cue&a

Tables (18)

answer

  • answer_id — BIGSERIAL — Primary key — NOT NULL
  • session_id — VARCHAR(50) — Foreign key → question.session_id — NOT NULL
  • question_id — VARCHAR(50) — Foreign key → question.question_id — NOT NULL
  • answer_text — TEXT
  • score — INTEGER
  • answer_start — DOUBLE PRECISION
  • answer_end — DOUBLE PRECISION
  • think_time — DOUBLE PRECISION
  • answered_at — TIMESTAMPTZ
  • metrics — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

badge

  • badge_id — BIGSERIAL — Primary key — NOT NULL
  • badge_code — VARCHAR(50) — NOT NULL
  • badge_name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • condition_type — VARCHAR(30) — NOT NULL
  • condition_data — JSONB — NOT NULL
  • icon_url — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

bookmarked_question

  • bookmarked_question_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • session_id — VARCHAR(50) — Foreign key → question.session_id — NOT NULL
  • question_id — VARCHAR(50) — Foreign key → question.question_id — NOT NULL
  • memo — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

calendar_event

  • calendar_event_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • job_role — VARCHAR(50) — NOT NULL
  • interview_round — VARCHAR(30)
  • scheduled_at — TIMESTAMPTZ — NOT NULL
  • interview_method — VARCHAR(10) — NOT NULL
  • location — VARCHAR(200)
  • meeting_url — VARCHAR(500)
  • memo — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

company

  • company_id — BIGSERIAL — Primary key — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • industry — VARCHAR(100) — NOT NULL
  • values_format — VARCHAR(20) — NOT NULL
  • core_values — JSONB — NOT NULL
  • job_requirements — JSONB
  • source_url — TEXT — NOT NULL
  • updated_at — DATE — NOT NULL
  • verified — BOOLEAN — NOT NULL
  • talent_profile — TEXT
  • interview_style — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL

document

  • doc_id — BIGSERIAL — Primary key — NOT NULL
  • public_id — UUID — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • doc_title — VARCHAR(100) — NOT NULL
  • doc_type — VARCHAR(20) — NOT NULL
  • source_type — VARCHAR(10) — NOT NULL
  • file_name — VARCHAR(255)
  • object_key — TEXT
  • mime_type — VARCHAR(100)
  • file_size — BIGINT
  • doc_text — TEXT
  • file_format — VARCHAR(10)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

folder

  • folder_id — BIGSERIAL — Primary key — NOT NULL
  • public_id — UUID — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • folder_name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

goal

  • goal_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • goal_type — VARCHAR(20) — NOT NULL
  • target_metric — VARCHAR(30) — NOT NULL
  • target_value — INTEGER — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

notification_setting

  • notification_setting_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • calendar_enabled — BOOLEAN — NOT NULL
  • goal_enabled — BOOLEAN — NOT NULL
  • report_enabled — BOOLEAN — NOT NULL
  • badge_enabled — BOOLEAN — NOT NULL
  • streak_enabled — BOOLEAN — NOT NULL
  • marketing_enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

question

  • question_id — VARCHAR(50) — Primary key — NOT NULL
  • session_id — VARCHAR(50) — Foreign key → session.session_id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • text — TEXT — NOT NULL
  • audio_url — TEXT
  • category — VARCHAR(20)
  • difficulty — VARCHAR(5)
  • reask_of — VARCHAR(50)
  • is_spare_topic — BOOLEAN — NOT NULL
  • is_replay — BOOLEAN — NOT NULL
  • question_number — INTEGER — NOT NULL
  • topic_index — INTEGER — NOT NULL
  • answer_audio_object_key — TEXT
  • answer_video_object_key — TEXT
  • answer_is_timeout — BOOLEAN — NOT NULL
  • is_bookmarked — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

report

  • report_id — BIGSERIAL — Primary key — NOT NULL
  • public_id — UUID — NOT NULL
  • session_id — VARCHAR(50) — Foreign key → session.session_id — NOT NULL
  • score_content — INTEGER
  • score_speech — INTEGER
  • score_vision — INTEGER
  • score_total — INTEGER
  • summary — JSONB
  • growth_narrative — TEXT
  • timeline — JSONB
  • resilience — JSONB
  • report_data — JSONB
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

session

  • session_id — VARCHAR(50) — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • company_id — BIGINT — Foreign key → company.company_id
  • document_id — BIGINT — Foreign key → document.doc_id — NOT NULL
  • folder_id — BIGINT — Foreign key → folder.folder_id
  • retry_of_session_id — VARCHAR(50) — Foreign key → session.session_id
  • mode — VARCHAR(20) — NOT NULL
  • job_role — VARCHAR(100) — NOT NULL
  • custom_talent — TEXT
  • question_count — INTEGER — NOT NULL
  • persona — VARCHAR(20) — NOT NULL
  • hide_question_text — BOOLEAN — NOT NULL
  • duration_limit — INTEGER
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

streak

  • streak_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • activity_date — DATE — NOT NULL
  • answer_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user_auth

  • auth_id — VARCHAR(50) — Primary key — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(100)
  • password — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

user_badge

  • user_badge_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • badge_id — BIGINT — Foreign key → badge.badge_id — NOT NULL
  • source_session_id — VARCHAR(50) — Foreign key → session.session_id
  • earned_at — TIMESTAMPTZ — NOT NULL

user_company_interest

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • company_id — BIGINT — Foreign key → company.company_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

user_profile

  • user_profile_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key — NOT NULL
  • profile_image_url — VARCHAR(500)
  • introduction — VARCHAR(500)
  • target_job_role — VARCHAR(50)
  • career_level — VARCHAR(20)
  • school_name — VARCHAR(100)
  • major — VARCHAR(100)
  • graduation_year — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • email — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL