MySQL Create Table SQL
Table Structure: okayapi_landi_plan_detail:/tablelist/okayapi_landi_plan_detail.html
-- MySQL Table okayapi_landi_plan_detail
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_plan_detail` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`plan_id` int(11) NULL COMMENT '',
`fac_id` int(11) NULL COMMENT '',
`total` int(11) NULL COMMENT '',
`already` int(11) NULL DEFAULT '0' COMMENT '',
`unitprice` double NULL COMMENT '',
`all_money` double NULL COMMENT '',
`provider` varchar(64) NULL COMMENT '供应商',
`invoice_type` varchar(20) NULL COMMENT '不含票 含普票 含增票',
`received` varchar(10) NULL COMMENT '是否收到(0否 1收到)',
`order_date` date NULL COMMENT '下单日期',
`arrival_date` date NULL COMMENT '到货日期',
`okayapi_landi_plan_detail_comment` varchar(64) NULL COMMENT '',
`sys_state` int(11) NULL DEFAULT '1' COMMENT '',
KEY `plan_id` (`plan_id`),
KEY `fac_id` (`fac_id`),
KEY `total` (`total`),
KEY `already` (`already`),
KEY `unitprice` (`unitprice`),
KEY `all_money` (`all_money`),
KEY `provider` (`provider`),
KEY `invoice_type` (`invoice_type`),
KEY `received` (`received`),
KEY `order_date` (`order_date`),
KEY `arrival_date` (`arrival_date`),
KEY `okayapi_landi_plan_detail_comment` (`okayapi_landi_plan_detail_comment`),
KEY `sys_state` (`sys_state`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'LD酒店租房管理-采购方案详情';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-13 of 13 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
plan_id | int(11) | 是 | Normal Index | |||
fac_id | int(11) | 是 | ||||
total | int(11) | 是 | ||||
already | int(11) | 0 | 是 | 0 | ||
unitprice | double | 是 | ||||
all_money | double | 是 | ||||
provider | varchar(64) | 是 | 供应商 | |||
invoice_type | varchar(20) | 是 | 不含票 含普票 含增票 | |||
received | varchar(10) | 是 | 是否收到(0否 1收到) | |||
order_date | date | 是 | 下单日期 | |||
arrival_date | date | 是 | 到货日期 | |||
okayapi_landi_plan_detail_comment | varchar(64) | 是 | ||||
sys_state | int(11) | 1 | 是 | 1 |