혼자 해보는 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