trunk-5652

Enter password: ****************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 23
Server version: 5.7.16-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| openmrs            |
| performance_schema |
| server             |
| sys                |
+--------------------+
6 rows in set (0.00 sec)

mysql> use openmrs;
Database changed
mysql> show tables;
+--------------------------------+
| Tables_in_openmrs              |
+--------------------------------+
| allergy                        |
| allergy_reaction               |
| care_setting                   |
| clob_datatype_storage          |
| cohort                         |
| cohort_member                  |
| concept                        |
| concept_answer                 |
| concept_attribute              |
| concept_attribute_type         |
| concept_class                  |
| concept_complex                |
| concept_datatype               |
| concept_description            |
| concept_map_type               |
| concept_name                   |
| concept_name_tag               |
| concept_name_tag_map           |
| concept_numeric                |
| concept_proposal               |
| concept_proposal_tag_map       |
| concept_reference_map          |
| concept_reference_source       |
| concept_reference_term         |
| concept_reference_term_map     |
| concept_set                    |
| concept_state_conversion       |
| concept_stop_word              |
| conditions                     |
| drug                           |
| drug_ingredient                |
| drug_order                     |
| drug_reference_map             |
| encounter                      |
| encounter_diagnosis            |
| encounter_provider             |
| encounter_role                 |
| encounter_type                 |
| field                          |
| field_answer                   |
| field_type                     |
| form                           |
| form_field                     |
| form_resource                  |
| global_property                |
| hl7_in_archive                 |
| hl7_in_error                   |
| hl7_in_queue                   |
| hl7_source                     |
| liquibasechangelog             |
| liquibasechangeloglock         |
| location                       |
| location_attribute             |
| location_attribute_type        |
| location_tag                   |
| location_tag_map               |
| note                           |
| notification_alert             |
| notification_alert_recipient   |
| notification_template          |
| obs                            |
| obs_unused_fields              |
| order_frequency                |
| order_group                    |
| order_set                      |
| order_set_member               |
| order_type                     |
| order_type_class_map           |
| orders                         |
| patient                        |
| patient_identifier             |
| patient_identifier_type        |
| patient_program                |
| patient_program_attribute      |
| patient_state                  |
| person                         |
| person_address                 |
| person_attribute               |
| person_attribute_type          |
| person_merge_log               |
| person_name                    |
| privilege                      |
| program                        |
| program_attribute_type         |
| program_workflow               |
| program_workflow_state         |
| provider                       |
| provider_attribute             |
| provider_attribute_type        |
| relationship                   |
| relationship_type              |
| report_object                  |
| report_schema_xml              |
| role                           |
| role_privilege                 |
| role_role                      |
| scheduler_task_config          |
| scheduler_task_config_property |
| serialized_object              |
| test_order                     |
| user_property                  |
| user_role                      |
| users                          |
| visit                          |
| visit_attribute                |
| visit_attribute_type           |
| visit_type                     |
+--------------------------------+
107 rows in set (0.00 sec)

mysql> desc order_group;
+---------------------+--------------+------+-----+---------+----------------+
| Field               | Type         | Null | Key | Default | Extra          |
+---------------------+--------------+------+-----+---------+----------------+
| order_group_id      | int(11)      | NO   | PRI | NULL    | auto_increment |
| order_set_id        | int(11)      | YES  | MUL | NULL    |                |
| patient_id          | int(11)      | NO   | MUL | NULL    |                |
| encounter_id        | int(11)      | NO   | MUL | NULL    |                |
| creator             | int(11)      | NO   | MUL | NULL    |                |
| date_created        | datetime     | NO   |     | NULL    |                |
| voided              | tinyint(1)   | NO   |     | 0       |                |
| voided_by           | int(11)      | YES  | MUL | NULL    |                |
| date_voided         | datetime     | YES  |     | NULL    |                |
| void_reason         | varchar(255) | YES  |     | NULL    |                |
| changed_by          | int(11)      | YES  | MUL | NULL    |                |
| date_changed        | datetime     | YES  |     | NULL    |                |
| uuid                | char(38)     | NO   | UNI | NULL    |                |
| nested_order_groups | int(11)      | YES  |     | NULL    |                |
+---------------------+--------------+------+-----+---------+----------------+
14 rows in set (0.00 sec)

mysql>