project_1

테이블 (9)

Author

  • AuthorID — INT — 기본 키 — NOT NULL
  • Name — VARCHAR(100)
  • Phone — VARCHAR(15)

Book_Author

  • BookID — INT
  • AuthorID — INT

Book_Field

  • BookID — INT
  • FieldID — INT

Customer

  • CustomerID — INT
  • Name — VARCHAR(100)
  • Phone — VARCHAR(15)

Field

  • FieldID — INT
  • FieldName — VARCHAR(100)
  • Description — TEXT

Publisher

  • PublisherName — VARCHAR(100)
  • CEO — VARCHAR(100)
  • Phone — VARCHAR(15)

Purchase

  • PurchaseID — INT
  • CustomerID — INT
  • BookID — INT
  • PurchaseDate — DATE
  • RefundableUntil — DATE

Review

  • ReviewID — INT
  • PurchaseID — INT
  • Rating — INT
  • Comment — TEXT — EX

서적 (Book)

  • BookID — INT — 기본 키 — NOT NULL
  • Title — VARCHAR(200)
  • Price — DECIMAL(10, 2)
  • PublicationYear — YEAR
  • PublisherName — VARCHAR(100)