CREATE TABLE `pai_db_log` ( `log_text` text, `creation_date` datetime DEFAULT CURRENT_TIMESTAMP, `log_id` int(11) NOT NULL AUTO_INCREMENT, `log_name` varchar(45) DEFAULT NULL, PRIMARY KEY (`log_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4838 DEFAULT CHARSET=utf8 SHOW INDEX IN pai_db_log; +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | pai_db_log | 0 | PRIMARY | 1 | log_id | A | 4868 | NULL | NULL | | BTREE | | | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 1 row in set (0.00 sec) CREATE TABLE `pai_beacon_service_entries_ux` ( `people_id` varchar(40) DEFAULT NULL, `full_name` varchar(20) DEFAULT NULL, `id_no` decimal(10,2) DEFAULT NULL, `other_id_number` decimal(10,2) DEFAULT NULL, `dob` datetime DEFAULT NULL, `gender` varchar(10) DEFAULT NULL, `gender_code` varchar(10) DEFAULT NULL, `ssn_number` varchar(10) DEFAULT NULL, `is_staff` varchar(10) DEFAULT NULL, `intake_dt` datetime DEFAULT NULL, `discharge_dt` datetime DEFAULT NULL, `medicaid_number` varchar(10) DEFAULT NULL, `ipd` varchar(10) DEFAULT NULL, `current_location` varchar(50) DEFAULT NULL, `program_info_id` varchar(40) DEFAULT NULL, `program_name` varchar(30) DEFAULT NULL, `program_type` varchar(30) DEFAULT NULL, `site_providing_service` varchar(40) DEFAULT NULL, `facility` varchar(10) DEFAULT NULL, `license_number` varchar(10) DEFAULT NULL, `staff_id` varchar(40) DEFAULT NULL, `job_title` varchar(20) DEFAULT NULL, `staff_name` varchar(20) DEFAULT NULL, `actual_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `duration` decimal(10,2) DEFAULT NULL, `event_log_id` varchar(40) NOT NULL DEFAULT '', `event_definition_id` varchar(40) DEFAULT NULL, `event_name` varchar(30) DEFAULT NULL, `parent_event` varchar(40) DEFAULT NULL, `service` varchar(30) DEFAULT NULL, `activity_type` varchar(20) DEFAULT NULL, `encounter_with` varchar(10) DEFAULT NULL, `is_client_involved` varchar(10) DEFAULT NULL, `is_noshow` varchar(10) DEFAULT NULL, `is_locked` varchar(10) DEFAULT NULL, `progress_note` varchar(10) DEFAULT NULL, `event_category_id` varchar(40) DEFAULT NULL, `form_header_id` varchar(40) DEFAULT NULL, `is_billed` varchar(10) DEFAULT NULL, `is_paid` varchar(10) DEFAULT NULL, `invoice_number` varchar(10) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `user_entered` varchar(40) DEFAULT NULL, `user_entered_name` varchar(20) DEFAULT NULL, `approved_date` datetime DEFAULT NULL, `approved_by_id` varchar(40) DEFAULT NULL, `approved_staff_name` varchar(20) DEFAULT NULL, `submitted` varchar(30) DEFAULT NULL, `is_approved` decimal(10,2) DEFAULT NULL, `is_notapproved` decimal(10,2) DEFAULT NULL, `is_notapproved_subm` decimal(10,2) DEFAULT NULL, `depended_activity` decimal(10,2) DEFAULT NULL, `program_unit_description` varchar(30) DEFAULT NULL, `sc_code` varchar(10) DEFAULT NULL, `duration_num` decimal(10,2) DEFAULT NULL, `do_not_bill` varchar(10) DEFAULT NULL, `do_not_pay` varchar(10) DEFAULT NULL, `general_location_id` varchar(40) DEFAULT NULL, `general_location` varchar(20) DEFAULT NULL, `program_modifier_id` varchar(10) DEFAULT NULL, `program_modifier` varchar(10) DEFAULT NULL, `program_modifier_code` varchar(10) DEFAULT NULL, `normalworkhours` varchar(10) DEFAULT NULL, `duration_other_num` decimal(10,2) DEFAULT NULL, `duration_other` varchar(10) DEFAULT NULL, `travel_time_num` decimal(10,2) DEFAULT NULL, `travel_time` varchar(10) DEFAULT NULL, `planning_time_num` decimal(10,2) DEFAULT NULL, `planning_time` varchar(10) DEFAULT NULL, `total_duration_num` decimal(10,2) DEFAULT NULL, `total_duration` varchar(10) DEFAULT NULL, `total_duration_num_cc` decimal(10,2) DEFAULT NULL, `total_duration_cc` varchar(10) DEFAULT NULL, `actual_location_facility_id` varchar(10) DEFAULT NULL, `actual_location_facility` varchar(10) DEFAULT NULL, `reason_for_no_show_id` varchar(10) DEFAULT NULL, `reason_for_no_show` varchar(10) DEFAULT NULL, `form_program` varchar(20) DEFAULT NULL, `cue_number` varchar(10) DEFAULT NULL, `cue_type` varchar(10) DEFAULT NULL, `client_participation_response` varchar(10) DEFAULT NULL, `client_part_resp_description` varchar(10) DEFAULT NULL, `outcome_id` varchar(10) DEFAULT NULL, `outcome_description` varchar(10) DEFAULT NULL, `gaf_score_current` varchar(10) DEFAULT NULL, `date_order` varchar(20) DEFAULT NULL, `is_billable` decimal(10,2) DEFAULT NULL, `snb_reasons` varchar(10) DEFAULT NULL, `is_billing` varchar(10) DEFAULT NULL, `sr_incident_to` varchar(10) DEFAULT NULL, `is_incident_to` varchar(10) DEFAULT NULL, `medicare_incident_to_supervisor` varchar(10) DEFAULT NULL, `it_supervisor_name` varchar(10) DEFAULT NULL, `etl_post_status` varchar(10) DEFAULT NULL, PRIMARY KEY (`event_log_id`), KEY `idx_pai_beacon_service_entries_ux_etl_post_status` (`etl_post_status`), KEY `idx_pai_beacon_service_entries_ux_sc_code` (`sc_code`), KEY `idx_pai_beacon_service_entries_ux_staff_id` (`staff_id`), KEY `idx_pai_beacon_service_entries_ux_actual_date` (`actual_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 MariaDB [paischema]> SHOW INDEX IN pai_beacon_service_entries_ux; +-------------------------------+------------+---------------------------------------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------------------------------+------------+---------------------------------------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | pai_beacon_service_entries_ux | 0 | PRIMARY | 1 | event_log_id | A | 194251 | NULL | NULL | | BTREE | | | | pai_beacon_service_entries_ux | 1 | idx_pai_beacon_service_entries_ux_etl_post_status | 1 | etl_post_status | A | 2 | NULL | NULL | YES | BTREE | | | | pai_beacon_service_entries_ux | 1 | idx_pai_beacon_service_entries_ux_sc_code | 1 | sc_code | A | 18 | NULL | NULL | YES | BTREE | | | | pai_beacon_service_entries_ux | 1 | idx_pai_beacon_service_entries_ux_staff_id | 1 | staff_id | A | 434 | NULL | NULL | YES | BTREE | | | | pai_beacon_service_entries_ux | 1 | idx_pai_beacon_service_entries_ux_actual_date | 1 | actual_date | A | 194251 | NULL | NULL | YES | BTREE | | | +-------------------------------+------------+---------------------------------------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 5 rows in set (0.00 sec)