MySQL Create Table SQL
Table Structure: okayapi_landi_host:/tablelist/okayapi_landi_host.html
-- MySQL Table okayapi_landi_host
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_host` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`guest_id` int(10) NULL COMMENT '',
`host_name` varchar(64) NULL COMMENT '',
`rent_charge` double NULL COMMENT '',
`service_charge` double NULL COMMENT '',
`return_money` double NULL COMMENT '',
`other_charge` double NULL COMMENT '',
`sys_state` int(11) NULL DEFAULT '1' COMMENT '',
`host_type` varchar(64) NULL COMMENT 'spc或小业主',
`host_identity` varchar(64) NULL COMMENT '',
`host_account` varchar(64) NULL COMMENT '',
`tax_charge` double NULL COMMENT '',
`tenet_charge` double NULL COMMENT '物业管理费',
`heating_charge` double NULL COMMENT '',
`actual_charge` double NULL COMMENT '',
`spc_recover` varchar(255) NULL COMMENT '是否追缴物业费(追缴/不追缴)',
`heating_recover` varchar(255) NULL COMMENT '是否追缴采暖费(追缴/不追缴)',
`account_comment` varchar(255) NULL COMMENT '',
KEY `guest_id` (`guest_id`),
KEY `host_name` (`host_name`),
KEY `rent_charge` (`rent_charge`),
KEY `service_charge` (`service_charge`),
KEY `return_money` (`return_money`),
KEY `other_charge` (`other_charge`),
KEY `sys_state` (`sys_state`),
KEY `host_type` (`host_type`),
KEY `host_identity` (`host_identity`),
KEY `host_account` (`host_account`),
KEY `tax_charge` (`tax_charge`),
KEY `tenet_charge` (`tenet_charge`),
KEY `heating_charge` (`heating_charge`),
KEY `actual_charge` (`actual_charge`),
KEY `spc_recover` (`spc_recover`),
KEY `heating_recover` (`heating_recover`),
KEY `account_comment` (`account_comment`),
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-17 of 17 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
guest_id | int(10) | 是 | Normal Index | |||
host_name | varchar(64) | 是 | ||||
rent_charge | double | 是 | ||||
service_charge | double | 是 | ||||
return_money | double | 是 | ||||
other_charge | double | 是 | ||||
sys_state | int(11) | 1 | 是 | 1 | ||
host_type | varchar(64) | 是 | spc或小业主 | |||
host_identity | varchar(64) | 是 | ||||
host_account | varchar(64) | 是 | ||||
tax_charge | double | 是 | ||||
tenet_charge | double | 是 | 物业管理费 | |||
heating_charge | double | 是 | ||||
actual_charge | double | 是 | ||||
spc_recover | varchar(255) | 是 | 是否追缴物业费(追缴/不追缴) | |||
heating_recover | varchar(255) | 是 | 是否追缴采暖费(追缴/不追缴) | |||
account_comment | varchar(255) | 是 |