Documemtation

TABLE regional_prosecutions
TABLE COMMENT A list of regional prosecutions scrapped from various legal / court databases from around the Pacific
ROWS 153
COLUMN
COMMENT
TYPE
LENGTH
COLUMN KEY
POSITION
IS NULL
id int(11) PRI 1 NO
date_created datetime 2 YES
date_updated datetime 3 YES
Case varchar(255) 255 4 YES
Case_Outcome varchar(120) 120 5 YES
Flag_State varchar(255) 255 6 YES
Jurisdiction varchar(255) 255 7 YES
Flag_State_Code char(2) 2 8 YES
Jurisdiction_Code char(2) 2 9 YES
Plaintiff varchar(255) 255 10 YES
Defendant varchar(255) 255 11 YES
Judges_Name varchar(255) 255 12 YES
Date_of_Judgement__Settlement date 13 YES
Settlement_Amount decimal(32,4) 14 YES
Submitted_By_First_Name varchar(255) 255 15 YES
Submitted_By_Last_Name varchar(255) 255 16 YES
Email varchar(255) 255 17 YES
Vessel_Name varchar(255) 255 18 YES
Registry_Vessel_Name varchar(255) 255 19 YES
Vessel_Type varchar(255) 255 20 YES
Year_Built int(11) 21 YES
IMO int(11) 22 YES
MMSI int(11) 23 YES
IRCS varchar(20) 20 24 YES