ssafyens
Tables (43)
admin_permission
- id — bigint — Primary key — NOT NULL
- code — character varying(100) — NOT NULL
- name — character varying(100) — NOT NULL
- description — text
- display_order — integer — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
checkpoint_blobs
- thread_id — text — Primary key — NOT NULL
- checkpoint_ns — text — Primary key — NOT NULL
- channel — text — Primary key — NOT NULL
- version — text — Primary key — NOT NULL
- type — text — NOT NULL
- blob — bytea
checkpoint_migrations
- v — integer — Primary key — NOT NULL
checkpoint_writes
- thread_id — text — Primary key — NOT NULL
- checkpoint_ns — text — Primary key — NOT NULL
- checkpoint_id — text — Primary key — NOT NULL
- task_id — text — Primary key — NOT NULL
- idx — integer — Primary key — NOT NULL
- task_path — text — NOT NULL
- channel — text — NOT NULL
- type — text
- blob — bytea — NOT NULL
checkpoints
- thread_id — text — Primary key — NOT NULL
- checkpoint_ns — text — Primary key — NOT NULL
- checkpoint_id — text — Primary key — NOT NULL
- parent_checkpoint_id — text
- type — text
- checkpoint — jsonb — NOT NULL
- metadata — jsonb — NOT NULL
company
- id — bigint — Primary key — NOT NULL
- name — character varying(255) — NOT NULL
- type — character varying(50) — NOT NULL
- logo_url — character varying(512)
- corp_code — character varying(20)
- stock_code — character varying(20)
- listed — boolean — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
cs_topic
- id — bigserial — Primary key — NOT NULL
- parent_topic_id — bigint — Foreign key → cs_topic.id
- depth — smallint — NOT NULL
- domain — character varying(32) — NOT NULL
- path — character varying(200) — NOT NULL
- code — character varying(100) — NOT NULL
- name — character varying(100) — NOT NULL
- summary — character varying(255)
- description — text
- difficulty_level — character varying(16)
- learning_goal — jsonb
- display_order — integer — NOT NULL
- img_url — character varying(255)
- lecture_url — character varying(500)
- lecture_producer — character varying(100)
- lecture_title — character varying(200)
- created_at — timestamp with time zone — NOT NULL
- updated_at — timestamp with time zone — NOT NULL
- deleted_at — timestamp with time zone
edu_tier_benefit
- id — bigint — Primary key — NOT NULL
- edu_user_tier_id — bigint — Foreign key → edu_user_tier.id — NOT NULL
- code — character varying(50) — NOT NULL
- name — character varying(100) — NOT NULL
- description — text
- display_order — integer — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
edu_tier_condition
- id — bigint — Primary key — NOT NULL
- edu_user_tier_id — bigint — Foreign key → edu_user_tier.id — NOT NULL
- condition_type — character varying(50) — NOT NULL
- target_count — integer — NOT NULL
- description — text
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
edu_user_tier
- id — bigint — Primary key — NOT NULL
- code — character varying(50) — NOT NULL
- name — character varying(50) — NOT NULL
- description — text
- level — integer — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
file_asset
- id — bigint — Primary key — NOT NULL
- public_id — character varying(36) — NOT NULL
- owner_type — character varying(30)
- owner_id — bigint
- temporary_key — character varying(36)
- purpose — character varying(30) — NOT NULL
- original_file_name — character varying(255) — NOT NULL
- stored_file_name — character varying(255) — NOT NULL
- file_url — character varying(255) — NOT NULL
- file_size — bigint — NOT NULL
- mime_type — character varying(100) — NOT NULL
- display_order — integer — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
interview_messages
- id — bigserial — Primary key — NOT NULL
- session_id — bigint — Foreign key → interview_sessions.id — NOT NULL
- role — character varying(20) — NOT NULL
- content — text — NOT NULL
- feedback — text
- model_answer — text
- hint — text
- score — integer
- input_type — character varying(20) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
- parent_message_id — bigint — Foreign key → interview_messages.id
- superseded_at — timestamp with time zone
- status — character varying(16) — NOT NULL
- claimed_at — timestamp with time zone — NOT NULL
- main_index — integer
- is_follow_up — boolean
- follow_up_index — integer
- rubric_scores — jsonb
interview_question
- id — bigint — Primary key — NOT NULL
- interview_review_id — bigint — Foreign key → interview_review.id — NOT NULL
- question — text — NOT NULL
- processed_at — timestamp(6) with time zone
interview_review
- id — bigint — Primary key — NOT NULL
- author_id — bigint — Foreign key → user.id — NOT NULL
- company_id — bigint — Foreign key → company.id
- requested_company_name — character varying(255)
- title — character varying(100) — NOT NULL
- recruit_type — character varying(20)
- major — character varying(100)
- author_is_major — boolean — NOT NULL
- position — character varying(50) — NOT NULL
- process_info — text
- vibe_info — text
- content — text
- status — character varying(30) — NOT NULL
- admin_feedback — text
- reviewed_by — bigint — Foreign key → user.id
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
- view_count — integer — NOT NULL
interview_review_tech_stack
- review_id — bigint — Foreign key → interview_review.id — NOT NULL
- tech_stack_id — bigint — Foreign key → tech_stack.id — NOT NULL
interview_session_contexts
- id — bigserial — Primary key — NOT NULL
- session_id — bigint — Foreign key → interview_sessions.id — NOT NULL
- jd_text — text
- resume_text — text
- company_name — character varying(100)
- job_role — character varying(100)
- max_main_questions — integer — NOT NULL
- max_follow_ups_per_main — integer — NOT NULL
- created_at — timestamp with time zone — NOT NULL
- updated_at — timestamp with time zone — NOT NULL
- interview_category — character varying(20)
interview_sessions
- id — bigserial — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- type — character varying(20) — NOT NULL
- title — character varying(200)
- custom_prompt — text
- resume_file_url — character varying(500)
- status — character varying(20) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
- updated_at — timestamp with time zone — NOT NULL
job_interview_v2_threads
- thread_id — character varying(64) — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- company_name — character varying(120) — NOT NULL
- job_role — character varying(120) — NOT NULL
- title — character varying(200)
- status — character varying(32) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
- updated_at — timestamp with time zone — NOT NULL
job_question_corpus
- id — bigserial — Primary key — NOT NULL
- company_name — character varying(100)
- job_role — character varying(100)
- year — integer
- category — character varying(50)
- question_text — text — NOT NULL
- source_url — character varying(500)
- embedding — vector(1536)
- created_at — timestamp with time zone — NOT NULL
job_success_story
- id — bigint — Primary key — NOT NULL
- company_id — bigint — Foreign key → company.id — NOT NULL
- author_id — bigint — Foreign key → user.id — NOT NULL
- title — character varying(100) — NOT NULL
- position — character varying(50) — NOT NULL
- recruit_type — character varying(20)
- author_is_major — boolean — NOT NULL
- pass_tip — text — NOT NULL
- interview_process — text — NOT NULL
- written_test — text — NOT NULL
- view_count — integer — NOT NULL
- status — character varying(30) — NOT NULL
- admin_feedback — text
- reviewed_by — bigint — Foreign key → user.id
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
job_success_tech_stack
- story_id — bigint — Foreign key → job_success_story.id — NOT NULL
- tech_stack_id — bigint — Foreign key → tech_stack.id — NOT NULL
knowledge_models
- id — uuid — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- topics — jsonb — NOT NULL
- weak_areas — jsonb — NOT NULL
- strong_areas — jsonb — NOT NULL
- updated_at — timestamp with time zone — NOT NULL
message
- id — bigint — Primary key — NOT NULL
- sender_id — bigint — Foreign key → user.id — NOT NULL
- receiver_id — bigint — Foreign key → user.id — NOT NULL
- title — character varying(64) — NOT NULL
- content — character varying(256) — NOT NULL
- purpose — character varying(20) — NOT NULL
- is_read — boolean — NOT NULL
- is_sender_deleted — boolean — NOT NULL
- is_receiver_deleted — boolean — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
notice
- id — bigint — Primary key — NOT NULL
- author_id — bigint — Foreign key → user.id — NOT NULL
- type — character varying(20) — NOT NULL — '게시글 유형입니다. 허용값: NOTICE QNA, MENTORING, DONATION_NOTICE, DONATION_PREMIUM.',
- is_anonymous — boolean — NOT NULL — '익명 작성 여부입니다. QNA MENTORING 유형에서만 허용됩니다.',
- is_public — boolean — NOT NULL — '게시글 공개 여부입니다. QNA MENTORING 유형은 항상 공개 상태여야 합니다.',
- is_pinned — boolean — NOT NULL
- category — character varying(50) — NOT NULL
- view_count — integer
- title — character varying(100) — NOT NULL
- content — text — NOT NULL
- status — character varying(20) — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
notice_comment
- id — bigint — Primary key — NOT NULL
- notice_id — bigint — Foreign key → notice_comment.notice_id — NOT NULL
- author_id — bigint — Foreign key → user.id — NOT NULL
- parent_comment_id — bigint — Foreign key → notice_comment.id
- content — text — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
notice_like
- id — bigint — Primary key — NOT NULL
- notice_id — bigint — Foreign key → notice.id — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
rag_chunks
- id — bigserial — Primary key — NOT NULL
- document_id — bigint — Foreign key → rag_documents.id — NOT NULL
- chunk_index — integer — NOT NULL
- content — text — NOT NULL
- content_hash — character varying(64) — NOT NULL
- token_count — integer — NOT NULL
- metadata — jsonb
- created_at — timestamp with time zone — NOT NULL
rag_documents
- id — bigserial — Primary key — NOT NULL
- source_type — character varying(50) — NOT NULL
- source_id — bigint
- title — character varying(300) — NOT NULL
- metadata — jsonb
- created_at — timestamp with time zone — NOT NULL
rag_embeddings
- id — bigserial — Primary key — NOT NULL
- chunk_id — bigint — Foreign key → rag_chunks.id — NOT NULL
- embedding — vector(1536) — NOT NULL
- model — character varying(100) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
resume
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- title — character varying(100)
- introduction — text
- photo_url — character varying(512)
- user_name — character varying(100)
- birth_date — date
- phone — character varying(20)
- address — character varying(255)
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
resume_certification
- id — bigint — Primary key — NOT NULL
- resume_id — bigint — Foreign key → resume.id — NOT NULL
- name — character varying(100) — NOT NULL
- issuing_organization — character varying(100)
- score_or_grade — character varying(50)
- type — character varying(30)
- obtained_date — date
- expiry_date — date
resume_education
- id — bigint — Primary key — NOT NULL
- resume_id — bigint — Foreign key → resume.id — NOT NULL
- school_name — character varying(100)
- location — character varying(100)
- school_type — character varying(50)
- major — character varying(100)
- degree — character varying(50)
- status — character varying(20)
- start_date — date
- end_date — date
role
- id — bigint — Primary key — NOT NULL
- code — character varying(255) — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
session_analyses
- id — uuid — Primary key — NOT NULL
- session_id — bigint — Foreign key → interview_sessions.id — NOT NULL
- question_analyses — jsonb — NOT NULL
- overall_score — integer — NOT NULL
- growth_delta — jsonb
- coach_recommendations — jsonb
- created_at — timestamp with time zone — NOT NULL
tech_stack
- id — bigint — Primary key — NOT NULL
- name — character varying(100) — NOT NULL
- name_lower — character varying(100) — NOT NULL
- badge_url — character varying(512) — NOT NULL
- deleted_at — timestamp(6) with time zone
user
- id — bigint — Primary key — NOT NULL
- edu_user_tier_id — bigint — Foreign key → edu_user_tier.id
- role_id — bigint — Foreign key → role.id — NOT NULL
- full_name — character varying(512)
- student_id — character varying(512)
- password_hash — character varying(255)
- last_team_id — character varying(50)
- cohort — character varying(20)
- is_major — boolean — NOT NULL
- nickname — character varying(50)
- profile_image_url — character varying(512)
- email — character varying(512)
- login_id — character varying(512)
- login_id_hash — character varying(64)
- phone_number — character varying(512)
- phone_number_hash — character varying(64)
- phone_verified — boolean — NOT NULL
- phone_alert — boolean — NOT NULL
- activity_country_code — character varying(2)
- activity_sido_code — character varying(2)
- activity_sigungu_code — character varying(5)
- introduction — text
- donation_verification_status — character varying(20) — NOT NULL
- project_coach_verification_status — character varying(20) — NOT NULL
- profile_completed — boolean — NOT NULL
- account_status — character varying(20) — NOT NULL
- visit_count — integer — NOT NULL
- last_active_at — timestamp(6) with time zone
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
user_admin_permission
- user_id — bigint — Foreign key → user.id — NOT NULL
- admin_permission_id — bigint — Foreign key → admin_permission.id — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
user_company
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- company_id — bigint — Foreign key → company.id
- requested_company_name — character varying(255)
- position — character varying(50) — NOT NULL
- document_url — character varying(512)
- status — character varying(20) — NOT NULL
- admin_feedback — text
- reviewed_by — bigint — Foreign key → user.id
- requested_at — timestamp(6) with time zone — NOT NULL
- reviewed_at — timestamp(6) with time zone
user_concept_progress
- id — bigserial — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- topic_id — bigint — Foreign key → cs_topic.id — NOT NULL
- status — character varying(20) — NOT NULL
- completed_at — timestamp with time zone
- created_at — timestamp with time zone — NOT NULL
- updated_at — timestamp with time zone — NOT NULL
user_donation_verification
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- request_type — character varying(20) — NOT NULL
- status — character varying(20) — NOT NULL
- admin_feedback — text
- reviewed_by — bigint — Foreign key → user.id
- requested_at — timestamp(6) with time zone — NOT NULL
- reviewed_at — timestamp(6) with time zone
user_project_coach_verification
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- request_type — character varying(20) — NOT NULL
- status — character varying(20) — NOT NULL
- admin_feedback — text
- reviewed_by — bigint — Foreign key → user.id
- requested_at — timestamp(6) with time zone — NOT NULL
- reviewed_at — timestamp(6) with time zone
user_service_consent
- user_id — bigint — Foreign key → user.id — NOT NULL
- mentoring_service_consent — boolean — NOT NULL
- ai_mock_interview_service_consent — boolean — NOT NULL
- information_sharing_service_consent — boolean — NOT NULL
- marketing_advertising_consent — boolean — NOT NULL
- advertising_information_receipt_consent — boolean — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
user_tech_stack
- tech_stack_id — bigint — Foreign key → tech_stack.id — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL