golden
Tables (6)
FOOD
- FOODNUMBER — SERIAL — Primary key — NOT NULL
- NAME — VARCHAR(32)
- AREA — VARCHAR(32)
- COOKINGTIME — INT
- TIME — VARCHAR(32)
- HEALTH — VARCHAR(32)
- CALORY — VARCHAR(32)
- LEVEL — INT
- HOWTO — VARCHAR(2048)
- TEMPERATURE — FLOAT
- MONTH — FLOAT
FOOD_DETAILS
- FOODNUMBER — int — Foreign key → FOOD.FOODNUMBER — NOT NULL
- NECESSARY — INT
- AMOUNT — VARCHAR(32)
- INGREDIENT_NAME — VARCHAR(32)
RECOMMEND_TEMP
- USERNUMBER — int — Foreign key → USER.USERNUMBER — NOT NULL
- FOODNUMBER — int — Foreign key → FOOD.FOODNUMBER — NOT NULL
- SCORE — float
- TIME — TIMESTAMP
USEDATA
- USERNUMBER — int — Foreign key → USER.USERNUMBER — NOT NULL
- FOODNUMBER — int — Foreign key → FOOD.FOODNUMBER — NOT NULL
- TIME — TIMESTAMP
- TYPE — VARCHAR(32)
- TEMPERATURE — FLOAT
- WEATHER — VARCHAR(32)
USER
- USERNUMBER — SERIAL — Primary key — NOT NULL
- NAME — VARCHAR(32)
- ID — VARCHAR(32)
- PW — VARCHAR(32)
- TIME — TIMESTAMP
USER_INVENTORY
- USERNUMBER — int — Foreign key → USER.USERNUMBER — NOT NULL
- AMOUNT — VARCHAR(32)
- INGREDIENT_NAME — VARCHAR(32)
- COOKWARE_NAME — VARCHAR(32)
- CATEGORY — VARCHAR(32)