book-project

Tables (3)

Author (author)

  • id (기본키) — BIGINT — Primary key — NOT NULL
  • gender (성별) — VARCHAR
  • introducer (소개) — VARCHAR

Book (book)

  • id (기본키) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR
  • price (가격) — INT
  • publisher_id (출판사ID) — BIGINT(FK) — Foreign key → Publisher.id — NOT NULL
  • author_id (작가ID) — BIGINT(FK) — Foreign key → Author.id — NOT NULL

Publisher (publisher)

  • id (기본키) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR
  • email (이메일) — VARCHAR
  • address (주소) — VARCHAR
  • description (설명) — VARCHAR