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)