카테부2 11-1

테이블 (14)

ai_evaluation_jobs

  • eval_job_id — BIGINT — 기본 키 — NOT NULL
  • application_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • requested_by — BIGINT — NOT NULL
  • requested_at — TIMESTAMP — NOT NULL
  • started_at — TIMESTAMP
  • finished_at — TIMESTAMP
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL

ai_evaluation_results

  • eval_result_id — BIGINT — 기본 키 — NOT NULL
  • application_id — BIGINT — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • overall_score — INT — NOT NULL
  • one_line_review — VARCHAR(255) — NOT NULL
  • metric1_name — VARCHAR(50) — NOT NULL
  • metric1_score — INT — NOT NULL
  • metric1_feedback — TEXT
  • metric2_name — VARCHAR(50) — NOT NULL
  • metric2_score — INT — NOT NULL
  • metric2_feedback — TEXT
  • metric3_name — VARCHAR(50) — NOT NULL
  • metric3_score — INT — NOT NULL
  • metric3_feedback — TEXT
  • metric4_name — VARCHAR(50) — NOT NULL
  • metric4_score — INT — NOT NULL
  • metric4_feedback — TEXT
  • generated_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

application_documents

  • application_document_id — BIGINT — 기본 키 — NOT NULL
  • application_id — BIGINT — NOT NULL
  • doc_type — VARCHAR(20) — NOT NULL
  • file_id — BIGINT — NOT NULL
  • uploaded_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

auth_refresh_tokens

  • refresh_token_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • token_hash — CHAR(64) — NOT NULL
  • issued_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked_at — TIMESTAMP
  • revoke_reason — VARCHAR(50)
  • replaced_by_token_id — BIGINT
  • user_agent — VARCHAR(255)
  • ip_address — VARCHAR(45)
  • created_at — TIMESTAMP — NOT NULL

chat_messages

  • message_id — BIGINT — 기본 키 — NOT NULL
  • chat_room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • message_type — VARCHAR(20) — NOT NULL
  • content — TEXT
  • file_id — BIGINT
  • sent_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

chat_room_members

  • chat_room_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 기본 키 — NOT NULL
  • application_id — BIGINT
  • role — VARCHAR(20) — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL
  • left_at — TIMESTAMP
  • leave_reason — VARCHAR(50)
  • kicked_by_user_id — BIGINT
  • is_banned — BOOLEAN — NOT NULL

chat_rooms

  • chat_room_id — BIGINT — 기본 키 — NOT NULL
  • job_post_id — BIGINT — NOT NULL
  • created_by — BIGINT — NOT NULL
  • room_name — VARCHAR(50) — NOT NULL
  • max_participants — INT — NOT NULL
  • room_goal — VARCHAR(50) — NOT NULL
  • cutline_score — INT — NOT NULL
  • preferred_conditions — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

file_objects

  • file_id — BIGINT — 기본 키 — NOT NULL
  • storage_provider — VARCHAR(20) — NOT NULL
  • bucket — VARCHAR(100)
  • object_key — VARCHAR(255) — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • content_type — VARCHAR(100)
  • size_bytes — BIGINT — NOT NULL
  • checksum — VARCHAR(128)
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

job_applications

  • application_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • job_post_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

job_posts

  • job_post_id — BIGINT — 기본 키 — NOT NULL
  • created_by — BIGINT — NOT NULL
  • source_url — VARCHAR(500) — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • job_title — VARCHAR(150) — NOT NULL
  • main_tasks — TEXT
  • tech_stack — TEXT
  • recruitment_status — VARCHAR(20) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • ai_summary — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

notifications

  • notification_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • body — VARCHAR(255) — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • ref_type — VARCHAR(30)
  • ref_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • read_at — TIMESTAMP

user_oauth_accounts

  • oauth_account_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(100) — NOT NULL
  • provider_email — VARCHAR(255)
  • connected_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

user_withdrawals

  • withdrawal_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • reason — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGINT — 기본 키 — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP
  • profile_image_file_id — BIGINT