Board-pjt
Tables (5)
Article
- Article_id (Int) — Not Null — Primary key — NOT NULL
- User_id (INT) — NOT NULL — Foreign key → User.User_id — NOT NULL
- Title (String) — Not Null
- Category (Field2) — Not Null
- Content (Field) — Not Null
- PublishDate (Field4) — Not Null
- UpdatedDate (Field5)
- Comment_count (Field6)
- Like_count (Field7)
Comment
- Comment_id (Int) — Not Null — Primary key — NOT NULL
- Article_id (Int2) — Not Null — Foreign key → Article.Article_id — NOT NULL
- User_id (INT2) — NOT NULL — Foreign key → Article.User_id — NOT NULL
- Content (Field2)
- PublishDate (Field3)
- UpdatedDate (Field4)
- Parent_Comment_id (Field6)
- User_id (INT) — NOT NULL — Foreign key → User.User_id — NOT NULL
Follow
- Follow_id (int) — Not Null — Primary key — NOT NULL
- Follower_id (INT) — NOT NULL — Foreign key → User.User_id — NOT NULL
- Followed_id (INT2) — NOT NULL — Foreign key → User.User_id — NOT NULL
Like
- Like_id (Key) — Primary key — NOT NULL
- User_id (INT2) — NOT NULL — Foreign key → User.User_id — NOT NULL
- Article_id (Int3) — Not Null — Foreign key → Article.Article_id — NOT NULL
- Comment_id (Int) — Not Null — Foreign key → Comment.Comment_id — NOT NULL
- Target_type (Field) — Article or Comment
- target_id (Field2) — id값
User
- User_id (INT) — NOT NULL — Primary key — NOT NULL
- email (dd) — Not Null
- password (Field2)
- level (Field)
- NickName (Field3)
- Visit_count (Field4)
- Article_count (Field5)
- Comment_count (Field6)
- Follower_count (Field7)
- Following_count (Field8)
- Created_at (Field9)
- Updated_at (Field10)