MyBoard

Tables (3)

COMMENT

  • 댓글ID (comment_id) — BIGINT — Primary key — NOT NULL
  • 유저ID (writer_id) — BIGINT — Foreign key → MEMBER.유저ID — NOT NULL
  • 생성시간 (created_date) — TIMESTAMP — NOT NULL
  • 최종수정날짜 (last_modified_date) — TIMESTAMP — NOT NULL
  • content — CLOB — NOT NULL
  • is_removed — TINYINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • 댓글ID (parent_id) — BIGINT — Foreign key → COMMENT.댓글ID — NOT NULL

MEMBER (Member)

  • 유저ID (member_id) — BIGINT — Primary key — NOT NULL
  • 생성시간 (created_date) — TIMESTAMP — NOT NULL
  • 최종수정날짜 (last_modified_date) — TIMESTAMP — NOT NULL
  • 나이 (Field) — INT — NOT NULL
  • 이름 (Field2) — VARCHAR(30) — NOT NULL
  • 닉네임 (nick_name) — VARCHAR(30) — NOT NULL
  • 아이디 (username) — VARCHAR(30) — NOT NULL
  • 비밀번호 (password) — VARCHAR(255) — NOT NULL
  • 권한 (role) — VARCHAR(15) — NOT NULL
  • 리프레쉬토큰 (refresh_token) — VARCHAR(1000) — NOT NULL

POST

  • 게시물ID (post_id) — BIGINT — Primary key — NOT NULL
  • 유저ID (writer_id) — BIGINT — Foreign key → MEMBER.유저ID — NOT NULL
  • 생성시간 (created_date) — TIMESTAMP — NOT NULL
  • 최종수정날짜 (last_modified_date) — TIMESTAMP — NOT NULL
  • content — CLOB — NOT NULL
  • file_path — VARCHAR(255)
  • title — VARCHAR(40) — NOT NULL