alarm_action.alarm_actionkey01

TableName | alarm_action
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

alarm_action.alarm_actionkey01 Index Columns

ColumnName | Sort Order
event_id | Ascending
alarm_action | Ascending
action_state | Ascending
modcount | Ascending

appchannels.config_chankey01_1

TableName | appchannels
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

appchannels.config_chankey01_1 Index Columns

ColumnName | Sort Order
progid | Ascending
net | Ascending
sta | Ascending
seedchan | Ascending
location | Ascending
ondate | Ascending

applications.progkey01_1

TableName | applications
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

applications.progkey01_1 Index Columns

ColumnName | Sort Order
progid | Ascending

assoc_region_group.pk_assoc_reggrp

TableName | assoc_region_group
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

assoc_region_group.pk_assoc_reggrp Index Columns

ColumnName | Sort Order
grpid | Ascending
name | Ascending

assocnte.assocntekey01

TableName | assocnte
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

assocnte.assocntekey01 Index Columns

ColumnName | Sort Order
ntid | Ascending
evid | Ascending

autoposter.pk3_1

TableName | autoposter
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

autoposter.pk3_1 Index Columns

ColumnName | Sort Order
instancename | Ascending

channelmap_ampparms.cm_amp_key

TableName | channelmap_ampparms
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

channelmap_ampparms.cm_amp_key Index Columns

ColumnName | Sort Order
net | Ascending
sta | Ascending
seedchan | Ascending
location | Ascending
ondate | Ascending

channelmap_codaparms.cm_coda_key

TableName | channelmap_codaparms
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

channelmap_codaparms.cm_coda_key Index Columns

ColumnName | Sort Order
net | Ascending
sta | Ascending
seedchan | Ascending
location | Ascending
ondate | Ascending

config_param.configparamkey01

TableName | config_param
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

config_param.configparamkey01 Index Columns

ColumnName | Sort Order
progid | Ascending

credit.pk_credit

TableName | credit
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

credit.pk_credit Index Columns

ColumnName | Sort Order
id | Ascending
tname | Ascending

credit_alias.pk_alias

TableName | credit_alias
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

credit_alias.pk_alias Index Columns

ColumnName | Sort Order
alias | Ascending
keyid | Ascending

epochtimebase.pk5

TableName | epochtimebase
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

epochtimebase.pk5 Index Columns

ColumnName | Sort Order
base | Ascending
ondate | Ascending

eventmatchpassingscore.eventmatchpasskey01

TableName | eventmatchpassingscore
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

eventmatchpassingscore.eventmatchpasskey01 Index Columns

ColumnName | Sort Order
auth | Ascending

eventpriorityparams.eppkey01

TableName | eventpriorityparams
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

eventpriorityparams.eppkey01 Index Columns

ColumnName | Sort Order
magfactor | Ascending
agefactor | Ascending
qualfactor | Ascending

gazetteer_region_group.pk_gazreggrp

TableName | gazetteer_region_group
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

gazetteer_region_group.pk_gazreggrp Index Columns

ColumnName | Sort Order
grpid | Ascending

gazetteerbigtown.gazbigtown_pk_gazid

TableName | gazetteerbigtown
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

gazetteerbigtown.gazbigtown_pk_gazid Index Columns

ColumnName | Sort Order
gazid | Ascending

gazetteerfault.gazfault_pk_gazid

TableName | gazetteerfault
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

gazetteerfault.gazfault_pk_gazid Index Columns

ColumnName | Sort Order
gazid | Ascending

gazetteerline.gazline_pk_gazid

TableName | gazetteerline
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

gazetteerline.gazline_pk_gazid Index Columns

ColumnName | Sort Order
gazid | Ascending

gazetteerpt.gazpt_pk_gazid

TableName | gazetteerpt
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

gazetteerpt.gazpt_pk_gazid Index Columns

ColumnName | Sort Order
gazid | Ascending

gazetteerquake.gazeq_pk_gazid

TableName | gazetteerquake
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

gazetteerquake.gazeq_pk_gazid Index Columns

ColumnName | Sort Order
gazid | Ascending

gazetteerquarry.gazqry_pk_gazid

