ReQ

Tables (7)

FeedBack (피드백)

  • id (피드백번호) — BIGINT — Primary key — NOT NULL
  • feedback (피드백 내용) — TEXT
  • created_at (생성 일자) — DATETIME
  • it_id (번호2) — BIGINT — Foreign key → Interview.it_id — NOT NULL

Interview (면접 세션)

  • it_id (번호) — BIGINT — Primary key — NOT NULL
  • company_name (회사명) — VARCHAR(100) — NOT NULL
  • job_position (직무) — VARCHAR(100)
  • created_at (생성일자) — DATETIME — NOT NULL

Interview_Answer (예상 질문 답변)

  • id (예상 답변 번호) — BIGINT — Primary key — NOT NULL
  • id (예상질문번호) — BIGINT — Foreign key → Interview_Question.id — NOT NULL
  • answer (답변) — TEXT
  • created_at (생성일자) — DATETIME

Interview_Question (예상 질문)

  • id (예상질문번호) — BIGINT — Primary key — NOT NULL
  • it_id (면접 세션 번호) — BIGINT — Foreign key → Interview.it_id — NOT NULL
  • question (예상 질문) — TEXT
  • category (카테고리) — VARCHAR(50)
  • difficulty (난이도) — ENUM
  • created_at (생성일자) — DATETIME — NOT NULL

Interview_Review (면접 회고)

  • id (면접 회고 번호) — BIGINT — Primary key — NOT NULL
  • content (면접 회고 내용) — TEXT
  • feeling (감정) — ENUM
  • created_at (생성 일자) — DATETIME — NOT NULL
  • it_id (번호2) — BIGINT — Foreign key → Interview.it_id — NOT NULL

Resume (이력서)

  • resume_id (이력서번호) — BIGINT — Primary key — NOT NULL
  • resume_title (이력서제목) — VARCHAR(100) — NOT NULL
  • resume_content (원문 이력서) — TEXT — NOT NULL
  • file_url (파일) — VARCHAR(255) — NOT NULL
  • analyzed (분석여부) — BOOLEAN — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일자) — DATETIME — NOT NULL
  • user_id (사용자번호) — BIGINT — Foreign key → User.user_id — NOT NULL

User (사용자)

  • user_id (사용자번호) — BIGINT — Primary key — NOT NULL
  • username (사용자명) — VARCHAR(20) — NOT NULL
  • password (패스워드) — VARCHAR(200) — NOT NULL
  • email (이메일) — VARCHAR(50) — NOT NULL
  • provider (Field)
  • created_at (생성일자) — DATETIME — NOT NULL
  • nickname (닉네임) — VARCHAR(15)