blog

Tables (3)

Post

  • post_id — Long — Primary key — NOT NULL
  • board_id — Long — Foreign key → board.board_id — NOT NULL
  • user_id — Long — Foreign key → board.user_id — NOT NULL
  • title — String
  • content — String
  • parent_id — Long — Foreign key → Post.post_id — NOT NULL
  • created_date — DATE
  • modified_date — DATE

Users

  • user_id — Long — Primary key — NOT NULL
  • email — String
  • nickname — String
  • password — String
  • role — String
  • created_date — DATE
  • modified_date — DATE
  • is_active — Boolean

board

  • board_id — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → Users.user_id — NOT NULL
  • name — String
  • created_date — DATE
  • modified_date — DATE