portune

Tables (38)

assignments

  • id — UUID — Primary key — NOT NULL
  • candidate_id — UUID — Foreign key → candidates.id — NOT NULL
  • snapshot_id — UUID — Foreign key → snapshot_orders.snapshot_id — NOT NULL
  • snapshot_order_id — UUID — Foreign key → snapshot_orders.id — NOT NULL
  • berth_id — UUID — Foreign key → berths.id
  • assignment_status — VARCHAR(30) — NOT NULL
  • etb_at — TIMESTAMPTZ
  • operation_start — TIMESTAMPTZ
  • operation_end — TIMESTAMPTZ
  • hose_disconnect_at — TIMESTAMPTZ
  • etu_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

audit_events

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → planning_workspaces.id
  • actor_issuer — VARCHAR(255) — NOT NULL
  • actor_subject — VARCHAR(255) — NOT NULL
  • action — VARCHAR(100) — NOT NULL
  • entity_type — VARCHAR(100) — NOT NULL
  • entity_id — UUID
  • occurred_at — TIMESTAMPTZ — NOT NULL
  • request_id — VARCHAR(100)
  • before_data — JSONB
  • after_data — JSONB
  • reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

berth_products

  • id — UUID — Primary key — NOT NULL
  • berth_id — UUID — Foreign key → berths.id — NOT NULL
  • product_id — UUID — Foreign key → products.id — NOT NULL
  • direction — VARCHAR(20) — NOT NULL
  • verification_status — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id

berths

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(60) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • external_facility_code — VARCHAR(60)
  • max_dwt_t — DECIMAL(18,3)
  • min_loa_m — DECIMAL(12,3)
  • max_loa_m — DECIMAL(12,3)
  • min_pbl_m — DECIMAL(12,3)
  • max_draft_m — DECIMAL(12,3)
  • direction_minutes — DECIMAL(12,3)
  • switching_minutes — DECIMAL(12,3)
  • verification_status — VARCHAR(30) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id

calculation_results

  • id — UUID — Primary key — NOT NULL
  • assignment_id — UUID — Foreign key → assignments.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • laytime_start — TIMESTAMPTZ
  • laytime_expiry — TIMESTAMPTZ
  • applied_laytime_minutes — DECIMAL(18,6)
  • excess_minutes — DECIMAL(18,6)
  • deducted_minutes — DECIMAL(18,6)
  • final_amount — DECIMAL(20,6)
  • currency — VARCHAR(3)
  • trace_schema_version — VARCHAR(30) — NOT NULL
  • trace — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

candidates

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → runs.workspace_id — NOT NULL
  • snapshot_id — UUID — Foreign key → runs.snapshot_id — NOT NULL
  • run_id — UUID — Foreign key → runs.id — NOT NULL
  • candidate_no — INTEGER — NOT NULL
  • completion_status — VARCHAR(30) — NOT NULL
  • calculation_status — VARCHAR(30) — NOT NULL
  • validation_summary — JSONB
  • required_evaluation_manifest — JSONB
  • currency — VARCHAR(3)
  • total_cost — DECIMAL(20,6)
  • inventory_result — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

cargo_groups

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(40) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

constraint_groups

  • id — UUID — Primary key — NOT NULL
  • policy_version_id — UUID — Foreign key → policy_versions.id — NOT NULL
  • rule_key — VARCHAR(100) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • occupancy_basis — VARCHAR(40) — NOT NULL
  • exception_parameters — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

constraint_members

  • id — UUID — Primary key — NOT NULL
  • constraint_group_id — UUID — Foreign key → constraint_groups.id — NOT NULL
  • berth_id — UUID — Foreign key → berths.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

contract_terms

  • id — UUID — Primary key — NOT NULL
  • order_id — UUID — Foreign key → orders.id — NOT NULL
  • laycan_from — TIMESTAMPTZ
  • laycan_to — TIMESTAMPTZ
  • allowed_laytime — DECIMAL(18,6)
  • laytime_unit — VARCHAR(20)
  • daily_demurrage_rate — DECIMAL(20,6)
  • currency — VARCHAR(3)
  • daylight_condition — JSONB
  • cfr_condition — JSONB
  • verification_status — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id

disruption_berths

  • id — UUID — Primary key — NOT NULL
  • disruption_id — UUID — Foreign key → disruptions.id — NOT NULL
  • berth_id — UUID — Foreign key → berths.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

disruptions

  • id — UUID — Primary key — NOT NULL
  • kind — VARCHAR(30) — NOT NULL
  • starts_at — TIMESTAMPTZ — NOT NULL
  • ends_at — TIMESTAMPTZ — NOT NULL
  • reason — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id — NOT NULL

