Ait
Tables (39)
ai_comprehensive_reports
- id — BIGINT — Primary key — NOT NULL
- ai_interview_id — BIGINT — Foreign key → ai_interviews.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
ai_interview_answer_feedbacks
- id — BIGINT — Primary key — NOT NULL
- answer_id — BIGINT — Foreign key → ai_interview_user_answers.id — NOT NULL
- extracted_keywords — VARCHAR(255)
- score — INT — NOT NULL
- feedback_text — TEXT — NOT NULL
- created_at — TIMESTAMP
ai_interview_expected_answers
- id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → ai_interview_questions.id — NOT NULL
- expected_answer_text — TEXT — NOT NULL
ai_interview_questions
- id — BIGINT — Primary key — NOT NULL
- ai_interview_id — BIGINT — Foreign key → ai_interviews.id — NOT NULL
- question_num — INT — NOT NULL
- question_text — TEXT — NOT NULL
- intention — TEXT — NOT NULL
ai_interview_user_answers
- id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → ai_interview_questions.id — NOT NULL
- user_answer_text — TEXT — NOT NULL
ai_interviews
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- difficulty — VARCHAR(50) — NOT NULL
- ai_attitude_style — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
- ended_at — TIMESTAMP
ai_peer_summaries
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → study_sessions.id — NOT NULL
- evaluatee_id — BIGINT — Foreign key → users.id — NOT NULL
- summary_content — TEXT — NOT NULL
- created_at — TIMESTAMP
analyses
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- target_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
cover_letter_questions
- id — BIGINT — Primary key — NOT NULL
- cover_letter_id — BIGINT — Foreign key → cover_letters.id — NOT NULL
- question_order — INT — NOT NULL
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
cover_letters
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- company_name — VARCHAR(255) — NOT NULL
- job_role — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
github_installations
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- installation_id — VARCHAR(100) — NOT NULL
- github_username — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
github_repos
- id — BIGINT — Primary key — NOT NULL
- github_installation_id — BIGINT — Foreign key → github_installations.id — NOT NULL
- github_repo_id — VARCHAR(100) — NOT NULL
- repo_nickname — VARCHAR(255) — NOT NULL
- repo_origin_name — VARCHAR(255) — NOT NULL
- is_private — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
job_interests
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- job_interest — VARCHAR(100) — NOT NULL
notifications
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- target_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- status — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- deleted_at — TIMESTAMP
peer_feedbacks
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → study_sessions.id — NOT NULL
- evaluator_id — BIGINT — Foreign key → users.id — NOT NULL
- evaluatee_id — BIGINT — Foreign key → users.id — NOT NULL
- logical_score — INT — NOT NULL
- answer_score — INT — NOT NULL
- communication_score — INT — NOT NULL
- comprehension_score — INT — NOT NULL
- attitude_score — INT — NOT NULL
- time_management_score — INT — NOT NULL
- feedback — TEXT — NOT NULL
- created_at — TIMESTAMP
post_comments
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
post_images
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- stored_name — VARCHAR(255) — NOT NULL
post_likes
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- created_at — TIMESTAMP
post_scraps
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- created_at — TIMESTAMP
posts
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- category — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
resume_activities
- id — BIGINT — Primary key — NOT NULL
- resume_id — BIGINT — Foreign key → resumes.id — NOT NULL
- activity_name — VARCHAR(255) — NOT NULL
- organization — VARCHAR(255) — NOT NULL
- role — VARCHAR(100)
- start_date — DATE — NOT NULL
- end_date — DATE
- description — TEXT
resume_awards
- id — BIGINT — Primary key — NOT NULL
- resume_id — BIGINT — Foreign key → resumes.id — NOT NULL
- award_name — VARCHAR(255) — NOT NULL
- organization — VARCHAR(255) — NOT NULL
- grade — VARCHAR(100) — NOT NULL
- award_date — DATE — NOT NULL
- description — TEXT
resume_careers
- id — BIGINT — Primary key — NOT NULL
- resume_id — BIGINT — Foreign key → resumes.id — NOT NULL
- company_name — VARCHAR(255) — NOT NULL
- role — VARCHAR(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- description — TEXT
- is_working — BOOLEAN — NOT NULL
resume_certifications
- id — BIGINT — Primary key — NOT NULL
- resume_id — BIGINT — Foreign key → resumes.id — NOT NULL
- cert_name — VARCHAR(255) — NOT NULL
- issuer — VARCHAR(255) — NOT NULL
- acquired_date — DATE — NOT NULL
resume_educations
- id — BIGINT — Primary key — NOT NULL
- resume_id — BIGINT — Foreign key → resumes.id — NOT NULL
- school_name — VARCHAR(255) — NOT NULL
- major — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- gpa — VARCHAR(20)
- start_date — DATE — NOT NULL
- end_date — DATE
resume_languages
- id — BIGINT — Primary key — NOT NULL
- resume_id — BIGINT — Foreign key → resumes.id — NOT NULL
- language_name — VARCHAR(100) — NOT NULL
- test_name — VARCHAR(100) — NOT NULL
- score — VARCHAR(50) — NOT NULL
- acquired_date — DATE — NOT NULL
resume_projects
- id — BIGINT — Primary key — NOT NULL
- resume_id — BIGINT — Foreign key → resumes.id — NOT NULL
- project_name — VARCHAR(255) — NOT NULL
- tech_stacks — VARCHAR(255) — NOT NULL
- role — VARCHAR(100) — NOT NULL
- description — TEXT — NOT NULL
- repo_id — VARCHAR(255)
resume_sw_skills
- id — BIGINT — Primary key — NOT NULL
- resume_id — BIGINT — Foreign key → resumes.id — NOT NULL
- skill_name — VARCHAR(100) — NOT NULL
- skill_level — VARCHAR(10) — NOT NULL
- description — TEXT
resume_trainings
- id — BIGINT — Primary key — NOT NULL
- resume_id — BIGINT — Foreign key → resumes.id — NOT NULL
- organization — VARCHAR(255) — NOT NULL
- course_name — VARCHAR(255) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- description — TEXT
resumes
- id — BIGINT — Primary key — NOT NULL
- usre_id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
social_users
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- provider_id — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
study_group_calendars
- id — BIGINT — Primary key — NOT NULL
- study_group_id — BIGINT — Foreign key → study_groups.id — NOT NULL
- content — TEXT — NOT NULL
- start_time — TIMESTAMP — NOT NULL
- ended_time — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
study_group_members
- id — BIGINT — Primary key — NOT NULL
- study_group_id — BIGINT — Foreign key → study_groups.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
- joined_at — TIMESTAMP
- deleted_at — TIMESTAMP
study_groups
- id — BIGINT — Primary key — NOT NULL
- owner_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- capacity — INT — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
study_session_members
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- session_id — BIGINT — Foreign key → study_sessions.id — NOT NULL
- role — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- joined_at — TIMESTAMP
study_sessions
- id — BIGINT — Primary key — NOT NULL
- study_group_id — BIGINT — Foreign key → study_groups.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- session_uuid — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- ended_at — TIMESTAMP
user_images
- id — BIGINT — Primary key — NOT NULL
- user_id (user_Id) — BIGINT — Foreign key → users.id — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- stored_name — VARCHAR(255) — NOT NULL
user_skills
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- skill — VARCHAR(100) — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(25) — NOT NULL
- nickname — VARCHAR(25) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP