ㅂㅂㅂㅂ
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