-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcreateTable.sql
More file actions
17 lines (17 loc) · 9.91 KB
/
Copy pathcreateTable.sql
File metadata and controls
17 lines (17 loc) · 9.91 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
CREATE TABLE t_pass_data ( record_id int(11) NOT NULL , code varchar(20) NULL , card varchar(20) NULL , name varchar(20) NULL , area varchar(20) NULL , snap_time datetime NULL , direction int(11) NULL , pass_type varchar(45) NULL , owner_id bigint(20) NOT NULL ,PRIMARY KEY (record_id) )
CREATE TABLE t_staff_info ( staff_id bigint(20) NOT NULL , staff_name varchar(64) NOT NULL , staff_phone varchar(64) NOT NULL , create_time datetime NOT NULL , update_time datetime NOT NULL , com_id bigint(20) NOT NULL , audit_flag int(3) NOT NULL , create_by varchar(64) NOT NULL , update_by varchar(64) NULL , del_flag int(1) NULL , post_name varchar(50) NULL , sig_cust_id bigint(20) NULL , birthday datetime NULL , certi_nbr varchar(50) NULL , certi_type int(11) NULL , cust_code varchar(50) NULL , gender int(11) NULL , staff_status int(11) NOT NULL ,PRIMARY KEY (com_id) )
CREATE TABLE t_invite ( invite_id bigint(20) NOT NULL , inviter_name varchar(64) NOT NULL , inviter_phone varchar(64) NOT NULL , inviter_pic varchar(64) NULL , inviter_id_pic varchar(64) NULL , visit_com_name varchar(64) NOT NULL , visit_com_id bigint(20) NULL , visit_man_name varchar(64) NOT NULL , visit_man_phone varchar(64) NOT NULL , visit_time datetime NOT NULL , visit_addr varchar(64) NULL , visit_reason int(3) NULL , create_time datetime NOT NULL , update_time datetime NULL , invite_status int(3) NOT NULL , create_by varchar(64) NULL , create_name varchar(64) NULL , instance_id varchar(36) NULL , invite_type int(3) NOT NULL , delete_flag int(1) NULL , inviter_idno varchar(64) NULL , inviter_idtype int(3) NULL , business_key varchar(36) NOT NULL , building_id bigint(20) NULL , area_code varchar(10) NULL , validate_start datetime NULL ,PRIMARY KEY (business_key) )
CREATE TABLE t_com_info ( com_id bigint(20) NOT NULL , com_name varchar(64) NOT NULL , com_type int(3) NOT NULL , level int(1) NOT NULL , del_flag int(1) NULL , create_time datetime NOT NULL , update_time datetime NULL , update_by varchar(64) NULL , create_by varchar(64) NOT NULL , cust_code varchar(50) NULL , credit_code varchar(50) NULL , company_address varchar(50) NULL , email varchar(50) NULL , establish_date datetime NULL , company_legal varchar(10) NULL , listed_comp_code varchar(10) NULL , listing_type varchar(10) NULL , regist_authority varchar(50) NULL , regist_number varchar(50) NULL , registered_capital varchar(50) NULL , taxpayer_code varchar(50) NULL , taxpayer_id varchar(50) NULL , website varchar(50) NULL , annual_output varchar(50) NULL , annual_tax varchar(50) NULL , employees_num varchar(50) NULL , end_time datetime NULL , open_time datetime NULL , operation_scope varchar(50) NULL , patents_number varchar(50) NULL , approval_date datetime NULL , com_status int(3) NULL , industry varchar(50) NULL , registered_addr varchar(50) NULL ,PRIMARY KEY (com_id) )
CREATE TABLE sys_user ( user_id bigint(20) NOT NULL , dept_id bigint(20) NULL , user_name varchar(30) NOT NULL , nick_name varchar(30) NULL , user_type varchar(2) NULL , email varchar(50) NULL , phonenumber varchar(11) NULL , sex char(1) NULL , avatar varchar(256) NULL , password varchar(100) NULL , status char(1) NULL , del_flag char(1) NULL , login_ip varchar(50) NULL , login_date datetime NULL , create_by varchar(64) NULL , create_time datetime NULL , update_by varchar(64) NULL , update_time datetime NULL , remark varchar(500) NULL , staff_id bigint(20) NULL , salt varchar(16) NULL ,PRIMARY KEY (user_id) )
CREATE TABLE t_repair_event ( event_id bigint(20) NOT NULL , event_type int(3) NULL , event_name varchar(10) NULL , event_time datetime NULL , event_user_id varchar(64) NULL , event_euser_id varchar(64) NULL , event_user_name varchar(64) NULL , target_user_id varchar(64) NULL , target_euser_id varchar(64) NULL , target_user_name varchar(64) NULL , track_id bigint(20) NOT NULL , plan_relieve_time datetime NULL , remark varchar(64) NULL , hang_status int(11) NULL , fact_relieve_hang datetime NULL , review_advise varchar(64) NULL , comment_type int(11) NULL , photo varchar(128) NULL , sup_flag varchar(20) NULL , create_time varchar(45) NOT NULL ,PRIMARY KEY (event_id) )
CREATE TABLE t_repair_track ( track_id bigint(20) NOT NULL , track_name varchar(64) NULL , status_name varchar(64) NULL , track_code varchar(64) NULL , status int(3) NOT NULL , order_id bigint(20) NOT NULL , track_desc varchar(128) NULL , current_user_id varchar(64) NULL , current_euser_id varchar(64) NULL , current_user_name varchar(64) NULL , current_user_type int(11) NULL , current_user_tel varchar(20) NULL , review_result varchar(1) NULL , create_time datetime NOT NULL , create_by varchar(64) NOT NULL , update_time datetime NULL , update_by varchar(64) NULL , version bigint(20) NOT NULL , sige_track_id bigint(20) NOT NULL , sige_order_id varchar(20) NOT NULL ,PRIMARY KEY (track_id) )
CREATE TABLE t_repair_track_detail ( deal_advise varchar(1024) NULL , deal_photos varchar(1024) NULL , deal_sign_photos varchar(1024) NULL )
CREATE TABLE t_repairs_order ( order_id bigint(20) NOT NULL , order_no varchar(32) NOT NULL , order_type int(3) NOT NULL , addr varchar(128) NOT NULL , desc varchar(500) NOT NULL , connect varchar(20) NOT NULL , connector varchar(64) NOT NULL , level int(3) NOT NULL , building_id bigint(20) NOT NULL , create_time datetime NOT NULL , create_by varchar(64) NOT NULL , source_type int(3) NOT NULL , voice_file bigint(20) NULL , order_time datetime NOT NULL , order_status varchar(2) NULL , version bigint(20) NOT NULL , com_id bigint(20) NULL , sige_order_id varchar(20) NULL , order_create_name varchar(64) NULL , sige_transport_user_id varchar(64) NULL , sige_transport_euser_id varchar(64) NULL , del_flag int(1) NOT NULL , outtime_status int(1) NOT NULL ,PRIMARY KEY (order_id) )
CREATE TABLE t_evaluate ( evaluate_level int(1) NOT NULL , desc varchar(256) NULL , create_time datetime NOT NULL , create_by varchar(64) NOT NULL )
CREATE TABLE t_buliding ( building_id int(11) NOT NULL , building_name varchar(64) NULL , building_type int(3) NOT NULL , building_code varchar(20) NOT NULL , create_time varchar(45) NULL , create_by varchar(64) NOT NULL , update_time varchar(45) NULL , update_by varchar(64) NULL , delete_flag int(1) NULL , source_type int(1) NOT NULL , build_floor int(11) NOT NULL , build_status int(1) NOT NULL , sig_build_id bigint(20) NULL , sig_organ_id bigint(20) NULL ,PRIMARY KEY (building_code) )
CREATE TABLE t_project ( proj_id bigint(20) NOT NULL , sig_organ_id bigint(20) NULL , organ_name varchar(64) NULL , organ_py varchar(100) NULL , organ_status int(11) NULL , charge_type int(11) NULL , organ_code varchar(10) NULL , organ_address varchar(100) NULL , organ_region varchar(1) NULL , complete_date datetime NULL , checkin_date datetime NULL , build_area varchar(10) NULL , total_area varchar(10) NULL , province int(11) NULL , city int(11) NULL , region int(11) NULL , street int(11) NULL , description varchar(100) NULL , plot_ratio varchar(10) NULL , green_ratio varchar(10) NULL , create_time datetime NOT NULL , create_by varchar(32) NOT NULL , update_time datetime NULL , update_by varchar(32) NULL , del_flag int(1) NOT NULL ,PRIMARY KEY (proj_id) )
CREATE TABLE t_unit ( unit_id bigint(20) NOT NULL , sig_unit_id bigint(20) NOT NULL , unit_name varchar(45) NULL , unit_status varchar(45) NULL , unit_code varchar(45) NULL , sig_build_id bigint(20) NULL , sig_organ_id bigint(20) NULL , create_time datetime NOT NULL , create_by varchar(45) NOT NULL , update_time datetime NULL , update_by varchar(45) NULL , del_flag int(1) NOT NULL , source_type int(1) NOT NULL , proj_id bigint(20) NULL ,PRIMARY KEY (unit_id) )
CREATE TABLE t_floor ( floor_id bigint(20) NOT NULL , sig_floor_id bigint(20) NULL , floor_name varchar(45) NULL , floor_status varchar(45) NULL , floor_code varchar(45) NULL , floor_index varchar(45) NULL , build_area varchar(10) NULL , bill_area varchar(10) NULL , use_area varchar(10) NULL , describe varchar(10) NULL , sig_unit_id bigint(20) NULL , sig_build_id bigint(20) NULL , sig_organ_id bigint(20) NULL , create_time datetime NOT NULL , create_by varchar(45) NOT NULL , update_time datetime NULL , update_by varchar(45) NULL , del_flag int(1) NOT NULL , source_type int(1) NOT NULL , unit_id bigint(20) NULL , building_id bigint(20) NULL ,PRIMARY KEY (floor_id) )
CREATE TABLE t_house ( house_id bigint(20) NOT NULL , sig_house_id bigint(20) NOT NULL , house_name varchar(64) NOT NULL , house_status int(11) NOT NULL , house_code varchar(10) NOT NULL , house_no varchar(10) NOT NULL , house_type int(11) NOT NULL , use_area varchar(10) NULL , garden_area varchar(10) NULL , share_area varchar(10) NULL , build_area varchar(10) NULL , bill_area varchar(10) NULL , sig_floor_id bigint(20) NOT NULL , sig_unit_id bigint(20) NOT NULL , sig_build_id bigint(20) NOT NULL , sig_organ_id bigint(20) NOT NULL , create_time datetime NOT NULL , create_by varchar(45) NOT NULL , update_time datetime NULL , update_by varchar(45) NULL , del_flag int(1) NOT NULL , source_type int(1) NOT NULL , floor_id bigint(20) NULL , unit_id bigint(20) NULL , building_id bigint(20) NULL , proj_id bigint(20) NULL , resource_type int(11) NULL ,PRIMARY KEY (house_id) )
CREATE TABLE sys_dept ( dept_id bigint(20) NOT NULL , parent_id bigint(20) NULL , ancestors varchar(50) NULL , dept_name varchar(30) NULL , order_num int(4) NULL , leader varchar(20) NULL , phone varchar(11) NULL , email varchar(50) NULL , status char(1) NULL , del_flag char(1) NULL , create_by varchar(64) NULL , create_time datetime NULL , update_by varchar(64) NULL , update_time datetime NULL ,PRIMARY KEY (dept_id) )
CREATE TABLE t_com_res ( res_id bigint(20) NOT NULL , sig_rel_type varchar(10) NOT NULL , sig_obj_id varchar(50) NOT NULL , resource_name varchar(50) NULL , sig_community_id varchar(50) NULL , sig_cust_id varchar(50) NULL , sig_up_cust_id varchar(50) NULL , cust_type varchar(4) NULL , cust_status varchar(4) NULL , decorate_time datetime NULL , eff_time datetime NULL , exp_time datetime NULL , in_time datetime NULL , join_time datetime NULL , out_time datetime NULL , com_id bigint(20) NULL , space_id bigint(20) NULL ,PRIMARY KEY (res_id) )