sdsdeae
Tables (11)
Untitled2
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
- Field9
- Field10
tb_category_product (카테고리 상품 매핑)
- PRODUCT_SEQ (상품번호) — INT — Foreign key → tb_product.PRODUCT_SEQ — NOT NULL
- category_product_seq (카테고리상품매핑번호)
- category_seq (카테고리번호)
- del_yn (삭제여부)
- regdate (등록일시)
- Field5
- Field6
- Field7
tb_item (옵션)
- ITEM_SEQ (옵션번호) — INT — Primary key — NOT NULL
- PRODUCT_SEQ (상품번호) — INT — Foreign key → tb_product.PRODUCT_SEQ — NOT NULL
- STATUS_CD (상품상태코드)
- AMOUNT (수량)
- SELL_AMOUNT (판매수량)
- ORG_PRICE_PER_KG (판매자입력판매가격(비가공품전용))
- FINAL_PRICE_PER_KG (구매자판매가격(비가공품전용))
- MAX_KG (최대중량(비가공품전용))
- MIN_KG (최소중량(입고상품이아닐경우에노출용)(비가공품전용))
- AVG_KG (평균중량(비가공품전용))
- PROC_DATE (가공일자(비가공품전용))
- DETERM_DATE (판정일자)
- EXP_DATE (유통기한(비가공품전용))
- EARMARK_NO (개체식별번호(귀표번호)(국산소돼지 사용)(비가공품전용))
- EARMARK_NO_LIST (묶음 개체식별번호 목록(귀표번호)(국산소돼지 사용)(비가공품전용))
- DIST_ID_NO (유통식별번호(현재 수입소만 향후 수입돼지도 사용)(비가공품전용))
- BL_NO (선하증권번호(비가공품전용))
- BUTCHERY (도축장(비가공품전용))
- BCR_DATE (도축일자(비가공품전용))
- BIRTH_DATE (출생일자(비가공품전용))
- THUMBNAIL_PATH (옵션대표이미지경로(비가공품전용))
- BAR_CD (바코드타입(PDA에서 입력))
- ITEM_RACK_NO (상품보관RACK번호 여러거 입력 가능 하도록 varchar)
- COMMENT (비고)
- DISPLAY_YN (옵션 표시 여부(비가공품전용))
- APPROVAL_YN (승인여부(비가공품전용))
- APPROVAL_DATE (승인일시(비가공품전용))
- REG_MEMBER_SEQ (등록자)
- REGDATE (등록일자)
- MOD_MEMBER_SEQ (수정자)
- MODDATE (수정일자)
- Field4
tb_item_box_info (아이템 박스 정보)
- BOX_INFO_SEQ (고유번호) — INT — Primary key — NOT NULL
- ITEM_SEQ (옵션번호) — INT — Foreign key → tb_item.ITEM_SEQ — NOT NULL
- ITEM_OPTION_SEQ (Field)
- INCOMING_NO (입고 고유 번호)
- RELEASE_NO (출고 고유 번호)
- ORDER_ITEM_SEQ (Field4)
- BOX_SEQ (박스별 중량)
- BOX_KG (박스상태(PD00) : 입고완료(PD01)/판매자출고완료(PD02)/주문출고완료(PD03)/입고전송(PD04)/판매자출고전송(PD05)/주문출고전송(PD06))
- BOX_STATUS_CD (Field7)
- FULL_CODE (Field8)
- INCOMING_DATETIME (Field9)
- RELEASE_DATETIME (Field10)
- REGDATE (최초등록시간)
- REG_MEMBER_SEQ (최초등록자고유번호)
- MODDATE (수정등록시간 : 최초등록시 같이 등록)
- MOD_MEMBER_SEQ (수정 등록자 고유번호 : 최초등록시 같이 등록)
- IN_SCAN_TIME (입고스캔시간(hhmmss+순번(3)))
- IN_SCAN_PDA (ㄴㅇㄴㅁ)
- OUT_SCAN_TIME (출고스캔시간(hhmmss+순번(3)))
- OUT_SCAN_PDA (Field18)
- WH_CD (창고 코드)
- USE_YN (Y)
tb_item_proc_option (가공상품옵션)
- SELL_MEMBER_SEQ (판매자) — Primary key — NOT NULL
- ITEM_OPTION_SEQ (상품옵션등록번호) — INT — Primary key — NOT NULL
- ITEM_OPTION_NAME (상품옵션명) — Primary key — NOT NULL
- AMOUNT (수량) — Primary key — NOT NULL
- SELL_AMOUNT (판매수량) — Primary key — NOT NULL
- MAX_KG (최대중량) — Primary key — NOT NULL
- SELL_PKG_CD (판매단위) — Primary key — NOT NULL
- FINAL_PRICE_PER_KG (kg당 소비자가) — Primary key — NOT NULL
- FINAL_PRICE_PER_BOX (박스당 소비자가) — Primary key — NOT NULL
- MARGIN (수수료) — Primary key — NOT NULL
- CHARGE_PRICE_PER_BOX (박스당 정산가격8) — Primary key — NOT NULL
- STATUS_CD (상품상태코드) — Primary key — NOT NULL
- DISPLAY_YN (옵션 표시 여부) — Primary key — NOT NULL
- APPROVAL_YN (승인여부) — Primary key — NOT NULL
- APPROVAL_DATE (승인일시) — Primary key — NOT NULL
- REG_MEMBER_SEQ (일련번호) — Primary key — NOT NULL
- REGDATE (등록자) — Primary key — NOT NULL
- MOD_MEMBER_SEQ (등록일자) — Primary key — NOT NULL
- MODDATE (Key16) — Primary key — NOT NULL
- ITEM_SEQ (옵션번호) — INT — Foreign key → tb_item.ITEM_SEQ — NOT NULL
tb_order (주문)
- ORDER_SEQ (주문일련번호) — INT — Primary key — NOT NULL
- MEMBER_SEQ (고객일련번호)
- ORDER_DT (주문일자)
- ORDER_TYPE_CD (주문타입코드(일반, 고객센터, 삽니다))
- Field3 (배송구분코드(택배,3PL,직접수령))
- OLS_REGION_CD (3PL 권역코드)
- OLS_REGION_SEQ (Field)
- RECV_NM (Field2)
- RECV_CELL_NO (Field3)
- VIRTUAL_RECV_CELL_NO (가상전화번호)
- RECV_MSG (Field4)
- ZIP_CD1 (배송지우편번호)
- ZIP_CD2 (배송지우편번호2)
- ADDR1 (주소1)
- ADDR2 (주소2)
- BASE_SELL_YN (Field9)
- RECV_TIME (Field10)
- OFFLINE_PAY_YN (Field11)
- REG_MEMBER_SEQ (Field12)
- REGDATE (Field5)
- MOD_MEMBER_SEQ (Field6)
- MODDATE (Field7)
- SALES_CODE (Field8)
- DEVICE_TYPE_CD (Field13)
- SALES_MEMBER_SEQ (Field14)
- MILEAGE (Field15)
- PAYMENT_TYPE_CD (Field16)
- CARD_TID (Field17)
- CARD_AMOUNT (Field18)
- pg_shop_id (Field19)
- DEPOSIT_EXPECT_DT (Field20)
- VBANK_CD (Field21)
- ESCROW_YN (Field22)
- CASH_ISSUE_YN (Field23)
- APPROVAL_NO (Field24)
- ESCROW_YN (Field25)
- CASH_ISSUE_YN (N)
- APPROVAL_NO (Field27)
- RECEIPT_SEQ_NO (현금영수증번호)
- FIRST_ORDER_YN (첫주문여부)
- BEFORE_ADDR_DIFF_YN (이전주문 주소와 상이여부)
- BANK_CD (은행코드)
- BANK_ACCOUNT (계좌번호)
- PG_TX_ID (PG사 트랜잭션 ID)
tb_order_item_distbox (Untitled)
- ORDER_ITEM_SEQ (주문상품일련번호) — INT — Foreign key → tr_order_item.ORDER_ITEM_SEQ — NOT NULL
- BOX_SEQ (상품등록번호) — INT
- FIX_KG ('박스당 KG(계근중량)) — DOUBLE
- PRICE_PER_KG (KG당가격(현재사용안함)) — INT
- ORDER_DIST_STAT_CD (배송상태코드) — CHAR
- TAX_BILL_YN (판매자세금계산서 발행여부) — CHAR
- DIST_TYPE_CD (배송구분코드(택배,3PL,직접수령)) — CHAR
- DIST_PRICE (배송비(소비자가)') — INT
- DIST_CONS_PRICE (배송비(소비자가)) — INT
- DIST_ORG_PRICE (배송비(원가)) — INT
- DIST_CHARGE_STAT_CD (배송정산상태) — CHAR
- DIST_CHARGE_CMPL_DT (배송정산일자) — CHAR
- SELL_CHARGE_STAT_CD (판매상품정산상태(GnTOSeller)- AI00) — CHAR
- SELL_CHARGE_CMPL_DT (판매상품정산입금완료일(지급처리일)) — CHAR
- INVOICE_NO (송장번호) — CHAR
- Field
tb_product (상품)
- PRODUCT_SEQ (상품번호) — INT — Primary key — NOT NULL
- SELL_MEMBER_SEQ (판매자회원번호) — BIGINT(20)
- PRODUCT_NAME (상품명)
- STATUS_CD (상품상태코드)
tb_product_option (상품 세절분쇄소분 옵션)
- PRODUCT_OPTION_SEQ (상품 옵션등록번호) — INT — Primary key — NOT NULL
- PRODUCT_SEQ (상품등록번호) — INT — Foreign key → tb_product.PRODUCT_SEQ — NOT NULL
- SELL_MEMBER_SEQ (판매자)
- OPTION_NAME (상품 세절분쇄소분 옵션명) — CHAR
- VIEW_YN (노출여부(Y, N)) — CHAR
- CAT_CD (옵션 구분 코드: A001, B001)
- PER_UNIT (중량단위(10이면 10kg 당 추가비용 발생))
- ADD_PRICE (추가비용)
- PRICE_TYPE_CD (비용처리옵션(PER : kg 당, BOX ; 박스당?, TOT: 전체 ))
- SEQ (일련번호)
- REG_MEMBER_SEQ (등록자)
- REGDATE (등록일자)
tb_product_tag (상품태그)
- Key — Primary key — NOT NULL
- PRODUCT_SEQ (상품번호) — INT — Foreign key → tb_product.PRODUCT_SEQ — NOT NULL
- SEQ (일련번호) — INT
- SEARCH_TEXT (검색어)
- CATEGORY (검색어 구분)
- REG_GBN (등록구분)
- REG_MEMBER_SEQ (등록자)
- REG_DATE (등록일자)
- MOD_MEMBER_SEQ (수정자)
- MOD_DATE (수정일자)
tr_order_item (주문상품)
- ORDER_ITEM_SEQ (주문상품일련번호) — INT — Primary key — NOT NULL
- ORDER_SEQ (주문일련번호) — INT — Foreign key → tb_order.ORDER_SEQ — NOT NULL
- ITEM_SEQ (상품등록번호)
- ITEM_CAT_SEQ (상품분류코드)
- ORDER_STAT_CD (배송상태코드)
- WH_CD (창고구분코드)
- WH_ITEM_NO (창고입고상품번호)
- ORDER_BOX_CNT (주문한 BOX 수량)
- card_commission_ratio (카드수수료율(%))
- AVG_KG (평균중량)
- MAX_KG (Field7)
- PRICE_PER_KG (KG당가격)
- PURCHASE_PRICE_PER_KG (공동구매 최종 KG당가격)
- MARGIN (KG당 수수료)
- ORDER_TOTAL_KG (주문총중량-여러개의 BOX인 경우 합계)
- FIX_TOTAL_KG (총 중량-여러개의 BOX인 경우 합계)
- ORDER_PRICE (주문최종 가격-ORDER_TOTAL_KG*PRICE_PER_KG)
- FIX_PRICE (최종 가격-FIX_TOTAL_KG*PRICE_PER_KG)
- SHIPPING_CD (배송방법)
- TAX_MAPPING_NO (세금계산서 Mapping 번호)
- TAX_ISSUE_GBN (세금계산서 발행 구분 (D : 일별, M:월별))
- SELL_TAX_BILL_STAT_CD (판매자가 구매자에게 발행하는 세금계산서)
- PRO_OPT_SEQ (상세옵션번호)
- PRO_OPT_NAME (상세옵션명)
- OPT1_NAME (상품옵션명)
- OPT1_PRICE (추가비용)
- OPT2_NAME (상품옵션명2)
- OPT2_PRICE (추가비용2)
- OPT3_NAME (상품옵션명3)
- OPT3_PRICE (추가비용3)
- OPT4_NAME (상품옵션명4)
- OPT4_PRICE (추가비용4)
- MILEAGE (마일리지)
- COUPON_MILEAGE (쿠폰사용금액)
- CAL_INTERVAL (정산주기(D+7, D+3))
- DIST_PRICE (최종배송비-배송비소비자가 * ORDER_BOX_CNT)
- SELLER_DIST_PRICE (판매자 부담 배송비)
- GROUP_PURCHASE_GBN (공동구매 구분)
- RECEIPT_SEQ_NO (Field2)
- REG_MEMBER_SEQ (등록자)
- REGDATE (등록일자)
- MOD_MEMBER_SEQ (수정자)
- MODDATE (수정일자)