데이타베이스 과제

테이블 (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