04번 김도영Final Project
테이블 (9)
BOOK (Untitled)
- isbn (Key) — char(13) — 기본 키 — NOT NULL
- booktitle (Field) — char(50)
- author (Field8) — char(50)
- kor_6th (Field2) — char(20)
- pubYear (Field3) — int(04)
- type (Field4) — char(50)
- expression (Field5) — char(3)
- description (Field7) — char(100)
- libraryID (Key2) — int(30) — 외래 키 → LIBRARY.libraryID — NOT NULL
- workId (Key3) — int(30) — 외래 키 → WORK.workId — NOT NULL
CLASSIFICATION (Untitled9)
- classificationId (Key) — int(10) — 기본 키 — NOT NULL
- classificationTitle (Field) — char(30)
CLIENT (Untitled2)
- clientId (Key) — int(100) — 기본 키 — NOT NULL
- name (Field) — char(30)
- phone (Field2) — int(30)
- email (Field3) — char(30)
- address (Field4) — char(30)
LIBRARY (Untitled5)
- libraryID (Key) — int(30) — 기본 키 — NOT NULL
- libraryname (Field) — char(30)
RENT (Untitled7)
- rentId (Key) — int(100) — 기본 키 — NOT NULL
- rentDate (Field) — date
- returnDate (Field2) — date
- isbn (Key2) — char(13) — 외래 키 → BOOK.isbn — NOT NULL
- clientId (Key3) — int(100) — 외래 키 → CLIENT.clientId — NOT NULL
SCIENCEMUSEUM (Untitled6)
- sciencemuseumId (Key) — int(30) — 기본 키 — NOT NULL
- sciencemuseumName (Field) — char(50)
SCIENCEVIDEO (Untitled3)
- videoId (Key) — int(10) — 기본 키 — NOT NULL
- videotitle (Field) — char(50)
- releasedYear (Field2) — int(4)
- expression (Field3) — char(3)
- url (Field6) — text
- sciencemuseumId (Key2) — int(30) — 외래 키 → SCIENCEMUSEUM.sciencemuseumId — NOT NULL
- workId (Key3) — int(30) — 외래 키 → WORK.workId — NOT NULL
WORK (Untitled4)
- workId (Key) — int(30) — 기본 키 — NOT NULL
- workTitle (Field) — char(50)
WORK_CLASSIFICATION (Untitled8)
- workId (Key) — int(3) — 외래 키 → WORK.workId — NOT NULL
- classificationId (Key2) — int(10) — 외래 키 → CLASSIFICATION.classificationId — NOT NULL