Thai Token Exchange

# 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

}

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

```