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)