데코추

테이블 (7)

filter

  • filter_id (id) — AUTO INCREMENT — 기본 키
  • name — VARCHAR(100)
  • is_shared — TINYINT(1)
  • created_at — DATETIME
  • updated_at — DATETIME
  • login_id — VARCHAR(255) — 외래 키 → member.member_id — NOT NULL

filter_station

  • station_id — BIG INT — 외래 키 → station.station_id
  • filter_id — BIG INT — 외래 키 → filter.filter_id

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

  • member_id (id) — AUTO INCREMENT — 기본 키 — NOT NULL
  • login_id — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)
  • created_at — DATETIME
  • updated_at — DATETIME

member_filter

  • filter_id — BIG INT — 외래 키 → filter.filter_id
  • member_id — AUTO INCREMENT — 외래 키 → member.member_id — NOT NULL

station

  • station_id (id) — AUTO INCREMENT — 기본 키
  • station_name (name) — VARCHAR(100) — NOT NULL
  • line_nun,ber (line) — VARCHAR(50)
  • adress — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME