AML

Tables (11)

aml_company

  • company_guid — varchar(50) — Primary key — NOT NULL
  • company_name — varchar(50) — NOT NULL
  • domain — varchar(50)
  • ceo — varchar(50)
  • address — varchar(50)
  • create_dt — date
  • enabled — int(11)
  • homepage_logo (Field) — varchar(50)

aml_customer

  • customer_guid — varchar(50) — Primary key — NOT NULL
  • company_guid — varchar(50) — Foreign key → aml_company.company_guid — NOT NULL
  • position — varchar(50)
  • name_ko — varchar(50)
  • name_en — varchar(50)
  • birth — date
  • create_dt — date
  • expire_dt — date
  • enabled — int(11)

aml_edd

  • company_guid — varchar(50) — Foreign key → aml_company.company_guid — NOT NULL
  • aml_id — varchar(50) — Foreign key → aml_kyc.aml_id
  • seq — int(11)
  • edd_guid — varchar(50)
  • reason_for_transfer — text
  • processing_status — varchar(50)
  • requester_guid — varchar(50)
  • reviewer_guid — varchar(50)
  • approver_guid — varchar(50)
  • transaction_status — varchar(50)
  • result_reply — varchar(50)
  • create_dt — date

aml_invoice

  • seq — int(11)
  • company_guid — varchar(50) — Foreign key → aml_company.company_guid — NOT NULL
  • create_dt — date
  • state — varchar(50)
  • recipient_guid — varchar(50)
  • recipient_email — varchar(50)
  • recpieint_name (recipient_name) — varchar(50)
  • tid — varchar(50)
  • ref_id — varchar(50)
  • sender_name — varchar(50)

aml_kyc

  • aml_id — varchar(50) — Primary key
  • seq — int(11)
  • company_guid (company_guid2) — varchar(50) — Foreign key → aml_company.company_guid — NOT NULL
  • requester_guid — verchar(50)
  • requester_name — varchar(50)
  • create_dt — date
  • registration_number — varchar(50)
  • service_type — varchar(50)
  • sender — varchar(50)
  • account_verification — varchar(50)
  • id_card_verification — varchar(50)
  • dowjonse — varchar(50)
  • state — varchar(50)
  • account_name — varchar(50)
  • account_number — varchar(50)
  • id_card_image — varchar(50)
  • id_card_type — varchar(50)
  • id_card_resident_number — varchar(50)
  • id_card_create_dt — date
  • id_card_birth — date

aml_request

  • aml_id — varchar(50) — Primary key
  • company_guid — varchar(50) — Foreign key → aml_company.company_guid — NOT NULL
  • location — varchar(50)
  • tid — varchar(50)
  • request_dt — date
  • reviewer — varchar(50)
  • approver — varchar(50)
  • state — varchar(50)
  • contents — varchar(50)

aml_residual_risk_management

  • aml_id — varchar(50) — Primary key — NOT NULL
  • id — int(11)
  • category — varchar(50)
  • identified_risk — text
  • importance — int(11)
  • known_risk_level — int(11)
  • future_risk_level — int(11)
  • future_risk_factors — varchar(50)
  • occurrence_frequency — int(11)
  • risk_score — int(11)
  • manager — varchar(50)
  • create_dt — date
  • measures — text
  • document — text
  • update_dt — date
  • company_guid — varchar(50) — Foreign key → aml_company.company_guid — NOT NULL

aml_terms

  • aml_id — varchar(50) — Primary key — NOT NULL
  • company_guid — varchar(50) — Foreign key → aml_company.company_guid — NOT NULL
  • name — varchar(50)
  • contents — text
  • message — text
  • requester — varchar(50)
  • reviewer — varchar(50)
  • approver — varchar(50)
  • create_dt — date

aml_token

  • ip — varchar(50)
  • aud (audience) — varchar(50)
  • exp (expiraton) — date
  • uid — varchar(50)
  • iat (issued at) — date
  • jti — varchar(50)

aml_user

  • user_guid — varchar(50) — Primary key
  • uid — varchar(50)
  • company_guid — varchar(50) — Foreign key → aml_company.company_guid — NOT NULL
  • position — varchar(50)
  • name — varchar(50)
  • create_dt — date
  • reviewer — varchar(50)
  • approver — varchar(50)
  • affiliate — varchar(50)
  • email — varchar(50)
  • enabled — int(11)
  • authority — varchar(50)

user_log

  • aml_id — varchar(50) — Primary key — NOT NULL
  • user_guid — varchar(50) — Foreign key → aml_user.user_guid
  • ip — varchar(50)
  • date — date
  • menu — varchar(50)
  • action — varchar(50)