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)