Seed tables

[PetitsPoissons]

• [x] seed Access table with real data as follows:

  There are 5 levels of access as follows:

  • superuser level: complete access throughout
  • administrator level: access and edit all data, except for access privileges and data related to security and authentication
  • clinician level: access and edit own clients only (documentation, notes, billing, and reports)
  • basic level: access and edit user, client descriptive data as well diagnosis, document and procedure libraries but cannot see any data related to clinical interventions (documentation, notes and reports on clients)
  • biller level: can manage billing for all clients, but cannot see any data related to clinical interventions (documentation, notes and reports on clients)

• [x] seed User table with mock data (can use mockaroo.com)

• [x] seed Client table with mock data (can use mockaroo.com)

• [x] seed Procedure table with real data (see https://victims.ca.gov/docs/forms/providers/CPTCODES.pdf for example)

• [x] seed Document table with real data

• [x] seed Record table with mock data (make sure to respect the foreign key constraints)

• [x] seed Diagnosis table with real data (e.g. use ICD10 data for a start - can use mockaroo.com)

• [ ] seed IsDiagnosed table with mock data (make sure to respect the foreign key constraints)

[seanc0ne]

Hooray!