CoachBot

Tables (9)

Untitled (job_category)

  • Key (job_category_id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (description) — varchar(255)

Untitled (Question)

  • Key (question_id) — bigint — Primary key — NOT NULL
  • Key (job_category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled (AnswerHistory)

  • Key (history_id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL
  • Key (question_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (job_category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (question_text) — text
  • Field (answer_text) — text — NOT NULL
  • Field (ai_feedback_text) — text — NOT NULL
  • Field (ai_example_answer_text) — text — NOT NULL
  • Field2 (created_at) — datetime — NOT NULL

Untitled (review)

  • Key (review_id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL
  • Key (job_category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field2 (company_name) — varchar(255) — NOT NULL
  • Field3 (content) — text — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (ai_prompt)

  • Key (prompt_id) — bigint — Primary key — NOT NULL
  • Key (job_category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (prompt_text) — text — NOT NULL
  • Field (temperature) — float — NOT NULL
  • Field (max_tokens) — int — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (review_likes)

  • Key (like_id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (user_token)

  • Key (token_id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL
  • Field (refresh_token) — text — NOT NULL
  • Field (expires_at) — datetime — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (admin)

  • Key (admin_id) — bigint — Primary key — NOT NULL
  • Field (email) — varchar(255) — NOT NULL
  • Field (password) — varchar(255) — NOT NULL
  • Field (created_at) — datetime — NOT NULL

user

  • id (user_id) — bigint — Primary key — NOT NULL
  • Key (job_category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • kakao_id — bigint — NOT NULL
  • Field2 (email) — varchar(255) — NOT NULL
  • Field (nickname) — varchar(50) — NOT NULL
  • Field2 (profile_image_url) — text
  • Field4 (created_at) — datetime — NOT NULL
  • Field5 (updated_at) — datetime — NOT NULL