exercise2 모범

테이블 (5)

ACTIVITY (Untitled)

  • activityID (Key) — char(10) — 기본 키 — NOT NULL
  • activityName (Field) — char(30)
  • description (Field2) — longtxt

CLASS (Untitled2)

  • classID (Key) — char(30) — 기본 키 — NOT NULL
  • className (Field) — char(30)
  • time (Field3) — char(30)
  • price (Field4) — int
  • level (Field5) — char(10)
  • memberLimited (Field6) — int
  • year (Field2) — int(4)
  • month (Field7) — int(2)
  • activityID (Key2) — char(10) — 외래 키 → ACTIVITY.activityID — NOT NULL
  • lecturerID (Key3) — char(10) — 외래 키 → LECTURER.lecturer — NOT NULL

ENROLL (Untitled3)

  • memberID (Key2) — char(10) — 외래 키 → MEMBER.memberID — NOT NULL
  • classID (Key3) — char(30) — 외래 키 → CLASS.classID — NOT NULL
  • paymentYN (Field) — char

LECTURER (Untitled5)

  • lecturer (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • phone (Field2) — char(15)
  • address (Field3) — char(50)
  • grade (Field4)
  • description (Field5) — longtxt

MEMBER (Untitled4)

  • memberID (Key) — char(10) — 기본 키 — NOT NULL
  • mamberName (Field) — char(30)
  • address (Field2) — char(50)
  • phone (Field3) — char(15)
  • email (Field4) — char(20)
  • birthDate (Field5) — date