SNS
Tables (4)
Comment (댓글)
- commentId (Key) — Primary key — NOT NULL
- userId (Key2) — Foreign key → User.userId — NOT NULL
- content (Field6)
- ref (Field)
- refOrder (Field2)
- step (Field3)
- parentNum (Field4)
- answerNum (Field5)
- createdAt (Field8)
- deletedAt (Field7)
Like (좋아요)
- likeId (Key3) — Primary key — NOT NULL
- postId (Key) — Foreign key → Post.postId — NOT NULL
- userId (Key2) — Foreign key → User.userId — NOT NULL
- createdAt (Field2)
- deletedAt (Field3)
Post (게시물)
- postId (Key) — Primary key — NOT NULL
- userId (Key2) — Foreign key → User.userId — NOT NULL
- title (Field)
- content (Field2)
- image (Field3)
- hashtag (Field4)
- createdAt (Field5)
- updatedAt (Field6)
User (사용자)
- userId (Key) — Primary key — NOT NULL
- email (Field)
- phone (Field2)
- image (Field3)
- introduce (Field4)
- createdAt (Field5)
- updatedAt (Field6)