
SET transaction_timeout = 0;



--
-- Name: audit_events; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.audit_events (
    id bigint NOT NULL,
    empresa_id bigint,
    user_id bigint,
    event_type character varying(255) NOT NULL,
    entity_type character varying(255) NOT NULL,
    entity_id bigint NOT NULL,
    old_values json,
    new_values json,
    ip_address character varying(255),
    user_agent character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.audit_events OWNER TO sail;

--
-- Name: audit_events_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.audit_events_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.audit_events_id_seq OWNER TO sail;

--
-- Name: audit_events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.audit_events_id_seq OWNED BY public.audit_events.id;

--
-- Name: failed_jobs; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.failed_jobs (
    id bigint NOT NULL,
    uuid character varying(255) NOT NULL,
    connection text NOT NULL,
    queue text NOT NULL,
    payload text NOT NULL,
    exception text NOT NULL,
    failed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.failed_jobs OWNER TO sail;

--
-- Name: failed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.failed_jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.failed_jobs_id_seq OWNER TO sail;

--
-- Name: failed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id;


--
-- Name: job_batches; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.job_batches (
    id character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    total_jobs integer NOT NULL,
    pending_jobs integer NOT NULL,
    failed_jobs integer NOT NULL,
    failed_job_ids text NOT NULL,
    options text,
    cancelled_at integer,
    created_at integer NOT NULL,
    finished_at integer
);


ALTER TABLE public.job_batches OWNER TO sail;

--
-- Name: jobs; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.jobs (
    id bigint NOT NULL,
    queue character varying(255) NOT NULL,
    payload text NOT NULL,
    attempts smallint NOT NULL,
    reserved_at integer,
    available_at integer NOT NULL,
    created_at integer NOT NULL
);


ALTER TABLE public.jobs OWNER TO sail;

--
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.jobs_id_seq OWNER TO sail;

--
-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;


--
-- Name: migrations; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.migrations (
    id integer NOT NULL,
    migration character varying(255) NOT NULL,
    batch integer NOT NULL
);


ALTER TABLE public.migrations OWNER TO sail;

--
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.migrations_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.migrations_id_seq OWNER TO sail;

--
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id;


--
-- Name: model_has_permissions; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.model_has_permissions (
    permission_id bigint NOT NULL,
    model_type character varying(255) NOT NULL,
    model_id bigint NOT NULL
);


ALTER TABLE public.model_has_permissions OWNER TO sail;

--
-- Name: model_has_roles; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.model_has_roles (
    role_id bigint NOT NULL,
    model_type character varying(255) NOT NULL,
    model_id bigint NOT NULL
);


ALTER TABLE public.model_has_roles OWNER TO sail;

--
-- Name: oper_aseguradoras; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_aseguradoras (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    nombre_aseguradora character varying(255) NOT NULL,
    nit character varying(255),
    telefono character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_aseguradoras OWNER TO sail;

--
-- Name: oper_aseguradoras_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_aseguradoras_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_aseguradoras_id_seq OWNER TO sail;

--
-- Name: oper_aseguradoras_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_aseguradoras_id_seq OWNED BY public.oper_aseguradoras.id;


--
-- Name: oper_cdas; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_cdas (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    nombre_cda character varying(255) NOT NULL,
    nit character varying(255),
    direccion character varying(255),
    telefono character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_cdas OWNER TO sail;

--
-- Name: oper_cdas_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_cdas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_cdas_id_seq OWNER TO sail;

--
-- Name: oper_cdas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_cdas_id_seq OWNED BY public.oper_cdas.id;


--
-- Name: oper_cliente_responsables; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_cliente_responsables (
    id bigint NOT NULL,
    cliente_id bigint NOT NULL,
    identificacion character varying(50),
    nombres character varying(150) NOT NULL,
    apellidos character varying(150),
    cargo character varying(100),
    telefono character varying(50),
    correo_electronico character varying(150),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    direccion character varying(200)
);


ALTER TABLE public.oper_cliente_responsables OWNER TO sail;

--
-- Name: oper_cliente_responsables_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_cliente_responsables_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_cliente_responsables_id_seq OWNER TO sail;

--
-- Name: oper_cliente_responsables_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_cliente_responsables_id_seq OWNED BY public.oper_cliente_responsables.id;


--
-- Name: oper_clientes; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_clientes (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    tipo_persona character varying(255) NOT NULL,
    identificacion_nit character varying(50) NOT NULL,
    nombres_razon_social character varying(150) NOT NULL,
    apellidos character varying(150),
    apodo character varying(150),
    direccion character varying(200),
    telefono character varying(50),
    correo_electronico character varying(150),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    CONSTRAINT oper_clientes_tipo_persona_check CHECK (((tipo_persona)::text = ANY ((ARRAY['Natural'::character varying, 'Juridica'::character varying])::text[])))
);


ALTER TABLE public.oper_clientes OWNER TO sail;

--
-- Name: oper_clientes_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_clientes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_clientes_id_seq OWNER TO sail;

--
-- Name: oper_clientes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_clientes_id_seq OWNED BY public.oper_clientes.id;


--
-- Name: oper_conductor_capacitaciones; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_conductor_capacitaciones (
    id bigint NOT NULL,
    conductor_id bigint NOT NULL,
    tipo_curso character varying(150) NOT NULL,
    entidad_expedidora character varying(150),
    fecha_realizacion date NOT NULL,
    fecha_vencimiento date,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_conductor_capacitaciones OWNER TO sail;

--
-- Name: oper_conductor_capacitaciones_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_conductor_capacitaciones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_conductor_capacitaciones_id_seq OWNER TO sail;

--
-- Name: oper_conductor_capacitaciones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_conductor_capacitaciones_id_seq OWNED BY public.oper_conductor_capacitaciones.id;


--
-- Name: oper_conductor_documentos; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_conductor_documentos (
    id bigint NOT NULL,
    conductor_id bigint NOT NULL,
    tipo_documento character varying(255) NOT NULL,
    numero_documento character varying(255),
    entidad_expedidora character varying(255),
    fecha_expedicion date NOT NULL,
    fecha_inicio_vigencia date NOT NULL,
    fecha_vencimiento date NOT NULL,
    archivo_path character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_conductor_documentos OWNER TO sail;

--
-- Name: oper_conductor_documentos_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_conductor_documentos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_conductor_documentos_id_seq OWNER TO sail;

--
-- Name: oper_conductor_documentos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_conductor_documentos_id_seq OWNED BY public.oper_conductor_documentos.id;


--
-- Name: oper_conductor_examenes; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_conductor_examenes (
    id bigint NOT NULL,
    conductor_id bigint NOT NULL,
    nombre_examen character varying(150) NOT NULL,
    entidad character varying(150),
    fecha_realizacion date NOT NULL,
    fecha_vencimiento date,
    archivo_path character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_conductor_examenes OWNER TO sail;

--
-- Name: oper_conductor_examenes_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_conductor_examenes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_conductor_examenes_id_seq OWNER TO sail;

--
-- Name: oper_conductor_examenes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_conductor_examenes_id_seq OWNED BY public.oper_conductor_examenes.id;


--
-- Name: oper_conductor_experiencia; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_conductor_experiencia (
    id bigint NOT NULL,
    conductor_id bigint NOT NULL,
    empresa character varying(150) NOT NULL,
    cargo character varying(150) NOT NULL,
    fecha_inicio date NOT NULL,
    fecha_fin date,
    nombre_jefe_directo character varying(150),
    telefono_verificacion character varying(50),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_conductor_experiencia OWNER TO sail;

--
-- Name: oper_conductor_experiencia_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_conductor_experiencia_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_conductor_experiencia_id_seq OWNER TO sail;

--
-- Name: oper_conductor_experiencia_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_conductor_experiencia_id_seq OWNED BY public.oper_conductor_experiencia.id;


--
-- Name: oper_conductor_infracciones; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_conductor_infracciones (
    id bigint NOT NULL,
    conductor_id bigint NOT NULL,
    numero_comparendo character varying(100) NOT NULL,
    fecha_infraccion date NOT NULL,
    estado_pago character varying(50),
    valor numeric(15,2) DEFAULT '0'::numeric NOT NULL,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_conductor_infracciones OWNER TO sail;

--
-- Name: oper_conductor_infracciones_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_conductor_infracciones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_conductor_infracciones_id_seq OWNER TO sail;

--
-- Name: oper_conductor_infracciones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_conductor_infracciones_id_seq OWNED BY public.oper_conductor_infracciones.id;


--
-- Name: oper_conductor_referencias; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_conductor_referencias (
    id bigint NOT NULL,
    conductor_id bigint NOT NULL,
    tipo_referencia character varying(255) NOT NULL,
    nombre_completo character varying(150) NOT NULL,
    parentesco character varying(100),
    telefono character varying(50) NOT NULL,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    CONSTRAINT oper_conductor_referencias_tipo_referencia_check CHECK (((tipo_referencia)::text = ANY ((ARRAY['Personal'::character varying, 'Familiar'::character varying, 'Laboral'::character varying])::text[])))
);


ALTER TABLE public.oper_conductor_referencias OWNER TO sail;

--
-- Name: oper_conductor_referencias_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_conductor_referencias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_conductor_referencias_id_seq OWNER TO sail;

--
-- Name: oper_conductor_referencias_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_conductor_referencias_id_seq OWNED BY public.oper_conductor_referencias.id;


--
-- Name: oper_conductor_ssocial; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_conductor_ssocial (
    id bigint NOT NULL,
    conductor_id bigint NOT NULL,
    fecha_inicial date NOT NULL,
    fecha_final date NOT NULL,
    fecha_pago date,
    numero_planilla character varying(100) NOT NULL,
    archivo_path character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_conductor_ssocial OWNER TO sail;

--
-- Name: oper_conductor_ssocial_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_conductor_ssocial_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_conductor_ssocial_id_seq OWNER TO sail;

--
-- Name: oper_conductor_ssocial_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_conductor_ssocial_id_seq OWNED BY public.oper_conductor_ssocial.id;


--
-- Name: oper_conductor_vehiculo; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_conductor_vehiculo (
    id bigint NOT NULL,
    conductor_id bigint NOT NULL,
    vehiculo_id bigint NOT NULL,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_conductor_vehiculo OWNER TO sail;

--
-- Name: oper_conductor_vehiculo_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_conductor_vehiculo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_conductor_vehiculo_id_seq OWNER TO sail;

--
-- Name: oper_conductor_vehiculo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_conductor_vehiculo_id_seq OWNED BY public.oper_conductor_vehiculo.id;


--
-- Name: oper_conductores; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_conductores (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    user_id bigint,
    documento character varying(255) NOT NULL,
    nombres character varying(255) NOT NULL,
    apellidos character varying(255) NOT NULL,
    numero_licencia character varying(255) NOT NULL,
    vencimiento_licencia date NOT NULL,
    telefono character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    fecha_ingreso date,
    ciudad_residencia_id bigint,
    ciudad_expedicion_documento_id bigint,
    fecha_nacimiento date,
    direccion_residencia character varying(255),
    barrio character varying(255),
    celular character varying(255),
    email character varying(255),
    estado_civil character varying(255),
    hijos integer DEFAULT 0 NOT NULL,
    grupo_sanguineo character varying(255),
    eps character varying(255),
    arl character varying(255),
    fondo_pensiones character varying(255),
    nombre_contacto_emergencia character varying(255),
    telefono_contacto_emergencia character varying(255),
    fecha_expedicion_licencia date,
    categoria_licencia character varying(255),
    archivo_licencia_path character varying(255)
);


ALTER TABLE public.oper_conductores OWNER TO sail;

--
-- Name: oper_conductores_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_conductores_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_conductores_id_seq OWNER TO sail;

--
-- Name: oper_conductores_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_conductores_id_seq OWNED BY public.oper_conductores.id;


--
-- Name: oper_contratos; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_contratos (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    numero_contrato character varying(255) NOT NULL,
    objeto_contrato text NOT NULL,
    fecha_inicio date NOT NULL,
    fecha_fin date NOT NULL,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    cliente_id bigint NOT NULL,
    responsable_id bigint NOT NULL,
    recorrido_descripcion text,
    valor_contrato numeric(15,2),
    origen character varying(100),
    destino character varying(100),
    ruta text,
    plantilla_formato text
);


ALTER TABLE public.oper_contratos OWNER TO sail;

--
-- Name: oper_contratos_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_contratos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_contratos_id_seq OWNER TO sail;

--
-- Name: oper_contratos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_contratos_id_seq OWNED BY public.oper_contratos.id;


--
-- Name: oper_empresas_convenio; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_empresas_convenio (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    razon_social character varying(255) NOT NULL,
    nit character varying(255) NOT NULL,
    representante_legal character varying(255),
    documento_representante_legal character varying(255),
    telefono character varying(255),
    direccion character varying(255),
    correo_electronico character varying(255),
    fecha_inicio_convenio date,
    fecha_final_convenio date,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_empresas_convenio OWNER TO sail;

--
-- Name: oper_empresas_convenio_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_empresas_convenio_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_empresas_convenio_id_seq OWNER TO sail;

--
-- Name: oper_empresas_convenio_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_empresas_convenio_id_seq OWNED BY public.oper_empresas_convenio.id;


--
-- Name: oper_mantenimiento_registros; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_mantenimiento_registros (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    vehiculo_id bigint NOT NULL,
    rutina_id bigint,
    tipo_mantenimiento character varying(255) NOT NULL,
    fecha_servicio date NOT NULL,
    kilometraje_servicio integer NOT NULL,
    taller_nombre character varying(255),
    costo_total numeric(12,2) DEFAULT '0'::numeric NOT NULL,
    descripcion_trabajo text,
    archivo_factura_path character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    CONSTRAINT oper_mantenimiento_registros_tipo_mantenimiento_check CHECK (((tipo_mantenimiento)::text = ANY ((ARRAY['Preventivo'::character varying, 'Correctivo'::character varying])::text[])))
);


ALTER TABLE public.oper_mantenimiento_registros OWNER TO sail;

--
-- Name: oper_mantenimiento_registros_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_mantenimiento_registros_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_mantenimiento_registros_id_seq OWNER TO sail;

--
-- Name: oper_mantenimiento_registros_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_mantenimiento_registros_id_seq OWNED BY public.oper_mantenimiento_registros.id;


--
-- Name: oper_mantenimiento_rutinas; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_mantenimiento_rutinas (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    nombre_rutina character varying(255) NOT NULL,
    tipo_frecuencia character varying(255) NOT NULL,
    valor_frecuencia integer NOT NULL,
    alerta_anticipacion integer DEFAULT 500 NOT NULL,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    CONSTRAINT oper_mantenimiento_rutinas_tipo_frecuencia_check CHECK (((tipo_frecuencia)::text = ANY ((ARRAY['KM'::character varying, 'DIAS'::character varying])::text[])))
);


ALTER TABLE public.oper_mantenimiento_rutinas OWNER TO sail;

--
-- Name: oper_mantenimiento_rutinas_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_mantenimiento_rutinas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_mantenimiento_rutinas_id_seq OWNER TO sail;

--
-- Name: oper_mantenimiento_rutinas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_mantenimiento_rutinas_id_seq OWNED BY public.oper_mantenimiento_rutinas.id;


--
-- Name: oper_preoperacional_evidencias; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_preoperacional_evidencias (
    id bigint NOT NULL,
    preoperacional_id bigint NOT NULL,
    categoria_falla character varying(100) NOT NULL,
    descripcion text,
    foto_path character varying(255) NOT NULL,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_preoperacional_evidencias OWNER TO sail;

--
-- Name: oper_preoperacional_evidencias_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_preoperacional_evidencias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_preoperacional_evidencias_id_seq OWNER TO sail;

--
-- Name: oper_preoperacional_evidencias_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_preoperacional_evidencias_id_seq OWNED BY public.oper_preoperacional_evidencias.id;


--
-- Name: oper_preoperacionales; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_preoperacionales (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    conductor_id bigint NOT NULL,
    vehiculo_id bigint NOT NULL,
    plantilla_id bigint,
    kilometraje_actual integer NOT NULL,
    estado_general character varying(255) NOT NULL,
    respuestas_json jsonb NOT NULL,
    observaciones_conductor text,
    firma_digital_path character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    CONSTRAINT oper_preoperacionales_estado_general_check CHECK (((estado_general)::text = ANY ((ARRAY['Aprobado'::character varying, 'Aprobado con Observaciones'::character varying, 'Rechazado'::character varying])::text[])))
);


ALTER TABLE public.oper_preoperacionales OWNER TO sail;

--
-- Name: oper_preoperacionales_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_preoperacionales_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_preoperacionales_id_seq OWNER TO sail;

--
-- Name: oper_preoperacionales_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_preoperacionales_id_seq OWNED BY public.oper_preoperacionales.id;


--
-- Name: oper_propietarios; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_propietarios (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    user_id bigint NOT NULL,
    documento character varying(255) NOT NULL,
    nombres character varying(255) NOT NULL,
    apellidos character varying(255) NOT NULL,
    telefono character varying(255),
    banco character varying(255),
    tipo_cuenta character varying(255),
    numero_cuenta character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_propietarios OWNER TO sail;

--
-- Name: oper_propietarios_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_propietarios_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_propietarios_id_seq OWNER TO sail;

--
-- Name: oper_propietarios_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_propietarios_id_seq OWNED BY public.oper_propietarios.id;


--
-- Name: oper_vehiculo_documentos; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_vehiculo_documentos (
    id bigint NOT NULL,
    vehiculo_id bigint NOT NULL,
    tipo_documento character varying(255) NOT NULL,
    numero_documento character varying(255),
    entidad_expedidora character varying(255),
    fecha_expedicion date NOT NULL,
    fecha_inicio_vigencia date NOT NULL,
    fecha_vencimiento date NOT NULL,
    archivo_path character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_vehiculo_documentos OWNER TO sail;

--
-- Name: oper_vehiculo_documentos_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_vehiculo_documentos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_vehiculo_documentos_id_seq OWNER TO sail;

--
-- Name: oper_vehiculo_documentos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_vehiculo_documentos_id_seq OWNED BY public.oper_vehiculo_documentos.id;


--
-- Name: oper_vehiculo_polizas; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_vehiculo_polizas (
    id bigint NOT NULL,
    vehiculo_id bigint NOT NULL,
    aseguradora_id bigint NOT NULL,
    tipo_poliza character varying(255) NOT NULL,
    numero_poliza character varying(255),
    fecha_expedicion date NOT NULL,
    fecha_inicio_vigencia date NOT NULL,
    fecha_vencimiento date NOT NULL,
    dias_notificacion integer DEFAULT 30 NOT NULL,
    archivo_path character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_vehiculo_polizas OWNER TO sail;

--
-- Name: oper_vehiculo_polizas_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_vehiculo_polizas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_vehiculo_polizas_id_seq OWNER TO sail;

--
-- Name: oper_vehiculo_polizas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_vehiculo_polizas_id_seq OWNED BY public.oper_vehiculo_polizas.id;


--
-- Name: oper_vehiculo_revisiones; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_vehiculo_revisiones (
    id bigint NOT NULL,
    vehiculo_id bigint NOT NULL,
    cda_id bigint NOT NULL,
    tipo_revision character varying(255) NOT NULL,
    numero_certificado character varying(255),
    fecha_expedicion date NOT NULL,
    fecha_inicio_vigencia date NOT NULL,
    fecha_vencimiento date NOT NULL,
    dias_notificacion integer DEFAULT 5 NOT NULL,
    archivo_path character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.oper_vehiculo_revisiones OWNER TO sail;

--
-- Name: oper_vehiculo_revisiones_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_vehiculo_revisiones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_vehiculo_revisiones_id_seq OWNER TO sail;

--
-- Name: oper_vehiculo_revisiones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_vehiculo_revisiones_id_seq OWNED BY public.oper_vehiculo_revisiones.id;


--
-- Name: oper_vehiculos; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.oper_vehiculos (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    placa character varying(255) NOT NULL,
    modelo character varying(255),
    capacidad_pasajeros integer NOT NULL,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    propietario_id bigint,
    clase character varying(255),
    color character varying(255),
    cilindraje character varying(255),
    numero_motor character varying(255),
    numero_chasis character varying(255),
    numero_licencia_transito character varying(255),
    fecha_expedicion_licencia_transito date,
    fecha_matricula date,
    tipo_carroceria character varying(255),
    combustible character varying(255),
    numero_vin character varying(255),
    numero_serie character varying(255),
    origen character varying(255) DEFAULT 'Propio'::character varying NOT NULL,
    fecha_vencimiento_contrato date,
    marca_id bigint,
    linea_id bigint,
    empresa_convenio_id bigint,
    numero_interno character varying(50),
    numero_tarjeta_operacion character varying(100),
    kilometraje integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.oper_vehiculos OWNER TO sail;

--
-- Name: oper_vehiculos_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.oper_vehiculos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.oper_vehiculos_id_seq OWNER TO sail;

--
-- Name: oper_vehiculos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.oper_vehiculos_id_seq OWNED BY public.oper_vehiculos.id;


--
-- Name: param_ciudades; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.param_ciudades (
    id bigint NOT NULL,
    departamento_id bigint NOT NULL,
    nombre character varying(255) NOT NULL,
    codigo_dane character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.param_ciudades OWNER TO sail;

--
-- Name: param_ciudades_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.param_ciudades_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.param_ciudades_id_seq OWNER TO sail;

--
-- Name: param_ciudades_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.param_ciudades_id_seq OWNED BY public.param_ciudades.id;


--
-- Name: param_departamentos; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.param_departamentos (
    id bigint NOT NULL,
    nombre character varying(255) NOT NULL,
    codigo_dane character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.param_departamentos OWNER TO sail;

--
-- Name: param_departamentos_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.param_departamentos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.param_departamentos_id_seq OWNER TO sail;

--
-- Name: param_departamentos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.param_departamentos_id_seq OWNED BY public.param_departamentos.id;


--
-- Name: param_lineas; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.param_lineas (
    id bigint NOT NULL,
    marca_id bigint NOT NULL,
    nombre character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.param_lineas OWNER TO sail;

--
-- Name: param_lineas_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.param_lineas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.param_lineas_id_seq OWNER TO sail;

--
-- Name: param_lineas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.param_lineas_id_seq OWNED BY public.param_lineas.id;


--
-- Name: param_marcas; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.param_marcas (
    id bigint NOT NULL,
    nombre character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.param_marcas OWNER TO sail;

--
-- Name: param_marcas_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.param_marcas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.param_marcas_id_seq OWNER TO sail;

--
-- Name: param_marcas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.param_marcas_id_seq OWNED BY public.param_marcas.id;


--
-- Name: param_preop_plantillas; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.param_preop_plantillas (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    nombre_plantilla character varying(150) NOT NULL,
    estructura_json jsonb NOT NULL,
    es_predeterminada boolean DEFAULT false NOT NULL,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.param_preop_plantillas OWNER TO sail;

--
-- Name: param_preop_plantillas_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.param_preop_plantillas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.param_preop_plantillas_id_seq OWNER TO sail;

--
-- Name: param_preop_plantillas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.param_preop_plantillas_id_seq OWNED BY public.param_preop_plantillas.id;

--
-- Name: permissions; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.permissions (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    guard_name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.permissions OWNER TO sail;

--
-- Name: permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.permissions_id_seq OWNER TO sail;

--
-- Name: permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.permissions_id_seq OWNED BY public.permissions.id;

--
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.personal_access_tokens_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.personal_access_tokens_id_seq OWNER TO sail;

--
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.personal_access_tokens_id_seq OWNED BY public.personal_access_tokens.id;


--
-- Name: reg_fuecs; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.reg_fuecs (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    vehiculo_id bigint NOT NULL,
    conductor_id bigint NOT NULL,
    contrato_id bigint NOT NULL,
    numero_fuec character varying(255) NOT NULL,
    origen character varying(255) NOT NULL,
    destino character varying(255) NOT NULL,
    fecha_inicio_viaje date NOT NULL,
    fecha_fin_viaje date NOT NULL,
    estado character varying(255) DEFAULT 'ACTIVO'::character varying NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    consecutivo_anual integer,
    resolucion_snapshot character varying(255),
    datos_snapshot jsonb,
    qr_verificacion_hash character varying(255),
    conductor2_id bigint,
    conductor3_id bigint,
    CONSTRAINT reg_fuecs_estado_check CHECK (((estado)::text = ANY ((ARRAY['ACTIVO'::character varying, 'VENCIDO'::character varying, 'ANULADO'::character varying])::text[])))
);


ALTER TABLE public.reg_fuecs OWNER TO sail;

--
-- Name: reg_fuecs_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.reg_fuecs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.reg_fuecs_id_seq OWNER TO sail;

--
-- Name: reg_fuecs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.reg_fuecs_id_seq OWNED BY public.reg_fuecs.id;


--
-- Name: role_has_permissions; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.role_has_permissions (
    permission_id bigint NOT NULL,
    role_id bigint NOT NULL
);


ALTER TABLE public.role_has_permissions OWNER TO sail;

--
-- Name: roles; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.roles (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    guard_name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.roles OWNER TO sail;

--
-- Name: roles_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.roles_id_seq OWNER TO sail;

--
-- Name: roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.roles_id_seq OWNED BY public.roles.id;

--
-- Name: saas_empresas_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.saas_empresas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.saas_empresas_id_seq OWNER TO sail;

--
-- Name: saas_empresas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.saas_empresas_id_seq OWNED BY public.saas_empresas.id;


--
-- Name: saas_features; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.saas_features (
    id bigint NOT NULL,
    empresa_id bigint NOT NULL,
    feature_name character varying(255) NOT NULL,
    is_enabled boolean DEFAULT false NOT NULL,
    config_json json,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.saas_features OWNER TO sail;

--
-- Name: saas_features_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.saas_features_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.saas_features_id_seq OWNER TO sail;

--
-- Name: saas_features_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.saas_features_id_seq OWNED BY public.saas_features.id;


--
-- Name: sessions; Type: TABLE; Schema: public; Owner: sail
--

CREATE TABLE public.sessions (
    id character varying(255) NOT NULL,
    user_id bigint,
    ip_address character varying(45),
    user_agent text,
    payload text NOT NULL,
    last_activity integer NOT NULL
);


ALTER TABLE public.sessions OWNER TO sail;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: sail
--

CREATE SEQUENCE public.users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.users_id_seq OWNER TO sail;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sail
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- Name: audit_events id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.audit_events ALTER COLUMN id SET DEFAULT nextval('public.audit_events_id_seq'::regclass);


--
-- Name: failed_jobs id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.failed_jobs ALTER COLUMN id SET DEFAULT nextval('public.failed_jobs_id_seq'::regclass);


--
-- Name: jobs id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass);


--
-- Name: migrations id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.migrations ALTER COLUMN id SET DEFAULT nextval('public.migrations_id_seq'::regclass);


--
-- Name: oper_aseguradoras id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_aseguradoras ALTER COLUMN id SET DEFAULT nextval('public.oper_aseguradoras_id_seq'::regclass);


--
-- Name: oper_cdas id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_cdas ALTER COLUMN id SET DEFAULT nextval('public.oper_cdas_id_seq'::regclass);


--
-- Name: oper_cliente_responsables id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_cliente_responsables ALTER COLUMN id SET DEFAULT nextval('public.oper_cliente_responsables_id_seq'::regclass);


--
-- Name: oper_clientes id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_clientes ALTER COLUMN id SET DEFAULT nextval('public.oper_clientes_id_seq'::regclass);


--
-- Name: oper_conductor_capacitaciones id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_capacitaciones ALTER COLUMN id SET DEFAULT nextval('public.oper_conductor_capacitaciones_id_seq'::regclass);


--
-- Name: oper_conductor_documentos id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_documentos ALTER COLUMN id SET DEFAULT nextval('public.oper_conductor_documentos_id_seq'::regclass);


--
-- Name: oper_conductor_examenes id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_examenes ALTER COLUMN id SET DEFAULT nextval('public.oper_conductor_examenes_id_seq'::regclass);


--
-- Name: oper_conductor_experiencia id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_experiencia ALTER COLUMN id SET DEFAULT nextval('public.oper_conductor_experiencia_id_seq'::regclass);


--
-- Name: oper_conductor_infracciones id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_infracciones ALTER COLUMN id SET DEFAULT nextval('public.oper_conductor_infracciones_id_seq'::regclass);


--
-- Name: oper_conductor_referencias id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_referencias ALTER COLUMN id SET DEFAULT nextval('public.oper_conductor_referencias_id_seq'::regclass);


--
-- Name: oper_conductor_ssocial id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_ssocial ALTER COLUMN id SET DEFAULT nextval('public.oper_conductor_ssocial_id_seq'::regclass);


--
-- Name: oper_conductor_vehiculo id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_vehiculo ALTER COLUMN id SET DEFAULT nextval('public.oper_conductor_vehiculo_id_seq'::regclass);


--
-- Name: oper_conductores id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductores ALTER COLUMN id SET DEFAULT nextval('public.oper_conductores_id_seq'::regclass);


--
-- Name: oper_contratos id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_contratos ALTER COLUMN id SET DEFAULT nextval('public.oper_contratos_id_seq'::regclass);


--
-- Name: oper_empresas_convenio id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_empresas_convenio ALTER COLUMN id SET DEFAULT nextval('public.oper_empresas_convenio_id_seq'::regclass);


--
-- Name: oper_mantenimiento_registros id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_mantenimiento_registros ALTER COLUMN id SET DEFAULT nextval('public.oper_mantenimiento_registros_id_seq'::regclass);


--
-- Name: oper_mantenimiento_rutinas id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_mantenimiento_rutinas ALTER COLUMN id SET DEFAULT nextval('public.oper_mantenimiento_rutinas_id_seq'::regclass);


--
-- Name: oper_preoperacional_evidencias id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_preoperacional_evidencias ALTER COLUMN id SET DEFAULT nextval('public.oper_preoperacional_evidencias_id_seq'::regclass);


--
-- Name: oper_preoperacionales id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_preoperacionales ALTER COLUMN id SET DEFAULT nextval('public.oper_preoperacionales_id_seq'::regclass);


--
-- Name: oper_propietarios id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_propietarios ALTER COLUMN id SET DEFAULT nextval('public.oper_propietarios_id_seq'::regclass);


--
-- Name: oper_vehiculo_documentos id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_documentos ALTER COLUMN id SET DEFAULT nextval('public.oper_vehiculo_documentos_id_seq'::regclass);


--
-- Name: oper_vehiculo_polizas id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_polizas ALTER COLUMN id SET DEFAULT nextval('public.oper_vehiculo_polizas_id_seq'::regclass);


--
-- Name: oper_vehiculo_revisiones id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_revisiones ALTER COLUMN id SET DEFAULT nextval('public.oper_vehiculo_revisiones_id_seq'::regclass);


--
-- Name: oper_vehiculos id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculos ALTER COLUMN id SET DEFAULT nextval('public.oper_vehiculos_id_seq'::regclass);


--
-- Name: param_ciudades id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_ciudades ALTER COLUMN id SET DEFAULT nextval('public.param_ciudades_id_seq'::regclass);


--
-- Name: param_departamentos id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_departamentos ALTER COLUMN id SET DEFAULT nextval('public.param_departamentos_id_seq'::regclass);


--
-- Name: param_lineas id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_lineas ALTER COLUMN id SET DEFAULT nextval('public.param_lineas_id_seq'::regclass);


--
-- Name: param_marcas id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_marcas ALTER COLUMN id SET DEFAULT nextval('public.param_marcas_id_seq'::regclass);


--
-- Name: param_preop_plantillas id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_preop_plantillas ALTER COLUMN id SET DEFAULT nextval('public.param_preop_plantillas_id_seq'::regclass);


--
-- Name: permissions id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.permissions ALTER COLUMN id SET DEFAULT nextval('public.permissions_id_seq'::regclass);


--
-- Name: reg_fuecs id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.reg_fuecs ALTER COLUMN id SET DEFAULT nextval('public.reg_fuecs_id_seq'::regclass);


--
-- Name: roles id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.roles ALTER COLUMN id SET DEFAULT nextval('public.roles_id_seq'::regclass);


--
-- Name: saas_features id; Type: DEFAULT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.saas_features ALTER COLUMN id SET DEFAULT nextval('public.saas_features_id_seq'::regclass);


--
-- Data for Name: audit_events; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.audit_events (id, empresa_id, user_id, event_type, entity_type, entity_id, old_values, new_values, ip_address, user_agent, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin;
\.


--
-- Data for Name: job_batches; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.job_batches (id, name, total_jobs, pending_jobs, failed_jobs, failed_job_ids, options, cancelled_at, created_at, finished_at) FROM stdin;
\.


--
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.jobs (id, queue, payload, attempts, reserved_at, available_at, created_at) FROM stdin;
\.


--
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.migrations (id, migration, batch) FROM stdin;
1	0001_01_01_000000_create_users_table	1
2	0001_01_01_000001_create_cache_table	1
3	0001_01_01_000002_create_jobs_table	1
4	2026_03_31_183629_create_personal_access_tokens_table	1
5	2026_03_31_184904_create_permission_tables	1
6	2026_03_31_185103_create_saas_empresas_table	1
7	2026_03_31_185108_create_saas_features_table	1
8	2026_03_31_185115_add_empresa_id_to_users_table	1
9	2026_03_31_185121_create_oper_vehiculos_table	1
10	2026_03_31_185128_create_oper_conductores_table	1
11	2026_03_31_185140_create_oper_contratos_table	1
12	2026_03_31_185146_create_reg_fuecs_table	1
13	2026_03_31_185152_create_audit_events_table	1
14	2026_04_01_020156_create_oper_propietarios_table	1
15	2026_04_01_020204_create_oper_vehiculo_documentos_table	1
16	2026_04_01_020216_create_oper_conductor_documentos_table	1
17	2026_04_01_020221_alter_oper_vehiculos_schema	1
18	2026_04_01_023748_create_param_departamentos_table	1
19	2026_04_01_023757_create_param_ciudades_table	1
20	2026_04_01_023804_create_param_marcas_table	1
21	2026_04_01_023811_create_param_lineas_table	1
22	2026_04_01_023926_alter_oper_vehiculos_phase12	1
23	2026_04_01_023936_alter_oper_conductores_phase12	1
24	2026_04_01_025123_create_oper_empresas_convenio_table	1
25	2026_04_01_025130_alter_oper_vehiculos_add_convenio_id	1
26	2026_04_01_044443_create_oper_aseguradoras_table	1
27	2026_04_01_044450_create_oper_cdas_table	1
28	2026_04_01_044459_create_oper_vehiculo_polizas_table	1
29	2026_04_01_044507_create_oper_vehiculo_revisiones_table	1
30	2026_04_01_051331_create_oper_clientes_table	1
31	2026_04_01_051340_create_oper_cliente_responsables_table	1
32	2026_04_01_051421_alter_oper_contratos_cliente_relacional	1
33	2026_04_01_140608_create_oper_conductor_examenes_table	1
34	2026_04_01_140617_create_oper_conductor_ssocial_table	1
35	2026_04_01_140627_create_oper_conductor_vehiculo_table	1
36	2026_04_01_140637_create_oper_conductor_experiencia_table	1
37	2026_04_01_140646_create_oper_conductor_referencias_table	1
38	2026_04_01_140701_create_oper_conductor_capacitaciones_table	1
39	2026_04_01_140730_create_oper_conductor_infracciones_table	1
40	2026_04_01_142100_create_param_preop_plantillas_table	1
41	2026_04_01_142200_create_oper_preoperacionales_table	1
42	2026_04_01_142223_create_oper_preoperacional_evidencias_table	1
43	2026_04_01_150255_alter_saas_empresas_branding_cfg	1
44	2026_04_01_150302_alter_reg_fuecs_snapshot_legal	1
45	2026_04_07_184836_add_fields_to_oper_contratos_table	2
46	2026_04_07_190000_add_fields_to_oper_contratos_table	2
47	2026_04_07_192031_add_direccion_to_oper_cliente_responsables_table	3
48	2026_04_07_192040_add_direccion_to_oper_cliente_responsables_table	3
49	2026_04_07_192200_add_direccion_to_oper_cliente_responsables_table	3
50	2026_04_07_193539_add_numero_interno_to_oper_vehiculos_table	4
51	2026_04_07_193600_add_numero_interno_to_oper_vehiculos_table	4
53	2026_04_07_201000_add_tarjeta_operacion_to_oper_vehiculos_table	5
54	2026_04_08_160802_add_multiple_conductores_to_reg_fuecs_table	5
55	2026_04_08_194913_add_route_and_template_to_oper_contratos_table	6
56	2026_04_09_163951_create_oper_mantenimiento_rutinas_table	7
57	2026_04_09_164049_create_oper_mantenimiento_registros_table	7
58	2026_04_09_173553_add_kilometraje_to_oper_vehiculos_table	8
59	2026_04_09_190521_add_fav_ia_settings_to_saas_empresas_table	9
60	2026_04_09_194327_add_billing_credentials_to_saas_empresas_table	10
61	2026_04_10_193400_add_entity_ids_to_users_table	11
62	2026_04_15_000001_add_performance_indexes	12
\.


--
-- Data for Name: model_has_permissions; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.model_has_permissions (permission_id, model_type, model_id) FROM stdin;
\.


--
-- Data for Name: model_has_roles; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.model_has_roles (role_id, model_type, model_id) FROM stdin;
1	App\\Models\\User	1
2	App\\Models\\User	1
\.


--
-- Data for Name: oper_aseguradoras; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_aseguradoras (id, empresa_id, nombre_aseguradora, nit, telefono, is_active, created_at, updated_at, deleted_at) FROM stdin;
7	1	Seguros Bolivar	860.111.222	\N	t	\N	\N	\N
\.


--
-- Data for Name: oper_cdas; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_cdas (id, empresa_id, nombre_cda, nit, direccion, telefono, is_active, created_at, updated_at, deleted_at) FROM stdin;
6	1	CDA La 80	900.555.444	\N	\N	t	\N	\N	\N
\.


--
-- Data for Name: oper_cliente_responsables; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_cliente_responsables (id, cliente_id, identificacion, nombres, apellidos, cargo, telefono, correo_electronico, is_active, created_at, updated_at, deleted_at, direccion) FROM stdin;
16	28	\N	Responsable Colegio San Jose	\N	\N	\N	\N	t	2026-04-09 20:55:54	\N	\N	\N
17	29	\N	Responsable Ecopetrol S.A.	\N	\N	\N	\N	t	2026-04-09 20:55:54	\N	\N	\N
\.


--
-- Data for Name: oper_clientes; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_clientes (id, empresa_id, tipo_persona, identificacion_nit, nombres_razon_social, apellidos, apodo, direccion, telefono, correo_electronico, is_active, created_at, updated_at, deleted_at) FROM stdin;
28	1	Juridica	800.111.111-1	Colegio San Jose	\N	\N	\N	\N	\N	t	2026-04-09 20:55:54	\N	\N
29	1	Juridica	800.222.222-2	Ecopetrol S.A.	\N	\N	\N	\N	\N	t	2026-04-09 20:55:54	\N	\N
\.


--
-- Data for Name: oper_conductor_capacitaciones; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_conductor_capacitaciones (id, conductor_id, tipo_curso, entidad_expedidora, fecha_realizacion, fecha_vencimiento, is_active, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: oper_conductor_documentos; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_conductor_documentos (id, conductor_id, tipo_documento, numero_documento, entidad_expedidora, fecha_expedicion, fecha_inicio_vigencia, fecha_vencimiento, archivo_path, is_active, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: oper_conductor_examenes; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_conductor_examenes (id, conductor_id, nombre_examen, entidad, fecha_realizacion, fecha_vencimiento, archivo_path, is_active, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: oper_conductor_experiencia; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_conductor_experiencia (id, conductor_id, empresa, cargo, fecha_inicio, fecha_fin, nombre_jefe_directo, telefono_verificacion, is_active, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: oper_conductor_infracciones; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_conductor_infracciones (id, conductor_id, numero_comparendo, fecha_infraccion, estado_pago, valor, is_active, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: oper_conductor_referencias; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_conductor_referencias (id, conductor_id, tipo_referencia, nombre_completo, parentesco, telefono, is_active, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: oper_conductor_ssocial; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_conductor_ssocial (id, conductor_id, fecha_inicial, fecha_final, fecha_pago, numero_planilla, archivo_path, is_active, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: oper_conductor_vehiculo; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_conductor_vehiculo (id, conductor_id, vehiculo_id, is_active, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: oper_conductores; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_conductores (id, empresa_id, user_id, documento, nombres, apellidos, numero_licencia, vencimiento_licencia, telefono, is_active, created_at, updated_at, deleted_at, fecha_ingreso, ciudad_residencia_id, ciudad_expedicion_documento_id, fecha_nacimiento, direccion_residencia, barrio, celular, email, estado_civil, hijos, grupo_sanguineo, eps, arl, fondo_pensiones, nombre_contacto_emergencia, telefono_contacto_emergencia, fecha_expedicion_licencia, categoria_licencia, archivo_licencia_path) FROM stdin;
31	1	\N	10203040	Carlos	Perez	LC-555	2028-04-09	\N	t	2026-04-09 20:55:54	\N	\N	\N	13	13	\N	\N	\N	\N	\N	\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N
\.


--
-- Data for Name: oper_contratos; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_contratos (id, empresa_id, numero_contrato, objeto_contrato, fecha_inicio, fecha_fin, is_active, created_at, updated_at, deleted_at, cliente_id, responsable_id, recorrido_descripcion, valor_contrato, origen, destino, ruta, plantilla_formato) FROM stdin;
9	1	CONTR-2024	Transporte Escolar	2026-04-09	2027-04-09	t	\N	\N	\N	28	16	\N	\N	\N	\N	\N	\N
\.


--
-- Data for Name: oper_empresas_convenio; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_empresas_convenio (id, empresa_id, razon_social, nit, representante_legal, documento_representante_legal, telefono, direccion, correo_electronico, fecha_inicio_convenio, fecha_final_convenio, is_active, created_at, updated_at, deleted_at) FROM stdin;
1	1	Transportes ABC	9000000000	Juan Perez	5646456	3168547825	por ahi	abc@sireco.com	2026-04-01	2029-10-08	t	2026-04-08 19:13:04	2026-04-08 19:13:04	\N
\.


--
-- Data for Name: oper_mantenimiento_registros; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_mantenimiento_registros (id, empresa_id, vehiculo_id, rutina_id, tipo_mantenimiento, fecha_servicio, kilometraje_servicio, taller_nombre, costo_total, descripcion_trabajo, archivo_factura_path, is_active, created_at, updated_at, deleted_at) FROM stdin;
65	1	35	18	Preventivo	2026-02-09	41200	\N	250000.00	\N	\N	t	2026-04-09 20:55:54	\N	\N
\.


--
-- Data for Name: oper_mantenimiento_rutinas; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_mantenimiento_rutinas (id, empresa_id, nombre_rutina, tipo_frecuencia, valor_frecuencia, alerta_anticipacion, is_active, created_at, updated_at, deleted_at) FROM stdin;
18	1	Cambio de Aceite	KM	5000	500	t	2026-04-09 20:55:54	\N	\N
\.


--
-- Data for Name: oper_preoperacional_evidencias; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_preoperacional_evidencias (id, preoperacional_id, categoria_falla, descripcion, foto_path, is_active, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: oper_preoperacionales; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_preoperacionales (id, empresa_id, conductor_id, vehiculo_id, plantilla_id, kilometraje_actual, estado_general, respuestas_json, observaciones_conductor, firma_digital_path, is_active, created_at, updated_at, deleted_at) FROM stdin;
162	1	31	35	\N	45800	Rechazado	{"Luces": "CUMPLE", "Frenos": "NO CUMPLE"}	\N	\N	t	2026-04-06 20:55:54	\N	\N
163	1	31	35	\N	45800	Rechazado	{"Luces": "CUMPLE", "Frenos": "NO CUMPLE"}	\N	\N	t	2026-04-07 20:55:54	\N	\N
164	1	31	35	\N	45800	Rechazado	{"Luces": "CUMPLE", "Frenos": "NO CUMPLE"}	\N	\N	t	2026-04-08 20:55:54	\N	\N
\.


--
-- Data for Name: oper_propietarios; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_propietarios (id, empresa_id, user_id, documento, nombres, apellidos, telefono, banco, tipo_cuenta, numero_cuenta, is_active, created_at, updated_at, deleted_at) FROM stdin;
1	1	2	123456789	Juan	P├®rez (Propietario)	\N	Bancolombia	\N	0000111122	t	2026-04-01 15:13:47	2026-04-01 15:13:47	\N
\.


--
-- Data for Name: oper_vehiculo_documentos; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_vehiculo_documentos (id, vehiculo_id, tipo_documento, numero_documento, entidad_expedidora, fecha_expedicion, fecha_inicio_vigencia, fecha_vencimiento, archivo_path, is_active, created_at, updated_at, deleted_at) FROM stdin;
11	35	TARJETA_OPERACION	9898	aaaa	2026-04-14	2026-04-14	2026-06-12	sireco-app/empresas/1/vehiculos/35/documentos/ac40325e-65ea-46d7-ac8b-06192337029f.pdf	t	2026-04-15 15:03:48	2026-04-15 15:03:48	\N
\.


--
-- Data for Name: oper_vehiculo_polizas; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_vehiculo_polizas (id, vehiculo_id, aseguradora_id, tipo_poliza, numero_poliza, fecha_expedicion, fecha_inicio_vigencia, fecha_vencimiento, dias_notificacion, archivo_path, is_active, created_at, updated_at, deleted_at) FROM stdin;
21	36	7	SOAT	POL-ABC-456	2025-04-09	2025-04-09	2026-10-26	30	\N	t	2026-04-09 20:55:54	\N	\N
20	35	7	SOAT	POL-SXM-123	2025-04-09	2025-04-09	2026-04-12	30	\N	f	2026-04-09 20:55:54	\N	\N
22	35	7	SOAT	14858	2026-04-14	2026-04-14	2026-05-28	30	sireco-app/empresas/1/vehiculos/35/polizas/c39ee9ae-dbd6-4a8a-aeca-9cf784c3533c.pdf	t	2026-04-15 15:01:09	2026-04-15 15:01:09	\N
\.


--
-- Data for Name: oper_vehiculo_revisiones; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_vehiculo_revisiones (id, vehiculo_id, cda_id, tipo_revision, numero_certificado, fecha_expedicion, fecha_inicio_vigencia, fecha_vencimiento, dias_notificacion, archivo_path, is_active, created_at, updated_at, deleted_at) FROM stdin;
12	35	6	RTM	CERT-SXM-123	2025-04-09	2025-04-09	2026-10-26	5	\N	t	2026-04-09 20:55:54	\N	\N
13	36	6	RTM	CERT-ABC-456	2025-04-09	2025-04-09	2026-04-13	5	\N	t	2026-04-09 20:55:54	\N	\N
\.


--
-- Data for Name: oper_vehiculos; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.oper_vehiculos (id, empresa_id, placa, modelo, capacidad_pasajeros, is_active, created_at, updated_at, deleted_at, propietario_id, clase, color, cilindraje, numero_motor, numero_chasis, numero_licencia_transito, fecha_expedicion_licencia_transito, fecha_matricula, tipo_carroceria, combustible, numero_vin, numero_serie, origen, fecha_vencimiento_contrato, marca_id, linea_id, empresa_convenio_id, numero_interno, numero_tarjeta_operacion, kilometraje) FROM stdin;
35	1	SXM-123	2022	12	t	2026-04-09 20:55:54	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Propio	\N	53	52	\N	\N	\N	45800
36	1	ABC-456	2023	4	t	2026-04-09 20:55:54	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Propio	\N	54	53	\N	\N	\N	12500
37	1	ABC123	\N	4	t	2026-04-14 18:48:09	2026-04-14 18:48:09	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	Propio	\N	\N	\N	\N	\N	\N	0
\.


--
-- Data for Name: param_ciudades; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.param_ciudades (id, departamento_id, nombre, codigo_dane, created_at, updated_at) FROM stdin;
13	13	MEDELLIN	05001	2026-04-09 20:55:54	\N
\.


--
-- Data for Name: param_departamentos; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.param_departamentos (id, nombre, codigo_dane, created_at, updated_at) FROM stdin;
13	ANTIOQUIA	05	2026-04-09 20:55:54	\N
\.


--
-- Data for Name: param_lineas; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.param_lineas (id, marca_id, nombre, created_at, updated_at) FROM stdin;
52	53	NPR	2026-04-09 20:55:54	\N
53	54	F-150	2026-04-09 20:55:54	\N
54	55	SPRINTER	2026-04-09 20:55:54	\N
55	56	HILUX	2026-04-09 20:55:54	\N
56	57	URVAN	2026-04-09 20:55:54	\N
\.


--
-- Data for Name: param_marcas; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.param_marcas (id, nombre, created_at, updated_at) FROM stdin;
53	CHEVROLET	2026-04-09 20:55:54	\N
54	FORD	2026-04-09 20:55:54	\N
55	MERCEDES BENZ	2026-04-09 20:55:54	\N
56	TOYOTA	2026-04-09 20:55:54	\N
57	NISSAN	2026-04-09 20:55:54	\N
\.


--
-- Data for Name: param_preop_plantillas; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.param_preop_plantillas (id, empresa_id, nombre_plantilla, estructura_json, es_predeterminada, is_active, created_at, updated_at, deleted_at) FROM stdin;
1	1	Nueva Plantilla PESV	{"categorias": [{"id": "1", "items": [{"id": "i1", "texto": "Estado general del veh├¡culo", "exigir_foto": false}, {"id": "1775747195182", "texto": "Luces", "exigir_foto": false}, {"id": "1775747205897", "texto": "Frenos", "exigir_foto": false}, {"id": "1775747213844", "texto": "Llantas", "exigir_foto": false}], "nombre": "Inspecci├│n General"}]}	f	t	2026-04-09 15:07:47	2026-04-09 15:07:47	\N
2	1	Plantilla general	{"categorias": [{"id": "cat1", "items": [{"id": "i1", "texto": "Luces delanteras y traseras", "exigir_foto": false}, {"id": "i2", "texto": "Vidrio panor├ímico sin fisuras", "exigir_foto": true}], "nombre": "Luces y Vidrios"}, {"id": "cat2", "items": [{"id": "i3", "texto": "Nivel de aceite motor", "exigir_foto": false}, {"id": "i4", "texto": "Nivel de l├¡quido refrigerante", "exigir_foto": false}], "nombre": "Niveles de Fluidos"}]}	t	t	2026-04-09 16:21:41	2026-04-09 16:21:41	\N
\.


--
-- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.permissions (id, name, guard_name, created_at, updated_at) FROM stdin;
1	vehiculos.ver	web	2026-04-10 19:38:19	2026-04-10 19:38:19
2	vehiculos.crear	web	2026-04-10 19:38:19	2026-04-10 19:38:19
3	vehiculos.editar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
4	vehiculos.eliminar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
5	vehiculos.documentos	web	2026-04-10 19:38:19	2026-04-10 19:38:19
6	conductores.ver	web	2026-04-10 19:38:19	2026-04-10 19:38:19
7	conductores.crear	web	2026-04-10 19:38:19	2026-04-10 19:38:19
8	conductores.editar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
9	conductores.eliminar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
10	conductores.examenes	web	2026-04-10 19:38:19	2026-04-10 19:38:19
11	conductores.ssocial	web	2026-04-10 19:38:19	2026-04-10 19:38:19
12	propietarios.ver	web	2026-04-10 19:38:19	2026-04-10 19:38:19
13	propietarios.crear	web	2026-04-10 19:38:19	2026-04-10 19:38:19
14	propietarios.editar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
15	propietarios.eliminar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
16	clientes.ver	web	2026-04-10 19:38:19	2026-04-10 19:38:19
17	clientes.crear	web	2026-04-10 19:38:19	2026-04-10 19:38:19
18	clientes.editar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
19	clientes.eliminar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
20	contratos.ver	web	2026-04-10 19:38:19	2026-04-10 19:38:19
21	contratos.crear	web	2026-04-10 19:38:19	2026-04-10 19:38:19
22	contratos.editar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
23	contratos.eliminar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
24	convenios.ver	web	2026-04-10 19:38:19	2026-04-10 19:38:19
25	convenios.crear	web	2026-04-10 19:38:19	2026-04-10 19:38:19
26	convenios.editar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
27	convenios.eliminar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
28	fuec.ver	web	2026-04-10 19:38:19	2026-04-10 19:38:19
29	fuec.emitir	web	2026-04-10 19:38:19	2026-04-10 19:38:19
30	fuec.anular	web	2026-04-10 19:38:19	2026-04-10 19:38:19
31	fuec.descargar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
32	preoperacional.ver	web	2026-04-10 19:38:19	2026-04-10 19:38:19
33	preoperacional.realizar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
34	preoperacional.analitica	web	2026-04-10 19:38:19	2026-04-10 19:38:19
35	mantenimiento.ver	web	2026-04-10 19:38:19	2026-04-10 19:38:19
36	mantenimiento.registrar	web	2026-04-10 19:38:19	2026-04-10 19:38:19
37	mantenimiento.rutinas	web	2026-04-10 19:38:19	2026-04-10 19:38:19
38	reportes.gerencial	web	2026-04-10 19:38:19	2026-04-10 19:38:19
39	reportes.operativo	web	2026-04-10 19:38:19	2026-04-10 19:38:19
40	reportes.predictivo	web	2026-04-10 19:38:19	2026-04-10 19:38:19
41	configuracion.usuarios	web	2026-04-10 19:38:19	2026-04-10 19:38:19
42	configuracion.roles	web	2026-04-10 19:38:19	2026-04-10 19:38:19
43	configuracion.empresa	web	2026-04-10 19:38:19	2026-04-10 19:38:19
44	mobile.conductor	web	2026-04-10 19:38:19	2026-04-10 19:38:19
45	mobile.propietario	web	2026-04-10 19:38:19	2026-04-10 19:38:19
\.


--
-- Data for Name: reg_fuecs; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.reg_fuecs (id, empresa_id, vehiculo_id, conductor_id, contrato_id, numero_fuec, origen, destino, fecha_inicio_viaje, fecha_fin_viaje, estado, created_at, updated_at, deleted_at, consecutivo_anual, resolucion_snapshot, datos_snapshot, qr_verificacion_hash, conductor2_id, conductor3_id) FROM stdin;
42	1	35	31	9	FUEC-T-001	BASE	DESTINO	2026-04-09	2026-04-14	ANULADO	2026-04-09 20:55:54	2026-04-15 02:05:15	\N	\N	\N	\N	\N	\N	\N
\.


--
-- Data for Name: role_has_permissions; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.role_has_permissions (permission_id, role_id) FROM stdin;
1	2
2	2
3	2
4	2
5	2
6	2
7	2
8	2
9	2
10	2
11	2
12	2
13	2
14	2
15	2
16	2
17	2
18	2
19	2
20	2
21	2
22	2
23	2
24	2
25	2
26	2
27	2
28	2
29	2
30	2
31	2
32	2
33	2
34	2
35	2
36	2
37	2
38	2
39	2
40	2
41	2
42	2
43	2
44	2
45	2
1	4
6	4
12	4
16	4
20	4
24	4
28	4
38	4
1	5
3	5
6	5
8	5
28	5
29	5
31	5
35	5
32	5
1	6
6	6
12	6
16	6
20	6
24	6
28	6
39	6
32	6
33	7
44	7
1	8
29	8
31	8
45	8
\.


--
-- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.roles (id, name, guard_name, created_at, updated_at) FROM stdin;
1	Super Admin	admin	2026-04-01 15:07:06	2026-04-01 15:07:06
2	Administrador Empresa	web	2026-04-01 15:07:06	2026-04-01 15:07:06
3	Conductor	mobile	2026-04-01 15:07:06	2026-04-01 15:07:06
4	Gerencia	web	2026-04-10 19:38:20	2026-04-10 19:38:20
5	Operador de Ruta	web	2026-04-10 19:38:20	2026-04-10 19:38:20
6	Auditor	web	2026-04-10 19:38:20	2026-04-10 19:38:20
7	Conductor	web	2026-04-10 19:38:20	2026-04-10 19:38:20
8	Propietario	web	2026-04-10 19:38:20	2026-04-10 19:38:20
9	Super Admin	web	2026-04-10 19:38:20	2026-04-10 19:38:20
\.


--
-- Data for Name: saas_features; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.saas_features (id, empresa_id, feature_name, is_enabled, config_json, created_at, updated_at) FROM stdin;
1	1	fav_ia_llm	t	\N	2026-04-14 18:48:08	2026-04-14 18:48:08
\.


--
-- Data for Name: sessions; Type: TABLE DATA; Schema: public; Owner: sail
--

COPY public.sessions (id, user_id, ip_address, user_agent, payload, last_activity) FROM stdin;
KGcA7JIAu6a7rSdv11lWf3eS5C7mGlWl0HeUOgkU	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoiV3hwWk1QOXJpOWpzdW1PMm5rb2VFWDBhcEttTmNUMjBWUXVYa0d5NSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775056362
SsleXMPD7NOiu5CzszFGfbXchOSDpIv5fomCqS9H	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoibzZkU0llUDN2cFlWa0VDWmloa2lha0V6VzQ0Q1h6UTRLM0gzamhrNCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775056370
6zVUReeQTflaVj2kNi1g68w8xqwRgaIFF1fc5Ufp	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoiWERmWHplTDN2RkNXSTdQeXhzTFRwbjRDcmtrVnBjN21yeUlEcEY1QSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775142767
eSadPwaz3HWHU2eughYlXaSZh8v2y3mCWfMheL7Y	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoiMzlWMEdnbGV2NVhyMHpNdnd0dFNkcG84aUhtd1VnaDd4M2FTZEZ1RiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775142773
3F60BCO8nsS7QwdlMojwqObdUjjzzeXmlsCq6AFv	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoiT2l2WEJYUlJDTU5ESDA1RmRGQlRpVFhaUUVPSlBXY0pRcTlqNlJJZSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775158058
5yCZDeybZXXiplT0avb09o0EZc9Iq7hkWejAHPRk	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoic0Z2NTJwRmFuVGRFeVJyNGhOWU5Jd0xta2NpOW42TXdzWnJEbVZWViI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775158061
uGZrODLJRR0Xg7XN6zm7eqVTPSYf4oKYK2J61npX	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoiaHE0Yko4OTJGRnRaWnI0Q3R4Q1JXQUg5Y3JrOHBRZUlBNG5FYWdhNiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775183501
Dxm9Zk97529PQ0PX8LL2ikviVwXs04obruPJJDUi	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoicnhOTEIzR0MyZktQam1vZXpYNmkxT2E1S1Ryazg3UEFyYUxQMkJZTiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775183508
R4QuXf5qqPUssUR4GZi4q4fBhnhFk4GULrV0qffY	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoiMU1SdHJsR0dQZ244WWVvRXZmbFdIMVNKT1V6T3NKbU5KYzgzY2lidSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775316322
pQcmpsqYoRpKz21yKtu5OEIwhFBqY0F4aIRjgOQe	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoidllmQWtnQTU0NDRzbVBKaEZkQ1dpTmtRdjN2Yndha0dSd0FaT1pSUyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775316328
OqGnRE62JT0hfKny8M6W117FJBINmauE9r2bqESM	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoibWE5NW5IcXp4T3ZBM0phTGZxa1g2QmFPRWhMcWtYOXBYS0NGVmozZSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775329865
UOugxkd58CCtk1x5WvcxwAxKrwUZopelu6WvTbsd	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoiMlR4UmFQNUE4UHVCdEp4VVZGcUtDREpjdmd4WkFxVnh0UENmM3BGNiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775329869
eujV8ClGTQDqhXM6UmmocpCNbxkKz9gf2xcuDtou	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoicWE5dUhtRWk2SVdWSHVuRUVZRG1GWmt4bFJzQkNXZThBOFp1b2UzMCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775509701
luKcIVB7PPJSPvI4KGvCqxczCTTovty2yZHnzuu9	\N	172.18.0.1	Avast Antivirus	YTozOntzOjY6Il90b2tlbiI7czo0MDoiUDRFbVhOcmFCRjlwckQ3d3diQUtKaDBtczViNnVwMUNHSnRXN2ptSyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly8xNzIuMjguMzIuMSI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1775509707
WOxKK6lyOKIePeI3opjsm90neRRbaYWxminQAuN9	\N	172.18.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36	YTozOntzOjY6Il90b2tlbiI7czo0MDoidUVxN0t1enc1eGRQRnZTamx2V3NicUU1TFE3dXFNcWRoNTZ4Z0xZcSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly9sb2NhbGhvc3Qvc2FuY3R1bS9jc3JmLWNvb2tpZSI7czo1OiJyb3V0ZSI7czoxOToic2FuY3R1bS5jc3JmLWNvb2tpZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=	1775599526
TfgtGqXY8Xc2gAjnrmNYELHPjt8byhsSz0JtBDKr	\N	172.18.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36	YTozOntzOjY6Il90b2tlbiI7czo0MDoiWkhIZDM0ZTFNVGV5eTlzMUtUTUJFeVhwVHlYb1hWaWtBWTVTaG9LRSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly9sb2NhbGhvc3Qvc2FuY3R1bS9jc3JmLWNvb2tpZSI7czo1OiJyb3V0ZSI7czoxOToic2FuY3R1bS5jc3JmLWNvb2tpZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=	1775652947
edIAKyutbPsn00rkwiseZ0op4yPiGLIepq6aXJZ1	\N	172.18.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36	YTozOntzOjY6Il90b2tlbiI7czo0MDoiWURYak5Sa0FIclRNSXVzU0h2UWxwQWZ0YUNBRGNLdHR2MVVIZlF3WiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly9sb2NhbGhvc3QvYXBpL3YxL3VzZXIiO3M6NToicm91dGUiO047fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=	1775653083
ZTRY57WjoMOtUSGHhnr94c6W0nDF01lw2NrpnqCd	\N	172.18.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36	YTozOntzOjY6Il90b2tlbiI7czo0MDoiWUgzcGo4b0JOZkNBOVpJN3RMSnVpRFhtMjFwNzJ5djFQbG0xSU1qcCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly9sb2NhbGhvc3Qvc2FuY3R1bS9jc3JmLWNvb2tpZSI7czo1OiJyb3V0ZSI7czoxOToic2FuY3R1bS5jc3JmLWNvb2tpZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=	1775653192
\.



--
-- Name: audit_events audit_events_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.audit_events
    ADD CONSTRAINT audit_events_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);


--
-- Name: job_batches job_batches_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.job_batches
    ADD CONSTRAINT job_batches_pkey PRIMARY KEY (id);


--
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);


--
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);


--
-- Name: model_has_permissions model_has_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.model_has_permissions
    ADD CONSTRAINT model_has_permissions_pkey PRIMARY KEY (permission_id, model_id, model_type);


--
-- Name: model_has_roles model_has_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.model_has_roles
    ADD CONSTRAINT model_has_roles_pkey PRIMARY KEY (role_id, model_id, model_type);


--
-- Name: oper_aseguradoras oper_aseguradoras_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_aseguradoras
    ADD CONSTRAINT oper_aseguradoras_pkey PRIMARY KEY (id);


--
-- Name: oper_cdas oper_cdas_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_cdas
    ADD CONSTRAINT oper_cdas_pkey PRIMARY KEY (id);


--
-- Name: oper_cliente_responsables oper_cliente_responsables_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_cliente_responsables
    ADD CONSTRAINT oper_cliente_responsables_pkey PRIMARY KEY (id);


--
-- Name: oper_clientes oper_clientes_empresa_id_identificacion_nit_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_clientes
    ADD CONSTRAINT oper_clientes_empresa_id_identificacion_nit_unique UNIQUE (empresa_id, identificacion_nit);


--
-- Name: oper_clientes oper_clientes_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_clientes
    ADD CONSTRAINT oper_clientes_pkey PRIMARY KEY (id);


--
-- Name: oper_conductor_capacitaciones oper_conductor_capacitaciones_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_capacitaciones
    ADD CONSTRAINT oper_conductor_capacitaciones_pkey PRIMARY KEY (id);


--
-- Name: oper_conductor_documentos oper_conductor_documentos_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_documentos
    ADD CONSTRAINT oper_conductor_documentos_pkey PRIMARY KEY (id);


--
-- Name: oper_conductor_examenes oper_conductor_examenes_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_examenes
    ADD CONSTRAINT oper_conductor_examenes_pkey PRIMARY KEY (id);


--
-- Name: oper_conductor_experiencia oper_conductor_experiencia_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_experiencia
    ADD CONSTRAINT oper_conductor_experiencia_pkey PRIMARY KEY (id);


--
-- Name: oper_conductor_infracciones oper_conductor_infracciones_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_infracciones
    ADD CONSTRAINT oper_conductor_infracciones_pkey PRIMARY KEY (id);


--
-- Name: oper_conductor_referencias oper_conductor_referencias_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_referencias
    ADD CONSTRAINT oper_conductor_referencias_pkey PRIMARY KEY (id);


--
-- Name: oper_conductor_ssocial oper_conductor_ssocial_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_ssocial
    ADD CONSTRAINT oper_conductor_ssocial_pkey PRIMARY KEY (id);


--
-- Name: oper_conductor_vehiculo oper_conductor_vehiculo_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_vehiculo
    ADD CONSTRAINT oper_conductor_vehiculo_pkey PRIMARY KEY (id);


--
-- Name: oper_conductores oper_conductores_documento_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductores
    ADD CONSTRAINT oper_conductores_documento_unique UNIQUE (documento);


--
-- Name: oper_conductores oper_conductores_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductores
    ADD CONSTRAINT oper_conductores_pkey PRIMARY KEY (id);


--
-- Name: oper_contratos oper_contratos_numero_contrato_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_contratos
    ADD CONSTRAINT oper_contratos_numero_contrato_unique UNIQUE (numero_contrato);


--
-- Name: oper_contratos oper_contratos_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_contratos
    ADD CONSTRAINT oper_contratos_pkey PRIMARY KEY (id);


--
-- Name: oper_empresas_convenio oper_empresas_convenio_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_empresas_convenio
    ADD CONSTRAINT oper_empresas_convenio_pkey PRIMARY KEY (id);


--
-- Name: oper_mantenimiento_registros oper_mantenimiento_registros_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_mantenimiento_registros
    ADD CONSTRAINT oper_mantenimiento_registros_pkey PRIMARY KEY (id);


--
-- Name: oper_mantenimiento_rutinas oper_mantenimiento_rutinas_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_mantenimiento_rutinas
    ADD CONSTRAINT oper_mantenimiento_rutinas_pkey PRIMARY KEY (id);


--
-- Name: oper_preoperacional_evidencias oper_preoperacional_evidencias_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_preoperacional_evidencias
    ADD CONSTRAINT oper_preoperacional_evidencias_pkey PRIMARY KEY (id);


--
-- Name: oper_preoperacionales oper_preoperacionales_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_preoperacionales
    ADD CONSTRAINT oper_preoperacionales_pkey PRIMARY KEY (id);


--
-- Name: oper_propietarios oper_propietarios_documento_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_propietarios
    ADD CONSTRAINT oper_propietarios_documento_unique UNIQUE (documento);


--
-- Name: oper_propietarios oper_propietarios_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_propietarios
    ADD CONSTRAINT oper_propietarios_pkey PRIMARY KEY (id);


--
-- Name: oper_vehiculo_documentos oper_vehiculo_documentos_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_documentos
    ADD CONSTRAINT oper_vehiculo_documentos_pkey PRIMARY KEY (id);


--
-- Name: oper_vehiculo_polizas oper_vehiculo_polizas_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_polizas
    ADD CONSTRAINT oper_vehiculo_polizas_pkey PRIMARY KEY (id);


--
-- Name: oper_vehiculo_revisiones oper_vehiculo_revisiones_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_revisiones
    ADD CONSTRAINT oper_vehiculo_revisiones_pkey PRIMARY KEY (id);


--
-- Name: oper_vehiculos oper_vehiculos_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculos
    ADD CONSTRAINT oper_vehiculos_pkey PRIMARY KEY (id);


--
-- Name: oper_vehiculos oper_vehiculos_placa_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculos
    ADD CONSTRAINT oper_vehiculos_placa_unique UNIQUE (placa);


--
-- Name: param_ciudades param_ciudades_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_ciudades
    ADD CONSTRAINT param_ciudades_pkey PRIMARY KEY (id);


--
-- Name: param_departamentos param_departamentos_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_departamentos
    ADD CONSTRAINT param_departamentos_pkey PRIMARY KEY (id);


--
-- Name: param_lineas param_lineas_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_lineas
    ADD CONSTRAINT param_lineas_pkey PRIMARY KEY (id);


--
-- Name: param_marcas param_marcas_nombre_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_marcas
    ADD CONSTRAINT param_marcas_nombre_unique UNIQUE (nombre);


--
-- Name: param_marcas param_marcas_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_marcas
    ADD CONSTRAINT param_marcas_pkey PRIMARY KEY (id);


--
-- Name: param_preop_plantillas param_preop_plantillas_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_preop_plantillas
    ADD CONSTRAINT param_preop_plantillas_pkey PRIMARY KEY (id);


--
-- Name: permissions permissions_name_guard_name_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_name_guard_name_unique UNIQUE (name, guard_name);


--
-- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);


--
-- Name: reg_fuecs reg_fuecs_numero_fuec_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.reg_fuecs
    ADD CONSTRAINT reg_fuecs_numero_fuec_unique UNIQUE (numero_fuec);


--
-- Name: reg_fuecs reg_fuecs_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.reg_fuecs
    ADD CONSTRAINT reg_fuecs_pkey PRIMARY KEY (id);


--
-- Name: reg_fuecs reg_fuecs_qr_verificacion_hash_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.reg_fuecs
    ADD CONSTRAINT reg_fuecs_qr_verificacion_hash_unique UNIQUE (qr_verificacion_hash);


--
-- Name: role_has_permissions role_has_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_pkey PRIMARY KEY (permission_id, role_id);


--
-- Name: roles roles_name_guard_name_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_name_guard_name_unique UNIQUE (name, guard_name);


--
-- Name: roles roles_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);


--
-- Name: saas_features saas_features_empresa_id_feature_name_unique; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.saas_features
    ADD CONSTRAINT saas_features_empresa_id_feature_name_unique UNIQUE (empresa_id, feature_name);


--
-- Name: saas_features saas_features_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.saas_features
    ADD CONSTRAINT saas_features_pkey PRIMARY KEY (id);


--
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);


--
-- Name: audit_events_entity_type_entity_id_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX audit_events_entity_type_entity_id_index ON public.audit_events USING btree (entity_type, entity_id);


--
-- Name: idx_conductores_empresa_deleted; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_conductores_empresa_deleted ON public.oper_conductores USING btree (empresa_id, deleted_at);


--
-- Name: idx_conductores_licencia_venc; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_conductores_licencia_venc ON public.oper_conductores USING btree (vencimiento_licencia);


--
-- Name: idx_docs_vehiculo_tipo; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_docs_vehiculo_tipo ON public.oper_vehiculo_documentos USING btree (vehiculo_id, tipo_documento, is_active);


--
-- Name: idx_fuecs_conductor; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_fuecs_conductor ON public.reg_fuecs USING btree (conductor_id);


--
-- Name: idx_fuecs_empresa_deleted; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_fuecs_empresa_deleted ON public.reg_fuecs USING btree (empresa_id, deleted_at);


--
-- Name: idx_fuecs_empresa_estado; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_fuecs_empresa_estado ON public.reg_fuecs USING btree (empresa_id, estado);


--
-- Name: idx_fuecs_empresa_fecha; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_fuecs_empresa_fecha ON public.reg_fuecs USING btree (empresa_id, fecha_inicio_viaje);


--
-- Name: idx_fuecs_vehiculo; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_fuecs_vehiculo ON public.reg_fuecs USING btree (vehiculo_id);


--
-- Name: idx_manto_reg_empresa_deleted; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_manto_reg_empresa_deleted ON public.oper_mantenimiento_registros USING btree (empresa_id, deleted_at);


--
-- Name: idx_manto_reg_fecha; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_manto_reg_fecha ON public.oper_mantenimiento_registros USING btree (empresa_id, fecha_servicio);


--
-- Name: idx_manto_reg_vehiculo_rutina; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_manto_reg_vehiculo_rutina ON public.oper_mantenimiento_registros USING btree (vehiculo_id, rutina_id);


--
-- Name: idx_manto_rutinas_empresa_active; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_manto_rutinas_empresa_active ON public.oper_mantenimiento_rutinas USING btree (empresa_id, is_active);


--
-- Name: idx_polizas_vehiculo_active_venc; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_polizas_vehiculo_active_venc ON public.oper_vehiculo_polizas USING btree (vehiculo_id, is_active, fecha_vencimiento);


--
-- Name: idx_polizas_vehiculo_tipo; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_polizas_vehiculo_tipo ON public.oper_vehiculo_polizas USING btree (vehiculo_id, tipo_poliza, is_active);


--
-- Name: idx_preop_empresa_deleted; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_preop_empresa_deleted ON public.oper_preoperacionales USING btree (empresa_id, deleted_at);


--
-- Name: idx_preop_empresa_fecha; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_preop_empresa_fecha ON public.oper_preoperacionales USING btree (empresa_id, created_at);


--
-- Name: idx_preop_vehiculo_fecha; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_preop_vehiculo_fecha ON public.oper_preoperacionales USING btree (vehiculo_id, created_at);


--
-- Name: idx_revisiones_vehiculo_active_venc; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_revisiones_vehiculo_active_venc ON public.oper_vehiculo_revisiones USING btree (vehiculo_id, is_active, fecha_vencimiento);


--
-- Name: idx_revisiones_vehiculo_tipo; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_revisiones_vehiculo_tipo ON public.oper_vehiculo_revisiones USING btree (vehiculo_id, tipo_revision, is_active);


--
-- Name: idx_ssocial_conductor_active; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_ssocial_conductor_active ON public.oper_conductor_ssocial USING btree (conductor_id, is_active, fecha_final);


--
-- Name: idx_vehiculos_convenio; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_vehiculos_convenio ON public.oper_vehiculos USING btree (empresa_convenio_id);


--
-- Name: idx_vehiculos_empresa_deleted; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_vehiculos_empresa_deleted ON public.oper_vehiculos USING btree (empresa_id, deleted_at);


--
-- Name: idx_vehiculos_propietario; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX idx_vehiculos_propietario ON public.oper_vehiculos USING btree (propietario_id);


--
-- Name: jobs_queue_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue);


--
-- Name: model_has_permissions_model_id_model_type_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX model_has_permissions_model_id_model_type_index ON public.model_has_permissions USING btree (model_id, model_type);


--
-- Name: model_has_roles_model_id_model_type_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX model_has_roles_model_id_model_type_index ON public.model_has_roles USING btree (model_id, model_type);


--
-- Name: oper_clientes_identificacion_nit_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX oper_clientes_identificacion_nit_index ON public.oper_clientes USING btree (identificacion_nit);


--
-- Name: oper_conductor_documentos_fecha_vencimiento_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX oper_conductor_documentos_fecha_vencimiento_index ON public.oper_conductor_documentos USING btree (fecha_vencimiento);


--
-- Name: oper_vehiculo_documentos_fecha_vencimiento_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX oper_vehiculo_documentos_fecha_vencimiento_index ON public.oper_vehiculo_documentos USING btree (fecha_vencimiento);


--
-- Name: oper_vehiculo_polizas_fecha_vencimiento_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX oper_vehiculo_polizas_fecha_vencimiento_index ON public.oper_vehiculo_polizas USING btree (fecha_vencimiento);


--
-- Name: oper_vehiculo_revisiones_fecha_vencimiento_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX oper_vehiculo_revisiones_fecha_vencimiento_index ON public.oper_vehiculo_revisiones USING btree (fecha_vencimiento);


--
-- Name: sessions_last_activity_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity);


--
-- Name: sessions_user_id_index; Type: INDEX; Schema: public; Owner: sail
--

CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id);


--
-- Name: audit_events audit_events_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.audit_events
    ADD CONSTRAINT audit_events_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE SET NULL;


--
-- Name: audit_events audit_events_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.audit_events
    ADD CONSTRAINT audit_events_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: model_has_permissions model_has_permissions_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.model_has_permissions
    ADD CONSTRAINT model_has_permissions_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;


--
-- Name: model_has_roles model_has_roles_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.model_has_roles
    ADD CONSTRAINT model_has_roles_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- Name: oper_aseguradoras oper_aseguradoras_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_aseguradoras
    ADD CONSTRAINT oper_aseguradoras_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: oper_cdas oper_cdas_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_cdas
    ADD CONSTRAINT oper_cdas_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: oper_cliente_responsables oper_cliente_responsables_cliente_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_cliente_responsables
    ADD CONSTRAINT oper_cliente_responsables_cliente_id_foreign FOREIGN KEY (cliente_id) REFERENCES public.oper_clientes(id) ON DELETE CASCADE;


--
-- Name: oper_clientes oper_clientes_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_clientes
    ADD CONSTRAINT oper_clientes_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: oper_conductor_capacitaciones oper_conductor_capacitaciones_conductor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_capacitaciones
    ADD CONSTRAINT oper_conductor_capacitaciones_conductor_id_foreign FOREIGN KEY (conductor_id) REFERENCES public.oper_conductores(id) ON DELETE CASCADE;


--
-- Name: oper_conductor_documentos oper_conductor_documentos_conductor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_documentos
    ADD CONSTRAINT oper_conductor_documentos_conductor_id_foreign FOREIGN KEY (conductor_id) REFERENCES public.oper_conductores(id) ON DELETE CASCADE;


--
-- Name: oper_conductor_examenes oper_conductor_examenes_conductor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_examenes
    ADD CONSTRAINT oper_conductor_examenes_conductor_id_foreign FOREIGN KEY (conductor_id) REFERENCES public.oper_conductores(id) ON DELETE CASCADE;


--
-- Name: oper_conductor_experiencia oper_conductor_experiencia_conductor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_experiencia
    ADD CONSTRAINT oper_conductor_experiencia_conductor_id_foreign FOREIGN KEY (conductor_id) REFERENCES public.oper_conductores(id) ON DELETE CASCADE;


--
-- Name: oper_conductor_infracciones oper_conductor_infracciones_conductor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_infracciones
    ADD CONSTRAINT oper_conductor_infracciones_conductor_id_foreign FOREIGN KEY (conductor_id) REFERENCES public.oper_conductores(id) ON DELETE CASCADE;


--
-- Name: oper_conductor_referencias oper_conductor_referencias_conductor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_referencias
    ADD CONSTRAINT oper_conductor_referencias_conductor_id_foreign FOREIGN KEY (conductor_id) REFERENCES public.oper_conductores(id) ON DELETE CASCADE;


--
-- Name: oper_conductor_ssocial oper_conductor_ssocial_conductor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_ssocial
    ADD CONSTRAINT oper_conductor_ssocial_conductor_id_foreign FOREIGN KEY (conductor_id) REFERENCES public.oper_conductores(id) ON DELETE CASCADE;


--
-- Name: oper_conductor_vehiculo oper_conductor_vehiculo_conductor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_vehiculo
    ADD CONSTRAINT oper_conductor_vehiculo_conductor_id_foreign FOREIGN KEY (conductor_id) REFERENCES public.oper_conductores(id) ON DELETE CASCADE;


--
-- Name: oper_conductor_vehiculo oper_conductor_vehiculo_vehiculo_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductor_vehiculo
    ADD CONSTRAINT oper_conductor_vehiculo_vehiculo_id_foreign FOREIGN KEY (vehiculo_id) REFERENCES public.oper_vehiculos(id) ON DELETE CASCADE;


--
-- Name: oper_conductores oper_conductores_ciudad_expedicion_documento_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductores
    ADD CONSTRAINT oper_conductores_ciudad_expedicion_documento_id_foreign FOREIGN KEY (ciudad_expedicion_documento_id) REFERENCES public.param_ciudades(id) ON DELETE SET NULL;


--
-- Name: oper_conductores oper_conductores_ciudad_residencia_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductores
    ADD CONSTRAINT oper_conductores_ciudad_residencia_id_foreign FOREIGN KEY (ciudad_residencia_id) REFERENCES public.param_ciudades(id) ON DELETE SET NULL;


--
-- Name: oper_conductores oper_conductores_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductores
    ADD CONSTRAINT oper_conductores_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: oper_conductores oper_conductores_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_conductores
    ADD CONSTRAINT oper_conductores_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: oper_contratos oper_contratos_cliente_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_contratos
    ADD CONSTRAINT oper_contratos_cliente_id_foreign FOREIGN KEY (cliente_id) REFERENCES public.oper_clientes(id) ON DELETE RESTRICT;


--
-- Name: oper_contratos oper_contratos_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_contratos
    ADD CONSTRAINT oper_contratos_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: oper_contratos oper_contratos_responsable_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_contratos
    ADD CONSTRAINT oper_contratos_responsable_id_foreign FOREIGN KEY (responsable_id) REFERENCES public.oper_cliente_responsables(id) ON DELETE RESTRICT;


--
-- Name: oper_empresas_convenio oper_empresas_convenio_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_empresas_convenio
    ADD CONSTRAINT oper_empresas_convenio_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: oper_mantenimiento_registros oper_mantenimiento_registros_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_mantenimiento_registros
    ADD CONSTRAINT oper_mantenimiento_registros_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id);


--
-- Name: oper_mantenimiento_registros oper_mantenimiento_registros_rutina_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_mantenimiento_registros
    ADD CONSTRAINT oper_mantenimiento_registros_rutina_id_foreign FOREIGN KEY (rutina_id) REFERENCES public.oper_mantenimiento_rutinas(id);


--
-- Name: oper_mantenimiento_registros oper_mantenimiento_registros_vehiculo_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_mantenimiento_registros
    ADD CONSTRAINT oper_mantenimiento_registros_vehiculo_id_foreign FOREIGN KEY (vehiculo_id) REFERENCES public.oper_vehiculos(id);


--
-- Name: oper_mantenimiento_rutinas oper_mantenimiento_rutinas_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_mantenimiento_rutinas
    ADD CONSTRAINT oper_mantenimiento_rutinas_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id);


--
-- Name: oper_preoperacional_evidencias oper_preoperacional_evidencias_preoperacional_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_preoperacional_evidencias
    ADD CONSTRAINT oper_preoperacional_evidencias_preoperacional_id_foreign FOREIGN KEY (preoperacional_id) REFERENCES public.oper_preoperacionales(id) ON DELETE CASCADE;


--
-- Name: oper_preoperacionales oper_preoperacionales_conductor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_preoperacionales
    ADD CONSTRAINT oper_preoperacionales_conductor_id_foreign FOREIGN KEY (conductor_id) REFERENCES public.oper_conductores(id) ON DELETE CASCADE;


--
-- Name: oper_preoperacionales oper_preoperacionales_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_preoperacionales
    ADD CONSTRAINT oper_preoperacionales_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: oper_preoperacionales oper_preoperacionales_plantilla_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_preoperacionales
    ADD CONSTRAINT oper_preoperacionales_plantilla_id_foreign FOREIGN KEY (plantilla_id) REFERENCES public.param_preop_plantillas(id) ON DELETE SET NULL;


--
-- Name: oper_preoperacionales oper_preoperacionales_vehiculo_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_preoperacionales
    ADD CONSTRAINT oper_preoperacionales_vehiculo_id_foreign FOREIGN KEY (vehiculo_id) REFERENCES public.oper_vehiculos(id) ON DELETE CASCADE;


--
-- Name: oper_propietarios oper_propietarios_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_propietarios
    ADD CONSTRAINT oper_propietarios_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: oper_propietarios oper_propietarios_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_propietarios
    ADD CONSTRAINT oper_propietarios_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: oper_vehiculo_documentos oper_vehiculo_documentos_vehiculo_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_documentos
    ADD CONSTRAINT oper_vehiculo_documentos_vehiculo_id_foreign FOREIGN KEY (vehiculo_id) REFERENCES public.oper_vehiculos(id) ON DELETE CASCADE;


--
-- Name: oper_vehiculo_polizas oper_vehiculo_polizas_aseguradora_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_polizas
    ADD CONSTRAINT oper_vehiculo_polizas_aseguradora_id_foreign FOREIGN KEY (aseguradora_id) REFERENCES public.oper_aseguradoras(id) ON DELETE RESTRICT;


--
-- Name: oper_vehiculo_polizas oper_vehiculo_polizas_vehiculo_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_polizas
    ADD CONSTRAINT oper_vehiculo_polizas_vehiculo_id_foreign FOREIGN KEY (vehiculo_id) REFERENCES public.oper_vehiculos(id) ON DELETE CASCADE;


--
-- Name: oper_vehiculo_revisiones oper_vehiculo_revisiones_cda_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_revisiones
    ADD CONSTRAINT oper_vehiculo_revisiones_cda_id_foreign FOREIGN KEY (cda_id) REFERENCES public.oper_cdas(id) ON DELETE RESTRICT;


--
-- Name: oper_vehiculo_revisiones oper_vehiculo_revisiones_vehiculo_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculo_revisiones
    ADD CONSTRAINT oper_vehiculo_revisiones_vehiculo_id_foreign FOREIGN KEY (vehiculo_id) REFERENCES public.oper_vehiculos(id) ON DELETE CASCADE;


--
-- Name: oper_vehiculos oper_vehiculos_empresa_convenio_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculos
    ADD CONSTRAINT oper_vehiculos_empresa_convenio_id_foreign FOREIGN KEY (empresa_convenio_id) REFERENCES public.oper_empresas_convenio(id) ON DELETE SET NULL;


--
-- Name: oper_vehiculos oper_vehiculos_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculos
    ADD CONSTRAINT oper_vehiculos_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: oper_vehiculos oper_vehiculos_linea_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculos
    ADD CONSTRAINT oper_vehiculos_linea_id_foreign FOREIGN KEY (linea_id) REFERENCES public.param_lineas(id) ON DELETE SET NULL;


--
-- Name: oper_vehiculos oper_vehiculos_marca_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculos
    ADD CONSTRAINT oper_vehiculos_marca_id_foreign FOREIGN KEY (marca_id) REFERENCES public.param_marcas(id) ON DELETE SET NULL;


--
-- Name: oper_vehiculos oper_vehiculos_propietario_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.oper_vehiculos
    ADD CONSTRAINT oper_vehiculos_propietario_id_foreign FOREIGN KEY (propietario_id) REFERENCES public.oper_propietarios(id) ON DELETE SET NULL;


--
-- Name: param_ciudades param_ciudades_departamento_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_ciudades
    ADD CONSTRAINT param_ciudades_departamento_id_foreign FOREIGN KEY (departamento_id) REFERENCES public.param_departamentos(id) ON DELETE CASCADE;


--
-- Name: param_lineas param_lineas_marca_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_lineas
    ADD CONSTRAINT param_lineas_marca_id_foreign FOREIGN KEY (marca_id) REFERENCES public.param_marcas(id) ON DELETE CASCADE;


--
-- Name: param_preop_plantillas param_preop_plantillas_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.param_preop_plantillas
    ADD CONSTRAINT param_preop_plantillas_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: reg_fuecs reg_fuecs_conductor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.reg_fuecs
    ADD CONSTRAINT reg_fuecs_conductor_id_foreign FOREIGN KEY (conductor_id) REFERENCES public.oper_conductores(id) ON DELETE CASCADE;


--
-- Name: reg_fuecs reg_fuecs_contrato_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.reg_fuecs
    ADD CONSTRAINT reg_fuecs_contrato_id_foreign FOREIGN KEY (contrato_id) REFERENCES public.oper_contratos(id) ON DELETE CASCADE;


--
-- Name: reg_fuecs reg_fuecs_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.reg_fuecs
    ADD CONSTRAINT reg_fuecs_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;


--
-- Name: reg_fuecs reg_fuecs_vehiculo_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.reg_fuecs
    ADD CONSTRAINT reg_fuecs_vehiculo_id_foreign FOREIGN KEY (vehiculo_id) REFERENCES public.oper_vehiculos(id) ON DELETE CASCADE;


--
-- Name: role_has_permissions role_has_permissions_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;


--
-- Name: role_has_permissions role_has_permissions_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- Name: saas_features saas_features_empresa_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: sail
--

ALTER TABLE ONLY public.saas_features
    ADD CONSTRAINT saas_features_empresa_id_foreign FOREIGN KEY (empresa_id) REFERENCES public.saas_empresas(id) ON DELETE CASCADE;