2연습
테이블 (4)
ACTIVITY
- actCode (code) — char(20) — 기본 키 — NOT NULL
- name — char(30)
- desoription (Field2) — int
CLASS
- classID — integer — 기본 키 — NOT NULL
- actCode (code2) — char(20) — 외래 키 → ACTIVITY.actCode — NOT NULL
- clsaaName (className) — char(30)
- year — integer(4)
- month — integer(2)
- level — char(2)
- description (price) — text
- price (description) — integer(10)
- actCode (code) — char(20) — 외래 키 → ACTIVITY.actCode — NOT NULL
- Key (lectuerID) — 외래 키 → Untitled.Key — NOT NULL
CLASS_TIME
- classID — integer — 외래 키 → CLASS.classID — NOT NULL
- Field (timeID) — int
Untitled (LECTURER)
- Key (lectuerID) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field2 (address) — int
- Field3 (phone)