h_hotel
id: int
host_name: varchar(200) host_sex: varchar(200) hotel_name: varchar(500) hotel_imgs: varchar(200) img1: varchar(255)
img2: varchar(255)
img3: varchar(255)
img4: varchar(255) installations: varchar(400) location: varchar(500) country_id: int country_name: varchar(255) states_id: int
states_name: varchar(255) lng: decimal(20, 14)
lat: decimal(20, 14) book_num: int
price: decimal(20, 2) room_type: varchar(200) create_time: datetime create_user: varchar(200) upate_time: datetime update_user: varchar(200) status: smallint
sys_menu
sys_user
id: int
avatar: varchar(255) account: varchar(45) password: varchar(45) salt: varchar(45) name: varchar(45) birthday: datetime sex: int
email: varchar(45) phone: varchar(45) roleid: varchar(255) deptid: int
status: int createtime: datetime version: int
h_book_order
id: int
cust_id: int
cust_name: varchar(255) check_in: date
check_out: date
adults: varchar(200) order_no: varchar(200) hotel_id: int
hotel_name: varchar(500) hotel_img: varchar(200) hotel_location: varchar(200) order_amoun: decimal(20, 2) status: smallint create_time: datetime
h_cust
id: int
name: varchar(255) email: varchar(255) sex: varchar(200) birth: varchar(200) password: varchar(200) create_time: datetime amount: decimal(20, 2)
id: bigint id: int
id: int id: int
id: int
title: varchar(255) type: int
content: text createtime: datetime creater: int
sys_dept
sys_operation_log
sys_role
code: varchar(255) pcode: varchar(255) pcodes: varchar(255) name: varchar(255) icon: varchar(255) url: varchar(255) num: int
levels: int ismenu: int
tips: varchar(255) status: int isopen: int
h_feedback
dept_code: varchar(200) num: int
pid: int
pids: varchar(255) simplename: varchar(45) fullname: varchar(255) tips: varchar(255) version: int
status: smallint
sys_dict
logtype: varchar(255) logname: varchar(255) userid: int
classname: varchar(255) method: text createtime: datetime succeed: varchar(255) message: text
num: int
pid: int
name: varchar(255) deptid: int
role_code: varchar(200) tips: varchar(255) version: int
status: smallint
sys_expense sys_login_log
id: int id: int UNSIGNED id: int id: int id: int UNSIGNED
order_id: int hotel_id: int cust_id: int
score: double content: text create_time: datetime
jc_sys_provinces
id: int UNSIGNED country_id: int UNSIGNED title: varchar(255) code: varchar(10) en_title: varchar(255)
num: int
pid: int
name: varchar(255) tips: varchar(255) code: varchar(255) status: smallint
jc_sys_countries
id: int UNSIGNED title: varchar(255) code: varchar(10) en_title: varchar(255)
money: decimal(20, 2) desc: varchar(255) createtime: datetime state: int
userid: int
processId: varchar(255)
sys_countries
id: int
sortname: varchar(3) name: varchar(150) phonecode: int
logname: varchar(255) userid: int createtime: datetime succeed: varchar(255) message: text
ip: varchar(255)
sys_relation
country_id: int UNSIGNED province_id: int UNSIGNED title: varchar(255)
code: varchar(10) en_title: varchar(255)
sys_states
id: int id: int
menuid: bigint roleid: int
name: varchar(30) country_id: int
sys_notice
jc_sys_cities