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