ERD_예제3
테이블 (4)
ACTIVITY (Untitled)
- ActNum (Key) — char(10) — 기본 키 — NOT NULL
- ActName (Field) — char
- ActInfo (Field2) — char
CLASS (Untitled2)
- ClassNum (Key) — 기본 키 — NOT NULL
- ActNum (Key2) — char(10) — 외래 키 → ACTIVITY.ActNum — NOT NULL
- Time (Field)
- TotalNumber (Field2) — integer
- CurrentNumber (Field3) — integer
CLASS_LEVEL (Untitled4)
- Field
- Field2
MEMBER (Untitled3)
- Id (Key) — char(10) — 기본 키 — NOT NULL
- name (Field)
- address (Field2)
- age (Field3)