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.
9/ 'book_chapter' requires a numeric 'title' which is the chapter number. NB when inputting a new book_chapter, editing or importing don't check for duplicates on chapter/title.
Table\Resource Type | Book | Book Article | Book Chapter | Journal Article | Newspaper Article | Magazine Article | Web Site | Web Article | Web Encyclopedia | Web Encyclopedia Article | Thesis | Broadcast | Film | Miscellaneous | Miscellaneous Section | Software | Artwork | Audiovisual | Case | Legal Rule/Regulation | Bill | Classical Work | Conference Paper | Proceedings Article | 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 | book_article | journal_article | newspaper_article | magazine_article | web_site | web_article | web_encyclopedia | web_encyclopedia_article | type | thesis | broadcast | film | miscellaneous | miscellaneous_section | software | artwork | audiovisual | case | type | legal_ruling | bill | classical | conference_paper | proceedings_article | government_report | report | type | statute | patent | hearing | database | manuscript | map | chart | personal | type | proceedings | music_album | music_track | music_score | unpublished |
title | * | * | Chapter no. | * | * | * | * | * | * | * | title | * | * | * | * | * | * | * | * | * | title | * | * | * | * | * | * | * | title | * | * | * | * | * | * | * | * | title | * | * | * | * | * |
subtitle | * | * | * | * | * | * | * | * | * | subtitle | * | * | * | * | * | * | * | * | * | subtitle | * | * | * | * | * | * | * | subtitle | * | * | * | * | * | * | * | * | subtitle | * | * | * | * | * | |
noSort | * | * | * | * | * | * | * | * | * | noSort | * | * | * | * | * | * | * | * | * | noSort | * | * | * | * | * | * | * | noSort | * | * | * | * | * | * | * | * | noSort | * | * | * | * | * | |
shortTitle | * | * | * | * | * | * | * | * | * | shortTitle | * | * | * | * | * | * | * | * | * | shortTitle | * | * | * | * | * | * | * | shortTitle | * | * | * | * | * | * | * | * | shortTitle | * | * | * | * | * | |
transTitle | * | * | * | transTitle | transTitle | transTitle | transTitle | ||||||||||||||||||||||||||||||||||||
transSubtitle | * | * | * | transSubtitle | transSubtitle | transSubtitle | transSubtitle | ||||||||||||||||||||||||||||||||||||
transNoSort | * | * | * | transNoSort | transNoSort | transNoSort | transNoSort | ||||||||||||||||||||||||||||||||||||
transShortTitle | * | * | * | transShortTitle | transShortTitle | transShortTitle | transShortTitle | ||||||||||||||||||||||||||||||||||||
isbn | * | * | * | * | * | * | * | * | * | * | isbn | * | * | * | * | * | * | * | * | * | isbn | * | * | * | * | * | * | * | isbn | * | * | * | * | * | * | * | * | isbn | * | * | * | * | * |
url | * | * | * | * | * | * | * | * | * | * | url | * | * | * | * | * | * | * | * | * | url | * | * | * | * | * | * | * | url | * | * | * | * | * | * | * | * | url | * | * | * | * | * |
doi | * | * | * | * | * | * | * | * | * | * | doi | * | * | * | * | * | * | * | * | * | doi | * | * | * | * | * | * | * | doi | * | * | * | * | * | * | * | * | doi | * | * | * | * | * |
bibtexKey | * | * | * | * | * | * | * | * | * | * | bibtexKey | * | * | * | * | * | * | * | * | * | bibtexKey | * | * | * | * | * | * | * | bibtexKey | * | * | * | * | * | * | * | * | bibtexKey | * | * | * | * | * |
field1 | Series Title | Series Title | Series Title | Volume Number | Section | Edition | Volume Number | field1 | Thesis Type | Country | Series Title | Reporter | field1 | Section | Section | Series Title | Section | Series Title | field1 | Public Law Number | Published Source | Committee | Series Title | Name of File | field1 | ||||||||||||||||||
field2 | Edition | Edition | Edition | Issue Number | City | Type of Article | Issue Number | Edition | Edition | field2 | Thesis Description | Medium | 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 | Series Number | Issue Number | field3 | Volume Number | Edition | field3 | Edition | Session | Series Number | Edition | field3 | Session | Application Number | Session | Edition | Image Size | field3 | Edition | |||||||||||||||||||||||
field4 | Volume Number | Volume Number | Volume Number | Volume | field4 | Issue Number | version | Series Number | Reporter Volume | field4 | Rule Number | Code Volume | Volume | Volume Number | 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 | Number of pages | field6 | Number of pages | 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 | Book Chapter | Journal Article | Newspaper Article | Magazine Article | Web Site | Web Article | Web Encyclopedia | Web Encyclopedia Article | Thesis | Broadcast | Film | Miscellaneous | Miscellaneous Section | Software | Artwork | Audiovisual | Case | Legal Rule/Regulation | Bill | Classical Work | Conference Paper | Proceedings Article | 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 | Book ID | Journal ID | Newspaper ID | Magazine ID | Journal ID | Jounral ID | collection | Journal ID | Collection ID | collection | Code ID | Conference ID | Conference ID | collection | Manuscript ID | collection | Collection ID | |||||||||||||||||||||||||
publisher | Publisher ID | Publisher ID | Publisher ID | Publisher ID | Publisher ID | Publisher ID | publisher | Institution ID | Channel ID | Distributor ID | Publisher ID | Publisher ID | Publisher ID | Publisher ID | Publisher ID | Court ID | publisher | Publisher ID | Legislature ID | Conference Organizer ID | Conference Organiser ID | Publisher ID | Institution ID | publisher | Assignee ID | Publisher 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 | Translated Publisher ID | Translated Publisher ID | Translated Publisher ID | miscField1 | Minutes | Minutes | miscField1 | miscField1 | miscField1 | Publisher ID | |||||||||||||||||||||||||||||||||
miscField2 | Day | startDay | Day | Day | Day | Day | miscField2 | Day | Day | miscField2 | Day | startDay | startDay | Day | miscField2 | Day | Day | Day | Day | Day | Day | miscField2 | startDay | ||||||||||||||||||||
miscField3 | startMonth | Month | startMonth | Month | Month | Month | Month | miscField3 | Month | Month | miscField3 | Month | startMonth | startMonth | Month | miscField3 | Month | Month | Month | Month | Month | Month | miscField3 | startMonth | |||||||||||||||||||
miscField4 | Number of Volumes | Number of Volumes | Number of Volumes | miscField4 | Hours | Hours | Number of Volumes | miscField4 | miscField4 | Number of Volumes | miscField4 | ||||||||||||||||||||||||||||||||
miscField5 | endDay | publicationDay | miscField5 | miscField5 | endDay | endDay | miscField5 | miscField5 | endDay | ||||||||||||||||||||||||||||||||||
miscField6 | endMonth | endMonth | publicationMonth | miscField6 | miscField6 | endMonth | endMonth | miscField6 | miscField6 | endMonth | |||||||||||||||||||||||||||||||||
WKX_publisher | |||||||||||||||||||||||||||||||||||||||||||
publisherName | * | * | * | * | * | * | publisherName | * | * | * | * | * | * | * | * | * | publisherName | * | * | * | conference | * | * | publisherName | * | * | * | * | * | publisherName | * | * | * | * | * | ||||||||
publisherLocation | * | * | * | * | * | * | publisherLocation | * | * | * | * | * | * | * | publisherLocation | * | * | * |
* | * | publisherLocation | * | * | * | * | * | publisherLocation | * | * | * | |||||||||||||
publisherType | book | book | book | book | book | book | publisherType | institution | distributor | distributor | (ALL) | (ALL) | book | book | book | legal | publisherType | legal | legal | conference | conference | legal | book | publisherType | legal | legal | book | chart | chart | publisherType | conference | music | music | music | institution | ||||||||
WKX_resource_collection | Book | Book Article | Book Chapter | Journal Article | Newspaper Article | Magazine Article | Web Site | Web Article | Web Encyclopedia | Web Encyclopedia Article | Thesis | Broadcast | Film | Miscellaneous | Miscellaneous Section | Software | Artwork | Audiovisual | Case | Legal Rule/Regulation | Bill | Classical Work | Conference Paper | Proceedings Article | Government Report/Documentation | Report/Documentation | Statute | Patent | Hearing | Online Database | Manuscript | Map | Chart/Image | Personal Communication | Proceedings | Music Album | Music Track | Music Score | Unpublished | ||||
collectionTitle | * | * | * | * | * | * | * | collectionTitle | * | * | collectionTitle | * | * | collectionTitle | * | collectionTitle | * | ||||||||||||||||||||||||||
collectionTitleShort | * | * | * | * | * | * | * | collectionTitleShort | * | * | collectionTitleShort | * | * | collectionTitleShort | * | collectionTitleShort | * | ||||||||||||||||||||||||||
collectionType | book | book | journal | newspaper | magazine | web | web | collectionType | journal | (ALL) | collectionType | journal | journal | collectionType | manuscript | collectionType | music | ||||||||||||||||||||||||||
collectionString | * | * | * | * | * | * | * | collectionString | * | * | collectionString | * | * | collectionString | * | collectionString | * | ||||||||||||||||||||||||||
WKX_resource_year | Book | Book Article | Book Chapter | Journal Article | Newspaper Article | Magazine Article | Web Site | Web Article | Web Encyclopedia | Web Encyclopedia Article | Thesis | Broadcast | Film | Miscellaneous | Miscellaneous Section | Software | Artwork | Audiovisual | Case | Legal Rule/Regulation | Bill | Classical Work | Conference Paper | Proceedings Article | 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 Year | Publication Start Year | Publication Year | Publication 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 | 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 | Reprint Year | Access Year | Access Year | Access Year | Access Year | year2 | Abstract Year | year2 | Conference startYear | Conference startYear | year2 | Access Year | year2 | Conference startYear | |||||||||||||||||||||||||||
year3 | Volume Publication Year | Volume Publication Year | Volume Publication Year | Publication End Year | Revision Year | Revision Year | year3 | Volume Publication Year | year3 | Conference endYear | Conference endYear | year3 | year3 | Conference endYear | |||||||||||||||||||||||||||||
year4 | Translated Work Publication Year | Translated Work Publication Year | Translated Work Publication Year | year4 | year4 | year4 | year4 | ||||||||||||||||||||||||||||||||||||
WKX_resource_page | |||||||||||||||||||||||||||||||||||||||||||
pageStart | * | * | * | * | * | * | * | pageStart | * | * | pageStart | * | * | * | * | * | pageStart | * | * | * | pageStart | * | |||||||||||||||||||||
pageEnd | * | * | * | * | * | * | * | pageEnd | * | * | pageEnd | * | * | * | * | * | pageEnd | * | * | * | pageEnd | * | |||||||||||||||||||||
WKX_resource_creator | |||||||||||||||||||||||||||||||||||||||||||
creator1 | author | author | author | author | author | author | author | author | author | author | creator1 | author | director | director | author | author | author | artist | author | creator1 | author | attributedTo | author | author | author | author | creator1 | inventor | author | cartographer | creator | author | creator1 | performer | performer | composer | author | ||||||
creator2 | editor | editor | editor | editor | editor | creator2 | producer | producer | performer | creator2 | editor | editor | editor | creator2 | Issuing Organization | recipient | creator2 | composer | composer | editor | |||||||||||||||||||||||
creator3 | translator | translator | translator | creator3 | counsel | creator3 | creator3 | agent | creator3 | conductor | conductor | ||||||||||||||||||||||||||||||||
creator4 | reviser | reviser | reviser | creator4 | creator4 | creator4 | International Author | creator4 | |||||||||||||||||||||||||||||||||||
creator5 | series editor | series editor | series editor | creator5 | series editor | creator5 | creator5 | series editor | creator5 |