MySQL Create Table SQL
Table Structure: okayapi_landi_shuttle_bus:/tablelist/okayapi_landi_shuttle_bus.html
-- MySQL Table okayapi_landi_shuttle_bus
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_shuttle_bus` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`eighteenth` int(11) NULL DEFAULT '0' COMMENT '',
`nineteenth` int(11) NULL DEFAULT '0' COMMENT '',
`twentieth` int(11) NULL DEFAULT '0' COMMENT '',
`twenty_first` int(11) NULL DEFAULT '0' COMMENT '',
`twenty_second` int(11) NULL DEFAULT '0' COMMENT '',
`twenty_third` int(11) NULL DEFAULT '0' COMMENT '',
`twenty_fourth` int(11) NULL DEFAULT '0' COMMENT '',
`twenty_fifth` int(11) NULL DEFAULT '0' COMMENT '',
`twenty_sixth` int(11) NULL DEFAULT '0' COMMENT '',
`twenty_seventh` int(11) NULL DEFAULT '0' COMMENT '',
`twenty_eighth` int(11) NULL DEFAULT '0' COMMENT '',
`twenty_ninth` int(11) NULL DEFAULT '0' COMMENT '',
`thirtieth` int(11) NULL DEFAULT '0' COMMENT '',
`thirty_first` int(11) NULL DEFAULT '0' COMMENT '',
`days` int(11) NULL DEFAULT '0' COMMENT '',
`total` int(11) NULL DEFAULT '0' COMMENT '',
`occur_time` datetime NULL COMMENT '',
`import_time` datetime NULL COMMENT '',
`edit_time` datetime NULL COMMENT '',
`okayapi_landi_shuttle_bus_year` int(11) NULL COMMENT '',
`okayapi_landi_shuttle_bus_month` int(11) NULL COMMENT '',
`room_num` varchar(64) NULL COMMENT '',
`guest_id` int(11) NULL COMMENT '',
`guest_name` varchar(64) NULL COMMENT '',
`other_people` varchar(100) NULL COMMENT '',
`okayapi_landi_shuttle_bus_first` int(11) NULL DEFAULT '0' COMMENT '',
`okayapi_landi_shuttle_bus_second` int(11) NULL DEFAULT '0' COMMENT '',
`third` int(11) NULL DEFAULT '0' COMMENT '',
`fourth` int(11) NULL DEFAULT '0' COMMENT '',
`fifth` int(11) NULL DEFAULT '0' COMMENT '',
`sixth` int(11) NULL DEFAULT '0' COMMENT '',
`seventh` int(11) NULL DEFAULT '0' COMMENT '',
`eighth` int(11) NULL DEFAULT '0' COMMENT '',
`ninth` int(11) NULL DEFAULT '0' COMMENT '',
`tenth` int(11) NULL DEFAULT '0' COMMENT '',
`eleventh` int(11) NULL DEFAULT '0' COMMENT '',
`twelfth` int(11) NULL DEFAULT '0' COMMENT '',
`thirteenth` int(11) NULL DEFAULT '0' COMMENT '',
`fourteenth` int(11) NULL DEFAULT '0' COMMENT '',
`fifteenth` int(11) NULL DEFAULT '0' COMMENT '',
`sixteenth` int(11) NULL DEFAULT '0' COMMENT '',
`seventeenth` int(11) NULL DEFAULT '0' COMMENT '',
KEY `eighteenth` (`eighteenth`),
KEY `nineteenth` (`nineteenth`),
KEY `twentieth` (`twentieth`),
KEY `twenty_first` (`twenty_first`),
KEY `twenty_second` (`twenty_second`),
KEY `twenty_third` (`twenty_third`),
KEY `twenty_fourth` (`twenty_fourth`),
KEY `twenty_fifth` (`twenty_fifth`),
KEY `twenty_sixth` (`twenty_sixth`),
KEY `twenty_seventh` (`twenty_seventh`),
KEY `twenty_eighth` (`twenty_eighth`),
KEY `twenty_ninth` (`twenty_ninth`),
KEY `thirtieth` (`thirtieth`),
KEY `thirty_first` (`thirty_first`),
KEY `days` (`days`),
KEY `total` (`total`),
KEY `occur_time` (`occur_time`),
KEY `import_time` (`import_time`),
KEY `edit_time` (`edit_time`),
KEY `okayapi_landi_shuttle_bus_year` (`okayapi_landi_shuttle_bus_year`),
KEY `okayapi_landi_shuttle_bus_month` (`okayapi_landi_shuttle_bus_month`),
KEY `room_num` (`room_num`),
KEY `guest_id` (`guest_id`),
KEY `guest_name` (`guest_name`),
KEY `other_people` (`other_people`),
KEY `okayapi_landi_shuttle_bus_first` (`okayapi_landi_shuttle_bus_first`),
KEY `okayapi_landi_shuttle_bus_second` (`okayapi_landi_shuttle_bus_second`),
KEY `third` (`third`),
KEY `fourth` (`fourth`),
KEY `fifth` (`fifth`),
KEY `sixth` (`sixth`),
KEY `seventh` (`seventh`),
KEY `eighth` (`eighth`),
KEY `ninth` (`ninth`),
KEY `tenth` (`tenth`),
KEY `eleventh` (`eleventh`),
KEY `twelfth` (`twelfth`),
KEY `thirteenth` (`thirteenth`),
KEY `fourteenth` (`fourteenth`),
KEY `fifteenth` (`fifteenth`),
KEY `sixteenth` (`sixteenth`),
KEY `seventeenth` (`seventeenth`),
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-42 of 42 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
eighteenth | int(11) | 0 | 是 | 0 | ||
nineteenth | int(11) | 0 | 是 | 0 | ||
twentieth | int(11) | 0 | 是 | 0 | ||
twenty_first | int(11) | 0 | 是 | 0 | ||
twenty_second | int(11) | 0 | 是 | 0 | ||
twenty_third | int(11) | 0 | 是 | 0 | ||
twenty_fourth | int(11) | 0 | 是 | 0 | ||
twenty_fifth | int(11) | 0 | 是 | 0 | ||
twenty_sixth | int(11) | 0 | 是 | 0 | ||
twenty_seventh | int(11) | 0 | 是 | 0 | ||
twenty_eighth | int(11) | 0 | 是 | 0 | ||
twenty_ninth | int(11) | 0 | 是 | 0 | ||
thirtieth | int(11) | 0 | 是 | 0 | ||
thirty_first | int(11) | 0 | 是 | 0 | ||
days | int(11) | 0 | 是 | 0 | ||
total | int(11) | 0 | 是 | 0 | ||
occur_time | datetime | 是 | ||||
import_time | datetime | 是 | ||||
edit_time | datetime | 是 | ||||
okayapi_landi_shuttle_bus_year | int(11) | 是 | Normal Index | |||
okayapi_landi_shuttle_bus_month | int(11) | 是 | ||||
room_num | varchar(64) | 是 | Normal Index | |||
guest_id | int(11) | 是 | ||||
guest_name | varchar(64) | 是 | ||||
other_people | varchar(100) | 是 | ||||
okayapi_landi_shuttle_bus_first | int(11) | 0 | 是 | 0 | ||
okayapi_landi_shuttle_bus_second | int(11) | 0 | 是 | 0 | ||
third | int(11) | 0 | 是 | 0 | ||
fourth | int(11) | 0 | 是 | 0 | ||
fifth | int(11) | 0 | 是 | 0 | ||
sixth | int(11) | 0 | 是 | 0 | ||
seventh | int(11) | 0 | 是 | 0 | ||
eighth | int(11) | 0 | 是 | 0 | ||
ninth | int(11) | 0 | 是 | 0 | ||
tenth | int(11) | 0 | 是 | 0 | ||
eleventh | int(11) | 0 | 是 | 0 | ||
twelfth | int(11) | 0 | 是 | 0 | ||
thirteenth | int(11) | 0 | 是 | 0 | ||
fourteenth | int(11) | 0 | 是 | 0 | ||
fifteenth | int(11) | 0 | 是 | 0 | ||
sixteenth | int(11) | 0 | 是 | 0 | ||
seventeenth | int(11) | 0 | 是 | 0 |