셔틀버스
테이블 (6)
Bookmark (Untitled4)
- bookmark_id (Key) — int — 기본 키 — NOT NULL
- user_id (Field) — int
- bus_id (Field2) — int
Bus (Untitled5)
- bus_id (Key) — int — 기본 키 — NOT NULL
- station_id (Key2) — int — 외래 키 → Station.station_id — NOT NULL
- depart_time (Field) — time
- arrival_time (Field2) — time
- passengers (Field3) — int
- bookmark_num (Field4) — int
Driver (Untitled3)
- driver_id (Key) — int — 기본 키 — NOT NULL
- password (Field) — String
- email (Field2) — String
- Field3
Manager (Untitled2)
- manager_id (Key) — int — 기본 키 — NOT NULL
- password (Field) — String
- email (Field2) — String
- role (Field3) — int — NOT NULL
Station (Untitled6)
- station_id (Key) — int — 기본 키 — NOT NULL
- station_name (Field) — String
- arrival_time (Field2) — time
- Field3
User (Untitled)
- user_id (Key) — int — 기본 키 — NOT NULL
- school_id (Field) — int
- email (Field2) — String
- name (Field3) — String
- password (Field4) — String
- role (Field5) — int — NOT NULL