book_project

Tables (3)

Author (author)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Name (name) — VARCHAR(20)
  • Introduction (introduction) — VARCHAR(400)
  • Email (email) — VARCHAR(50)
  • Gender (gender) — Enum

Book (book)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Publisher ID (publisher_id) — BIGINT — Foreign key → Publisher.ID — NOT NULL
  • Author ID (author_id) — BIGINT — Foreign key → Author.ID — NOT NULL
  • Title (title) — VARCHAR(20)
  • Price (price) — INT

Publisher (publisher)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Name (name) — VARCHAR(20)
  • detail — VARCHAR(400)
  • Business Number (business_num) — INT
  • 논리설계 (물리설계)