bus_share
Tables (8)
Creator (Untitled4)
- id (Key) — INT(11) — Primary key — NOT NULL
- creatorType (Field) — VARCHAR(100)
- corporateName (Field2) — VARCHAR(100)
- corporateCode (Field3) — VARCHAR(100)
- sectionName (Field4) — VARCHAR(100)
- sctionCode (Field5) — VARCHAR(100)
- personName (Field6) — VARCHAR(100)
- personCode (Field7) — VARCHAR(100)
- positionName (Field8) — VARCHAR(100)
- positionCode (Field9) — VARCHAR(100)
join_form (User_info)
- num (Key) — INT(11) — Primary key — NOT NULL
- sc_name (Field) — VARCHAR(255)
- name (Field2) — VARCHAR(255)
- phone (Field3) — VARCHAR(20)
- email (Field4) — VARCHAR(100)
- region (Field5) — VARCHAR(255)
- consult_content (Field6) — VARCHAR(1000)
- sc_role (Field7) — VARCHAR(20)
- apply_yn (Field8) — CAHR(1)
record (Untitled5)
- recordId (Key) — INT(11) — Primary key — NOT NULL
- aggregationLevel (Field)
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
recordIdentifier (Untitled6)
- recordId (Key) — INT(11) — Foreign key → record.recordId — NOT NULL
- recordType (Field)
- recordValue (Field2)
route_info (Untitled)
- route_num (Key2) — INT(11) — Primary key — NOT NULL
- num (Key) — INT(11) — Foreign key → join_form.num — NOT NULL
- seat (Field) — INT(11)
- start_time (Field2) — VARCHAR(100)
- stopover1 (Field3) — VARCHAR(50)
- stopover2 (Field4) — VARCHAR(50)
- stopover3 (Field5) — VARCHAR(50)
- stopover4 (Field6) — VARCHAR(50)
- stopover5 (Field7) — VARCHAR(50)
- stopover6 (Field8) — VARCHAR(50)
- stopover7 (Field9) — VARCHAR(50)
- stopover8 (Field10) — VARCHAR(50)
- stopover9 (Field11) — VARCHAR(50)
- stopover10 (Field12) — VARCHAR(50)
stopover_info (Untitled3)
- route_num (Key2) — INT(11) — Foreign key → route_info.route_num — NOT NULL
- num (Key) — INT(11) — Foreign key → student_info.num — NOT NULL
- stopover_num (Filed1) — INT(11)
- st_name (Field2) — VARCHAR(100)
- up/down (Field3) — CHAR(1)
student_info (Untitled2)
- num (Key) — INT(11) — Foreign key → join_form.num — NOT NULL
- st_name (Field) — VARCHAR(100)
- st_phone (Field2) — VARCHAR(100)
- use_day (Field3) — VARCHAER(100)
- etc (Field4) — VARCHAR(100)
user_info (CopyOfUser_info)
- num (Key2) — INT(11) — Foreign key → join_form.num — NOT NULL
- id (Field) — VARCHAR(255)
- pwd (Field2) — VARCHAR(255)
- match_info (Field3) — VARCHAR(255)
- sc_level (Field4) — INT(11)
- bus_level (Field5) — INT(11)
- create_date (Field6) — DATETIME