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