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)