board

Tables (3)

Comment

  • id — bigint — Primary key — NOT NULL
  • post_id — bigint — Foreign key → Post.id — NOT NULL
  • author_id — bigint — Foreign key → Member.id — NOT NULL
  • content — varchar
  • created_date — datetime
  • modified_date — datetime

Member

  • id — bigint — Primary key — NOT NULL
  • username — varchar
  • password — varchar
  • nickname — varchar
  • created_date — datetime
  • modified_date — datetime

Post

  • id — bigint — Primary key — NOT NULL
  • author_id — bigint — Foreign key → Member.id — NOT NULL
  • title — varchar
  • content — text
  • created_date — datetime
  • modified_date — datetime