ERD

Tables (7)

filter

  • id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_shared — BOOLEAN
  • likes — INT
  • name — VARCHAR(100)
  • login_id — VARCHAR(255)

filter_station

  • filter_id — BIGINT
  • station_id — BIGINT

line

  • id — BIGINT
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL

line_station

  • id — BIGINT
  • order_in_line — INT
  • line_id — BIGINT
  • station_id — BIGINT

member

  • id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME
  • email — VARCHAR(255) — NOT NULL
  • login_id — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)
  • password — VARCHAR(255) — NOT NULL
  • roles — JSON

member_filter

  • filter_id — BIGINT
  • member_id — BIGINT

station

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • area — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME