dangol365

Tables (14)

TN_USED_KEY

  • ID — BIGINT(20) — Primary key — NOT NULL
  • WAREHOUSING_ID (WAREHOUSING_ID2) — BIGINT(20) — Foreign key → TN_WAREHOUSING.WAREHOUSING_ID — NOT NULL — 입고접수번호_ID
  • RECEIPT_ID — BIGINT(20) — NOT NULL
  • KEY_VALUE — BIGINT(20) — NOT NULL
  • PASSWD — SMALLINT(6) — NOT NULL
  • CREATE_USER_ID — VARCHAR(200)
  • CREATE_DT — DATETIME

TN_USED_PURCHASE

  • WAREHOUSING_ID — BIGINT(20) — Foreign key → TN_WAREHOUSING.WAREHOUSING_ID — NOT NULL — 입고접수번호_ID
  • STATE — VARCHAR(2) — C: 사용자 확인중, D:확인 완료, E: 상담 요청' COLLATE 'utf8_unicode_ci
  • COMPLETE_YN — SMALLINT(6)
  • RETURN_STATE — SMALLINT(6)
  • USER_ID — BIGINT(20)
  • GOOD_CNT — SMALLINT(6)
  • BAD_CNT — SMALLINT(6)
  • FAULT_CNT — SMALLINT(6)
  • DES — VARCHAR(500)
  • REQUEST — VARCHAR(500)
  • ADD_PRICE — BIGINT(20)
  • ADD_DES — VARCHAR(100)
  • RECEIPT_ID — BIGINT(20)
  • USER_SEQ — BIGINT(20)
  • DELIVERY_COMPANY — VARCHAR(2)
  • DELIVERY_INVOICE — VARCHAR(50)
  • CREATE_USER_ID — VARCHAR(20) — 생성한사람' COLLATE 'utf8_unicode_ci
  • CREATE_DT — DATETIME — 생성일시
  • UPDATE_USER_ID — VARCHAR(20) — 수정한사람' COLLATE 'utf8_unicode_ci
  • UPDATE_DT — DATETIME — 수정일시

TN_USED_PURCHASE_DELIVERY_INVOICE

  • INVOICE_ID — BIGINT(20) — Primary key — NOT NULL
  • RELEASE_ID (RELEASE_ID2) — BIGINT(20) — Foreign key → TN_USED_PURCHASE_RELEASE.RELEASE_ID — NOT NULL — 중고매입 출고번호
  • INVOICE — VARCHAR(30) — 송장번호' COLLATE 'utf8_unicode_ci
  • DELIVERY_COMPANY — VARCHAR(50) — 택배업체명' COLLATE 'utf8_unicode_ci
  • CREATE_USER_ID — VARCHAR(20)
  • CREATE_DT — DATETIME
  • UPDATE_USER_ID — VARCHAR(20)
  • UPDATE_DT — DATETIME

TN_USED_PURCHASE_FAULT

  • FAULT_ID — BIGINT(20) — Primary key — NOT NULL
  • WAREHOUSING_ID (WAREHOUSING_ID2) — BIGINT(20) — Foreign key → TN_WAREHOUSING.WAREHOUSING_ID — NOT NULL — 입고접수번호_ID
  • COMPONENT_CD — VARCHAR(50)
  • PART_CODE — VARCHAR(20)
  • MODEL_NM — VARCHAR(100)
  • PART_CNT — SMALLINT(6)
  • INVENTORY_CAT — VARCHAR(5)
  • DES — VARCHAR(200)
  • CREATE_USER_ID — VARCHAR(30)
  • CREATE_DT — DATETIME — 생성일시
  • UPDATE_USER_ID — VARCHAR(30)
  • UPDATE_DT — DATETIME

TN_USED_PURCHASE_IMAGE

  • RESULT_IMAGE_ID — BIGINT(20) — Primary key — NOT NULL — 관리번호_ID
  • RESULT_ID (RESULT_ID2) — BIGINT(20) — Foreign key → TN_USED_PURCHASE_RESULT.RESULT_ID — NOT NULL — 관리번호_ID
  • RESULT_ID — BIGINT(20) — NOT NULL
  • URL — VARCHAR(200)
  • CREATE_USER_ID — VARCHAR(20) — 생성한사람' COLLATE 'utf8_unicode_ci
  • CREATE_DT — DATETIME — 생성일시
  • UPDATE_USER_ID — VARCHAR(20) — 수정한사람' COLLATE 'utf8_unicode_ci
  • UPDATE_DT — DATETIME — 수정일시

