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