testerd

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 (수정일자)