데이타베이스 과제
테이블 (6)
CAREER (Untitled5)
- chID (Key2) — char(3) — 기본 키 — NOT NULL
- career1 (Field2) — char(10)
- career2 (Field3) — char(10)
- hobby1 (Field4) — char(10)
- hobby2 (Field5) — char(10)
- memberID (Key) — char(3) — 외래 키 → MEMBER.memberID — NOT NULL
MEMBER (Untitled2)
- memberID (Key) — char(3) — 기본 키 — NOT NULL
- memberName (Field) — char(10)
- gender (Field3) — char(2)
- age (Field2) — char(2)
- schoolName (Field6) — char(10)
- memberPhone (Field5) — char(11)
- memberEmail (Field4) — char(20)
PASSIVE_PROGRAM (Untitled)
- ppID (Key) — char(10) — 기본 키 — NOT NULL
- ppName (Field2) — char(10)
- ppTime (Field) — char(20)
- ppDate (Field3) — char(20)
- ppMemberlimit (Field4) — char(10)
- ppMembercount (Field5) — char(10)
- zoneID (Key2) — char(3) — 외래 키 → ZONE.zoneID — NOT NULL
TEACHER (Untitled4)
- tcID (Key) — char(3) — 기본 키 — NOT NULL
- tcName (Field) — char(10)
- major (Field4) — char(10)
- phone (Field3) — char(11)
- ppID (Key2) — char(10) — 외래 키 → PASSIVE_PROGRAM.ppID — NOT NULL
ZONE (Untitled3)
- zoneID (Key) — char(3) — 기본 키 — NOT NULL
- zonName (Field) — char(10)
- zoneExplanation (Field2) — char(100)
ZONE_USETIME (Untitled6)
- zone_usetimeID (Field2) — char(3) — 기본 키
- zone_usetime (Field) — char(10)
- memberID (Key) — char(3) — 외래 키 → MEMBER.memberID — NOT NULL
- zoneID (Key2) — char(3) — 외래 키 → ZONE.zoneID — NOT NULL