Data Model for a Client Data Management System

Join the Conversation

Tuesday, July 7th to Wednesday, September 30th

Please join us in an online, open forum on telehealth. NCB is providing an opportunity for clinicians to ask each other questions, share observations and adapted telehealth protocols for the SoT population via an online forum and technical exchange. This conversation will be a forum for peer-led informational exchange. NCB staff will assist in facilitating and monitoring the conversation.

Directions: Please watch Eugene Augusterfer’s presentation and interview Telemedicine in Mental Health first. Then feel free to join us in this open forum. All are welcome to join this forum, whether you have an account on or not. For more information on using the forum, please read the directions on the first post. Please keep your comments respectful, relevant, factual, and do not share identifying information about clients per client privacy and HIPAA regulations. This forum will be open from July 6, 2020 through September 30, 2020.

Part of the Client Data Toolkit, this is a generic data model for the client services database of a Torture Treatment Center. This model is a generic representaion of the type of data that might be used by a Torture Treatment Center providing direct client care services. There are thirty-one tables used for client demographics.

  • One main client table called T_Client.
  • Fifteen related client tables beginning with T_Client.
  • Thirty code tables used to lookup information in drop-down boxes.
  • The T_Client table stores one record for each client identified by a unique ClientID number.
  • The lines connecting each table show the relationships between the tables.
  • Lines between the main T_Client table and all related tables beginning with T_Client are one-to-many. This means one client can have many records in each related table. For instance, the table T_ClientService holds all records for services provided.


Average: 1 (1 vote)

Add new comment