+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
guest_idint(10)Normal Index
host_namevarchar(64)
rent_chargedouble
service_chargedouble
return_moneydouble
other_chargedouble
sys_stateint(11)11
host_typevarchar(64)spc或小业主
host_identityvarchar(64)
host_accountvarchar(64)
tax_chargedouble
tenet_chargedouble物业管理费
heating_chargedouble
actual_chargedouble
spc_recovervarchar(255)是否追缴物业费(追缴/不追缴)
heating_recovervarchar(255)是否追缴采暖费(追缴/不追缴)
account_commentvarchar(255)

Guess You Like

MySQL Table Design okayapi_landi_agent_purchase

MySQL Table Design okayapi_landi_contract_income

MySQL Table Design okayapi_landi_cost_le

MySQL Table Design okayapi_landi_daily_service

MySQL Table Design okayapi_landi_diary_reminder

MySQL Table Design okayapi_landi_drinking_water

MySQL Table Design okayapi_landi_emergency_problem

MySQL Table Design okayapi_landi_fac_sta

MySQL Table Design okayapi_landi_flight_picking

MySQL Table Design okayapi_landi_grocery_item

MySQL Table Design okayapi_landi_grocery_running

MySQL Table Design okayapi_landi_guest

MySQL Table Design okayapi_landi_guest_balance

MySQL Table Design okayapi_landi_guest_service

MySQL Table Design okayapi_landi_income

MySQL Table Design okayapi_landi_intern

MySQL Table Design okayapi_landi_invoice

MySQL Table Design okayapi_landi_invoice_detail

MySQL Table Design okayapi_landi_laundry

MySQL Table Design okayapi_landi_mail_reminder

TOP ↑