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)