pdb_work_data
Primary reference to works
field name |
type |
description |
work_id |
MEDIUMINT(7) auto_inc |
Primary Key |
work_artist_id |
MEDIUMINT(7) |
Artist link |
work_name |
VARCHAR(255) |
Name of PD item |
work_description |
VARCHAR(255) |
Short description of item |
work_uncopy |
TINYINT(1) |
Set to 1 if work has never been copyrighted |
work_item_birthdate |
DATE |
Approximate date work was created |
work_media_genre |
VARCHAR(20) |
Genre. eg. Classical, fiction, rock, modern.. |
pdb_medium_data
Establishes data specific to a reproduction of a work
field name |
type |
description |
medium_id |
MEDIUMINT(7) auto_inc |
Primary Key |
medium_work_id |
MEDIUMINT(7) |
Relate back to primairy work data |
medium_media_type |
MEDIUMINT(7) / VARCHAR |
Relates to medium type table |
medium_copy_holder |
VARCHAR(255) |
Previous/current owner of this reproduction |
medium_copy_date |
DATE |
Date on which work was copyrighted by the holder |
medium_copy_country |
VARCHAR(30) |
Country in which copyright was established |
medium_cat |
VARCHAR(20) |
Media catagory eg. Literature, sheet music, painting, etc. |
pdb_artist_data
To store generic information on artists
field name |
type |
description |
artist_id |
MEDIUMINT(7) auto_inc |
Primary Key |
artist_first_name |
VARCHAR(50)) |
First name |
artist_last_name |
VARCHAR(50) |
Last name |
artist_DOB |
DATE |
artit date of birth (for the record) |
artist_DOD |
DATE |
artists date of death (if applicable) |
artist_description |
TEXT |
A description of the artist |
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_medium_id |
MEDIUMINT(7) |
Reference to medium for which this is a digital reproduction |
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
23/02/06
- Have included tables for artist and medium, and have renamed the metadata table to work_data. Have changed the rest of the database accordingly.
- Mediums now have a copyright start date, instead of an end date. Likewise, artists have a date-of-death.. copyright status can be monitored.
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.