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 |  | NUMBER(15, 0) | NO | Object type
mecid |  | 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