team9
Tables (5)
COMMENT
- commentId (Key) — long — Primary key — NOT NULL
- postId (Key3) — long — Foreign key → POST.postId — NOT NULL
- content (Field) — String
- username (Field2) — boolean
LIKECOMMENT
- likepostId (Key) — long — Primary key — NOT NULL
- commentId (Key2) — long — Foreign key → COMMENT.commentId — NOT NULL
- postId (Key3) — long — Foreign key → COMMENT.postId — NOT NULL
- username (Field) — String
LIKEPOST
- likepostId (Key) — long — Primary key — NOT NULL
- postId (Key2) — long — Foreign key → POST.postId — NOT NULL
- username (Field) — String
POST
- postId (Key) — long — Primary key — NOT NULL
- title (Field) — text
- content (Field2) — String
- username (Field3) — String
USER
- userId (Key) — long — Primary key — NOT NULL
- username (Field1) — String
- password (Field2) — int
- role (Field3) — UserRoleEnum