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