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