a) | ||||
id | filename | title | author | year |
(int(10)) | (varchar(250)) | (varchar(200)) | (varchar(100)) | (int(10)) |
1 | 'activity.xml' | 'A TeachEngineering Activity' | 'University of Colorado at Boulder' | 2004 |
b) | ||||
id | parentName | parentID | index | text_section_name |
(int(10)) | (varchar(100)) | (int(10)) | (int(10)) | (varchar(50)) |
1 | 'activity' | 1 | 1 | 'Section 1' |
2 | 'activity' | 1 | 2 | 'Section 2' |
c) | ||||
id | parentName | parentID | index | text |
(int(10)) | (varchar(100)) | (int(10)) | (int(10)) | (text) |
1 | 'text_section' | 1 | 1 | 'A block of text in section 1.' |
2 | 'text_section' | 1 | 2 | 'Another block of text in section 1.' |
3 | 'text_section' | 2 | 1 | 'A block of text in section 2.' |
4 | 'text_section' | 2 | 2 | 'Another block of text in _section 2.' |
Table 3: Populated metadata tables. (a) activity; (b) test_section; (c) text_block.