Project

General

Profile

Bug #6330

Updated by Sebastian Citko 11 months ago

create table android.measurement_files( 
 id serial primary key, 
 ship_fkey int, 
 android_report_number int, 
 location text, 
 file_name text, 
 uploaded bool default 'false', 
 foreign key (ship_fkey) references kombajn.ships(ship_id_pkey) on delete cascade); 

 create table android.measurement_files_version( 
 id int, 
 ship_fkey int, 
 android_report_number int, 
 location text, 
 file_name text, 
 uploaded bool default 'false', 
 transaction_id int, 
	 end_transaction_id int, 
	 operation_type text);

Back