duration_estimates

  • id — UUID — Primary key — NOT NULL
  • snapshot_cargo_id — UUID — Foreign key → snapshot_cargoes.id — NOT NULL
  • berth_id — UUID — Foreign key → berths.id — NOT NULL
  • processing_rate — DECIMAL(20,6) — NOT NULL
  • rate_unit — VARCHAR(30) — NOT NULL
  • hose_delay_minutes — DECIMAL(18,6) — NOT NULL
  • hose_application — VARCHAR(40) — NOT NULL
  • estimation_method — VARCHAR(40) — NOT NULL
  • sample_count — INTEGER
  • fallback_level — VARCHAR(60)
  • evidence_refs — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

findings

  • id — UUID — Primary key — NOT NULL
  • candidate_id — UUID — Foreign key → candidates.id — NOT NULL
  • rule_key — VARCHAR(100) — NOT NULL
  • result — VARCHAR(30) — NOT NULL
  • severity — VARCHAR(20) — NOT NULL
  • related_refs — JSONB
  • explanation — TEXT — NOT NULL
  • evidence_refs — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

fixed_occupancies

  • id — UUID — Primary key — NOT NULL
  • berth_id — UUID — Foreign key → berths.id — NOT NULL
  • vessel_evidence — JSONB
  • cargo_evidence — JSONB
  • starts_at — TIMESTAMPTZ — NOT NULL
  • ends_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id — NOT NULL

historical_shipments

  • id — UUID — Primary key — NOT NULL
  • external_shipment_key — VARCHAR(200) — NOT NULL
  • external_line_key — VARCHAR(200) — NOT NULL
  • vessel_id — UUID — Foreign key → vessels.id — NOT NULL
  • product_id — UUID — Foreign key → products.id — NOT NULL
  • berth_id — UUID — Foreign key → berths.id — NOT NULL
  • quantity — DECIMAL(20,6) — NOT NULL
  • quantity_unit — VARCHAR(20) — NOT NULL
  • operation_start_at — TIMESTAMPTZ — NOT NULL
  • operation_end_at — TIMESTAMPTZ — NOT NULL
  • hose_disconnect_at — TIMESTAMPTZ
  • verification_status — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id — NOT NULL

input_snapshots

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → input_snapshots.workspace_id — NOT NULL
  • revision_no — BIGINT — NOT NULL
  • parent_snapshot_id — UUID — Foreign key → input_snapshots.id
  • change_set — JSONB
  • change_reason — TEXT
  • status — VARCHAR(20) — NOT NULL
  • schema_version — VARCHAR(30) — NOT NULL
  • content_hash — VARCHAR(64)
  • planning_start — TIMESTAMPTZ — NOT NULL
  • planning_end — TIMESTAMPTZ — NOT NULL
  • timezone — VARCHAR(50) — NOT NULL
  • environment — JSONB — NOT NULL
  • frozen_at — TIMESTAMPTZ
  • frozen_by — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL

inventory_observations

  • id — UUID — Primary key — NOT NULL
  • storage_pool_id — UUID — Foreign key → storage_pools.id — NOT NULL
  • observed_at — TIMESTAMPTZ — NOT NULL
  • quantity — DECIMAL(20,6) — NOT NULL
  • quantity_unit — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • source_id — UUID — Foreign key → sources.id — NOT NULL

order_cargoes

  • id — UUID — Primary key — NOT NULL
  • order_id — UUID — Foreign key → orders.id — NOT NULL
  • line_no — INTEGER — NOT NULL
  • product_id — UUID — Foreign key → products.id — NOT NULL
  • direction — VARCHAR(20) — NOT NULL
  • quantity — DECIMAL(20,6) — NOT NULL
  • quantity_unit — VARCHAR(20) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

orders

  • id — UUID — Primary key — NOT NULL
  • vessel_id — UUID — Foreign key → vessels.id — NOT NULL
  • external_source_id — UUID — Foreign key → sources.id
  • external_key — VARCHAR(200)
  • eta_at — TIMESTAMPTZ
  • nor_tender_at — TIMESTAMPTZ
  • status — VARCHAR(30) — NOT NULL
  • trade_direction — VARCHAR(20) — NOT NULL
  • applicable_vessel_type_id — UUID — Foreign key → vessel_types.id
  • classification_source_id — UUID — Foreign key → sources.id
  • classification_reason — TEXT
  • classification_status — VARCHAR(30) — NOT NULL
  • classification_reviewed_by — VARCHAR(255)
  • classification_reviewed_at — TIMESTAMPTZ
  • arrival_draft_expected_m — DECIMAL(12,3)
  • departure_draft_expected_m — DECIMAL(12,3)
  • arrival_draft_actual_m — DECIMAL(12,3)
  • departure_draft_actual_m — DECIMAL(12,3)
  • arrival_draft_observed_at — TIMESTAMPTZ
  • departure_draft_observed_at — TIMESTAMPTZ
  • arrival_draft_source_id — UUID — Foreign key → sources.id
  • departure_draft_source_id — UUID — Foreign key → sources.id
  • actual_times — JSONB
  • fixed_plan — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

