4

Tables (11)

diseases (Untitled4)

  • disease_id (Key) — BIGINT — Primary key — NOT NULL
  • disease_name (Field) — varchar(255)
  • disease_info (Field2)
  • disease_effect (Field3)
  • reg_date (Field4) — DATETIME
  • update_date (Field5) — DATETIME
  • enrolled_id (Field6) — UUID
  • (Field7)

ingredient_diseases (Untitled7)

  • Key — BIGINT — Primary key — NOT NULL
  • disease_id (Key2) — BIGINT — Foreign key → diseases.disease_id — NOT NULL
  • ingr_id (Key3) — BIGINT — Foreign key → ingredients.ingr_id — NOT NULL
  • description (Field) — TEXT
  • reference_source (Field2) — TEXT
  • type (Field3) — VARCHAR(20)
  • enrolled_id (Field4) — UUID
  • reg_date (Field5) — DATETIME
  • update_date (Field6) — DATETIME
  • Field7

ingredients (Untitled3)

  • ingr_id (Key) — BIGINT — Primary key — NOT NULL
  • ingr_name (Field) — VARCHAR(255)
  • description (Field2) — TEXT
  • functionality (Field3) — TEXT
  • usage (Field4) — TEXT
  • potential_risk (Field5) — TEXT
  • safety_rating (Field6) — VARCHAR(50)
  • reference_source (Field7) — TEXT
  • reg_date (Field8) — DATETIME
  • update_date (Field9) — DATETIME
  • enrolled_id (Field10) — UUID
  • (Field11)

life_style_intgredients (Untitled10)

  • life_style_ingredients_id (Key) — BIGINT — Primary key — NOT NULL
  • life_stlye_id (Key2) — BIGINT — Foreign key → life_styles.life_stlye_id — NOT NULL
  • ingr_id (Key3) — BIGINT — Foreign key → ingredients.ingr_id — NOT NULL
  • tyle (Field) — varchar(20)
  • enrolled_id (Field2) — UUID
  • reg_date (Field3) — DATETIME
  • update_date (Field4) — DATETIME
  • (Field5)

life_styles (Untitled8)

  • life_stlye_id (Key) — BIGINT — Primary key — NOT NULL
  • life_style)anem (Field) — varchar(255)
  • enrolled_id (Field2) — UUID
  • reg_date (Field3) — DATETIME
  • update_date (Field4) — DATETIME
  • Field5

product_ingredients (Untitled5)

  • product_ingredients_id (Field) — BIGINT — Primary key
  • product_id (Key) — BIGINT — Foreign key → products.product_id — NOT NULL
  • ingr_id (Key2) — BIGINT — Foreign key → ingredients.ingr_id — NOT NULL
  • enrolled_id (Field2)
  • reg_date (Field3) — DATETIME
  • update_date (Field4) — DATETIME

products (Untitled2)

  • product_id (Key) — BIGINT — Primary key — NOT NULL
  • product_name (Field) — varchar(255)
  • brand_name (Field2) — varchar(255)
  • category (Field3) — varchar(100)
  • img_url (Field4) — TEXT
  • reg_date (Field5) — DATETIME
  • update_date (Field6) — DATETIME
  • enrolled_id (Field7) — UUID
  • (Field8)

user_diseases (Untitled6)

  • user_diseases (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — UUID — Foreign key → users.user_id — NOT NULL
  • disease_id (Key3) — BIGINT — Foreign key → diseases.disease_id — NOT NULL
  • reg_date (Field) — DATETIME
  • update_date (Field2) — DATETIME
  • Field3

user_favorites (Untitled11)

  • user_favorites_id (Key) — bigint — Primary key — NOT NULL
  • type (Field2) — VARCHAR(20)
  • item_id (Field3) — BIGINT
  • reg_date (Field4) — DATETIME
  • update_date (Field5) — DATETIME
  • user_id (Key2) — UUID — Foreign key → users.user_id — NOT NULL

user_life_styles (Untitled9)

  • user_life_styles (Key) — BIGINT — Primary key — NOT NULL
  • reg_date (Field) — DATETIME
  • update_date (Field2) — DATETIME
  • Field3
  • user_id (Key2) — UUID — Foreign key → users.user_id — NOT NULL
  • life_stlye_id (Key3) — BIGINT — Foreign key → life_styles.life_stlye_id — NOT NULL

users (Untitled)

  • user_id (Key) — UUID — Primary key — NOT NULL
  • user_name (Field) — vaechar(255)
  • user_pw (Field2) — varchar(255)
  • user_email (Field3) — varchar(255)
  • user_nickname (Field4) — char(20)
  • user_type (Field5) — char(2)
  • reg_date (Field6) — DATETIME
  • update_date (Field7) — DATETIME
  • delete_date (Field8) — DATETIME
  • is_deleted (Field9)