entity

Tables (5)

allergy (Untitled4)

  • all_no (Key) — int — Primary key — NOT NULL
  • all_name (Field) — varchar
  • all_explanation (Field2) — string
  • all_symptoms (Field3) — varchar
  • all_caution (Field4) — string
  • all_good_ingredient (Field5) — varchar
  • all_bad_ingredient (Field6) — varchar
  • Field7

disease (Untitled5)

  • dis_no (Key) — int — Primary key — NOT NULL
  • dis_name (Field) — varchar
  • dis_explanation (Field2) — stringq
  • dis_symptoms (Field3) — varchar
  • dis_caution (Field4) — string
  • dis_good_ingredient (Field5) — varchar
  • dis_bad_ingredient (Field6) — varchar
  • Field7

ingredient (Untitled3)

  • ing_no (Key) — int — Primary key — NOT NULL
  • ing_name (Field) — varchar
  • ing_ewg (Field2) — varchar
  • ing_allergy_level (Field3) — tinyint
  • ing_risk_level (Field4) — tinyint
  • ing_use (Field5) — varchar
  • ing_included_product (Field6) — varchar
  • ing_explanation (Field7) — string
  • Field8

product (Untitled2)

  • pro_no (Key) — int — Primary key — 제품 식별키
  • pro_name (Field) — varchar — 제품 이름
  • pro_brand (Field2) — varchar — 제품 브랜드
  • pro_barcode (Field3) — varchar — 제품 바코드
  • pro_category (Field4) — varchar
  • price (Field5) — int
  • pro_ingredient (Field6) — varchar
  • Field7

user (Untitled)

  • user_id — varchar — Primary key — NOT NULL — 유저 아이디
  • user_pw — varchar — NOT NULL — 유저 패스워드
  • user_email — varchar — NOT NULL — 유저 이메일
  • user_name — varchar — NOT NULL — 유저 이름
  • user_phone (Field5) — varchar — 유저 전화번호
  • user_age (Field6) — int — 유저 나이
  • user_gender (Field7) — varchar — 유저 성별
  • Field