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