데이터베이스 기말대체과제

테이블 (4)

Untitled (Activity)

  • Key (Activity Code) — int(10) — 기본 키 — NOT NULL
  • Field (Name) — char(20)
  • Field (time) — int(10)
  • Field (startYear) — int(5)
  • Key (LocationCode) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Location)

  • Key (LocationCode) — int(10) — 기본 키 — NOT NULL
  • Field (LocationTitle) — cahr(10)

Untitled2 (Activity Manager)

  • Key (manager ID) — int(10) — 기본 키 — NOT NULL
  • Key (Activity Code) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ParticipantsID) — int(10) — 외래 키 → Untitled3.Key — NOT NULL

Untitled3 (Participants)

  • Key (ParticipantsID) — int(10) — 기본 키 — NOT NULL
  • Field (job) — char(20)
  • Field (address) — char(30)
  • Field (age) — int(3)
  • Field (name) — char(10)