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