0429_KDTstudy

Tables (8)

Author (저자)

  • author_id (PK) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR

Author-book (책-저자)

  • id (Key) — Primary key — NOT NULL
  • author_id (PK) — INT — Foreign key → Author.author_id — NOT NULL
  • book_id (PK2) — INT — Foreign key → Book.book_id — NOT NULL

Book (도서)

  • book_id (PK) — INT — Primary key — NOT NULL
  • Publisher_id (Key2) — INT — Foreign key → Publisher.Publisher_id — NOT NULL
  • title (Field) — VARCHAR
  • count (Field3) — INT

Borrow_list (대여목록)

  • idx (PK) — INT — Primary key — NOT NULL
  • member_id (FK1) — INT — Foreign key → Member.member_id — NOT NULL
  • book_id (FK2) — INT — Foreign key → Book.book_id — NOT NULL
  • Publisher_id (Key2) — INT — Foreign key → Book.Publisher_id — NOT NULL
  • d_day (Field2) — INT
  • borrow_date (Field3) — DATE
  • fee (Field) — INT
  • Field4

Category (장르)

  • category_id (PK) — INT — Primary key — NOT NULL
  • category (Field) — VARCHAR

Category-Book (책-장르)

  • id (Key) — INT — Primary key — NOT NULL
  • book_id (PK) — INT — Foreign key → Book.book_id — NOT NULL
  • category_id (PK2) — INT — Foreign key → Category.category_id — NOT NULL

Member (회원)

  • member_id (PK) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • tel (Field2) — VARCHAR
  • sex (Field3) — VARCHAR
  • age (Field4) — INT

Publisher (출판사)

  • Publisher_id (Key) — INT — Primary key — NOT NULL
  • publisher (Field) — VARCHAR