TN_USED_PURCHASE_RELEASE

  • RELEASE_ID — BIGINT(20) — Primary key — NOT NULL — 중고매입 출고번호
  • WAREHOUSING_ID (WAREHOUSING_ID2) — BIGINT(20) — Foreign key → TN_WAREHOUSING.WAREHOUSING_ID — NOT NULL — 입고접수번호_ID
  • RECEIPT — VARCHAR(20) — 접수번호' COLLATE 'utf8_unicode_ci
  • RELEASE_STATE — VARCHAR(1) — 출고상태' COLLATE 'utf8_unicode_ci
  • REQUEST — VARCHAR(200) — 참고사항' COLLATE 'utf8_unicode_ci
  • RELEASE_TYPE — VARCHAR(10)
  • CUSTOMER_ID — BIGINT(20)
  • RELEASE_CHARGE — BIGINT(20) — 출고정산
  • EXTRA_CHARGE — BIGINT(20)
  • REFUND_CHARGE — BIGINT(20)
  • RECEIPT_DT — DATETIME — 접수일
  • PROCESS_DT — DATETIME
  • POSTPONE_DT — DATETIME
  • CANCEL_DT — DATETIME
  • RELEASE_DT — DATETIME
  • COMPLETE_DT — DATETIME — 완료일자
  • CREATE_USER_ID — VARCHAR(20)
  • CREATE_DT — DATETIME
  • UPDATE_USER_ID — VARCHAR(20)
  • UPDATE_DT — DATETIME
  • WORKER_ID — VARCHAR(20)

TN_USED_PURCHASE_RELEASE_FAULT_PART

  • RELEASE_FAULT_PART_ID — BIGINT(20) — Primary key — NOT NULL
  • RELEASE_ID — BIGINT(20) — NOT NULL
  • FAULT_ID — BIGINT(20) — NOT NULL
  • PRICE — BIGINT(20)
  • DES — VARCHAR(50)
  • CREATE_USER_ID — VARCHAR(50) — 사용자ID' COLLATE 'utf8_unicode_ci
  • CREATE_DT — DATETIME
  • UPDATE_USER_ID — VARCHAR(50)
  • UPDATE_DT — DATETIME

TN_USED_PURCHASE_RELEASE_PART

  • RELEASE_PART_ID — BIGINT(20) — Primary key — NOT NULL
  • RELEASE_ID (RELEASE_ID2) — BIGINT(20) — Foreign key → TN_USED_PURCHASE_RELEASE.RELEASE_ID — NOT NULL — 중고매입 출고번호
  • INVENTORY_ID — BIGINT(20) — NOT NULL
  • PRICE — BIGINT(20)
  • CREATE_USER_ID — VARCHAR(50) — 사용자ID' COLLATE 'utf8_unicode_ci
  • CREATE_DT — DATETIME
  • UPDATE_USER_ID — VARCHAR(50)
  • UPDATE_DT — DATETIME

TN_USED_PURCHASE_REQUEST

  • REQUEST_ID — BIGINT(20) — Primary key — NOT NULL
  • WAREHOUSING_ID (WAREHOUSING_ID2) — BIGINT(20) — Foreign key → TN_WAREHOUSING.WAREHOUSING_ID — NOT NULL — 입고접수번호_ID
  • REQUEST_CAT — VARCHAR(50)
  • DES — VARCHAR(300)
  • REQUEST_DT — VARCHAR(30)
  • CREATE_DT — DATETIME — 생성일시

TN_USED_PURCHASE_RESPONSE

  • RESPONSE_ID — BIGINT(20) — Primary key — NOT NULL
  • REQUEST_ID (REQUEST_ID2) — BIGINT(20) — Foreign key → TN_USED_PURCHASE_REQUEST.REQUEST_ID — NOT NULL
  • DES — VARCHAR(300)
  • CREATE_USER_ID — VARCHAR(20) — 생성한사람' COLLATE 'utf8_unicode_ci
  • CREATE_DT — DATETIME — 생성일시

