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`