도서관리시스템

테이블 (9)

Author (Untitled2)

  • author_id (PK) — int — 기본 키 — NOT NULL
  • author_name (Field) — String
  • Field2

Author_Book (Untitled3)

  • wite_book_id (Key) — int — 기본 키 — NOT NULL
  • author_id (FK) — int — 외래 키 → Author.author_id — NOT NULL
  • book_id (FK2) — int — 외래 키 → Book.book_id — NOT NULL
  • publisher_id (Key3) — int — 외래 키 → Book.publisher_id — NOT NULL
  • Field

Book

  • book_id (PK) — int — 기본 키 — NOT NULL
  • publisher_id (FK2) — int — 외래 키 → Publisher.publisher_id — NOT NULL
  • book_title — varchar
  • published_date (publication_date) — datetime
  • book_genre (Field5) — String
  • location (Field2)
  • reservation_available (Field) — boolean
  • Field3

Genre (Untitled5)

  • genre_id (Key) — int — 기본 키 — NOT NULL
  • Field

Genre_Book (Untitled)

  • genre_book_id (Key) — int — 기본 키 — NOT NULL
  • book_id (PK) — int — 외래 키 → Book.book_id — NOT NULL
  • publisher_id (FK2) — int — 외래 키 → Book.publisher_id — NOT NULL
  • genre_id (Key2) — int — 외래 키 → Genre.genre_id — NOT NULL
  • Field

Member

  • member_id (PK) — int — 기본 키 — NOT NULL
  • member_name — varchar
  • phone — String
  • e-mail (adress) — String
  • adress (grade) — String
  • Field3

Publisher (Untitled4)

  • publisher_id (Key) — int — 기본 키 — NOT NULL
  • Field

Rent_book (Rental)

  • rent_book_id (Key) — int — 기본 키 — NOT NULL
  • rental_id (PK2) — int — 외래 키 → Rental_System.rental_id — NOT NULL
  • book_id (PK) — int — 외래 키 → Book.book_id — NOT NULL
  • publisher_id (FK2) — int — 외래 키 → Book.publisher_id — NOT NULL
  • Field

Rental_System (RentalSystem)

  • rental_id (PK) — int — 기본 키 — NOT NULL
  • member_id (FK) — int — 외래 키 → Member.member_id — NOT NULL
  • rental_date (retal_date) — datetime
  • return_date — datetime
  • extension — datetime
  • Field4