subnet

Logical Entity Name | subnet
Default Table Name | subnet
Definition | Used only at caltech -- to populate EW carlsubtrig file

subnet Columns

ColumnName | Domain | Datatype | NULL | Definition
subid |  | NUMBER(15, 0) | NO |
code |  | VARCHAR2(3) | NO |
description |  | VARCHAR2(80) | YES |
mintrig |  | NUMBER(15, 0) | NO |
lddate |  | DATE | YES |

subnet Primary and Unique Keys

Key Name | Key Type | Keys

subnet Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred

subnet Check Constraints

Check Constraint Name | CheckConstraint