MySQL Create Table SQL
Table Structure: okayapi_landi_agent_purchase:/tablelist/okayapi_landi_agent_purchase.html
-- MySQL Table okayapi_landi_agent_purchase
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_agent_purchase` (
`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 '',
`good_name` varchar(64) NULL COMMENT '代购物品名称',
`count` int(11) NULL COMMENT '',
`cover_price` double NULL COMMENT '垫付费',
`service_price` double NULL COMMENT '服务费',
`pay_mode` tinyint(3) NULL COMMENT '支付方式(现金0 月结1)',
`okayapi_landi_agent_purchase_comment` varchar(64) NULL COMMENT '',
`staff_id` int(11) NULL COMMENT '垫付人id(就是一个员工staff)',
`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 `good_name` (`good_name`),
KEY `count` (`count`),
KEY `cover_price` (`cover_price`),
KEY `service_price` (`service_price`),
KEY `pay_mode` (`pay_mode`),
KEY `okayapi_landi_agent_purchase_comment` (`okayapi_landi_agent_purchase_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-14 of 14 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) | 是 | ||||
good_name | varchar(64) | 是 | 代购物品名称 | |||
count | int(11) | 是 | ||||
cover_price | double | 是 | 垫付费 | |||
service_price | double | 是 | 服务费 | |||
pay_mode | tinyint(3) | 是 | 支付方式(现金0 月结1) | |||
okayapi_landi_agent_purchase_comment | varchar(64) | 是 | ||||
staff_id | int(11) | 是 | 垫付人id(就是一个员工staff) | |||
staff_name | varchar(64) | 是 | ||||
occur_time | datetime | 是 | ||||
import_time | datetime | 是 | ||||
edit_time | datetime | 是 |