Fields to add

[zmon]

Note: moved some of the new fields from conviction to client

Client

             $table->string('license_issuing_state',64)->nullable();
             $table->string('license_expiration_date',64)->nullable();

+            
+            $table->string('filling_court',64)->nullable();
+
+            $table->string('judicial_circuit_number',64)->nullable();
+            $table->string('count_name',64)->nullable();
+            $table->string('judge_name',64)->nullable();
+            $table->string('division_name',64)->nullable();
+            $table->string('petitioner_name',64)->nullable();
+            $table->string('division_number',64)->nullable();
+            $table->string('city_name_here',64)->nullable();
+            $table->string('county_name',64)->nullable();
+            $table->string('arresting_county',64)->nullable();
+            $table->string('prosecuting_county',64)->nullable();
+            $table->string('arresting_municipalituy',64)->nullable();
+            $table->text('other_agencies_names')->nullable();
+            //
+
             $table->integer('created_by')->default(0)->nullable();
             $table->integer('modified_by')->default(0)->nullable();
             $table->integer('purged_by')->default(0)->nullable(); 

Convictions table

             $table->unsignedBigInteger('client_id')->default(0);
+            $table->string('name',64)->nullable();
+            $table->string('arrest_date',64)->nullable();

             $table->string('case_number',64)->nullable();
             $table->string('agency',64)->nullable();
@@ -25,7 +27,9 @@ class CreateConvictions extends Migration
             $table->string('name_of_judge',64)->nullable();
             $table->string('your_name_in_case',64)->nullable();
             $table->string('release_status',64)->nullable();
+
             $table->date('release_date')->nullable();
+           $table->text('note')->nullable();
             $table->integer('created_by')->default(0)->nullable();

Charge

             $table->string('class',64)->nullable();
             $table->string('type',64)->nullable();
             $table->string('sentence',64)->nullable();
+            $table->string('convicted',64)->nullable();
             $table->string('eligible',64)->nullable();
+            $table->string('expunge',64)->nullable();
+
+            $table->text('note')->nullable();
+

[zmon]

These things can wait, I have a work around for them

Dates

Would be nice to be able to pass null as a value.

Renames

Client

• judicial_ciruit_number -> judicial_circuit_number
• county_name -> county_of_prosecutor
• count_name -> county_name

Conviction

• arrest_date . should be a string, one could argue that it should be called approximate_arrest_date

[zmon]

GET /clients/2 does not return all fields.

Only returns:

active: null
address_line_1: "205 TENTH AVENUE"
address_line_2: "#330"
city: "New York"
dob: "Thu, 06 Dec 1923 00:00:00 GMT"
email: null
full_name: "Tia Pol"
id: 2
license_expiration_date: "Tue, 01 Jan 2030 00:00:00 GMT"
license_issuing_state: "Illinois"
license_number: "J88484538435345"
phone: "2126758805"
race: "Black or African American"
sex: "Intersex"
state: "New York"
status: null
user_id: null
zip_code: "10011"