Board

Tables (3)

COMMENT (comment)

  • COMMENT_ID (comment_id) — Long — Primary key — NOT NULL
  • CONTENT (content) — VARCHAR(255)
  • GOOD (good) — INT
  • POST_ID (post_id) — Long — Foreign key → POST.POST_ID — NOT NULL
  • USERS_ID (users_id) — Long — Foreign key → USERS.USERS_ID — NOT NULL

POST (post)

  • POST_ID (post_id) — Long — Primary key — NOT NULL
  • TITLE (title) — VARCHAR(255)
  • CONTENTS (contents) — VARCHAR(255)
  • GOOD (good) — INT
  • USERS_ID (users_id) — Long — Foreign key → USERS.USERS_ID — NOT NULL

USERS (users)

  • USERS_ID (users_id) — Long — Primary key — NOT NULL
  • USERNAME (username) — VARCHAR(10)
  • PASSWORD (password) — VARCHAR(15)
  • ROLE (role) — VARCHAR(255)