beyond_prject01_조상원

테이블 (11)

diseases (Untitled11)

  • disease_id (Key) — BIGINT — 기본 키 — NOT NULL
  • disease_name (Field) — VARCHAR(255) — NOT NULL
  • disease_info (Field2) — TEXT
  • disease_effect (Field3) — TEXT
  • enrolled_id (Field4) — UUID — NOT NULL
  • reg_date (Field5) — DATETIME — NOT NULL
  • update_date (Field6) — DATETIME — NOT NULL

ingredient_diseases (Untitled8)

  • ingredient_diseases_id (Key) — BIGINT — 기본 키 — NOT NULL
  • ingr_id (Field) — BIGINT — NOT NULL
  • diseases_id (Field2) — BIGINT — NOT NULL
  • description (Field3) — TEXT
  • reference_source (Field4) — TEXT
  • type (Field5) — VARCHAR(20) — NOT NULL
  • enrolled_id (Field6) — UUID — NOT NULL
  • reg_date (Field7) — DATETIME — NOT NULL
  • update_date (Field8) — DATETIME — NOT NULL
  • ingr_id (Key2) — BIGINT — 외래 키 → ingredients.ingr_id — NOT NULL
  • disease_id (Key3) — BIGINT — 외래 키 → diseases.disease_id — NOT NULL

ingredients (Untitled3)

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

life_style_ingredients (Untitled9)

  • life_style_ingredients_id (Key) — BIGINT — 기본 키 — NOT NULL
  • life_style_id (Field) — BIGINT — NOT NULL
  • ingr_id (Field2) — BIGINT — NOT NULL
  • type (Field3) — VARCHAR(20) — NOT NULL
  • enrolled_id (Field4) — UUID — NOT NULL
  • reg_date (Field5) — DATETIME — NOT NULL
  • update_date (Field6) — DATETIME — NOT NULL
  • ingr_id (Key2) — BIGINT — 외래 키 → ingredients.ingr_id — NOT NULL
  • life_style_id (Key3) — BIGINT — 외래 키 → life_styles.life_style_id — NOT NULL

life_styles (Untitled4)

  • life_style_id (Key) — BIGINT — 기본 키 — NOT NULL
  • life)style_name (Field) — VARCHAR(255) — NOT NULL
  • enrolled_id (Field2) — UUID — NOT NULL
  • reg_date (Field3) — DATETIME — NOT NULL
  • update_date (Field4) — DATETIME — NOT NULL

product_ingredients (Untitled7)

  • product_ingredients_id (Key) — BIGINT — 기본 키 — NOT NULL
  • product_id (Field) — BIGINT — NOT NULL
  • ingr_id (Field2) — BIGINT — NOT NULL
  • enrolled_id (Field3) — UUID — NOT NULL
  • reg_date (Field4) — DATETIME — NOT NULL
  • update_date (Field5) — DATETIME — NOT NULL
  • product_id (Key2) — BIGINT — 외래 키 → products.product_id — NOT NULL
  • ingr_id (Key3) — BIGINT — 외래 키 → ingredients.ingr_id — NOT NULL
  • user_id (Key4) — UUID — 외래 키 → users.user_id — NOT NULL

products (Untitled2)

  • product_id (Key) — BIGINT — 기본 키 — NOT NULL
  • product_name (Field) — VARCHAR(255) — NOT NULL
  • brand_name (Field2) — VARCHAR(255)
  • category (Field3) — VARCHAR(100) — NOT NULL
  • ing_url (Field4) — TEXT
  • enrolled_id (Field5) — UUID — NOT NULL
  • reg_date (Field6) — DATETIME — NOT NULL
  • update_date (Field7) — DATETIME — NOT NULL

user_diseases (Untitled5)

  • user_disease_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id (Field) — UUID — NOT NULL
  • diseases_id (Field2) — BIGINT — NOT NULL
  • reg_date (Field3) — DATETIME — NOT NULL
  • update_date (Field4) — DATETIME — NOT NULL
  • disease_id (Key3) — BIGINT — 외래 키 → diseases.disease_id — NOT NULL
  • user_id (Key2) — UUID — 외래 키 → users.user_id — NOT NULL

user_favorites (Untitled6)

  • user_favorites_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id (Field) — UUID — NOT NULL
  • type (Field2) — VARCHAR(20) — NOT NULL
  • item_id (Field3) — BIGINT — NOT NULL
  • reg_date (Field4) — DATETIME — NOT NULL
  • update_date (Field5) — DATETIME — NOT NULL
  • user_id (Key2) — UUID — 외래 키 → users.user_id — NOT NULL

user_life_styles (Untitled10)

  • user_life_styles (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id (Field) — UUID — NOT NULL
  • life_style_id (Field2) — BIGINT — NOT NULL
  • reg_date (Field3) — DATETIME — NOT NULL
  • update_date (Field4) — DATETIME — NOT NULL
  • life_style_id (Key3) — BIGINT — 외래 키 → life_styles.life_style_id — NOT NULL
  • user_id (Key2) — UUID — 외래 키 → users.user_id — NOT NULL

users (Untitled)

  • user_id (Key) — UUID — 기본 키 — NOT NULL
  • user_name (Field) — VARCHAR(255) — NOT NULL
  • user_pw (Field2) — VARCHAR(255) — NOT NULL
  • user_email (Field3) — VARCHAR(255) — NOT NULL
  • user_nickname (Field4) — VARCHAR(100)
  • user_type (Field5) — CHAR(20) — NOT NULL
  • reg_date (Field6) — DATETIME — NOT NULL
  • update_date (Field7) — DATETIME — NOT NULL
  • delete_date (Field8) — DATETIME
  • is_deleted (Field9) — BOOLEAN — NOT NULL