JoriKing
Tables (7)
R_Comment (Untitled3)
- comment_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
- comment_content (Field) — text — NOT NULL
Recipe (Untitled2)
- recipe_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
- recipe_name (Field) — varchar(20) — NOT NULL
- recipe_ingredients (Field2) — json — NOT NULL
- recipe_order (Field3) — json — NOT NULL
- recipe_is_vegi (Field4) — boolean — NOT NULL
Recipe_Like (Untitled5)
- user_id (Key) — int — Foreign key → User.user_id — NOT NULL
- recipe_id (Key2) — int — Foreign key → Recipe.recipe_id — NOT NULL
- user_id (Key22) — int — Foreign key → Recipe.user_id — NOT NULL
Recipe_R_Comment (Untitled4)
- recipe_id (Key) — int — Foreign key → Recipe.recipe_id — NOT NULL
- user_id (Key2) — int — Foreign key → Recipe.user_id — NOT NULL
- comment_id (Key3) — int — Foreign key → R_Comment.comment_id — NOT NULL
- user_id (Key22) — int — Foreign key → R_Comment.user_id — NOT NULL
Recipe_Tag (Untitled7)
- recipe_id (Key) — int — Foreign key → Recipe.recipe_id — NOT NULL
- user_id (Key2) — int — Foreign key → Recipe.user_id — NOT NULL
- tag_id (Key3) — int — Foreign key → Tag.tag_id — NOT NULL
Tag (Untitled6)
- tag_id (Key) — int — Primary key — NOT NULL
- type (Field) — varchar — NOT NULL
User (Untitled)
- user_id (Key) — int — Primary key — NOT NULL
- login_id (Field) — varchar (10) — NOT NULL
- nickname (Field2) — varchar(8) — NOT NULL
- e-mail (Field3) — varchar — NOT NULL
- password (Field4) — varchar — NOT NULL