aiet

Tables (5)

Log (Untitled4)

  • Field

user_checkin (Untitled2)

  • checkin_time (Field) — varchar(20) — Primary key
  • user_id (Key) — varchar(30) — Foreign key → user_enroll.user_id — NOT NULL
  • check_permission (Field2) — int()

user_enroll (enroll)

  • user_id (Key) — varchar(30) — Primary key — NOT NULL
  • user_name (Field) — varchar(30)
  • user_phone (Field2) — varchar(30)
  • user_enrolltime (Field3) — varchar(30)
  • user_landmark (Field4) — varchar(100)
  • user_vectorspace (Field5) — varchar( 100)
  • TOF (Field6) — int()
  • user_unknown_id (Field7)

user_verify (Untitled3)

  • checkin_time (Field3) — varchar(20) — Foreign key → user_checkin.checkin_time
  • user_id (Key) — varchar(30) — Foreign key → user_checkin.user_id — NOT NULL
  • user_landmark (Field) — varchar(100)
  • user_vectorspace (Field2) — varchar(100)
  • user_checkin_time (Field4) — varchar(20)

video (Untitled)

  • checkin_time (Field) — varchar(20) — Foreign key → user_checkin.checkin_time
  • user_id (Key2) — varchar(30) — Foreign key → user_checkin.user_id — NOT NULL
  • video_data (Field3)
  • video_name (Key) — varchar(30) — NOT NULL