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.

Back to Article