도서관
테이블 (5)
AUTHOR (Untitled3)
- authorID (Key) — char(15) — 기본 키 — NOT NULL
- name (Field) — char(15)
- birthday (Field2) — char(15)
- description (Field3) — text
BOOK (Untitled)
- bookID — char(15) — 기본 키 — NOT NULL
- title (Field) — char(30)
- author (Field3) — char(15)
- price (Field5) — char(10)
- purchaseDate (Field6) — date
- KDC (Field4) — char(30)
- ISBN (Field2) — char(15)
- bmlID (Key) — int(15) — 외래 키 → BOOK_MEMBER.bmlID — NOT NULL
- balID (Key2) — int(10) — 외래 키 → BOOK_AUTHOR.balID — NOT NULL
- bmlID (Key3) — int(15) — 외래 키 → BOOK_MEMBER.bmlID — NOT NULL
BOOK_AUTHOR (Untitled2)
- balID (Key) — int(10) — 기본 키 — NOT NULL
- bookID (Field) — char(15)
- authorID (Field2) — char(15)
- role (Field3) — char(30)
- authorID (Key2) — char(15) — 외래 키 → AUTHOR.authorID — NOT NULL
BOOK_MEMBER (Untitled4)
- bmlID (Key) — int(15) — 기본 키 — NOT NULL
- bookID (Field) — char(15)
- loanDate (Field2) — date
- returnDate (Field3) — date
- ssn (Key2) — char(15) — 외래 키 → MEMBER.ssn — NOT NULL
MEMBER (Untitled5)
- ssn (Key) — char(15) — 기본 키 — NOT NULL
- name (Field) — char(15)
- address (Field2) — char(30)
- phone (Field3) — char(15)
- joindateField4 (Field4) — date