| mecobject |
| Logical Entity Name | mecobject |
| Default Table Name | mecobject |
| Definition | Summary information on objects associated with a mechanism |
| mecobject Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| dataid |
NUMERIC(15, 0) | NO | Object type | |
| mecid |
NUMERIC(15, 0) | NO | Mechanism identification. Each mechanism is assigned a unique positive integer which identifies it in the database | |
| mimetype | VARCHAR(20) | YES | Image type | |
| data | PICTURE | YES | Object described by dataid/mimetype | |
| meta | VARCHAR(128) | YES | Metadata for object, i.e. filename=email.txt |
| mecobject Keys |
| Key Name | Key Type | Keys |
| MecObject_PK | PrimaryKey | dataid, mecid |
| mecobject Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| mec | Non-Identifying | Zero or One to Zero or More | mecid | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| mecobject Check Constraints |
| Check Constraint Name | CheckConstraint |
| MecObj01 | mecid > 0 |
| MecObj02 | dataid >= 0 |