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