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