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