mini
Tables (4)
comment (Untitled3)
- commentId (Key) — Long — Primary key — NOT NULL
- postId (Key2) — Long — Foreign key → post.postId — NOT NULL
- userId (Key3) — Long — Foreign key → user.userId — NOT NULL
- comment (Field) — String
- username (Field2) — String
- createdAt (Field3) — String
post (Untitled2)
- postId (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → user.userId — NOT NULL
- title (Field) — String
- username (Field2) — String
- artist (Field3) — String
- genre (Field4) — String
- contents (Field5) — String
- image (Field6) — String
- video (Field7) — String
- likeCnt (Field8) — Long
- createdAt (Field9) — String
- modifiedAt (Field10) — String
postLike (Untitled4)
- likeId (Key) — Long — Primary key — NOT NULL
- postId (Key2) — Long — Foreign key → post.postId — NOT NULL
- userId (Key3) — Long — Foreign key → user.userId — NOT NULL
user (Untitled)
- userId (Key) — Long — Primary key — NOT NULL
- username (Field) — String
- password (Field2) — String