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