database

Tables (8)

Copy Of Copy Of Cuisine (스코빌 정도 선택)

  • Key (스코빌 정도ID) — INT — Primary key — NOT NULL
  • Field (스코빌 정도) — VARCHAR(255)
  • Field3 (입력 날짜) — DATE

Copy Of Copy Of Cuisine2 (온도 선택)

  • Key (온도ID) — INT — Primary key — NOT NULL
  • Field2 (온도) — VARCHAR(255)
  • Field3 (입력 날짜) — DATE

Copy Of Cuisine (종류 선택)

  • Key (종류ID) — INT — Primary key — NOT NULL
  • CuisineName (종류명) — VARCHAR(255)
  • Field3 (입력 날짜) — DATE

Cuisine (음식 나라 선택)

  • Key (음식 나라ID) — INT — Primary key — NOT NULL
  • Field2 (음식 나라명) — VARCHAR(255)
  • Field3 (입력 날짜) — DATE

Ingredient (재료 입력)

  • Key (재료ID) — INT — Primary key — NOT NULL
  • IngredientName (재료명) — VARCHAR(255)
  • InputDate (입력 날짜) — DATE

Recipe (레시피 제공)

  • Key (레시피) — INT — Primary key — NOT NULL
  • RecipeText (요리 레시피) — VARCHAR(255)
  • ProvidedDate (날짜 정보) — DATE
  • Key (재료ID) — INT — Foreign key → Ingredient.Key — NOT NULL
  • Key (종류ID) — INT — Foreign key → Copy Of Cuisine.Key — NOT NULL
  • Key (음식 나라ID) — INT — Foreign key → Cuisine.Key — NOT NULL
  • Key (스코빌 정도ID) — INT — Foreign key → Copy Of Copy Of Cuisine.Key — NOT NULL
  • Key (온도ID) — INT — Foreign key → Copy Of Copy Of Cuisine2.Key — NOT NULL

SearchHistory (제공 기록 관리)

  • Key (제공ID) — INT — Primary key — NOT NULL
  • Key (유저ID) — INT — Foreign key → User.Key — NOT NULL
  • Key (레시피) — INT — Foreign key → Recipe.Key — NOT NULL
  • SearchDate (제공 날짜) — DATE

User (유저 관리)

  • Key (유저ID) — INT — Primary key — NOT NULL
  • Name (이름) — VARCHAR(255)
  • Email (이메일) — VARCHAR(255)
  • Password (비밀번호) — VARCHAR(255)
  • RegistrationDate (회원가입 날짜) — DATE