Clothes

Tables (12)

Bag (장바구니)

  • 장바구니번호 (bag_id) — str — Primary key — NOT NULL
  • 크기 (productsize) — int — Foreign key → ProductSize.id — NOT NULL
  • 색상 (productcolor) — int — Foreign key → ProductColor.id — NOT NULL
  • 상품 (product) — int — Foreign key → Product.id — NOT NULL
  • 개수 (quantity) — int — NOT NULL

OptionColor (색상)

  • id — int — Primary key — NOT NULL
  • 색상 (color) — varchar(30) — NOT NULL

OptionSize (사이즈)

  • id — int — Primary key — NOT NULL
  • 크기 (size) — varchar(30) — NOT NULL

Order (결제)

  • 주문번호 (order_id) — str — Primary key — NOT NULL
  • 상품 — int — Foreign key → Product.id — NOT NULL
  • 크기 (productsize) — int — Foreign key → ProductSize.id — NOT NULL
  • 색상 (productcolor) — int — Foreign key → ProductColor.id — NOT NULL
  • 유저 (user) — int — Foreign key → User.id — NOT NULL
  • 개수 (quantity) — int — NOT NULL

Photo (사진)

  • id — int — Primary key — NOT NULL
  • 상품 (product) — int — Foreign key → Product.id — NOT NULL
  • 사진 (photo) — image — NOT NULL

Product (상품)

  • id — int — Primary key — NOT NULL
  • 카테고리 (category) — int — Foreign key → ProductCategory.id — NOT NULL
  • 이름 (name) — varchar(255) — NOT NULL
  • 설명 (description) — varchar(255)
  • 가격 (price) — int — NOT NULL
  • 등록날짜 (reg_date) — datetime — NOT NULL
  • 수정날짜 (update_date) — datetime
  • 관리 지침 (care_instruction) — text
  • 구성 (composition) — text
  • 세부사항 (detail) — text

ProductCategory (카테고리)

  • id — int — Primary key — NOT NULL
  • 이름 (name) — varchar(255) — NOT NULL

ProductColor (상품색상)

  • id — int — Primary key — NOT NULL
  • 색상id (color) — int — Foreign key → OptionColor.id — NOT NULL
  • 상품id (product) — int — Foreign key → Product.id — NOT NULL

ProductSize (상품사이즈)

  • id — int — Primary key — NOT NULL
  • 사이즈id (size) — int — Foreign key → OptionSize.id — NOT NULL
  • 상품id (product) — int — Foreign key → Product.id — NOT NULL

SizeGuide (사이즈가이드)

  • id — int — Primary key — NOT NULL
  • 상품 (product) — int — Foreign key → Product.id — NOT NULL
  • 이름 (name) — varchar(30)
  • 길이 (length) — int

User (유저)

  • id — int — Primary key — NOT NULL
  • 이름 (last_name) — varchar(15) — NOT NULL
  • 성 (first_name) — varchar(10)
  • 주소 (address) — varchar(255)
  • 비밀번호 (password) — varchar(255) — NOT NULL
  • 집 전화번호 (phone_number) — varchar(30)
  • 전화번호 (mobile_phone_number) — varchar(30) — NOT NULL
  • 성별 (sex) — varchar(2) — NOT NULL

account (계좌)

  • id — int — Primary key — NOT NULL
  • 유저 (user) — int — Foreign key → User.id — NOT NULL
  • 은행계좌 (bank_account) — varchar(30) — NOT NULL
  • 은핸계좌번호 (bank_account_number) — varchar(30) — NOT NULL
  • 예금주명 (account_holder_name) — varchar(20) — NOT NULL