과제제출

테이블 (9)

age (Untitled9)

  • ageID (Key) — 기본 키 — NOT NULL
  • description (Field)

book (Untitled4)

  • ISBN (Key) — 기본 키 — NOT NULL
  • title (Field)
  • author (Field2)
  • publisher (Field3)
  • ageID (Key2) — 외래 키 → age.ageID — NOT NULL

child (Untitled2)

  • childID (Key) — 기본 키 — NOT NULL
  • name (Field2)
  • birthday (Field)
  • ageID (Key3) — 외래 키 → age.ageID — NOT NULL
  • memberID (Key2) — 외래 키 → member.memberID — NOT NULL

ggurumi (Untitled6)

  • ggurumiID (Key) — 기본 키 — NOT NULL
  • childID (Key2) — 외래 키 → child.childID — NOT NULL
  • ISBN (Key3) — 외래 키 → book.ISBN — NOT NULL

member (Untitled)

  • memberID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • birthday (Field3)
  • phone (Field4)
  • address (Field5)
  • ageID (Key2) — 외래 키 → age.ageID — NOT NULL

member_program (Untitled7)

  • mpID (Key) — 기본 키 — NOT NULL
  • memberID (Key2) — 외래 키 → member.memberID — NOT NULL
  • programID (Key3) — 외래 키 → program.programID — NOT NULL

program (Untitled5)

  • programID (Key) — 기본 키 — NOT NULL
  • title (Field)
  • day (Field2)
  • starttime (Field3)
  • space (Field4)
  • runtime (Field5)

volunteer_lecturer (Untitled3)

  • vlID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • role (Field2)
  • description (Field5)
  • phone (Field3)
  • accountnumber (Field6)
  • bank (Field4)

volunteer_lecturer_program (Untitled8)

  • vlpID (Key) — 기본 키 — NOT NULL
  • programID (Key3) — 외래 키 → program.programID — NOT NULL
  • vlID (Key2) — 외래 키 → volunteer_lecturer.vlID — NOT NULL