ERD 테스트

테이블 (4)

Applied Project (Application)

  • id — 기본 키 — NOT NULL
  • user_id
  • project_id
  • Field (status)

Created Project

  • Key (id) — 기본 키 — NOT NULL
  • Field2 (user_id)
  • Field (project_id)
  • Field (title) — NOT NULL
  • Field (description)
  • Field (created_at)

Project

  • Key (id2) — 외래 키 → Created Project.Key — NOT NULL
  • id

User

  • id (id2) — 외래 키 → Applied Project.id — NOT NULL
  • Key (id3) — 외래 키 → Created Project.Key — NOT NULL
  • id