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