데이터베이스 기말대체과제
테이블 (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)