board_task

Tables (4)

BOARD (Untitled)

  • boardId (Key) — Long — Primary key — NOT NULL
  • userId (Key3) — Lomg — Primary key — NOT NULL
  • commentId (Key2) — Long — Foreign key → USER.userId — NOT NULL
  • title (Field) — String
  • content (Field4) — String
  • createdAt (Field5) — String
  • modifiedAt (Field6) — String
  • heartCnt (Field2) — int
  • commentCnt (Field3) — int
  • isLiked (Field7) — Integer
  • locked (Field8) — Boolean

COMMENT (CopyOfUntitled2)

  • commentId (Key2) — Long — Primary key — NOT NULL
  • boardId (Key) — Long — Foreign key → BOARD.boardId — NOT NULL
  • userId (Key3) — Long — Foreign key → USER.userId — NOT NULL
  • comment (Field) — String
  • createdAt (Field2) — String
  • modifiedAt (Field3) — String

HEART (CopyOfCopyOfUntitled)

  • heartId (Key) — Long — Primary key — NOT NULL
  • boardId (Key3) — Long — Foreign key → BOARD.boardId — NOT NULL
  • userId (Field) — Long

USER (CopyOfUntitled)

  • userId (Key) — Long — Primary key — NOT NULL
  • username (Field) — String
  • nickname (Field2) — String
  • password (Field3) — String