t5est
Tables (11)
business_list
- business_id — mediumint(20) — Primary key — NOT NULL
- business_name — varchar(100)
- start_date — date
- intersection_count — mediumint(10)
- detector_count — mediumint(10)
- active_status — char(1)
- creater — varchar(10)
- create_unixtime — bigint(20)
- updater — varchar(10)
- update_unixtime — bigint(20)
code
- code — varchar(10)
- code_name — varchar(10)
- code_type — varchar(10)
- create_unixtime — bigint(20)
- update_unixtime — bigint(20)
comment
- comment_id — bigint(20) — Primary key — NOT NULL
- issue_id — bigint(20) — Foreign key → issue.issue_id — NOT NULL
- comment_content — varchar(1000)
- creater — varchar(10)
- creater_unixtime — bigint(20)
- updater — varchar(10)
- update_unixtime — bigint(20)
detector_list
- detector_id — bigint(20) — Primary key — NOT NULL
- intersection_id — bigint(20) — Foreign key → intersection_list.intersection_id — NOT NULL
- business_id — mediumint(20) — Foreign key → intersection_list.business_id — NOT NULL
- detector_number — varchar(20)
- direction — varchar(10)
- direction_number — smallint(10)
- camr_2k_ip — int(11)
- edge_sys_2k_ip — int(11)
- camr_4k_ip — int(11)
- edge_sys_4k_ip — int(11)
- creater — varchar(10)
- create_unixtime — bigint(20)
- updater — varchar(10)
- update_unixtime — bigint(20)
- issue_count — int(10)
- x_issue_count — int(10)
file
- file_id — bigint(20) — Primary key — NOT NULL
- parent_id — bigint(20)
- issue_comment_type — varchar(10)
- original_file_name — varchar(70)
- location — varchar(70)
- file_name — varchar(70)
- extns — varchar(10)
- creater — varchar(10)
- create_unixtime — bigint(20)
- updater — varchar(10)
- update_unixtime — bigint(20)
intersection_list
- intersection_id — bigint(20) — Primary key — NOT NULL
- business_id — mediumint(20) — Foreign key → business_list.business_id — NOT NULL
- site_number — mediumint(10)
- intersection_number — varchar(20)
- intersection_name — varchar(30)
- box_type — varchar(10)
- cot — varchar(10)
- site_address — varchar(100)
- x_coordinate — decimal(18,10)
- y_coordinate — decimal(18,10)
- creater — varchar(10)
- create_unixtime — bigint(20)
- updater — varchar(10)
- update_unixtime — bigint(20)
issue
- issue_id — bigint(20) — Primary key — NOT NULL
- detector_id — bigint(20) — Foreign key → detector_list.detector_id — NOT NULL
- intersection_id — bigint(20) — Foreign key → detector_list.intersection_id — NOT NULL
- business_id — mediumint(20) — Foreign key → detector_list.business_id — NOT NULL
- issue_type — varchar(10)
- issue_content — varchar(1000)
- issue_level — int(1)
- issue_state — varchar(10)
- creater — varchar(10)
- create_unixtime — bigint(20)
- partner — varchar(10)
- updater — varchar(10)
- update_unixtime — bigint(20)
issue_history
- history_id — bigint(20) — Primary key — NOT NULL
- issue_id — bigint(20) — NOT NULL
- detector_id — bigint(20)
- intersection_id — bigint(20)
- business_id — mediumint(20)
- issue_type — varchar(10)
- issue_content — varchar(1000)
- issue_level — int(1)
- issue_state — varchar(10)
- creater — varchar(10)
- create_unixtime — bigint(20)
- partner — varchar(10)
- updater — varchar(10)
- update_unixtime — bigint(20)
log
- log_id — bigint(20) — Primary key — NOT NULL
- user_id — varchar(10)
- url — varchar(100)
- method — varchar(5)
- creater_unixtime — bigint(20)
user
- user_id — varchar(10) — Primary key — NOT NULL
- position — varchar(10)
- password — varchar(128)
- salt — varchar(16)
- username — varchar(10)
- department — varchar(50)
- role — varchar(10)
- creater — varchar(10)
- create_unixtime — bigint(20)
- updater — varchar(10)
- update_unixtime — bigint(20)
user_to_business_list
- id — bigint(20) — Primary key — NOT NULL
- business_id — mediumint(20) — Foreign key → business_list.business_id — NOT NULL
- user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
- creater — varchar(10)
- create_unixtime — bigint(20)
- updater — varchar(10)
- update_unixtime — bigint(20)