카테부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