ㅂㅂㅂㅂ

Tables (15)

admins

  • id — BIGINT
  • admin_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — ENUM('SUPER_ADMIN', 'ADMIN') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

buses

  • id — VARCHAR(50)
  • bus_number — VARCHAR(50) — NOT NULL
  • license_plate — VARCHAR(20) — NOT NULL
  • seat_count — INT — NOT NULL
  • status — ENUM('AVAILABLE', 'IN_USE', 'MAINTENANCE', 'RETIRED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — idx_status

drivers

  • id — BIGINT
  • driver_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • license_number — VARCHAR(50) — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE', 'SUSPENDED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — idx_status

notice_targets

  • id — BIGINT
  • notice_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • sent — BOOLEAN — NOT NULL
  • sent_at — DATETIME
  • INDEX — idx_notice_sent

notices

  • id — BIGINT
  • admin_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • importance — ENUM('NORMAL', 'IMPORTANT') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • sent_at — DATETIME
  • INDEX — idx_importance

notifications

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • type — ENUM('RESERVATION', 'NOTICE', 'SYSTEM') — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • sent_at — DATETIME — NOT NULL
  • read — BOOLEAN — NOT NULL
  • important — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_user_read
  • INDEX — idx_important

reservation_days

  • id — BIGINT
  • reservation_id — BIGINT — NOT NULL
  • day_of_week — ENUM('MONDAY', 'TUESDAY', 'WEDNESDAY', 'THURSDAY', 'FRIDAY', 'SATURDAY', 'SUNDAY') — NOT NULL

reservations

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • time — VARCHAR(5) — NOT NULL — HH:mm 형식
  • schedule_type — ENUM('GOING', 'RETURNING') — NOT NULL
  • from_location — VARCHAR(100) — NOT NULL
  • to_location — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted — BOOLEAN — NOT NULL
  • INDEX — idx_user_deleted
  • INDEX — idx_schedule_time

ride_locations

  • id — BIGINT
  • ride_id — BIGINT — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • current_station_id — BIGINT
  • timestamp — DATETIME — NOT NULL
  • INDEX — idx_ride_timestamp
  • INDEX — idx_timestamp

rides

  • id — BIGINT
  • schedule_id — BIGINT — NOT NULL
  • route_id — BIGINT — NOT NULL
  • bus_id — VARCHAR(50) — NOT NULL
  • driver_id — BIGINT — NOT NULL
  • scheduled_start_time — DATETIME — NOT NULL
  • actual_start_time — DATETIME
  • end_time — DATETIME
  • status — ENUM('SCHEDULED', 'RUNNING', 'COMPLETED', 'CANCELLED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — idx_status_time
  • INDEX — idx_driver_time

route_stations

  • id — BIGINT
  • route_id — BIGINT — NOT NULL
  • station_id — BIGINT — NOT NULL
  • order — INT — NOT NULL — 정류장 순서
  • INDEX — idx_route_station

routes

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • direction — ENUM('GOING', 'RETURNING', 'CIRCULAR') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

schedules

  • id — BIGINT
  • route_id — BIGINT — NOT NULL
  • time — VARCHAR(5) — NOT NULL — HH:mm 형식
  • schedule_type — ENUM('GOING', 'RETURNING') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — idx_route_schedule

stations

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — idx_location

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • affiliation — ENUM('STUDENT', 'STAFF') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted — BOOLEAN — NOT NULL
  • INDEX — idx_affiliation
  • INDEX — idx_email