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)