MySQL Create Table SQL
Table Structure: okayapi_landi_income:/tablelist/okayapi_landi_income.html
-- MySQL Table okayapi_landi_income
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_income` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`room_number` varchar(64) NULL COMMENT '',
`guest_id` int(11) NULL COMMENT '',
`guest_name` varchar(64) NULL COMMENT '',
`okayapi_landi_income_time` datetime NULL COMMENT '',
`contract_receive` double NULL DEFAULT '0' COMMENT '',
`contaact_pay` double NULL DEFAULT '0' COMMENT '',
`benifit` double NULL DEFAULT '0' COMMENT '',
`okayapi_landi_income_source` double NULL DEFAULT '0' COMMENT '',
`daily_service` double NULL DEFAULT '0' COMMENT '',
`maintain` double NULL DEFAULT '0' COMMENT '',
`shuttle_bus` double NULL DEFAULT '0' COMMENT '',
`laundry` double NULL DEFAULT '0' COMMENT '',
`sys_state` int(11) NULL DEFAULT '1' COMMENT '',
KEY `room_number` (`room_number`),
KEY `guest_id` (`guest_id`),
KEY `guest_name` (`guest_name`),
KEY `okayapi_landi_income_time` (`okayapi_landi_income_time`),
KEY `contract_receive` (`contract_receive`),
KEY `contaact_pay` (`contaact_pay`),
KEY `benifit` (`benifit`),
KEY `okayapi_landi_income_source` (`okayapi_landi_income_source`),
KEY `daily_service` (`daily_service`),
KEY `maintain` (`maintain`),
KEY `shuttle_bus` (`shuttle_bus`),
KEY `laundry` (`laundry`),
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 |
---|---|---|---|---|---|---|
room_number | varchar(64) | 是 | Normal Index | |||
guest_id | int(11) | 是 | ||||
guest_name | varchar(64) | 是 | ||||
okayapi_landi_income_time | datetime | 是 | ||||
contract_receive | double | 0 | 是 | 0 | ||
contaact_pay | double | 0 | 是 | 0 | ||
benifit | double | 0 | 是 | 0 | ||
okayapi_landi_income_source | double | 0 | 是 | 0 | ||
daily_service | double | 0 | 是 | 0 | ||
maintain | double | 0 | 是 | 0 | ||
shuttle_bus | double | 0 | 是 | 0 | ||
laundry | double | 0 | 是 | 0 | ||
sys_state | int(11) | 1 | 是 | 1 |