Exe2_이명건

테이블 (6)

ACTIVITY (Untitled)

  • Act.code (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(15)
  • description (Field2) — text

CLASS (Untitled2)

  • classID (Key) — integer — 기본 키 — NOT NULL
  • name (Field) — char(15)
  • capacity (Field2) — integer(3)
  • Price (Field3) — char(10)
  • level (Field4) — text
  • description (Field5) — text
  • year (Field6) — char(4)
  • month (Field7) — char(2)
  • Act.code (Key2) — char(10) — 외래 키 → ACTIVITY.Act.code — NOT NULL

CLASS-TIME (Untitled6)

  • classID (Key) — integer — 외래 키 → CLASS.classID — NOT NULL
  • timeID (Key2) — integer — 외래 키 → TIME.timeID — NOT NULL

ENROLL (Untitled4)

  • memID (Key) — integer — 외래 키 → MEMBER.memID — NOT NULL
  • classID (Key2) — integer — 외래 키 → CLASS.classID — NOT NULL

MEMBER (Untitled3)

  • memID (Key) — integer — 기본 키 — NOT NULL
  • name (Field) — char(15)
  • adress (Field2) — char(50)
  • age (Field3) — char(3)
  • phone (Field4) — interger(10)

TIME (Untitled5)

  • timeID (Key) — integer — 기본 키 — NOT NULL
  • time (Field) — integer
  • Field2