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(