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