5 <meta http-equiv=
"X-UA-Compatible" content=
"IE=edge">
6 <title>openemr_postcalendar_categories - 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">
13 <link rel=
"stylesheet" href=
"../bower/font-awesome/css/font-awesome.min.css">
15 <link rel=
"stylesheet" href=
"../bower/ionicons/css/ionicons.min.css">
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">
20 <link rel=
"stylesheet" href=
"../bower/codemirror/codemirror.css">
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'
>
26 <link rel=
"stylesheet" href=
"../bower/admin-lte/dist/css/AdminLTE.min.css">
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">
33 <link rel=
"stylesheet" href=
"../schemaSpy.css">
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:// -->
38 <script src="../bower/html5shiv/html5shiv.min.js"></script>
39 <script src="../bower/respond/respond.min.js"></script>
42 <!-- ADD THE CLASS layout-top-nav TO REMOVE THE SIDEBAR. -->
43 <body class=
"hold-transition skin-blue layout-top-nav">
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>
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 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> -->
65 <!-- /.navbar-collapse -->
66 <!-- Navbar Right Menu -->
68 <!-- /.container-fluid -->
72 <!-- Full Width Column -->
73 <div class=
"content-wrapper">
74 <!-- Content Header (Page header) -->
75 <section class=
"content-header">
76 <h1>openemr_postcalendar_categories
</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 openemr_postcalendar_categories.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>
87 </div><!-- /.box-header -->
88 <div class=
"box-body clearfix">
89 <p>Contains the types / categories a patient scheduled appointment can be
</p>
90 </div><!-- /.box-body -->
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>
104 <div class=
"box-body">
107 class=
"table table-bordered table-striped dataTable"
110 data-page-length=
"10"
111 data-length-change=
"false">
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>
127 <td class='primaryKey' title='Primary Key'
><i class='icon ion-key iconkey' style='padding-left:
5px;'
></i><span id=
"pc_catid">pc_catid
</span></td>
128 <td>INT UNSIGNED
</td>
131 <td title='Automatically updated by the database'
>√
</td>
134 <table border='
0' cellspacing='
0' cellpadding='
0'
>
136 <td title=
"form_groups_encounter.pc_catid references openemr_postcalendar_categories.pc_catid"><a href='form_groups_encounter.html'
>form_groups_encounter
</a><span class='relatedKey'
>.pc_catid
</span></td>
137 <td class=
"constraint detail">Defined in XML
</td>
138 <td class=
"constraint detail"><span title='Restrict delete:
Parent cannot be deleted if children exist'
>R
</span></td>
141 <td title=
"openemr_postcalendar_events.pc_catid references openemr_postcalendar_categories.pc_catid"><a href='openemr_postcalendar_events.html'
>openemr_postcalendar_events
</a><span class='relatedKey'
>.pc_catid
</span></td>
142 <td class=
"constraint detail">Defined in XML
</td>
143 <td class=
"constraint detail"><span title='Restrict delete:
Parent cannot be deleted if children exist'
>R
</span></td>
146 <td title=
"openemr_postcalendar_events.pc_prefcatid references openemr_postcalendar_categories.pc_catid"><a href='openemr_postcalendar_events.html'
>openemr_postcalendar_events
</a><span class='relatedKey'
>.pc_prefcatid
</span></td>
147 <td class=
"constraint detail">Defined in XML
</td>
148 <td class=
"constraint detail"><span title='Restrict delete:
Parent cannot be deleted if children exist'
>R
</span></td>
153 <table border='
0' cellspacing='
0' cellpadding='
0'
>
156 <td><p>Auto-incremented identifier for the appointment category
</p></td>
159 <td class='indexedColumn' title='Indexed'
><i class='fa fa-sitemap fa-rotate-
120' style='padding-right:
5px;'
></i><span id=
"pc_constant_id">pc_constant_id
</span></td>
162 <td title='nullable'
>√
</td>
166 <table border='
0' cellspacing='
0' cellpadding='
0'
>
170 <table border='
0' cellspacing='
0' cellpadding='
0'
>
173 <td><p>Identifier for the appointment category which is referenced in the codebase for appointment specific functionality
</p></td>
176 <td class='indexedColumn' title='Indexed'
><i class='fa fa-sitemap fa-rotate-
120' style='padding-right:
5px;'
></i><span id=
"pc_catname">pc_catname
</span></td>
179 <td title='nullable'
>√
</td>
183 <table border='
0' cellspacing='
0' cellpadding='
0'
>
187 <table border='
0' cellspacing='
0' cellpadding='
0'
>
190 <td><p>Name of the appointment category
</p></td>
193 <td class='indexedColumn' title='Indexed'
><i class='fa fa-sitemap fa-rotate-
120' style='padding-right:
5px;'
></i><span id=
"pc_catcolor">pc_catcolor
</span></td>
196 <td title='nullable'
>√
</td>
200 <table border='
0' cellspacing='
0' cellpadding='
0'
>
204 <table border='
0' cellspacing='
0' cellpadding='
0'
>
207 <td><p>Visual display color associated with the appointment category
</p></td>
210 <td><span id=
"pc_catdesc">pc_catdesc
</span></td>
213 <td title='nullable'
>√
</td>
217 <table border='
0' cellspacing='
0' cellpadding='
0'
>
221 <table border='
0' cellspacing='
0' cellpadding='
0'
>
224 <td><p>Description of the appointment category
</p></td>
227 <td><span id=
"pc_recurrtype">pc_recurrtype
</span></td>
234 <table border='
0' cellspacing='
0' cellpadding='
0'
>
238 <table border='
0' cellspacing='
0' cellpadding='
0'
>
241 <td><p>Type of recurring appointment
0=Not recurring,
1=Recurring appointment
</p></td>
244 <td><span id=
"pc_enddate">pc_enddate
</span></td>
247 <td title='nullable'
>√
</td>
251 <table border='
0' cellspacing='
0' cellpadding='
0'
>
255 <table border='
0' cellspacing='
0' cellpadding='
0'
>
258 <td><p>End date of the appointment
</p></td>
261 <td><span id=
"pc_recurrspec">pc_recurrspec
</span></td>
264 <td title='nullable'
>√
</td>
268 <table border='
0' cellspacing='
0' cellpadding='
0'
>
272 <table border='
0' cellspacing='
0' cellpadding='
0'
>
275 <td><p>Specification for recurring appointments in php array serialized format. Includes information on the repeating frequency, the type of repeat (daily, weekday,week,monthly, etc)
</p></td>
278 <td><span id=
"pc_recurrfreq">pc_recurrfreq
</span></td>
285 <table border='
0' cellspacing='
0' cellpadding='
0'
>
289 <table border='
0' cellspacing='
0' cellpadding='
0'
>
292 <td><p>Frequency of recurring appointments
</p></td>
295 <td><span id=
"pc_duration">pc_duration
</span></td>
302 <table border='
0' cellspacing='
0' cellpadding='
0'
>
306 <table border='
0' cellspacing='
0' cellpadding='
0'
>
309 <td><p>Duration of the appointment in seconds
</p></td>
312 <td><span id=
"pc_end_date_flag">pc_end_date_flag
</span></td>
319 <table border='
0' cellspacing='
0' cellpadding='
0'
>
323 <table border='
0' cellspacing='
0' cellpadding='
0'
>
326 <td><p>Flag indicating the use of an end date for the appointment
</p></td>
329 <td><span id=
"pc_end_date_type">pc_end_date_type
</span></td>
332 <td title='nullable'
>√
</td>
336 <table border='
0' cellspacing='
0' cellpadding='
0'
>
340 <table border='
0' cellspacing='
0' cellpadding='
0'
>
343 <td><p>Type of end date for the appointment
</p></td>
346 <td><span id=
"pc_end_date_freq">pc_end_date_freq
</span></td>
353 <table border='
0' cellspacing='
0' cellpadding='
0'
>
357 <table border='
0' cellspacing='
0' cellpadding='
0'
>
360 <td><p>Frequency of the end date
</p></td>
363 <td><span id=
"pc_end_all_day">pc_end_all_day
</span></td>
370 <table border='
0' cellspacing='
0' cellpadding='
0'
>
374 <table border='
0' cellspacing='
0' cellpadding='
0'
>
377 <td><p>Flag indicating if the end date is all-day
</p></td>
380 <td><span id=
"pc_dailylimit">pc_dailylimit
</span></td>
387 <table border='
0' cellspacing='
0' cellpadding='
0'
>
391 <table border='
0' cellspacing='
0' cellpadding='
0'
>
394 <td><p>Limit on daily appointments for the category
</p></td>
397 <td><span id=
"pc_cattype">pc_cattype
</span></td>
404 <table border='
0' cellspacing='
0' cellpadding='
0'
>
408 <table border='
0' cellspacing='
0' cellpadding='
0'
>
411 <td><p>Type of category used in grouping categories
</p></td>
414 <td><span id=
"pc_active">pc_active
</span></td>
421 <table border='
0' cellspacing='
0' cellpadding='
0'
>
425 <table border='
0' cellspacing='
0' cellpadding='
0'
>
428 <td><p>Flag indicating the category is active
</p></td>
431 <td><span id=
"pc_seq">pc_seq
</span></td>
438 <table border='
0' cellspacing='
0' cellpadding='
0'
>
442 <table border='
0' cellspacing='
0' cellpadding='
0'
>
445 <td><p>Sequence number for the category
</p></td>
448 <td><span id=
"aco_spec">aco_spec
</span></td>
453 <td>encounters|notes
</td>
455 <table border='
0' cellspacing='
0' cellpadding='
0'
>
459 <table border='
0' cellspacing='
0' cellpadding='
0'
>
462 <td><p>Access control for the category. Empty on export
</p></td>
468 <div class=
"box box-primary">
469 <div class=
"box-header with-border">
470 <i class=
"fa fa-sitemap"></i>
471 <h3 id=
"Indexes" class=
"box-title">Indexes
</h3>
472 <div class=
"box-tools pull-right">
473 <button type=
"button" class=
"btn btn-box-tool" data-widget=
"collapse"><i class=
"fa fa-minus"></i></button>
474 <button type=
"button" class=
"btn btn-box-tool" data-widget=
"remove"><i class=
"fa fa-times"></i></button>
477 <div class=
"box-body">
480 class=
"table table-bordered table-striped dataTable"
483 data-page-length=
"10"
484 data-length-change=
"false">
487 <th>Constraint Name
</th>
495 <td class='primaryKey' title='Primary Key'
><i class='icon ion-key iconkey'
></i> PRIMARY
</td>
497 <td><span title='Ascending'
>Asc
</span></td>
501 <td title='Indexed'
>basic_cat
</td>
503 <td><span title='Ascending'
>Asc
</span>/
<span title='Ascending'
>Asc
</span></td>
504 <td>pc_catname + pc_catcolor
</td>
507 <td class='uniqueKey' title='Unique Key'
><i class='icon ion-key iconkey'
></i> pc_constant_id
</td>
508 <td>Must be unique
</td>
509 <td><span title='Ascending'
>Asc
</span></td>
510 <td>pc_constant_id
</td>
514 </div><!-- /.box-body -->
516 <div class=
"box box-primary">
517 <div class=
"box-header with-border">
518 <i class=
"fa fa-code-fork"></i>
519 <h3 id=
"Relationships" class=
"box-title">Relationships
</h3>
520 <div class=
"box-tools pull-right">
521 <button type=
"button" class=
"btn btn-box-tool" data-widget=
"collapse"><i class=
"fa fa-minus"></i></button>
522 <button type=
"button" class=
"btn btn-box-tool" data-widget=
"remove"><i class=
"fa fa-times"></i></button>
525 <div class=
"box-body">
526 <div class=
"nav-tabs-custom"><!-- Tabs within a box -->
527 <h5>Close relationships within degrees of separation
</h5>
528 <ul class=
"nav nav-tabs pull-left ui-sortable-handle">
529 <li class=
"active"><a href=
"#oneDegreeImg-chart" data-toggle=
"tab" aria-expanded=
"true">One
</a></li>
530 <li class=
""><a href=
"#twodegreesDegreeImg-chart" data-toggle=
"tab" aria-expanded=
"true">Two degrees
</a></li>
532 <div class=
"tab-content no-padding">
533 <div class=
"chart tab-pane active" id=
"oneDegreeImg-chart" style=
"position: relative; overflow-x:auto;">
535 <a name='diagram'
><object type=
"image/svg+xml" id=
"oneDegreeImg" data=
"../diagrams/tables/openemr_postcalendar_categories.1degree.svg" class=
"diagram" border=
"0" align=
"left"></object></a>
537 <div class=
"chart tab-pane " id=
"twodegreesDegreeImg-chart" style=
"position: relative; overflow-x:auto;">
539 <a name='diagram'
><object type=
"image/svg+xml" id=
"twodegreesDegreeImg" data=
"../diagrams/tables/openemr_postcalendar_categories.2degrees.svg" class=
"diagram" border=
"0" align=
"left"></object></a>
543 </div><!-- /.box-body -->
553 <!-- /.content-wrapper -->
554 <footer class=
"main-footer">
556 <div class=
"pull-right hidden-xs">
557 <a href=
"https://github.com/schemaspy/schemaspy" title=
"GitHub for SchemaSpy"><i class=
"fa fa-github-square fa-2x"></i></a>
558 <a href=
"http://stackoverflow.com/questions/tagged/schemaspy" title=
"StackOverflow for SchemaSpy"><i class=
"fa fa-stack-overflow fa-2x"></i></a>
560 <strong>Generated by
<a href=
"http://schemaspy.org/" class=
"logo-text"><i class=
"fa fa-database"></i> SchemaSpy
6.2.4</a></strong>
567 <!-- jQuery 2.2.3 -->
568 <script src=
"../bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script>
569 <script src=
"../bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script>
570 <!-- Bootstrap 3.3.5 -->
571 <script src=
"../bower/admin-lte/bootstrap/js/bootstrap.min.js"></script>
573 <script src=
"../bower/datatables.net/jquery.dataTables.min.js"></script>
574 <script src=
"../bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
575 <script src=
"../bower/datatables.net-buttons/dataTables.buttons.min.js"></script>
576 <script src=
"../bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script>
577 <script src=
"../bower/datatables.net-buttons/buttons.html5.min.js"></script>
578 <script src=
"../bower/datatables.net-buttons/buttons.print.min.js"></script>
579 <script src=
"../bower/datatables.net-buttons/buttons.colVis.min.js"></script>
581 <script src=
"../bower/js-xlsx/xlsx.full.min.js"></script>
583 <script src=
"../bower/pdfmake/pdfmake.min.js"></script>
584 <script src=
"../bower/pdfmake/vfs_fonts.js"></script>
586 <script src=
"../bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script>
588 <script src=
"../bower/admin-lte/plugins/fastclick/fastclick.js"></script>
590 <script src=
"../bower/salvattore/salvattore.min.js"></script>
592 <script src=
"../bower/anchor-js/anchor.min.js"></script>
594 <script src=
"../bower/codemirror/codemirror.js"></script>
595 <script src=
"../bower/codemirror/sql.js"></script>
596 <!-- AdminLTE App -->
597 <script src=
"../bower/admin-lte/dist/js/app.min.js"></script>
598 <script src=
"table.js"></script>
599 <script src=
"../schemaSpy.js"></script>