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

NEWS_ITEMS

Columns

NameTypeNullableDefault valueComment
NEWS_ITEM_IDNUMBER(38)N  
NEWSGROUP_IDNUMBER(38)N  
TITLEVARCHAR2(200.0)N  
BODYCLOBN  
HTML_PCHAR(1.0)Y'f'  
APPROVAL_STATEVARCHAR2(15.0)Y'unexamined'  
APPROVAL_DATEDATEY  
APPROVAL_USERNUMBER(38)Y  
APPROVAL_IP_ADDRESSVARCHAR2(50.0)Y  
RELEASE_DATEDATEN  
EXPIRATION_DATEDATEN  
CREATION_DATEDATEN  
CREATION_USERNUMBER(38)N  
CREATION_IP_ADDRESSVARCHAR2(50.0)N  

Primary key:

Constraint NameColumns
SYS_C002087459NEWS_ITEM_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002087449"NEWSGROUP_ID" IS NOT NULL
SYS_C002087450"TITLE" IS NOT NULL
SYS_C002087451"BODY" IS NOT NULL
SYS_C002087452"RELEASE_DATE" IS NOT NULL
SYS_C002087453"EXPIRATION_DATE" IS NOT NULL
SYS_C002087454"CREATION_DATE" IS NOT NULL
SYS_C002087455"CREATION_USER" IS NOT NULL
SYS_C002087456"CREATION_IP_ADDRESS" IS NOT NULL
SYS_C002087457html_p in ('t','f')
SYS_C002087458approval_state in ('unexamined','approved', 'disapproved')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002087460NEWSGROUP_ID NEWSGROUPS SYS_C002087447 NO ACTION
SYS_C002087461APPROVAL_USER USERS SYS_C002087135 NO ACTION
SYS_C002087462CREATION_USER USERS SYS_C002087135 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
NEWS_ITEMS_IDXNORMALNONUNIQUENEWSGROUP_ID
SYS_C002087459NORMALUNIQUENEWS_ITEM_ID
SYS_IL0001976489C00004$$LOBUNIQUE 

Triggers

Name: NEWS_GC_DELETE
CREATE TRIGGER news_gc_delete
  after DELETE
  ON news_items
  FOR each row
REFERENCING NEW AS NEW OLD AS OLD
BEGIN
  DELETE FROM general_comments
    WHERE on_which_table = 'news_items'
    AND on_what_id = :old.news_item_id;
END;



Generated by OraSchemaDoc, (c) Aram Kananov, 2002