2024_04_ERD 중간고사 대체과제
테이블 (6)
BOOK
- Key (book_isbn) — int(30) — 기본 키 — NOT NULL
- Field (book_name) — char(30)
- Field (book_summary) — char(500)
- Field (book-regdate) — date
- Key (author_codeid) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOKRENT)
- Key (rent_id) — int(10) — 기본 키 — NOT NULL
- Key (book_isbn) — int(30) — 외래 키 → BOOK.Key — NOT NULL
- Field (rent_date) — date
- Field (rent_returndate) — date
- Field (rent-status) — char(5)
- Key (user_id) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOK_PUBLISHER)
- Key (publisher_id) — int(20) — 기본 키 — NOT NULL
- Key (author_codeid) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (publisher_name) — char(10)
- Field (puslisher-address) — char(30)
- Field (puslisher_phone) — char(11)
- Key (book_isbn) — int(30) — 외래 키 → BOOK.Key — NOT NULL
Untitled (BOOK_AUTHOR)
- Key (author_codeid) — int(10) — 기본 키 — NOT NULL
- Field (author_name) — char(20)
- Field (author_address) — char(30)
Untitled (USER)
- Key (user_id) — int(10) — 기본 키 — NOT NULL
- Key (book_isbn) — int(30) — 외래 키 → BOOK.Key — NOT NULL
- Field (user_pw) — char(4)
- Field (user_name) — char(20)
- Field (user_grade) — char(3)
- Field (user_address) — char(30)
- Field (user_phone) — char(11)
- Field (user_email) — email
Untitled (BOOK_CATATEGORY)
- Key (cataegory_id') — int(30) — 기본 키 — NOT NULL
- Field (category_name) — char(30)
- Key (book_isbn) — int(30) — 외래 키 → BOOK.Key — NOT NULL
- Key (author_codeid) — int(10) — 외래 키 → Untitled.Key — NOT NULL