| 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.' |