itbook

Tables (3)

book

  • 책 ID (Key) — Primary key — NOT NULL
  • title — VARCHAR(250) — NOT NULL
  • writer — VARCHAR(250) — NOT NULL
  • publisher — VARCHAR(250) — NOT NULL
  • price — INT — NOT NULL
  • pub_date — DATE — NOT NULL
  • summery — LONGTEXT — NOT NULL
  • content — LONGTEXT

comment

  • comment_id — INT — NOT NULL
  • content — LONGTEXT
  • 책 ID (book_id) — int — Foreign key → book.책 ID
  • Field

user

  • id — INT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL