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