car
Tables (9)
Comment
- Comment_ID — INT
- Post_ID — INT — NOT NULL
- User_ID — INT — NOT NULL
- Comment_Content — TEXT — NOT NULL
- Created_At — TIMESTAMP
- Updated_At — TIMESTAMP
- Deleted_At — TIMESTAMP
- TotalLike — INT
- parent_comment_id — int
- mention_user_id — int
CommentLike
- Comment_ID — INT — Primary key — NOT NULL
- User_ID — INT — Primary key — NOT NULL
- Like_Status — BOOLEAN
EmailVerification
- User_ID — INT — Primary key — NOT NULL
- Email — VARCHAR(255) — Primary key — NOT NULL
- Verification_Code — VARCHAR(10) — NOT NULL
- Purpose — ENUM('signup', 'reset')
- Created_At — TIMESTAMP
- Is_Verified — BOOLEAN
Post
- Post_ID — INT
- Post_Title — VARCHAR(100) — NOT NULL
- Post_Content — TEXT — NOT NULL
- User_ID — INT — NOT NULL
- Created_At — TIMESTAMP
- Updated_At — TIMESTAMP
- Deleted_At — TIMESTAMP
- TotalCount — INT
- TotalLike — INT
PostLike
- Post_ID — INT — Primary key — NOT NULL
- User_ID — INT — Primary key — NOT NULL
- Like_Status — BOOLEAN
Term
- Term_Code — VARCHAR(10)
- Term_Content — TEXT — NOT NULL
User
- User_ID — INT
- Nickname — VARCHAR(50) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- Email — VARCHAR(255) — NOT NULL
- Phone — VARCHAR(20)
- Name — VARCHAR(50) — NOT NULL
- Created_At — TIMESTAMP
UserTerm
- User_ID — INT — Primary key — NOT NULL
- Term_Code — VARCHAR(10) — Primary key — NOT NULL
- Is_Agreed — BOOLEAN
- Created_At — TIMESTAMP
- Updated_At — TIMESTAMP
WithdrawnUser
- User_ID — INT
- Deleted_At — TIMESTAMP