Thai Token Exchange

# Customer Database

<img style="width: 1327px;" src="clipboard-202603162047-hprot.png"><br>

```

Table appman {

  id int

  verification string

  attribute_id int

}

Table appman_attribute {

  id int

}

Ref: appman_attribute.id - appman.attribute_id

Table identity {

  id uuid

  customer_code int

  fullname_id int

  current_address_id int

  register_address_id int

  work_address_id int

  suite_test_id int

  occupation_id int

  education_id int

  workplace_id int

  income_id int

  customer_type int

}

Table fullname {

  id int

  th_first_name string

  th_middle_name string

  th_last_name string

  en_first_name string

  en_middle_name string

  en_last_name string

}

Table address {

  id int

  house_number string

  floor string

  village_building string

  sub_street strign

  street strign

  country_code string

  location_id  int

}

Table location {

  id int

  code int

  zipcode string

}

Ref: location.id < address.location_id

Ref: fullname.id - identity.fullname_id

Ref: address.id - identity.current_address_id 

Ref: address.id - identity.register_address_id

Ref: address.id - identity.work_address_id

Ref: suitetest.id - identity.suite_test_id

Ref: education.id - identity.education_id

Ref: occupation.id - identity.occupation_id

Ref: workplace.id - identity.workplace_id

Ref: income.id - identity.income_id

Table suitetest {

  id int

}

Table suitetest_question {

  id int

  value string

}

Table suitetest_answer {

  id int

  suitetest_id int [ref: > suitetest.id]

  question_id int [ref: > suitetest_question.id]

  value stirng

}

Table occupation {

  id int

  code string

  value string

}

Table education {

  id int

  code string

  value string

}

Table income {

  id int

  code string

  range string

}

Table workplace {

  id int

  position string

  name string

}

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

Table verification {

  id uuid

  email_id int

  mobile_id int

  appman_id int

  cdd_id int

  step int

}

Table mobile {

  id int

  value string

}

Table email {

  id int

  value string

}

Table cdd {

  id int

  face_compare_pass bool

  mule string

  freeze_04 string

  freeze_05 string

  pep bool

  pep_message string

  dopa bool

}

Ref: mobile.id - verification.mobile_id

Ref: email.id - verification.email_id

Ref: appman.id - verification.appman_id

Ref: cdd.id - verification.cdd_id

```