assoccoo 
Logical Entity Name  assoccoo 
Default Table Name  assoccoo 
Definition  Data associating codas with origins 

assoccoo Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
orid(PK)(FK)    NUMERIC(15, 0)  NO  Origin identification. Each origin is assigned a unique positive integer which identifies it in the database. The orid is used to identify one of the many hypotheses of the actual location of the event 
coid(PK)(FK)    NUMERIC(15, 0)  NO  Coda identification. Each coda is assigned a unique positive integer which identifies it in the database 
commid    NUMERIC(15, 0)  YES  Comment identification. This is a key used to point to free-form comments entered in the Remark relation. These comments store additional information about a tuple in another relation. Within the Remark relation, there may be many tuples with the same commid and different lineno, but the same commid will appear in only one other tuple among the rest of the relations in the database 
auth    VARCHAR(15)  NO  The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record 
subsource    VARCHAR(8)  YES  A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE 
delta    NUMERIC(9, 4)  YES  Source-receiver distance. This attribute is the arc length, over the earth’s surface, of the path the seismic phase follows from source to receiver. The location of the origin is specified in the origin record referenced by the attribute orid. The attribute arid points to the record in the Arrival relation that identifies the receiver. 
seaz    NUMERIC(7, 4)  YES  Station to event azimuth. This attribute is calculated from the station and event locations. It is measured clockwise from North 
rflag    VARCHAR(2)  YES  This flag describes whether an observation was generated automatically, by a human, or has been finalized 
lddate    DATE  YES  Load date. Date and time that the record was created, in Oracle date datatype 

assoccoo Keys 
Key Name  Key Type  Keys 
assoccookey01  PrimaryKey  orid, coid 

assoccoo Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
coda  Identifying  One To Zero or More        coid  NO 
origin  Identifying  One To Zero or More        orid  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
remark  Non-Specific            NO 

assoccoo Check Constraints 
Check Constraint Name  CheckConstraint 
assoccookey04  rflag in ('a','h','f','A','H','F')