AML
Tables (6)
pg_aml_edd
- seq — INT(11) — Primary key — NOT NULL
- aml_id — VARCHAR(20)
- dst_mem_guid — VARCHAR(50)
- dst_mem_type — VARCHAR(30)
- mrchnt_mem_guid — VARCHAR(50)
- edd_target_type — VARCHAR(10) — 송금인, 수취인 구분을 위함' COLLATE 'utf8_general_ci
- mem_fl — VARCHAR(2) — NOT NULL
- name — VARCHAR(50)
- dob — VARCHAR(10)
- gender — VARCHAR(10)
- contact_information — VARCHAR(50) — 연락처' COLLATE 'utf8_general_ci
- job — VARCHAR(20)
- cmpl_chk_cd — VARCHAR(50) — 사유 코드' COLLATE 'utf8_general_ci
- recv_addr — VARCHAR(100) — 수취인 주소' COLLATE 'utf8_general_ci
- home_tl_no — VARCHAR(11) — 자택전화번호' COLLATE 'utf8_general_ci
- ocup_name — VARCHAR(15) — 직장명' COLLATE 'utf8_general_ci
- wrst_addr — VARCHAR(100) — 직장주' COLLATE 'utf8_general_ci
- wrst_tl_no — VARCHAR(44) — 직장전화번호' COLLATE 'utf8_general_ci
- anul_income — BIGINT(13) — 연소득
- recv_confirm_method — VARCHAR(4) — 수취인직업 및 연간소득확인방법' COLLATE 'utf8_general_ci
- remit_addr — VARCHAR(100) — 송금인주소' COLLATE 'utf8_general_ci
- wlf_revoc_rsn_ctnt — VARCHAR(50) — WLF해제사유내용' COLLATE 'utf8_general_ci
- reason_cd — VARCHAR(20) — 거래 사유(목적)' COLLATE 'utf8_general_ci
- src_of_income — VARCHAR(20) — 거래 자금의 원천' COLLATE 'utf8_general_ci
- processing_status — VARCHAR(10)
- final_validator — VARCHAR(50) — 해제 담당자 ID' COLLATE 'utf8_general_ci
- edd_success_yn — VARCHAR(1) — EDD 성공여부(Y:성공, N:실패)' COLLATE 'utf8_general_ci
- create_dt — DATETIME — NOT NULL
- update_dt — DATETIME
pg_aml_image
- seq — BIGINT(20) — Primary key — NOT NULL
- seq (seq2) — INT(11) — Foreign key → pg_aml_kyc.seq — NOT NULL — unique key
- aml_id — VARCHAR(100) — NOT NULL — seyfert unique key' COLLATE 'utf8_general_ci
- img_type — VARCHAR(30) — NOT NULL — 이미지 종류(여권, 주민, 운전)' COLLATE 'utf8_general_ci
- img_size — BIGINT(20) — NOT NULL — 이미지사이즈(단위는byte)
- img_extensions — VARCHAR(12) — NOT NULL — 이미지확장자(image/png)' COLLATE 'utf8_general_ci
- original_data — VARCHAR(200) — NOT NULL — 원본이미지HashID(복호화에 필요)' COLLATE 'utf8_general_ci
- crop_data — VARCHAR(200) — NOT NULL — 사용자 crop Image HashID(복호화에 필요)' COLLATE 'utf8_general_ci
- thumbnail — VARCHAR(200) — NOT NULL — 썸네일이미지HashID(복호화에 필요)' COLLATE 'utf8_general_ci
- original_file_name — VARCHAR(200) — NOT NULL — 원본이미지이름' COLLATE 'utf8_general_ci
- create_dt — TIMESTAMP — NOT NULL
- update_dt — TIMESTAMP — NOT NULL
pg_aml_kyc
- seq — INT(11) — Primary key — NOT NULL — unique key
- aml_id — VARCHAR(100) — NOT NULL — sefert kyc unique key' COLLATE 'utf8_general_ci
- ref_id — VARCHAR(45) — 파트너사와의 reference ID' COLLATE 'utf8_general_ci
- register_id — VARCHAR(100) — NOT NULL — kyc aml 접수번호' COLLATE 'utf8_general_ci
- dob — VARCHAR(20)
- dst_mem_guid — VARCHAR(100) — NOT NULL — 수령자guid' COLLATE 'utf8_general_ci
- dst_mem_type — VARCHAR(100) — NOT NULL — 수령자 타입' COLLATE 'utf8_general_ci
- dst_mem_phone — VARCHAR(50) — 수령자핸드폰번호' COLLATE 'utf8_general_ci
- dst_mem_email — VARCHAR(100) — 수령자이메일' COLLATE 'utf8_general_ci
- dst_mem_accnt_no — VARCHAR(50) — 수령자 계좌번호' COLLATE 'utf8_general_ci
- dst_mem_accnt_owner_name — VARCHAR(100) — NOT NULL — 수령자 계좌주명' COLLATE 'utf8_general_ci
- dst_mem_bnk_cd — VARCHAR(8)
- org_mem_name — VARCHAR(100) — 보내는 사람 이름' COLLATE 'utf8_general_ci
- mrchnt_mem_guid — VARCHAR(100) — NOT NULL — 요청한상점guid' COLLATE 'utf8_general_ci
- mrchnt_mem_name — VARCHAR(100) — NOT NULL — 요청한상점이름' COLLATE 'utf8_general_ci
- mrchnt_mem_phone — VARCHAR(100) — NOT NULL — 요청한 상점전화번호' COLLATE 'utf8_general_ci
- mrchnt_mem_email — VARCHAR(100) — NOT NULL — 요청한 상점 이메일' COLLATE 'utf8_general_ci
- enhncd_accnt_vrf_yn — VARCHAR(50) — 강화된계좌검증결과값' COLLATE 'utf8_general_ci
- dowjones_success_yn — VARCHAR(50) — 다우존스결과값' COLLATE 'utf8_general_ci
- dow_or_limit_fail_yn — CHAR(1) — 100만원 이하 다우실패, 한도체크 실패 시 kyc 접수를 위한 구분 값(Y로 보낸다)' COLLATE 'latin1_swedish_ci
- notice_yn — VARCHAR(1)
- aml_process_status — VARCHAR(50) — NOT NULL — AML처리상태' COLLATE 'utf8_general_ci
- reason_cd — VARCHAR(50) — 거래사유코드' COLLATE 'utf8_general_ci
- lang — CHAR(50) — NOT NULL — 수령자가 사용할언어(sms발송시언어적용)' COLLATE 'utf8_general_ci
- kyc_result_code — VARCHAR(50) — aml 처리후 결과 코드(SUCCESS, FAILURE)' COLLATE 'utf8_general_ci
- kyc_result_msg — VARCHAR(200) — aml 처리후 결과 메세지(SUCCESS, 오류내용)' COLLATE 'utf8_general_ci
- tr_dt — VARCHAR(50) — NOT NULL — 거래일자(trDt)' COLLATE 'utf8_general_ci
- limit_dt — VARCHAR(50) — NOT NULL — 신분증등록타임아웃일시' COLLATE 'utf8_general_ci
- create_dt — TIMESTAMP — NOT NULL
- update_dt — TIMESTAMP — NOT NULL
- INDEX — `reg_mem_type-idx`
- INDEX — `idx_where`
pg_aml_request
- seq — INT(11) — Primary key — NOT NULL
- aml_id — VARCHAR(20)
- mrchnt_code — VARCHAR(50)
- main_type — VARCHAR(20) — NOT NULL
- requester — INT(11) — NOT NULL
- request_note — VARCHAR(100)
- request_dt — DATETIME
- reviewer — INT(11) — NOT NULL
- review_result — VARCHAR(20)
- review_dt — DATETIME
- approver — INT(11) — NOT NULL
- approve_result — VARCHAR(20)
- approve_dt — DATETIME
- request_type — VARCHAR(20) — NOT NULL
- create_dt — DATETIME — NOT NULL
pg_aml_request_data
- seq — INT(11) — Primary key — NOT NULL
- request_seq — INT(11) — NOT NULL
- aml_id — VARCHAR(50)
- title — VARCHAR(50)
- path — VARCHAR(20) — NOT NULL
- origin — VARCHAR(50)
- create_dt — DATETIME — NOT NULL
pg_aml_verification
- seq — INT(11) — Primary key — NOT NULL — unique key
- seq (seq2) — INT(11) — Foreign key → pg_aml_kyc.seq — NOT NULL — unique key
- aml_id — VARCHAR(100) — NOT NULL — seyfert unique key' COLLATE 'utf8_general_ci
- dst_mem_guid — VARCHAR(100) — NOT NULL — guid' COLLATE 'utf8_general_ci
- img_type — VARCHAR(50) — NOT NULL — 업로드 된 이미지의 종류(업로드 전이면 NOTUPLOAD)' COLLATE 'utf8_general_ci
- validate_type — CHAR(50) — 검증수단(GBG or Dowjones)' COLLATE 'latin1_swedish_ci
- gbg_result — CHAR(50) — GBG bandText' COLLATE 'latin1_swedish_ci
- dow_result — CHAR(50) — Dowjones risk-icon' COLLATE 'latin1_swedish_ci
- passport_num — VARCHAR(50) — 암호화된 여권번호' COLLATE 'utf8_general_ci
- passport_expire_dt — CHAR(10) — 여권만료일' COLLATE 'latin1_swedish_ci
- id_card_num — VARCHAR(50) — 암호화된 주민번호' COLLATE 'utf8_general_ci
- driver_license_num — VARCHAR(50) — 암호화된 운전면허번호' COLLATE 'utf8_general_ci
- driver_serial_num — VARCHAR(50) — 운전면허 암호일련번호' COLLATE 'utf8_general_ci
- business_license_num — VARCHAR(50)
- nationality — CHAR(10) — NOT NULL — 여권의국가, 주민증운전증은 KOR' COLLATE 'utf8_general_ci
- ocr_result — VARCHAR(30) — ocr인식결과 ' COLLATE 'utf8_general_ci
- valid_st — CHAR(50) — 신분증진위여부(Valid,Invalid)' COLLATE 'latin1_swedish_ci
- issue_dt — CHAR(10) — 여권생성일,주민증운전증발급일' COLLATE 'latin1_swedish_ci
- create_dt — TIMESTAMP — NOT NULL
- update_dt — TIMESTAMP — NOT NULL
- id_result — VARCHAR(20) — 신분증진위여부결과 ' COLLATE 'utf8_general_ci
- ilwon_result — VARCHAR(20) — 1원인증결과 ' COLLATE 'utf8_general_ci
- INDEX — `idx_aml_verification_dst_mem_guid`