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

GENERAL_PORTRAITS

Columns

NameTypeNullableDefault valueComment
PORTRAIT_IDNUMBER(38)N  
ON_WHICH_TABLEVARCHAR2(50.0)N  
ON_WHAT_IDNUMBER(38)N  
UPLOAD_USER_IDNUMBER(38)N  
PORTRAITBLOBY  
PORTRAIT_UPLOAD_DATEDATEYsysdate 
PORTRAIT_COMMENTVARCHAR2(4000.0)Y  
PORTRAIT_CLIENT_FILE_NAMEVARCHAR2(500.0)Y  
PORTRAIT_FILE_TYPEVARCHAR2(100.0)Y  
PORTRAIT_FILE_EXTENSIONVARCHAR2(50.0)Y  
PORTRAIT_ORIGINAL_WIDTHNUMBER(38)Y  
PORTRAIT_ORIGINAL_HEIGHTNUMBER(38)Y  
PORTRAIT_THUMBNAILBLOBY  
PORTRAIT_THUMBNAIL_WIDTHNUMBER(38)Y  
PORTRAIT_THUMBNAIL_HEIGHTNUMBER(38)Y  
PORTRAIT_PRIMARY_PCHAR(1.0)N  
APPROVED_PCHAR(1.0)Y't'  

Primary key:

Constraint NameColumns
GP_PORTRAIT_ID_PKPORTRAIT_ID

Check Constraints:

Constraint NameCheck Condition
GP_APPROVED_P_CKapproved_p in ('t', 'f')
GP_PORTRAIT_PRIMARY_P_CKportrait_primary_p in ('t', 'f')
SYS_C002087916"ON_WHICH_TABLE" IS NOT NULL
SYS_C002087917"ON_WHAT_ID" IS NOT NULL
SYS_C002087918"UPLOAD_USER_ID" IS NOT NULL
SYS_C002087919"PORTRAIT_PRIMARY_P" IS NOT NULL

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
GP_UPOAD_USER_ID_FKUPLOAD_USER_ID USERS SYS_C002087135 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
GP_PORTRAIT_ID_PKNORMALUNIQUEPORTRAIT_ID
SYS_IL0001976786C00005$$LOBUNIQUE 
SYS_IL0001976786C00013$$LOBUNIQUE 

Triggers

Name: GP_PORTRAIT_PRIMARY_TR
CREATE TRIGGER gp_portrait_primary_tr
BEFORE insert on general_portraits
FOR EACH ROW
REFERENCING NEW AS NEW OLD AS OLD
When new.portrait_primary_p = 't'
DECLARE
   v_count_primary number;
   pragma autonomous_transaction;
BEGIN
   SELECT count(gp.portrait_id) INTO v_count_primary
     FROM general_portraits gp
    WHERE gp.on_what_id = :new.on_what_id
      AND gp.on_which_table = :new.on_which_table
      AND gp.portrait_primary_p = 't';
   IF v_count_primary >= 1 THEN
      RAISE_APPLICATION_ERROR (-20000, 'Multiple primary portrait');
   END IF;
END;



Generated by OraSchemaDoc, (c) Aram Kananov, 2002