Memership_Information
Tables (5)
FIT_information (맞춤정보)
- MN (회원번호) — Foreign key → Memership_Information.MN — NOT NULL
- Goods_num (물품번호) — NUMBER(20) — Foreign key → Goods_num.Goods_num — NOT NULL
- buy_number (구매번호) — Foreign key → buy_information.buy_number — NOT NULL
- post_Num (게시물번호) — Foreign key → avis_information.post_Num — NOT NULL
- age (연령)
- keyword (키워드)
- search_cookie (검색기록)
Goods_num (상품 정보)
- Goods_num (물품번호) — NUMBER(20) — Primary key — NOT NULL
- Goods_name (물품명)
- Goods_price (물품가격)
- Goods_age (권장나이)
Memership_Information (고객정보)
- MN (회원번호) — Primary key — NOT NULL
- Memail (이메일)
- Mname (이름)
- phonenumber (전화번호)
- childname (아이이름)
- childage (아이나이)
- address (주소)
avis_information (게시물정보)
- post_Num (게시물번호) — Primary key — NOT NULL
- post_name (게시물제목)
- post_registrant (등록자)
- post_registration_date (등록날짜)
- post_age (나이)
buy_information (구매정보)
- buy_number (구매번호) — Primary key — NOT NULL
- buy_paymentoption (결제방법)