feshionshop

Tables (10)

color (색상)

  • color_id (pk) — int — Primary key — NOT NULL
  • color_name (색상명) — 문자열

member (회원테이블)

  • member_id (pk) — 숫자 — Primary key — NOT NULL
  • home_id (홈페이지id) — 문자열
  • home_pass (홈페이지pwd) — 문자열
  • provicer_userID (sns사업자회원식별코드) — 문자열
  • name (회원 닉네임) — 문자열
  • email (회원 이메일) — 문자열
  • regdate (회원가입일) — 날짜형
  • updated (회원정보 수정일) — 날짜형
  • provicer (pk2) — 숫자 — Foreign key → provider_id.provicer — NOT NULL

prodcut_size (제품사이즈)

  • product_size_id (pk) — int — Primary key — NOT NULL
  • size_id (pk2) — int — Foreign key → size.size_id — NOT NULL
  • product_id (pk3) — int — Foreign key → product.product_id — NOT NULL

product (제품)

  • product_id (pk) — int — Primary key — NOT NULL
  • subcategory_id (fk) — int — Foreign key → subcategory.subcategory_id — NOT NULL
  • product_name (상품명) — 문자열
  • brand (브랜드) — 문자열
  • price (가격) — 문자열
  • discount (할인가) — int
  • introduce (간단소개) — 문자열
  • detail (상세설명) — 문자열

product_color (제품색상)

  • product_color_id (pk) — int — Primary key — NOT NULL
  • color_id (fk) — int — Foreign key → color.color_id — NOT NULL
  • product_id (fk2) — int — Foreign key → product.product_id — NOT NULL

product_img (상품이미지)

  • product_img_id (pk) — int — Primary key — NOT NULL
  • product_id (fk) — int — Foreign key → product.product_id — NOT NULL
  • file_name (파일명) — 문자열

provider_id (sns 사업자)

  • provicer (pk) — 숫자 — Primary key — NOT NULL
  • provicer_name (사업자이름) — 문자열

size (사이즈)

  • size_id (pk) — int — Primary key — NOT NULL
  • size_name (사이즈명) — 문자열

subcategory (하위카테고리)

  • subcategory_id (pk) — int — Primary key — NOT NULL
  • topcategory_id (pk2) — int — Foreign key → topcategory.topcategory_id — NOT NULL
  • subname (카테고리명) — 문자열

topcategory (상위 카테고리)

  • topcategory_id (pk) — int — Primary key — NOT NULL
  • topname (카테고리명) — varchar