plan_selections

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → plan_selections.workspace_id — NOT NULL
  • snapshot_id — UUID — Foreign key → candidates.snapshot_id — NOT NULL
  • candidate_id — UUID — Foreign key → candidates.id — NOT NULL
  • request_key — VARCHAR(100) — NOT NULL
  • request_hash — VARCHAR(64) — NOT NULL
  • selection_version — BIGINT — NOT NULL
  • selected_by — VARCHAR(255) — NOT NULL
  • selected_at — TIMESTAMPTZ — NOT NULL
  • reason — TEXT — NOT NULL
  • selection_mode — VARCHAR(30) — NOT NULL
  • supersedes_selection_id — UUID — Foreign key → plan_selections.id
  • created_at — TIMESTAMPTZ — NOT NULL

planning_workspaces

  • id — UUID — Foreign key → plan_selections.workspace_id — NOT NULL
  • scope_key — VARCHAR(100) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • active_snapshot_id — UUID — Foreign key → plan_selections.snapshot_id
  • active_selection_id — UUID — Foreign key → plan_selections.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

policy_versions

  • id — UUID — Primary key — NOT NULL
  • version_label — VARCHAR(100) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • schema_version — VARCHAR(30) — NOT NULL
  • rules — JSONB — NOT NULL
  • content_hash — VARCHAR(64)
  • event_time_basis — VARCHAR(60)
  • reviewed_by — VARCHAR(255)
  • approved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

policy_vessel_type_rules

  • id — UUID — Primary key — NOT NULL
  • policy_version_id — UUID — Foreign key → policy_versions.id — NOT NULL
  • vessel_type_id — UUID — Foreign key → vessel_types.id — NOT NULL
  • rule_key — VARCHAR(100) — NOT NULL
  • applicability — VARCHAR(30) — NOT NULL
  • effective_from — TIMESTAMPTZ — NOT NULL
  • effective_to — TIMESTAMPTZ
  • source_location — TEXT
  • evidence_note — TEXT
  • verification_status — VARCHAR(30) — NOT NULL
  • approval_status — VARCHAR(30) — NOT NULL
  • approved_by — VARCHAR(255)
  • approved_at — TIMESTAMPTZ
  • unresolved_reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id — NOT NULL

process_flows

  • id — UUID — Primary key — NOT NULL
  • storage_pool_id — UUID — Foreign key → storage_pools.id — NOT NULL
  • direction — VARCHAR(10) — NOT NULL
  • starts_at — TIMESTAMPTZ — NOT NULL
  • ends_at — TIMESTAMPTZ — NOT NULL
  • quantity — DECIMAL(20,6) — NOT NULL
  • quantity_unit — VARCHAR(20) — NOT NULL
  • profile — VARCHAR(30) — NOT NULL
  • verification_status — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id — NOT NULL

products

  • id — UUID — Primary key — NOT NULL
  • cargo_group_id — UUID — Foreign key → cargo_groups.id — NOT NULL
  • code — VARCHAR(60) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

report_candidates

  • id — UUID — Primary key — NOT NULL
  • report_id — UUID — Foreign key → reports.id — NOT NULL
  • candidate_id — UUID — Foreign key → candidates.id — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • display_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

reports

  • id — UUID — Primary key — NOT NULL
  • primary_snapshot_id — UUID — Foreign key → input_snapshots.id — NOT NULL
  • selection_id — UUID — Foreign key → plan_selections.id
  • report_type — VARCHAR(40) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • schema_version — VARCHAR(30) — NOT NULL
  • content — JSONB
  • input_package — JSONB — NOT NULL
  • artifact_ref — TEXT
  • artifact_hash — VARCHAR(64)
  • created_by — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

runs

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → input_snapshots.workspace_id — NOT NULL
  • snapshot_id — UUID — Foreign key → input_snapshots.id — NOT NULL
  • request_key — VARCHAR(100) — NOT NULL
  • request_hash — VARCHAR(64) — NOT NULL
  • algorithm — VARCHAR(60) — NOT NULL
  • algorithm_version — VARCHAR(60) — NOT NULL
  • engine_version — VARCHAR(60) — NOT NULL
  • config — JSONB — NOT NULL
  • random_seed — BIGINT
  • status — VARCHAR(30) — NOT NULL
  • started_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ
  • timeout_seconds — INTEGER
  • heartbeat_at — TIMESTAMPTZ
  • attempt_no — INTEGER — NOT NULL
  • lease_token — UUID
  • error_code — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL

