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