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