ASRW website/Database

From UBC Wiki
Jump to navigation Jump to search

Relational Database Tables to be used in the ASRW website

Tablename: Category
Field Category CategoryDisplayName
Example Value 1 Disciplines (root) Writing in the Disciplines
Example Value 2 Psychology Writing in the discipline of Psychology
Example Value 3 English Writing in the discipline of English
Example Value 4 English-Downloads Resource Downloads
Example Value 5 English-Articles Articles
Example Value 5 History-TAP Talking-Aloud
Example Value 7 General-Interviews Interview with Faculty Members

Tablename: CategoryRelation (table that defines the tree-like hierarchical relationships between the different categories)
Field CategoryParent CategoryChild
Example Value 1 Disciplines (root) History
Example Value 2 Disciplines (root) English
Example Value 3 English English-Articles
Example Value 4 English English-Downloads
Tablename: Resource (resources are articles, video, audio recordings, animation, etc)
Field Name Citation Abstract Mini-Abstract Location ContentType FileType
Example Value 1 Writing across and against the Curriculum Title: Writing across and against the Curriculum Author: Art Young College Composition and Communication, Vol. 54, No. 3 (Feb., 2003), pp. 472-485 After reviewing my career as a teacher of composition and literature and as a writing program administrator of writing across the curriculum, I discuss ... An article about writing in the discipline of English. /Content/English/Articles/WritingAcrossAndAgainstTheCurriculum.pdf Text PDF
Example Value 2 Interview with Dr. Katharine Patterson Dr. Katharine Patterson, Chair of Arts Studies in Research & Writing, discusses the epistemology of ... An interview with Dr. Katharine Patterson regarding Arts Studies in Research & Writing /Content/General/Interviews/Patterson.avi Video AVI
Tablename: CategoryResourceRelation (this table links the resource to the category (ies) that it belongs to)
Field Category Resource
Example Value 1 English-Articles Writing across and against the Curriculum
Example Value 2 General-Interviews Interview with Dr. Katharine Patterson

Back to ASRW Main Page.