MySQL Create Table SQL
Table Structure: okayapi_landi_fac_sta:/tablelist/okayapi_landi_fac_sta.html
-- MySQL Table okayapi_landi_fac_sta
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_fac_sta` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_landi_fac_sta_type` varchar(64) NULL COMMENT '',
`cat` varchar(64) NULL COMMENT '',
`brand` varchar(64) NULL COMMENT '',
`okayapi_landi_fac_sta_name` varchar(64) NULL COMMENT '',
`okayapi_landi_fac_sta_owner` varchar(64) NULL COMMENT '归属权',
`repo_id` int(11) NULL COMMENT '',
`repo_num` varchar(64) NULL COMMENT '库房号码',
`total` int(11) NULL COMMENT '',
`free` int(11) NULL COMMENT '待分配',
`working` int(11) NULL COMMENT '可用',
`maintain` int(11) NULL COMMENT '维修',
`bad` int(11) NULL COMMENT '报废',
`okayapi_landi_fac_sta_comment` varchar(64) NULL COMMENT '',
KEY `okayapi_landi_fac_sta_type` (`okayapi_landi_fac_sta_type`),
KEY `cat` (`cat`),
KEY `brand` (`brand`),
KEY `okayapi_landi_fac_sta_name` (`okayapi_landi_fac_sta_name`),
KEY `okayapi_landi_fac_sta_owner` (`okayapi_landi_fac_sta_owner`),
KEY `repo_id` (`repo_id`),
KEY `repo_num` (`repo_num`),
KEY `total` (`total`),
KEY `free` (`free`),
KEY `working` (`working`),
KEY `maintain` (`maintain`),
KEY `bad` (`bad`),
KEY `okayapi_landi_fac_sta_comment` (`okayapi_landi_fac_sta_comment`),
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 |
---|---|---|---|---|---|---|
okayapi_landi_fac_sta_type | varchar(64) | 是 | ||||
cat | varchar(64) | 是 | ||||
brand | varchar(64) | 是 | ||||
okayapi_landi_fac_sta_name | varchar(64) | 是 | ||||
okayapi_landi_fac_sta_owner | varchar(64) | 是 | 归属权 | |||
repo_id | int(11) | 是 | ||||
repo_num | varchar(64) | 是 | 库房号码 | |||
total | int(11) | 是 | ||||
free | int(11) | 是 | 待分配 | |||
working | int(11) | 是 | 可用 | |||
maintain | int(11) | 是 | 维修 | |||
bad | int(11) | 是 | 报废 | |||
okayapi_landi_fac_sta_comment | varchar(64) | 是 |