SQLite format 3@ .K  0C'G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadatax//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrations>_tablefoosfoosCREATE TABLE "foos" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)##otablecommunitiescommunitiesCREATE TABLE "communities" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "global_registry_id" varchar, "infobase_id" integer, "infobase_gr_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)] tablecountriescountriesCREATE TABLE "countries" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "global_registry_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)_tableareasareasCREATE TABLE "areas" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "area_name" varchar, "area_code" varchar, "is_active" boolean, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) S#9indexindex_assignments_on_assigned_by_idassignmentsCREATE INDEX "index_assignments_on_assigned_by_id" ON "assignments" ("assigned_by_id") U#=indexindex_assignments_on_organization_idassignments CREATE INDEX "index_assignments_on_organization_id" ON "assignments" ("organization_id") I#%indexindex_assignments_on_person_idassignments CREATE INDEX "index_assignments_on_person_id" ON "assignments" ("person_id")c ## tableassignmentsassignments CREATE TABLE "assignments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "assigned_by_gr_rel_id" varchar, "role" varchar, "hired_at" datetime, "person_id" integer, "organization_id" integer, "assigned_by_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) I'%indexindex_organizations_on_area_idorganizations CREATE INDEX "index_organizations_on_area_id" ON "organizations" ("area_id") M'-indexindex_organizations_on_parent_idorganizations CREATE INDEX "index_organizations_on_parent_id" ON "organizations" ("parent_id")N''[tableorganizationsorganizationsCREATE TABLE "organizations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "gr_id" varchar, "name" varchar, "description" text, "start_date" date, "parent_id" integer, "area_id" integer, "global_registry_area_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)zEindexindex_addresses_on_person_idaddressesCREATE INDEX "index_addresses_on_person_id" ON "addresses" ("person_id")tableaddressesaddressesCREATE TABLE "addresses" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "address1" varchar, "zip" varchar, "primary" boolean, "person_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)[Iindexindex_people_on_country_of_residence_idpeopleCREATE INDEX "index_people_on_country_of_residence_id" ON "people" ("country_of_residence_id")WAindexindex_people_on_country_of_service_idpeopleCREATE INDEX "index_people_on_country_of_service_id" ON "people" ("country_of_service_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)VtablepeoplepeopleCREATE TABLE "people" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "global_registry_mdm_id" varchar, "global_registry_fingerprint" varchar, "first_name" varchar, "last_name" varchar, "guid" varchar, "country_of_service_id" integer, "country_of_residence_id" integer, "country_of_service_gr_id" varchar, "country_of_residence_gr_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT                   0  0 H#AAenvironmenttest2021-01-21 20:00:21.5567622021-01-21 20:00:21.556762 # environment C' @  0C'G[5indexsqlite_autoindex_ar_internal_metay[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata0//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrationss>_tablefoosfoosCREATE TABLE "foos" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)##otablecommunitiescommunitiesCREATE TABLE "communities" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "global_registry_id" varchar, "infobase_id" integer, "infobase_gr_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)] tablecountriescountriesCREATE TABLE "countries" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "global_registry_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)_tableareasareasCREATE TABLE "areas" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "area_name" varchar, "area_code" varchar, "is_active" boolean, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) S#9indexindex_assignments_on_assigned_by_idassignmentsCREATE INDEX "index_assignments_on_assigned_by_id" ON "assignments" ("assigned_by_id") U#=indexindex_assignments_on_organization_idassignments CREATE INDEX "index_assignments_on_organization_id" ON "assignments" ("organization_id") I#%indexindex_assignments_on_person_idassignments CREATE INDEX "index_assignments_on_person_id" ON "assignments" ("person_id")c ## tableassignmentsassignments CREATE TABLE "assignments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "assigned_by_gr_rel_id" varchar, "role" varchar, "hired_at" datetime, "person_id" integer, "organization_id" integer, "assigned_by_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) I'%indexindex_organizations_on_area_idorganizations CREATE INDEX "index_organizations_on_area_id" ON "organizations" ("area_id") M'-indexindex_organizations_on_parent_idorganizations CREATE INDEX "index_organizations_on_parent_id" ON "organizations" ("parent_id")N''[tableorganizationsorganizationsCREATE TABLE "organizations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "gr_id" varchar, "name" varchar, "description" text, "start_date" date, "parent_id" integer, "area_id" integer, "global_registry_area_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)zEindexindex_addresses_on_person_idaddressesCREATE INDEX "index_addresses_on_person_id" ON "addresses" ("person_id")tableaddressesaddressesCREATE TABLE "addresses" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "address1" varchar, "zip" varchar, "primary" boolean, "person_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)[Iindexindex_people_on_country_of_residence_idpeopleCREATE INDEX "index_people_on_country_of_residence_id" ON "people" ("country_of_residence_id")WAindexindex_people_on_country_of_service_idpeopleCREATE INDEX "index_people_on_country_of_service_id" ON "people" ("country_of_service_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)VtablepeoplepeopleCREATE TABLE "people" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "global_registry_mdm_id" varchar, "global_registry_fingerprint" varchar, "first_name" varchar, "last_name" varchar, "guid" varchar, "country_of_service_id" integer, "country_of_residence_id" integer, "country_of_service_gr_id" varchar, "country_of_residence_gr_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) {P M m V  G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataT55Ktablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)AU/indexsqlite_autoindex_schema_migrations_1schema_migrationsx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)>_tablefoosfoosCREATE TABLE "foos" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)##otablecommunitiescommunitiesCREATE TABLE "communities" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "global_registry_id" varchar, "infobase_id" integer, "infobase_gr_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)] tablecountriescountriesCREATE TABLE "countries" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "global_registry_id" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)_tableareasareasCREATE TABLE "areas" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "global_registry_id" varchar, "area_name" varchar, "area_code" varchar, "is_active" boolean, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) S#9indexindex_assignments_on_assigned_by_idassignmentsCREATE INDEX "index_assignments_on_assigned_by_id" ON "assignments" ("assigned_by_id") U#=indexindex_assignments_on_organization_idassignments CREATE INDEX "index_assignments_on_organization_id" ON "assignments" ("organization_id") I#%indexindex_assignments_on_person_idassignments CREATE INDEX "index_assignments_on_person_id" ON "assignments" ("person_id")