snapshot_cargoes

  • id — UUID — Primary key — NOT NULL
  • snapshot_id — UUID — Foreign key → snapshot_orders.snapshot_id — NOT NULL
  • snapshot_order_id — UUID — Foreign key → snapshot_orders.id — NOT NULL
  • order_id — UUID — Foreign key → order_cargoes.order_id — NOT NULL
  • order_cargo_id — UUID — Foreign key → order_cargoes.id — NOT NULL
  • line_no — INTEGER — NOT NULL
  • product_data — JSONB — NOT NULL
  • direction — VARCHAR(20) — NOT NULL
  • quantity — DECIMAL(20,6) — NOT NULL
  • quantity_unit — VARCHAR(20) — NOT NULL
  • conversion_data — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

snapshot_orders

  • id — UUID — Primary key — NOT NULL
  • snapshot_id — UUID — Foreign key → input_snapshots.id — NOT NULL
  • order_id — UUID — Foreign key → contract_terms.order_id — NOT NULL
  • contract_terms_id — UUID — Foreign key → contract_terms.id — NOT NULL
  • order_data — JSONB — NOT NULL
  • vessel_data — JSONB — NOT NULL
  • contract_data — JSONB — NOT NULL
  • progress_data — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

solar_days

  • id — UUID — Primary key — NOT NULL
  • local_date — DATE — NOT NULL
  • sunrise_at — TIMESTAMPTZ — NOT NULL
  • sunset_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id — NOT NULL

sources

  • id — UUID — Primary key — NOT NULL
  • source_type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • locator — TEXT
  • captured_at — TIMESTAMPTZ
  • effective_from — TIMESTAMPTZ
  • effective_to — TIMESTAMPTZ
  • verification_status — VARCHAR(30) — NOT NULL
  • evidence_note — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

storage_pools

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(60) — NOT NULL
  • product_id — UUID — Foreign key → products.id
  • cargo_group_id — UUID — Foreign key → cargo_groups.id
  • capacity — DECIMAL(20,6) — NOT NULL
  • operating_min — DECIMAL(20,6) — NOT NULL
  • operating_max — DECIMAL(20,6) — NOT NULL
  • quantity_unit — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id — NOT NULL

storage_routes

  • id — UUID — Primary key — NOT NULL
  • berth_id — UUID — Foreign key → berths.id — NOT NULL
  • storage_pool_id — UUID — Foreign key → storage_pools.id — NOT NULL
  • direction — VARCHAR(20) — NOT NULL
  • throughput_limit — DECIMAL(20,6)
  • throughput_unit — VARCHAR(30)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

transfers

  • id — UUID — Primary key — NOT NULL
  • assignment_id — UUID — Foreign key → assignments.id — NOT NULL
  • candidate_id — UUID — Foreign key → assignments.candidate_id — NOT NULL
  • snapshot_id — UUID — Foreign key → snapshot_cargoes.snapshot_id — NOT NULL
  • snapshot_order_id — UUID — Foreign key → snapshot_cargoes.snapshot_order_id — NOT NULL
  • snapshot_cargo_id — UUID — Foreign key → snapshot_cargoes.id — NOT NULL
  • storage_route_id — UUID — Foreign key → storage_routes.id — NOT NULL
  • sequence_no — INTEGER — NOT NULL
  • starts_at — TIMESTAMPTZ — NOT NULL
  • ends_at — TIMESTAMPTZ — NOT NULL
  • quantity — DECIMAL(20,6) — NOT NULL
  • quantity_unit — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

vessel_types

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(40) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • verification_status — VARCHAR(30) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id — NOT NULL

vessels

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • imo — VARCHAR(7)
  • call_sign — VARCHAR(30)
  • mmsi — VARCHAR(9)
  • vessel_type_id — UUID — Foreign key → vessel_types.id
  • registered_type_raw — VARCHAR(200)
  • vessel_type_source_id — UUID — Foreign key → sources.id
  • vessel_type_verified_at — TIMESTAMPTZ
  • vessel_type_status — VARCHAR(30) — NOT NULL
  • gross_tonnage — DECIMAL(18,3)
  • gross_tonnage_standard — VARCHAR(10)
  • dwt_t — DECIMAL(18,3)
  • loa_m — DECIMAL(12,3)
  • pbl_m — DECIMAL(12,3)
  • design_draft_m — DECIMAL(12,3)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • row_version — BIGINT — NOT NULL
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)
  • source_id — UUID — Foreign key → sources.id