유로패스파인더
테이블 (3)
Price_Alerts
- alert_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → Users.user_id — NOT NULL
- departure_airport — VARCHAR(10) — NOT NULL
- arrival_airport — VARCHAR(10) — NOT NULL
- target_date — DATE
- target_price — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
Routes
- route_id — INT — 기본 키 — NOT NULL
- departure_airport — VARCHAR(10) — NOT NULL
- arrival_airport — VARCHAR(10) — NOT NULL
- airline_code — VARCHAR(10) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- departure_date — DATE — NOT NULL
- updated_at — DATETIME — NOT NULL
Users
- user_id — INT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- preferred_currency — VARCHAR(10) — NOT NULL