title11
Tables (6)
Comment (댓글)
- commentid (Key) — Long — Primary key — NOT NULL
- postid (Key2) — Long — Foreign key → Post.postid — NOT NULL
- userId (Key22) — Long — Foreign key → Post.userId — NOT NULL
- content (Field) — VARCHAR
- createdAt (Field2) — VARCHAR
- likecount (Field3)
CommentLike (댓글좋아요)
- commentid (Key2) — Long — Foreign key → Comment.commentid — NOT NULL
- userId (Key3) — Long — Foreign key → User.userId — NOT NULL
Like (Untitled)
- postid (Key) — Long — Foreign key → Post.postid — NOT NULL
- userId (Key3) — Long — Foreign key → User.userId — NOT NULL
Post (게시글)
- postid (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.userId — NOT NULL
- title (Field) — VARCHAR
- content (Field2) — VARCHAR
- createdAt (Field3) — VARCHAR
- likecount (Field4)
Role (권한)
- user (Field)
- admin (Field2)
User (회원)
- userId (Key) — Long — Primary key — NOT NULL
- username (Field) — VARCHAR
- password (Field2) — VARCHAR
- createdAt (Field3) — DATE
- role (Field4) — VARCHAR