GanaanProject

Tables (16)

category (카테고리)

  • id — int — Primary key — NOT NULL
  • name (카테고리 명) — varchar(20)

category_paths (카테고리 위치)

  • descendant (자신index) — int — Primary key — NOT NULL
  • ancestor (부모index) — int — Foreign key → category.id — NOT NULL
  • depth (깊이) — int

consignment (위탁판매 업체)

  • id — int — Primary key — NOT NULL
  • company (업체명) — varchar(20)
  • state (현재상황) — bool — 계약중/계약해지
  • Field3
  • Field4

courier_company (택배사)

  • id — int — Primary key — NOT NULL — id
  • name (회사 명) — char(20) — 롯데택배
  • contact (계약유무) — bool — 사용하는 회사면 1

courier_number (송장번호)

  • id — int — Primary key — NOT NULL — id
  • order_id (주문코드) — int — Foreign key → order.id — NOT NULL — id
  • courier_id (택배사) — int — Foreign key → courier_company.id — NOT NULL — id
  • number (송장) — varchar(100) — 송장번호
  • state (현재상황) — varchar(20) — 배송중

order (거래 내역)

  • id (주문코드) — int — Primary key — NOT NULL
  • site_id (쇼핑몰ID) — int — Foreign key → shoppingmall_site.id — NOT NULL
  • product_id (상품정보ID) — int — Foreign key → product.id — NOT NULL
  • name (구매자명) — varchar(20)
  • phone1 (번호1) — varchar(20)
  • phone2 (번호2) — varchar(20) — null
  • address (주소) — varchar(100)
  • memo (배송자메시지) — null
  • courier_id (택배사) — int — Foreign key → courier_company.id — NOT NULL — id
  • date (상품주문일) — datetime
  • time_stamp (최근 실행시간) — datetime — 주문 접수 시 update

orders_bak

  • id — TEXT
  • state — TEXT
  • time_stamp — TEXT
  • customer_name — TEXT
  • customer_phone — TEXT
  • site — TEXT
  • mobile_number — TEXT
  • sep_pack — TEXT
  • address — TEXT
  • order_count — TEXT
  • product — TEXT
  • memo — TEXT
  • send_date — TEXT
  • delivery_number — TEXT
  • order_code — TEXT
  • delivery_type — TEXT
  • courier — TEXT
  • tracking_number — TEXT
  • product_code — TEXT
  • stocked — INT

prod_names

  • id — text
  • site — text
  • origin_name — text
  • prod_name — text
  • sep_pack — text
  • dlv_comp — TEXT

product (상품 정보)

  • id (상품정보ID) — int — Primary key — NOT NULL
  • name (상품명) — char(20)
  • price (상품가격) — int
  • add_cost (추가비용) — bool — 카테고리따라 할거면 수정필요
  • category_id (카테고리ID) — int — Foreign key → category.id — NOT NULL
  • stock (수량) — int

product_option (상품별 옵션)

  • id (옵션ID) — int — Primary key — NOT NULL
  • product_id (상품ID) — int — Foreign key → product.id — NOT NULL
  • name (옵션명) — char(20) — 색상

product_option_value (상품별 옵션 정보)

  • id (옵션값ID) — int — Primary key — NOT NULL
  • option_id (옵션ID) — int — Foreign key → product_option.id — NOT NULL
  • info_id (상품정보ID) — int — Foreign key → product.id — NOT NULL
  • value (옵션의 값) — char(20) — 빨간색
  • price (옵션 추가금액) — int

shoppingmall_site (사용중인 쇼핑몰사이트)

  • id (쇼핑몰ID) — int — Primary key — NOT NULL
  • name (쇼핑몰명) — char(20)
  • Field

site_product (사이트별 상품등록)

  • info_id (상품정보ID) — int — Foreign key → product.id — NOT NULL
  • site_id (쇼핑몰ID) — int — Foreign key → shoppingmall_site.id — NOT NULL
  • name (쇼핑몰 상품명) — text

usa_tableid

  • id — text
  • origin_name — text
  • prod_name — text

warehouse_bakidtext,

  • countinteger — default
  • pushinteger — default
  • popinteger — default
  • lastinteger — default

warehouseidtext,

  • countinteger — default
  • pushinteger — default
  • popinteger — default
  • lastinteger — default