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)