?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
Finished outstanding doc TODOs in meta document. (#6987)
[openemr.git] / Documentation / EHI_Export / docs / tables / users.html
blob528f3191e1d132bf0bfbfb0415baa58bc107b68d
1 <!DOCTYPE html>
2 <html>
3 <head>
4 <meta charset="utf-8">
5 <meta http-equiv="X-UA-Compatible" content="IE=edge">
6 <title>users - openemr.openemr</title>
7 <!-- Tell the browser to be responsive to screen width -->
8 <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
9 <link rel="icon" type="image/png" sizes="16x16" href="../favicon.png">
10 <!-- Bootstrap 3.3.5 -->
11 <link rel="stylesheet" href="../bower/admin-lte/bootstrap/css/bootstrap.min.css">
12 <!-- Font Awesome -->
13 <link rel="stylesheet" href="../bower/font-awesome/css/font-awesome.min.css">
14 <!-- Ionicons -->
15 <link rel="stylesheet" href="../bower/ionicons/css/ionicons.min.css">
16 <!-- DataTables -->
17 <link rel="stylesheet" href="../bower/datatables.net-bs/css/dataTables.bootstrap.min.css">
18 <link rel="stylesheet" href="../bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css">
19 <!-- Code Mirror -->
20 <link rel="stylesheet" href="../bower/codemirror/codemirror.css">
21 <!-- Fonts -->
22 <link href='../fonts/indieflower/indie-flower.css' rel='stylesheet' type='text/css'>
23 <link href='../fonts/source-sans-pro/source-sans-pro.css' rel='stylesheet' type='text/css'>
24
25 <!-- Theme style -->
26 <link rel="stylesheet" href="../bower/admin-lte/dist/css/AdminLTE.min.css">
27 <!-- Salvattore -->
28 <link rel="stylesheet" href="../bower/salvattore/salvattore.css">
29 <!-- AdminLTE Skins. Choose a skin from the css/skins
30 folder instead of downloading all of them to reduce the load. -->
31 <link rel="stylesheet" href="../bower/admin-lte/dist/css/skins/_all-skins.min.css">
32 <!-- SchemaSpy -->
33 <link rel="stylesheet" href="../schemaSpy.css">
34
35 <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
36 <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
37 <!--[if lt IE 9]>
38 <script src="../bower/html5shiv/html5shiv.min.js"></script>
39 <script src="../bower/respond/respond.min.js"></script>
40 <![endif]-->
41 </head>
42 <!-- ADD THE CLASS layout-top-nav TO REMOVE THE SIDEBAR. -->
43 <body class="hold-transition skin-blue layout-top-nav">
44 <div class="wrapper">
45 <header class="main-header">
46 <nav class="navbar navbar-static-top">
47 <div class="container">
48 <div class="navbar-header">
49 <a href="../index.html" class="navbar-brand"><b>openemr</b></a><span class="navbar-brand" style="padding-left: 0">.openemr</span>
50 <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button>
51 </div>
52
53 <!-- Collect the nav links, forms, and other content for toggling -->
54 <div class="collapse navbar-collapse pull-left" id="navbar-collapse">
55 <ul class="nav navbar-nav">
56 <li><a href="../index.html">Tables <span class="sr-only">(current)</span></a></li>
57 <li><a href="../columns.html" title="All of the columns in the schema">Columns</a></li>
58 <!-- <li><a href="../constraints.html" title="Useful for diagnosing error messages that just give constraint name or number">Constraints</a></li>-->
59 <li><a href="../relationships.html" title="Diagram of table relationships">Relationships</a></li>
60 <!-- <li><a href="../orphans.html" title="View of tables with neither parents nor children">Orphan&nbsp;Tables</a></li> -->
61 <!-- <li><a href="../anomalies.html" title="Things that might not be quite right">Anomalies</a></li> -->
62 <!-- <li><a href="../routines.html" title="Procedures and functions">Routines</a></li> -->
63 </ul>
64 </div>
65 <!-- /.navbar-collapse -->
66 <!-- Navbar Right Menu -->
67 </div>
68 <!-- /.container-fluid -->
69 </nav>
70 </header>
71 <!-- Main content -->
72 <!-- Full Width Column -->
73 <div class="content-wrapper">
74 <!-- Content Header (Page header) -->
75 <section class="content-header">
76 <h1>users</h1><br />
77 <p>If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of users.csv</p>
78 <p>If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element</p>
79 <div class="box box-primary">
80 <div class="box-header with-border">
81 <i class="fa fa-file-text-o"></i>
82 <h3 id="Description" class="box-title">Description</h3>
83 <div class="box-tools pull-right">
84 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
85 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
86 </div>
87 </div><!-- /.box-header -->
88 <div class="box-body clearfix">
89 <p>Contains actors in the system that are not patients. This includes providers, employees, and external organizations/contacts records as well as system processes. This does not include API actors</p>
90 </div><!-- /.box-body -->
91 </div>
92 </section>
93 <!-- Main content -->
94 <section class="content">
95 <div class="box box-primary">
96 <div class="box-header with-border">
97 <span class="glyphicon glyphicon-list-alt" aria-hidden="true"></span>
98 <h3 id="Columns" class="box-title">Columns</h3>
99 <div class="box-tools pull-right">
100 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
101 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
102 </div>
103 </div>
104 <div class="box-body">
105 <table
106 id="standard_table"
107 class="table table-bordered table-striped dataTable"
108 role="grid"
109 data-paging="false"
110 data-page-length="10"
111 data-length-change="false">
112 <thead align='left'>
113 <tr>
114 <th>Column</th>
115 <th>Type</th>
116 <th>Size</th>
117 <th title='Are nulls allowed?'>Nulls</th>
118 <th title='Is column automatically updated?'>Auto</th>
119 <th title='Default value'>Default</th>
120 <th title='Columns in tables that reference this column'>Children</th>
121 <th title='Columns in tables that are referenced by this column'>Parents</th>
122 <th title='Comments' class="toggle"><span>Comments</span></th>
123 </tr>
124 </thead>
125 <tbody>
126 <tr>
127 <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="id">id</span></td>
128 <td>BIGINT</td>
129 <td>19</td>
130 <td title=''></td>
131 <td title='Automatically updated by the database'>√</td>
132 <td>null</td>
133 <td>
134 <table border='0' cellspacing='0' cellpadding='0'>
135 <tr>
136 <td title="amendments.created_by references users.id"><a href='amendments.html'>amendments</a><span class='relatedKey'>.created_by</span></td>
137 <td class="constraint detail">Defined in XML</td>
138 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
139 </tr>
140 <tr>
141 <td title="amendments.modified_by references users.id"><a href='amendments.html'>amendments</a><span class='relatedKey'>.modified_by</span></td>
142 <td class="constraint detail">Defined in XML</td>
143 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
144 </tr>
145 <tr>
146 <td title="ar_activity.post_user references users.id"><a href='ar_activity.html'>ar_activity</a><span class='relatedKey'>.post_user</span></td>
147 <td class="constraint detail">Defined in XML</td>
148 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
149 </tr>
150 <tr>
151 <td title="ar_session.user_id references users.id"><a href='ar_session.html'>ar_session</a><span class='relatedKey'>.user_id</span></td>
152 <td class="constraint detail">Defined in XML</td>
153 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
154 </tr>
155 <tr>
156 <td title="billing.user references users.id"><a href='billing.html'>billing</a><span class='relatedKey'>.user</span></td>
157 <td class="constraint detail">Defined in XML</td>
158 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
159 </tr>
160 <tr>
161 <td title="documents.owner references users.id"><a href='documents.html'>documents</a><span class='relatedKey'>.owner</span></td>
162 <td class="constraint detail">Defined in XML</td>
163 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
164 </tr>
165 <tr>
166 <td title="esign_signatures.uid references users.id"><a href='esign_signatures.html'>esign_signatures</a><span class='relatedKey'>.uid</span></td>
167 <td class="constraint detail">Defined in XML</td>
168 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
169 </tr>
170 <tr>
171 <td title="form_groups_encounter.provider_id references users.id"><a href='form_groups_encounter.html'>form_groups_encounter</a><span class='relatedKey'>.provider_id</span></td>
172 <td class="constraint detail">Defined in XML</td>
173 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
174 </tr>
175 <tr>
176 <td title="form_groups_encounter.supervisor_id references users.id"><a href='form_groups_encounter.html'>form_groups_encounter</a><span class='relatedKey'>.supervisor_id</span></td>
177 <td class="constraint detail">Defined in XML</td>
178 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
179 </tr>
180 <tr>
181 <td title="form_painmap.user references users.id"><a href='form_painmap.html'>form_painmap</a><span class='relatedKey'>.user</span></td>
182 <td class="constraint detail">Defined in XML</td>
183 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
184 </tr>
185 <tr>
186 <td title="form_phq9.user references users.id"><a href='form_phq9.html'>form_phq9</a><span class='relatedKey'>.user</span></td>
187 <td class="constraint detail">Defined in XML</td>
188 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
189 </tr>
190 <tr>
191 <td title="form_sdoh.user references users.id"><a href='form_sdoh.html'>form_sdoh</a><span class='relatedKey'>.user</span></td>
192 <td class="constraint detail">Defined in XML</td>
193 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
194 </tr>
195 <tr>
196 <td title="form_treatment_plan.user references users.id"><a href='form_treatment_plan.html'>form_treatment_plan</a><span class='relatedKey'>.user</span></td>
197 <td class="constraint detail">Defined in XML</td>
198 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
199 </tr>
200 <tr>
201 <td title="forms.provider_id references users.id"><a href='forms.html'>forms</a><span class='relatedKey'>.provider_id</span></td>
202 <td class="constraint detail">Defined in XML</td>
203 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
204 </tr>
205 <tr>
206 <td title="history_data.created_by references users.id"><a href='history_data.html'>history_data</a><span class='relatedKey'>.created_by</span></td>
207 <td class="constraint detail">Defined in XML</td>
208 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
209 </tr>
210 <tr>
211 <td title="immunization_observation.imo_user references users.id"><a href='immunization_observation.html'>immunization_observation</a><span class='relatedKey'>.imo_user</span></td>
212 <td class="constraint detail">Defined in XML</td>
213 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
214 </tr>
215 <tr>
216 <td title="immunizations.administered_by_id references users.id"><a href='immunizations.html'>immunizations</a><span class='relatedKey'>.administered_by_id</span></td>
217 <td class="constraint detail">Defined in XML</td>
218 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
219 </tr>
220 <tr>
221 <td title="immunizations.created_by references users.id"><a href='immunizations.html'>immunizations</a><span class='relatedKey'>.created_by</span></td>
222 <td class="constraint detail">Defined in XML</td>
223 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
224 </tr>
225 <tr>
226 <td title="immunizations.ordering_provider references users.id"><a href='immunizations.html'>immunizations</a><span class='relatedKey'>.ordering_provider</span></td>
227 <td class="constraint detail">Defined in XML</td>
228 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
229 </tr>
230 <tr>
231 <td title="immunizations.updated_by references users.id"><a href='immunizations.html'>immunizations</a><span class='relatedKey'>.updated_by</span></td>
232 <td class="constraint detail">Defined in XML</td>
233 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
234 </tr>
235 <tr>
236 <td title="lists_medication.created_by references users.id"><a href='lists_medication.html'>lists_medication</a><span class='relatedKey'>.created_by</span></td>
237 <td class="constraint detail">Defined in XML</td>
238 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
239 </tr>
240 <tr>
241 <td title="medex_recalls.r_provider references users.id"><a href='medex_recalls.html'>medex_recalls</a><span class='relatedKey'>.r_provider</span></td>
242 <td class="constraint detail">Defined in XML</td>
243 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
244 </tr>
245 <tr>
246 <td title="onsite_documents.user references users.id"><a href='onsite_documents.html'>onsite_documents</a><span class='relatedKey'>.user</span></td>
247 <td class="constraint detail">Defined in XML</td>
248 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
249 </tr>
250 <tr>
251 <td title="amendments_history.created_by references users.id"><a href='amendments_history.html'>amendments_history</a><span class='relatedKey'>.created_by</span></td>
252 <td class="constraint detail">Defined in XML</td>
253 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
254 </tr>
255 <tr>
256 <td title="form_gad7.user references users.id"><a href='form_gad7.html'>form_gad7</a><span class='relatedKey'>.user</span></td>
257 <td class="constraint detail">Defined in XML</td>
258 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
259 </tr>
260 <tr>
261 <td title="notes.owner references users.id"><a href='notes.html'>notes</a><span class='relatedKey'>.owner</span></td>
262 <td class="constraint detail">Defined in XML</td>
263 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
264 </tr>
265 <tr>
266 <td title="openemr_postcalendar_events.pc_aid references users.id"><a href='openemr_postcalendar_events.html'>openemr_postcalendar_events</a><span class='relatedKey'>.pc_aid</span></td>
267 <td class="constraint detail">Defined in XML</td>
268 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
269 </tr>
270 <tr>
271 <td title="openemr_postcalendar_events.pc_informant references users.id"><a href='openemr_postcalendar_events.html'>openemr_postcalendar_events</a><span class='relatedKey'>.pc_informant</span></td>
272 <td class="constraint detail">Defined in XML</td>
273 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
274 </tr>
275 <tr>
276 <td title="patient_data.created_by references users.id"><a href='patient_data.html'>patient_data</a><span class='relatedKey'>.created_by</span></td>
277 <td class="constraint detail">Defined in XML</td>
278 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
279 </tr>
280 <tr>
281 <td title="patient_data.providerID references users.id"><a href='patient_data.html'>patient_data</a><span class='relatedKey'>.providerID</span></td>
282 <td class="constraint detail">Defined in XML</td>
283 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
284 </tr>
285 <tr>
286 <td title="patient_data.ref_providerID references users.id"><a href='patient_data.html'>patient_data</a><span class='relatedKey'>.ref_providerID</span></td>
287 <td class="constraint detail">Defined in XML</td>
288 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
289 </tr>
290 <tr>
291 <td title="patient_data.updated_by references users.id"><a href='patient_data.html'>patient_data</a><span class='relatedKey'>.updated_by</span></td>
292 <td class="constraint detail">Defined in XML</td>
293 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
294 </tr>
295 <tr>
296 <td title="patient_history.created_by references users.id"><a href='patient_history.html'>patient_history</a><span class='relatedKey'>.created_by</span></td>
297 <td class="constraint detail">Defined in XML</td>
298 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
299 </tr>
300 <tr>
301 <td title="pnotes.assigned_to references users.id"><a href='pnotes.html'>pnotes</a><span class='relatedKey'>.assigned_to</span></td>
302 <td class="constraint detail">Defined in XML</td>
303 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
304 </tr>
305 <tr>
306 <td title="pnotes.update_by references users.id"><a href='pnotes.html'>pnotes</a><span class='relatedKey'>.update_by</span></td>
307 <td class="constraint detail">Defined in XML</td>
308 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
309 </tr>
310 <tr>
311 <td title="pnotes.user references users.id"><a href='pnotes.html'>pnotes</a><span class='relatedKey'>.user</span></td>
312 <td class="constraint detail">Defined in XML</td>
313 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
314 </tr>
315 <tr>
316 <td title="prescriptions.created_by references users.id"><a href='prescriptions.html'>prescriptions</a><span class='relatedKey'>.created_by</span></td>
317 <td class="constraint detail">Defined in XML</td>
318 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
319 </tr>
320 <tr>
321 <td title="prescriptions.provider_id references users.id"><a href='prescriptions.html'>prescriptions</a><span class='relatedKey'>.provider_id</span></td>
322 <td class="constraint detail">Defined in XML</td>
323 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
324 </tr>
325 <tr>
326 <td title="prescriptions.updated_by references users.id"><a href='prescriptions.html'>prescriptions</a><span class='relatedKey'>.updated_by</span></td>
327 <td class="constraint detail">Defined in XML</td>
328 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
329 </tr>
330 <tr>
331 <td title="pro_assessments.user_id references users.id"><a href='pro_assessments.html'>pro_assessments</a><span class='relatedKey'>.user_id</span></td>
332 <td class="constraint detail">Defined in XML</td>
333 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
334 </tr>
335 <tr>
336 <td title="procedure_order.collector_id references users.id"><a href='procedure_order.html'>procedure_order</a><span class='relatedKey'>.collector_id</span></td>
337 <td class="constraint detail">Defined in XML</td>
338 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
339 </tr>
340 <tr>
341 <td title="procedure_order.provider_id references users.id"><a href='procedure_order.html'>procedure_order</a><span class='relatedKey'>.provider_id</span></td>
342 <td class="constraint detail">Defined in XML</td>
343 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
344 </tr>
345 <tr>
346 <td title="procedure_report.source references users.id"><a href='procedure_report.html'>procedure_report</a><span class='relatedKey'>.source</span></td>
347 <td class="constraint detail">Defined in XML</td>
348 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
349 </tr>
350 <tr>
351 <td title="questionnaire_response.audit_user_id references users.id"><a href='questionnaire_response.html'>questionnaire_response</a><span class='relatedKey'>.audit_user_id</span></td>
352 <td class="constraint detail">Defined in XML</td>
353 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
354 </tr>
355 <tr>
356 <td title="questionnaire_response.creator_user_id references users.id"><a href='questionnaire_response.html'>questionnaire_response</a><span class='relatedKey'>.creator_user_id</span></td>
357 <td class="constraint detail">Defined in XML</td>
358 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
359 </tr>
360 <tr>
361 <td title="shared_attributes.user_id references users.id"><a href='shared_attributes.html'>shared_attributes</a><span class='relatedKey'>.user_id</span></td>
362 <td class="constraint detail">Defined in XML</td>
363 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
364 </tr>
365 <tr>
366 <td title="therapy_groups_counselors.user_id references users.id"><a href='therapy_groups_counselors.html'>therapy_groups_counselors</a><span class='relatedKey'>.user_id</span></td>
367 <td class="constraint detail">Defined in XML</td>
368 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
369 </tr>
370 <tr>
371 <td title="voids.user_id references users.id"><a href='voids.html'>voids</a><span class='relatedKey'>.user_id</span></td>
372 <td class="constraint detail">Defined in XML</td>
373 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
374 </tr>
375 </table>
376 </td>
377 <td>
378 <table border='0' cellspacing='0' cellpadding='0'>
379 </table>
380 </td>
381 <td><p>Unique identifier for each user in the system.</p></td>
382 </tr>
383 <tr>
384 <td class='indexedColumn' title='Indexed'><i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'></i><span id="uuid">uuid</span></td>
385 <td>BINARY</td>
386 <td>16</td>
387 <td title='nullable'>√</td>
388 <td title=''></td>
389 <td>null</td>
390 <td>
391 <table border='0' cellspacing='0' cellpadding='0'>
392 </table>
393 </td>
394 <td>
395 <table border='0' cellspacing='0' cellpadding='0'>
396 </table>
397 </td>
398 <td><p>Universally unique identifier for the user.</p></td>
399 </tr>
400 <tr>
401 <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="username">username</span></td>
402 <td>VARCHAR</td>
403 <td>255</td>
404 <td title='nullable'>√</td>
405 <td title=''></td>
406 <td>null</td>
407 <td>
408 <table border='0' cellspacing='0' cellpadding='0'>
409 <tr>
410 <td title="form_aftercare_plan.user references users.username"><a href='form_aftercare_plan.html'>form_aftercare_plan</a><span class='relatedKey'>.user</span></td>
411 <td class="constraint detail">Defined in XML</td>
412 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
413 </tr>
414 <tr>
415 <td title="form_ankleinjury.user references users.username"><a href='form_ankleinjury.html'>form_ankleinjury</a><span class='relatedKey'>.user</span></td>
416 <td class="constraint detail">Defined in XML</td>
417 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
418 </tr>
419 <tr>
420 <td title="form_bronchitis.user references users.username"><a href='form_bronchitis.html'>form_bronchitis</a><span class='relatedKey'>.user</span></td>
421 <td class="constraint detail">Defined in XML</td>
422 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
423 </tr>
424 <tr>
425 <td title="form_CAMOS_category.user references users.username"><a href='form_CAMOS_category.html'>form_CAMOS_category</a><span class='relatedKey'>.user</span></td>
426 <td class="constraint detail">Defined in XML</td>
427 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
428 </tr>
429 <tr>
430 <td title="form_CAMOS_item.user references users.username"><a href='form_CAMOS_item.html'>form_CAMOS_item</a><span class='relatedKey'>.user</span></td>
431 <td class="constraint detail">Defined in XML</td>
432 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
433 </tr>
434 <tr>
435 <td title="form_group_attendance.user references users.username"><a href='form_group_attendance.html'>form_group_attendance</a><span class='relatedKey'>.user</span></td>
436 <td class="constraint detail">Defined in XML</td>
437 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
438 </tr>
439 <tr>
440 <td title="form_questionnaire_assessments.user references users.username"><a href='form_questionnaire_assessments.html'>form_questionnaire_assessments</a><span class='relatedKey'>.user</span></td>
441 <td class="constraint detail">Defined in XML</td>
442 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
443 </tr>
444 <tr>
445 <td title="form_vitals.user references users.username"><a href='form_vitals.html'>form_vitals</a><span class='relatedKey'>.user</span></td>
446 <td class="constraint detail">Defined in XML</td>
447 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
448 </tr>
449 <tr>
450 <td title="forms.user references users.username"><a href='forms.html'>forms</a><span class='relatedKey'>.user</span></td>
451 <td class="constraint detail">Defined in XML</td>
452 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
453 </tr>
454 <tr>
455 <td title="groups.user references users.username"><a href='groups.html'>groups</a><span class='relatedKey'>.user</span></td>
456 <td class="constraint detail">Defined in XML</td>
457 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
458 </tr>
459 <tr>
460 <td title="lists.user references users.username"><a href='lists.html'>lists</a><span class='relatedKey'>.user</span></td>
461 <td class="constraint detail">Defined in XML</td>
462 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
463 </tr>
464 <tr>
465 <td title="patient_tracker.original_user references users.username"><a href='patient_tracker.html'>patient_tracker</a><span class='relatedKey'>.original_user</span></td>
466 <td class="constraint detail">Defined in XML</td>
467 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
468 </tr>
469 <tr>
470 <td title="patient_tracker_element.user references users.username"><a href='patient_tracker_element.html'>patient_tracker_element</a><span class='relatedKey'>.user</span></td>
471 <td class="constraint detail">Defined in XML</td>
472 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
473 </tr>
474 </table>
475 </td>
476 <td>
477 <table border='0' cellspacing='0' cellpadding='0'>
478 </table>
479 </td>
480 <td><p>The username associated with the user&rsquo;s account.</p></td>
481 </tr>
482 <tr>
483 <td><span id="password">password</span></td>
484 <td>LONGTEXT</td>
485 <td>2147483647</td>
486 <td title='nullable'>√</td>
487 <td title=''></td>
488 <td>null</td>
489 <td>
490 <table border='0' cellspacing='0' cellpadding='0'>
491 </table>
492 </td>
493 <td>
494 <table border='0' cellspacing='0' cellpadding='0'>
495 </table>
496 </td>
497 <td><p>The password for the user&rsquo;s account.</p></td>
498 </tr>
499 <tr>
500 <td><span id="authorized">authorized</span></td>
501 <td>TINYINT</td>
502 <td>3</td>
503 <td title='nullable'>√</td>
504 <td title=''></td>
505 <td>null</td>
506 <td>
507 <table border='0' cellspacing='0' cellpadding='0'>
508 </table>
509 </td>
510 <td>
511 <table border='0' cellspacing='0' cellpadding='0'>
512 </table>
513 </td>
514 <td><p>Indicates whether the user is authorized (1 for authorized, 0 for unauthorized).</p></td>
515 </tr>
516 <tr>
517 <td><span id="info">info</span></td>
518 <td>LONGTEXT</td>
519 <td>2147483647</td>
520 <td title='nullable'>√</td>
521 <td title=''></td>
522 <td>null</td>
523 <td>
524 <table border='0' cellspacing='0' cellpadding='0'>
525 </table>
526 </td>
527 <td>
528 <table border='0' cellspacing='0' cellpadding='0'>
529 </table>
530 </td>
531 <td><p>Additional information or notes about the user.</p></td>
532 </tr>
533 <tr>
534 <td><span id="source">source</span></td>
535 <td>TINYINT</td>
536 <td>3</td>
537 <td title='nullable'>√</td>
538 <td title=''></td>
539 <td>null</td>
540 <td>
541 <table border='0' cellspacing='0' cellpadding='0'>
542 </table>
543 </td>
544 <td>
545 <table border='0' cellspacing='0' cellpadding='0'>
546 </table>
547 </td>
548 <td><p>An indicator of the source of the user (e.g., internal or external).</p></td>
549 </tr>
550 <tr>
551 <td><span id="fname">fname</span></td>
552 <td>VARCHAR</td>
553 <td>255</td>
554 <td title='nullable'>√</td>
555 <td title=''></td>
556 <td>null</td>
557 <td>
558 <table border='0' cellspacing='0' cellpadding='0'>
559 </table>
560 </td>
561 <td>
562 <table border='0' cellspacing='0' cellpadding='0'>
563 </table>
564 </td>
565 <td><p>First name of the user.</p></td>
566 </tr>
567 <tr>
568 <td><span id="mname">mname</span></td>
569 <td>VARCHAR</td>
570 <td>255</td>
571 <td title='nullable'>√</td>
572 <td title=''></td>
573 <td>null</td>
574 <td>
575 <table border='0' cellspacing='0' cellpadding='0'>
576 </table>
577 </td>
578 <td>
579 <table border='0' cellspacing='0' cellpadding='0'>
580 </table>
581 </td>
582 <td><p>Middle name of the user.</p></td>
583 </tr>
584 <tr>
585 <td><span id="lname">lname</span></td>
586 <td>VARCHAR</td>
587 <td>255</td>
588 <td title='nullable'>√</td>
589 <td title=''></td>
590 <td>null</td>
591 <td>
592 <table border='0' cellspacing='0' cellpadding='0'>
593 </table>
594 </td>
595 <td>
596 <table border='0' cellspacing='0' cellpadding='0'>
597 </table>
598 </td>
599 <td><p>Last name of the user.</p></td>
600 </tr>
601 <tr>
602 <td><span id="suffix">suffix</span></td>
603 <td>VARCHAR</td>
604 <td>255</td>
605 <td title='nullable'>√</td>
606 <td title=''></td>
607 <td>null</td>
608 <td>
609 <table border='0' cellspacing='0' cellpadding='0'>
610 </table>
611 </td>
612 <td>
613 <table border='0' cellspacing='0' cellpadding='0'>
614 </table>
615 </td>
616 <td><p>Suffix for the user&rsquo;s name (e.g., Jr., Sr.).</p></td>
617 </tr>
618 <tr>
619 <td><span id="federaltaxid">federaltaxid</span></td>
620 <td>VARCHAR</td>
621 <td>255</td>
622 <td title='nullable'>√</td>
623 <td title=''></td>
624 <td>null</td>
625 <td>
626 <table border='0' cellspacing='0' cellpadding='0'>
627 </table>
628 </td>
629 <td>
630 <table border='0' cellspacing='0' cellpadding='0'>
631 </table>
632 </td>
633 <td><p>Federal Tax ID associated with the user.</p></td>
634 </tr>
635 <tr>
636 <td><span id="federaldrugid">federaldrugid</span></td>
637 <td>VARCHAR</td>
638 <td>255</td>
639 <td title='nullable'>√</td>
640 <td title=''></td>
641 <td>null</td>
642 <td>
643 <table border='0' cellspacing='0' cellpadding='0'>
644 </table>
645 </td>
646 <td>
647 <table border='0' cellspacing='0' cellpadding='0'>
648 </table>
649 </td>
650 <td><p>Federal Drug ID associated with the user.</p></td>
651 </tr>
652 <tr>
653 <td><span id="upin">upin</span></td>
654 <td>VARCHAR</td>
655 <td>255</td>
656 <td title='nullable'>√</td>
657 <td title=''></td>
658 <td>null</td>
659 <td>
660 <table border='0' cellspacing='0' cellpadding='0'>
661 </table>
662 </td>
663 <td>
664 <table border='0' cellspacing='0' cellpadding='0'>
665 </table>
666 </td>
667 <td><p>Universal Physician Identification Number for the user.</p></td>
668 </tr>
669 <tr>
670 <td><span id="facility">facility</span></td>
671 <td>VARCHAR</td>
672 <td>255</td>
673 <td title='nullable'>√</td>
674 <td title=''></td>
675 <td>null</td>
676 <td>
677 <table border='0' cellspacing='0' cellpadding='0'>
678 </table>
679 </td>
680 <td>
681 <table border='0' cellspacing='0' cellpadding='0'>
682 </table>
683 </td>
684 <td><p>The facility where the user is associated.</p></td>
685 </tr>
686 <tr>
687 <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="facility_id">facility_id</span></td>
688 <td>INT</td>
689 <td>10</td>
690 <td title=''></td>
691 <td title=''></td>
692 <td>0</td>
693 <td>
694 <table border='0' cellspacing='0' cellpadding='0'>
695 </table>
696 </td>
697 <td>
698 <table border='0' cellspacing='0' cellpadding='0'>
699 <tr>
700 <td title="users.facility_id references facility.id"><a href='facility.html'>facility</a><span class='relatedKey'>.id</span></td>
701 <td class="constraint detail">Defined in XML</td>
702 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
703 </tr>
704 </table>
705 </td>
706 <td><p>Unique identifier for the user&rsquo;s associated facility.</p></td>
707 </tr>
708 <tr>
709 <td><span id="see_auth">see_auth</span></td>
710 <td>INT</td>
711 <td>10</td>
712 <td title=''></td>
713 <td title=''></td>
714 <td>1</td>
715 <td>
716 <table border='0' cellspacing='0' cellpadding='0'>
717 </table>
718 </td>
719 <td>
720 <table border='0' cellspacing='0' cellpadding='0'>
721 </table>
722 </td>
723 <td><p>Indicates if the user has the ability to see authorizations.</p></td>
724 </tr>
725 <tr>
726 <td><span id="active">active</span></td>
727 <td>BIT</td>
728 <td>1</td>
729 <td title=''></td>
730 <td title=''></td>
731 <td>1</td>
732 <td>
733 <table border='0' cellspacing='0' cellpadding='0'>
734 </table>
735 </td>
736 <td>
737 <table border='0' cellspacing='0' cellpadding='0'>
738 </table>
739 </td>
740 <td><p>Indicates the user&rsquo;s activity status (1 for active, 0 for inactive).</p></td>
741 </tr>
742 <tr>
743 <td><span id="npi">npi</span></td>
744 <td>VARCHAR</td>
745 <td>15</td>
746 <td title='nullable'>√</td>
747 <td title=''></td>
748 <td>null</td>
749 <td>
750 <table border='0' cellspacing='0' cellpadding='0'>
751 </table>
752 </td>
753 <td>
754 <table border='0' cellspacing='0' cellpadding='0'>
755 </table>
756 </td>
757 <td><p>National Provider Identifier for the user.</p></td>
758 </tr>
759 <tr>
760 <td><span id="title">title</span></td>
761 <td>VARCHAR</td>
762 <td>30</td>
763 <td title='nullable'>√</td>
764 <td title=''></td>
765 <td>null</td>
766 <td>
767 <table border='0' cellspacing='0' cellpadding='0'>
768 </table>
769 </td>
770 <td>
771 <table border='0' cellspacing='0' cellpadding='0'>
772 </table>
773 </td>
774 <td><p>Title or designation of the user (e.g., MD, RN).</p></td>
775 </tr>
776 <tr>
777 <td><span id="specialty">specialty</span></td>
778 <td>VARCHAR</td>
779 <td>255</td>
780 <td title='nullable'>√</td>
781 <td title=''></td>
782 <td>null</td>
783 <td>
784 <table border='0' cellspacing='0' cellpadding='0'>
785 </table>
786 </td>
787 <td>
788 <table border='0' cellspacing='0' cellpadding='0'>
789 </table>
790 </td>
791 <td><p>The specialty of the user (e.g., cardiology, pediatrics).</p></td>
792 </tr>
793 <tr>
794 <td><span id="billname">billname</span></td>
795 <td>VARCHAR</td>
796 <td>255</td>
797 <td title='nullable'>√</td>
798 <td title=''></td>
799 <td>null</td>
800 <td>
801 <table border='0' cellspacing='0' cellpadding='0'>
802 </table>
803 </td>
804 <td>
805 <table border='0' cellspacing='0' cellpadding='0'>
806 </table>
807 </td>
808 <td><p>Billing name for the user.</p></td>
809 </tr>
810 <tr>
811 <td><span id="email">email</span></td>
812 <td>VARCHAR</td>
813 <td>255</td>
814 <td title='nullable'>√</td>
815 <td title=''></td>
816 <td>null</td>
817 <td>
818 <table border='0' cellspacing='0' cellpadding='0'>
819 </table>
820 </td>
821 <td>
822 <table border='0' cellspacing='0' cellpadding='0'>
823 </table>
824 </td>
825 <td><p>Email address associated with the user&rsquo;s account. EMPTY for exports</p></td>
826 </tr>
827 <tr>
828 <td><span id="email_direct">email_direct</span></td>
829 <td>VARCHAR</td>
830 <td>255</td>
831 <td title=''></td>
832 <td title=''></td>
833 <td></td>
834 <td>
835 <table border='0' cellspacing='0' cellpadding='0'>
836 </table>
837 </td>
838 <td>
839 <table border='0' cellspacing='0' cellpadding='0'>
840 </table>
841 </td>
842 <td><p>Trusted Direct email address for the user.</p></td>
843 </tr>
844 <tr>
845 <td class='indexedColumn' title='Indexed'><i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'></i><span id="google_signin_email">google_signin_email</span></td>
846 <td>VARCHAR</td>
847 <td>255</td>
848 <td title='nullable'>√</td>
849 <td title=''></td>
850 <td>null</td>
851 <td>
852 <table border='0' cellspacing='0' cellpadding='0'>
853 </table>
854 </td>
855 <td>
856 <table border='0' cellspacing='0' cellpadding='0'>
857 </table>
858 </td>
859 <td><p>Email address for Google Sign-In (if applicable). EMPTY for exports</p></td>
860 </tr>
861 <tr>
862 <td><span id="url">url</span></td>
863 <td>VARCHAR</td>
864 <td>255</td>
865 <td title='nullable'>√</td>
866 <td title=''></td>
867 <td>null</td>
868 <td>
869 <table border='0' cellspacing='0' cellpadding='0'>
870 </table>
871 </td>
872 <td>
873 <table border='0' cellspacing='0' cellpadding='0'>
874 </table>
875 </td>
876 <td><p>URL associated with the user&rsquo;s profile.</p></td>
877 </tr>
878 <tr>
879 <td><span id="assistant">assistant</span></td>
880 <td>VARCHAR</td>
881 <td>255</td>
882 <td title='nullable'>√</td>
883 <td title=''></td>
884 <td>null</td>
885 <td>
886 <table border='0' cellspacing='0' cellpadding='0'>
887 </table>
888 </td>
889 <td>
890 <table border='0' cellspacing='0' cellpadding='0'>
891 </table>
892 </td>
893 <td><p>Name of the user&rsquo;s assistant or support staff.</p></td>
894 </tr>
895 <tr>
896 <td><span id="organization">organization</span></td>
897 <td>VARCHAR</td>
898 <td>255</td>
899 <td title='nullable'>√</td>
900 <td title=''></td>
901 <td>null</td>
902 <td>
903 <table border='0' cellspacing='0' cellpadding='0'>
904 </table>
905 </td>
906 <td>
907 <table border='0' cellspacing='0' cellpadding='0'>
908 </table>
909 </td>
910 <td><p>Name of the user&rsquo;s organization or practice.</p></td>
911 </tr>
912 <tr>
913 <td><span id="valedictory">valedictory</span></td>
914 <td>VARCHAR</td>
915 <td>255</td>
916 <td title='nullable'>√</td>
917 <td title=''></td>
918 <td>null</td>
919 <td>
920 <table border='0' cellspacing='0' cellpadding='0'>
921 </table>
922 </td>
923 <td>
924 <table border='0' cellspacing='0' cellpadding='0'>
925 </table>
926 </td>
927 <td><p>Valedictory or honorary title of the user.</p></td>
928 </tr>
929 <tr>
930 <td><span id="street">street</span></td>
931 <td>VARCHAR</td>
932 <td>60</td>
933 <td title='nullable'>√</td>
934 <td title=''></td>
935 <td>null</td>
936 <td>
937 <table border='0' cellspacing='0' cellpadding='0'>
938 </table>
939 </td>
940 <td>
941 <table border='0' cellspacing='0' cellpadding='0'>
942 </table>
943 </td>
944 <td><p>Street address for the user. EMPTY for exports</p></td>
945 </tr>
946 <tr>
947 <td><span id="streetb">streetb</span></td>
948 <td>VARCHAR</td>
949 <td>60</td>
950 <td title='nullable'>√</td>
951 <td title=''></td>
952 <td>null</td>
953 <td>
954 <table border='0' cellspacing='0' cellpadding='0'>
955 </table>
956 </td>
957 <td>
958 <table border='0' cellspacing='0' cellpadding='0'>
959 </table>
960 </td>
961 <td><p>Secondary street address for the user. EMPTY for exports</p></td>
962 </tr>
963 <tr>
964 <td><span id="city">city</span></td>
965 <td>VARCHAR</td>
966 <td>30</td>
967 <td title='nullable'>√</td>
968 <td title=''></td>
969 <td>null</td>
970 <td>
971 <table border='0' cellspacing='0' cellpadding='0'>
972 </table>
973 </td>
974 <td>
975 <table border='0' cellspacing='0' cellpadding='0'>
976 </table>
977 </td>
978 <td><p>City of residence or practice for the user. EMPTY for exports</p></td>
979 </tr>
980 <tr>
981 <td><span id="state">state</span></td>
982 <td>VARCHAR</td>
983 <td>30</td>
984 <td title='nullable'>√</td>
985 <td title=''></td>
986 <td>null</td>
987 <td>
988 <table border='0' cellspacing='0' cellpadding='0'>
989 </table>
990 </td>
991 <td>
992 <table border='0' cellspacing='0' cellpadding='0'>
993 </table>
994 </td>
995 <td><p>State or province of residence or practice for the user. EMPTY for exports</p></td>
996 </tr>
997 <tr>
998 <td><span id="zip">zip</span></td>
999 <td>VARCHAR</td>
1000 <td>20</td>
1001 <td title='nullable'>√</td>
1002 <td title=''></td>
1003 <td>null</td>
1004 <td>
1005 <table border='0' cellspacing='0' cellpadding='0'>
1006 </table>
1007 </td>
1008 <td>
1009 <table border='0' cellspacing='0' cellpadding='0'>
1010 </table>
1011 </td>
1012 <td><p>ZIP code or postal code for the user. EMPTY for exports</p></td>
1013 </tr>
1014 <tr>
1015 <td><span id="street2">street2</span></td>
1016 <td>VARCHAR</td>
1017 <td>60</td>
1018 <td title='nullable'>√</td>
1019 <td title=''></td>
1020 <td>null</td>
1021 <td>
1022 <table border='0' cellspacing='0' cellpadding='0'>
1023 </table>
1024 </td>
1025 <td>
1026 <table border='0' cellspacing='0' cellpadding='0'>
1027 </table>
1028 </td>
1029 <td><p>Alternative street address for the user. EMPTY for exports</p></td>
1030 </tr>
1031 <tr>
1032 <td><span id="streetb2">streetb2</span></td>
1033 <td>VARCHAR</td>
1034 <td>60</td>
1035 <td title='nullable'>√</td>
1036 <td title=''></td>
1037 <td>null</td>
1038 <td>
1039 <table border='0' cellspacing='0' cellpadding='0'>
1040 </table>
1041 </td>
1042 <td>
1043 <table border='0' cellspacing='0' cellpadding='0'>
1044 </table>
1045 </td>
1046 <td><p>Alternative street address for the user. EMPTY for exports</p></td>
1047 </tr>
1048 <tr>
1049 <td><span id="city2">city2</span></td>
1050 <td>VARCHAR</td>
1051 <td>30</td>
1052 <td title='nullable'>√</td>
1053 <td title=''></td>
1054 <td>null</td>
1055 <td>
1056 <table border='0' cellspacing='0' cellpadding='0'>
1057 </table>
1058 </td>
1059 <td>
1060 <table border='0' cellspacing='0' cellpadding='0'>
1061 </table>
1062 </td>
1063 <td><p>Alternative City of residence or practice for the user. EMPTY for exports</p></td>
1064 </tr>
1065 <tr>
1066 <td><span id="state2">state2</span></td>
1067 <td>VARCHAR</td>
1068 <td>30</td>
1069 <td title='nullable'>√</td>
1070 <td title=''></td>
1071 <td>null</td>
1072 <td>
1073 <table border='0' cellspacing='0' cellpadding='0'>
1074 </table>
1075 </td>
1076 <td>
1077 <table border='0' cellspacing='0' cellpadding='0'>
1078 </table>
1079 </td>
1080 <td><p>Alternative State or province of residence or practice for the user. EMPTY for exports</p></td>
1081 </tr>
1082 <tr>
1083 <td><span id="zip2">zip2</span></td>
1084 <td>VARCHAR</td>
1085 <td>20</td>
1086 <td title='nullable'>√</td>
1087 <td title=''></td>
1088 <td>null</td>
1089 <td>
1090 <table border='0' cellspacing='0' cellpadding='0'>
1091 </table>
1092 </td>
1093 <td>
1094 <table border='0' cellspacing='0' cellpadding='0'>
1095 </table>
1096 </td>
1097 <td><p>Alternative ZIP code or postal code for the user. EMPTY for exports</p></td>
1098 </tr>
1099 <tr>
1100 <td><span id="phone">phone</span></td>
1101 <td>VARCHAR</td>
1102 <td>30</td>
1103 <td title='nullable'>√</td>
1104 <td title=''></td>
1105 <td>null</td>
1106 <td>
1107 <table border='0' cellspacing='0' cellpadding='0'>
1108 </table>
1109 </td>
1110 <td>
1111 <table border='0' cellspacing='0' cellpadding='0'>
1112 </table>
1113 </td>
1114 <td><p>Phone number for the user. EMPTY for exports</p></td>
1115 </tr>
1116 <tr>
1117 <td><span id="fax">fax</span></td>
1118 <td>VARCHAR</td>
1119 <td>30</td>
1120 <td title='nullable'>√</td>
1121 <td title=''></td>
1122 <td>null</td>
1123 <td>
1124 <table border='0' cellspacing='0' cellpadding='0'>
1125 </table>
1126 </td>
1127 <td>
1128 <table border='0' cellspacing='0' cellpadding='0'>
1129 </table>
1130 </td>
1131 <td><p>Fax number for the user. EMPTY for exports</p></td>
1132 </tr>
1133 <tr>
1134 <td><span id="phonew1">phonew1</span></td>
1135 <td>VARCHAR</td>
1136 <td>30</td>
1137 <td title='nullable'>√</td>
1138 <td title=''></td>
1139 <td>null</td>
1140 <td>
1141 <table border='0' cellspacing='0' cellpadding='0'>
1142 </table>
1143 </td>
1144 <td>
1145 <table border='0' cellspacing='0' cellpadding='0'>
1146 </table>
1147 </td>
1148 <td><p>Work phone number for the user.</p></td>
1149 </tr>
1150 <tr>
1151 <td><span id="phonew2">phonew2</span></td>
1152 <td>VARCHAR</td>
1153 <td>30</td>
1154 <td title='nullable'>√</td>
1155 <td title=''></td>
1156 <td>null</td>
1157 <td>
1158 <table border='0' cellspacing='0' cellpadding='0'>
1159 </table>
1160 </td>
1161 <td>
1162 <table border='0' cellspacing='0' cellpadding='0'>
1163 </table>
1164 </td>
1165 <td><p>Alternative Work phone number for the user.</p></td>
1166 </tr>
1167 <tr>
1168 <td><span id="phonecell">phonecell</span></td>
1169 <td>VARCHAR</td>
1170 <td>30</td>
1171 <td title='nullable'>√</td>
1172 <td title=''></td>
1173 <td>null</td>
1174 <td>
1175 <table border='0' cellspacing='0' cellpadding='0'>
1176 </table>
1177 </td>
1178 <td>
1179 <table border='0' cellspacing='0' cellpadding='0'>
1180 </table>
1181 </td>
1182 <td><p>Cell phone number for the user. EMPTY for exports</p></td>
1183 </tr>
1184 <tr>
1185 <td><span id="notes">notes</span></td>
1186 <td>TEXT</td>
1187 <td>65535</td>
1188 <td title='nullable'>√</td>
1189 <td title=''></td>
1190 <td>null</td>
1191 <td>
1192 <table border='0' cellspacing='0' cellpadding='0'>
1193 </table>
1194 </td>
1195 <td>
1196 <table border='0' cellspacing='0' cellpadding='0'>
1197 </table>
1198 </td>
1199 <td><p>Additional notes or comments about the user. EMPTY for exports</p></td>
1200 </tr>
1201 <tr>
1202 <td><span id="cal_ui">cal_ui</span></td>
1203 <td>TINYINT</td>
1204 <td>3</td>
1205 <td title=''></td>
1206 <td title=''></td>
1207 <td>1</td>
1208 <td>
1209 <table border='0' cellspacing='0' cellpadding='0'>
1210 </table>
1211 </td>
1212 <td>
1213 <table border='0' cellspacing='0' cellpadding='0'>
1214 </table>
1215 </td>
1216 <td><p>UNUSED</p></td>
1217 </tr>
1218 <tr>
1219 <td><span id="taxonomy">taxonomy</span></td>
1220 <td>VARCHAR</td>
1221 <td>30</td>
1222 <td title=''></td>
1223 <td title=''></td>
1224 <td>207Q00000X</td>
1225 <td>
1226 <table border='0' cellspacing='0' cellpadding='0'>
1227 </table>
1228 </td>
1229 <td>
1230 <table border='0' cellspacing='0' cellpadding='0'>
1231 </table>
1232 </td>
1233 <td><p>Taxonomy code associated with the user.</p></td>
1234 </tr>
1235 <tr>
1236 <td><span id="calendar">calendar</span></td>
1237 <td>BIT</td>
1238 <td>1</td>
1239 <td title=''></td>
1240 <td title=''></td>
1241 <td>0</td>
1242 <td>
1243 <table border='0' cellspacing='0' cellpadding='0'>
1244 </table>
1245 </td>
1246 <td>
1247 <table border='0' cellspacing='0' cellpadding='0'>
1248 </table>
1249 </td>
1250 <td><p>Indicates whether the user appears in the calendar (1 for appears, 0 for doesn&rsquo;t appear).</p></td>
1251 </tr>
1252 <tr>
1253 <td class='indexedColumn' title='Indexed'><i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'></i><span id="abook_type">abook_type</span></td>
1254 <td>VARCHAR</td>
1255 <td>31</td>
1256 <td title=''></td>
1257 <td title=''></td>
1258 <td></td>
1259 <td>
1260 <table border='0' cellspacing='0' cellpadding='0'>
1261 </table>
1262 </td>
1263 <td>
1264 <table border='0' cellspacing='0' cellpadding='0'>
1265 </table>
1266 </td>
1267 <td><p>Address book type for the user.</p></td>
1268 </tr>
1269 <tr>
1270 <td><span id="default_warehouse">default_warehouse</span></td>
1271 <td>VARCHAR</td>
1272 <td>31</td>
1273 <td title=''></td>
1274 <td title=''></td>
1275 <td></td>
1276 <td>
1277 <table border='0' cellspacing='0' cellpadding='0'>
1278 </table>
1279 </td>
1280 <td>
1281 <table border='0' cellspacing='0' cellpadding='0'>
1282 </table>
1283 </td>
1284 <td><p>Default warehouse for the user.</p></td>
1285 </tr>
1286 <tr>
1287 <td><span id="irnpool">irnpool</span></td>
1288 <td>VARCHAR</td>
1289 <td>31</td>
1290 <td title=''></td>
1291 <td title=''></td>
1292 <td></td>
1293 <td>
1294 <table border='0' cellspacing='0' cellpadding='0'>
1295 </table>
1296 </td>
1297 <td>
1298 <table border='0' cellspacing='0' cellpadding='0'>
1299 </table>
1300 </td>
1301 <td><p>IRN (Insurance Referral Network) pool for the user.</p></td>
1302 </tr>
1303 <tr>
1304 <td><span id="state_license_number">state_license_number</span></td>
1305 <td>VARCHAR</td>
1306 <td>25</td>
1307 <td title='nullable'>√</td>
1308 <td title=''></td>
1309 <td>null</td>
1310 <td>
1311 <table border='0' cellspacing='0' cellpadding='0'>
1312 </table>
1313 </td>
1314 <td>
1315 <table border='0' cellspacing='0' cellpadding='0'>
1316 </table>
1317 </td>
1318 <td><p>State license number for the user.</p></td>
1319 </tr>
1320 <tr>
1321 <td><span id="weno_prov_id">weno_prov_id</span></td>
1322 <td>VARCHAR</td>
1323 <td>15</td>
1324 <td title='nullable'>√</td>
1325 <td title=''></td>
1326 <td>null</td>
1327 <td>
1328 <table border='0' cellspacing='0' cellpadding='0'>
1329 </table>
1330 </td>
1331 <td>
1332 <table border='0' cellspacing='0' cellpadding='0'>
1333 </table>
1334 </td>
1335 <td><p>WENO Provider ID for the user. EMPTY for exports</p></td>
1336 </tr>
1337 <tr>
1338 <td><span id="newcrop_user_role">newcrop_user_role</span></td>
1339 <td>VARCHAR</td>
1340 <td>30</td>
1341 <td title='nullable'>√</td>
1342 <td title=''></td>
1343 <td>null</td>
1344 <td>
1345 <table border='0' cellspacing='0' cellpadding='0'>
1346 </table>
1347 </td>
1348 <td>
1349 <table border='0' cellspacing='0' cellpadding='0'>
1350 </table>
1351 </td>
1352 <td><p>NewCrop user role for the user.EMPTY for exports</p></td>
1353 </tr>
1354 <tr>
1355 <td><span id="cpoe">cpoe</span></td>
1356 <td>BIT</td>
1357 <td>1</td>
1358 <td title='nullable'>√</td>
1359 <td title=''></td>
1360 <td>null</td>
1361 <td>
1362 <table border='0' cellspacing='0' cellpadding='0'>
1363 </table>
1364 </td>
1365 <td>
1366 <table border='0' cellspacing='0' cellpadding='0'>
1367 </table>
1368 </td>
1369 <td><p>Indicates whether the user has CPOE (Computerized Physician Order Entry) capabilities.</p></td>
1370 </tr>
1371 <tr>
1372 <td><span id="physician_type">physician_type</span></td>
1373 <td>VARCHAR</td>
1374 <td>50</td>
1375 <td title='nullable'>√</td>
1376 <td title=''></td>
1377 <td>null</td>
1378 <td>
1379 <table border='0' cellspacing='0' cellpadding='0'>
1380 </table>
1381 </td>
1382 <td>
1383 <table border='0' cellspacing='0' cellpadding='0'>
1384 </table>
1385 </td>
1386 <td><p>Type or designation of the physician (e.g., standard, specialist).</p></td>
1387 </tr>
1388 <tr>
1389 <td><span id="main_menu_role">main_menu_role</span></td>
1390 <td>VARCHAR</td>
1391 <td>50</td>
1392 <td title=''></td>
1393 <td title=''></td>
1394 <td>standard</td>
1395 <td>
1396 <table border='0' cellspacing='0' cellpadding='0'>
1397 </table>
1398 </td>
1399 <td>
1400 <table border='0' cellspacing='0' cellpadding='0'>
1401 </table>
1402 </td>
1403 <td><p>Main menu role for the user. EMPTY for exports</p></td>
1404 </tr>
1405 <tr>
1406 <td><span id="patient_menu_role">patient_menu_role</span></td>
1407 <td>VARCHAR</td>
1408 <td>50</td>
1409 <td title=''></td>
1410 <td title=''></td>
1411 <td>standard</td>
1412 <td>
1413 <table border='0' cellspacing='0' cellpadding='0'>
1414 </table>
1415 </td>
1416 <td>
1417 <table border='0' cellspacing='0' cellpadding='0'>
1418 </table>
1419 </td>
1420 <td><p>Patient menu role for the user. EMPTY for exports</p></td>
1421 </tr>
1422 <tr>
1423 <td><span id="portal_user">portal_user</span></td>
1424 <td>BIT</td>
1425 <td>1</td>
1426 <td title=''></td>
1427 <td title=''></td>
1428 <td>0</td>
1429 <td>
1430 <table border='0' cellspacing='0' cellpadding='0'>
1431 </table>
1432 </td>
1433 <td>
1434 <table border='0' cellspacing='0' cellpadding='0'>
1435 </table>
1436 </td>
1437 <td><p>Indicates if the user is a portal user (1 for portal user, 0 for non-portal user). EMPTY for exports</p></td>
1438 </tr>
1439 <tr>
1440 <td><span id="supervisor_id">supervisor_id</span></td>
1441 <td>INT</td>
1442 <td>10</td>
1443 <td title=''></td>
1444 <td title=''></td>
1445 <td>0</td>
1446 <td>
1447 <table border='0' cellspacing='0' cellpadding='0'>
1448 </table>
1449 </td>
1450 <td>
1451 <table border='0' cellspacing='0' cellpadding='0'>
1452 </table>
1453 </td>
1454 <td><p>Unique identifier of the user&rsquo;s supervisor. EMPTY for exports</p></td>
1455 </tr>
1456 <tr>
1457 <td><span id="billing_facility">billing_facility</span></td>
1458 <td>TEXT</td>
1459 <td>65535</td>
1460 <td title='nullable'>√</td>
1461 <td title=''></td>
1462 <td>null</td>
1463 <td>
1464 <table border='0' cellspacing='0' cellpadding='0'>
1465 </table>
1466 </td>
1467 <td>
1468 <table border='0' cellspacing='0' cellpadding='0'>
1469 </table>
1470 </td>
1471 <td><p>Billing facility information for the user.</p></td>
1472 </tr>
1473 <tr>
1474 <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="billing_facility_id">billing_facility_id</span></td>
1475 <td>INT</td>
1476 <td>10</td>
1477 <td title=''></td>
1478 <td title=''></td>
1479 <td>0</td>
1480 <td>
1481 <table border='0' cellspacing='0' cellpadding='0'>
1482 </table>
1483 </td>
1484 <td>
1485 <table border='0' cellspacing='0' cellpadding='0'>
1486 <tr>
1487 <td title="users.billing_facility_id references facility.id"><a href='facility.html'>facility</a><span class='relatedKey'>.id</span></td>
1488 <td class="constraint detail">Defined in XML</td>
1489 <td class="constraint detail"><span title='Restrict delete:&#10;Parent cannot be deleted if children exist'>R</span></td>
1490 </tr>
1491 </table>
1492 </td>
1493 <td><p>Unique identifier for the user&rsquo;s billing facility.</p></td>
1494 </tr>
1495 </tbody>
1496 </table>
1497 </div>
1498 </div>
1499 <div class="box box-primary">
1500 <div class="box-header with-border">
1501 <i class="fa fa-sitemap"></i>
1502 <h3 id="Indexes" class="box-title">Indexes</h3>
1503 <div class="box-tools pull-right">
1504 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
1505 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
1506 </div>
1507 </div>
1508 <div class="box-body">
1509 <table
1510 id="indexes_table"
1511 class="table table-bordered table-striped dataTable"
1512 role="grid"
1513 data-paging="false"
1514 data-page-length="10"
1515 data-length-change="false">
1516 <thead>
1517 <tr>
1518 <th>Constraint Name</th>
1519 <th>Type</th>
1520 <th>Sort</th>
1521 <th>Column(s)</th>
1522 </tr>
1523 </thead>
1524 <tbody>
1525 <tr>
1526 <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey'></i> PRIMARY</td>
1527 <td>Primary key</td>
1528 <td><span title='Ascending'>Asc</span></td>
1529 <td>id</td>
1530 </tr>
1531 <tr>
1532 <td title='Indexed'>abook_type</td>
1533 <td>Performance</td>
1534 <td><span title='Ascending'>Asc</span></td>
1535 <td>abook_type</td>
1536 </tr>
1537 <tr>
1538 <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> google_signin_email</td>
1539 <td>Must be unique</td>
1540 <td><span title='Ascending'>Asc</span></td>
1541 <td>google_signin_email</td>
1542 </tr>
1543 <tr>
1544 <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> uuid</td>
1545 <td>Must be unique</td>
1546 <td><span title='Ascending'>Asc</span></td>
1547 <td>uuid</td>
1548 </tr>
1549 </tbody>
1550 </table>
1551 </div><!-- /.box-body -->
1552 </div>
1553 <div class="box box-primary">
1554 <div class="box-header with-border">
1555 <i class="fa fa-code-fork"></i>
1556 <h3 id="Relationships" class="box-title">Relationships</h3>
1557 <div class="box-tools pull-right">
1558 <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>
1559 <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
1560 </div>
1561 </div>
1562 <div class="box-body">
1563 <div class="nav-tabs-custom"><!-- Tabs within a box -->
1564 <h5>Close relationships within degrees of separation</h5>
1565 <ul class="nav nav-tabs pull-left ui-sortable-handle">
1566 <li class="active"><a href="#oneDegreeImg-chart" data-toggle="tab" aria-expanded="true">One</a></li>
1567 <li class=""><a href="#twodegreesDegreeImg-chart" data-toggle="tab" aria-expanded="true">Two degrees</a></li>
1568 </ul>
1569 <div class="tab-content no-padding">
1570 <div class="chart tab-pane active" id="oneDegreeImg-chart" style="position: relative; overflow-x:auto;">
1571
1572 <a name='diagram'><object type="image/svg+xml" id="oneDegreeImg" data="../diagrams/tables/users.1degree.svg" class="diagram" border="0" align="left"></object></a>
1573 </div>
1574 <div class="chart tab-pane " id="twodegreesDegreeImg-chart" style="position: relative; overflow-x:auto;">
1575
1576 <a name='diagram'><object type="image/svg+xml" id="twodegreesDegreeImg" data="../diagrams/tables/users.2degrees.svg" class="diagram" border="0" align="left"></object></a>
1577 </div>
1578 </div>
1579 </div>
1580 </div><!-- /.box-body -->
1581 </div>
1582 </section>
1583 <script>
1584 var config = {
1585 pagination: false
1586 }
1587 </script>
1588
1589 </div>
1590 <!-- /.content-wrapper -->
1591 <footer class="main-footer">
1592 <div>
1593 <div class="pull-right hidden-xs">
1594 <a href="https://github.com/schemaspy/schemaspy" title="GitHub for SchemaSpy"><i class="fa fa-github-square fa-2x"></i></a>
1595 <a href="http://stackoverflow.com/questions/tagged/schemaspy" title="StackOverflow for SchemaSpy"><i class="fa fa-stack-overflow fa-2x"></i></a>
1596 </div>
1597 <strong>Generated by <a href="http://schemaspy.org/" class="logo-text"><i class="fa fa-database"></i> SchemaSpy 6.2.4</a></strong>
1598 </div>
1599 <!-- /.container -->
1600 </footer>
1601 </div>
1602 <!-- ./wrapper -->
1603
1604 <!-- jQuery 2.2.3 -->
1605 <script src="../bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script>
1606 <script src="../bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script>
1607 <!-- Bootstrap 3.3.5 -->
1608 <script src="../bower/admin-lte/bootstrap/js/bootstrap.min.js"></script>
1609 <!-- DataTables -->
1610 <script src="../bower/datatables.net/jquery.dataTables.min.js"></script>
1611 <script src="../bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
1612 <script src="../bower/datatables.net-buttons/dataTables.buttons.min.js"></script>
1613 <script src="../bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script>
1614 <script src="../bower/datatables.net-buttons/buttons.html5.min.js"></script>
1615 <script src="../bower/datatables.net-buttons/buttons.print.min.js"></script>
1616 <script src="../bower/datatables.net-buttons/buttons.colVis.min.js"></script>
1617 <!-- SheetJS -->
1618 <script src="../bower/js-xlsx/xlsx.full.min.js"></script>
1619 <!-- pdfmake -->
1620 <script src="../bower/pdfmake/pdfmake.min.js"></script>
1621 <script src="../bower/pdfmake/vfs_fonts.js"></script>
1622 <!-- SlimScroll -->
1623 <script src="../bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script>
1624 <!-- FastClick -->
1625 <script src="../bower/admin-lte/plugins/fastclick/fastclick.js"></script>
1626 <!-- Salvattore -->
1627 <script src="../bower/salvattore/salvattore.min.js"></script>
1628 <!-- AnchorJS -->
1629 <script src="../bower/anchor-js/anchor.min.js"></script>
1630 <!-- CodeMirror -->
1631 <script src="../bower/codemirror/codemirror.js"></script>
1632 <script src="../bower/codemirror/sql.js"></script>
1633 <!-- AdminLTE App -->
1634 <script src="../bower/admin-lte/dist/js/app.min.js"></script>
1635 <script src="table.js"></script>
1636 <script src="../schemaSpy.js"></script>
1637 </body>
1638 </html>
Mirror of official OpenEMR Sourceforge repository