guest-book-project

Tables (3)

book

  • book_id — bigint(20) — Primary key — NOT NULL
  • write_date — timestamp — NOT NULL
  • content — varchar(255) — NOT NULL
  • writer_nick — varchar(32) — NOT NULL
  • writer_password — varchar(255) — NOT NULL
  • Field (writeDate) — timestamp
  • Field2 (modifyDate) — timestamp
  • Field (deleteDate) — timestamp

tag

  • book_id — bigint(20) — Foreign key → book.book_id — NOT NULL
  • tag_item_id — bigint(20) — Foreign key → tag_item.tag_item_id — NOT NULL

tag_item

  • tag_item_id — bigint(20) — Primary key — NOT NULL
  • tag_item_text — varchar(32)