MySQL Create Table SQL
Table Structure: okayapi_landi_meal:/tablelist/okayapi_landi_meal.html
-- MySQL Table okayapi_landi_meal
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_meal` (
`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 '',
`restaurant_name` varchar(64) NULL COMMENT '',
`total_price` double NULL COMMENT '总消费费用',
`pay_mode` tinyint(3) NULL COMMENT '支付方式(现金0 月结1)',
`okayapi_landi_meal_comment` varchar(64) NULL COMMENT '',
`staff_id` int(11) NULL COMMENT '点餐人的id号',
`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 `restaurant_name` (`restaurant_name`),
KEY `total_price` (`total_price`),
KEY `pay_mode` (`pay_mode`),
KEY `okayapi_landi_meal_comment` (`okayapi_landi_meal_comment`),
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) | 是 | ||||
restaurant_name | varchar(64) | 是 | ||||
total_price | double | 是 | 总消费费用 | |||
pay_mode | tinyint(3) | 是 | 支付方式(现金0 月结1) | |||
okayapi_landi_meal_comment | varchar(64) | 是 | ||||
staff_id | int(11) | 是 | 点餐人的id号 | |||
staff_name | varchar(64) | 是 | ||||
occur_time | datetime | 是 | 发生时间(点餐时间) | |||
import_time | datetime | 是 | ||||
edit_time | datetime | 是 |