01.20

Tables (5)

User (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • name (Field)
  • email (Field2)
  • password (Field3)
  • Field4
  • Field5

car_info (Untitled4)

  • car_id (Key) — Primary key — NOT NULL
  • name (Field)
  • number (Field2)
  • type (Field3)
  • info (Field4)

drive_info (Untitled2)

  • drive_id (Key) — Primary key — NOT NULL
  • date (Field)
  • time (Field2)
  • car_id (Key2) — Foreign key → car_info.car_id — NOT NULL

log_info (Untitled3)

  • log_id (Key) — Primary key — NOT NULL
  • date (Field)
  • mode (Field2)
  • status (Field3)
  • event1 (Field4)
  • event2 (Field5)
  • error1 (Field6)
  • error2 (Field7)
  • warning1 (Field8)
  • warning2 (Field9)
  • drive_id (Key2) — Foreign key → drive_info.drive_id — NOT NULL

ride_user (Untitled5)

  • ride_user_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • drive_id (Key3) — Foreign key → drive_info.drive_id — NOT NULL
  • 탑승 (Field)
  • 하차 (Field2)
  • 상태 (Field3)