개인 ERD 작성문제
테이블 (4)
Activity (Untitled)
- Activity_Code (Key) — 기본 키 — NOT NULL
- Key2 — 기본 키 — NOT NULL
- Name (Field)
- Description (Field2)
Class (Untitled2)
- Class_ID (Key) — 기본 키 — NOT NULL
- Schedule (Field2)
- Max_Participants (Field3)
- Current_Participants (Field4)
- Activity_Code (Key2) — 외래 키 → Activity.Activity_Code — NOT NULL
- Member_ID (Key3) — 외래 키 → Member_Class.Member_ID — NOT NULL
- Key2 (Key22) — 외래 키 → Member_Class.Key2 — NOT NULL
- Key2 (Key23) — 외래 키 → Activity.Key2 — NOT NULL
Member (Untitled3)
- Member_ID (Key) — 기본 키 — NOT NULL
- Key2 — 기본 키 — NOT NULL
- Class_ID (Field)
- Address (Field2)
- Age (Field3)
- Difficulty_Level (Field4)
- Field5
Member_Class (Untitled4)
- Member_ID (Key) — 외래 키 → Member.Member_ID — NOT NULL
- Key2 (Key22) — 외래 키 → Member.Key2 — NOT NULL
- Difficulty_Level (Field)
- Class_ID (Key2) — 외래 키 → Class.Class_ID — NOT NULL
- Key2 (Key23) — 외래 키 → Class.Key2 — NOT NULL