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