user admin module:
UI design, and sql tables already built, if the job is done well then more work available.
3 user types: level 1,2,3
4 page types: A, B, C, D
level 1 has CRUD access to all other users, and to all databases.
level 2 has CRUD access to tables related to page type A.
level 3 has CRUD access to tables related to page type A,B,C,D. but any create, edit, delete action has to be approved by user level 1 before it can be committed.
3 passwords for 'level 3' user:
password 1 allows user access to all functions for that user level (see above).
password 2 allows user to ONLY view data for page A.
psssword 3 allows user to ONLY view pages A and B.
Page A : overview page: will allow user to add instances of page type C and D. will also display summary of main information from tables (UI built).
Page B : CRUD, simple table of demographics (tables built)
Page C : from 'page A' a new 'page C' can be created. once in an instance of 'page C' CRUD functions will occur. (UI built, 8 fields in table)
Page D : from 'page A' a new 'page D' can be created. once in an instance of 'page C' CRUD functions will occur. (UI built, 8 fields in table).