3.20과제ERD ex2

테이블 (8)

ACTIVITY (Untitled)

  • actCode (Key) — char(10) — 기본 키 — NOT NULL
  • actName (Field) — char(20)
  • description (Field2) — text
  • Field3

CLASS (Untitled2)

  • classId (Key) — char(10) — 기본 키 — NOT NULL
  • className (Field) — char(20)
  • time (Field2) — char(50)
  • classCize (Field3) — int(3)
  • level (Field4) — char(4)
  • lecturer (Field5) — char(10)
  • price (Field6) — int(6)
  • location (Field7) — char(20)
  • actCode (Key2) — char(10) — 외래 키 → ACTIVITY.actCode — NOT NULL

CLASS_TIME (Untitled5)

  • timeID (Key3) — char(6) — 외래 키 → TIME.timeID — NOT NULL
  • monclaID (Key) — char(10) — 외래 키 → MONTH_CLASS.monclaID — NOT NULL

ENROLL (Untitled4)

  • memId (Key2) — har(10) — 외래 키 → MEMBER.memId — NOT NULL
  • classId (Key3) — char(10) — 외래 키 → CLASS.classId — NOT NULL

LECTURER (Untitled7)

  • lectureID (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(50)
  • phone (Field3) — char(11)
  • description (Field4) — text

MEMBER (Untitled3)

  • memId (Key) — har(10) — 기본 키 — NOT NULL
  • memName (Field) — char(20)
  • address (Field2) — char(50)
  • phone (Field3) — char(11)
  • birthDate (Field4) — date
  • gender (Field5) — char(1)

MONTH_CLASS (Untitled8)

  • monclaID (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • year (Field2) — char(4)
  • month (Field3) — char(2)
  • classId (Key2) — char(10) — 외래 키 → CLASS.classId — NOT NULL
  • lectureID (Key3) — char(10) — 외래 키 → LECTURER.lectureID — NOT NULL

TIME (Untitled6)

  • timeID (Key) — char(6) — 기본 키 — NOT NULL
  • time (Field) — char(4(