DataTable

Tables (5)

Comments (Untitled3)

  • CommentId (Key) — int — Primary key — NOT NULL
  • Content (Field) — varchar(1500)
  • FoodId (Key3) — int — Foreign key → Foods.FoodId — NOT NULL
  • Id (Key2) — int — Foreign key → Users.Id — NOT NULL
  • UseYN (Field2) — int

Follows (Untitled5)

  • FollowId (Key) — int — Primary key — NOT NULL
  • FollowerId (Key3) — int — Foreign key — NOT NULL
  • FollowedId (Key2) — int — Foreign key → Users.Id — NOT NULL
  • UseYN (Field) — int

Foods (Untitled)

  • FoodId (Key) — int — Primary key — NOT NULL
  • Title (Field) — varchar(200)
  • Category (Field2) — enum
  • Ingredient (Field3) — varchar(1000)
  • Difficulty (Field4) — enum
  • UseYN (Field5) — int
  • Id (Key2) — int — Foreign key → Users.Id — NOT NULL
  • ImageUrl (Field6) — varchar(2048)
  • RegisterDate (Field7) — date

Likes (Untitled4)

  • LikeId (Key) — int — Primary key — NOT NULL
  • FoodId (Key3) — int — Foreign key → Foods.FoodId — NOT NULL
  • Id (Key2) — int — Foreign key → Users.Id — NOT NULL
  • UseYN (Field) — int

Users (User)

  • Id (Key) — int — Primary key — NOT NULL
  • UserId (Field5) — varchar(100)
  • UserName (Field) — varchar(100)
  • Password (Field2) — varchar(100)
  • Email (Field3) — varchar(100)
  • Category (Field4) — enum
  • UseYN (Field6) — int