Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers

WAP_USER_AGENTS

Columns

NameTypeNullableDefault valueComment
USER_AGENT_IDNUMBER(38)N  
NAMEVARCHAR2(200.0)N  
CREATION_COMMENTVARCHAR2(4000.0)Y  
CREATION_DATEDATEYsysdate 
CREATION_USERNUMBER(38)Y  
DELETION_DATEDATEY  
DELETION_USERNUMBER(38)Y  

Primary key:

Constraint NameColumns
WAP_USER_AGENT_ID_PKUSER_AGENT_ID

Check Constraints:

Constraint NameCheck Condition
WAP_USER_AGENT_ID_NN"USER_AGENT_ID" IS NOT NULL
WAP_USER_AGENT_NAME_NN"NAME" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
WAP_USER_AGT_CREATE_USER_FKCREATION_USER USERS SYS_C002087135 NO ACTION
WAP_USER_AGT_DELETE_USER_FKDELETION_USER USERS SYS_C002087135 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
WAP_USER_AGENT_ID_PKNORMALUNIQUEUSER_AGENT_ID

Generated by OraSchemaDoc, (c) Aram Kananov, 2002