'primary_key' => 'itemnum',
'unique' => [ [ 'usernum' ] ],
'index' => [],
- 'foreign_keys' => [
- { columns => [ 'usernum' ],
- table => 'access_user',
- },
- ],
},
#'sched_item_class'
'primary_key' => 'availnum',
'unique' => [],
'index' => [],
- 'foreign_keys' => [
- { columns => [ 'itemnum' ],
- table => 'sched_item',
- },
- ],
},
'svc_phone' => {
'primary_key' => 'extensionnum',
'unique' => [ [ 'svcnum', 'extension' ] ],
'index' => [ [ 'svcnum' ] ],
- 'foreign_keys' => [
- { columns => [ 'svcnum' ],
- table => 'svc_pbx',
- },
- { columns => [ 'circuit_svcnum' ],
- table => 'svc_circuit',
- references => [ 'svcnum' ],
- },
- ],
},
'svc_mailinglist' => { #svc_group?
'primary_key' => 'svcnum',
'unique' => [],
'index' => [ [ 'providernum' ], [ 'typenum' ] ],
- 'foreign_keys' => [
- { columns => [ 'svcnum' ],
- table => 'cust_svc',
- },
- { columns => [ 'typenum' ],
- table => 'circuit_type',
- },
- { columns => [ 'providernum' ],
- table => 'circuit_provider',
- },
- { columns => [ 'termnum' ],
- table => 'circuit_termination',
- },
- ],
},
%{ tables_hashref_torrus() },
'primary_key' => 'batchnum',
'unique' => [],
'index' => [ [ 'exportnum' ], [ 'status' ] ],
- 'foreign_keys' => [
- { columns => [ 'exportnum' ],
- table => 'part_export',
- references => [ 'exportnum' ]
- },
- ],
},
'export_batch_item' => {
'primary_key' => 'itemnum',
'unique' => [],
'index' => [ [ 'batchnum' ], [ 'svcnum' ] ],
- 'foreign_keys' => [
- { columns => [ 'batchnum' ],
- table => 'export_batch',
- references => [ 'batchnum' ]
- },
- ],
},
# lookup table for states, similar to msa and lata
'primary_key' => 'zonenum',
'unique' => [],
'index' => [ [ 'agentnum' ] ],
- 'foreign_keys' => [
- { columns => [ 'agentnum' ],
- table => 'agent',
- references => [ 'agentnum' ],
- },
- ],
},
'deploy_zone_block' => {
'primary_key' => 'blocknum',
'unique' => [],
'index' => [ [ 'zonenum' ] ],
- 'foreign_keys' => [
- { columns => [ 'zonenum' ],
- table => 'deploy_zone',
- references => [ 'zonenum' ],
- },
- ],
},
'deploy_zone_vertex' => {
'primary_key' => 'vertexnum',
'unique' => [ ],
'index' => [ ],
- 'foreign_keys' => [
- { columns => [ 'zonenum' ],
- table => 'deploy_zone',
- references => [ 'zonenum' ],
- },
- ],
},