TableName | gazetteerquarry
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

gazetteerquarry.gazqry_pk_gazid Index Columns

ColumnName | Sort Order
gazid | Ascending

gazetteertown.gaztown_pk_gazid

TableName | gazetteertown
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

gazetteertown.gaztown_pk_gazid Index Columns

ColumnName | Sort Order
gazid | Ascending

gazetteertype.gaztype_pk_code

TableName | gazetteertype
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

gazetteertype.gaztype_pk_code Index Columns

ColumnName | Sort Order
code | Ascending

jasieventlock.PK3

TableName | jasieventlock
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

jasieventlock.PK3 Index Columns

ColumnName | Sort Order
evid | Ascending

magprefpriority.magpref_pk

TableName | magprefpriority
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

magprefpriority.magpref_pk Index Columns

ColumnName | Sort Order
region_name | Ascending
datetime_on | Ascending
priority | Ascending

mcaparms.mcaparms_key01

TableName | mcaparms
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

mcaparms.mcaparms_key01 Index Columns

ColumnName | Sort Order
net | Ascending
sta | Ascending
seedchan | Ascending
location | Ascending
ondate | Ascending

messagetext.pk11

TableName | messagetext
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

messagetext.pk11 Index Columns

ColumnName | Sort Order
srcnet | Ascending
texttype | Ascending
lineno | Ascending

nettrig.nettrigkey01

TableName | nettrig
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

nettrig.nettrigkey01 Index Columns

ColumnName | Sort Order
ntid | Ascending

orgprefpriority.originpref_pk

TableName | orgprefpriority
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

orgprefpriority.originpref_pk Index Columns

ColumnName | Sort Order
region_name | Ascending
datetime_on | Ascending
priority | Ascending

pcs_signal.pk_sig

TableName | pcs_signal
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

pcs_signal.pk_sig Index Columns

ColumnName | Sort Order
sigid | Ascending

pcs_state.pk14

TableName | pcs_state
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

pcs_state.pk14 Index Columns

ColumnName | Sort Order
controlgroup | Ascending
sourcetable | Ascending
id | Ascending
state | Ascending

pcs_transition.pcs_state_pk

TableName | pcs_transition
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

pcs_transition.pcs_state_pk Index Columns

ColumnName | Sort Order
groupold | Ascending
sourceold | Ascending
stateold | Ascending
resultold | Ascending
groupnew | Ascending
sourcenew | Ascending
statenew | Ascending

request_card.request_cardkey01

TableName | request_card
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

request_card.request_cardkey01 Index Columns

ColumnName | Sort Order
rcid | Ascending

request_card.req03

TableName | request_card
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | Index

request_card.req03 Index Columns

ColumnName | Sort Order
auth | Ascending
subsource | Ascending
net | Ascending
sta | Ascending
seedchan | Ascending
location | Ascending
staauth | Ascending
datetime_on | Ascending
datetime_off | Ascending
request_type | Ascending

stacorrections.stacoo

TableName | stacorrections
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

stacorrections.stacoo Index Columns

ColumnName | Sort Order
net | Ascending
sta | Ascending
seedchan | Ascending
location | Ascending
corr_type | Ascending
ondate | Ascending

stamapping.stamapkey01

TableName | stamapping
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

stamapping.stamapkey01 Index Columns

ColumnName | Sort Order
net | Ascending
sta | Ascending

swarm_events.swarm_eventskey01

TableName | swarm_events
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

swarm_events.swarm_eventskey01 Index Columns

ColumnName | Sort Order
evid | Ascending
region | Ascending

swarm_state.swarm_statekey01

TableName | swarm_state
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

swarm_state.swarm_statekey01 Index Columns

ColumnName | Sort Order
region | Ascending

trig_channel.trigchankey01

TableName | trig_channel
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

trig_channel.trigchankey01 Index Columns

ColumnName | Sort Order
trigid | Ascending

unassocamp.unassocampkey01

TableName | unassocamp
Unique | YES
Clustered Option | NON-CLUSTERED
IndexType | PrimaryKey

unassocamp.unassocampkey01 Index Columns

ColumnName | Sort Order
ampid | Ascending