newsFeed_Project

Tables (5)

Comments (Comment)

  • Contents (Content_Id) — Type — Primary key — NOT NULL
  • Commnet_Id (Id) — bigint
  • Newpeed_Id — bigint
  • User_Id — bigint
  • Comment — varchar
  • Good_Count (Good_count) — bigint
  • Write_Date — timestamp
  • Update_Date — timestamp
  • Contents (Content_Id2) — Type — Foreign key → Contents.Contents — NOT NULL

Contents

  • Contents (Content_Id) — Type — Primary key — NOT NULL
  • Contents_Id (Field) — bigint
  • Cheer — varchar
  • City_Restaurant — varchar
  • Club_Peed (Club_peed) — varchar
  • Match_Result (Match_ Result) — varchar
  • Proof_Shot (Proof_shot) — varchar
  • Player_News (Player_news) — varchar
  • Comment (Field2) — varchar
  • UserId (userId) — Type — Foreign key → User.UserId — NOT NULL

Good_Count (Untitled)

  • Good_Count (Key) — Type — Primary key — NOT NULL
  • Id (Field) — bigint
  • User_Id (Field2) — bigint
  • Contents_Id (Field3) — bigint
  • Contents_Type (Field4) — varchar
  • Write_Date (Field5) — timestamp
  • Update_Date (Field6) — timestamp
  • Contents (Content_Id) — Type — Foreign key → Comments.Contents — NOT NULL

User (user)

  • UserId (userId) — Type — Primary key — NOT NULL
  • Id — bigint
  • UserId (User_id) — varchar
  • Password — varchar
  • Name — varchar
  • Email (E-mail) — varchar
  • Mention — varchar
  • User_Status — varchar
  • Refresh_Token — varchar
  • Status_Change_Date — timestamp
  • Write_Date — timestamp
  • Update_Date — timestamp

User_Status (user_status)

  • UserId (userId) — Type — Foreign key → User.UserId — NOT NULL
  • Sign_Up (Sign_up) — varchar
  • Withdraw — varchar
  • Login — varchar
  • Logout (Field) — varchar