Contains information about media.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | Each media item has a unique ID. | |
| NUMERIC(19) | not null |
The version of the media item. | ||
| TIMESTAMP | null |
The creation date of the media item. | ||
| TIMESTAMP | null |
The start date which the media item becomes active. | ||
| TIMESTAMP | null |
the end date which the media item is no longer active. | ||
| WVARCHAR(255) | not null |
The name of the media item. | ||
| WVARCHAR(255) | null |
A description of the media item. | ||
| WVARCHAR(255) | not null |
a relative path of where the media item is located in a hierarchy. | ||
| VARCHAR(40) | not null |
The parent of this media item. | ||
| NUMERIC(19) | null |
The type of the media item. |