from code
Tables (20)
ai_correction
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- correctionResult — JSON — NOT NULL — AI correction results in JSON format
- projectId — INT — NOT NULL
- modelName — VARCHAR(255) — NOT NULL
- llmTemperature — FLOAT
- portfolioCorrectionId — INT — NOT NULL
attendee
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- userId — INT — NOT NULL
- planId — INT — NOT NULL
cocomment
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- content — VARCHAR(300) — NOT NULL
- commentId — INT — NOT NULL
- userId — INT — NOT NULL
comment
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- content — VARCHAR(300) — NOT NULL
- userId — INT — NOT NULL
- taskId — INT — NOT NULL
manager
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- userId — INT — NOT NULL
- taskId — INT — NOT NULL
master_portfolio
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- detailInfo — VARCHAR(2000)
- assignedTask — VARCHAR(2000)
- keyAchievement — VARCHAR(2000)
- insight — VARCHAR(2000)
- contributionRate — INT
- mainTask — VARCHAR(24)
- category — ENUM('COURSE', 'CLUB', 'ACTIVITY', 'PROJECT', 'OTHER') — 수업, 동아리, 대외활동, 프로젝트, 그 외
- status — ENUM('DONE', 'NOT_STARTED', 'NEED_ANSWERS', 'GENERATING')
- userId — INT — NOT NULL
- projectId — INT — NOT NULL
master_portfolio_ai
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- detailInfo — VARCHAR(2000) — NOT NULL
- assignedTask — VARCHAR(2000) — NOT NULL
- keyAchievement — VARCHAR(2000) — NOT NULL
- insight — VARCHAR(2000) — NOT NULL
- userId — INT — NOT NULL
- projectId — INT — NOT NULL
personal_recall
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- collaborationProfile — VARCHAR(2000)
- memorableExperience — VARCHAR(2000)
- strengthsAndGrowth — VARCHAR(2000)
- userId — INT — NOT NULL
- projectId — INT — NOT NULL
plan
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- name — VARCHAR(35)
- date — DATETIME — NOT NULL
- location — VARCHAR(20)
- memo — VARCHAR(500) — Plan notes
- startHour — TIME — Format: HH:mm:ss
- meetingRecords — VARCHAR(5000)
- projectId — INT — NOT NULL
- masterPortfolioId — INT
portfolio_correction
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- title — VARCHAR(20)
- submissionTarget — VARCHAR(20) — NOT NULL
- jobTitle — VARCHAR(15) — NOT NULL
- companyInsight — VARCHAR(5000)
- jd — VARCHAR(500) — NOT NULL — Job description
- status — ENUM('DONE', 'NOT_STARTED', 'DOING_RAG', 'COMPANY_INSIGHT', 'GENERATING')
- userId — INT — NOT NULL
project
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- name — VARCHAR(20) — NOT NULL
- goal — VARCHAR(400) — NOT NULL
- rule — VARCHAR(400) — NOT NULL
- isCompleted — BOOLEAN
- completedAt — DATETIME
project_file
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- name — VARCHAR(30) — NOT NULL
- fileUrl — VARCHAR(255) — NOT NULL
- category — ENUM('WORK', 'REFERENCE', 'EXAMPLE') — 업무, 레퍼런스, 예시
- userId — INT — NOT NULL
- projectId — INT — NOT NULL
questions
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- questionId — INT — NOT NULL
- questionType — ENUM('YES_NO', 'TEXT') — NOT NULL
- question — TEXT — NOT NULL
- answer — ENUM('YES', 'NO')
- reason — VARCHAR(300)
- masterPortfolioId — INT — NOT NULL
rag_data
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- keyword — VARCHAR(255)
- link — TEXT
- title — VARCHAR(255)
- type — ENUM('keyword', 'link') — NOT NULL
- portfolioCorrectionId — INT — NOT NULL
step
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- name — VARCHAR(20) — NOT NULL
- projectId — INT — NOT NULL
task
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- name — VARCHAR(35)
- deadline — DATETIME
- status — ENUM('NOTSTART', 'ONGOING', 'COMPLETED')
- memo — VARCHAR(500)
- stepId — INT — NOT NULL
task_file
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- fileUrl — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- taskId — INT — NOT NULL
- userId — INT — NOT NULL
user
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- name — VARCHAR(10) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- school — VARCHAR(15)
- tier — VARCHAR(255) — Payment plan - to be changed to ENUM
- imageUrl — VARCHAR(255) — NOT NULL
- kakaoId — BIGINT — NOT NULL — Kakao OAuth ID
- credit — INT — User credit amount
- projectNum — INT — Number of projects
- isActive — BOOLEAN — Account active status
- major — VARCHAR(15) — User major field
user_project
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- permission — ENUM('LEAD', 'MEMBER')
- role — VARCHAR(13) — NOT NULL
- userId — INT — NOT NULL
- projectId — INT — NOT NULL
writer
- id — INT
- createdAt — DATETIME
- updatedAt — DATETIME
- userId — INT — NOT NULL
- planId — INT — NOT NULL