dington

Tables (4)

BOARD (Untitled2)

  • boardId (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • comment (Field3) — List
  • boardImage (Field4) — List
  • time (Field5) — LocalDateTime
  • writer (Field6) — Long
  • status (Field7) — Enum

COMMENT (Untitled3)

  • commentID (Key) — Long — Primary key — NOT NULL
  • boardId (Key2) — Long — Foreign key → BOARD.boardId — NOT NULL
  • content (Field) — String
  • writer (Field2) — Long
  • time (Field3) — LocalDateTime
  • status (Field4) — Enum
  • subComment (Field5) — List

SUBCOMMENT (Untitled4)

  • subCommentID (Key) — Long — Primary key — NOT NULL
  • boardId (Key22) — Long — Foreign key → COMMENT.boardId — NOT NULL
  • commentID (Key2) — Long — Foreign key → COMMENT.commentID — NOT NULL
  • content (Field) — String
  • writer (Field2) — Long
  • time (Field3) — LocalDateTime
  • status (Field4) — Enum

USER (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • phoneNo (Field2) — String
  • email (Field3) — String
  • password (Field4) — String
  • nickname (Field5) — String
  • status (Field6) — Enum