Test Database Specification

This zip file contains a pre-configured database that can be uploaded into an empty test environment.

The default test database will have the following entities defined

Organisations

1. Admin - members have admin status

2. OP1 - example school

3. AP1 - example activity provider

4. VP1 - example volunteer provider.

People

1. SysAdmin

2. OP Admin 1

3. OP Member 1

4. OP Member 2

5. OP Follower 1

6. AP Admin 1

7. AP Member 1

8. AP Member 2

9. AP Follower 2

10. VP Admin 1

11. VP Member 1

12. VP Member 2

13. VP Follower 1

Membership

1. SysAdmin - member and orgAdmin of Admin

2. OP Admin 1 - OrgAdmin of School 1

3. OP Member 1 - member of School 1

4. Op Member 2 - member of school 1

5. OP Follower 1 - follower of school 1

6. AP Admin 1 - OrgAdmin of AP1

7. AP Member 1 - member of AP1

8. AP Member 2 - member of AP1

9. AP Follower 2 - follower of AP1

10. VP Admin 1 - OrgAdmin of VP1

11. VP Member 1 - Member of VP1

12. VP Member 2 - Member of VP1

13. VP Follower 1 - Follower of VP1

Activity plans

Owned by AP1.
Activity Plan 1 - published
Activity Plan 2 - draft

Opportunities

Requested by OP Member 1
Opportunity 1 - based on AP1 - published
Opportunity 2 - original, published
Opportunity 3 - original draft.
Opportunity 4 - published and completed

Interests

VP Member 1 - interested in Opportunity 1,
VP Member 1 - attended Opportunity 4
VP Member 2 - invited and committed to Opportunity 3
VP Member 2 - attended Opportunity 4