Mapping of WIKINDX resource types across database tables and fields.
1/ Fields in `WKX_resource` are of type VARCHAR(255).
2/ Fields in `WKX_resource_misc` are of type INT(10).
3/ Fields in `WKX_year` are of type VARCHAR(30).
4/ If a resource type uses fields for 'day' and 'month', these must
be in the fields 'miscField2' and 'miscField3' as these are hard-coded
in the scripts.
5/ If a resource type uses fields for 'minute' and 'hour', these must
be in the fields 'miscField1' and 'miscField4' as these are hard-coded
in the scripts.
6/ All other fields are quite flexible in their use and mappings are
defined in the files core/resource/RESOURCEMAP.php and
core/styles/STYLEMAP.php.
7/ A 'collection' is something of which a resource is a part of, for
example, a book (containing book_article types), a journal, a CD etc.
and each collection in `WKX_collection` is defined by a
`collectionType` which provides focussed select boxes of collections
when adding or editing resources of a particular type. There is no
point displaying a list of journals when prompting the user to input a
book title for a book_article resource type. Mappings are defined in
core/collection/COLLECTIONMAP.php.
8/ Similarly, `WKX_publisher` has `publisherType` which provides
focussed select boxes of publishers when adding/editing resources.
Mappings are defined in core/publisher/PUBLISHERMAP.php.
Table\Resource Type | Book | Book Article | Journal Article | Newspaper Article | Magazine Article | Proceedings Article | Web Article | Thesis | Broadcast | Film | Miscellaneous | Software | Artwork | Audiovisual | Case | Legal Rule/Regulation | Bill | Classical Work | Conference Paper | Government Report/Documentation | Report/Documentation | Statute | Patent | Hearing | Online Database | Manuscript | Map | Chart/Image | Personal Communication | Proceedings | Music Album | Music Track | Music Score | Unpublished | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
WKX_resource | ||||||||||||||||||||||||||||||||||||||
id | * | * | * | * | * | * | * | id | * | * | * | * | * | * | * | * | id | * | * | * | * | * | * | id | * | * | * | * | * | * | * | * | id | * | * | * | * | * |
type | book | book_article | journal_article | newspaper_article | magazine_article | proceedings_article | web_article | type | thesis | film | film | miscellaneous | software | artwork | audiovisual | case | type | legal_ruling | bill | classical | conference_paper | government_report | report | type | statute | patent | hearing | database | manuscript | map | chart | personal | type | proceedings | music_album | music_track | music_score | unpublished |
title | * | * | * | * | * | * | * | title | * | * | * | * | * | * | * | * | title | * | * | * | * | * | * | title | * | * | * | * | * | * | * | * | title | * | * | * | * | * |
subtitle | * | * | * | * | * | * | * | subtitle | * | * | * | * | * | * | * | * | subtitle | * | * | * | * | * | * | subtitle | * | * | * | * | * | * | * | * | subtitle | * | * | * | * | * |
noSort | * | * | * | * | * | * | * | noSort | * | * | * | * | * | * | * | * | noSort | * | * | * | * | * | * | noSort | * | * | * | * | * | * | * | * | noSort | * | * | * | * | * |
isbn | * | * | * | * | * | * | * | isbn | * | * | * | * | * | * | * | * | isbn | * | * | * | * | * | * | isbn | * | * | * | * | * | * | * | * | isbn | * | * | * | * | * |
url | * | * | * | * | * | * | * | url | * | * | * | * | * | * | * | * | url | * | * | * | * | * | * | url | * | * | * | * | * | * | * | * | url | * | * | * | * | * |
file | * | * | * | * | * | * | * | file | * | * | * | * | * | * | * | * | * | * | * | * | * | * | file | * | * | * | * | * | * | * | * | file | * | * | * | * | * | |
field1 | Series Title | Series Title | Volume Number | Section | Edition | Series Title | Volume Number | field1 | Thesis Type | Country | Series Title | Reporter | field1 | Section | Section | Section | Series Title | field1 | Public Law Number | Published Source | Committee | Series Title | Name of File | field1 | ||||||||||||||
field2 | Edition | Edition | Issue Number | City | Type of Article | Issue Number | field2 | Thesis Description | Medium | Type | Medium | Medium | field2 | Type of Rule | Code | Department | Type of Report | field2 | Code | Patent Version Number | Legislative Body | Type of Manuscript | Type of Map | Image Program | Type of Communication | field2 | Medium | Medium | Type of Work | |||||||||
field3 | Series Number | Series Number | Issue Number | Series Number | field3 | Volume Number | Edition | field3 | Edition | Session | Edition | field3 | Session | Application Number | Session | Edition | Image Size | field3 | Edition | |||||||||||||||||||
field4 | Volume Number | Volume Number | Volume | Volume Number | field4 | Issue Number | version | Series Number | Reporter Volume | field4 | Rule Number | Code Volume | Volume | Volume | field4 | Sections | Patent Type | Document Number | Manuscript Number | Type of Image | field4 | |||||||||||||||||
field5 | field5 | Department | Volume Number | field5 | Bill Number | Issue Number | Report Number | field5 | Code Number | International Patent Number | Version | field5 | ||||||||||||||||||||||||||
field6 | field6 | field6 | field6 | International Title | Number | field6 | ||||||||||||||||||||||||||||||||
field7 | field7 | field7 | field7 | International Patent Classification | field7 | |||||||||||||||||||||||||||||||||
field8 | field8 | field8 | field8 | Patent Number | field8 | |||||||||||||||||||||||||||||||||
field9 | field9 | field9 | field9 | Legal Status | field9 | |||||||||||||||||||||||||||||||||
WKX_resource_misc | Book | Book Article | Journal Article | Newspaper Article | Magazine Article | Proceedings Article | Web Article | Thesis | Broadcast | Film | Miscellaneous | Software | Artwork | Audiovisual | Case | Legal Rule/Regulation | Bill | Classical Work | Conference Paper | Government Report/Documentation | Report/Documentation | Statute | Patent | Hearing | Online Database | Manuscript | Map | Chart/Image | Personal Communication | Proceedings | Music Album | Music Track | Music Score | Unpublished | ||||
id | * | * | * | * | * | * | * | id | * | * | * | * | * | * | * | * | id | * | * | * | * | * | * | id | * | * | * | * | * | * | * | * | id | * | * | * | * | * |
collection | Book ID | Journal ID | Newspaper ID | Magazine ID | Conference ID | Journal ID | collection | Journal ID | collection | Code ID | collection | Manuscript ID | collection | Collection ID | ||||||||||||||||||||||||
publisher | Publisher ID | Publisher ID | Conference Organiser ID | publisher | Institution ID | Channel ID | Distributor ID | Publisher ID | Publisher ID | Publisher ID | Publisher ID | Court ID | publisher | Publisher ID | Legislature ID | Publisher ID | Publisher ID | Institution ID | publisher | Assignee ID | Publisher ID | Publisher ID | Publisher ID | publisher | Conference Organiser ID | Publisher ID | Publisher ID | Publisher ID | Institution ID | |||||||||
tag | * | * | * | * | * | * | * | tag | * | * | * | * | * | * | * | * | tag | * | * | * | * | * | * | tag | * | * | * | * | * | * | * | * | tag | * | * | * | * | * |
addUserIdResource | * | * | * | * | * | * | * | addUserIdResource | * | * | * | * | * | * | * | * | addUserIdResource | * | * | * | * | * | * | addUserIdResource | * | * | * | * | * | * | * | * | addUserIdResource | * | * | * | * | * |
editUserIdResource | * | * | * | * | * | * | * | editUserIdResource | * | * | * | * | * | * | * | * | editUserIdResource | * | * | * | * | * | * | editUserIdResource | * | * | * | * | * | * | * | * | editUserIdResource | * | * | * | * | * |
miscField1 | Publisher ID | miscField1 | Minutes | Minutes | miscField1 | miscField1 | miscField1 | |||||||||||||||||||||||||||||||
miscField2 | Day | startDay | startDay | Day | miscField2 | Day | Day | miscField2 | Day | Day | miscField2 | Day | Day | Day | Day | Day | Day | miscField2 | startDay | |||||||||||||||||||
miscField3 | startMonth | Month | startMonth | startMonth | Month | miscField3 | Month | Month | miscField3 | Month | Month | miscField3 | Month | Month | Month | Month | Month | Month | miscField3 | startMonth | ||||||||||||||||||
miscField4 | Number of Volumes | Number of Volumes | miscField4 | Hours | Hours | Number of Volumes | miscField4 | miscField4 | Number of Volumes | miscField4 | ||||||||||||||||||||||||||||
miscField5 | endDay | endDay | miscField5 | miscField5 | miscField5 | miscField5 | endDay | |||||||||||||||||||||||||||||||
miscField6 | endMonth | endMonth | endMonth | miscField6 | miscField6 | miscField6 | miscField6 | endMonth | ||||||||||||||||||||||||||||||
WKX_publisher | ||||||||||||||||||||||||||||||||||||||
publisherName | * | * | * | publisherName | * | * | * | * | * | * | * | * | publisherName | * | * | * | * | * | publisherName | * | * | * | * | * | publisherName | * | * | * | * | * | ||||||||
publisherLocation | * | * | * | publisherLocation | * | * | * | * | * | * | publisherLocation | * | * | * | * | publisherLocation | * | * | * | * | * | publisherLocation | * | * | * | |||||||||||||
publisherType | book | book | conference | publisherType | institution | distributor | distributor | (ALL) | book | book | book | legal | publisherType | legal | legal | conference | legal | book | publisherType | legal | legal | book | chart | chart | publisherType | conference | music | music | music | institution | ||||||||
WKX_resource_collection | ||||||||||||||||||||||||||||||||||||||
collectionTitle | * | * | * | * | * | * | collectionTitle | * | collectionTitle | collectionTitle | * | collectionTitle | * | |||||||||||||||||||||||||
collectionTitleShort | * | * | * | * | * | * | collectionTitleShort | * | collectionTitleShort | collectionTitleShort | * | collectionTitleShort | * | |||||||||||||||||||||||||
collectionType | book | journal | newspaper | magazine | journal | journal | collectionType | journal | collectionType | collectionType | manuscript | collectionType | music | |||||||||||||||||||||||||
WKX_resource_year | Book | Book Article | Journal Article | Newspaper Article | Magazine Article | Proceedings Article | Web Article | Thesis | Broadcast | Film | Miscellaneous | Software | Artwork | Audiovisual | Case | Legal Rule/Regulation | Bill | Classical Work | Conference Paper | Government Report/Documentation | Report/Documentation | Statute | Patent | Hearing | Online Database | Manuscript | Map | Chart/Image | Personal Communication | Proceedings | Music Album | Music Track | Music Score | Unpublished | ||||
year1 | Publication Year | Publication Year | Publication Start Year | Publication Year | Publication Year | Publication Year | Publication Year | year1 | Awarding Year | Publication Year | Publication Year | Publication Year | Publication Year | Publication Year | Publication Year | Publication Year | year1 | Code Edition Year | SessionYear | Publication Year | Publication Year | Publication Year | Publication Year | year1 | Enactment Year | Issue Year | Hearing Year | Publication Year | Publication Year | Publication Year | Publication Year | Year | year1 | Publication Year | Publication Year | Publication Year | Publication Year | Year |
year2 | Reprint Year | Reprint Year | Conference startYear | Access Year | year2 | Abstract Year | year2 | year2 | Access Year | year2 | Conference startYear | |||||||||||||||||||||||||||
year3 | Volume Publication Year | Volume Publication Year | Publication End Year | Conference endYear | year3 | Volume Publication Year | year3 | year3 | year3 | Conference endYear | ||||||||||||||||||||||||||||
WKX_resource_page | ||||||||||||||||||||||||||||||||||||||
pageStart | * | * | * | * | * | * | pageStart | * | * | pageStart | * | * | * | * | pageStart | * | * | * | pageStart | * | ||||||||||||||||||
pageEnd | * | * | * | * | * | * | pageEnd | * | * | pageEnd | * | * | * | * | pageEnd | * | * | * | pageEnd | * | ||||||||||||||||||
WKX_resource_creator | ||||||||||||||||||||||||||||||||||||||
creator1 | author | author | author | author | author | author | author | creator1 | author | director | director | author | author | artist | author | creator1 | author | attributedTo | author | author | author | creator1 | inventor | author | cartographer | creator | author | creator1 | performer | performer | composer | author | ||||||
creator2 | editor | editor | editor | creator2 | producer | producer | performer | creator2 | creator2 | Issuing Organization | recipient | creator2 | composer | composer | editor | |||||||||||||||||||||||
creator3 | translator | translator | creator3 | counsel | creator3 | creator3 | agent | creator3 | conductor | conductor | ||||||||||||||||||||||||||||
creator4 | reviser | reviser | creator4 | creator4 | creator4 | International Author | creator4 | |||||||||||||||||||||||||||||||
creator5 | series editor | series editor | creator5 | series editor | creator5 | creator5 | series editor | creator5 |