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