+ 'usage_elec_transaction867' => {
+ 'columns'=> [
+ 'id','serial','','','','',
+ 'usage_elec_id','serial','','','','',
+ 'note','varchar','NULL','255','','',
+ ],
+ 'primary_key'=> 'id',
+ 'unique' => [],
+ 'index'=>[['usage_elec_id']],
+ },
+
+ 'usage_elec' => {
+ 'columns' => [
+ 'id', 'serial', '', '', '', '',
+ 'prev_date', @date_type, '', '',
+ 'curr_date', @date_type,'','',
+ 'prev_read', 'decimal', '14,4', '', '', '',
+ 'curr_read', 'decimal', '14,4', '', '', '',
+ 'tdsp', @money_type, '', '',
+ 'meter_multiplier','real','','','','',
+ 'total_usage','decimal','14,4','','','',
+ 'measured_demand','decimal','14,4','','','',
+ 'billed_demand','decimal','14,4','','','',
+ 'svcnum', 'int', '', '', '', '',
+ '_date',@date_type,'','',
+ 'meter_number','varchar','255','','','',
+ ],
+ 'primary_key' => 'id',
+ 'unique' => [],
+ 'index' => [['svcnum']],
+ },
+
+# -nguyen
+ 'elec_general' => {
+ 'columns' => [
+ 'id', 'serial', '', '', '', '',
+ 'esiid','int','','','','',
+ ],
+ 'primary_key' => 'id',
+ 'unique' => [],
+ 'index' => [],
+ },
+
+ 'trading_rep_profile' => {
+ 'columns' => [
+ 'id', 'serial', '', '', '', '',
+ 'company_name', 'varchar', 'NULL', $char_d, '', '',
+ 'duns_num', 'int', '', '', '', '',
+ 'company_type', 'varchar', 'NULL', $char_d, '', '',
+ 'puct_license_num', 'int', '', '', '', '',
+ 'active', 'int', '', '', '', '',
+ 'start_date', @date_type, '', '',
+ 'end_date', @date_type, '', '',
+ ],
+ 'primary_key' => 'id',
+ 'unique' => [ ['duns_num'] ],
+ 'index' => [],
+ },
+
+
+ 'transaction810' => {
+ 'columns' => [
+ 'id', 'serial', '', '', '', '',
+ 'tdsp_duns', 'varchar', 'NULL', $char_d, '', '',
+ 'inv_num', 'varchar', 'NULL', $char_d, '', '',
+ 'ref_identification', 'varchar', 'NULL', $char_d, '', '',
+ 'esiid', 'varchar', 'NULL', $char_d, '', '',
+ 'tdsp', 'int', '', '', '', '',
+ 'due_date', 'int', '', '', '', '',
+ 'inv_date', 'int', '', '', '', '',
+ 'usage_kwatts', 'real', '', '', '', '',
+ 'srvc_from_date', 'int', '', '', '', '',
+ 'srvc_to_date', 'int', '', '', '', '',
+ 'puct_fund', 'int', '', '', '', '',
+ 'billed_demand', 'real', '', '', '', '',
+ 'measured_demand', 'real', 'NULL', '', '', '',
+ 'bill_status', 'char', '', 2, '', '',
+ 'type_of_bill', 'int', '', '', '', '', # bool 0/1
+ 'ack_997', 'int', '', '', '', '', # bool 0/1
+ 'processed', 'int', '', '', '', '', # bool 0/1
+ ],
+ 'primary_key' => 'id',
+ 'unique' => [ ['inv_num'] ],
+ 'index' => [ ['id'], ['tdsp_duns'], ['inv_num'], ['esiid'] ],
+ },
+
+ 'transaction867' => {
+ 'columns' => [
+ 'id', 'serial', '', '', '', '',
+ 'tdsp_duns', 'int', '', '', '', '',
+ 'ref_identification', 'varchar', '', $char_d, '', '',
+ 'esiid', 'varchar', '', $char_d, '', '',
+ 'trans_creation_date', 'int', '', '', '', '',
+ 'meter_no', 'varchar', '', $char_d, '', '',
+ 'srvc_period_start_date', 'int', '', '', '', '',
+ 'srvc_period_end_date', 'int', '', '', '', '',
+ 'prev_read_kwatts', 'real', '', '', '', '',
+ 'curr_read_kwatts', 'real', '', '', '', '',
+ 'meter_multiplier', 'real', '', '', '', '',
+ 'usage_kwatts', 'real', '', '', '', '',
+ 'measured_demand', 'real', 'NULL', '', '', '',
+ 'ack_997', 'int', '', '', '', '', # bool 0/1
+ 'processed', 'int', '', '', '', '', # bool 0/1
+ ],
+ 'primary_key' => 'id',
+ 'unique' => [ ['ref_identification'] ],
+ 'index' => [],
+ },
+
+