+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
eighteenthint(11)00
nineteenthint(11)00
twentiethint(11)00
twenty_firstint(11)00
twenty_secondint(11)00
twenty_thirdint(11)00
twenty_fourthint(11)00
twenty_fifthint(11)00
twenty_sixthint(11)00
twenty_seventhint(11)00
twenty_eighthint(11)00
twenty_ninthint(11)00
thirtiethint(11)00
thirty_firstint(11)00
daysint(11)00
totalint(11)00
occur_timedatetime
import_timedatetime
edit_timedatetime
okayapi_landi_shuttle_bus_yearint(11)Normal Index
okayapi_landi_shuttle_bus_monthint(11)
room_numvarchar(64)Normal Index
guest_idint(11)
guest_namevarchar(64)
other_peoplevarchar(100)
okayapi_landi_shuttle_bus_firstint(11)00
okayapi_landi_shuttle_bus_secondint(11)00
thirdint(11)00
fourthint(11)00
fifthint(11)00
sixthint(11)00
seventhint(11)00
eighthint(11)00
ninthint(11)00
tenthint(11)00
eleventhint(11)00
twelfthint(11)00
thirteenthint(11)00
fourteenthint(11)00
fifteenthint(11)00
sixteenthint(11)00
seventeenthint(11)00

Guess You Like

MySQL Table Design okayapi_landi_agent_purchase

MySQL Table Design okayapi_landi_contract_income

MySQL Table Design okayapi_landi_cost_le

MySQL Table Design okayapi_landi_daily_service

MySQL Table Design okayapi_landi_diary_reminder

MySQL Table Design okayapi_landi_drinking_water

MySQL Table Design okayapi_landi_emergency_problem

MySQL Table Design okayapi_landi_fac_sta

MySQL Table Design okayapi_landi_flight_picking

MySQL Table Design okayapi_landi_grocery_item

MySQL Table Design okayapi_landi_grocery_running

MySQL Table Design okayapi_landi_guest

MySQL Table Design okayapi_landi_guest_balance

MySQL Table Design okayapi_landi_guest_service

MySQL Table Design okayapi_landi_host

MySQL Table Design okayapi_landi_income

MySQL Table Design okayapi_landi_intern

MySQL Table Design okayapi_landi_invoice

MySQL Table Design okayapi_landi_invoice_detail

MySQL Table Design okayapi_landi_laundry

TOP ↑