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. |
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
- Reduced genre_name_field size from 100 to 20
- Added additional genre_definition field. This should help to clarifry what a genre covers and what it does not.