
SET transaction_timeout = 0;



--
-- Name: alembic_version; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.alembic_version (
    version_num character varying(32) NOT NULL
);


--
-- Name: alimentos_preparados; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.alimentos_preparados (
    descripcion character varying(255) NOT NULL,
    cantidad double precision NOT NULL,
    unidad character varying(50) NOT NULL,
    equipo character varying(100) NOT NULL,
    fecha date NOT NULL,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: alimentos_preparados_componentes; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.alimentos_preparados_componentes (
    alimento_preparado_id integer NOT NULL,
    donacion_materia_id integer NOT NULL,
    cantidad_usada double precision NOT NULL,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: alimentos_preparados_componentes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: alimentos_preparados_componentes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.alimentos_preparados_componentes_id_seq OWNED BY public.alimentos_preparados_componentes.id;


--
-- Name: alimentos_preparados_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: alimentos_preparados_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.alimentos_preparados_id_seq OWNED BY public.alimentos_preparados.id;


--
-- Name: areas; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.areas (
    area character varying(100) NOT NULL,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: areas_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: areas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.areas_id_seq OWNED BY public.areas.id;


--
-- Name: asistencia_servidores; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.asistencia_servidores (
    id_persona integer CONSTRAINT asistencia_servidores_id_servidor_not_null NOT NULL,
    fecha date NOT NULL,
    rol character varying(50) NOT NULL,
    categoria_contexto character varying(50) NOT NULL,
    referencia_id integer,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: asistencia_servidores_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: asistencia_servidores_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.asistencia_servidores_id_seq OWNED BY public.asistencia_servidores.id;


--
-- Name: aulas; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.aulas (
    condicion character varying NOT NULL,
    ninos integer NOT NULL,
    ninas integer NOT NULL,
    fecha date NOT NULL,
    id_salon integer,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone,
    id_maestra integer,
    id_auxiliar integer
);


--
-- Name: aulas_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: aulas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.aulas_id_seq OWNED BY public.aulas.id;


--
-- Name: auxiliares; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.auxiliares (
    nombre character varying(100) NOT NULL,
    edad integer NOT NULL,
    fecha_nacimiento date,
    cedula integer NOT NULL,
    celular character varying(20),
    correo character varying(100),
    numero_equipo integer,
    id_capitan integer,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: auxiliares_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: auxiliares_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.auxiliares_id_seq OWNED BY public.auxiliares.id;


--
-- Name: capitanes; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.capitanes (
    nombre character varying(100) NOT NULL,
    edad integer NOT NULL,
    fecha_nacimiento date,
    cedula integer NOT NULL,
    celular character varying(20),
    correo character varying(100),
    id_coordinador integer,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: capitanes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: capitanes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.capitanes_id_seq OWNED BY public.capitanes.id;


--
-- Name: colaboradores; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.colaboradores (
    nombre character varying(100) NOT NULL,
    edad integer NOT NULL,
    fecha_nacimiento date,
    cedula integer NOT NULL,
    celular character varying(20),
    correo character varying(100),
    numero_equipo integer,
    id_capitan integer,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: colaboradores_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: colaboradores_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.colaboradores_id_seq OWNED BY public.colaboradores.id;


--
-- Name: coordinadores; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.coordinadores (
    nombre character varying(100) NOT NULL,
    edad integer NOT NULL,
    fecha_nacimiento date,
    cedula integer NOT NULL,
    celular character varying(20),
    correo character varying(100),
    id_lider integer,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone,
    id_area integer
);


--
-- Name: coordinadores_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: coordinadores_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.coordinadores_id_seq OWNED BY public.coordinadores.id;


--
-- Name: distribuciones; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.distribuciones (
    donacion_id integer,
    alimento_preparado_id integer,
    salon_id integer,
    area_id integer,
    recepcion_id integer,
    cantidad double precision NOT NULL,
    unidad character varying(50) NOT NULL,
    fecha date NOT NULL,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: distribuciones_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: distribuciones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.distribuciones_id_seq OWNED BY public.distribuciones.id;


--
-- Name: docentes; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.docentes (
    nombre character varying(100) NOT NULL,
    edad integer NOT NULL,
    fecha_nacimiento date,
    cedula integer NOT NULL,
    celular character varying(20),
    correo character varying(100),
    numero_equipo integer,
    id_capitan integer,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: docentes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: docentes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.docentes_id_seq OWNED BY public.docentes.id;


--
-- Name: donaciones; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.donaciones (
    descripcion character varying(255) NOT NULL,
    cantidad double precision NOT NULL,
    unidad character varying(50) NOT NULL,
    equipo character varying(100),
    fecha date NOT NULL,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: donaciones_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: donaciones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.donaciones_id_seq OWNED BY public.donaciones.id;


--
-- Name: ensenanzas; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.ensenanzas (
    capitan character varying,
    subcapitan integer,
    fecha date,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: ensenanzas_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: ensenanzas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.ensenanzas_id_seq OWNED BY public.ensenanzas.id;


--
-- Name: lideres; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.lideres (
    nombre character varying(100) NOT NULL,
    edad integer NOT NULL,
    fecha_nacimiento date,
    cedula integer NOT NULL,
    celular character varying(20),
    correo character varying(100),
    id_pastor integer,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: lideres_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: lideres_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.lideres_id_seq OWNED BY public.lideres.id;


--
-- Name: logisticas; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.logisticas (
    almacen integer,
    capitan integer,
    distribucion integer,
    hidratacion integer,
    pasillo integer,
    secretaria integer,
    fecha date NOT NULL,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone,
    id_capitan integer,
    observaciones text
);


--
-- Name: logisticas_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: logisticas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.logisticas_id_seq OWNED BY public.logisticas.id;


--
-- Name: otrasareas; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.otrasareas (
    alabanza integer,
    protocolo integer,
    semillitas integer,
    sonido integer,
    teatro integer,
    tv integer,
    ujier integer,
    seguridad integer,
    fecha date,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: otrasareas_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: otrasareas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.otrasareas_id_seq OWNED BY public.otrasareas.id;


--
-- Name: pastores; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.pastores (
    nombre character varying(100) NOT NULL,
    iglesia character varying(100) NOT NULL,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: pastores_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: pastores_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.pastores_id_seq OWNED BY public.pastores.id;


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

CREATE TABLE public.permissions (
    codigo character varying(100) NOT NULL,
    descripcion character varying(255),
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


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

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


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

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


--
-- Name: recepciones; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.recepciones (
    nombre character varying,
    fecha date,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: recepciones_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: recepciones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.recepciones_id_seq OWNED BY public.recepciones.id;


--
-- Name: role_permissions; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.role_permissions (
    role_id integer NOT NULL,
    permission_id integer NOT NULL
);


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

CREATE TABLE public.roles (
    nombre character varying(50) NOT NULL,
    descripcion character varying(255),
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


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

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


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

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


--
-- Name: salones; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.salones (
    salon character varying NOT NULL,
    edad character varying NOT NULL,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone,
    id_area integer
);


--
-- Name: salones_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: salones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.salones_id_seq OWNED BY public.salones.id;


--
-- Name: servidores; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.servidores (
    nombre character varying(100) NOT NULL,
    edad integer NOT NULL,
    cedula integer NOT NULL,
    celular character varying(20),
    correo character varying(100),
    numero_equipo integer,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone,
    fecha_nacimiento date,
    id_capitan integer
);


--
-- Name: servidores_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: servidores_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.servidores_id_seq OWNED BY public.servidores.id;


--
-- Name: sync_queue; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.sync_queue (
    entity_name character varying(80) NOT NULL,
    entity_sync_id character varying(36) NOT NULL,
    operation character varying(20) NOT NULL,
    payload_json text NOT NULL,
    status character varying(20) NOT NULL,
    attempts integer NOT NULL,
    last_error text,
    processed_at timestamp without time zone,
    id integer NOT NULL,
    sync_id character varying(36) NOT NULL,
    is_deleted boolean,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    last_sync timestamp without time zone
);


--
-- Name: sync_queue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: sync_queue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.sync_queue_id_seq OWNED BY public.sync_queue.id;


--
-- Name: usuarios_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: usuarios_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.usuarios_id_seq OWNED BY public.usuarios.id;


--
-- Name: alimentos_preparados id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: alimentos_preparados_componentes id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: areas id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: asistencia_servidores id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: aulas id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: auxiliares id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: capitanes id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: colaboradores id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: coordinadores id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: distribuciones id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: docentes id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: donaciones id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: ensenanzas id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: lideres id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: logisticas id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: otrasareas id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: pastores id; Type: DEFAULT; Schema: public; Owner: -
--

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


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

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


--
-- Name: recepciones id; Type: DEFAULT; Schema: public; Owner: -
--

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


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

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


--
-- Name: salones id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: servidores id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: sync_queue id; Type: DEFAULT; Schema: public; Owner: -
--

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


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

COPY public.alembic_version (version_num) FROM stdin;
751a47a06aaa
\.


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

COPY public.alimentos_preparados (descripcion, cantidad, unidad, equipo, fecha, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
Jugo de guayaba	237	Vaso(s)	N. 2	2026-05-03	1	271bc578-5609-47c4-90da-af2edffb52f7	f	2026-05-10 19:29:37.444635	2026-05-10 19:29:37.44464	\N
\.


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

COPY public.alimentos_preparados_componentes (alimento_preparado_id, donacion_materia_id, cantidad_usada, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
1	3	3	1	f8438bb5-5362-46be-bad9-185a60394dc5	f	2026-05-10 19:29:37.482923	2026-05-10 19:29:37.482929	\N
1	2	3	2	5ebdf9da-bb7c-4464-a243-a2ebd141097e	f	2026-05-10 19:29:37.482942	2026-05-10 19:29:37.482944	\N
\.


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

COPY public.areas (area, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
Logistica	1	0f169ead-bb6a-44a9-9c91-63c37de3db0b	f	2026-05-10 19:04:09.641126	2026-05-10 19:04:09.641135	\N
Almacén	2	dfdb89e7-4043-4002-b94c-59754dbc36ee	f	2026-05-10 19:04:31.115682	2026-05-10 19:04:31.115687	\N
Secretaría	3	b36d362b-96b4-4f04-8040-3cf9ed1de78b	f	2026-05-10 19:04:40.810793	2026-05-10 19:04:40.8108	\N
Distribución de Alimentos	4	beb47f4f-756c-4259-b5ce-9c165ef2909e	f	2026-05-10 19:04:58.415163	2026-05-10 19:04:58.415169	\N
Maternal	5	be378141-898b-49e6-a307-1b49612e0363	f	2026-05-14 14:56:43.761711	2026-05-14 14:56:43.761716	\N
Infantil	6	88243cda-291e-4651-b20e-79c9dc5a2e5b	f	2026-05-14 14:56:49.42182	2026-05-14 14:56:49.421825	\N
Pre-Juvenil	7	a717ff7c-efa3-41d2-adf2-b8e6053a67a4	f	2026-05-14 14:56:54.880864	2026-05-14 14:56:54.880869	\N
Logistica-pasillo	8	bf29f61f-9fe9-45bc-9a1a-20ea9d625195	f	2026-05-19 02:31:07.948163	2026-05-19 02:31:07.948169	\N
Logistica-hidratación	9	e2a6b53f-da2d-4eb9-aae6-403261d8e2e5	f	2026-05-19 02:31:16.527641	2026-05-19 02:31:16.527646	\N
\.


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

COPY public.asistencia_servidores (id_persona, fecha, rol, categoria_contexto, referencia_id, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
\.


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

COPY public.aulas (condicion, ninos, ninas, fecha, id_salon, id, sync_id, is_deleted, created_at, updated_at, last_sync, id_maestra, id_auxiliar) FROM stdin;
Abierto	1	1	2026-05-03	2	1	d27b0487-c559-4506-9ee7-44fe0f617046	f	2026-05-10 19:19:54.890844	2026-05-10 19:19:54.89085	\N	\N	\N
Abierto	3	1	2026-05-03	3	2	66777813-816b-4983-8d85-18d9e204d109	f	2026-05-10 19:22:50.807202	2026-05-10 19:22:50.807209	\N	\N	\N
\.


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

COPY public.auxiliares (nombre, edad, fecha_nacimiento, cedula, celular, correo, numero_equipo, id_capitan, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
\.


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

COPY public.capitanes (nombre, edad, fecha_nacimiento, cedula, celular, correo, id_coordinador, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
Flavio García	19	2007-03-02	33411494	4244605084	flaviogarciaoriginal35@gmail.com	1	1	30213e04-ddc0-479a-bf11-c6db6f40593a	f	2026-05-14 20:16:29.383775	2026-05-14 20:16:29.383779	\N
Marcos Jimenez	18	2007-08-22	32349262	04144012640	\N	1	2	a600c738-f60b-409b-bb85-aaf5a3aef662	f	2026-05-14 20:17:12.047199	2026-05-14 20:17:12.047203	\N
Reina Torres	52	1974-03-09	12101243	04244035469	\N	6	6	2483edf8-dbf6-4acd-a653-3a9e2a332152	f	2026-05-14 20:23:04.989606	2026-05-14 20:23:04.989609	\N
Davis Jesús García Rodríguez 	46	1979-05-17	13194143	0424418118	\N	9	9	8c9b0bfd-b5f3-4341-9e87-61918c64a952	f	2026-05-14 20:25:23.522468	2026-05-14 20:25:23.522472	\N
Crisálida Rojas	58	1967-05-21	8668243	04128864207	\N	10	13	a58ac00b-db58-4d0c-8e9f-905c846d8655	f	2026-05-14 20:29:23.600222	2026-05-14 20:29:23.600227	\N
Liyeira Ochoa 	52	1974-03-07	11526448	04165406041 	\N	1	14	f9e8cd0a-5a76-468c-8bc7-40b4be9b296f	f	2026-05-14 20:30:09.881666	2026-05-14 20:30:09.881671	\N
 Yohana González	46	\N	15657098	0412.755.4175	\N	5	3	69a397a8-37cd-4438-8d95-22bea36050b1	f	2026-05-14 20:18:38.232796	2026-05-14 20:47:39.838221	\N
Martha Navarro 	52	\N	11354526	0424-4560239	\N	5	4	200a5db3-1613-400c-92a5-8acd4798feeb	f	2026-05-14 20:19:40.501717	2026-05-14 20:48:06.933656	\N
Rebeca Del Valle Valdespino	40	\N	17513136	414-5845023	\N	5	5	594aa52f-d05d-405a-8e3f-6e69464e190b	f	2026-05-14 20:20:20.569346	2026-05-14 20:48:23.208918	\N
Rosana Angélica Zumeta Viñas	39	\N	17613359	0414-4105673	\N	8	7	91142301-3ebf-4ffd-b586-6a5e545ce1cb	f	2026-05-14 20:23:59.362162	2026-05-14 20:49:16.819118	\N
Orlairis del Valle Patti Rodriguez	36	\N	20697541	0424-4995846	\N	8	8	2b56e3b2-f61f-4abe-a855-6c5fd57cefe7	f	2026-05-14 20:24:45.236067	2026-05-14 20:49:34.124212	\N
Yorkhatreen Yanez	27	1998-06-01	27925147	424-4095793	\N	6	15	d02592f9-c18d-44b6-9b5e-29cc18836073	f	2026-05-14 20:56:22.652276	2026-05-14 20:56:22.65228	\N
María Carrillo	41	\N	17257952	 04144314626 	\N	13	10	91d7f153-4dbc-469f-bcd6-a62168b6f712	f	2026-05-14 20:26:17.703728	2026-05-14 21:00:21.447748	\N
Alicia García 	60	\N	9525964	04244298347	\N	13	12	0b1e9196-5b82-4995-a1e2-56c4eaefc602	f	2026-05-14 20:28:35.716678	2026-05-14 21:00:32.80572	\N
Richard José Giménez Meléndez 	41	\N	17613006	0412-4107719	\N	13	11	cec30d5a-b241-4a43-b165-769aa968862d	f	2026-05-14 20:27:03.67715	2026-05-14 21:00:48.991789	\N
\.


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

COPY public.colaboradores (nombre, edad, fecha_nacimiento, cedula, celular, correo, numero_equipo, id_capitan, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
\.


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

COPY public.coordinadores (nombre, edad, fecha_nacimiento, cedula, celular, correo, id_lider, id, sync_id, is_deleted, created_at, updated_at, last_sync, id_area) FROM stdin;
Dina Carreño	50	\N	13254487	0424-4370301	dina.m.c@hotmail.com	1	1	8bae3ac8-9814-45e5-91e8-dd2ffb877b55	f	2026-05-13 19:15:47.925392	2026-05-14 19:44:41.893849	\N	\N
Noreidis Rada 	33	1992-11-24	21017972	04262468973	\N	1	6	d58cc795-0193-45a1-a9b4-e6f5878c457b	f	2026-05-14 20:08:34.823654	2026-05-14 20:08:34.82366	\N	\N
Vanessa Sánchez 	35	1990-05-20	20180218	04128664432	\N	1	7	8269663c-b3f6-4dab-9239-d851eb002e6a	f	2026-05-14 20:12:51.615495	2026-05-14 20:12:51.615499	\N	\N
Dina Rodriguez 	44	1981-06-22	15901226	04128380443	\N	1	8	f15d3489-9a4f-4c37-b4df-f0350252c61c	f	2026-05-14 20:13:27.69409	2026-05-14 20:13:27.694093	\N	\N
Elizabeth Solemni Pérez Padrón 	36	1989-06-21	18973052	04143492253	\N	1	9	84d66673-851d-4b60-84e2-4a64aae71461	f	2026-05-14 20:14:09.40626	2026-05-14 20:14:09.406266	\N	\N
Rafael Garcia	35	1990-08-14	20091488	0412.1470380	\N	1	10	70ab4c4d-cfc8-4170-a82a-27027c6fb479	f	2026-05-14 20:14:54.082272	2026-05-14 20:14:54.082276	\N	\N
Mariana Alcalá de Malavé	37	1988-12-26	18781089	0412413000	\N	1	11	3cc2f257-edd8-4c5d-bee8-5833bb45e2bb	f	2026-05-14 20:58:26.08442	2026-05-14 20:58:26.084424	\N	\N
Carlos Enrique Malavé	44	1981-07-17	15824189	04244494489	\N	1	12	0e92faf0-7d2c-4b61-be4e-40e59dd8f59c	f	2026-05-14 20:59:10.681315	2026-05-14 20:59:10.681319	\N	\N
Jesús María Silva Terán	54	1971-12-02	11155867	04128861314	\N	1	13	ce761b99-567e-4923-8d37-1f2677c4a3fe	f	2026-05-14 20:59:45.480812	2026-05-14 20:59:45.480816	\N	\N
Andrea González (md)	29	\N	24458183	0424-4965738	\N	1	3	d7958258-4e2b-4d58-bbf2-4fc4abb1fef6	f	2026-05-14 19:46:51.212916	2026-05-15 03:21:20.343983	\N	\N
Sulma Ines Arango Loboa	44	1981-09-28	22212426	04244491781	\N	1	5	813a4009-bddd-45d2-90cb-92f6df72de52	f	2026-05-14 20:04:03.315374	2026-05-19 21:53:42.593199	\N	5
\.


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

COPY public.distribuciones (donacion_id, alimento_preparado_id, salon_id, area_id, recepcion_id, cantidad, unidad, fecha, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
\N	1	2	\N	\N	5	Vaso(s)	2026-05-03	1	515185c7-7062-4126-94b9-a2deeedba91a	f	2026-05-10 19:30:50.71222	2026-05-10 19:30:50.712226	\N
\.


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

COPY public.docentes (nombre, edad, fecha_nacimiento, cedula, celular, correo, numero_equipo, id_capitan, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
Yrene del Carmen Escobar Hernandez	50	1976-05-28	14392872	0412 9658152	\N	1	3	1	8c4bb78b-4298-4af7-826d-3756f0c763f8	f	2026-06-08 18:07:59.103312	2026-06-08 18:07:59.103317	\N
Gloria Isabel  Manzanilla Carreño	20	2006-05-27	32047347	0414 4092307	\N	1	3	2	aedce09f-82d9-424e-ae5f-3282c7aefeab	f	2026-06-08 18:09:30.552141	2026-06-08 18:09:30.552146	\N
Joselyn Karina Bravo Suárez	22	2003-07-07	30195494	0412 4411774	\N	1	3	3	d178b5f7-016e-4751-970c-39ffde0f5a70	f	2026-06-08 18:13:26.798667	2026-06-08 18:13:26.798673	\N
Yelimar Pérez	32	1993-10-05	21241340	0414 4023117	\N	1	3	4	86e53a61-1ecc-49f4-84cb-749e7f8d9f3b	f	2026-06-08 18:14:24.747303	2026-06-08 18:14:24.747306	\N
Francisca del Carmen Alvarez de Medina 	70	1955-12-03	5319246	0424 4104403	\N	1	3	5	d38cfc88-fb21-4bc3-b715-08b70f871165	f	2026-06-08 18:15:45.060593	2026-06-08 18:15:45.060598	\N
Aurelia Carrasco de Galvis	63	1962-12-05	7726073	0414 4307685	\N	1	3	6	61ff2f2f-729a-4557-8f28-35ae6038bc73	f	2026-06-08 18:16:44.006633	2026-06-08 18:16:44.006637	\N
Isbeth Tovar	0	\N	11057227	0412 7464577	\N	3	4	7	abaa9573-3d0e-49ac-8f9f-5cf84db0714a	f	2026-06-08 18:21:17.58246	2026-06-08 18:21:17.582465	\N
Marianys Conde	22	2003-06-25	29915272	0412 4086768	\N	3	4	8	f1d6a1c9-92a1-4474-a91e-a98a558faaa4	f	2026-06-08 18:22:13.023206	2026-06-08 18:22:13.02321	\N
Angelys Gutierrez	25	2000-09-28	27877616	0414 9426627	\N	2	4	9	91bbe9d6-db7c-4fea-a101-6462781a5c5d	f	2026-06-08 18:23:00.992523	2026-06-08 18:23:00.992526	\N
Nurbia Sanchez	38	1987-07-21	19425901	0424 4054264	\N	3	4	10	7583dac4-4868-4003-9fe7-80edff311f8d	f	2026-06-08 18:23:43.105468	2026-06-08 18:23:43.105472	\N
Eluzai Rodriguez	-1	2026-07-11	32842330	0424 5064234	\N	3	4	11	2e5b49f5-30cf-41f9-ac57-562883a36595	f	2026-06-08 18:24:20.597585	2026-06-08 18:24:20.597588	\N
Analia Perez	0	\N	16053007	0412 9899672	\N	3	4	12	0418659d-ebe6-48b5-a5f8-1ab9ae66a192	f	2026-06-08 18:25:06.787831	2026-06-08 18:25:06.787837	\N
Willianys Nuñez	19	2007-02-05	32125778	0412 9899672	\N	1	4	13	ba331a91-b96d-4b93-a050-92e6d3294e3c	f	2026-06-08 18:25:54.457624	2026-06-08 18:25:54.457628	\N
Katherine Ariza	0	\N	24644990	0414 4268050	\N	3	4	14	a7531d37-1efb-4708-b0ab-d25549264b76	f	2026-06-08 18:26:32.746859	2026-06-08 18:26:32.746866	\N
Eidimar Nuñez	35	1991-03-26	22002458	0412 7430022	\N	3	4	15	0d0ebaf5-54f2-490f-b0f8-4c24aedee16d	f	2026-06-08 18:27:34.246205	2026-06-08 18:27:34.246209	\N
Dianis Vera	22	2004-04-21	30758060	0412 1432454	\N	1	15	16	a90cc8f2-2006-40c7-b605-ca9172d44d54	f	2026-06-08 18:38:09.303933	2026-06-08 18:38:09.30394	\N
Stefany Muro	31	1995-05-26	84558441	0414 5955436	\N	-2	15	17	4ddcba13-34f0-4995-b8c5-601ba9f7b5ee	f	2026-06-08 18:39:05.464906	2026-06-08 18:39:05.464909	\N
Dainielis Alcarra	22	2004-03-20	31932581	0412 8466374	\N	1	15	18	4640a0af-0629-46b4-8cb7-197c9bf65dd7	f	2026-06-08 18:44:01.734614	2026-06-08 18:44:01.734619	\N
Rosbelys Fabiany Tovar Acosta	24	2001-08-12	28299924	0424 4103690	\N	1	15	19	41c1999b-85b3-44b8-9162-67aeb954914d	f	2026-06-08 18:45:10.327931	2026-06-08 18:45:10.327934	\N
Franyelis Sinai  Villazana Brea	27	1998-12-18	26670956	0416 2448719	\N	1	15	20	574d2b73-a18a-4c17-999f-ee777e483b91	f	2026-06-08 18:45:41.663638	2026-06-08 18:45:41.663644	\N
Belkis Herrera	42	1983-08-03	17338173	0412 7174791	\N	1	15	21	9b46df9e-bd87-464b-88f3-0a1363c6727f	f	2026-06-08 18:46:13.086025	2026-06-08 18:46:13.086029	\N
Diosennys Annali Diaz Espejo	18	2008-04-23	33667219	0412 9063591	\N	1	15	22	6f625fff-96be-4b05-8d67-ecbf632804b5	f	2026-06-08 18:46:50.819246	2026-06-08 18:46:50.81925	\N
Roxana Alexandra Rodríguez	48	1977-12-26	14571617	0412 5064231	\N	3	6	23	fd29ac42-f7c5-4a8b-984f-aabac5ecec1b	f	2026-06-08 18:48:01.540285	2026-06-08 18:48:01.540289	\N
Alba Freites	60	1965-06-29	8671626	04244460729	\N	3	6	24	3a4b41f7-3f85-4024-9b7f-2dbf1b022c8d	f	2026-06-08 18:48:30.269073	2026-06-08 18:49:23.929022	\N
Felimar de Romero Hernández 	27	1998-11-11	26636188	04125188615	\N	3	6	25	458e58b3-87c2-49b7-84a5-361e85b5ab36	f	2026-06-08 18:50:09.327516	2026-06-08 18:50:09.327521	\N
María Porte 	50	1975-12-12	12772868	04120398558	\N	3	6	26	a7937cdf-9b6b-4fff-950c-82cbc15d4362	f	2026-06-08 18:50:39.481955	2026-06-08 18:50:39.481959	\N
Esquivel María	44	1981-06-19	15102954	04120381735	\N	3	6	27	9b810b5a-36ec-4df4-9948-0ba6304c7088	f	2026-06-08 18:51:24.134286	2026-06-08 18:51:24.13429	\N
Karem Cedeño	0	\N	30640668	04128473213	\N	-2	6	28	dedb4109-d010-448b-a065-bdd1eaffadc0	f	2026-06-08 18:52:00.146652	2026-06-08 18:52:00.146657	\N
\.


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

COPY public.donaciones (descripcion, cantidad, unidad, equipo, fecha, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
Pastelitos 	252	Unidad(es)	N. 2	2026-05-03	1	b683153e-2ea3-4062-9afd-5bca2282ed5b	f	2026-05-10 19:26:01.084071	2026-05-10 19:26:01.084077	\N
Guayaba	3	Kilogramos	N. 2	2026-05-03	2	c2a3c89e-547f-4516-bcf5-fb75afba33fd	f	2026-05-10 19:27:16.975044	2026-05-10 19:27:16.975049	\N
Azúcar 	3	Kilogramos	N. 2	2026-05-10	3	753ed42f-5bcb-4cc0-a14b-c639ebde5eaa	f	2026-05-10 19:27:39.376762	2026-05-10 19:27:39.376767	\N
\.


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

COPY public.ensenanzas (capitan, subcapitan, fecha, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
\.


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

COPY public.lideres (nombre, edad, fecha_nacimiento, cedula, celular, correo, id_pastor, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
Ludy	56	\N	1234567890	1234-5678901	nocorreo@correo.com	1	1	c9c627cb-40a1-4f0b-9888-f3253892800b	f	2026-05-13 19:14:41.805056	2026-05-13 19:14:41.805061	\N
\.


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

COPY public.logisticas (almacen, capitan, distribucion, hidratacion, pasillo, secretaria, fecha, id, sync_id, is_deleted, created_at, updated_at, last_sync, id_capitan, observaciones) FROM stdin;
\.


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

COPY public.otrasareas (alabanza, protocolo, semillitas, sonido, teatro, tv, ujier, seguridad, fecha, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
\.


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

COPY public.pastores (nombre, iglesia, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
Francisco Barrios	Maranatha Venezuela sede San Diego	1	b3386bed-da9e-43bb-88ba-656957117023	f	2026-05-13 19:13:25.04304	2026-05-13 19:13:25.043046	\N
\.


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

COPY public.permissions (codigo, descripcion, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
areas.view	Permiso areas.view	76	4a7c8a1f-0c06-4e4d-83cb-40b475df96a5	f	2026-05-07 02:34:14.563107	2026-05-07 02:34:14.563107	\N
areas.manage	Permiso areas.manage	77	deaf450c-a2a9-4109-a95c-82e3e1a7f26b	f	2026-05-07 02:34:15.487193	2026-05-07 02:34:15.487193	\N
salones.view	Permiso salones.view	78	c3e8f09f-e5eb-496d-b85a-8e45bbc017c9	f	2026-05-07 02:34:16.798078	2026-05-07 02:34:16.798078	\N
salones.manage	Permiso salones.manage	79	d27bbf69-a5dc-4519-9de2-331c0d2e21c6	f	2026-05-07 02:34:18.121693	2026-05-07 02:34:18.121693	\N
aulas.view	Permiso aulas.view	80	d35423b9-14e1-4a76-8726-eda8ba050572	f	2026-05-07 02:34:21.718228	2026-05-07 02:34:21.718228	\N
aulas.manage	Permiso aulas.manage	81	3470791a-9e69-419c-afa5-1e55e0539f3d	f	2026-05-07 02:34:26.153414	2026-05-07 02:34:26.153414	\N
estadistica.view	Permiso estadistica.view	82	b124faf7-95d5-4542-9dd8-eb1d65ff67a7	f	2026-05-07 02:34:27.467314	2026-05-07 02:34:27.467314	\N
donaciones.view	Permiso donaciones.view	83	1fb1c5bb-79da-4818-8653-8a4878face0c	f	2026-05-07 02:34:28.866472	2026-05-07 02:34:28.866472	\N
donaciones.manage	Permiso donaciones.manage	84	dd763ab5-1dc9-4a8f-9ca8-9dfc25c0c7d3	f	2026-05-07 02:34:31.657896	2026-05-07 02:34:31.657896	\N
preparados.view	Permiso preparados.view	85	392fb6a6-0057-440d-bf64-89b4cfef81c7	f	2026-05-07 02:34:33.824533	2026-05-07 02:34:33.824533	\N
preparados.manage	Permiso preparados.manage	86	5ed91b3b-434a-480a-bd19-fb22bc72f8c0	f	2026-05-07 02:34:36.859013	2026-05-07 02:34:36.859013	\N
distribuciones.view	Permiso distribuciones.view	87	90cf906d-d64a-44a7-80ad-60b6369bde24	f	2026-05-07 02:34:38.337399	2026-05-07 02:34:38.337399	\N
distribuciones.manage	Permiso distribuciones.manage	88	1ebc25f5-0fef-4800-8aaa-97658f264a83	f	2026-05-07 02:34:39.73482	2026-05-07 02:34:39.73482	\N
logistica.view	Permiso logistica.view	89	9248b852-4994-4d01-b83c-1b56481d9389	f	2026-05-07 02:34:41.22011	2026-05-07 02:34:41.22011	\N
logistica.manage	Permiso logistica.manage	90	a6e2c152-b8e4-491b-b23a-1e4f3bfbecb8	f	2026-05-07 02:34:43.918622	2026-05-07 02:34:43.918622	\N
otras_areas.view	Permiso otras_areas.view	91	ea60310d-2554-4696-97bd-40c97be98522	f	2026-05-07 02:34:45.81427	2026-05-07 02:34:45.81427	\N
otras_areas.manage	Permiso otras_areas.manage	92	dad2452b-1a15-44e8-a8d2-18839874687b	f	2026-05-07 02:34:48.074799	2026-05-07 02:34:48.074799	\N
ensenanza.view	Permiso ensenanza.view	93	d4f96164-adab-47d5-a3af-7db2498c61d6	f	2026-05-07 02:34:50.595613	2026-05-07 02:34:50.595613	\N
ensenanza.manage	Permiso ensenanza.manage	94	1006b482-3c1e-49de-b20d-1f7e34ef21f8	f	2026-05-07 02:34:53.652918	2026-05-07 02:34:53.652918	\N
recepcion.view	Permiso recepcion.view	95	62d65546-4292-4def-ab4c-58f2fd99e314	f	2026-05-07 02:34:55.182599	2026-05-07 02:34:55.182599	\N
recepcion.manage	Permiso recepcion.manage	96	857258c9-b070-481b-9037-c7c01b8a290b	f	2026-05-07 02:34:56.69203	2026-05-07 02:34:56.69203	\N
servidores.view	Permiso servidores.view	97	4a32acaa-6ecb-4b8f-b834-422d3bb2cdb3	f	2026-05-07 02:35:00.475911	2026-05-07 02:35:00.475911	\N
servidores.manage	Permiso servidores.manage	98	80c343b4-9c05-4716-ab6c-36daff3094c6	f	2026-05-07 02:35:06.88033	2026-05-07 02:35:06.88033	\N
reporte.view	Permiso reporte.view	99	93109aae-61b9-4673-b30d-b3fed9a9b7b5	f	2026-05-07 02:35:10.230442	2026-05-07 02:35:10.230442	\N
ayuda.view	Permiso ayuda.view	100	0e9526b2-2238-4530-acc8-97d2cfcf0d44	f	2026-05-07 02:35:16.276908	2026-05-07 02:35:16.276908	\N
pastores.view	Permiso pastores.view	101	222c5924-1db7-4ce6-9b55-08b1ea93244d	f	2026-05-19 13:08:33.864115	2026-05-19 13:08:33.86412	\N
pastores.manage	Permiso pastores.manage	102	9ce29b67-4f0c-4fa5-b811-c3a2a4ba7c51	f	2026-05-19 13:08:33.873743	2026-05-19 13:08:33.873749	\N
lideres.view	Permiso lideres.view	103	b72b056c-6984-4416-a872-828d576dd742	f	2026-05-19 13:08:33.886253	2026-05-19 13:08:33.886259	\N
lideres.manage	Permiso lideres.manage	104	64ede990-44ce-4d8f-aa05-040aa0fa6252	f	2026-05-19 13:08:33.897606	2026-05-19 13:08:33.897611	\N
capitanes.view	Permiso capitanes.view	105	e562e83c-5104-4c9c-90c1-09f700fcefa1	f	2026-05-19 13:08:33.908123	2026-05-19 13:08:33.908128	\N
capitanes.manage	Permiso capitanes.manage	106	0a6905bd-b472-4958-bbe0-bae5b2c58eac	f	2026-05-19 13:08:33.918799	2026-05-19 13:08:33.918805	\N
docentes.view	Permiso docentes.view	107	e05d93f3-b7ee-43b0-8442-57a0200bcdb5	f	2026-05-19 13:08:33.930435	2026-05-19 13:08:33.930441	\N
docentes.manage	Permiso docentes.manage	108	29da87a6-0f4b-4925-bf8c-4514c27720fa	f	2026-05-19 13:08:33.942265	2026-05-19 13:08:33.942269	\N
auxiliares.view	Permiso auxiliares.view	109	cfdc6817-8e8b-4adc-915b-0563c7c5cf15	f	2026-05-19 13:08:33.954321	2026-05-19 13:08:33.954326	\N
auxiliares.manage	Permiso auxiliares.manage	110	59823539-dd08-4ce3-aa6f-266577c083a9	f	2026-05-19 13:08:33.965532	2026-05-19 13:08:33.965538	\N
colaboradores.view	Permiso colaboradores.view	111	e7f9c076-b3ce-40ca-bc8b-72d7ad70d715	f	2026-05-19 13:08:33.976742	2026-05-19 13:08:33.976747	\N
colaboradores.manage	Permiso colaboradores.manage	112	993a1d85-be12-4a70-9171-469f48ecdbf9	f	2026-05-19 13:08:33.987363	2026-05-19 13:08:33.987369	\N
\.


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

COPY public.recepciones (nombre, fecha, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
\.


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

COPY public.role_permissions (role_id, permission_id) FROM stdin;
14	76
14	77
14	78
14	79
14	80
14	81
14	82
14	83
14	84
14	85
14	86
14	87
14	88
14	89
14	90
14	91
14	92
14	93
14	94
14	95
14	96
14	97
14	98
14	99
14	100
15	80
15	82
15	78
15	81
16	84
16	85
16	86
16	80
16	87
16	83
16	88
16	82
14	101
14	102
14	103
14	104
14	105
14	106
14	107
14	108
14	109
14	110
14	111
14	112
17	83
17	84
17	85
17	86
17	87
17	88
17	99
17	89
17	90
17	91
17	100
17	92
17	93
17	94
17	76
17	95
17	77
17	78
17	79
17	96
17	80
17	81
17	82
\.


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

COPY public.roles (nombre, descripcion, id, sync_id, is_deleted, created_at, updated_at, last_sync) FROM stdin;
root	Rol del sistema: root	13	3f2cafe5-cef8-4d96-a02f-723d2a28e2a6	f	2026-05-07 02:34:09.708778	2026-05-07 02:34:09.708778	\N
administrador	Rol del sistema: administrador	14	475e9027-8183-4967-b202-e8bbfb24bbfb	f	2026-05-07 02:34:12.848226	2026-05-07 02:34:12.848226	\N
maestro	Rol del sistema: maestro	15	149fc543-6df9-4f72-8f4e-8b909ce9ab03	f	2026-05-07 02:35:19.704892	2026-05-07 02:35:19.704892	\N
distribuidor	Rol del sistema: distribuidor	16	fe5225fa-3fd4-4fb2-a33d-9ae853667274	f	2026-05-07 02:35:34.0938	2026-05-07 02:35:34.0938	\N
secretaria	Rol del sistema: secretaria	17	eaf82c1e-ac43-40d6-b428-33014295b3bb	f	2026-05-19 13:27:19.06031	2026-05-19 13:27:19.060317	\N
\.


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

COPY public.salones (salon, edad, id, sync_id, is_deleted, created_at, updated_at, last_sync, id_area) FROM stdin;
Sala 1 	1 año	2	f064fa37-639d-4dce-a006-e33439e601ef	f	2026-05-10 19:07:24.873925	2026-05-10 19:07:24.87397	\N	\N
Sala 2 	2 años	3	4aa1480a-5f76-41ac-816e-720a6e575ebd	f	2026-05-10 19:07:34.924991	2026-05-10 19:07:34.924997	\N	\N
Sala 3 	3 años	4	a3dde0eb-b014-4296-9880-16cb9c0fb2f0	f	2026-05-10 19:07:46.701155	2026-05-10 19:07:46.70116	\N	\N
A	3 años	5	bc306618-b5db-40e4-a2ee-3b19e28cc0d7	f	2026-05-10 19:09:01.258287	2026-05-10 19:09:01.258299	\N	\N
B	2 años	6	46d1ea2d-6056-4ca2-a752-2d16d4ee6a06	f	2026-05-10 19:09:22.002686	2026-05-10 19:09:22.002692	\N	\N
C	3 años	7	455e0cd0-e536-49c7-b6b4-674557422d6c	f	2026-05-10 19:09:38.902967	2026-05-10 19:09:38.902973	\N	\N
E	4 años	9	b0b3906c-e4fe-4435-8feb-8b1307d1f014	f	2026-05-10 19:09:52.911838	2026-05-10 19:09:52.911843	\N	\N
F	5 años	10	361047b5-bee6-4cc8-96be-43435c42a762	f	2026-05-10 19:09:59.807076	2026-05-10 19:09:59.807081	\N	\N
G	5 años	11	c4fe785f-0e66-44d9-a145-acb39f8ea3b2	f	2026-05-10 19:10:07.207829	2026-05-10 19:10:07.207835	\N	\N
H	6 años	12	741cdbfb-79f2-4097-8dbc-1b860d9f0298	f	2026-05-10 19:10:16.897096	2026-05-10 19:10:16.897101	\N	\N
I	6 años	13	fe9314e5-57f7-4074-97df-be2af7c9a5c2	f	2026-05-10 19:10:26.87231	2026-05-10 19:10:26.872315	\N	\N
J	7 años	14	9fac41ec-85f0-4f78-8a50-02d0cd554341	f	2026-05-10 19:10:49.475448	2026-05-10 19:10:49.475455	\N	\N
K	7 años	15	9aea54d8-8df1-4de2-aef8-8531a079490c	f	2026-05-10 19:10:57.535778	2026-05-10 19:10:57.535784	\N	\N
L	7 años	16	e091f154-a817-4f50-970e-343086343ddd	f	2026-05-10 19:11:03.939405	2026-05-10 19:11:03.939412	\N	\N
Comedor	8 a 11 años	17	571410af-c292-493a-a2ef-75fac7c5215a	f	2026-05-10 19:11:18.280569	2026-05-10 19:11:18.280574	\N	\N
D	4 años	8	a8d24439-1463-4326-808c-e7d9d60993e2	t	2026-05-10 19:09:45.604794	2026-05-11 22:10:30.242968	\N	\N
Cuna y gateo	1 mes a 11 meses	1	f96ca35c-bf98-4ffb-8f5c-9e4e1ebecb69	f	2026-05-10 19:07:14.180531	2026-05-19 02:29:51.370324	\N	5
Salón de usos múltiple 	12 años a 17 años	18	0480dd7e-1a46-4648-b6b4-dcb78fc6fb15	f	2026-05-10 19:11:44.432678	2026-05-19 02:30:23.946323	\N	7
\.


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

COPY public.servidores (nombre, edad, cedula, celular, correo, numero_equipo, id, sync_id, is_deleted, created_at, updated_at, last_sync, fecha_nacimiento, id_capitan) FROM stdin;
Flavio Garcia	19	3411494	04243605084	flaviogarciaoriginal35@gmail.com	\N	1	01a6a302-6f65-4e64-8923-bee88bbe0536	f	2026-05-08 12:15:46.316708	2026-05-08 12:15:46.316714	\N	2007-03-02	\N
\.





--
-- Name: alembic_version alembic_version_pkc; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.alembic_version
    ADD CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num);


--
-- Name: alimentos_preparados_componentes alimentos_preparados_componentes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.alimentos_preparados_componentes
    ADD CONSTRAINT alimentos_preparados_componentes_pkey PRIMARY KEY (id);


--
-- Name: alimentos_preparados alimentos_preparados_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.alimentos_preparados
    ADD CONSTRAINT alimentos_preparados_pkey PRIMARY KEY (id);


--
-- Name: areas areas_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.areas
    ADD CONSTRAINT areas_pkey PRIMARY KEY (id);


--
-- Name: asistencia_servidores asistencia_servidores_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.asistencia_servidores
    ADD CONSTRAINT asistencia_servidores_pkey PRIMARY KEY (id);


--
-- Name: aulas aulas_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.aulas
    ADD CONSTRAINT aulas_pkey PRIMARY KEY (id);


--
-- Name: auxiliares auxiliares_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.auxiliares
    ADD CONSTRAINT auxiliares_pkey PRIMARY KEY (id);


--
-- Name: capitanes capitanes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.capitanes
    ADD CONSTRAINT capitanes_pkey PRIMARY KEY (id);


--
-- Name: colaboradores colaboradores_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.colaboradores
    ADD CONSTRAINT colaboradores_pkey PRIMARY KEY (id);


--
-- Name: coordinadores coordinadores_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.coordinadores
    ADD CONSTRAINT coordinadores_pkey PRIMARY KEY (id);


--
-- Name: distribuciones distribuciones_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.distribuciones
    ADD CONSTRAINT distribuciones_pkey PRIMARY KEY (id);


--
-- Name: docentes docentes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.docentes
    ADD CONSTRAINT docentes_pkey PRIMARY KEY (id);


--
-- Name: donaciones donaciones_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.donaciones
    ADD CONSTRAINT donaciones_pkey PRIMARY KEY (id);


--
-- Name: ensenanzas ensenanzas_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.ensenanzas
    ADD CONSTRAINT ensenanzas_pkey PRIMARY KEY (id);


--
-- Name: lideres lideres_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.lideres
    ADD CONSTRAINT lideres_pkey PRIMARY KEY (id);


--
-- Name: logisticas logisticas_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.logisticas
    ADD CONSTRAINT logisticas_pkey PRIMARY KEY (id);


--
-- Name: otrasareas otrasareas_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.otrasareas
    ADD CONSTRAINT otrasareas_pkey PRIMARY KEY (id);


--
-- Name: pastores pastores_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.pastores
    ADD CONSTRAINT pastores_pkey PRIMARY KEY (id);


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

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


--
-- Name: recepciones recepciones_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.recepciones
    ADD CONSTRAINT recepciones_pkey PRIMARY KEY (id);


--
-- Name: role_permissions role_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.role_permissions
    ADD CONSTRAINT role_permissions_pkey PRIMARY KEY (role_id, permission_id);


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

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


--
-- Name: salones salones_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.salones
    ADD CONSTRAINT salones_pkey PRIMARY KEY (id);


--
-- Name: servidores servidores_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.servidores
    ADD CONSTRAINT servidores_pkey PRIMARY KEY (id);


--
-- Name: sync_queue sync_queue_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sync_queue
    ADD CONSTRAINT sync_queue_pkey PRIMARY KEY (id);


--
-- Name: areas uq_areas_area; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.areas
    ADD CONSTRAINT uq_areas_area UNIQUE (area);


--
-- Name: auxiliares uq_auxiliares_cedula; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.auxiliares
    ADD CONSTRAINT uq_auxiliares_cedula UNIQUE (cedula);


--
-- Name: auxiliares uq_auxiliares_correo; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.auxiliares
    ADD CONSTRAINT uq_auxiliares_correo UNIQUE (correo);


--
-- Name: capitanes uq_capitanes_cedula; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.capitanes
    ADD CONSTRAINT uq_capitanes_cedula UNIQUE (cedula);


--
-- Name: capitanes uq_capitanes_correo; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.capitanes
    ADD CONSTRAINT uq_capitanes_correo UNIQUE (correo);


--
-- Name: colaboradores uq_colaboradores_cedula; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.colaboradores
    ADD CONSTRAINT uq_colaboradores_cedula UNIQUE (cedula);


--
-- Name: colaboradores uq_colaboradores_correo; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.colaboradores
    ADD CONSTRAINT uq_colaboradores_correo UNIQUE (correo);


--
-- Name: coordinadores uq_coordinadores_cedula; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.coordinadores
    ADD CONSTRAINT uq_coordinadores_cedula UNIQUE (cedula);


--
-- Name: coordinadores uq_coordinadores_correo; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.coordinadores
    ADD CONSTRAINT uq_coordinadores_correo UNIQUE (correo);


--
-- Name: docentes uq_docentes_cedula; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.docentes
    ADD CONSTRAINT uq_docentes_cedula UNIQUE (cedula);


--
-- Name: docentes uq_docentes_correo; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.docentes
    ADD CONSTRAINT uq_docentes_correo UNIQUE (correo);


--
-- Name: lideres uq_lideres_cedula; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.lideres
    ADD CONSTRAINT uq_lideres_cedula UNIQUE (cedula);


--
-- Name: lideres uq_lideres_correo; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.lideres
    ADD CONSTRAINT uq_lideres_correo UNIQUE (correo);


--
-- Name: salones uq_salones_salon; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.salones
    ADD CONSTRAINT uq_salones_salon UNIQUE (salon);


--
-- Name: servidores uq_servidores_cedula; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.servidores
    ADD CONSTRAINT uq_servidores_cedula UNIQUE (cedula);


--
-- Name: servidores uq_servidores_correo; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.servidores
    ADD CONSTRAINT uq_servidores_correo UNIQUE (correo);


--
-- Name: ix_alimentos_preparados_componentes_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_alimentos_preparados_componentes_id ON public.alimentos_preparados_componentes USING btree (id);


--
-- Name: ix_alimentos_preparados_componentes_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_alimentos_preparados_componentes_sync_id ON public.alimentos_preparados_componentes USING btree (sync_id);


--
-- Name: ix_alimentos_preparados_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_alimentos_preparados_id ON public.alimentos_preparados USING btree (id);


--
-- Name: ix_alimentos_preparados_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_alimentos_preparados_sync_id ON public.alimentos_preparados USING btree (sync_id);


--
-- Name: ix_areas_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_areas_id ON public.areas USING btree (id);


--
-- Name: ix_areas_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_areas_sync_id ON public.areas USING btree (sync_id);


--
-- Name: ix_asistencia_servidores_categoria_contexto; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_asistencia_servidores_categoria_contexto ON public.asistencia_servidores USING btree (categoria_contexto);


--
-- Name: ix_asistencia_servidores_fecha; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_asistencia_servidores_fecha ON public.asistencia_servidores USING btree (fecha);


--
-- Name: ix_asistencia_servidores_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_asistencia_servidores_id ON public.asistencia_servidores USING btree (id);


--
-- Name: ix_asistencia_servidores_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_asistencia_servidores_sync_id ON public.asistencia_servidores USING btree (sync_id);


--
-- Name: ix_aulas_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_aulas_id ON public.aulas USING btree (id);


--
-- Name: ix_aulas_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_aulas_sync_id ON public.aulas USING btree (sync_id);


--
-- Name: ix_auxiliares_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_auxiliares_id ON public.auxiliares USING btree (id);


--
-- Name: ix_auxiliares_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_auxiliares_sync_id ON public.auxiliares USING btree (sync_id);


--
-- Name: ix_capitanes_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_capitanes_id ON public.capitanes USING btree (id);


--
-- Name: ix_capitanes_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_capitanes_sync_id ON public.capitanes USING btree (sync_id);


--
-- Name: ix_colaboradores_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_colaboradores_id ON public.colaboradores USING btree (id);


--
-- Name: ix_colaboradores_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_colaboradores_sync_id ON public.colaboradores USING btree (sync_id);


--
-- Name: ix_coordinadores_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_coordinadores_id ON public.coordinadores USING btree (id);


--
-- Name: ix_coordinadores_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_coordinadores_sync_id ON public.coordinadores USING btree (sync_id);


--
-- Name: ix_distribuciones_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_distribuciones_id ON public.distribuciones USING btree (id);


--
-- Name: ix_distribuciones_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_distribuciones_sync_id ON public.distribuciones USING btree (sync_id);


--
-- Name: ix_docentes_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_docentes_id ON public.docentes USING btree (id);


--
-- Name: ix_docentes_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_docentes_sync_id ON public.docentes USING btree (sync_id);


--
-- Name: ix_donaciones_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_donaciones_id ON public.donaciones USING btree (id);


--
-- Name: ix_donaciones_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_donaciones_sync_id ON public.donaciones USING btree (sync_id);


--
-- Name: ix_ensenanzas_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_ensenanzas_id ON public.ensenanzas USING btree (id);


--
-- Name: ix_ensenanzas_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_ensenanzas_sync_id ON public.ensenanzas USING btree (sync_id);


--
-- Name: ix_lideres_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_lideres_id ON public.lideres USING btree (id);


--
-- Name: ix_lideres_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_lideres_sync_id ON public.lideres USING btree (sync_id);


--
-- Name: ix_logisticas_fecha; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_logisticas_fecha ON public.logisticas USING btree (fecha);


--
-- Name: ix_logisticas_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_logisticas_id ON public.logisticas USING btree (id);


--
-- Name: ix_logisticas_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_logisticas_sync_id ON public.logisticas USING btree (sync_id);


--
-- Name: ix_otrasareas_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_otrasareas_id ON public.otrasareas USING btree (id);


--
-- Name: ix_otrasareas_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_otrasareas_sync_id ON public.otrasareas USING btree (sync_id);


--
-- Name: ix_pastores_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_pastores_id ON public.pastores USING btree (id);


--
-- Name: ix_pastores_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_pastores_sync_id ON public.pastores USING btree (sync_id);


--
-- Name: ix_permissions_codigo; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_permissions_codigo ON public.permissions USING btree (codigo);


--
-- Name: ix_permissions_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_permissions_id ON public.permissions USING btree (id);


--
-- Name: ix_permissions_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_permissions_sync_id ON public.permissions USING btree (sync_id);


--
-- Name: ix_recepciones_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_recepciones_id ON public.recepciones USING btree (id);


--
-- Name: ix_recepciones_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_recepciones_sync_id ON public.recepciones USING btree (sync_id);


--
-- Name: ix_roles_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_roles_id ON public.roles USING btree (id);


--
-- Name: ix_roles_nombre; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_roles_nombre ON public.roles USING btree (nombre);


--
-- Name: ix_roles_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_roles_sync_id ON public.roles USING btree (sync_id);


--
-- Name: ix_salones_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_salones_id ON public.salones USING btree (id);


--
-- Name: ix_salones_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_salones_sync_id ON public.salones USING btree (sync_id);


--
-- Name: ix_servidores_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_servidores_id ON public.servidores USING btree (id);


--
-- Name: ix_servidores_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_servidores_sync_id ON public.servidores USING btree (sync_id);


--
-- Name: ix_sync_queue_entity_name; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_sync_queue_entity_name ON public.sync_queue USING btree (entity_name);


--
-- Name: ix_sync_queue_entity_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_sync_queue_entity_sync_id ON public.sync_queue USING btree (entity_sync_id);


--
-- Name: ix_sync_queue_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX ix_sync_queue_id ON public.sync_queue USING btree (id);


--
-- Name: ix_sync_queue_sync_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX ix_sync_queue_sync_id ON public.sync_queue USING btree (sync_id);


--
-- Name: alimentos_preparados_componentes alimentos_preparados_componentes_alimento_preparado_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.alimentos_preparados_componentes
    ADD CONSTRAINT alimentos_preparados_componentes_alimento_preparado_id_fkey FOREIGN KEY (alimento_preparado_id) REFERENCES public.alimentos_preparados(id);


--
-- Name: alimentos_preparados_componentes alimentos_preparados_componentes_donacion_materia_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.alimentos_preparados_componentes
    ADD CONSTRAINT alimentos_preparados_componentes_donacion_materia_id_fkey FOREIGN KEY (donacion_materia_id) REFERENCES public.donaciones(id);


--
-- Name: asistencia_servidores asistencia_servidores_id_servidor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.asistencia_servidores
    ADD CONSTRAINT asistencia_servidores_id_servidor_fkey FOREIGN KEY (id_persona) REFERENCES public.servidores(id);


--
-- Name: aulas aulas_id_salon_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.aulas
    ADD CONSTRAINT aulas_id_salon_fkey FOREIGN KEY (id_salon) REFERENCES public.salones(id);


--
-- Name: auxiliares auxiliares_id_capitan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.auxiliares
    ADD CONSTRAINT auxiliares_id_capitan_fkey FOREIGN KEY (id_capitan) REFERENCES public.capitanes(id);


--
-- Name: capitanes capitanes_id_coordinador_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.capitanes
    ADD CONSTRAINT capitanes_id_coordinador_fkey FOREIGN KEY (id_coordinador) REFERENCES public.coordinadores(id);


--
-- Name: colaboradores colaboradores_id_capitan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.colaboradores
    ADD CONSTRAINT colaboradores_id_capitan_fkey FOREIGN KEY (id_capitan) REFERENCES public.capitanes(id);


--
-- Name: coordinadores coordinadores_id_area_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.coordinadores
    ADD CONSTRAINT coordinadores_id_area_fkey FOREIGN KEY (id_area) REFERENCES public.areas(id);


--
-- Name: coordinadores coordinadores_id_lider_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.coordinadores
    ADD CONSTRAINT coordinadores_id_lider_fkey FOREIGN KEY (id_lider) REFERENCES public.lideres(id);


--
-- Name: distribuciones distribuciones_alimento_preparado_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.distribuciones
    ADD CONSTRAINT distribuciones_alimento_preparado_id_fkey FOREIGN KEY (alimento_preparado_id) REFERENCES public.alimentos_preparados(id);


--
-- Name: distribuciones distribuciones_area_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.distribuciones
    ADD CONSTRAINT distribuciones_area_id_fkey FOREIGN KEY (area_id) REFERENCES public.areas(id);


--
-- Name: distribuciones distribuciones_donacion_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.distribuciones
    ADD CONSTRAINT distribuciones_donacion_id_fkey FOREIGN KEY (donacion_id) REFERENCES public.donaciones(id);


--
-- Name: distribuciones distribuciones_recepcion_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.distribuciones
    ADD CONSTRAINT distribuciones_recepcion_id_fkey FOREIGN KEY (recepcion_id) REFERENCES public.recepciones(id);


--
-- Name: distribuciones distribuciones_salon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.distribuciones
    ADD CONSTRAINT distribuciones_salon_id_fkey FOREIGN KEY (salon_id) REFERENCES public.salones(id);


--
-- Name: docentes docentes_id_capitan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.docentes
    ADD CONSTRAINT docentes_id_capitan_fkey FOREIGN KEY (id_capitan) REFERENCES public.capitanes(id);


--
-- Name: aulas fk_aulas_id_auxiliar_auxiliares; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.aulas
    ADD CONSTRAINT fk_aulas_id_auxiliar_auxiliares FOREIGN KEY (id_auxiliar) REFERENCES public.auxiliares(id);


--
-- Name: aulas fk_aulas_id_maestra_docentes; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.aulas
    ADD CONSTRAINT fk_aulas_id_maestra_docentes FOREIGN KEY (id_maestra) REFERENCES public.docentes(id);


--
-- Name: salones fk_salones_id_area_areas; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.salones
    ADD CONSTRAINT fk_salones_id_area_areas FOREIGN KEY (id_area) REFERENCES public.areas(id);


--
-- Name: lideres lideres_id_pastor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.lideres
    ADD CONSTRAINT lideres_id_pastor_fkey FOREIGN KEY (id_pastor) REFERENCES public.pastores(id);


--
-- Name: logisticas logisticas_id_capitan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.logisticas
    ADD CONSTRAINT logisticas_id_capitan_fkey FOREIGN KEY (id_capitan) REFERENCES public.servidores(id);


--
-- Name: role_permissions role_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: role_permissions role_permissions_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: servidores servidores_id_capitan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.servidores
    ADD CONSTRAINT servidores_id_capitan_fkey FOREIGN KEY (id_capitan) REFERENCES public.capitanes(id);


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: -
--

GRANT ALL ON SCHEMA public TO postgres;