FinalProject
Tables (6)
CAREER (Untitled5)
- chID (Key) — char(3) — Primary key — NOT NULL
- career1 (Field) — char(10)
- career2 (Field2) — char(10)
- hobby1 (Field3) — char(10)
- hobby2 (Field4) — char(10)
- memberID (Key2) — char(3) — Foreign key → MEMBER.memberID — NOT NULL
CLASS (Untitled4)
- classID (Key) — char(10) — Primary key — NOT NULL
- className (Field) — char(10)
- classTime (Field2) — char(20)
- classDate (Field3) — char(20)
- classMemberlimit (Field4) — char(10)
- classMembercount (Field5) — char(10)
- zoneID (Key2) — char(3) — Foreign key → ZONE.zoneID — NOT NULL
MEMBER (Untitled2)
- memberID (Key) — char(3) — Primary key — NOT NULL
- memberName (Field) — char(10)
- gender (Field2) — char(2)
- age (Field5) — char(2)
- schoolName (Field3) — char(10)
- memberPhone (Field4) — char(11)
- memberEmail (Field6) — char(20)
TEACHER (Untitled6)
- tcID (Key) — char(3) — Primary key — NOT NULL
- tcName (Field) — char(10)
- major (Field2) — char(10)
- phone (Field3) — char(11)
- classID (Key2) — char(10) — Foreign key → CLASS.classID — NOT NULL
ZONE (Untitled)
- zoneID (Key) — char(3) — Primary key — NOT NULL
- zoneName (Field) — char(10)
- zoneexpanation (Field2) — char(100)
ZONE_USETIME (Untitled3)
- zone_usetimeID (Key) — char(3) — Primary key — NOT NULL
- zone_usetime (Field) — char(10)
- memberID (Key2) — char(3) — Foreign key → MEMBER.memberID — NOT NULL
- zoneID (Key3) — char(3) — Foreign key → ZONE.zoneID — NOT NULL