셔틀버스

테이블 (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