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