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