도서 대출 관리 시스템

테이블 (9)

Book (Untitled2)

  • Book_id (PK) — 기본 키 — NOT NULL
  • book_name (Field)
  • book_count (Field4)
  • book_pubdate (Field5)
  • publish_id (pk) — 외래 키 → publish.publish_id — NOT NULL

Member (Untitled)

  • member_id (PK) — 기본 키 — NOT NULL
  • member_name (varchar)
  • member_phone (FIELD)
  • member_address (Field)
  • member_joinmembership_date (Field2)
  • member_age (Field3)

author (Untitled4)

  • author_id (Key) — 기본 키 — NOT NULL
  • author_name (varchar)

book_author (Untitled6)

  • Book_id (PK) — 외래 키 → Book.Book_id — NOT NULL
  • author_id (Key) — 외래 키 → author.author_id — NOT NULL

book_category (Untitled8)

  • category_id (pk) — 외래 키 → category.category_id — NOT NULL
  • Book_id (PK) — 외래 키 → Book.Book_id — NOT NULL

category (Untitled7)

  • category_id (pk) — 기본 키 — NOT NULL
  • category_name (Field)

loan (Untitled3)

  • loan_id (pk) — 기본 키 — NOT NULL
  • member_id (PK) — 외래 키 → Member.member_id — NOT NULL
  • loan_start_at (Field)
  • loan_end_at (Field2)
  • due_date (Field3)

loan_book (Untitled9)

  • id (pk) — 기본 키 — NOT NULL
  • loan_id (pk2) — 외래 키 → loan.loan_id — NOT NULL
  • Book_id (PK) — 외래 키 → Book.Book_id — NOT NULL
  • count (Field)

publish (Untitled5)

  • publish_id (pk) — 기본 키 — NOT NULL
  • publish_name (Field)