따릉이
테이블 (9)
Board
- board_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- board_type — ENUM('QNA','NOTICE','REPORT') — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- modified_at — TIMESTAMP
Comment
- comment_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- board_id — BIGINT — 외래 키 → Board.board_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
Pass
- pass_id — BIGINT — 기본 키 — NOT NULL
- type — ENUM('1DAY','7DAY','30DAY','ANNUAL') — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
Rental
- rental_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- start_station_id — BIGINT — 외래 키 → Station.station_id — NOT NULL
- end_station_id — BIGINT — 외래 키 → Station.station_id — NOT NULL
- bike_num — VARCHAR(50) — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME
Report
- report_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- bike_num — VARCHAR(50)
- description — TEXT
- status — ENUM('PENDING','IN_PROGRESS','RESOLVED')
- created_at — TIMESTAMP
- station_id — BIGINT — 외래 키 → Station.station_id — NOT NULL
Station
- station_id — BIGINT — 기본 키 — NOT NULL
- created_by — BIGINT — 외래 키 → User.user_id — NOT NULL
- updated_by — BIGINT — 외래 키 → User.user_id — NOT NULL
- station_name — VARCHAR(100) — NOT NULL
- latitude — DECIMAL(10,7) — NOT NULL
- longitude — DECIMAL(10,7) — NOT NULL
- address — VARCHAR(255)
- capacity — INT
- installed_date — DATE
- closed_date — DATE
UsageStats
- stat_id — BIGINT — 기본 키 — NOT NULL
- station_id — BIGINT — 외래 키 → Station.station_id — NOT NULL
- rental_id — BIGINT — 외래 키 → Rental.rental_id — NOT NULL
- date — DATE — NOT NULL
- rentals — INT
- returns — INT
User
- user_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('USER', 'ADMIN') — NOT NULL
User_Pass
- user_pass_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- pass_id — BIGINT — 외래 키 → Pass.pass_id — NOT NULL
- activated_at — DATETIME
- expired_at — DATETIME
- status — ENUM('ACTIVE','EXPIRED','CANCELED')