started 10/01/06

pdb_metadata

Primary reference to works

field name

type

description

meta_id

MEDIUMINT(7) auto_inc

Primary Key

meta_name

VARCHAR(255)

Name of PD item

meta_description

VARCHAR(255)

Short description of item

meta_copy_exp

DATE

Approximate date work was created

meta_uncopy

TINYINT(1)

Set to 1 if work has never been copyrighted

meta_item_birthdate

DATE

Approximate date work was created

meta_media_type

VARCHAR(20)

Digital medium. Video, audio, text, still image.

meta_media_cat

VARCHAR(20)

Media catagory eg. Literature, sheet music, painting, etc.

meta_media_genre

VARCHAR(20)

Genre. eg. Classical, fiction, rock, modern..

pdb_media_url

This table contains the URLs and other information specific to an individual digital media.

field name

type

description

media_id

MEDIUMINT(7) auto_inc

Primary key

media_meta_id

MEDIUMINT(7)

Reference to meta table

media_URL

VARCHAR(255)

Absolute URL to work (eg. somework)

media_comment

VARCHAR(255)

Comment about URL

media_submitted

DATE

Date of submission

pdb_media_type

Stores the types of media. Though the generic types of media available are not likely to change Im including it anyway as it makes the database more self-sufficient.

field name

type

description

media_type_id

SMALLINT(3) auto_inc

Primairy key

media_type

VARCHAR(20)

Type of media - audio, video, text and still image

pdb_catagory

This table contains broad categorys eg. Sheet music, painting, literature

field name

type

description

category_id

MEDIUMINT(5) auto_inc

Primary key

category_media_type_id

SMALLINT(3)

Relates back to media type

category_name

VARCHAR(50)

Name of category : sheet music, etc.

pdb_genre

Contains genre names, related back to categorys

field name

type

description

genre_id

MEDIUMINT(5) auto_inc

Primary key

genre_category_id

MEDIUMINT(5)

Relates back to category table

genre_name

VARCHAR(20)

Name of genre. Blues, modern, etc.

genre_definition

VARCHAR(255)

Short description of umbrella genre

Revisions

18/01/06

None: DatabaseDesignCurrent (last edited 2008-01-14 11:33:56 by RufusPollock)