TN_USED_PURCHASE_RESULT

  • RESULT_ID — BIGINT(20) — Primary key — NOT NULL — 관리번호_ID
  • WAREHOUSING_ID (WAREHOUSING_ID2) — BIGINT(20) — Foreign key → TN_USED_PURCHASE.WAREHOUSING_ID — NOT NULL — 입고접수번호_ID
  • PART_ID — BIGINT(20)
  • P_PART_ID — BIGINT(20)
  • STATE — SMALLINT(6) — 0: 없음, 1: 매입, 2: 반품 3: 폐기
  • COMPONENT_CD — VARCHAR(20)
  • LT_COMPONENT_ID — VARCHAR(20)
  • LT_MODEL_NM — VARCHAR(100)
  • LT_PART_CNT — BIGINT(20) — 데이터 ID
  • INVENTORY_ID — BIGINT(20)
  • COMPONENT_ID — BIGINT(20) — 부품 ID
  • COMPONENT — VARCHAR(50)
  • MODEL_NM — VARCHAR(200)
  • MODEL_NM_SHORT — VARCHAR(200)
  • PART_CNT — BIGINT(20) — 초기가격
  • DIFF — VARCHAR(50)
  • INVENTORY_CAT — VARCHAR(20)
  • ADJUST_DES — VARCHAR(50) — 차감내역' COLLATE 'utf8_unicode_ci
  • OFFER_PRICE — BIGINT(20) — 매입신청금액
  • INIT_PRICE — BIGINT(20) — 초기금액
  • ADJUST_PRICE — BIGINT(20) — NOT NULL — 가감금액
  • TOTAL_PRICE — BIGINT(20) — 최종입고금액
  • DES — VARCHAR(100) — 설명' COLLATE 'utf8_unicode_ci
  • CREATE_USER_ID — VARCHAR(20) — 생성한사람' COLLATE 'utf8_unicode_ci
  • CREATE_DT — DATETIME — 생성일시
  • UPDATE_USER_ID — VARCHAR(20) — 수정한사람' COLLATE 'utf8_unicode_ci
  • UPDATE_DT — DATETIME — 수정일시

TN_USED_PURCHASE_STATE_DT

  • STATE_DT_ID — BIGINT(20) — Primary key — NOT NULL
  • RELEASE_ID (RELEASE_ID2) — BIGINT(20) — Foreign key → TN_USED_PURCHASE_RELEASE.RELEASE_ID — NOT NULL — 중고매입 출고번호
  • STATE_TYPE — SMALLINT(6) — 출고:1, 추가정산:2, 환급:3
  • USER_ID — VARCHAR(20) — 사용자ID' COLLATE 'utf8_unicode_ci
  • CREATE_DT — DATETIME

TN_WAREHOUSING

  • WAREHOUSING_ID — BIGINT(20) — Primary key — NOT NULL — 입고접수번호_ID
  • WAREHOUSING — VARCHAR(10) — 입고접수번호' COLLATE 'utf8_unicode_ci
  • PART_CNT — SMALLINT(6) — 부품 개수
  • WAREHOUSING_TYPE — VARCHAR(1) — 입고종류(매입:1, 위탁:2)' COLLATE 'utf8_unicode_ci
  • WAREHOUSING_CATEGORY — SMALLINT(6) — 1: U,중고매입, 2: B,일반
  • WAREHOUSING_STATE — VARCHAR(1) — 입고상태' COLLATE 'utf8_unicode_ci
  • WAREHOUSING_DT — DATETIME — 입고처리완료일
  • EXAMINE_USER_ID — VARCHAR(20) — 검수자' COLLATE 'utf8_unicode_ci
  • EXAMINE_DT — DATETIME — 검수날짜
  • REGISTER_DT — DATETIME — 등록일자
  • LOCATION — VARCHAR(10) — 입고위치' COLLATE 'utf8_unicode_ci
  • COMPONENT_ID — BIGINT(20) — 대표 부품 ID
  • INVENTORY_ID — BIGINT(20) — 관리번호 ID
  • MODEL_NM — VARCHAR(50) — 대표 부품 이름' COLLATE 'utf8_unicode_ci
  • SPEC_NM — VARCHAR(200) — 부품상세스펙' COLLATE 'utf8_unicode_ci
  • CUSTOMER_ID — VARCHAR(20) — 거래처' COLLATE 'utf8_unicode_ci
  • COMPANY_ID — BIGINT(20) — 업체
  • PRICE — BIGINT(20) — 입고가격
  • CREATE_USER_ID — VARCHAR(20) — 사용자ID' COLLATE 'utf8_unicode_ci
  • CREATE_DT — DATETIME
  • UPDATE_USER_ID — VARCHAR(20)
  • UPDATE_DT — DATETIME

TN_WAREHOUSING_PART

  • INVENTORY_ID — BIGINT(20) — Primary key — NOT NULL — 관리번호
  • WAREHOUSING_ID (WAREHOUSING_ID2) — BIGINT(20) — Foreign key → TN_WAREHOUSING.WAREHOUSING_ID — NOT NULL — 입고접수번호_ID
  • PRICE — BIGINT(20) — 입고가
  • USER_ID — VARCHAR(20) — 사용자ID' COLLATE 'utf8_unicode_ci
  • CREATE_DT — DATETIME
  • UPDATE_DT — DATETIME