2026_SKTHON

Tables (4)

favorites

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • vacancy_id — BIGINT — Foreign key → vacancies.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

recommendations

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • vacancy_id — BIGINT — Foreign key → vacancies.id
  • recommendation_type — VARCHAR(30) — NOT NULL
  • input_data — JSONB — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • result_data — JSONB
  • detailed_report — JSONB
  • error_message — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(80) — NOT NULL
  • phone — VARCHAR(30)
  • role — VARCHAR(20) — NOT NULL
  • oauth_provider — VARCHAR(20)
  • oauth_id — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

vacancies

  • id — BIGSERIAL — Primary key — NOT NULL
  • owner_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • address — VARCHAR(500) — NOT NULL
  • latitude — NUMERIC(10,7)
  • longitude — NUMERIC(10,7)
  • area_pyeong — NUMERIC(8,2) — NOT NULL
  • floor — VARCHAR(30) — NOT NULL
  • deposit_amount — BIGINT
  • monthly_rent_amount — BIGINT
  • parking_available — BOOLEAN — NOT NULL
  • access_note — VARCHAR(255)
  • desired_businesses — TEXT
  • status — VARCHAR(20) — NOT NULL
  • cancelled_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL