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 (결제방법)