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

CONTEST_VOTES

Columns

NameTypeNullableDefault valueComment
USER_IDNUMBER(38)N  
ENTRY_DATEDATEY  
DOMAIN_IDNUMBER(38)N  
ENTRY_IDNUMBER(38)N  
IPADDRESSVARCHAR2(100.0)Y  
INTEGER_VOTENUMBER(38)Y  
COMMENTSVARCHAR2(4000.0)Y  

Primary key:

Constraint NameColumns
CV_ENTRY_USER_DOMAIN_PKENTRY_ID , USER_ID , DOMAIN_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002087616"USER_ID" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
CONTEST_VOTES_DOMAIN_ID_FKDOMAIN_ID CONTEST_DOMAINS SYS_C002087608 NO ACTION
CONTEST_VOTES_USER_ID_FKUSER_ID USERS SYS_C002087135 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
CV_ENTRY_USER_DOMAIN_PKNORMALUNIQUEENTRY_ID , USER_ID , DOMAIN_ID

Generated by OraSchemaDoc, (c) Aram Kananov, 2002