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