example01

테이블 (9)

Author (Untitled4)

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

Book (Untitled2)

  • book_id (PK) — 기본 키 — NOT NULL
  • publisher_id (FK) — 외래 키 → Publisher(출판사).publisher_id — NOT NULL
  • book_title (Field)
  • count(책 재고) (Field2)
  • price (Field3)

Book_Author (Untitled3)

  • Book_Author_id (Key) — 기본 키 — NOT NULL
  • book_id (Key2) — 외래 키 → Book.book_id — NOT NULL
  • author_id (Key3) — 외래 키 → Author.author_id — NOT NULL
  • publisher_id (Key22) — 외래 키 → Book.publisher_id — NOT NULL

Book_Category (Untitled7)

  • book_category_id (PK) — 기본 키 — NOT NULL
  • category_id (FK) — 외래 키 → Category.category_id — NOT NULL
  • book_id (FK1) — 외래 키 → Book.book_id — NOT NULL
  • publisher_id (FK2) — 외래 키 → Book.publisher_id — NOT NULL

Category (Untitled6)

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

Loan(기록으로봐야함) (Untitled8)

  • loan_id (Key) — 기본 키 — NOT NULL
  • member_id (FK) — 외래 키 → Member.member_id — NOT NULL
  • loan_start_at (Field)
  • loan_end_at (Field2)
  • due_date(마감일) (Field3)

Loan_Book (Untitled9)

  • loan_book_id (Key) — 기본 키 — NOT NULL
  • loan_id (Key2) — 외래 키 → Loan(기록으로봐야함).loan_id — NOT NULL
  • book_id (PK) — 외래 키 → Book.book_id — NOT NULL
  • publisher_id (FK2) — 외래 키 → Book.publisher_id — NOT NULL
  • count (Field)

Member (Untitled)

  • member_id (Key) — 기본 키 — NOT NULL
  • member_name (Field)
  • email (Field2)

Publisher(출판사) (Untitled5)

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