데코추
테이블 (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