HR DB 테이블 명세서

테이블 (4)

Department (Untitled)

  • Key (uniqe) — varchar — 기본 키 — NOT NULL
  • Key — int — 외래 키 → Member.Key — NOT NULL

Member

  • Key — int — 기본 키 — NOT NULL
  • Field (foreign key) — varchar
  • Field — varchar
  • Field2 — varchar
  • Field3 — varchar

Project (Untitled2)

  • Key — int — 외래 키 → Member.Key — NOT NULL
  • Field — varchar
  • Field2 — Date
  • Field3 — Date

ProjectMember (Untitled3)

  • Key — varchar — 외래 키 → Project.Key — NOT NULL
  • Key (Key2) — int — 외래 키 → Member.Key — NOT NULL
  • Field — int