ERD Final report(여영규)
테이블 (4)
AUTHOR (Untitled3)
- authorID (Key) — char(20) — 기본 키 — NOT NULL
- bookISBN (Key2) — char(20) — 외래 키 → BOOK.bookISBN — NOT NULL
- authorName (Field) — char(20)
BOOK (Untitled)
- bookISBN (Key) — char(20) — 기본 키 — NOT NULL
- bookName (Field) — char(50)
- bookPublisherdate (Field2) — date
- bookPublisher (Field3) — char(20)
- studentID (Key2) — char(10) — 외래 키 → STUDENT.studentID — NOT NULL
RENT (Untitled5)
- rentNumber (Key) — char(10) — 기본 키 — NOT NULL
- rentDate (Field) — date
- rentTime (Field2) — time
- bookISBN (Key3) — char(20) — 외래 키 → BOOK.bookISBN — NOT NULL
STUDENT (Untitled2)
- studentID (Key) — char(10) — 기본 키 — NOT NULL
- studentName (Field) — char(20)
- studentDept (Field2) — char(30)
- studentYear (Field3) — int(3)
- studentPhone (Field4) — char(10)
- studentAddress (Field5) — text