Customer Database » History » Revision 6
Revision 5 (Ryan Supawarapong, 04/01/2026 01:21 AM) → Revision 6/9 (Ryan Supawarapong, 04/01/2026 01:25 AM)
# Customer Database
```
// 4 top layer 1
// Onboarding
// Customer
// Transaction: combine of customer and asset
// Digital Asset: asset_id
// Layer 2
// Fullname
// Customer info: link to transaction, onboarding
// customer suite test answer: answer
// suite test id: question and answer
// Layer 3
// suite test question and answer
// Knowledge test
// Layer 1
// ----------------------
// Onboarding
Table onboarding {
id int
register_id uuid
customer_info_id int [ref: - customer_info.id]
idcard_id int [ref: - idcard.id]
occupation_id int [ref: - occupation.id]
register_address_id int [ref : - address.id]
current_address_id int [ref : - address.id]
work_address_id int [ref : - address.id]
customer_suite_id int [ref: - customer_suite_submission.id]
cdd_id int [ref: - cdd.id]
bank_id int [ref: - bank.id]
secondary_bank_id int [ref: - bank.id]
source_of_fund_id int [ref: - source_of_fund.id]
thaid_id int [ref: - thaid.id]
ndid_id int [ref: - ndid.id]
approval_id int [ref: - approval.id]
appman_id int [ref: - appman.id]
risk_score_id int [ref: - risk_score.id]
has_done_knowledge_test bool
steps int
}
// Customer
Table customer {
id int
customer_info_id int [ref: - customer_info.id]
risk_score_id int [ref: - risk_score.id]
idcard_id int [ref: - idcard.id]
occupation_id int [ref: - occupation.id]
register_address_id int [ref : - address.id]
current_address_id int [ref : - address.id]
work_address_id int [ref : - address.id]
customer_suite_id int [ref: - customer_suite_submission.id]
bank_id int [ref: - bank.id]
secondary_bank_id int [ref: - bank.id]
source_of_fund_id int [ref: - source_of_fund.id]
}
// Transaction
Table transaction {
id uuid
seller_info_id int [ref: - customer_info.id]
}
// Digital Asset
Table digital_asset {
id uuid
customer_info_id int [ref: - customer_info.id]
asset_detail_id int [ref: - asset_detail.id]
}
// ----------------------
// Layer 2
// ----------------------
Table customer_info {
id int
mobile string
email string
title_id int [ref: - title.id]
first_name_th string
middle_name_th string
last_name_th string
first_name_en string
middle_name_en string
last_name_en string
customer_type enum
ip_id int [ref: - ip_detail.id]
}
Table address {
id int
house_number string
floor string
village_building string
sub_street strign
street strign
country_code string
location_id int
}
Table idcard {
id int
citizen_id string
laser_code string
date_of_birth timestamp
expire_date timestamp
issue_date timestamp
}
Table occupation {
id int
code string
position_name string
source_of_investment string
workplace_name string
education_id string [ref: - education.id]
occupation_id int [ref: - occupation.id]
business_type_id int [ref: - business_type.id]
income_range_id int [ref: - income_range.id]
}
Table customer_suite_answer {
id int
submission_id int [ref: > customer_suite_submission.id]
question_id int [ref: > suitability_question.id]
choice_id int [ref: > suitability_choice.id]
}
Table customer_suite_submission {
id int
customer_info_id int [ref: > customer_info.id]
total_score int
risk_level string
}
Table cdd {
id int
mule string
freeze_04 string
freeze_05 string
pep bool
pep_message string
dopa bool
}
Table appman {
id int
verification_id string
idcard_id int [ref: - appman_id_card.id]
liveness_id int [ref: - appman_liveness.id]
liveness_attribute_id int [ref: - appman_liveness_attributes.id]
recognition int [ref: - appman_recognition.id]
}
Table bank { //
id int
name string
branch string
account_no string
}
Table source_of_fund { //
id int
source_of_fund string
country_of_income string
purpose_of_investment string
}
Table thaid {
id int
url string
state string
thaid_detail_id int [ref: - thaid_detail.id]
}
Table ndid {
id int
ndid_detail_id int [ref: - ndid_detail.id]
}
Table approval {
id int
by string
name string
level int
message string
is_approve bool
}
Table risk_score {
id int
score int
risk_level int
}
Table asset_detail {
id int
name string
price float
}
// ----------------------
// Layer 3
// ----------------------
Table suitability_question {
id int
question string
}
Table suitability_choice {
id int
question_id int [ref: > suitability_question.id]
answer string
score int
}
Table appman_id_card {
id int
}
Table appman_liveness {
id int
}
Table appman_liveness_attributes {
id int
}
Table appman_recognition {
id int
}
Table education {
id int
code string
name string
}
Table business_type {
id int
name string
risk_score int
}
Table income_range {
id int
range string
}
Table thaid_detail {
id int
}
Table ndid_detail {
id int
}
Table ip_detail {
id int
ip_address string
country string
}
Table title {
id int
name_en string
name_th string
}
// ----------------------
```
Tree layer version:
```
.
├── Layer 1
│ ├── onboarding
│ │ ├── id: int
│ │ ├── register_id: uuid
│ │ ├── customer_info_id: int [ref: customer_info.id]
│ │ ├── idcard_id: int [ref: idcard.id]
│ │ ├── occupation_id: int [ref: occupation.id]
│ │ ├── register_address_id: int [ref: address.id]
│ │ ├── current_address_id: int [ref: address.id]
│ │ ├── work_address_id: int [ref: address.id]
│ │ ├── customer_suite_id: int [ref: customer_suite_submission.id]
│ │ ├── cdd_id: int [ref: cdd.id]
│ │ ├── bank_id: int [ref: bank.id]
│ │ ├── secondary_bank_id: int [ref: bank.id]
│ │ ├── source_of_fund_id: int [ref: source_of_fund.id]
│ │ ├── thaid_id: int [ref: thaid.id]
│ │ ├── ndid_id: int [ref: ndid.id]
│ │ ├── approval_id: int [ref: approval.id]
│ │ ├── appman_id: int [ref: appman.id]
│ │ ├── risk_score_id: int [ref: risk_score.id]
│ │ ├── has_done_knowledge_test: bool
│ │ └── steps: int
│ ├── customer
│ │ ├── id: int
│ │ ├── customer_info_id: int [ref: customer_info.id]
│ │ ├── risk_score_id: int [ref: risk_score.id]
│ │ ├── idcard_id: int [ref: idcard.id]
│ │ ├── occupation_id: int [ref: occupation.id]
│ │ ├── register_address_id: int [ref: address.id]
│ │ ├── current_address_id: int [ref: address.id]
│ │ ├── work_address_id: int [ref: address.id]
│ │ ├── customer_suite_id: int [ref: customer_suite_submission.id]
│ │ ├── bank_id: int [ref: bank.id]
│ │ ├── secondary_bank_id: int [ref: bank.id]
│ │ └── source_of_fund_id: int [ref: source_of_fund.id]
│ ├── transaction
│ │ ├── id: uuid
│ │ └── seller_info_id: int [ref: customer_info.id]
│ └── digital_asset
│ ├── id: uuid
│ ├── customer_info_id: int [ref: customer_info.id]
│ └── asset_detail_id: int [ref: asset_detail.id]
├── Layer 2
│ ├── customer_info
│ │ ├── id: int
│ │ ├── mobile: string
│ │ ├── email: string
│ │ ├── title_id: int [ref: title.id]
│ │ ├── first_name_th: string
│ │ ├── middle_name_th: string
│ │ ├── last_name_th: string
│ │ ├── first_name_en: string
│ │ ├── middle_name_en: string
│ │ ├── last_name_en: string
│ │ ├── customer_type: enum
│ │ └── ip_id: int [ref: ip_detail.id]
│ ├── address
│ │ ├── id: int
│ │ ├── house_number: string
│ │ ├── floor: string
│ │ ├── village_building: string
│ │ ├── sub_street: string
│ │ ├── street: string
│ │ ├── country_code: string
│ │ └── location_id: int
│ ├── idcard
│ │ ├── id: int
│ │ ├── citizen_id: string
│ │ ├── laser_code: string
│ │ ├── date_of_birth: timestamp
│ │ ├── expire_date: timestamp
│ │ └── issue_date: timestamp
│ ├── occupation
│ │ ├── id: int
│ │ ├── code: string
│ │ ├── position_name: string
│ │ ├── source_of_investment: string
│ │ ├── workplace_name: string
│ │ ├── education_id: string [ref: education.id]
│ │ ├── occupation_id: int [ref: occupation.id]
│ │ ├── business_type_id: int [ref: business_type.id]
│ │ └── income_range_id: int [ref: income_range.id]
│ ├── customer_suite_answer
│ │ ├── id: int
│ │ ├── submission_id: int [ref: customer_suite_submission.id]
│ │ ├── question_id: int [ref: suitability_question.id]
│ │ └── choice_id: int [ref: suitability_choice.id]
│ ├── customer_suite_submission
│ │ ├── id: int
│ │ ├── customer_info_id: int [ref: customer_info.id]
│ │ ├── total_score: int
│ │ └── risk_level: string
│ ├── cdd
│ │ ├── id: int
│ │ ├── mule: string
│ │ ├── freeze_04: string
│ │ ├── freeze_05: string
│ │ ├── pep: bool
│ │ ├── pep_message: string
│ │ └── dopa: bool
│ ├── appman
│ │ ├── id: int
│ │ ├── verification_id: string
│ │ ├── idcard_id: int [ref: appman_id_card.id]
│ │ ├── liveness_id: int [ref: appman_liveness.id]
│ │ ├── liveness_attribute_id: int [ref: appman_liveness_attributes.id]
│ │ └── recognition: int [ref: appman_recognition.id]
│ ├── bank
│ │ ├── id: int
│ │ ├── name: string
│ │ ├── branch: string
│ │ └── account_no: string
│ ├── source_of_fund
│ │ ├── id: int
│ │ ├── source_of_fund: string
│ │ ├── country_of_income: string
│ │ └── purpose_of_investment: string
│ ├── thaid
│ │ ├── id: int
│ │ ├── url: string
│ │ ├── state: string
│ │ └── thaid_detail_id: int [ref: thaid_detail.id]
│ ├── ndid
│ │ ├── id: int
│ │ └── ndid_detail_id: int [ref: ndid_detail.id]
│ ├── approval
│ │ ├── id: int
│ │ ├── by: string
│ │ ├── name: string
│ │ ├── level: int
│ │ ├── message: string
│ │ └── is_approve: bool
│ ├── risk_score
│ │ ├── id: int
│ │ ├── score: int
│ │ └── risk_level: int
│ └── asset_detail
│ ├── id: int
│ ├── name: string
│ └── price: float
└── Layer 3
├── suitability_question
│ ├── id: int
│ └── question: string
├── suitability_choice
│ ├── id: int
│ ├── question_id: int [ref: suitability_question.id]
│ ├── answer: string
│ └── score: int
├── appman_id_card
│ └── id: int
├── appman_liveness
│ └── id: int
├── appman_liveness_attributes
│ └── id: int
├── appman_recognition
│ └── id: int
├── education
│ ├── id: int
│ ├── code: string
│ └── name: string
├── business_type
│ ├── id: int
│ ├── name: string
│ └── risk_score: int
├── income_range
│ ├── id: int
│ └── range: string
├── thaid_detail
│ └── id: int
├── ndid_detail
│ └── id: int
├── ip_detail
│ ├── id: int
│ ├── ip_address: string
│ └── country: string
└── title
├── id: int
├── name_en: string
└── name_th: string
```