MySQL Create Table SQL
Table Structure: okayapi_landi_other_fare:/tablelist/okayapi_landi_other_fare.html
-- MySQL Table okayapi_landi_other_fare
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_other_fare` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`room_num` varchar(64) NULL COMMENT '',
`guest_id` int(11) NULL COMMENT '',
`guest_name` varchar(64) NULL COMMENT '',
`usage_type` varchar(64) NULL COMMENT '',
`pay_mode` tinyint(3) NULL COMMENT '',
`okayapi_landi_other_fare_comment` varchar(64) NULL COMMENT '',
`total_price` double NULL COMMENT '',
`staff_id` int(11) NULL COMMENT '',
`staff_name` varchar(64) NULL COMMENT '',
`occur_time` datetime NULL COMMENT '',
`import_time` datetime NULL COMMENT '',
`edit_time` datetime NULL COMMENT '',
KEY `room_num` (`room_num`),
KEY `guest_id` (`guest_id`),
KEY `guest_name` (`guest_name`),
KEY `usage_type` (`usage_type`),
KEY `pay_mode` (`pay_mode`),
KEY `okayapi_landi_other_fare_comment` (`okayapi_landi_other_fare_comment`),
KEY `total_price` (`total_price`),
KEY `staff_id` (`staff_id`),
KEY `staff_name` (`staff_name`),
KEY `occur_time` (`occur_time`),
KEY `import_time` (`import_time`),
KEY `edit_time` (`edit_time`),
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-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
room_num | varchar(64) | 是 | ||||
guest_id | int(11) | 是 | ||||
guest_name | varchar(64) | 是 | ||||
usage_type | varchar(64) | 是 | ||||
pay_mode | tinyint(3) | 是 | ||||
okayapi_landi_other_fare_comment | varchar(64) | 是 | ||||
total_price | double | 是 | ||||
staff_id | int(11) | 是 | ||||
staff_name | varchar(64) | 是 | ||||
occur_time | datetime | 是 | ||||
import_time | datetime | 是 | ||||
edit_time | datetime | 是 |