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)