board

Tables (5)

board (게시글)

  • id (아이디) — INT — Primary key — NOT NULL
  • User (유저) — INT — Foreign key → user.id — NOT NULL
  • Title (제목) — VARCHAR
  • Date (날짜) — LOCALDATE
  • Content (내용) — VARCHAR

boardCorrection (게시글 수정)

  • id (게시글 수정) — INT — Primary key — NOT NULL
  • id (아이디) — INT — Foreign key → board.id — NOT NULL
  • id (유저) — INT — Foreign key → board.User — NOT NULL
  • Title (제목) — VARCHAR
  • Date (날짜) — LOCALDATE
  • Content (내용) — VARCHAR

image (사진)

  • id (사진) — INT — Primary key — NOT NULL
  • image (이미지) — IMAGE
  • id (아이디) — INT — Foreign key → board.id — NOT NULL
  • id (유저) — INT — Foreign key → board.User — NOT NULL

uesrConrrection (유저 수정)

  • id (유저수정) — INT — Primary key — NOT NULL
  • id (유저2) — INT — Foreign key → user.id — NOT NULL
  • UserId (아이디) — VARCHAR
  • PasssWord (비밀번호) — 256
  • CorrectionDate (수정일) — LOCALDATE

user (유저)

  • id (유저) — INT — Primary key — NOT NULL
  • UserId (아이디) — String
  • PassWord (비밀번호) — 256
  • CreationDate (생성일) — LOCALDATE
  • NumberOfPost (게시글의 수) — INT