OPP_GOVWINIQ |
Default Table Name | OPP_GOVWINIQ |
Definition |
OPP_GOVWINIQ Columns |
ColumnName | Domain | Datatype | NULL | Definition |
OPP_ID![]() |
VARCHAR2(32) | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
REFRESH_FL | VARCHAR2(1) | YES | ||
LAST_GWIQ_SYNCH | DATE | YES | ||
LAST_ANALYST_UPD | DATE | YES | ||
PROGRAM_NAME | VARCHAR2(256) | YES | ||
GOVWIN_ID | VARCHAR2(256) | YES | ||
ACRONYM | VARCHAR2(256) | YES | ||
DEPARTMENT | VARCHAR2(256) | YES | ||
AGENCY_ID | VARCHAR2(15) | YES | ||
CURR_STATUS_DESC | VARCHAR2(4000) | YES | ||
SOLICITATION_NO | VARCHAR2(256) | YES | ||
EST_VALUE | NUMBER(17, 2) | YES | ||
COMPETITION_TYPE | VARCHAR2(256) | YES | ||
NAICS_CD_1 | VARCHAR2(256) | YES | ||
GWIQ_OPP_LINK | VARCHAR2(256) | YES | ||
DURATION | VARCHAR2(256) | YES | ||
CONTRACT_TYPE | VARCHAR2(256) | YES | ||
PRIMARY_OFFER | VARCHAR2(256) | YES | ||
COMMENTS | VARCHAR2(4000) | YES | ||
PROG_SUMMARY | VARCHAR2(4000) | YES | ||
POT_BIDDERS | VARCHAR2(4000) | YES | ||
PROCUREMT_ACTIVITY | VARCHAR2(4000) | YES | ||
PROGRAM_DESCRIP | CLOB | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | YES | ||
ROWVERSION | NUMBER(10, 0) | YES |
OPP_GOVWINIQ Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_OPP_GOVWINIQ_IDX | PrimaryKey | OPP_ID, COMPANY_ID |
OPP_GOVWINIQ Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
OPP_MASTER | Identifying | One To Zero or More | FK_OPP_GOVWINIQ_OPCO_IDX | OPP_ID, COMPANY_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
OPP_GWIQ_ADDED_BY | Identifying | One To Zero or More | FK_OPP_GWIQ_ADDED_BY_OPCO_IDX | NO | NO | NO | |||
OPP_GWIQ_CONTACTS | Identifying | One To Zero or More | FK_OPP_GWIQ_CONTACTS_OPCO_IDX | NO | NO | NO | |||
OPP_GWIQ_KEY_DATES | Identifying | One To Zero or More | FK_OPP_GWIQ_KEY_DATES_OPCO_IDX | NO | NO | NO |