유로패스파인더

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