slot_reservation

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('slot_reservation_id_seq'::regclass)
berth_reservation.slot_reservation_id berth_reservation_slot_reservation_id_fkeyC
port_call.slot_reservation_id port_call_slot_reservation_id_fkeyN
nomination_id int8 19 √ null
nomination.id slot_reservation_nomination_id_fkeyN
berth_id int8 19 √ null
berth.id slot_reservation_berth_id_fkeyR
email text 2147483647 null
imo int4 10 null
vessel_name text 2147483647 null
loa float4 8,8 null
beam float4 8,8 null
draft float4 8,8 null
laytime interval 49,6 null
eta timestamptz 35,6 null
rta_window_start timestamptz 35,6 √ null
rta_window_end timestamptz 35,6 √ null
jit_eta timestamptz 35,6 √ null
slot_reservation_status_id serial 10 √ nextval('slot_reservation_slot_reservation_status_id_seq'::regclass)
slot_reservation_status.id slot_reservation_slot_reservation_status_id_fkeyR
created_at timestamptz 35,6 CURRENT_DATE
created_by int4 10 null
modified_at timestamptz 35,6 CURRENT_DATE
modified_by int4 10 null
port_call_id int8 19 √ null
port_call.id slot_reservation_port_call_id_fkeyN
jit_eta_discrepancy_time timestamptz 35,6 √ null
jit_eta_alert_state text 2147483647 'green'::text

Indexes

Constraint Name Type Sort Column(s)
slot_reservation_pkey Primary key Asc id
slot_reservation_nomination_id_berth_id_email_imo_vessel_name_e Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc nomination_id + berth_id + email + imo + vessel_name + eta + rta_window_start + rta_window_end + jit_eta + slot_reservation_status_id

Relationships

Close relationships within degrees of separation