recipe

Tables (3)

recipe (레시피)

  • recipe_id (Key) — BIGINT — Primary key — NOT NULL
  • recipe_user_id (Key2) — BIGINT — Foreign key → recipe_user.recipe_user_id — NOT NULL
  • recipe_name (Field) — VARCHAR(20)
  • recipe_url (Field2) — VARCHAR
  • recipe_desc (Field3) — VARCHAR
  • recipe_stored (Field4) — VARCHAR

recipe_user (레시피 사용자)

  • recipe_user_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key4) — BIG INT — Foreign key → user.user_id — NOT NULL
  • recipe_id (Key2) — BIGINT — Foreign key → recipe.recipe_id — NOT NULL
  • group_name (Field) — VARCHAR

user (사용자)

  • user_id (Key) — BIG INT — Primary key — NOT NULL
  • user_email (Field) — VARCHAR(20)
  • user_nickname (Field2) — VARCHAR(10)
  • user_password (Field3) — VARCHAR(20)
  • auth_code (Field4) — VARCHAR