BEN Metadata Database CHANGES 9/23/2003: Added the new Learning Resources Types - INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 1, '<<<< Auditorium - Multimedia >>>>', 'Invalid1', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 2, 'Animation', 'Animation', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 3, 'Audio', 'Audio', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 4, 'Video', 'Video', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 5, 'Diagram', 'Diagram', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 6, 'Table', 'Table', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 7, '35mm slide', '35mm slide', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 8, 'Digital presentation ( powerpoint)', 'Digital presentation ( powerpoint)', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 9, 'Illustration', 'Illustration', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 10, 'Map', 'Map', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 11, 'Photograph', 'Photograph', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 12, 'Image', 'Image', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 13, 'Simulation', 'Simulation', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 14, 'Application', 'Application', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 15, 'Discussion group/Listserv', 'Discussion group/Listserv', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 16, 'Webcast', 'Webcast', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 17, '<<<< Reading Room >>>>', 'Invalid2', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 18, 'Meeting presentation', 'Meeting presentation', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 19, 'Proceedings', 'Proceedings', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 20, 'Book', 'Book', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 21, 'Book chapter', 'Book chapter', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 22, 'Journal', 'Journal', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 23, 'Journal article/Issue', 'Journal article/Issue', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 24, 'Thesis/Dissertation', 'Thesis/Dissertation', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 25, 'Report', 'Report', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 26, 'Memo', 'Memo', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 27, 'Newsletter', 'Newsletter', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 28, 'Non-journal article', 'Non-journal article', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 29, 'Pamphlet/Brochure', 'Pamphlet/Brochure', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 30, '<<<< Reference Room >>>>', 'Invalid3', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 31, 'Bibliography', 'Bibliography', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 32, 'Index', 'Index', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 33, 'Dataset', 'Dataset', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 34, 'Dictionary/Glossary', 'Dictionary/Glossary', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 35, 'Thesaurus', 'Thesaurus', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 36, 'Discussion group/Listserv archive', 'Discussion group/Listserv archive', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 37, 'Manual', 'Manual', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 38, 'Scientific standards and guidelines', 'Scientific standards and guidelines', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 39, 'Review', 'Review', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 40, '<<<< Classroom >>>>', 'Invalid4', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 41, 'Educational standards', 'Educational standards', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 42, 'Teaching strategies & guidelines', 'Teaching strategies & guidelines', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 43, 'Course syllabus', 'Course syllabus', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 44, 'Lesson plan', 'Lesson plan', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 45, 'Lecture/Lecture outline', 'Lecture/Lecture outline', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 46, 'Laboratory exercise', 'Laboratory exercise', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 47, 'Laboratory manual', 'Laboratory manual', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 48, 'Assignment/Activity ( non-laboratory)', 'Assignment/Activity ( non-laboratory)', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 49, 'Assessment- tool', 'Assessment- tool', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 50, 'Assessment- exam with answer key', 'Assessment- exam with answer key', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 51, 'Assessment- exam without answer key', 'Assessment- exam without answer key', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 52, 'Assessment- other', 'Assessment- other', ''); INSERT INTO tbl_ddlb_LearningResourceTypes VALUES( 53, 'Fieldtrip guide', 'Fieldtrip guide', ''); CHANGES 7/24/2003: Added 'status' field to tbl_meta_records - can be used to determine if a record is approved or not CHANGES 4/28/2003: Added 2 new fields to table tbl_users: registerDate and discoverBEN Added the new Disciplines for the BEN Subject/Discipline Taxonomy - INSERT INTO tbl_ddlb_Disciplines VALUES( '62', 'Genomics', 'Genomics', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '63', 'Proteomics', 'Proteomics', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '64', 'Bacteriology', 'Bacteriology', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '65', 'Public health', 'Public health', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '66', 'Biocomplexity', 'Biocomplexity', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '67', 'Biodiversity', 'Biodiversity', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '68', 'Structural biology', 'Structural biology', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '69', 'Oceanography', 'Oceanography', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '70', 'Hematology', 'Hematology', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '71', 'Bioengineering', 'Bioengineering', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '72', 'Enzymology', 'Enzymology', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '73', 'Glycobiology', 'Glycobiology', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '74', 'Metabolism', 'Metabolism', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '75', 'Wildlife science', 'Wildlife science', NULL); INSERT INTO tbl_ddlb_Disciplines VALUES( '76', 'Range Science', 'Range Science', NULL); CHANGES 3/26/2002: A new version of the database schema has been released with several changes, including addition of an 'approved' field to tbl_meta_records, spelling corrections in tbl_ddlb_Disciplines, and the addition of tbl_partner#_identifiers tables to track harvested partner records and tbl_search_index for the search engine. This document will no longer be maintained. CHANGES 2/15/2002: Updated tbl_Partners with new field, modified tbl_ddlb_Disciplines and tbl_ddlb_LearningResourceType CHANGES 1/22/2002: Updated tbl_Partners with new field, added table tbl_ddlb_usersListSortCriteria and tbl_ddlb_ContributorRoles CHANGES 1/15/2002: Changed tbl_users to reflect changes in registration process decided at the last BEN Meeting: added field teachingAudience, removed fields institutionType and minorityGroup CHANGES 1/4/2002: Added table tbl_ddlb_IntendedEndUserRoles Changed default values for table tbl_ddlb_LearningResourceTypes Changed table name 'tbl_ddlb_LearningResouceContexts' to 'tbl_ddlb_LearningResourceContexts' to correct misspelling CHANGES 12/27/2001: Added fields 'middleName', 'namePrefix', and department to tbl_users Changed all 'entity' tables (tbl_meta_lifeCycle_contribute_entity and tbl_meta_metaMetadata_contribute_entity) Dropped field 'value' Added the following fields: name institution department stateProvince vCard CHANGES 12/26/2001: Added 'tbl_Partners' table to store and manage information about BEN partners Added 'tbl_useractions' and 'tbl_userclasses' to be used for permissions and security purposes Added 'tbl_ddlb_*' tables to serve as sources for drop-down menus CHANGES 12/20/2001: Renamed all tables with 'tbl_' prefix ('tbl_meta_' if they are metadata tables) Deleted tables that previously held metadata for CatalogEntry, Contribute, Entity, Keywords, and Language elements. Revised tables that held child metadata elements of the 9 top-level categories: General - Removed the 'description' field from tbl_meta_general' The tables catalogEntry, language, description, keywords, coverage became the following: tbl_meta_general_catalogEntry tbl_meta_general_language tbl_meta_general_description tbl_meta_general_keywords tbl_meta_general_coverage LifeCycle - The tables contribute, entity became the following: tbl_meta_lifeCycle_contribute tbl_meta_lifeCycle_contribute_entity Metametadata - The tables catalogEntry, contribute, entity, metadataScheme, language became the following: tbl_meta_metaMetadata_catalogEntry tbl_meta_metaMetadata_contribute tbl_meta_metaMetadata_contribute_entity tbl_meta_metaMetadata_metadataScheme tbl_meta_metaMetadata_language Technical - The tables format, location, requirements became the following: tbl_meta_technical_format tbl_meta_technical_location tbl_meta_technical_requirements Educational - The tables learningResourceType, intendedEndUserRole, context, typicalAgeRange, language became the following: tbl_meta_educational_learningResourceType tbl_meta_educational_intendedEndUserRole tbl_meta_educational_context tbl_meta_educational_typicalAgeRange tbl_meta_educational_language Relation - The table resource, catalogEntry became the following: tbl_meta_relation_resource tbl_meta_relation_resource_catalogyEntry Classification - The tables keywords, taxonPath, taxon became the following: tbl_meta_classification_keywords tbl_meta_classification_taxonPath tbl_meta_classification_taxonPath_taxon For each of the child tables above (but not the nine parent tables), the following changes were made to the table structure: The field "category varchar(64) NOT NULL" was eliminated. The "categoryID int(10) unsigned NOT NULL" was changed to "parentID int(10) unsigned NOT NULL" The index "KEY recordID (recordID, category, categoryID)" was changed to "KEY recordID (recordID), KEY parentID (parentID)" Also, changed user tables (tbl_users, tbl_userclasses, tbl_useractions) and added 'ddlb' tables (drop-down-list-box) for use in generating drop down menus. See database SQL schema for more info on these changes.