mecobject 
Logical Entity Name  mecobject 
Default Table Name  mecobject 
Definition  Summary information on objects associated with a mechanism 

mecobject Columns 
ColumnName  Domain  Datatype  NULL  Definition 
dataid(PK)    NUMBER(15, 0)  NO  Object type 
mecid(PK)(FK)    NUMBER(15, 0)  NO  Mechanism identification. Each mechanism is assigned a unique positive integer which identifies it in the database 
mimetype    VARCHAR2(20)  YES  Image type 
data    BLOB  YES  Object described by dataid/mimetype 
meta    VARCHAR2(128)  YES  Metadata for object, i.e. filename=email.txt 

mecobject Primary and Unique Keys 
Key Name  Key Type  Keys 
MecObject_PK  PrimaryKey  dataid, mecid 

mecobject Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
mec  Non-Identifying  Zero or One to Zero or More        mecid  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 

mecobject Check Constraints 
Check Constraint Name  CheckConstraint 
MecObj02  dataid >= 0 
MecObj01  mecid > 0