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
}

// ----------------------