ERD Exercise 2(여영규)
테이블 (4)
CLASS (클래스)
- ClassId (Key) — char(10) — 기본 키 — NOT NULL
- ClassActivityCode (Field) — char(10)
- ClassTime (Field2) — char(30)
- ClassLimitNumber (Field3) — char(5)
- ClassPresentNumber (Field4) — char(5)
- MemberId (Key2) — char(10) — 외래 키 → Member.MemberId — NOT NULL
- ActivityCode (Key3) — char(10) — 외래 키 → LEPORTS ACTIVITY.ActivityCode — NOT NULL
LEPORTS ACTIVITY (레포츠활동)
- ActivityCode (Key) — char(10) — 기본 키 — NOT NULL
- ActivityName (Field) — text
- ActivityDescription (Field2) — char(10)
- ClassId (Key2) — char(10) — 외래 키 → CLASS.ClassId — NOT NULL
- MemberId (Key3) — char(10) — 외래 키 → Member.MemberId — NOT NULL
LEVEL_TEST (난이도레벨)
- level (Key) — char(2) — 기본 키 — NOT NULL
- ClassId (Key2) — char(10) — 외래 키 → CLASS.ClassId — NOT NULL
- MemberId (Key3) — char(10) — 외래 키 → Member.MemberId — NOT NULL
Member (회원)
- MemberId (Key) — char(10) — 기본 키 — NOT NULL
- MemberName (Field) — char(10)
- MemberAddress (Field2) — text
- MemberAge (Field3) — char(5)