'status', 'varchar', 'NULL', $char_d, '', '',
'failure_status','varchar', 'NULL', 16, '', '',
'error_message', 'varchar', 'NULL', $char_d, '', '',
+ 'paycode', 'varchar', 'NULL', $char_d, '', '',
],
'primary_key' => 'paybatchnum',
'unique' => [],
'ocn', 'char', 'NULL', 4, '', '',
],
'primary_key' => 'prefixnum',
- 'unique' => [],
+ 'unique' => [ [ 'countrycode', 'npa', 'nxx' ] ],
'index' => [ [ 'countrycode' ], [ 'npa' ], [ 'regionnum' ] ],
'foreign_keys' => [
{ columns => [ 'regionnum' ],
'vendor_order_status', 'varchar', 'NULL', $char_d, '', '',
'endpoint_ip_addr', 'varchar', 'NULL', 40, '', '',
'endpoint_mac_addr', 'varchar', 'NULL', 12, '', '',
+ 'internal_circuit_id', 'varchar', '', 64, '', '',
],
'primary_key' => 'svcnum',
'unique' => [],