beyond_project01_조상원
테이블 (5)
ALLERGY (Untitled5)
- allergy_id (Key) — char — 기본 키 — NOT NULL — allergy_id
- allergy_name (Field) — char — NOT NULL — allergy_name
- allergy_info (Field2) — char — NOT NULL — allergy_information
- symptom (Field3) — char — NOT NULL — symptom_of_allergy
- caution (Field4) — char — NOT NULL — allergy_caution
DISEASE (Untitled4)
- disease_id (Key) — char — 기본 키 — NOT NULL — disease_id
- disease_name (Field) — char — NOT NULL — disease_name
- disease_info (Field2) — char — NOT NULL — disease_information
- symptom (Field3) — char — NOT NULL — symptom_of_disease
- caution (Field4) — char — NOT NULL — disease_caution
INREDIENT (Untitled3)
- ing_id (Key) — char — 기본 키 — NOT NULL — ingredient_id
- ing_name (Field) — char — NOT NULL — ingredient_name
- ing_exp (Field2) — char — NOT NULL — ingredient explanation
- level (Field3) — tinyint — NOT NULL — danger_level
- ing_fun (Field4) — char — ingredient_function
- ing_efficacy (Field5) — char — ingredient_efficacy
- ing_purpose (Field6) — char — ingredient_purpose
- ing_risk (Field7) — char — ingredient_potential_risk
- ing_info_source (Field8) — char — ingredient_source_of_information
PRODUCT (Untitled2)
- product_id (Key) — char — 기본 키 — NOT NULL — product_ID
- price (Field) — int — NOT NULL — product_price
- disease_id (Field2) — char — product_disease
- allergy_id (Field3) — char — product_allergy
- product_name (Field4) — char — NOT NULL — product_name
- product_brand (Field5) — char — NOT NULL — product_brand
- category (Field6) — char — NOT NULL — product_category
- image (Field7) — varchar — product_image
- level (Field8) — tinyint — NOT NULL — danger_level
USER (Untitled)
- user_id (Key) — char — 기본 키 — NOT NULL — ID
- user_name (Field) — char — NOT NULL — name
- user_no (Field2) — int — NOT NULL — number
- user_pass (Field3) — char — NOT NULL — passward
- user_phone (Field4) — int — NOT NULL — phone_number
- email (Field5) — char — email
- disease_id (Field6) — char — user_disease
- allergy_id (Field7) — char — user_allergy
- review (Field8) — char — user_review
- rating (Field9) — tinyint — user_rating
- bookmark (Field10) — char — user_bookmark