개인 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