과제2번
테이블 (4)
class (Untitled2)
- class id (Key) — char(10) — 기본 키 — NOT NULL
- codenumber (Key2) — char(10) — 외래 키 → leports activity.codenumber — NOT NULL
- class time (Field) — char(5)
- registlation limit (Field2) — char(10)
- number of registerd member (Field3) — char(10)
- level (Field4) — char(10)
- classname (Field5)
- price (Field6)
- location (Field7)
- lecturer (Field8)
class-member (Untitled4)
- class id (Key) — char(10) — 외래 키 → class.class id — NOT NULL
- codenumber (Key2) — char(10) — 외래 키 → class.codenumber — NOT NULL
- member id (Key3) — char(10) — 외래 키 → member.member id — NOT NULL
leports activity (Untitled)
- codenumber (Key) — char(10) — 기본 키 — NOT NULL
- description (Field) — char(20)
- name (Field2) — char(10)
member (Untitled3)
- member id (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char(10)
- adress (Field2) — char(20)
- age (Field3) — char(10)
- birthdate (Field5)