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