따릉이

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