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