실습2

테이블 (4)

Activity (Untitled)

  • ActCode (Key) — Char(10) — 기본 키 — NOT NULL
  • ActDsc (Field)

Class (Untitled2)

  • classCode (Key) — Char(10) — 기본 키 — NOT NULL
  • workingHour (Field)
  • limNum (Field2) — int(3)
  • currentLimNum (Field3) — int(3)
  • Level (Field4) — Char(4)
  • ActCode (Key3) — Char(10) — 외래 키 → Activity.ActCode — NOT NULL

Member (Untitled4)

  • memID (Key) — char(10) — 기본 키 — NOT NULL
  • memAdr (Field) — char(30)
  • memAge (Field2) — int(3)
  • memName (Field3) — char(10)

Register (Untitled3)

  • memID (Key) — char(10) — 외래 키 → Member.memID — NOT NULL
  • classCode (Key2) — Char(10) — 외래 키 → Class.classCode — NOT NULL