혼자 해보는 erdcloud
테이블 (4)
RESUMES (Untitled)
- ID(PK) (Key) — BIGINT — 기본 키 — NOT NULL
- USER_ID(FK->USERS.ID) (Field) — BIGINT
- TITLE (Field2) — VARCHAR
- CATEGORY(자기소개서/이력서) (Field3) — VARCHAR
- CREATED_AT (Field4) — TIMESTAMP
RESUME_VERSIONS (CopyOfID)
- ID (Key) — 기본 키 — NOT NULL
- RESUME_ID(FK->resumes.id)) (Field) — BIGINT
- VERSION_NUMBER (Field3) — INT
- content (Field4) — text
- created_at (Field2) — timestamp
USERS (ID)
- ID(PK) (Key) — BIGINT — 기본 키 — NOT NULL
- EMAIL(UQ) (Field) — VARCHAR
- NAME (Field3) — VARCHAR
- CREATED_AT (Field4) — TIMESTAMP
feedbacks (Untitled2)
- ID (Key) — BIGINT — 기본 키 — NOT NULL
- resume_version_id(FK->resume_versions.id) (Field) — BIGINT
- status (VARCHAR) — VARCHAR
- overall_score (Field3) — INT
- result_json (Field2) — JSONB
- error_message (Field4) — TEXT
- created_at (Field5) — TIMESTAMP
- completed_at (Field6) — TIMESTAMP