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)