media_id

VARCHAR(40)

not null

(primary key)

Each media item has a unique ID.

version

NUMERIC(19)

not null

The version of the media item.

creation_date

TIMESTAMP

null

The creation date of the media item.

start_date

TIMESTAMP

null

The start date which the media item becomes active.

end_date

TIMESTAMP

null

the end date which the media item is no longer active.

name

WVARCHAR(255)

not null

The name of the media item.

description

WVARCHAR(255)

null

A description of the media item.

path

WVARCHAR(255)

not null

a relative path of where the media item is located in a hierarchy.

parent_folder_id

VARCHAR(40)

not null

The parent of this media item.

media_type

NUMERIC(19)

null

The type of the media item.