-- -- PostgreSQL database dump -- -- Dumped from database version 16.4 -- Dumped by pg_dump version 16.4 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: airtime; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.airtime ( id_airtime bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), montant integer, numero character varying(255) NOT NULL, statut character varying(255), partenaire_id_partenaire bigint, libelle character varying(255) ); ALTER TABLE public.airtime OWNER TO postgres; -- -- Name: airtime_id_airtime_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.airtime_id_airtime_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.airtime_id_airtime_seq OWNER TO postgres; -- -- Name: airtime_id_airtime_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.airtime_id_airtime_seq OWNED BY public.airtime.id_airtime; -- -- Name: api; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.api ( id_api bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), description character varying(255), libelle character varying(255), managed_entity character varying(255), methode character varying(255), type_retour character varying(255), url character varying(255), action_id_type_action bigint, partenaire_id_partenaire bigint, reponse_id_type_reponse bigint, response_param_id_reponse_param bigint, response_param_id_api bigint ); ALTER TABLE public.api OWNER TO postgres; -- -- Name: api_id_api_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.api_id_api_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.api_id_api_seq OWNER TO postgres; -- -- Name: api_id_api_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.api_id_api_seq OWNED BY public.api.id_api; -- -- Name: app_client; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.app_client ( id bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), libelle character varying(255), nom character varying(255), nom_entreprise character varying(255), nom_representant character varying(255), numero_entreprise character varying(255), numero_representant character varying(255), user_id bigint, email_entreprise character varying(255) ); ALTER TABLE public.app_client OWNER TO postgres; -- -- Name: app_client_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.app_client_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.app_client_id_seq OWNER TO postgres; -- -- Name: app_client_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.app_client_id_seq OWNED BY public.app_client.id; -- -- Name: application; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.application ( id bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), cle_public character varying(255), description character varying(20000), logo character varying(255), nom character varying(255), user_id_user bigint ); ALTER TABLE public.application OWNER TO postgres; -- -- Name: application_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.application_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.application_id_seq OWNER TO postgres; -- -- Name: application_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.application_id_seq OWNED BY public.application.id; -- -- Name: cash; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.cash ( id_cash bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), code character varying(255), libelle character varying(255), montant integer, nom_client character varying(255), numero character varying(255) NOT NULL, prenom_client character varying(255), response_enquiry text, statut character varying(255), type_cash character varying(255), partenaire_id_partenaire bigint ); ALTER TABLE public.cash OWNER TO postgres; -- -- Name: cash_id_cash_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.cash_id_cash_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.cash_id_cash_seq OWNER TO postgres; -- -- Name: cash_id_cash_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.cash_id_cash_seq OWNED BY public.cash.id_cash; -- -- Name: decaisser; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.decaisser ( id_decaisser bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), code character varying(255), comtpe_destinateur character varying(255), libelle_decaisser character varying(255), montant integer, nom_client character varying(255), numero character varying(255) NOT NULL, prenom_client character varying(255), response_enquiry text, statut character varying(255), app_client_id bigint, evenement_id_evenement bigint, partenaire_id_partenaire bigint, type_transaction_id_type_transaction bigint ); ALTER TABLE public.decaisser OWNER TO postgres; -- -- Name: decaisser_id_decaisser_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.decaisser_id_decaisser_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.decaisser_id_decaisser_seq OWNER TO postgres; -- -- Name: decaisser_id_decaisser_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.decaisser_id_decaisser_seq OWNED BY public.decaisser.id_decaisser; -- -- Name: error_code; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.error_code ( id_error_code bigint NOT NULL, code character varying(255), description character varying(255), error_code_type_id_error_code_type bigint ); ALTER TABLE public.error_code OWNER TO postgres; -- -- Name: error_code_id_error_code_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.error_code_id_error_code_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.error_code_id_error_code_seq OWNER TO postgres; -- -- Name: error_code_id_error_code_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.error_code_id_error_code_seq OWNED BY public.error_code.id_error_code; -- -- Name: error_code_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.error_code_type ( id_error_code_type bigint NOT NULL, description character varying(255), libelle_type_error character varying(255), partenaire_id_partenaire bigint ); ALTER TABLE public.error_code_type OWNER TO postgres; -- -- Name: error_code_type_id_error_code_type_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.error_code_type_id_error_code_type_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.error_code_type_id_error_code_type_seq OWNER TO postgres; -- -- Name: error_code_type_id_error_code_type_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.error_code_type_id_error_code_type_seq OWNED BY public.error_code_type.id_error_code_type; -- -- Name: evenement; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.evenement ( id_evenement bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), bouton character varying(255), description character varying(20000), libelle character varying(255) NOT NULL, lien character varying(255), photo_url character varying(255), user_id_user bigint ); ALTER TABLE public.evenement OWNER TO postgres; -- -- Name: evenement_id_evenement_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.evenement_id_evenement_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.evenement_id_evenement_seq OWNER TO postgres; -- -- Name: evenement_id_evenement_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.evenement_id_evenement_seq OWNED BY public.evenement.id_evenement; -- -- Name: membre; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.membre ( id_membre bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), adresse character varying(255), code integer, email character varying(255), nom character varying(255), numero_identite character varying(255), prenom character varying(255), statut boolean, telephone character varying(255) ); ALTER TABLE public.membre OWNER TO postgres; -- -- Name: membre_id_membre_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.membre_id_membre_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.membre_id_membre_seq OWNER TO postgres; -- -- Name: membre_id_membre_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.membre_id_membre_seq OWNED BY public.membre.id_membre; -- -- Name: membres_tontines; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.membres_tontines ( id_tontine bigint NOT NULL, id_membre bigint NOT NULL ); ALTER TABLE public.membres_tontines OWNER TO postgres; -- -- Name: parametre; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.parametre ( id_parametre bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), key character varying(255), ordre integer, value character varying(255), api_id_api bigint, has_children boolean, parent_id bigint, niveau integer, description character varying(255), code_type integer, type_param character varying(255), type character varying(255) ); ALTER TABLE public.parametre OWNER TO postgres; -- -- Name: parametre_id_parametre_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.parametre_id_parametre_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.parametre_id_parametre_seq OWNER TO postgres; -- -- Name: parametre_id_parametre_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.parametre_id_parametre_seq OWNED BY public.parametre.id_parametre; -- -- Name: partenaire; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.partenaire ( id_partenaire bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), adresse_physique character varying(255), base_url character varying(255), email character varying(255) NOT NULL, login character varying(255), nif character varying(255), nom_compagnie character varying(255) NOT NULL, password character varying(255), photo_url character varying(255), rccm character varying(255), telephone character varying(255) NOT NULL, logo character varying(255) ); ALTER TABLE public.partenaire OWNER TO postgres; -- -- Name: partenaire_id_partenaire_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.partenaire_id_partenaire_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.partenaire_id_partenaire_seq OWNER TO postgres; -- -- Name: partenaire_id_partenaire_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.partenaire_id_partenaire_seq OWNED BY public.partenaire.id_partenaire; -- -- Name: payement_visa; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.payement_visa ( id_payement_visa bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), amount character varying(255), card_number character varying(255), cvv character varying(255), expiry character varying(255), card_num_dest character varying(255), card_num_exp character varying(255), city character varying(255), country character varying(255), name character varying(255), telephone character varying(255) ); ALTER TABLE public.payement_visa OWNER TO postgres; -- -- Name: payement_visa_id_payement_visa_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.payement_visa_id_payement_visa_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.payement_visa_id_payement_visa_seq OWNER TO postgres; -- -- Name: payement_visa_id_payement_visa_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.payement_visa_id_payement_visa_seq OWNED BY public.payement_visa.id_payement_visa; -- -- Name: possible_values; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.possible_values ( id_possible_value bigint NOT NULL, message character varying(255), value character varying(255), response_param_id_reponse_param bigint ); ALTER TABLE public.possible_values OWNER TO postgres; -- -- Name: possible_values_id_possible_value_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.possible_values_id_possible_value_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.possible_values_id_possible_value_seq OWNER TO postgres; -- -- Name: possible_values_id_possible_value_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.possible_values_id_possible_value_seq OWNED BY public.possible_values.id_possible_value; -- -- Name: profile; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.profile ( id_profile bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), nom_profile character varying(255) ); ALTER TABLE public.profile OWNER TO postgres; -- -- Name: profile_id_profile_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.profile_id_profile_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.profile_id_profile_seq OWNER TO postgres; -- -- Name: profile_id_profile_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.profile_id_profile_seq OWNED BY public.profile.id_profile; -- -- Name: reponse_param; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.reponse_param ( id_reponse_param bigint NOT NULL, key character varying(255), value character varying(255), id_api bigint ); ALTER TABLE public.reponse_param OWNER TO postgres; -- -- Name: reponse_param_id_reponse_param_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.reponse_param_id_reponse_param_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.reponse_param_id_reponse_param_seq OWNER TO postgres; -- -- Name: reponse_param_id_reponse_param_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.reponse_param_id_reponse_param_seq OWNED BY public.reponse_param.id_reponse_param; -- -- Name: session; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.session ( id_session bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), expire_date character varying(255), is_current boolean, token character varying(255), compagnie_id_partenaire bigint, partenaire_id_partenaire bigint, token_type character varying(255) ); ALTER TABLE public.session OWNER TO postgres; -- -- Name: session_id_session_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.session_id_session_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.session_id_session_seq OWNER TO postgres; -- -- Name: session_id_session_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.session_id_session_seq OWNED BY public.session.id_session; -- -- Name: session_tontine; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.session_tontine ( id_session_tontine bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), date_debut date, date_fin date, description character varying(20000), libelle character varying(255), montant double precision NOT NULL, owner_id_user bigint, tontine_id_tontine bigint, total_collecte double precision NOT NULL ); ALTER TABLE public.session_tontine OWNER TO postgres; -- -- Name: session_tontine_id_session_tontine_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.session_tontine_id_session_tontine_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.session_tontine_id_session_tontine_seq OWNER TO postgres; -- -- Name: session_tontine_id_session_tontine_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.session_tontine_id_session_tontine_seq OWNED BY public.session_tontine.id_session_tontine; -- -- Name: session_tontine_transaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.session_tontine_transaction ( id_session_tontine_transaction bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), code character varying(255), montant integer, statut character varying(255), evenement_id_evenement bigint, membre_id_membre bigint, partenaire_id_partenaire bigint, session_tontine_id_session_tontine bigint, transaction_id bigint ); ALTER TABLE public.session_tontine_transaction OWNER TO postgres; -- -- Name: session_tontine_transaction_id_session_tontine_transaction_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.session_tontine_transaction_id_session_tontine_transaction_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.session_tontine_transaction_id_session_tontine_transaction_seq OWNER TO postgres; -- -- Name: session_tontine_transaction_id_session_tontine_transaction_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.session_tontine_transaction_id_session_tontine_transaction_seq OWNED BY public.session_tontine_transaction.id_session_tontine_transaction; -- -- Name: test_visa_foreign; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.test_visa_foreign ( id bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), destination_currency_code character varying(255), initiating_party_id character varying(255), quote_id_required character varying(255), rate_product_code character varying(255), source_currency_code character varying(255) ); ALTER TABLE public.test_visa_foreign OWNER TO postgres; -- -- Name: test_visa_foreign_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.test_visa_foreign_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.test_visa_foreign_id_seq OWNER TO postgres; -- -- Name: test_visa_foreign_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.test_visa_foreign_id_seq OWNED BY public.test_visa_foreign.id; -- -- Name: tontine; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.tontine ( id_tontine bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), bouton character varying(255), description character varying(20000), libelle character varying(255) NOT NULL, lien character varying(255), montant double precision NOT NULL, periodicite character varying(255), photo_url character varying(255), owner_id_user bigint ); ALTER TABLE public.tontine OWNER TO postgres; -- -- Name: tontine_id_tontine_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.tontine_id_tontine_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.tontine_id_tontine_seq OWNER TO postgres; -- -- Name: tontine_id_tontine_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.tontine_id_tontine_seq OWNED BY public.tontine.id_tontine; -- -- Name: transaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.transaction ( id_transaction bigint NOT NULL, code character varying(255), libelle_transaction character varying(255), montant integer, nom_client character varying(255), numero character varying(255) NOT NULL, prenom_client character varying(255), app_client_id bigint, evenement_id_evenement bigint, partenaire_id_partenaire bigint, type_transaction_id_type_transaction bigint, response_enquiry text, statut character varying(255), created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255) ); ALTER TABLE public.transaction OWNER TO postgres; -- -- Name: transaction_id_transaction_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.transaction_id_transaction_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.transaction_id_transaction_seq OWNER TO postgres; -- -- Name: transaction_id_transaction_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.transaction_id_transaction_seq OWNED BY public.transaction.id_transaction; -- -- Name: type_action; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.type_action ( id_type_action bigint NOT NULL, libelle_type_action character varying(255) ); ALTER TABLE public.type_action OWNER TO postgres; -- -- Name: type_action_id_type_action_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.type_action_id_type_action_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.type_action_id_type_action_seq OWNER TO postgres; -- -- Name: type_action_id_type_action_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.type_action_id_type_action_seq OWNED BY public.type_action.id_type_action; -- -- Name: type_reponse; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.type_reponse ( id_type_reponse bigint NOT NULL, libelle_type_reponse character varying(255), type integer ); ALTER TABLE public.type_reponse OWNER TO postgres; -- -- Name: type_reponse_id_type_reponse_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.type_reponse_id_type_reponse_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.type_reponse_id_type_reponse_seq OWNER TO postgres; -- -- Name: type_reponse_id_type_reponse_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.type_reponse_id_type_reponse_seq OWNED BY public.type_reponse.id_type_reponse; -- -- Name: type_transaction; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.type_transaction ( id_type_transaction bigint NOT NULL, libelle_type_transaction character varying(255) ); ALTER TABLE public.type_transaction OWNER TO postgres; -- -- Name: type_transaction_id_type_transaction_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.type_transaction_id_type_transaction_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.type_transaction_id_type_transaction_seq OWNER TO postgres; -- -- Name: type_transaction_id_type_transaction_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.type_transaction_id_type_transaction_seq OWNED BY public.type_transaction.id_type_transaction; -- -- Name: utilisateur; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.utilisateur ( id_user bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), email character varying(255), nom character varying(255), password character varying(255), prenom character varying(255), username character varying(255), profile_id bigint, statut boolean, telephone character varying(255), projet_id_projet bigint ); ALTER TABLE public.utilisateur OWNER TO postgres; -- -- Name: utilisateur_id_user_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.utilisateur_id_user_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.utilisateur_id_user_seq OWNER TO postgres; -- -- Name: utilisateur_id_user_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.utilisateur_id_user_seq OWNED BY public.utilisateur.id_user; -- -- Name: valider_compte_payement_visa; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.valider_compte_payement_visa ( id_valider_compte_pay_visa bigint NOT NULL, created_at timestamp without time zone, created_by character varying(255), modified_at timestamp without time zone, modified_by character varying(255), acquirer_country_code character varying(255), acquiring_bin integer, card_cvv integer, card_expiry_date character varying(255), complet_name character varying(255), number_carte integer, postal_code integer, retrieval_reference_number character varying(255), telephone integer NOT NULL, partenaire_id_partenaire bigint ); ALTER TABLE public.valider_compte_payement_visa OWNER TO postgres; -- -- Name: valider_compte_payement_visa_id_valider_compte_pay_visa_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.valider_compte_payement_visa_id_valider_compte_pay_visa_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.valider_compte_payement_visa_id_valider_compte_pay_visa_seq OWNER TO postgres; -- -- Name: valider_compte_payement_visa_id_valider_compte_pay_visa_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.valider_compte_payement_visa_id_valider_compte_pay_visa_seq OWNED BY public.valider_compte_payement_visa.id_valider_compte_pay_visa; -- -- Name: airtime id_airtime; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.airtime ALTER COLUMN id_airtime SET DEFAULT nextval('public.airtime_id_airtime_seq'::regclass); -- -- Name: api id_api; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.api ALTER COLUMN id_api SET DEFAULT nextval('public.api_id_api_seq'::regclass); -- -- Name: app_client id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.app_client ALTER COLUMN id SET DEFAULT nextval('public.app_client_id_seq'::regclass); -- -- Name: application id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.application ALTER COLUMN id SET DEFAULT nextval('public.application_id_seq'::regclass); -- -- Name: cash id_cash; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.cash ALTER COLUMN id_cash SET DEFAULT nextval('public.cash_id_cash_seq'::regclass); -- -- Name: decaisser id_decaisser; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.decaisser ALTER COLUMN id_decaisser SET DEFAULT nextval('public.decaisser_id_decaisser_seq'::regclass); -- -- Name: error_code id_error_code; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.error_code ALTER COLUMN id_error_code SET DEFAULT nextval('public.error_code_id_error_code_seq'::regclass); -- -- Name: error_code_type id_error_code_type; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.error_code_type ALTER COLUMN id_error_code_type SET DEFAULT nextval('public.error_code_type_id_error_code_type_seq'::regclass); -- -- Name: evenement id_evenement; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.evenement ALTER COLUMN id_evenement SET DEFAULT nextval('public.evenement_id_evenement_seq'::regclass); -- -- Name: membre id_membre; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.membre ALTER COLUMN id_membre SET DEFAULT nextval('public.membre_id_membre_seq'::regclass); -- -- Name: parametre id_parametre; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.parametre ALTER COLUMN id_parametre SET DEFAULT nextval('public.parametre_id_parametre_seq'::regclass); -- -- Name: partenaire id_partenaire; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.partenaire ALTER COLUMN id_partenaire SET DEFAULT nextval('public.partenaire_id_partenaire_seq'::regclass); -- -- Name: payement_visa id_payement_visa; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.payement_visa ALTER COLUMN id_payement_visa SET DEFAULT nextval('public.payement_visa_id_payement_visa_seq'::regclass); -- -- Name: possible_values id_possible_value; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.possible_values ALTER COLUMN id_possible_value SET DEFAULT nextval('public.possible_values_id_possible_value_seq'::regclass); -- -- Name: profile id_profile; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.profile ALTER COLUMN id_profile SET DEFAULT nextval('public.profile_id_profile_seq'::regclass); -- -- Name: reponse_param id_reponse_param; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.reponse_param ALTER COLUMN id_reponse_param SET DEFAULT nextval('public.reponse_param_id_reponse_param_seq'::regclass); -- -- Name: session id_session; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session ALTER COLUMN id_session SET DEFAULT nextval('public.session_id_session_seq'::regclass); -- -- Name: session_tontine id_session_tontine; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine ALTER COLUMN id_session_tontine SET DEFAULT nextval('public.session_tontine_id_session_tontine_seq'::regclass); -- -- Name: session_tontine_transaction id_session_tontine_transaction; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine_transaction ALTER COLUMN id_session_tontine_transaction SET DEFAULT nextval('public.session_tontine_transaction_id_session_tontine_transaction_seq'::regclass); -- -- Name: test_visa_foreign id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.test_visa_foreign ALTER COLUMN id SET DEFAULT nextval('public.test_visa_foreign_id_seq'::regclass); -- -- Name: tontine id_tontine; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tontine ALTER COLUMN id_tontine SET DEFAULT nextval('public.tontine_id_tontine_seq'::regclass); -- -- Name: transaction id_transaction; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.transaction ALTER COLUMN id_transaction SET DEFAULT nextval('public.transaction_id_transaction_seq'::regclass); -- -- Name: type_action id_type_action; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.type_action ALTER COLUMN id_type_action SET DEFAULT nextval('public.type_action_id_type_action_seq'::regclass); -- -- Name: type_reponse id_type_reponse; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.type_reponse ALTER COLUMN id_type_reponse SET DEFAULT nextval('public.type_reponse_id_type_reponse_seq'::regclass); -- -- Name: type_transaction id_type_transaction; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.type_transaction ALTER COLUMN id_type_transaction SET DEFAULT nextval('public.type_transaction_id_type_transaction_seq'::regclass); -- -- Name: utilisateur id_user; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.utilisateur ALTER COLUMN id_user SET DEFAULT nextval('public.utilisateur_id_user_seq'::regclass); -- -- Name: valider_compte_payement_visa id_valider_compte_pay_visa; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.valider_compte_payement_visa ALTER COLUMN id_valider_compte_pay_visa SET DEFAULT nextval('public.valider_compte_payement_visa_id_valider_compte_pay_visa_seq'::regclass); -- -- Data for Name: airtime; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.airtime (id_airtime, created_at, created_by, modified_at, modified_by, montant, numero, statut, partenaire_id_partenaire, libelle) FROM stdin; 5 2024-12-12 14:37:20.965 admin 2024-12-12 14:37:20.965 admin 300 89362840 INITIEE 3 chapchap \. -- -- Data for Name: api; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.api (id_api, created_at, created_by, modified_at, modified_by, description, libelle, managed_entity, methode, type_retour, url, action_id_type_action, partenaire_id_partenaire, reponse_id_type_reponse, response_param_id_reponse_param, response_param_id_api) FROM stdin; 4 2022-09-01 10:38:51.88 admin 2022-09-01 13:08:10.799 admin Récupérer le token d'authentification Authentification AUTHENTIFICATION POST Object auth/oauth2/token 3 3 1 \N \N 3 2022-08-31 18:00:50.072 admin 2022-08-31 18:00:50.072 admin Payer les frais Paiement PAIEMENT POST objet merchant/v1/payments/ 3 3 \N 5 \N 6 2022-09-16 12:46:51.643 admin 2022-09-16 12:46:51.643 admin RETOURNER LE STATUT D'UNE TXN TXN_STATUS PAIEMENT GET object standard/v1/payments 2 3 1 \N \N 8 2024-09-24 12:01:14.448 admin 2024-09-27 17:11:56.79 admin payement de disbursements disbur-payement DECAISSEMENT POST json standard/v3/disbursements 3 3 1 \N \N 15 2024-10-08 15:27:43.047 admin 2024-10-08 15:27:43.047 admin cash in CAHS IN CASHIN POST json standard/v2/cashin/ 3 3 1 \N \N 20 2024-11-21 11:10:16.475 admin 2024-11-21 11:10:16.475 admin test test VISA POST JSON forexrates/v2/foreignexchangerates 3 6 1 \N \N 14 2024-10-03 14:39:04.277 admin 2024-11-29 10:18:40.049 admin Remboursement Remboursement REMBOURSEMENT POST json standard/v1/payments/refund 3 3 1 \N \N 22 2024-11-30 12:04:35.611 admin 2024-11-30 12:10:32.275 admin CASHOUT CAHSOUT CASHOUT POST json standard/v2/cashout/ 3 3 1 \N \N 18 2024-10-31 09:08:19.378 admin 2024-11-30 12:11:53.021 admin recharge unité Airtel AIRTIME AIRTIME POST jason airtime/recharge/v2/sell_product 3 3 1 \N \N 21 2024-11-23 13:23:55.157 admin 2025-01-30 16:19:25.305 admin envoi par visa envoi par visa PUSH_VISA POST json visadirect/fundstransfer/v1/pushfundstransactions 3 6 1 \N \N \. -- -- Data for Name: app_client; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.app_client (id, created_at, created_by, modified_at, modified_by, libelle, nom, nom_entreprise, nom_representant, numero_entreprise, numero_representant, user_id, email_entreprise) FROM stdin; 2 2022-08-31 10:49:06.497 admin 2022-08-31 10:50:39.309 admin \N nom Client nomE nomR numE numR 3 emailE 3 2022-08-31 10:51:19.303 admin 2022-08-31 10:51:19.303 admin \N nn rt rtn rt rtns 4 rt 5 2022-09-02 14:30:03.075 admin 2022-09-02 14:30:03.075 admin \N BeTicket BeIt Bako 98793379 98793379 6 beit@gmail.com \. -- -- Data for Name: application; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.application (id, created_at, created_by, modified_at, modified_by, cle_public, description, logo, nom, user_id_user) FROM stdin; 1 2022-12-30 17:02:23.236 admin 2022-12-30 17:02:23.236 admin \N Application de gestion des ateliers e2122d19-6500-4aff-ab3c-e64c8e6e3dc6-undraw_creative_draft_vb5x.png BeTailor 1 2 2022-12-30 17:13:39.524 admin 2022-12-30 17:13:39.524 admin \N Sawki est une plateforme de vente en ligne 581a924d-3263-46bc-9b43-f2587d15584a-undraw_Real_time_sync_re_nky7.png Sawki 1 3 2022-12-30 17:31:25.057 admin 2022-12-30 17:31:25.057 admin \N Application de gestion de stock 9cb82e99-7f33-4037-b7bb-2f9a6f55c2ff-undraw_Web_developer_re_h7ie.png BeStock 1 4 2023-01-07 12:11:50.357 admin 2023-01-07 12:11:50.357 admin \N Application de gestion médicale 373379fb-c531-4038-b061-e1de20100f6e-undraw_Thought_process_re_om58.png BeMedical 1 5 2023-01-13 09:44:03.882 Abou 2023-01-13 09:44:03.882 Abou \N Plateforme destinée au commerce électronique 2e153de4-6df5-49f7-b755-ffdc56eda56d-logo_new.png SAWKI 8 \. -- -- Data for Name: cash; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.cash (id_cash, created_at, created_by, modified_at, modified_by, code, libelle, montant, nom_client, numero, prenom_client, response_enquiry, statut, type_cash, partenaire_id_partenaire) FROM stdin; 1 2024-10-15 12:02:22.653 admin 2024-10-15 12:02:22.653 admin NK cashout 100 Rido 98793379 Seydou \N INITIEE 3 2 2024-10-16 12:24:08.077 admin 2024-10-16 12:24:08.077 admin IJ43 PAYEMENT CASH 100 RIDO 98793379 SEYDOU \N INITIEE 3 3 2024-10-18 15:18:11.763 admin 2024-10-18 15:18:11.763 admin UBI978 paiement 100 Bako 98793379 Adamou \N INITIEE 3 4 2025-01-15 13:02:49.212 admin 2025-01-15 13:02:49.212 admin uig12 frais 100 Bako 98793379 Adamou \N INITIEE 3 6 2025-01-15 14:38:21.292 admin 2025-01-15 14:38:21.292 admin 354sd in 100 Maimouna 98793379 Moctar \N INITIEE CASHIN 3 7 2025-01-15 16:24:54.933 admin 2025-01-15 16:24:54.933 admin gbrg rnvoi 100 Abou 98793379 Sayabou \N INITIEE CASHOUT 3 8 2025-01-15 16:26:04.927 admin 2025-01-15 16:26:04.927 admin gbrg rnvoi 100 Abou 98793379 Sayabou \N INITIEE CASHOUT 3 9 2025-02-10 14:38:00.879 admin 2025-02-10 14:38:00.879 admin grt payement 100 Bako 98793379 Adamou \N INITIEE CASHOUT 3 10 2025-02-10 14:38:56.704 admin 2025-02-10 14:38:56.704 admin vgfb payement 100 Bako 98793379 Adamou \N INITIEE CASHIN 3 \. -- -- Data for Name: decaisser; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.decaisser (id_decaisser, created_at, created_by, modified_at, modified_by, code, comtpe_destinateur, libelle_decaisser, montant, nom_client, numero, prenom_client, response_enquiry, statut, app_client_id, evenement_id_evenement, partenaire_id_partenaire, type_transaction_id_type_transaction) FROM stdin; \. -- -- Data for Name: error_code; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.error_code (id_error_code, code, description, error_code_type_id_error_code_type) FROM stdin; 1 ROUTEUR001 Le portefeuille n'est pas configuré – Votre portefeuille d'application n'est pas configuré. Nous ne pouvons donc pas traiter votre demande. 1 2 ROUTEUR003 Paramètres d'en-tête/corps manquants : la demande a échoué car l'en-tête ou le corps de la demande obligatoire est manquant. 1 3 ROUTEUR005 Route nationale non configurée – La demande a échoué car la route nationale n'est pas configurée. Veuillez contacter le support client. 1 4 ROUTEUR006 Pays non valide – La demande a échoué en raison d'une valeur incorrecte du code de pays dans la demande 1 5 ROUTEUR007 Utilisateur non autorisé – Vous n'êtes pas autorisé à effectuer des opérations dans le pays indiqué. Nous ne pouvons donc pas traiter votre demande. 1 6 ROUTEUR112 Devise non valide – La demande a échoué en raison d'un code de devise incorrect dans la demande. 1 7 ROUTEUR114 Erreur lors de la validation du code PIN – La demande a échoué en raison d'une erreur survenue lors de la validation du code PIN dans la demande 1 8 ROUTEUR115 Code PIN incorrect – La demande a échoué en raison d'un code PIN incorrect dans la demande 1 9 ROUTEUR116 Code PIN chiffré incorrect – La valeur chiffrée du code PIN est incorrecte. Veuillez vérifier le mécanisme de chiffrement. La demande a échoué. 1 10 ROUTEUR117 Délai d'attente de la demande dépassé – La demande a expiré. En cas de paiement/remboursement, veuillez effectuer une demande de transaction ; sinon, réessayez plus tard. 1 11 ROUTEUR119 Devise non valide/manquante – La demande a échoué en raison d'une devise non valide ou manquante dans les paramètres de la demande. 1 13 200 Request Accepted. 4 14 401 Unauthorized Request 4 15 403 Forbidden Request. 4 16 404 Resource Not Found. 4 17 400 Mauvaise demande – Votre demande n’est pas valide. 5 18 401 Non autorisé – Votre clé API ou votre jeton porteur est incorrect. 5 19 403 Interdit – L’élément demandé est masqué pour les administrateurs uniquement. 5 20 404 Introuvable – Le chemin spécifié n’a pas pu être trouvé. 5 21 405 Méthode non autorisée – Vous avez essayé d’accéder à un chemin avec une méthode non valide. 5 22 408 Délai de lecture expiré – La demande a expiré. En cas de paiement/remboursement, veuillez effectuer une demande de transaction ; sinon, réessayez plus tard. 5 23 429 Trop de demandes – Vous faites trop de demandes ! Ralentissez. 5 24 500 Erreur interne du serveur – Nous avons rencontré un problème avec notre serveur. Réessayez plus tard. 5 25 502 Mauvaise passerelle - En cas de paiement/remboursement, veuillez effectuer une demande de transaction ; sinon, réessayez plus tard. 5 26 503 Service indisponible – Nous sommes temporairement hors ligne pour maintenance. Veuillez réessayer plus tard. 5 27 504 Délai d'expiration de la passerelle - En cas de paiement/remboursement, veuillez effectuer une demande de transaction ; sinon, réessayez plus tard. 5 28 0000900 La transaction peut être dans un état ambigu. Veuillez vérifier le code de réponse pour connaître le statut exact ou effectuer une demande de transaction. 3 29 ESB000001 Une erreur s'est produite. La demande peut être dans un état ambigu, veuillez effectuer une demande de transaction. 3 30 ESB000004 Une erreur s'est produite lors du lancement du paiement. La demande peut être dans un état ambigu, veuillez effectuer une demande de transaction. 3 31 ESB000008 Erreur de validation du champ. La demande peut être dans un état ambigu, veuillez effectuer une demande de transaction. 3 32 ESB000010 La demande a été un succès. 3 33 ESB000011 La demande a échoué. 3 34 ESB000014 Une erreur s'est produite lors de la récupération du statut de la transaction. La demande peut être dans un état ambigu, veuillez effectuer une demande de transaction après un certain temps. 3 35 ESB000033 La demande a échoué en raison d'une longueur MSISDN non valide. Veuillez réessayer avec la demande correcte. 3 36 ESB000034 La demande a échoué en raison d'un nom de pays non valide. Veuillez réessayer avec une demande correcte. 3 37 ESB000035 La demande a échoué en raison d'un code de devise non valide. Veuillez réessayer avec la demande correcte. 3 38 ESB000036 La demande a échoué car elle est d'une longueur MSISDN non valide ou ne commence pas par 0. Veuillez réessayer avec la demande correcte. 3 39 ESB000039 Le fournisseur n'est pas configuré pour effectuer une transaction dans le pays fourni. Veuillez réessayer avec la demande correcte. 3 40 ESB000041 Une transaction avec un ID de transaction externe existe déjà. Veuillez réessayer avec la demande correcte. 3 41 ESB000045 \t Aucune transaction trouvée avec l'ID de transaction fourni. 3 42 DP01000001000 Ambiguë 6 43 DP01000001001 Succès 6 44 DP01000001002 Code PIN incorrect 6 45 DP01000001003 Dépasse la ou les limites du montant de retrait / Limite du montant de retrait dépassée 6 46 DP01000001004 Montant invalide 6 47 DP01000001005 Échoué 6 48 DP01000001006 En cours 6 49 DP01000001007 Fonds insuffisants 6 50 DP01000001008 Utilisateur non autorisé 6 51 DP01000001009 Initié invalide 6 52 DP01000001010 Non autorisé 6 53 DP01000001011 N'honore pas 6 54 DP01000001012 Numéro de portable invalide 6 55 DP01000001013 Échec / Refusé 6 56 DP01000001014 La transaction a expiré 6 57 DP01000001015 Interdit 6 \. -- -- Data for Name: error_code_type; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.error_code_type (id_error_code_type, description, libelle_type_error, partenaire_id_partenaire) FROM stdin; 1 code courant Codes d'erreur courants 3 3 erreur specifique Code d'erreur spécifiques au produit 3 4 type types de reponse 3 5 erreur http code d'erreur HTTP 3 6 *** response_code 3 \. -- -- Data for Name: evenement; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.evenement (id_evenement, created_at, created_by, modified_at, modified_by, bouton, description, libelle, lien, photo_url, user_id_user) FROM stdin; 1 2022-12-09 17:05:13.772 admin 2022-12-09 17:05:13.772 admin Faire un dont Dont aux ophélins test Dont aux orphélins aa8c962a-3954-4987-8959-586584db78de-undraw_Co-working_re_w93t.png 1 2 2022-12-10 14:14:36.908 admin 2022-12-10 14:14:36.908 admin Cotiser Cotisation decembre Cotisation mensuelle 6dfae2d8-3374-45c5-ab97-003702aa0d3c-undraw_creative_draft_vb5x.png 1 3 2022-12-24 22:03:05.643 admin 2022-12-24 22:03:05.643 admin Achter ticket GDGDG\nDHBHDBHDù\nDBhbd Concert Alradik 8525254c-ba5d-4771-a4d0-ea0bca2cbe25-undraw_Team_spirit_re_yl1v.png \N 4 2022-12-27 00:06:16.063 Issamouss 2022-12-27 00:06:16.063 Issamouss Faire un dont Campage de dont aux orphélins Don aux orphélins c0bb4db4-17f3-4cde-9f8c-811062850c16-undraw_Developer_activity_re_39tg.png 7 5 2022-12-27 00:18:41.75 Issamouss 2022-12-27 00:18:41.75 Issamouss Cotiser Mata masu dubara Asusu d77d1224-585f-40d4-8a8e-61252c1b7ac7-undraw_Co-working_re_w93t.png 7 6 2023-01-13 00:03:45.677 Abou 2023-01-13 00:03:45.677 Abou Faire un don C'est une activité caritative qui consiste à venir en aide aide aux ophélins Collect pour ophélins a762cc07-8486-406c-8e25-74abbf347cb1-undraw_Our_solution_re_8yk6.png 8 7 2023-01-13 00:48:47.596 admin 2023-01-13 00:48:47.596 admin Faire un don Description Collecte de fonds pour les ophelins e81542e3-6709-43a8-a469-9d3922c2ad02-undraw_Bus_stop_re_h8ej.png 1 8 2023-01-13 09:22:37.203 Abou 2023-01-13 09:22:37.203 Abou Faire un don Description Collecte Agagi Karkara b214dabf-3e61-4bf6-9089-0625e1758c71-undraw_Developer_activity_re_39tg.png 8 \. -- -- Data for Name: membre; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.membre (id_membre, created_at, created_by, modified_at, modified_by, adresse, code, email, nom, numero_identite, prenom, statut, telephone) FROM stdin; 4 2023-01-11 21:22:42.67 admin 2023-01-11 21:22:42.67 admin Koubia 3 2465 issa.moussa@gmail.com Issa 17/AN/1002 Moussa f 90010203 5 2023-01-11 21:31:36.119 admin 2023-01-11 21:31:36.119 admin YANTALA GANDA 1668 abou@beitniger.com Abou 20/DRPN/A001 Sayabou f 90107074 6 2023-01-13 09:25:00.828 Abou 2023-01-13 09:25:00.828 Abou Magaria 1962 moutari.sanoussi@gmai.com Moutari 20/DRPN/2002 Sanoussi f 98601628 7 2023-01-13 09:25:54.139 Abou 2023-01-13 09:25:54.139 Abou Arlit 5505 saley.farid@gmai.com Saley 20/DRPN/ART/1002 Farida f 90292093 \. -- -- Data for Name: membres_tontines; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.membres_tontines (id_tontine, id_membre) FROM stdin; 1 4 1 5 3 6 3 7 \. -- -- Data for Name: parametre; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.parametre (id_parametre, created_at, created_by, modified_at, modified_by, key, ordre, value, api_id_api, has_children, parent_id, niveau, description, code_type, type_param, type) FROM stdin; 388 2024-11-29 09:50:03.062 admin 2024-11-29 09:50:20.615 admin data 0 3 t \N 1 2 Response \N 365 2024-11-29 09:23:13.389 admin 2024-12-05 08:12:50.256 admin Content-Type 1 application/json 4 f \N 0 1 Header \N 535 2024-12-06 11:26:19.876 admin 2024-12-06 11:26:19.913 admin Accept 0 */* 6 f \N 1 1 Header \N 379 2024-11-29 09:45:31.663 admin 2024-11-29 09:45:54.002 admin subscriber 0 3 t \N 1 Subscriber. 0 RequestBody \N 383 2024-11-29 09:47:34.675 admin 2024-11-29 09:47:55.641 admin transaction 0 3 t \N 1 0 RequestBody \N 536 2024-12-06 11:28:02.741 admin 2024-12-06 11:28:02.748 admin X-Country 0 NE 6 f \N 1 1 Header \N 398 2024-11-29 10:06:56.955 admin 2024-11-29 10:15:47.914 admin initiatingPartyId 0 1002 20 f \N 1 0 RequestBody \N 399 2024-11-29 10:07:20.373 admin 2024-11-29 10:16:00.665 admin rateProductCode 0 BANK 20 f \N 1 0 RequestBody \N 400 2024-11-29 10:07:34.347 admin 2024-11-29 10:16:10.967 admin destinationCurrencyCode 0 USD 20 f \N 1 0 RequestBody \N 401 2024-11-29 10:07:52.162 admin 2024-11-29 10:16:20.965 admin sourceCurrencyCode 0 EUR 20 f \N 1 0 RequestBody \N 402 2024-11-29 10:08:09.418 admin 2024-11-29 10:16:30.88 admin quoteIdRequired 0 true 20 f \N 1 0 RequestBody \N 537 2024-12-06 11:29:57.665 admin 2024-12-06 11:29:57.696 admin X-Currency 0 XOF 6 f \N 1 1 Header \N 551 2024-12-06 11:42:30.552 admin 2024-12-06 11:42:30.584 admin id 0 6 f 549 3 2 Response \N 561 2025-01-31 08:05:01.601 admin 2025-01-31 08:05:01.601 admin senderAddress 0 niamey 21 f \N 1 0 RequestBody \N 384 2024-11-29 09:47:55.057 admin 2024-12-05 08:25:21.545 admin amount 3 100 3 f 383 2 0 RequestBody \N 564 2025-01-31 08:17:07.252 admin 2025-01-31 08:17:07.252 admin panEntryMode 0 90 21 f 563 2 0 RequestBody \N 554 2024-12-06 11:43:42.916 admin 2024-12-06 11:44:01.282 admin status 0 6 t \N 1 Status response. 2 Response \N 380 2024-11-29 09:45:53.579 admin 2024-12-06 15:13:12.323 admin country 0 NE 3 f 379 2 0 RequestBody \N 411 2024-11-29 10:25:22.339 admin 2024-12-03 10:00:12.075 admin airtel_money_id 4 14 f 410 2 0 RequestBody \N 410 2024-11-29 10:25:01.919 admin 2024-12-03 10:00:12.329 admin transaction 0 14 t \N 1 0 RequestBody \N 381 2024-11-29 09:46:58.744 admin 2024-12-06 15:13:19.06 admin currency 0 XOF 3 f 379 2 0 RequestBody \N 426 2024-11-29 10:45:23.281 admin 2024-11-29 10:45:44.371 admin payee 0 8 t \N 1 0 RequestBody \N 428 2024-11-29 10:46:02.166 admin 2024-11-29 10:46:02.166 admin wallet_type 0 8 f 426 2 0 RequestBody \N 430 2024-11-29 10:46:44.357 admin 2024-11-29 10:46:44.357 admin pin 0 8 f \N 1 0 RequestBody \N 431 2024-11-29 10:47:12.918 admin 2024-11-29 10:47:32.495 admin transaction 0 8 t \N 1 0 RequestBody \N 433 2024-11-29 10:47:50.091 admin 2024-11-29 10:47:50.091 admin id 0 8 f 431 2 0 RequestBody \N 434 2024-11-29 10:48:11.383 admin 2024-11-29 10:48:11.383 admin type 0 8 f 431 2 0 RequestBody \N 566 2025-01-31 08:19:34.553 admin 2025-01-31 08:19:34.553 admin motoECIIndicator 0 0 21 f 563 2 0 RequestBody \N 593 2025-01-31 08:44:28.875 admin 2025-01-31 08:44:28.875 admin acquiringBin 0 408999 21 f \N 1 0 RequestBody \N 382 2024-11-29 09:47:18.282 admin 2024-12-06 15:04:35.524 admin msisdn 2 98793379 3 f 379 2 0 RequestBody \N 385 2024-11-29 09:48:18.568 admin 2024-12-06 15:13:27.464 admin country 0 NE 3 f 383 2 0 RequestBody \N 390 2024-11-29 09:50:58.217 admin 2024-11-29 09:50:58.217 admin id 0 3 f 389 3 2 Response \N 389 2024-11-29 09:50:20.129 admin 2024-11-29 09:50:58.828 admin transaction 0 3 t 388 2 2 Response \N 391 2024-11-29 09:51:20.58 admin 2024-11-29 09:51:20.58 admin status 0 3 f 389 3 2 Response \N 393 2024-11-29 09:53:27.453 admin 2024-11-29 09:53:27.453 admin code 0 3 f 392 2 2 Response \N 392 2024-11-29 09:52:01.378 admin 2024-11-29 09:53:28.758 admin status 0 3 t \N 1 Status Response. 2 Response \N 394 2024-11-29 09:53:47.308 admin 2024-11-29 09:53:47.308 admin message 0 3 f 392 2 2 Response \N 395 2024-11-29 09:54:39.664 admin 2024-11-29 09:54:39.664 admin result_code 0 3 f 392 2 2 Response \N 396 2024-11-29 09:55:32.528 admin 2024-11-29 09:55:32.528 admin response_code 1 3 f 392 2 2 Response \N 397 2024-11-29 09:55:52.6 admin 2024-11-29 09:55:52.6 admin success 0 3 f 392 2 2 Response \N 412 2024-11-29 10:26:11.956 admin 2024-11-29 10:26:45.551 admin data 0 14 t \N 1 2 Response \N 417 2024-11-29 10:29:23.696 admin 2024-11-29 10:29:23.696 admin code 0 14 f 416 2 2 Response \N 386 2024-11-29 09:48:36.969 admin 2024-12-06 15:13:35.846 admin currency 0 XOF 3 f 383 2 0 RequestBody \N 596 2025-01-31 08:46:43.659 admin 2025-01-31 08:46:43.659 admin senderStateCode 0 NE 21 f \N 1 0 RequestBody \N 387 2024-11-29 09:48:57.974 admin 2024-12-07 15:53:07.947 admin id 4 91 3 f 383 2 0 RequestBody \N 599 2025-01-31 08:47:47.457 admin 2025-01-31 08:47:47.457 admin businessApplicationId 0 AA 21 f \N 1 0 RequestBody \N 601 2025-01-31 08:48:30.119 admin 2025-01-31 08:48:30.119 admin merchantCategoryCode 0 6012 21 f \N 1 0 RequestBody \N 606 2025-01-31 08:50:50.173 admin 2025-02-01 15:05:24.605 admin senderAccountNumber 3 4957040000000001 21 f \N 1 0 RequestBody \N 598 2025-01-31 08:47:31.505 admin 2025-02-01 15:05:24.632 admin senderName 9 BAKO ADAMOU 21 f \N 1 0 RequestBody \N 560 2025-01-31 07:57:22.92 admin 2025-02-01 15:05:24.571 admin amount 1 20000 21 f \N 1 0 RequestBody \N 594 2025-01-31 08:45:44.882 admin 2025-01-31 11:11:43.783 admin retrievalReferenceNumber 0 412770452025 21 f \N 1 0 RequestBody \N 460 2024-11-30 11:30:32.284 admin 2025-02-10 14:38:56.713 admin reference 1 payement 15 f \N 1 0 RequestBody \N 376 2024-11-29 09:42:35.303 admin 2024-11-29 09:42:35.303 admin X-Currency 0 XOF 3 f \N 1 1 Header \N 440 2024-11-29 10:51:45.642 admin 2024-11-29 10:51:45.642 admin status 0 8 f 436 3 2 Response \N 441 2024-11-29 10:52:12.929 admin 2024-11-29 10:52:12.929 admin message 0 8 f 436 3 2 Response \N 438 2024-11-29 10:51:07.473 admin 2024-11-29 10:51:07.473 admin airtel_money_id 0 8 f 436 3 0 RequestBody \N 550 2024-12-06 11:42:09.557 admin 2024-12-06 11:42:09.586 admin airtel_money_id 0 6 f 549 3 2 Response \N 377 2024-11-29 09:43:01.735 admin 2024-12-07 15:53:15.094 admin Authorization 1 bearer c3Rc23NRfBj3C08eN35toSty63mVr1Yt 3 f \N 1 1 Header \N 458 2024-11-30 11:27:07.481 admin 2025-02-10 14:38:56.761 admin id 4 10 15 f 456 2 0 RequestBody \N 538 2024-12-06 11:30:52.929 admin 2024-12-07 15:54:03.543 admin Authorization 1 bearer c3Rc23NRfBj3C08eN35toSty63mVr1Yt 6 f \N 1 1 Header \N 454 2024-11-30 11:25:31.53 admin 2024-11-30 11:25:50.291 admin subscriber 0 15 t \N 1 0 RequestBody \N 456 2024-11-30 11:26:06.481 admin 2024-11-30 11:26:24.518 admin transaction 0 15 t \N 1 0 RequestBody \N 459 2024-11-30 11:28:50.704 admin 2024-11-30 11:28:50.704 admin additional_info 0 15 f \N 1 0 RequestBody \N 461 2024-11-30 11:30:50.156 admin 2024-11-30 11:30:50.156 admin pin 0 15 f \N 1 0 RequestBody \N 455 2024-11-30 11:25:50.012 admin 2025-01-15 13:02:49.397 admin msisdn 2 98793379 15 f 454 2 0 RequestBody \N 457 2024-11-30 11:26:23.755 admin 2025-01-15 13:02:49.403 admin amount 3 100 15 f 456 2 0 RequestBody \N 600 2025-01-31 08:48:10.393 admin 2025-01-31 08:48:10.393 admin settlementServiceIndicator 0 9 21 f \N 1 0 RequestBody \N 432 2024-11-29 10:47:32.058 admin 2024-12-03 10:10:17.627 admin amount 3 8 f 431 2 0 RequestBody \N 429 2024-11-29 10:46:24.832 admin 2024-12-03 10:11:52.483 admin reference 1 8 f \N 1 0 RequestBody \N 439 2024-11-29 10:51:27.6 admin 2024-12-03 10:12:10.619 admin id 4 8 f 436 3 0 RequestBody \N 499 2024-11-30 12:34:23.172 admin 2024-11-30 12:34:23.172 admin payment_mode 0 18 f \N 1 0 RequestBody \N 500 2024-11-30 12:34:48.152 admin 2024-11-30 12:34:48.152 admin currency_code 0 18 f \N 1 0 RequestBody \N 501 2024-11-30 12:35:07.037 admin 2024-11-30 12:35:07.037 admin provisioning_msisdn 0 18 f \N 1 0 RequestBody \N 502 2024-11-30 12:35:34.127 admin 2024-11-30 12:35:34.127 admin payment_transaction_id 0 18 f \N 1 0 RequestBody \N 503 2024-11-30 12:35:49.626 admin 2024-11-30 12:35:49.626 admin requester 0 18 f \N 1 0 RequestBody \N 504 2024-11-30 12:36:03.341 admin 2024-11-30 12:36:03.341 admin product_code 0 18 f \N 1 0 RequestBody \N 505 2024-11-30 12:36:15.819 admin 2024-11-30 12:36:15.819 admin transaction_type 0 18 f \N 1 0 RequestBody \N 443 2024-11-29 10:53:15.598 admin 2024-11-29 10:53:15.598 admin response_code 1 8 f 442 2 2 Response \N 444 2024-11-29 10:53:31.182 admin 2024-11-29 10:53:31.182 admin code 0 8 f 442 2 2 Response \N 445 2024-11-29 10:53:50.77 admin 2024-11-29 10:53:50.77 admin success 0 8 f 442 2 2 Response \N 446 2024-11-29 10:54:11.544 admin 2024-11-29 10:54:11.544 admin message 0 8 f 442 2 2 Response \N 463 2024-11-30 11:32:48.792 admin 2024-11-30 11:32:48.792 admin message 0 15 f 462 2 2 Response \N 462 2024-11-30 11:32:26.974 admin 2024-11-30 11:32:49.304 admin data 0 15 t \N 1 2 Response \N 464 2024-11-30 11:33:03.95 admin 2024-11-30 11:33:03.95 admin status 0 15 f 462 2 2 Response \N 466 2024-11-30 11:33:48.091 admin 2024-11-30 11:33:48.091 admin airtel_money_id 0 15 f 465 3 2 Response \N 468 2024-11-30 11:34:32.611 admin 2024-11-30 11:34:57.719 admin status 0 15 t \N 1 2 Response \N 563 2025-01-31 08:16:11.072 admin 2025-01-31 08:17:09.342 admin pointOfServiceData 0 21 t \N 1 0 RequestBody \N 595 2025-01-31 08:46:22.187 admin 2025-01-31 10:26:29.747 admin senderCity 6 null 21 f \N 1 0 RequestBody \N 604 2025-01-31 08:49:37.324 admin 2025-01-31 11:13:40.898 admin senderCountryCode 0 124 21 f \N 1 0 RequestBody \N 562 2025-01-31 08:13:04.525 admin 2025-02-01 15:05:24.616 admin localTransactionDateTime 5 2025-02-01 21 f \N 1 0 RequestBody \N 451 2024-11-30 11:24:32.242 admin 2025-02-10 14:38:56.774 admin Authorization 1 bearer qO84cVTc6vBaFEza7U4cz59SurAXPIn6 15 f \N 1 1 Header \N 407 2024-11-29 10:23:20.856 admin 2024-11-29 10:23:20.856 admin X-Country 0 NE 14 f \N 1 1 Header \N 403 2024-11-29 10:09:09.306 admin 2024-11-29 10:09:09.306 admin Accept 0 application/json 20 f \N 1 1 Header \N 404 2024-11-29 10:09:42.391 admin 2024-11-29 10:09:42.391 admin Content-Type 0 application/json 20 f \N 0 1 Header \N 405 2024-11-29 10:21:50.966 admin 2024-11-29 10:21:50.966 admin Accept 0 */* 14 f \N 1 1 Header \N 406 2024-11-29 10:22:57.644 admin 2024-11-29 10:22:57.644 admin Content-Type 0 application/json 14 f \N 1 1 Header \N 408 2024-11-29 10:23:40.652 admin 2024-11-29 10:23:40.652 admin X-Currency 0 XOF 14 f \N 1 1 Header \N 409 2024-11-29 10:24:04.099 admin 2024-11-29 10:24:04.099 admin Authorization 1 14 f \N 1 1 Header \N 421 2024-11-29 10:43:24.672 admin 2024-11-29 10:43:24.672 admin Content-Type 0 application/json 8 f \N 1 1 Header \N 425 2024-11-29 10:44:53.515 admin 2024-11-29 10:44:53.515 admin Authorization 1 8 f \N 1 1 Header \N 422 2024-11-29 10:43:49.627 admin 2024-11-29 10:43:49.627 admin Accept 0 */* 8 f \N 1 1 Header \N 424 2024-11-29 10:44:32.895 admin 2024-11-29 10:44:32.895 admin X-Currency 0 XOF 8 f \N 1 1 Header \N 447 2024-11-30 11:22:52.836 admin 2024-11-30 11:22:52.836 admin Content-Type 0 application/json 15 f \N 1 1 Header \N 448 2024-11-30 11:23:35.972 admin 2024-11-30 11:23:35.972 admin Accept 0 */* 15 f \N 1 1 Header \N 449 2024-11-30 11:23:55.558 admin 2024-11-30 11:23:55.558 admin X-Country 0 NE 15 f \N 1 1 Header \N 450 2024-11-30 11:24:11.402 admin 2024-11-30 11:24:11.402 admin X-Currency 0 XOF 15 f \N 1 1 Header \N 452 2024-11-30 11:24:44.544 admin 2024-11-30 11:24:44.544 admin x-signature 0 15 f \N 1 1 Header \N 453 2024-11-30 11:24:57.533 admin 2024-11-30 11:24:57.533 admin x-key 0 15 f \N 1 1 Header \N 494 2024-11-30 12:31:36.255 admin 2024-11-30 12:31:36.255 admin x-country 0 NE 18 f \N 1 1 Header \N 495 2024-11-30 12:32:54.609 admin 2024-11-30 12:32:54.609 admin x-currency 0 XOF 18 f \N 1 1 Header \N 496 2024-11-30 12:33:08.981 admin 2024-11-30 12:33:08.981 admin Authorization 0 18 f \N 1 1 Header \N 423 2024-11-29 10:44:13.167 admin 2024-11-29 10:44:13.167 admin X-Country 0 NE 8 f \N 1 1 Header \N 507 2024-11-30 12:36:59.343 admin 2024-11-30 12:38:03.858 admin data 0 18 t \N 1 2 Response \N 509 2024-11-30 12:38:19.651 admin 2024-11-30 12:38:19.651 admin airtel_money_id 0 18 f 508 3 2 Response \N 508 2024-11-30 12:38:03.53 admin 2024-11-30 12:38:19.964 admin transaction 0 18 t 507 2 2 Response \N 549 2024-12-06 11:41:38.558 admin 2024-12-06 11:42:09.89 admin transaction 0 6 t 548 2 2 Response \N 553 2024-12-06 11:43:18.146 admin 2024-12-06 11:43:18.165 admin status 0 6 f 549 3 2 Response \N 565 2025-01-31 08:18:45.53 admin 2025-01-31 08:18:45.53 admin posConditionCode 0 00 21 f 563 2 0 RequestBody \N 414 2024-11-29 10:28:16.673 admin 2024-11-29 10:28:16.673 admin airtel_money_id 0 14 f 413 3 2 Response \N 413 2024-11-29 10:26:45.138 admin 2024-11-29 10:28:17.244 admin transaction 0 14 t 412 2 2 Response \N 415 2024-11-29 10:28:47.41 admin 2024-11-29 10:28:47.41 admin status 0 14 f 413 3 Possible status: SUCCESS. 2 Response \N 416 2024-11-29 10:29:08.402 admin 2024-11-29 10:29:24.091 admin status 0 14 t \N 1 2 Response \N 418 2024-11-29 10:29:43.053 admin 2024-11-29 10:29:43.053 admin message 0 14 f 416 2 2 Response \N 419 2024-11-29 10:29:59.99 admin 2024-11-29 10:29:59.99 admin result_code 1 14 f 416 2 2 Response \N 420 2024-11-29 10:30:16.681 admin 2024-11-29 10:30:16.681 admin success 0 14 f 416 2 2 Response \N 435 2024-11-29 10:49:45.267 admin 2024-11-29 10:50:09.885 admin data 0 8 t \N 1 2 Response \N 437 2024-11-29 10:50:46.431 admin 2024-11-29 10:50:46.431 admin reference_id 0 8 f 436 3 2 Response \N 436 2024-11-29 10:50:09.282 admin 2024-11-29 10:50:46.996 admin transaction 0 8 t 435 2 2 Response \N 465 2024-11-30 11:33:25.746 admin 2024-11-30 11:33:48.782 admin transaction 0 15 t 462 2 2 Response \N 467 2024-11-30 11:34:08.469 admin 2024-11-30 11:34:08.469 admin id 0 15 f 462 3 2 Response \N 469 2024-11-30 11:34:56.954 admin 2024-11-30 11:34:56.954 admin code 0 15 f 468 2 2 Response \N 470 2024-11-30 11:35:15.093 admin 2024-11-30 11:35:15.093 admin message 0 15 f 468 2 2 Response \N 471 2024-11-30 11:35:31.759 admin 2024-11-30 11:35:31.759 admin response_code 0 15 f 468 2 2 Response \N 472 2024-11-30 11:35:50.308 admin 2024-11-30 11:35:50.308 admin success 0 15 f 468 2 2 Response \N 548 2024-12-06 11:41:15.406 admin 2024-12-06 11:41:38.917 admin data 0 6 t \N 1 2 Response \N 552 2024-12-06 11:42:55.618 admin 2024-12-06 11:42:55.647 admin message 0 6 f 549 3 2 Response \N 569 2025-01-31 08:23:05.868 admin 2025-01-31 08:23:05.868 admin addValueTaxReturn 0 10 21 f 568 2 0 RequestBody \N 568 2025-01-31 08:21:52.564 admin 2025-01-31 08:23:06.524 admin colombiaNationalServiceData 0 21 t \N 1 0 RequestBody \N 585 2025-01-31 08:38:03.004 admin 2025-01-31 10:26:29.76 admin county 7 Niger 21 f 582 3 0 RequestBody \N 567 2025-01-31 08:20:45.578 admin 2025-01-31 11:04:09.936 admin recipientPrimaryAccountNumber 0 4060320000000127 21 f \N 1 0 RequestBody \N 555 2024-12-06 11:44:00.742 admin 2024-12-06 11:44:00.745 admin code 0 6 f 554 2 2 Response \N 570 2025-01-31 08:24:18.697 admin 2025-01-31 08:24:18.697 admin taxAmountConsumption 0 10 21 f 568 2 taxe de la comsomation de l'api 0 RequestBody \N 576 2025-01-31 08:32:40.298 admin 2025-01-31 08:32:40.298 admin nationalChargebackReason 0 11 21 f 568 2 0 RequestBody \N 578 2025-01-31 08:33:35.076 admin 2025-01-31 08:33:35.076 admin nationalNetMiscAmountType 0 A 21 f 568 2 0 RequestBody \N 579 2025-01-31 08:34:03.674 admin 2025-01-31 08:34:03.674 admin costTransactionIndicator 0 0 21 f 568 2 0 RequestBody \N 556 2024-12-06 11:44:24.497 admin 2024-12-06 11:44:24.528 admin message 0 6 f 554 2 2 Response \N 557 2024-12-06 11:44:44.738 admin 2024-12-06 11:44:44.768 admin result_code 0 6 f 554 2 2 Response \N 571 2025-01-31 08:25:14.041 admin 2025-01-31 08:25:14.041 admin nationalNetReimbursementFeeBaseAmount 0 20 21 f 568 2 0 RequestBody \N 574 2025-01-31 08:31:02.928 admin 2025-01-31 08:31:02.928 admin nationalNetMiscAmount 0 10 21 f 568 2 0 RequestBody \N 577 2025-01-31 08:33:02.898 admin 2025-01-31 08:33:02.898 admin emvTransactionIndicator 0 1 21 f 568 2 0 RequestBody \N 580 2025-01-31 08:34:27.836 admin 2025-01-31 08:34:27.836 admin nationalReimbursementFee 0 20 21 f 568 2 0 RequestBody \N 581 2025-01-31 08:34:44.157 admin 2025-01-31 08:35:00.844 admin cardAcceptor 0 21 t \N 1 0 RequestBody \N 582 2025-01-31 08:35:00.419 admin 2025-01-31 08:35:54.599 admin address 0 21 t 581 2 0 RequestBody \N 587 2025-01-31 08:40:11.412 admin 2025-01-31 08:40:11.412 admin idCode 0 CA-IDCode-77765 21 f 581 2 0 RequestBody \N 366 2024-11-29 09:23:55.043 admin 2024-12-05 08:13:01.542 admin Accept 2 */* 4 f \N 0 1 Header \N 370 2024-11-29 09:30:29.511 admin 2024-12-05 08:14:01.208 admin access_token 1 4 f \N 1 2 Response \N 371 2024-11-29 09:31:20.974 admin 2024-12-05 08:14:09.508 admin expires_in 2 4 f \N 1 2 Response \N 372 2024-11-29 09:31:36.641 admin 2024-12-05 08:14:20.001 admin token_type 3 4 f \N 1 2 Response \N 367 2024-11-29 09:25:16.361 admin 2024-12-05 08:22:17.849 admin client_id 1 7b9e0597-7ab2-4e52-9b78-a7cb0a7d843f 4 f \N 1 0 RequestBody \N 373 2024-11-29 09:41:27.241 admin 2024-11-29 09:41:27.241 admin Accept 0 */* 3 f \N 1 1 Header \N 374 2024-11-29 09:41:50.721 admin 2024-11-29 09:41:50.721 admin Content-Type 0 application/json 3 f \N 1 1 Header \N 492 2024-11-30 12:13:08.889 admin 2024-11-30 12:13:08.889 admin Content-Type 0 application/json 18 f \N 1 1 Header \N 493 2024-11-30 12:13:32.974 admin 2024-11-30 12:13:32.974 admin Accept 0 application/json 18 f \N 1 1 Header \N 368 2024-11-29 09:27:19.628 admin 2024-12-05 08:22:45.964 admin client_secret 2 753c8081-a2d8-4192-b97e-f0dcf26417a1 4 f \N 1 0 RequestBody \N 369 2024-11-29 09:29:38.053 admin 2024-12-05 08:23:24.042 admin grant_type 3 client_credentials 4 f \N 1 0 RequestBody \N 558 2024-12-06 11:45:06.513 admin 2024-12-06 11:45:06.543 admin response_code 1 6 f 554 2 2 Response \N 559 2024-12-06 11:45:26.389 admin 2024-12-06 11:45:26.419 admin success 0 6 f 554 2 2 Response \N 572 2025-01-31 08:25:36.378 admin 2025-01-31 08:25:36.378 admin addValueTaxAmount 0 10 21 f 568 2 0 RequestBody \N 573 2025-01-31 08:26:00.395 admin 2025-01-31 08:26:00.395 admin nationalNetMiscAmount 0 10 21 f 568 2 0 RequestBody \N 575 2025-01-31 08:32:13.028 admin 2025-01-31 08:32:13.028 admin countryCodeNationalService 0 170 21 f 568 2 0 RequestBody \N 584 2025-01-31 08:37:37.463 admin 2025-01-31 08:37:37.463 admin zipCode 0 94404 21 f 582 3 0 RequestBody \N 588 2025-01-31 08:40:50.58 admin 2025-01-31 08:40:50.58 admin name 0 Niamey 21 f 581 2 0 RequestBody \N 583 2025-01-31 08:35:54.041 admin 2025-01-31 10:26:29.767 admin country 7 Niger 21 f 582 3 0 RequestBody \N 586 2025-01-31 08:39:01.542 admin 2025-01-31 10:57:38.702 admin state 0 null 21 f 582 3 0 RequestBody \N 375 2024-11-29 09:42:15.117 admin 2024-11-29 09:42:15.117 admin X-Country 0 NE 3 f \N 1 1 Header \N 589 2025-01-31 08:41:23.171 admin 2025-01-31 08:41:23.171 admin terminalId 0 TID-9999 21 f 581 2 0 RequestBody \N 442 2024-11-29 10:52:54.716 admin 2024-11-29 10:53:16.135 admin status 0 8 t \N 1 status 2 Response \N 590 2025-01-31 08:41:54.888 admin 2025-01-31 08:41:54.888 admin senderReference 0 21 f \N 1 0 RequestBody \N 516 2024-11-30 12:54:22.179 admin 2024-11-30 12:54:22.179 admin Content-Type 0 application/json 22 f \N 1 1 Header \N 592 2025-01-31 08:43:50.549 admin 2025-01-31 08:43:50.549 admin acquirerCountryCode 0 227 21 f \N 1 0 RequestBody \N 597 2025-01-31 08:47:05.891 admin 2025-01-31 08:47:05.891 admin systemsTraceAuditNumber 0 451018 21 f \N 1 0 RequestBody \N 602 2025-01-31 08:48:51.638 admin 2025-01-31 08:48:51.638 admin transactionCurrencyCode 0 XOF 21 f \N 1 0 RequestBody \N 603 2025-01-31 08:49:11.062 admin 2025-01-31 08:49:11.062 admin recipientName 0 BEIT 21 f \N 1 0 RequestBody \N 605 2025-01-31 08:49:58.213 admin 2025-01-31 08:49:58.213 admin sourceOfFundsCode 0 05 21 f \N 1 0 RequestBody \N 530 2024-11-30 13:01:17.787 admin 2025-02-10 14:38:00.942 admin reference 1 payement 22 f \N 1 0 RequestBody \N 528 2024-11-30 12:59:54.937 admin 2025-02-10 14:38:00.969 admin id 4 9 22 f 526 2 0 RequestBody \N 520 2024-11-30 12:55:38.34 admin 2025-02-10 14:38:03.022 admin Authorization 1 bearer qO84cVTc6vBaFEza7U4cz59SurAXPIn6 22 f \N 1 1 Header \N 378 2024-11-29 09:45:04.505 admin 2024-12-07 15:53:07.947 admin reference 1 TESTPAIEMENT 3 f \N 1 0 RequestBody \N 524 2024-11-30 12:58:19.844 admin 2024-11-30 12:58:45.625 admin subscriber 0 22 t \N 1 0 RequestBody \N 526 2024-11-30 12:59:15.665 admin 2024-11-30 12:59:39.124 admin transaction 0 22 t \N 1 0 RequestBody \N 529 2024-11-30 13:01:02.451 admin 2024-11-30 13:01:02.451 admin additional_info 0 22 f \N 1 0 RequestBody \N 497 2024-11-30 12:33:37.018 admin 2024-12-12 14:37:20.972 admin amount 1 300 18 f \N 1 0 RequestBody \N 591 2025-01-31 08:42:47.155 admin 2025-02-01 15:05:24.639 admin transactionIdentifier 10 9 21 f \N 1 0 RequestBody \N 427 2024-11-29 10:45:43.714 admin 2024-12-03 10:10:03.505 admin msisdn 2 8 f 426 2 0 RequestBody \N 506 2024-11-30 12:36:29.826 admin 2024-12-03 10:15:17.852 admin reference_number 2 18 f \N 1 0 RequestBody \N 517 2024-11-30 12:54:46.251 admin 2024-11-30 12:54:46.251 admin Accept 0 application/json 22 f \N 1 1 Header \N 518 2024-11-30 12:55:02.262 admin 2024-11-30 12:55:02.262 admin X-Country 0 NE 22 f \N 1 1 Header \N 519 2024-11-30 12:55:22.334 admin 2024-11-30 12:55:22.334 admin X-Currency 0 XOF 22 f \N 1 1 Header \N 521 2024-11-30 12:55:55.599 admin 2024-11-30 12:55:55.599 admin x-signature 0 22 f \N 1 1 Header \N 522 2024-11-30 12:56:38.257 admin 2024-11-30 12:56:38.257 admin x-signature 0 22 f \N 1 1 Header \N 523 2024-11-30 12:57:46.439 admin 2024-11-30 12:57:46.439 admin x-key 0 22 f \N 1 1 Header \N 510 2024-11-30 12:38:50.995 admin 2024-11-30 12:38:50.995 admin id 0 18 f 508 3 2 Response \N 511 2024-11-30 12:39:15.427 admin 2024-11-30 12:39:15.427 admin status 0 18 f 508 3 2 Response \N 513 2024-11-30 12:39:53.579 admin 2024-11-30 12:39:53.579 admin message 0 18 f \N 2 2 Response \N 514 2024-11-30 12:40:15.031 admin 2024-11-30 12:40:15.031 admin response_code 0 18 f 512 2 2 Response \N 512 2024-11-30 12:39:38.997 admin 2024-11-30 12:40:15.388 admin status 0 18 t \N 1 Status response. 2 Response \N 515 2024-11-30 12:40:33.311 admin 2024-11-30 12:40:33.311 admin success 0 18 f 512 2 2 Response \N 532 2024-11-30 13:02:37.186 admin 2024-11-30 13:02:37.186 admin id 0 22 f 531 2 2 Response \N 531 2024-11-30 13:02:06.636 admin 2024-11-30 13:02:37.681 admin data 0 22 t \N 1 2 Response \N 533 2024-11-30 13:02:57.313 admin 2024-11-30 13:02:57.313 admin status 0 22 f 531 2 2 Response \N 534 2024-11-30 13:03:14.478 admin 2024-11-30 13:03:14.478 admin status 0 22 f \N 1 status 2 Response \N 525 2024-11-30 12:58:45.103 admin 2025-01-15 14:09:09.853 admin msisdn 2 98793379 22 f 524 2 0 RequestBody \N 527 2024-11-30 12:59:38.748 admin 2025-01-15 14:09:09.855 admin amount 3 100 22 f 526 2 0 RequestBody \N \. -- -- Data for Name: partenaire; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.partenaire (id_partenaire, created_at, created_by, modified_at, modified_by, adresse_physique, base_url, email, login, nif, nom_compagnie, password, photo_url, rccm, telephone, logo) FROM stdin; 2 2022-08-30 15:57:40.6 admin 2022-08-30 15:57:40.6 admin addresse baseUrl ppp@gmail.com login nif Partenaire1 password \N rccm 11111111 \N 5 2022-12-13 23:37:06.382 admin 2022-12-17 13:46:03.404 admin money.moov.africa/openapi moov@moov.ne Moov Money \N 94004003 9d349c7a-bd7c-4317-97ad-82bc9a9caf32-Flooz-benin-vers-togo.png 3 2022-08-31 17:45:13.364 admin 2022-12-17 19:34:43.014 admin Zone Industrielle de Niamey https://openapi.airtel.africa/ contact@airtel.ne 7b9e0597-7ab2-4e52-9b78-a7cb0a7d843f Airtel Money 753c8081-a2d8-4192-b97e-f0dcf26417a1 \N 97777203 f1ee54cd-a296-42cd-9fc9-67321326ca60-logo_airtel_money.png 6 2024-11-21 11:08:41.326 admin 2024-11-21 11:08:41.326 admin Eur https://sandbox.api.visa.com/ visa@gmail.com admin azerty VISA admin \N azerty 1234 \N \. -- -- Data for Name: payement_visa; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.payement_visa (id_payement_visa, created_at, created_by, modified_at, modified_by, amount, card_number, cvv, expiry, card_num_dest, card_num_exp, city, country, name, telephone) FROM stdin; 8 2025-01-31 11:14:29.863 admin 2025-01-31 11:14:29.863 admin 100 \N 123 12/25 \N 4060320000000126 \N Niger Ridouane Seydou Djermakoye 89362840 9 2025-02-01 15:05:24.405 admin 2025-02-01 15:05:24.405 admin 20000 \N 234 12/25 \N 4957040000000001 \N Niger BAKO ADAMOU 22798793379 \. -- -- Data for Name: possible_values; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.possible_values (id_possible_value, message, value, response_param_id_reponse_param) FROM stdin; 3 echec failed 1 5 Code invalide DP00800001002 5 6 Solde insuffisant DP00800001003 5 7 montant doit être supérieur à 100fr DP00800001004 5 4 Transaction effectuée avec succès DP00800001006 5 12 Vous n'avez pas saisie votre code airtel money DP00800001005 5 2 Non valide Non Ok 4 17 Succès SUCCESS 11 18 ECHEC FAILED 11 19 Succès SUCCESS 11 20 ECHEC FAILED 11 21 Transaction effectuée avec succès ! DP00800001001 12 22 Code saisi incorrect DP00800001002 12 23 Vous ne disposez pas assez de fond pour effectuer cette opération DP00800001003 12 24 L'ID de la transaction est incorrecte DP00800001005 12 25 Votre transaction est en attente de validation DP00800001006 12 26 Transaction effectuée avec succès ! DP00800001001 12 27 Code saisi incorrect DP00800001002 12 28 Vous ne disposez pas assez de fond pour effectuer cette opération DP00800001003 12 29 L'ID de la transaction est incorrecte DP00800001005 12 30 Votre transaction est en attente de validation DP00800001006 12 31 OK 55 13 32 OK 55 13 33 Success DP01000001001 14 34 \tIncorrect Pin DP01000001002 14 35 Dépasse(s) la limite du montant du retrait / La limite du montant du retrait est dépassée DP01000001003 14 36 Invalid Amount\t DP01000001004 14 37 Failed DP01000001005 14 38 In Process DP01000001006 14 39 Insufficient Funds DP01000001007 14 40 User Not Allowed DP01000001008 14 41 Initiatee Invalid DP01000001009 14 42 Not Permitted DP01000001010 14 43 Do Not Honour DP01000001011 14 44 Invalid Mobile Number DP01000001012 14 45 Failed / Refused DP01000001013 14 46 Transaction Timed Out DP01000001014 14 47 Forbidden DP01000001015 14 48 Invalid Mobile Number DP01000001012 14 49 Do Not Honour DP01000001011 14 50 User Not Allowed DP01000001008 14 51 Success DP01000001001 14 52 Not Permitted DP01000001010 14 53 Initiatee Invalid DP01000001009 14 54 Failed / Refused DP01000001013 14 55 \tIncorrect Pin DP01000001002 14 56 Transaction Timed Out DP01000001014 14 57 Forbidden DP01000001015 14 58 In Process DP01000001006 14 60 Invalid Amount\t DP01000001004 14 59 Failed DP01000001005 14 61 Dépasse(s) la limite du montant du retrait / La limite du montant du retrait est dépassée DP01000001003 14 62 Insufficient Funds DP01000001007 14 63 echec DP00900001002 23 64 echec DP00900001002 23 65 AMBIGUOUS DP00800001000 30 66 INCORRECT PIN DP00800001002 30 67 exceeds withdrawal amount limit DP00800001003 30 68 INVALED AMOUNT DP00800001004 30 69 TRANSACTION ID IS INVALED DP00800001005 30 70 IN PROCESS DP00800001006 30 71 NOT ENOUGH BALANCE DP00800001007 30 72 REFUSED DP00800001008 30 73 TRANSACTION NOT PERMITTED TO PAYEE DP00800001010 30 74 TRANSACTION TIMED OUT DP00800001024 30 75 TRANSACTION NOT FOUND DP00800001025 30 76 TRANSACTION NOT FOUND DP00800001025 30 77 FORBIDDEN DP00800001026 30 78 TRANSACTION EXPIRED DP00800001029 30 79 Ambiguous DP00900001000 29 80 Success DP00900001001 29 81 Maximum transaction limit reached DP00900001003 29 82 Invalid Amount DP00900001004 29 83 Failed DP00900001005 29 84 In progress DP00900001006 29 85 Insufficient Funds DP00900001007 29 86 Invalid Initiatee DP00900001009 29 87 User Not Allowed DP00900001010 29 88 Invalid Mobile Numer DP00900001012 29 89 Transaction not Found DP00900001015 29 90 Duplicate Transaction Id DP00900001017 29 91 Forbidden DP00900001018 29 92 Success DP00800001001 30 95 Une erreur s'est produite lors du lancement du paiement. La demande peut être dans un état ambigu, veuillez effectuer une demande de transaction. ESB000004 31 97 Erreur de validation du champ. La demande peut être dans un état ambigu, veuillez effectuer une demande de transaction. ESB000008 31 93 La demande a été un succès. ESB000010 31 96 Une erreur s'est produite. La demande peut être dans un état ambigu, veuillez effectuer une demande de transaction. ESB000001 31 98 La demande a échoué. ESB000011 31 99 Une erreur s'est produite lors de la récupération du statut de la transaction. La demande peut être dans un état ambigu, veuillez effectuer une demande de transaction après un certain temps. ESB000014 31 101 Ambiguous DP01000001000 32 102 Success DP01000001001 32 103 Incorrect Pin DP01000001002 32 104 Exceeds withdrawal amount limit(s) / Withdrawal amount limit exceeded DP01000001003 32 105 Invalid Amount DP01000001004 32 106 Failed DP01000001005 32 107 In Process DP01000001006 32 108 Insufficient Funds DP01000001007 32 117 User Not Allowed DP01000001008 32 118 Initiatee Invalid DP01000001009 32 119 Not Permitted DP01000001010 32 120 Do Not Honour DP01000001011 32 121 Invalid Mobile Number DP01000001012 32 122 32 123 Failed / Refused DP01000001013 32 124 Transaction Timed Out DP01000001014 32 125 Forbidden DP01000001015 32 126 In process DP00800001006 33 127 Success DP00800001001 33 128 Ambiguous DP00800001000 33 129 Ambiguous DP01630001000 34 130 Failed Transaction\t DP01630001005 34 131 Transaction In Progress DP01630001006 34 132 Transaction Not Found DP01630001011 34 133 Transaction Id Already Exists DP01630001017 34 134 Invalid Input DP01630001018 34 135 34 136 34 137 Failed Transaction\t DP01630001005 34 138 Ambiguous DP01630001000 34 139 34 140 Transaction In Progress DP01630001006 34 141 Transaction Not Found DP01630001011 34 142 Invalid Input DP01630001018 34 143 Transaction Id Already Exists DP01630001017 34 \. -- -- Data for Name: profile; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.profile (id_profile, created_at, created_by, modified_at, modified_by, nom_profile) FROM stdin; 1 \N \N \N \N admin 2 2022-08-30 17:52:08.779 admin 2022-08-30 17:52:08.779 admin User 3 2022-12-26 23:42:07.67 admin 2022-12-26 23:42:07.67 admin Client \. -- -- Data for Name: reponse_param; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.reponse_param (id_reponse_param, key, value, id_api) FROM stdin; 1 status success 2 4 Sucess Ok 2 5 response_code DP00800001006 3 11 STATUS SUCCESS 2 12 response_code DP00800001006 5 13 10RT 404 \N 14 Ambiguous DP01000001000 \N 15 Ambiguous DP01000001000 \N 16 In progress DP00900001006 \N 17 In progress DP00900001006 \N 18 In progress DP00900001006 \N 19 \N 20 response_code DP00900001001 \N 21 response_code DP00900001001 \N 22 response_code DP00900001001 \N 23 response_code DP00900001001 \N 28 response_code DP0000010008 \N 29 response_code DP00900001001 8 30 response_code DP00800001001 6 31 result_code ESB000010 14 32 Success DP01000001001 15 33 response_code DP00800001001 14 34 DP01630001001 Success Transaction 18 \. -- -- Data for Name: session; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.session (id_session, created_at, created_by, modified_at, modified_by, expire_date, is_current, token, compagnie_id_partenaire, partenaire_id_partenaire, token_type) FROM stdin; 1 2022-09-01 16:57:16.956 admin 2022-09-01 17:00:02.363 admin 2022-09-01T17:00:16.899095300 f QqS9U7PYsKtCiWscVpGpW6GRMFebsKuS \N 3 \N 2 2022-09-01 17:00:02.331 admin 2022-09-01 17:59:01.193 admin 2022-09-01T17:03:02.272095500+0000 f clMEPsM7dyi8DrEuU9BR7CWg8tsDFGAi \N 3 \N 3 2022-09-01 17:59:01.139 admin 2022-09-02 11:27:12.558 admin 2022-09-01T18:02:01.060656800+0000 f rBQtwNpFLDIYBexlAqTAw0CTei7Rh5V4 \N 3 bearer 4 2022-09-02 11:27:12.532 admin 2022-09-02 11:31:47.222 admin 2022-09-02T11:30:12.476912500+0000 f dQEd7es1uuHQfTInDcMlVRD1D9qXMCRK \N 3 bearer 5 2022-09-02 11:31:47.203 admin 2022-09-02 11:41:56.69 admin 2022-09-02T11:34:47.136622100+0000 f 6tIiNe69gdxi6c7zSijgUiVq2micQBwj \N 3 bearer 6 2022-09-02 11:41:56.665 admin 2022-09-02 11:46:02.755 admin 2022-09-02T11:44:56.612361700+0000 f ifIxYBtZvy2bU2wiAeTm6VxuycvIIZcK \N 3 bearer 7 2022-09-02 11:46:02.731 admin 2022-09-02 11:50:34.388 admin 2022-09-02T11:49:02.675461200+0000 f QNLSoXEhlZjnCVtpznHZhB1LRAL272Y0 \N 3 bearer 8 2022-09-02 11:50:34.369 admin 2022-09-02 12:08:52.253 admin 2022-09-02T11:53:34.298402400+0000 f kWCIt9Y7LbAejdsK34r0IalI3wMMe7iU \N 3 bearer 9 2022-09-02 12:08:52.232 admin 2022-09-02 12:28:43.017 admin 2022-09-02T12:11:52.172134500+0000 f 5RhrEjMxWh02WCFHHptt0XOQeBx0CCRz \N 3 bearer 10 2022-09-02 12:28:42.998 admin 2022-09-02 12:41:35.687 admin 2022-09-02T12:31:42.938976+0000 f 047xsYs0M9BEvvK68iDIftiieAAoyL2o \N 3 bearer 11 2022-09-02 12:41:35.673 admin 2022-09-02 13:04:05.201 admin 2022-09-02T12:44:35.645610+0000 f zAN2ijOpn2B1Fn8YMqyGnRBzHY94QlTq \N 3 bearer 12 2022-09-02 13:04:05.195 admin 2022-09-02 14:49:18.995 admin 2022-09-02T13:07:05.168419200+0000 f IZVPGP7RIMQ6faE1E0Y4ybv5hz2aQMlg \N 3 bearer 13 2022-09-02 14:49:18.987 admin 2022-09-02 14:56:04.452 admin 2022-09-02T14:52:18.938822900+0000 f Oi8yosRbGD2ae1zASSIFLEgl7TQtVw0l \N 3 bearer 14 2022-09-02 14:56:04.447 admin 2022-09-05 15:22:28.955 admin 2022-09-02T14:59:04.441718400+0000 f 4kkVO7OeExgstEUECL04B0ZGX4P5VcNu \N 3 bearer 15 2022-09-05 15:22:28.95 admin 2022-09-05 15:28:59.259 admin 2022-09-05T15:25:28.929578+0000 f rowU7IXGXaM6MFNmqFxEHJ5nZ6T71jGj \N 3 bearer 16 2022-09-05 15:28:59.25 admin 2022-09-05 15:32:24.4 admin 2022-09-05T15:31:59.190582600+0000 f HWIDJmlOBSw24pgMVPADB8cGFg9LEuZt \N 3 bearer 17 2022-09-05 15:32:24.381 admin 2022-09-05 15:38:05.99 admin 2022-09-05T15:35:24.315980300+0000 f 3y6qsYdZczHPDgjFYagggBsF6zYXnJIT \N 3 bearer 18 2022-09-05 15:38:05.964 admin 2022-09-05 15:42:13.054 admin 2022-09-05T15:41:05.900415500+0000 f TKXFH9XMA07x8FeGsbbHr8U99IhMYuAr \N 3 bearer 19 2022-09-05 15:42:13.041 admin 2022-09-05 15:45:57.767 admin 2022-09-05T15:45:13.020334700+0000 f RohWW0QWHAtCowheZHgvh2U02JrAzwaG \N 3 bearer 20 2022-09-05 15:45:57.746 admin 2022-09-05 15:50:07.483 admin 2022-09-05T15:48:57.702955200+0000 f TuS4pkRN0jnRfLCjIWuqMFJlYJsdbzSX \N 3 bearer 21 2022-09-05 15:50:07.461 admin 2022-09-05 17:19:20.825 admin 2022-09-05T15:53:07.395655+0000 f VpIJRl2Sad1W51l2qyOdYNoSejxFQq91 \N 3 bearer 22 2022-09-05 17:19:20.804 admin 2022-09-05 17:23:19.617 admin 2022-09-05T17:22:20.738559400+0000 f cKyM5mn3qlkhe96dKTHugGNio1m64K3v \N 3 bearer 23 2022-09-05 17:23:19.598 admin 2022-09-05 17:51:50.625 admin 2022-09-05T17:26:19.538366500+0000 f 32p0NDlnAT8Zi6TIxVh1DDxvgRSQOJjq \N 3 bearer 24 2022-09-05 17:51:50.588 admin 2022-09-05 17:57:03.95 admin 2022-09-05T17:54:50.540906300+0000 f 2d8vVMfV6zdF4kJlFbZQpl00T0VUubvp \N 3 bearer 25 2022-09-05 17:57:03.915 admin 2022-09-05 18:06:28.075 admin 2022-09-05T18:00:03.858107800+0000 f XUusE5GdxScvayEdmlj4tg6KxXEm4ndT \N 3 bearer 26 2022-09-05 18:06:28.06 admin 2022-09-09 11:36:45.537 admin 2022-09-05T18:09:28.031849600+0000 f vqYITxDT5z6KZKcCuh5RFKG6WHOrBzH6 \N 3 bearer 27 2022-09-09 11:36:45.531 admin 2022-09-09 11:51:40.185 admin 2022-09-09T11:39:45.505760600+0000 f gJJRdlmUAwZBjOVP28kmPevWpz4DMfe1 \N 3 bearer 28 2022-09-09 11:51:40.18 admin 2022-09-09 11:59:10.992 admin 2022-09-09T11:54:40.155417800+0000 f NAneMQVPkQE98xGTr9O99iH8c639rUrh \N 3 bearer 29 2022-09-09 11:59:10.988 admin 2022-09-09 12:11:25.351 admin 2022-09-09T12:02:10.956118600+0000 f aOZT0kg0R4nx7KEWYMQ0lL3eVhh24spQ \N 3 bearer 30 2022-09-09 12:11:25.347 admin 2022-09-09 12:15:00.066 admin 2022-09-09T12:14:25.331821100+0000 f qUtGqEPjJJcQxD9gBRan3YLQ5riMZGib \N 3 bearer 31 2022-09-09 12:15:00.062 admin 2022-09-09 12:30:01.704 admin 2022-09-09T12:18:00.047412800+0000 f SRFjUYEWCd0Qxc1jqyMD61NFgQTwEfWy \N 3 bearer 32 2022-09-09 12:30:01.701 admin 2022-09-09 12:34:09.908 admin 2022-09-09T12:33:01.686898500+0000 f hUS5BbN2cQXtYsFYFUaS0N6eCIFnz9Rt \N 3 bearer 33 2022-09-09 12:34:09.901 admin 2022-09-09 12:40:26.548 admin 2022-09-09T12:37:09.874434600+0000 f xAFr3lnPhCQPf5kEuFiqZ1eq1itfjB25 \N 3 bearer 34 2022-09-09 12:40:26.544 admin 2022-09-09 12:43:31.405 admin 2022-09-09T12:43:26.522196600+0000 f MEBGGxzgIUtuF2RdwKyprj5doKOe2Nri \N 3 bearer 35 2022-09-09 12:43:31.398 admin 2022-09-09 12:46:36.923 admin 2022-09-09T12:46:31.371926900+0000 f h8b4knDVu2KYIrqnShzM5R36aTf4mauw \N 3 bearer 36 2022-09-09 12:46:36.913 admin 2022-09-09 12:50:48.355 admin 2022-09-09T12:49:36.884574300+0000 f kD6IIOYOzACPQ3UOd0QSLYx65VDFxaGS \N 3 bearer 37 2022-09-09 12:50:48.346 admin 2022-09-09 12:54:22.878 admin 2022-09-09T12:53:48.315568200+0000 f 0wcdZP5g92Bjz1DQtwrlu4XFjvr8oIdq \N 3 bearer 38 2022-09-09 12:54:22.872 admin 2022-09-09 13:03:39.223 admin 2022-09-09T12:57:22.841254500+0000 f PPQKJlSmDwjEZYmqBTz5bav2yBAVLQuc \N 3 bearer 39 2022-09-09 13:03:39.218 admin 2022-09-09 13:54:26.122 admin 2022-09-09T13:06:39.191833500+0000 f IJ3AkmlyOrHLJDYKK2hH3i0x1ziZYyLK \N 3 bearer 40 2022-09-09 13:54:26.116 admin 2022-09-09 13:58:09.418 admin 2022-09-09T13:57:26.090799300+0000 f FfeKVrHfeeuJe5V2klb3PVfQdyjxJbLY \N 3 bearer 41 2022-09-09 13:58:09.414 admin 2022-09-09 14:05:50.068 admin 2022-09-09T14:01:09.396448+0000 f wSnSC7gUd97TWz2DwaggCjEPAkLCzLrR \N 3 bearer 42 2022-09-09 14:05:50.062 admin 2022-09-09 15:21:47.907 admin 2022-09-09T14:08:50.039036800+0000 f toXMXg9k08JQBmAj4i5IxVLNqf7BiuBG \N 3 bearer 43 2022-09-09 15:21:47.9 admin 2022-09-09 15:26:53.258 admin 2022-09-09T15:24:47.874532900+0000 f lWvgHQVYIHE613ruLpkDRhAPFFBGJca3 \N 3 bearer 44 2022-09-09 15:26:53.25 admin 2022-09-09 16:13:06.458 admin 2022-09-09T15:29:53.224763700+0000 f BDmJqB4Ggdy29GH2TaPPEQ4CeX6QICm6 \N 3 bearer 45 2022-09-09 16:13:06.452 admin 2022-09-09 16:16:08.507 admin 2022-09-09T16:16:06.433057+0000 f ZvLSaJH57gPATGxRd180WdnQzsuoPJQa \N 3 bearer 46 2022-09-09 16:16:08.498 admin 2022-09-09 16:54:50.197 admin 2022-09-09T16:19:08.476545600+0000 f ubge1XHR7aakKABGazMG7qE3TgcVWoWY \N 3 bearer 47 2022-09-09 16:54:50.193 admin 2022-09-09 16:58:10.48 admin 2022-09-09T16:57:50.132197600+0000 f jhoyJJ8RzRDbBSDVvQPPwdUOi8F682xP \N 3 bearer 49 2022-09-09 17:14:54.69 admin 2022-09-09 17:23:49.209 admin 2022-09-09T17:17:54.662010500+0000 f 6FkD1PXiqFeHoBGhQz1LzQjMckoNkF2u \N 3 bearer 48 2022-09-09 16:58:10.471 admin 2022-09-09 17:14:54.697 admin 2022-09-09T17:01:10.448192300+0000 f TtXjVhDi4z6sb6OK1NfFudOC2QqX6JU5 \N 3 bearer 50 2022-09-09 17:23:49.204 admin 2022-09-09 17:27:37.851 admin 2022-09-09T17:26:49.175219900+0000 f GlWpvtiiGl404bGsziSSnfHmUxFmYtRi \N 3 bearer 51 2022-09-09 17:27:37.841 admin 2022-09-09 18:00:53.195 admin 2022-09-09T17:30:37.810949+0000 f 75Ph7SvbfOLuEk0ICwHWmIjWj5yUHV2a \N 3 bearer 52 2022-09-09 18:00:53.191 admin 2022-09-09 18:05:15.58 admin 2022-09-09T18:03:53.176053100+0000 f 83OveOW9y3rjkEaSPvc1VhjqE9yvvjSp \N 3 bearer 53 2022-09-09 18:05:15.573 admin 2022-09-09 18:09:06.953 admin 2022-09-09T18:08:15.542339100+0000 f gFcPN9vsy6XuK975529RpkGSnwn1w2lQ \N 3 bearer 54 2022-09-09 18:09:06.947 admin 2022-09-09 18:19:00.694 admin 2022-09-09T18:12:06.927126800+0000 f um0kgyHHhiDoA4Y9GLbCSRguwY0bn7zg \N 3 bearer 55 2022-09-09 18:19:00.686 admin 2022-09-09 18:22:50.502 admin 2022-09-09T18:22:00.663671100+0000 f bTRo173uFXOdJtN2OnhTdZ4YQ66Qh2r6 \N 3 bearer 56 2022-09-09 18:22:50.498 admin 2022-09-12 11:29:49.946 admin 2022-09-09T18:25:50.471857500+0000 f K5lflJcvxYKW7tJbKRFmwtB5gNADrMpS \N 3 bearer 57 2022-09-12 11:29:49.938 admin 2022-09-12 11:37:20.432 admin 2022-09-12T11:32:49.919423900+0000 f yWiGnNLx4n5aUdGxZSaKUs17WBWpjVXe \N 3 bearer 58 2022-09-12 11:37:20.426 admin 2022-09-12 11:52:28.271 admin 2022-09-12T11:40:20.418444200+0000 f GczJrMrhcv2HlvF931VWyntNuS71s2OO \N 3 bearer 59 2022-09-12 11:52:28.265 admin 2022-09-12 11:55:54.78 admin 2022-09-12T11:55:28.259891+0000 f 9ZvsKTcT9JAkoI2ycqRFBAbCC2hbPsXn \N 3 bearer 60 2022-09-12 11:55:54.771 admin 2022-09-12 11:59:11.727 admin 2022-09-12T11:58:54.747018900+0000 f 3T1Xg6bOMJKjGwQ8stewp0HZ08DTlP8l \N 3 bearer 61 2022-09-12 11:59:11.722 admin 2022-09-12 12:04:15.495 admin 2022-09-12T12:02:11.704724600+0000 f 16EgEIh215q7thNCJ5itsFYChIX5SPDm \N 3 bearer 62 2022-09-12 12:04:15.49 admin 2022-09-12 12:07:23.487 admin 2022-09-12T12:07:15.466750200+0000 f ALpY9EryU67jb95KEOjC5Kh6S34TWKl5 \N 3 bearer 63 2022-09-12 12:07:23.457 admin 2022-09-12 12:19:13.683 admin 2022-09-12T12:10:23.401370600+0000 f MHQSitmnYDRHZSIXvKE2GhlHXCaAUTjQ \N 3 bearer 64 2022-09-12 12:19:13.675 admin 2022-09-12 13:20:58.271 admin 2022-09-12T12:22:13.655633500+0000 f MqIPtj3iVUrLNHj2TzsYv47rFEZ6ni6h \N 3 bearer 65 2022-09-12 13:20:58.253 admin 2022-09-12 14:08:07.021 admin 2022-09-12T13:23:58.230338700+0000 f TN44O3prgpFnO0pYisdy8DAtL5hP2kDJ \N 3 bearer 66 2022-09-12 14:08:07.013 admin 2022-09-12 14:19:56.218 admin 2022-09-12T14:11:07.006678100+0000 f x3BhBTuBO44Q4pAC5NcwQVIhwi4C4SPy \N 3 bearer 67 2022-09-12 14:19:56.207 admin 2022-09-12 14:23:12.085 admin 2022-09-12T14:22:56.200131700+0000 f S6Pg6zfsYV7LT6sKY8D8EFXNH6Mnz9Tv \N 3 bearer 68 2022-09-12 14:23:12.082 admin 2022-09-12 14:37:19.235 admin 2022-09-12T14:26:12.080612800+0000 f 5d6c9WzDHgNckdHv5g4P8WftIf3p0CTZ \N 3 bearer 69 2022-09-12 14:37:19.227 admin 2022-09-12 15:26:06.377 admin 2022-09-12T14:40:19.223801500+0000 f 1y9kOqhqnFqJIogs220lBhAGyhFsy5R8 \N 3 bearer 70 2022-09-12 15:26:06.367 admin 2022-09-12 15:31:03.656 admin 2022-09-12T15:29:06.359468600+0000 f 2uboeBLCBbStflnZKQHZBPQBW0Lcj3gg \N 3 bearer 71 2022-09-12 15:31:03.651 admin 2022-09-12 15:37:33.586 admin 2022-09-12T15:34:03.607250600+0000 f ICcott364IWwUEbT5pkXGqPLQI8Gs0f5 \N 3 bearer 72 2022-09-12 15:37:33.581 admin 2022-09-12 16:24:27.725 admin 2022-09-12T15:40:33.535489+0000 f FN4XCv3WiHfq3YHZnIVFOH7nGrDd2N4c \N 3 bearer 73 2022-09-12 16:24:27.717 admin 2022-09-15 11:08:34.357 admin 2022-09-12T16:27:27.694061800+0000 f 8LFPRBvxLNXg2BFPooD9Zov33ESpSLJi \N 3 bearer 74 2022-09-15 11:08:34.35 admin 2022-09-15 11:34:48.157 admin 2022-09-15T11:11:34.313120400+0000 f URMurAVW1zZ9Uk2TiB90qICr8tvbRbdu \N 3 bearer 75 2022-09-15 11:34:48.157 admin 2022-09-15 14:57:59.259 admin 2022-09-15T11:37:48.140756800+0000 f KCFRj8aRZnRRGUAQenSCqYA3AipV8cRi \N 3 bearer 76 2022-09-15 14:57:59.244 admin 2022-09-15 15:16:06.421 admin 2022-09-15T15:00:59.228244400+0000 f OLisrjVZSnItLOwIHCD0JkPSiaL7hZc4 \N 3 bearer 77 2022-09-15 15:16:06.421 admin 2022-09-15 16:43:35.612 admin 2022-09-15T15:19:06.411338600+0000 f MN4zudKLXj62XCFwUFqxDabuXUlbZAyf \N 3 bearer 78 2022-09-15 16:43:35.61 admin 2022-09-15 16:47:33.366 admin 2022-09-15T16:46:35.596492800+0000 f kcYY5KiS3U5WN9XvySTecYXwkChEOlwH \N 3 bearer 79 2022-09-15 16:47:33.363 admin 2022-09-15 16:56:26.191 admin 2022-09-15T16:50:33.361452900+0000 f 2PC4UqHe7lxS0T2hQ4Z7uGblXJdNhlKI \N 3 bearer 80 2022-09-15 16:56:26.188 admin 2022-09-15 17:36:36.814 admin 2022-09-15T16:59:26.176348100+0000 f rqeebH2LcT4Yn09fBDWHrxFIlxBNSMvZ \N 3 bearer 81 2022-09-15 17:36:36.812 admin 2022-09-15 17:43:25.679 admin 2022-09-15T17:39:36.788851100+0000 f 7lscIlFnK4qFwbAVTpMOKdfjNhwaN6Ig \N 3 bearer 82 2022-09-15 17:43:25.663 admin 2022-09-15 17:47:23.432 admin 2022-09-15T17:46:25.663889400+0000 f E5irEeALtqr86QQoGUy55jKHA6ad67f1 \N 3 bearer 83 2022-09-15 17:47:23.432 admin 2022-09-15 17:51:35.214 admin 2022-09-15T17:50:23.401348200+0000 f FwBnWEq8ykcIC2vAYpZ3sRQ4rd5hfaB4 \N 3 bearer 84 2022-09-15 17:51:35.198 admin 2022-09-15 19:35:06.436 admin 2022-09-15T17:54:35.185800900+0000 f whlFgB91lryccBjNdUO6g85zRt3epihr \N 3 bearer 85 2022-09-15 19:35:06.431 admin 2022-09-15 19:45:50.275 admin 2022-09-15T19:38:06.429648600+0000 f UwLBR85fRnw0ydIcCCYVNX3wiyuLJmUy \N 3 bearer 86 2022-09-15 19:45:50.259 admin 2022-09-15 19:52:07.102 admin 2022-09-15T19:48:50.259760400+0000 f uE2i8qtNo6ShqMPLIdPWHxTxcxYlcrXm \N 3 bearer 87 2022-09-15 19:52:07.102 admin 2022-09-16 09:01:04.864 admin 2022-09-15T19:55:07.102260400+0000 f 8nHWMDsoew9Ogu6DiXNmirbAh1vZY7eY \N 3 bearer 88 2022-09-16 09:01:04.864 admin 2022-09-16 09:07:48.794 admin 2022-09-16T09:04:04.834748600+0000 f WLKziwNQko259vYRWsBhRUMrOPulqiY1 \N 3 bearer 89 2022-09-16 09:07:48.792 admin 2022-09-16 09:34:03.959 admin 2022-09-16T09:10:48.776004+0000 f 1E07dWqggB0hcX31HjAvx0eLdxXcucS0 \N 3 bearer 90 2022-09-16 09:34:03.959 admin 2022-09-16 09:48:15.692 admin 2022-09-16T09:37:03.959021500+0000 f WYKD0MUbBCNOEE3H9eQ56NDhJksLH7W3 \N 3 bearer 91 2022-09-16 09:48:15.688 admin 2022-09-16 10:03:47.749 admin 2022-09-16T09:51:15.660770800+0000 f YanoTSXPQdxAK7DRneAKl4csylhWw8I2 \N 3 bearer 92 2022-09-16 10:03:47.744 admin 2022-09-16 10:42:04.973 admin 2022-09-16T10:06:47.717128400+0000 f 5om37f13QPpO6wclPn0e9wrMeq83fj6Z \N 3 bearer 93 2022-09-16 10:42:04.961 admin 2022-09-17 20:29:30.678 admin 2022-09-16T10:45:04.941748100+0000 f SXuKFZxZJVVqJdNGUAS6pWnlIvsQh9Cz \N 3 bearer 94 2022-09-17 20:29:30.678 admin 2022-09-17 20:43:07.556 admin 2022-09-17T20:32:30.662652400+0000 f Fuci6SKQ37wiYpns4b0OjISL9ZBVDxaX \N 3 bearer 95 2022-09-17 20:43:07.55 admin 2022-09-17 20:48:51.648 admin 2022-09-17T20:46:07.534494+0000 f gfAYbMSJ9XZrq1Bo9l78hciI7XCq9T2Y \N 3 bearer 96 2022-09-17 20:48:51.648 admin 2022-09-17 20:55:59.493 admin 2022-09-17T20:51:51.631602900+0000 f 7skZpy6N5g9OV3hhS5PSafGp5pqQ78AL \N 3 bearer 97 2022-09-17 20:55:59.493 admin 2022-09-17 21:04:24.911 admin 2022-09-17T20:58:59.477900900+0000 f CbyRuWTBFQstjZUylQLdENox4nd36dGT \N 3 bearer 99 2022-09-19 14:27:03.825 admin 2022-09-19 15:08:56.025 admin 2022-09-19T14:30:03.815512600+0000 f 2isWrbIFGFzByqhbQ2P28t3IhuNsGXNR \N 3 bearer 98 2022-09-17 21:04:24.911 admin 2022-09-19 14:27:03.825 admin 2022-09-17T21:07:24.896083900+0000 f 012OuoFjtRdSuY4hb5d8s4x2cjaK0rdf \N 3 bearer 100 2022-09-19 15:08:56.02 admin 2022-09-20 19:47:06.936 admin 2022-09-19T15:11:56.018569600+0000 f 9wYEgBsnyaSNGaFr5cOdhSKYbcafpW1Q \N 3 bearer 101 2022-09-20 19:47:06.919 admin 2022-10-15 12:59:40.925 admin 2022-09-20T19:50:06.888153500+0000 f 83TvNBDifDJgEx7LhqMlRekafTGtwpXf \N 3 bearer 102 2022-10-15 12:59:40.913 admin 2022-12-17 19:24:29.095 admin 2022-10-15T13:02:40.877354800+0000 f hNN0J0gd4xenlGVUQ9lI9lCCyNCLf9MM \N 3 bearer 103 2022-12-17 19:24:29.081 admin 2022-12-17 19:35:42.858 admin 2022-12-17T19:27:29.063509400+0000 f d9Q564dcIpy4MEBxJ5AUkU40q4afPOUQ \N 3 bearer 104 2022-12-17 19:35:42.842 admin 2022-12-17 19:45:38.797 admin 2022-12-17T19:38:42.842591+0000 f LgfAdAvsf3MuByTFrFEUk3gOIdy7FB1p \N 3 bearer 105 2022-12-17 19:45:38.794 admin 2022-12-17 19:50:05.722 admin 2022-12-17T19:48:38.791954300+0000 f 50T58xhkisn2lZGAQNWPj1Ofd8zQx5pr \N 3 bearer 106 2022-12-17 19:50:05.722 admin 2022-12-18 01:19:33.992 admin 2022-12-17T19:53:05.697552600+0000 f LS9CPhF31zzriY3f5ghVhA5clXU47n5c \N 3 bearer 107 2022-12-18 01:19:33.975 admin 2022-12-18 01:34:31.248 admin 2022-12-18T01:22:33.944763400+0000 f Y3w3qngaOFUuYXLxjrYuM4jgBfWT5dd3 \N 3 bearer 108 2022-12-18 01:34:31.248 admin 2022-12-18 01:37:51.079 admin 2022-12-18T01:37:31.248629600+0000 f Dy1ohfSKZkamHd50TAVH3T6bf2AkP7dZ \N 3 bearer 109 2022-12-18 01:37:51.063 admin 2022-12-18 01:50:29.433 admin 2022-12-18T01:40:51.031326900+0000 f i6RZ75uSur3OrOWdfDIBTt0ljYuffJlH \N 3 bearer 110 2022-12-18 01:50:29.417 admin 2022-12-18 01:53:58.531 admin 2022-12-18T01:53:29.417750100+0000 f j2iNDJNW9TTV5Yh3yGkcwZMeuQVGLPhB \N 3 bearer 111 2022-12-18 01:53:58.523 admin 2022-12-18 01:59:46.492 admin 2022-12-18T01:56:58.523101900+0000 f DpC8Jfv6896L9xy7MU5H04aV5Knmcg9D \N 3 bearer 112 2022-12-18 01:59:46.484 admin 2022-12-18 02:03:15.815 admin 2022-12-18T02:02:46.484929600+0000 f t7woqMeh3EBFXQZ9pWb4h9It412057oz \N 3 bearer 113 2022-12-18 02:03:15.815 admin 2022-12-18 02:07:52.686 admin 2022-12-18T02:06:15.815676800+0000 f DN4xKPBygQCKLdVHZL5gFdkM5yAAk78w \N 3 bearer 114 2022-12-18 02:07:52.686 admin 2022-12-18 11:07:17.671 admin 2022-12-18T02:10:52.678559500+0000 f lPd6P2lvq7jyEWsZVmHSOyCSx36XWXJx \N 3 bearer 115 2022-12-18 11:07:17.655 admin 2022-12-18 11:17:03.005 admin 2022-12-18T11:10:17.655421+0000 f Y9TMWGY9G00a4z1sQr6v2TdUSqpY2dC7 \N 3 bearer 116 2022-12-18 11:17:02.991 admin 2022-12-18 11:27:22.792 admin 2022-12-18T11:20:02.974238900+0000 f oEw8IL1Fgvh73ChkfrQMULor1a088ANZ \N 3 bearer 117 2022-12-18 11:27:22.789 admin 2022-12-18 11:35:54.335 admin 2022-12-18T11:30:22.786640600+0000 f Pi2x0AYInPRVhf6BZ9CidzwlVL1kfyG2 \N 3 bearer 118 2022-12-18 11:35:54.332 admin 2022-12-18 11:59:22.389 admin 2022-12-18T11:38:54.329047900+0000 f y8XVVT9k5ug9nlxVnfzRi09uYWyWiKue \N 3 bearer 119 2022-12-18 11:59:22.389 admin 2022-12-18 12:27:37.549 admin 2022-12-18T12:02:22.358398300+0000 f rMcCwwZBXVylR6JMBnwQK3221lY4L1Yk \N 3 bearer 120 2022-12-18 12:27:37.533 admin 2022-12-23 17:35:21.802 admin 2022-12-18T12:30:37.502146100+0000 f B1e1Tn5nCfN2XevKSjYFpWhInk084S5i \N 3 bearer 121 2022-12-23 17:35:21.782 admin 2022-12-24 22:04:59.377 admin 2022-12-23T17:38:21.751054300+0000 f yQ0wYT3in9JYN3ryXGPqmTPJqjpCT4el \N 3 bearer 122 2022-12-24 22:04:59.353 admin 2023-01-07 17:33:06.42 admin 2022-12-24T22:07:59.306973100+0000 f UaYLnzICMQcNoix9b1o3Ktk3SglnRbui \N 3 bearer 123 2023-01-07 17:33:06.411 admin 2023-01-07 17:37:51.176 admin 2023-01-07T17:36:06.400241+0000 f x9GUG7oa2qUKPepiZQ4fhCiwfcBWswsx \N 3 bearer 124 2023-01-07 17:37:52.28 admin 2023-01-07 18:21:44.405 admin 2023-01-07T17:40:52.260105700+0000 f HMufCgzSadenu8qRP7eleZDCan3n3kXK \N 3 bearer 125 2023-01-07 18:21:45.555 admin 2023-01-07 19:25:56.245 admin 2023-01-07T18:24:45.541122800+0000 f WCMPZWjCxZ5HDCUAl0L2mK0B3hCCSMtX \N 3 bearer 126 2023-01-07 19:25:57.588 admin 2023-01-07 19:30:28.504 admin 2023-01-07T19:28:57.576541500+0000 f ow5yKivTcDLNygmmRd2oRfqrt5g46cRH \N 3 bearer 127 2023-01-07 19:30:29.716 admin 2023-01-08 00:01:52.946 admin 2023-01-07T19:33:29.704131600+0000 f Yha5Ayk93jxLjdVLs9X77kafZ6VmPEZA \N 3 bearer 128 2023-01-08 00:01:59.12 admin 2023-01-08 00:07:35.622 admin 2023-01-08T00:04:59.104497200+0000 f pLf7ux2jMOqYlm819alyNpTiCwWbsE8R \N 3 bearer 129 2023-01-08 00:07:37.048 admin 2023-01-08 00:23:16.927 admin 2023-01-08T00:10:37.032615700+0000 f 5o4VUguO2lNpjFioe22lvuLo17djwpxD \N 3 bearer 130 2023-01-08 00:23:19.987 admin 2023-01-08 00:30:32.343 admin 2023-01-08T00:26:19.984090400+0000 f EdEHDHqRhCcI3kr0OV08l7Qw0mCuGl4m \N 3 bearer 131 2023-01-08 00:30:34.341 admin 2023-01-08 00:33:43.418 admin 2023-01-08T00:33:34.333445500+0000 f L9G3VtOpZ6DYBRZIMPBIfcrpO3RI7Ubd \N 3 bearer 132 2023-01-08 00:33:45.969 admin 2023-01-08 00:37:03.771 admin 2023-01-08T00:36:45.961828700+0000 f cVaWE7yRZ4lIgZJhLdZvtxGBGwNhRVie \N 3 bearer 133 2023-01-08 00:37:08.315 admin 2023-01-08 00:41:39.268 admin 2023-01-08T00:40:08.307604500+0000 f HDsSMbbiUGlSZmeN8T5It2ZOSbqkVaVt \N 3 bearer 136 2023-01-08 12:45:42.069 admin 2023-01-08 13:44:51.341 admin 2023-01-08T12:48:42.054350400+0000 f lNVUyb15GUGm5X5FVIM6Njjx0eyBz8bN \N 3 bearer 134 2023-01-08 00:41:47.446 admin 2023-01-08 12:33:46.013 admin 2023-01-08T00:44:47.438188400+0000 f WeOksNhyAUsQ8ElllxrQlE3VHUIHuqOU \N 3 bearer 135 2023-01-08 12:33:51.814 admin 2023-01-08 12:45:39.198 admin 2023-01-08T12:36:51.806422+0000 f sDqV46IMxc3JSwGNWUC2e8n7oryXd0VL \N 3 bearer 137 2023-01-08 13:44:54.41 admin 2023-01-08 14:33:07.601 anonymousUser 2023-01-08T13:47:54.394270600+0000 f atxQAJRoDd8zRoTZeOXbBLGiBZTI4vnC \N 3 bearer 138 2023-01-08 14:33:09.266 anonymousUser 2023-01-13 00:05:07.319 anonymousUser 2023-01-08T14:36:09.250547400+0000 f lohodEHjy0wTrFKWt0EwVgoHL6cNuV1y \N 3 bearer 139 2023-01-13 00:05:13.416 anonymousUser 2023-01-13 00:57:46.535 anonymousUser 2023-01-13T00:08:13.409171400+0000 f FSRCKzqqLEdj6jULs38t2la9rcwBWfPj \N 3 bearer 140 2023-01-13 00:57:57.273 anonymousUser 2023-01-13 09:55:46.958 anonymousUser 2023-01-13T01:00:57.269747400+0000 f YAvssg56iZABqm0nqfl1HwSZCCl7l33D \N 3 bearer 141 2023-01-13 09:55:49.688 anonymousUser 2023-01-20 18:05:18.126 anonymousUser 2023-01-13T09:58:49.674714+0000 f MdymnKKMSWoFC8AhAW3Jintbv5bFeZqi \N 3 bearer 142 2023-01-20 18:05:21.272 anonymousUser 2024-09-16 12:15:55.651 admin 2023-01-20T18:08:21.272516300+0000 f OfWx8fwXaCh6ooWho9haqAOKqKD65Vv8 \N 3 bearer 143 2024-09-16 12:15:58.73 admin 2024-09-27 17:13:45.25 admin 2024-09-16T12:18:58.706832600+0000 f jNS3ttwaIvuvdS2K7XA3NpIgV6l8QCyT \N 3 bearer 147 2024-09-27 17:13:47.538 admin 2024-09-27 17:19:11.527 admin 2024-09-27T17:16:47.520679300+0000 f EjAwVXdW6X4288e0FUoyYgp7mWEYBqhj \N 3 bearer 148 2024-09-27 17:19:13.775 admin 2024-09-27 17:23:30.536 admin 2024-09-27T17:22:13.765995700+0000 f RAHFvzwZlMGEKSMxhuLoT7xK67H5fYIm \N 3 bearer 149 2024-09-27 17:23:34.505 admin 2024-09-27 17:45:51.888 admin 2024-09-27T17:26:34.491529500+0000 f 5s3I3eONwiPqUNieRsqMmk12x7rSinhd \N 3 bearer 151 2024-09-27 17:45:55.63 admin 2024-09-27 17:49:08.97 admin 2024-09-27T17:48:55.614451200+0000 f DvKc8Oc6suUiKR6HQ6vNq5Qc6Z2VLUNG \N 3 bearer 152 2024-09-27 17:49:10.996 admin 2024-09-27 17:53:00.871 admin 2024-09-27T17:52:10.992047900+0000 f m7pf8Vz7XDNQcnkhcUhXR9DnIYsJcTNV \N 3 bearer 172 2024-10-15 12:02:28.48 admin 2024-10-16 12:24:12.101 admin 2024-10-15T12:05:28.452004800+0000 f uL8HYpZSpV0qq44h1oPUwptRlc6AnY3x \N 3 bearer 153 2024-09-27 17:53:02.94 admin 2024-09-27 18:27:21.954 admin 2024-09-27T17:56:02.928157900+0000 f F6yFxG099XVAmAk3wvD1BG4jCqWSbl3y \N 3 bearer 155 2024-09-27 18:27:23.938 admin 2024-09-28 14:32:13.905 admin 2024-09-27T18:30:23.934032900+0000 f AcEF2XthRIVgcs9c3uC1Mcr772hQqWz0 \N 3 bearer 156 2024-09-28 14:32:16.448 admin 2024-09-28 15:18:26.569 admin 2024-09-28T14:35:16.419963300+0000 f 5npnBWUpBYwSUM0jJopdpK8zrYt8CtD9 \N 3 bearer 157 2024-09-28 15:18:28.909 admin 2024-09-28 15:29:48.72 admin 2024-09-28T15:21:28.896254700+0000 f woNdmES1QhDHh6J5sDckbka8NmRyuMnj \N 3 bearer 158 2024-09-28 15:29:51.095 admin 2024-09-28 15:38:03.21 admin 2024-09-28T15:32:51.083305900+0000 f c4J8fZtndz2aLmNoL26XQHP1fF2qnSHs \N 3 bearer 173 2024-10-16 12:24:12.095 admin 2024-10-16 15:29:43.22 admin 2024-10-16T12:27:12.083117+0000 f gZqDYTHc0wbRNrWVNBDlU37xvZ9wwE44 \N 3 bearer 174 2024-10-16 15:29:43.216 admin 2024-10-18 15:12:42.607 admin 2024-10-16T15:32:43.205077400+0000 f 5EepZwrvMrHrZaX2oiWxzuEpfdpibT6z \N 3 bearer 175 2024-10-18 15:12:42.576 admin 2024-10-18 15:18:14.099 admin 2024-10-18T15:15:42.550311400+0000 f WAly30mLMNvKXKiMOFu0UU04Zf98fXNe \N 3 bearer 159 2024-09-28 15:38:05.597 admin 2024-09-28 17:19:59.9 admin 2024-09-28T15:41:05.582652900+0000 f rwlHLSEqVZpEEEE2Y4P0ENKrp4rXW66n \N 3 bearer 160 2024-09-28 17:20:02.047 admin 2024-09-28 17:33:21.35 admin 2024-09-28T17:23:02.032578500+0000 f j1OzrQ9inf9VJrUBBIrOwrxEmN9avUcY \N 3 bearer 161 2024-09-28 17:33:23.622 admin 2024-09-28 17:39:43.773 admin 2024-09-28T17:36:23.613205+0000 f LMG2cgfq6cg63oIztVU1JBQPhr8DZZLF \N 3 bearer 162 2024-09-28 17:39:47.522 admin 2024-09-28 17:55:00.468 admin 2024-09-28T17:42:47.513525+0000 f QloAKxHcIUXPIIdSfD8mai8wK6INoO8s \N 3 bearer 176 2024-10-18 15:18:14.096 admin 2024-10-18 15:24:10.32 admin 2024-10-18T15:21:14.094418500+0000 f cKQESplSypMFBTNFAc0lxRGixmOXx5VM \N 3 bearer 177 2024-10-18 15:24:13.615 admin 2024-10-18 15:27:40.462 admin 2024-10-18T15:27:13.611480200+0000 f F22ACUJP8nHX7EeDMrK5IHiB1TdrF4VM \N 3 bearer 185 2024-12-06 11:56:34.505 admin 2024-12-06 15:04:35.534 admin 2024-12-06T11:59:34.499994900+0000 f LjTG1X4gfEMrfAK7qxMoMAOUmPGtTpMW \N 3 bearer 163 2024-09-28 17:55:02.879 admin 2024-10-05 18:14:44.016 admin 2024-09-28T17:58:02.865816900+0000 f dvvzv1HmHBIl9t1WRkJ6Yb9UyVMLyGgR \N 3 bearer 169 2024-10-05 18:14:43.964 admin 2024-10-07 10:12:42.655 admin 2024-10-05T18:17:43.946929300+0000 f kk9SRMEnHSHi9N2UU3kbvdxFm5Za9F6r \N 3 bearer 170 2024-10-07 10:12:42.647 admin 2024-10-08 13:12:58.63 admin 2024-10-07T10:15:42.639037600+0000 f kxnQPvCF7YT1rDROEGkBa63NPj8zICA3 \N 3 bearer 171 2024-10-08 13:12:58.619 admin 2024-10-15 12:02:28.524 admin 2024-10-08T13:15:58.600105600+0000 f 3ccRrm1JHQGEpCWOAawiMfqNyXszkqQb \N 3 bearer 186 2024-12-06 15:04:37.296 admin 2024-12-06 15:10:18.275 admin 2024-12-06T15:07:37.293943800+0000 f gXDqMwICWXvr5Uqz5s5DtgO117iXMY2c \N 3 bearer 193 2024-12-12 14:34:11.931 admin 2024-12-12 14:37:22.546 admin 2024-12-12T14:37:11.914493600+0000 f kvyUZ8y7IfhP76myg6A7xtQQNyk45jmB \N 3 bearer 187 2024-12-06 15:10:23.828 admin 2024-12-06 15:38:09.595 admin 2024-12-06T15:13:23.825537+0000 f t40nDI1jaP001ZS6l6DeQwrXKZ4SeAdf \N 3 bearer 178 2024-10-18 15:27:40.46 admin 2024-12-05 08:25:30.53 admin 2024-10-18T15:30:40.459444900+0000 f nTe4UQRJPHT9lnNFZRhxjQhb7i4Xb7uA \N 3 bearer 180 2024-12-05 08:25:31.903 admin 2024-12-05 08:33:46.252 admin 2024-12-05T08:28:31.889077800+0000 f Pthrg0a8Kz8pyTOgaUms7yXMMvdfVvbM \N 3 bearer 181 2024-12-05 08:33:47.903 admin 2024-12-06 08:58:10.903 anonymousUser 2024-12-05T08:36:47.900256700+0000 f Ff5x5y7rOejUM3OqWnmOMEvfm7Ar3KOJ \N 3 bearer 182 2024-12-06 08:58:10.889 anonymousUser 2024-12-06 10:45:22.621 admin 2024-12-06T09:01:10.877777+0000 f jXNodoeAx0OBOqtuNpet8xfqBwqyubEm \N 3 bearer 183 2024-12-06 10:45:24.6 admin 2024-12-06 11:51:24.258 admin 2024-12-06T10:48:24.588620900+0000 f 2cSpraH6TLMSCAJPjJxYQTw1dJXuaUOg \N 3 bearer 184 2024-12-06 11:51:27.398 admin 2024-12-06 11:56:29.865 admin 2024-12-06T11:54:27.380401+0000 f ElGfTqFgGZOXdbL1DkBdhfAtKJNkcTYL \N 3 bearer 188 2024-12-06 15:38:11.805 admin 2024-12-07 15:48:29.576 admin 2024-12-06T15:41:11.801238100+0000 f F3Gz20QNJPfEWrsTF676vc1CXYBNTX8C \N 3 bearer 190 2024-12-07 15:48:31.876 admin 2024-12-07 15:53:07.957 admin 2024-12-07T15:51:31.860467900+0000 f jlR5FyhjywCOBY06dVTLs6aI1XPO0Jv8 \N 3 bearer 191 2024-12-07 15:53:10.74 admin 2024-12-10 10:54:31.189 admin 2024-12-07T15:56:10.735750200+0000 f c3Rc23NRfBj3C08eN35toSty63mVr1Yt \N 3 bearer 192 2024-12-10 10:54:31.177 admin 2024-12-12 14:34:11.937 admin 2024-12-10T10:57:31.166527700+0000 f scW7u60HcVPRCsYNFCyD6PQIAyi63c9Q \N 3 bearer 194 2024-12-12 14:37:22.543 admin 2025-01-15 13:02:52.11 admin 2024-12-12T14:40:22.541631+0000 f okbi2S26f7iWKl8YRHtXBb82SIRSZ94v \N 3 bearer 195 2025-01-15 13:02:52.105 admin 2025-01-15 14:09:11.42 admin 2025-01-15T13:05:52.098357400+0000 f IZuCi0tkwdJ2rF3G030Za4okG3I4EpqG \N 3 bearer 196 2025-01-15 14:09:11.416 admin 2025-01-15 14:38:23.741 admin 2025-01-15T14:12:11.411017900+0000 f p7j7f8QIonSLXMAB4Y61sbqz2Zj0U9yW \N 3 bearer 197 2025-01-15 14:38:23.738 admin 2025-01-15 16:26:06.443 admin 2025-01-15T14:41:23.728008800+0000 f UCMltWEFD4KB4F3XTJcsV111kWslJH0u \N 3 bearer 199 2025-02-10 14:38:02.992 admin 2025-02-10 14:38:02.992 admin 2025-02-10T14:41:02.973843700+0000 t qO84cVTc6vBaFEza7U4cz59SurAXPIn6 \N 3 bearer 198 2025-01-15 16:26:06.44 admin 2025-02-10 14:38:03.008 admin 2025-01-15T16:29:06.433695300+0000 f DWInCcu3twK7nf1bpy7MNIzlvKNnnS2A \N 3 bearer \. -- -- Data for Name: session_tontine; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.session_tontine (id_session_tontine, created_at, created_by, modified_at, modified_by, date_debut, date_fin, description, libelle, montant, owner_id_user, tontine_id_tontine, total_collecte) FROM stdin; 1 2023-01-12 15:55:35.893 admin 2023-01-12 15:55:35.893 admin 2023-01-01 2023-01-31 Session Janvier 2023 20000 \N 1 0 2 2023-01-12 21:26:30.761 admin 2023-01-12 21:26:30.761 admin \N \N \N \N 20000 \N \N 0 3 2023-01-13 09:26:44.67 Abou 2023-01-13 09:26:44.67 Abou 2023-01-01 2023-01-27 \N Versement Janvier 2023 5000 \N 3 5000 \. -- -- Data for Name: session_tontine_transaction; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.session_tontine_transaction (id_session_tontine_transaction, created_at, created_by, modified_at, modified_by, code, montant, statut, evenement_id_evenement, membre_id_membre, partenaire_id_partenaire, session_tontine_id_session_tontine, transaction_id) FROM stdin; 2 2023-01-12 21:53:53.943 admin 2023-01-12 21:53:53.943 admin 2465 20000 INITIEE \N 4 3 1 37 1 2023-01-12 21:34:12.408 admin 2023-01-12 21:34:12.408 admin 2465 20000 INITIEE \N 5 3 1 36 3 2023-01-13 09:36:45.584 Abou 2023-01-13 09:36:45.584 Abou 5505 5000 INITIEE \N 7 3 3 40 \. -- -- Data for Name: test_visa_foreign; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.test_visa_foreign (id, created_at, created_by, modified_at, modified_by, destination_currency_code, initiating_party_id, quote_id_required, rate_product_code, source_currency_code) FROM stdin; 1 2024-11-29 10:09:58.996 anonymousUser 2024-11-29 10:09:58.996 anonymousUser USD 1002 true BANK EUR \. -- -- Data for Name: tontine; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.tontine (id_tontine, created_at, created_by, modified_at, modified_by, bouton, description, libelle, lien, montant, periodicite, photo_url, owner_id_user) FROM stdin; 1 2023-01-11 19:51:11.826 admin 2023-01-11 19:51:11.826 admin Cotiser Projet agagi vise à aider les jeunes entrepreuneurs à booster leur business. Tontime Agagi 20000 \N c30bfeaa-40b3-4427-9be5-c02eb739c2a6-WhatsApp Image 2023-01-10 at 10.57.38.jpeg 1 2 2023-01-13 00:59:24.282 Abou 2023-01-13 00:59:24.282 Abou Cotiser Description Tontine MATA 5000 \N 053f5f54-26df-42f5-a2cc-111f9e7c1de1-MySawki.png 8 3 2023-01-13 09:23:42.969 Abou 2023-01-13 09:23:42.969 Abou Cotiser Un projet de collecte pour les jeunes Assoussou Matassa 5000 \N a7267443-0159-449c-8fd1-211342be1b84-undraw_Software_engineer_re_fyew.png 8 4 2026-04-15 20:22:44.791 mabuzz 2026-04-15 20:22:44.791 mabuzz Cotiser Mutuelle pour les personnels Cotisation mutuelle 20000 \N \N 9 \. -- -- Data for Name: transaction; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.transaction (id_transaction, code, libelle_transaction, montant, nom_client, numero, prenom_client, app_client_id, evenement_id_evenement, partenaire_id_partenaire, type_transaction_id_type_transaction, response_enquiry, statut, created_at, created_by, modified_at, modified_by) FROM stdin; 1 \N BEPAY EVENT 1 100 BAKO ADAMOU 98793379 \N 1 3 \N \N \N \N \N \N \N 2 \N BEPAY EVENT 2 100 BAKO ADAMOU 98793379 \N 2 3 \N \N \N \N \N \N \N 3 \N BEPAY EVENT 2 100 BAKO ADAMOU 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP221224.2205.C00292","id":"3","message":"Desole, le mot passe entre est incorrecte.","status":"TF"}},"status":{"response_code":"DP008001013","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} \N \N \N \N \N 4 \N BEPAY EVENT 2 100 Moubarak Bako 98793379 \N 2 3 \N \N INITIEE \N \N \N \N 24 \N BEPAY EVENT 2 100 Abou Sayabou 98793379 \N 2 3 \N \N EN COURS \N \N \N \N 7 \N BEPAY EVENT 2 100 Moubarak Bako 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230107.1738.J04514","id":"7","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 8 \N BEPAY EVENT 2 100 Elh Bako Ara 98793379 \N 2 3 \N \N EN COURS \N \N \N \N 9 \N BEPAY EVENT 2 100 Elh Bako Ara 98793379 \N 2 3 \N \N EN COURS \N \N \N \N 17 \N BEPAY EVENT 2 100 Moubarak 98793379 \N 2 3 \N {"data":{"transaction":{"id":"17","status":"TIP"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 25 \N BEPAY EVENT 2 100 Abou Sayabou 98793379 \N 2 3 \N \N EN COURS \N \N \N \N 18 \N BEPAY EVENT 2 50 Moubarak 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230107.1930.J06059","id":"18","message":"Le montant de la transaction est inferieur au montant minimum defini pour ce service","status":"TF"}},"status":{"response_code":"DP008001013","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 19 \N BEPAY EVENT 2 100 Ibrahim Magagi 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.0002.J08752","id":"19","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 31 \N BEPAY EVENT 2 100 Ibrahim ISSA 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.1247.C05644","id":"31","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE \N \N \N \N 20 \N BEPAY EVENT 2 100 Ibrahim 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.0007.J08781","id":"20","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 26 \N BEPAY EVENT 2 100 Abou Sayabou 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.0042.J08849","id":"26","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 21 \N BEPAY EVENT 2 100 Mamane Ara 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.0023.C02696","id":"21","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 22 \N BEPAY EVENT 2 100 Ibrahim ISSA 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.0030.C02726","id":"22","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 23 \N BEPAY EVENT 2 100 Ibrahim ISSA 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.0034.C02732","id":"23","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 29 \N BEPAY EVENT 2 100 Ibrahim ISSA 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.1234.J00934","id":"29","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 30 \N BEPAY EVENT 2 100 Ibrahim ISSA 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.1245.C05617","id":"30","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} EN COURS \N \N \N \N 36 \N \N 20000 Issa 98793379 Moussa \N \N 3 \N \N INITIEE 2023-01-12 21:34:12.425 admin 2023-01-12 21:34:12.425 admin 34 \N BEPAY EVENT 2 100 Ibrahim ISSA 98793379 \N 2 3 \N {"data":{"transaction":{"id":"34","status":"TIP"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE \N \N \N \N 32 \N BEPAY EVENT 2 100 Ibrahim ISSA 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.1345.J01558","id":"32","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE \N \N \N \N 33 \N BEPAY EVENT 2 100 Ibrahim ISSA 98793379 \N 2 3 \N {"data":{"transaction":{"id":"33","status":"TIP"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE \N \N \N \N 37 \N \N 20000 Issa 98792003 Moussa \N \N 3 \N \N INITIEE 2023-01-12 21:53:53.958 admin 2023-01-12 21:53:53.958 admin 35 \N BEPAY EVENT 2 100 BAKO ADAMOU 98793379 \N 2 3 \N {"data":{"transaction":{"airtel_money_id":"MP230108.1435.J01958","id":"35","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE \N \N \N \N 38 \N BEPAY EVENT 6 100 Ibrahim ISSA 98793379 \N 6 3 \N {"data":{"transaction":{"airtel_money_id":"MP230113.0005.C06976","id":"38","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE 2023-01-13 00:05:07.195 anonymousUser 2023-01-13 00:06:04.669 anonymousUser 39 \N BEPAY EVENT 6 100 Ibrahim ISSA 98793379 \N 6 3 \N {"data":{"transaction":{"airtel_money_id":"MP230113.0058.J04754","id":"39","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE 2023-01-13 00:57:46.474 anonymousUser 2023-01-13 00:58:20.517 anonymousUser 40 \N \N 5000 Saley 98793379 Farida \N \N 3 \N \N INITIEE 2023-01-13 09:36:45.598 Abou 2023-01-13 09:36:45.598 Abou 42 \N BEPAY EVENT 6 100 Ibrahim ISSA 98793379 \N 6 3 \N {"data":{"transaction":{"airtel_money_id":"MP230113.0956.J05048","id":"42","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE 2023-01-13 09:55:46.901 anonymousUser 2023-01-13 09:56:10.219 anonymousUser 43 \N BEPAY EVENT 4 100 BAKO ADAMOU 98793379 \N 4 3 \N {"data":{"transaction":{"id":"43","status":"TIP"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE 2023-01-20 18:05:18.022 anonymousUser 2023-01-20 18:07:09.75 anonymousUser 44 122002 Cotisation 200 BAKO 98793379 Adamou \N \N 3 1 \N EN COURS 2024-09-16 12:15:55.396 admin 2024-10-18 15:26:59.773 admin 48 FEEVSF TEST 100 Ridouane 89362840 Seydou \N \N 3 1 \N EN COURS 2024-09-27 17:23:30.496 admin 2024-09-27 17:23:30.496 admin 49 SDS test 100 Rido 98793379 Seydou \N \N 3 1 \N EN COURS 2024-09-27 17:45:51.8 admin 2024-09-27 17:45:51.8 admin 45 YUHJB test 100 Ridouane 98793379 Seydou \N \N 3 1 \N EN COURS 2024-09-27 17:13:45.159 admin 2024-10-18 15:27:06.528 admin 51 KJ test 100 Bako 89362840 Adamou \N \N 3 1 {"data":{"transaction":{"id":"51","status":"TIP"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE 2024-09-27 17:53:00.767 admin 2024-09-27 17:53:26.278 admin 73 JHJG paiement 100 Adamou 98793379 Bako \N \N 3 1 {"data":{"transaction":{"airtel_money_id":"MP241018.1524.C07788","id":"73","message":"Your transaction has been successfully processed","status":"TS"}},"status":{"response_code":"DP00800001001","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE 2024-10-18 15:24:10.264 admin 2024-10-18 15:24:44.542 admin 53 HJY test 100 Bako 98793379 Adamou \N \N 3 1 {"data":{"transaction":{"id":"53","status":"TIP"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE 2024-09-27 18:27:21.925 admin 2024-09-27 18:27:49.022 admin 58 FKK TEST 100 Bako 98793379 Adamou \N \N 3 1 \N EN COURS 2024-09-28 15:31:55.462 admin 2024-09-28 15:31:55.462 admin 54 JEFE2334 toto 100 Bako 100 Adamou \N \N 3 1 {"status":{"response_code":"DP00800001025","code":"404","success":false,"result_code":"0000900","message":"Transaction not found"}} ECHOUEE 2024-09-28 14:32:13.721 admin 2024-09-28 14:32:26.252 admin 59 FVD test 100 Bako 98793379 Adamou \N \N 3 1 \N EN COURS 2024-09-28 15:38:03.006 admin 2024-09-28 15:38:03.006 admin 55 djsue toto 100 Adamou 89362840 Fawaz \N \N 3 1 {"data":{"transaction":{"id":"55","status":"TIP"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE 2024-09-28 14:33:19.896 admin 2024-09-28 14:33:51.446 admin 70 gjjjj TEST 500 RIdo 98793379 Seydou \N \N 3 1 {"data":{"transaction":{"id":"70","status":"TIP"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} ECHOUEE 2024-09-28 17:33:21.316 admin 2024-09-28 17:33:51.773 admin 63 FDE rfgr 100 dcdccdc 98793379 dcc \N \N 3 1 \N INITIEE 2024-09-28 16:57:32.811 admin 2024-09-28 16:57:32.811 admin 64 djdj ttt 100 TOTO 98793379 timo \N \N 3 1 \N INITIEE 2024-09-28 17:01:05.34 admin 2024-09-28 17:01:05.34 admin 65 UYHO test 100 Moubarak 98793379 Razak \N \N 3 1 \N INITIEE 2024-09-28 17:03:13.233 admin 2024-09-28 17:03:13.233 admin 69 RJR test 100 RIDO 98793379 SEYDOU \N \N 3 1 \N EN COURS 2024-09-28 17:19:59.767 admin 2024-09-28 17:19:59.767 admin 72 GVFG test 100 Rido 89362840 Seydou \N \N 3 1 {"data":{"transaction":{"airtel_money_id":"MP240928.1755.C04036","id":"72","message":"Initiateur est invalide","status":"TF"}},"status":{"response_code":"DP00800001010","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} ECHOUEE 2024-09-28 17:55:00.409 admin 2024-09-28 17:55:39.631 admin 57 FHEK test 100 Bako 98793379 Amadou \N \N 3 2 \N EN COURS 2024-09-28 15:29:48.669 admin 2024-10-08 13:12:54.975 admin 71 DX TEST 100 RIDO 98793379 SEYDOU \N \N 3 1 {"data":{"transaction":{"id":"71","status":"TIP"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} ECHOUEE 2024-09-28 17:39:43.723 admin 2024-09-28 17:40:10.967 admin 46 zsdfsfz test 100 Bako 98793379 Adamou \N \N 3 1 \N EN COURS 2024-09-27 17:19:11.508 admin 2024-10-18 15:27:12.885 admin 56 DHCBE test 100 Adamou 98793379 Bako \N \N 3 2 {"data":{"transaction":{"id":"56","status":"TIP"}},"status":{"response_code":"DP00800001006","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} TERMINEE 2024-09-28 15:18:26.472 admin 2024-10-18 15:27:38.058 admin 47 ZDCD TEST 100 BAKO 98793379 ADAMOU \N \N 3 2 \N EN COURS 2024-09-27 17:22:09.13 admin 2024-10-16 15:29:40.775 admin 50 cfsdj test 100 Bako 89362840 Adamou \N \N 3 2 \N EN COURS 2024-09-27 17:49:08.939 admin 2024-10-18 15:12:38.876 admin 79 EEE PAI 100 RIDO 89362840 SEYDOU \N \N 3 1 \N INITIEE 2024-12-05 08:25:07.804 admin 2024-12-05 08:25:07.804 admin 80 EEE PAI 100 RIDO 89362840 SEYDOU \N \N 3 1 \N INITIEE 2024-12-05 08:25:21.538 admin 2024-12-05 08:25:21.538 admin 82 ET PAI 100 RIDO 89362840 SEYDOU \N \N 3 1 \N INITIEE 2024-12-05 08:33:46.236 admin 2024-12-05 08:33:46.236 admin 83 momopo momopo 100 momopo 89362840 momopo \N \N 3 1 \N INITIEE 2024-12-06 10:45:22.481 admin 2024-12-06 10:45:22.481 admin 84 F PAIEMENT 100 MAIMOU 89362840 ADAMOU \N \N 3 1 \N INITIEE 2024-12-06 11:51:24.198 admin 2024-12-06 11:51:24.198 admin 85 1DV paiement 100 Abou 86541597 Sayabou \N \N 3 1 {"status":{"response_code":"DP00800001025","code":"404","success":false,"result_code":"0000900","message":"Transaction not found"}} ECHOUEE 2024-12-06 11:56:29.696 admin 2024-12-06 11:56:47.595 admin 86 de riri 100 bebe 98793379 bebe \N \N 3 1 {"status":{"response_code":"DP00800001025","code":"404","success":false,"result_code":"0000900","message":"Transaction not found"}} ECHOUEE 2024-12-06 15:04:35.515 admin 2024-12-06 15:05:05.658 admin 87 ccc paiement 100 bako 98793379 adou \N \N 3 1 {"status":{"response_code":"DP00800001025","code":"404","success":false,"result_code":"0000900","message":"Transaction not found"}} ECHOUEE 2024-12-06 15:10:18.252 admin 2024-12-06 15:12:05.129 admin 89 fvbdfvdfv ttt 100 bako 98793379 Adamou \N \N 3 1 {"status":{"response_code":"DP00800001025","code":"404","success":false,"result_code":"0000900","message":"Transaction not found"}} ECHOUEE 2024-12-06 15:38:09.574 admin 2024-12-06 15:39:19.462 admin 90 VDSV testPaiement 100 BAKO 98793379 ADAMOU \N \N 3 1 \N EN COURS 2024-12-07 15:48:29.494 admin 2024-12-07 15:48:29.494 admin 91 TOTO TESTPAIEMENT 100 BAKO 98793379 ADAMOU \N \N 3 1 {"data":{"transaction":{"airtel_money_id":"MP241207.1653.C02895","id":"91","message":"Desole, le mot passe entre est incorrecte.","status":"TF"}},"status":{"response_code":"DP00800001002","code":"200","success":true,"result_code":"ESB000010","message":"SUCCESS"}} ECHOUEE 2024-12-07 15:53:07.943 admin 2024-12-07 15:54:03.542 admin \. -- -- Data for Name: type_action; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.type_action (id_type_action, libelle_type_action) FROM stdin; 1 GetOne 2 GetList 3 PostOne \. -- -- Data for Name: type_reponse; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.type_reponse (id_type_reponse, libelle_type_reponse, type) FROM stdin; 1 JSON3 3 \. -- -- Data for Name: type_transaction; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.type_transaction (id_type_transaction, libelle_type_transaction) FROM stdin; 1 Payement 2 Remboursement \. -- -- Data for Name: utilisateur; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.utilisateur (id_user, created_at, created_by, modified_at, modified_by, email, nom, password, prenom, username, profile_id, statut, telephone, projet_id_projet) FROM stdin; 2 2022-08-30 17:33:01.444 admin 2022-08-30 18:10:27.822 admin eeeeeeeeee nnnnnnnnnnn $2a$10$RY1fXP9FMyNmj5d6wr7JvurosKSnHrxeW0rYxYQnHFuYPhwIbrnEC pppppppppppp user 2 \N \N \N 3 2022-08-31 10:49:06.462 admin 2022-08-31 10:50:16.701 admin emailU nomU $2a$10$toWxkTT3NiAAZDxmB49x0ubtEkXg8T7gham.brpsnJzkFBZSrcUWO prenomU loginUser 2 \N \N \N 4 2022-08-31 10:51:19.296 admin 2022-08-31 10:51:19.296 admin tn tn $2a$10$tIF2PIWuYEJf7A0Bb50IH.Arh4JpBkb48WVXuftyHMaxbj/uo1T7. tds tnr 1 \N \N \N 5 2022-08-31 10:52:43.97 admin 2022-08-31 10:52:43.97 admin bj bjmk $2a$10$VWTH8.IIHP/qW1KdTtDyt.3C7fnNbGdtShBRG1J1Kka88mD79I1GW hum bnjkm 1 \N \N \N 6 2022-09-02 14:30:02.982 admin 2022-09-02 14:30:02.982 admin beit@gmail.com beit $2a$10$HrLiqv0Nl0OGJStClXeS6.trWKUQImAryiXolaPaTMKxOA37S2VK6 beit beit 2 \N \N \N 7 2022-12-26 23:58:23.831 anonymousUser 2022-12-26 23:58:23.831 anonymousUser issa.moussa@gmail.com ISSA MOUSSA $2a$10$YZPRTeNbEqGyNXwYoKB8Ee9kT1/Kr6c7B4iNzU7UtKP194OBe9GBG \N Issamouss 3 f 90299039 \N 1 \N \N \N \N \N BAKO ADAMOU $2a$10$eu1XEIEAWgd6k8pR7Dv/GumISEiDkwJyo0h6qDd5RCKR15alejJiq M.Bariki admin 1 \N \N \N 8 2023-01-12 22:02:27.569 anonymousUser 2023-01-12 22:02:27.569 anonymousUser abou@gmail.com Abou $2a$10$ZXV6/OmyIruHGJar0vOdmOUsBUJkYU1iYwJO3Vtg/L58R75CTlewW \N Abou 3 f 94107074 \N 9 2026-04-15 20:21:04.271 anonymousUser 2026-04-15 20:21:04.271 anonymousUser mabuzz@gmail.com MaBuzz $2a$10$0FXNgJOmvEdqhdRGP5CvreiSz4UWs1Rn2ItTUlfllfIS6csp40ZA2 \N mabuzz 3 f 94010101 \N \. -- -- Data for Name: valider_compte_payement_visa; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.valider_compte_payement_visa (id_valider_compte_pay_visa, created_at, created_by, modified_at, modified_by, acquirer_country_code, acquiring_bin, card_cvv, card_expiry_date, complet_name, number_carte, postal_code, retrieval_reference_number, telephone, partenaire_id_partenaire) FROM stdin; \. -- -- Name: airtime_id_airtime_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.airtime_id_airtime_seq', 5, true); -- -- Name: api_id_api_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.api_id_api_seq', 22, true); -- -- Name: app_client_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.app_client_id_seq', 5, true); -- -- Name: application_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.application_id_seq', 5, true); -- -- Name: cash_id_cash_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.cash_id_cash_seq', 10, true); -- -- Name: decaisser_id_decaisser_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.decaisser_id_decaisser_seq', 7, true); -- -- Name: error_code_id_error_code_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.error_code_id_error_code_seq', 57, true); -- -- Name: error_code_type_id_error_code_type_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.error_code_type_id_error_code_type_seq', 6, true); -- -- Name: evenement_id_evenement_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.evenement_id_evenement_seq', 8, true); -- -- Name: membre_id_membre_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.membre_id_membre_seq', 7, true); -- -- Name: parametre_id_parametre_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.parametre_id_parametre_seq', 606, true); -- -- Name: partenaire_id_partenaire_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.partenaire_id_partenaire_seq', 6, true); -- -- Name: payement_visa_id_payement_visa_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.payement_visa_id_payement_visa_seq', 9, true); -- -- Name: possible_values_id_possible_value_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.possible_values_id_possible_value_seq', 144, true); -- -- Name: profile_id_profile_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.profile_id_profile_seq', 3, true); -- -- Name: reponse_param_id_reponse_param_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.reponse_param_id_reponse_param_seq', 34, true); -- -- Name: session_id_session_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.session_id_session_seq', 199, true); -- -- Name: session_tontine_id_session_tontine_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.session_tontine_id_session_tontine_seq', 3, true); -- -- Name: session_tontine_transaction_id_session_tontine_transaction_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.session_tontine_transaction_id_session_tontine_transaction_seq', 3, true); -- -- Name: test_visa_foreign_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.test_visa_foreign_id_seq', 1, true); -- -- Name: tontine_id_tontine_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tontine_id_tontine_seq', 4, true); -- -- Name: transaction_id_transaction_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.transaction_id_transaction_seq', 91, true); -- -- Name: type_action_id_type_action_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.type_action_id_type_action_seq', 3, true); -- -- Name: type_reponse_id_type_reponse_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.type_reponse_id_type_reponse_seq', 1, true); -- -- Name: type_transaction_id_type_transaction_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.type_transaction_id_type_transaction_seq', 2, true); -- -- Name: utilisateur_id_user_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.utilisateur_id_user_seq', 9, true); -- -- Name: valider_compte_payement_visa_id_valider_compte_pay_visa_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.valider_compte_payement_visa_id_valider_compte_pay_visa_seq', 1, false); -- -- Name: airtime airtime_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.airtime ADD CONSTRAINT airtime_pkey PRIMARY KEY (id_airtime); -- -- Name: api api_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.api ADD CONSTRAINT api_pkey PRIMARY KEY (id_api); -- -- Name: app_client app_client_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.app_client ADD CONSTRAINT app_client_pkey PRIMARY KEY (id); -- -- Name: application application_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.application ADD CONSTRAINT application_pkey PRIMARY KEY (id); -- -- Name: cash cash_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.cash ADD CONSTRAINT cash_pkey PRIMARY KEY (id_cash); -- -- Name: decaisser decaisser_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.decaisser ADD CONSTRAINT decaisser_pkey PRIMARY KEY (id_decaisser); -- -- Name: error_code error_code_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.error_code ADD CONSTRAINT error_code_pkey PRIMARY KEY (id_error_code); -- -- Name: error_code_type error_code_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.error_code_type ADD CONSTRAINT error_code_type_pkey PRIMARY KEY (id_error_code_type); -- -- Name: evenement evenement_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.evenement ADD CONSTRAINT evenement_pkey PRIMARY KEY (id_evenement); -- -- Name: membre membre_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.membre ADD CONSTRAINT membre_pkey PRIMARY KEY (id_membre); -- -- Name: parametre parametre_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.parametre ADD CONSTRAINT parametre_pkey PRIMARY KEY (id_parametre); -- -- Name: partenaire partenaire_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.partenaire ADD CONSTRAINT partenaire_pkey PRIMARY KEY (id_partenaire); -- -- Name: payement_visa payement_visa_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.payement_visa ADD CONSTRAINT payement_visa_pkey PRIMARY KEY (id_payement_visa); -- -- Name: possible_values possible_values_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.possible_values ADD CONSTRAINT possible_values_pkey PRIMARY KEY (id_possible_value); -- -- Name: profile profile_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.profile ADD CONSTRAINT profile_pkey PRIMARY KEY (id_profile); -- -- Name: reponse_param reponse_param_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.reponse_param ADD CONSTRAINT reponse_param_pkey PRIMARY KEY (id_reponse_param); -- -- Name: session session_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session ADD CONSTRAINT session_pkey PRIMARY KEY (id_session); -- -- Name: session_tontine session_tontine_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine ADD CONSTRAINT session_tontine_pkey PRIMARY KEY (id_session_tontine); -- -- Name: session_tontine_transaction session_tontine_transaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine_transaction ADD CONSTRAINT session_tontine_transaction_pkey PRIMARY KEY (id_session_tontine_transaction); -- -- Name: test_visa_foreign test_visa_foreign_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.test_visa_foreign ADD CONSTRAINT test_visa_foreign_pkey PRIMARY KEY (id); -- -- Name: tontine tontine_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tontine ADD CONSTRAINT tontine_pkey PRIMARY KEY (id_tontine); -- -- Name: transaction transaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.transaction ADD CONSTRAINT transaction_pkey PRIMARY KEY (id_transaction); -- -- Name: type_action type_action_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.type_action ADD CONSTRAINT type_action_pkey PRIMARY KEY (id_type_action); -- -- Name: type_reponse type_reponse_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.type_reponse ADD CONSTRAINT type_reponse_pkey PRIMARY KEY (id_type_reponse); -- -- Name: type_transaction type_transaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.type_transaction ADD CONSTRAINT type_transaction_pkey PRIMARY KEY (id_type_transaction); -- -- Name: partenaire uk_2y49uli6lyu3o9j61st08ksc2; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.partenaire ADD CONSTRAINT uk_2y49uli6lyu3o9j61st08ksc2 UNIQUE (email); -- -- Name: partenaire uk_3mabakalh5yvqx1n51ykjj6o0; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.partenaire ADD CONSTRAINT uk_3mabakalh5yvqx1n51ykjj6o0 UNIQUE (telephone); -- -- Name: partenaire uk_k71tgg8833gk2uunbr5lidsp7; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.partenaire ADD CONSTRAINT uk_k71tgg8833gk2uunbr5lidsp7 UNIQUE (nom_compagnie); -- -- Name: membre uk_ld6gdhj2rsvlj2f5euafcmm8e; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.membre ADD CONSTRAINT uk_ld6gdhj2rsvlj2f5euafcmm8e UNIQUE (telephone); -- -- Name: tontine uk_ln8yiarb68wixy51cqopinagl; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tontine ADD CONSTRAINT uk_ln8yiarb68wixy51cqopinagl UNIQUE (libelle); -- -- Name: evenement uk_nc0k0rmm5uk8ok8a0tmcfit4a; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.evenement ADD CONSTRAINT uk_nc0k0rmm5uk8ok8a0tmcfit4a UNIQUE (libelle); -- -- Name: membre uk_o596rgsrax69i2f6ia0oo63ll; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.membre ADD CONSTRAINT uk_o596rgsrax69i2f6ia0oo63ll UNIQUE (code); -- -- Name: utilisateur uk_rma38wvnqfaf66vvmi57c71lo; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.utilisateur ADD CONSTRAINT uk_rma38wvnqfaf66vvmi57c71lo UNIQUE (email); -- -- Name: utilisateur utilisateur_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.utilisateur ADD CONSTRAINT utilisateur_pkey PRIMARY KEY (id_user); -- -- Name: valider_compte_payement_visa valider_compte_payement_visa_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.valider_compte_payement_visa ADD CONSTRAINT valider_compte_payement_visa_pkey PRIMARY KEY (id_valider_compte_pay_visa); -- -- Name: session fk1ljn38dshuil7id84dsjx3v9n; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session ADD CONSTRAINT fk1ljn38dshuil7id84dsjx3v9n FOREIGN KEY (partenaire_id_partenaire) REFERENCES public.partenaire(id_partenaire); -- -- Name: transaction fk2of13qefrxblm779ofoiyc19a; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.transaction ADD CONSTRAINT fk2of13qefrxblm779ofoiyc19a FOREIGN KEY (evenement_id_evenement) REFERENCES public.evenement(id_evenement); -- -- Name: tontine fk33d63aa8d0ino19g4x0fd6f58; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tontine ADD CONSTRAINT fk33d63aa8d0ino19g4x0fd6f58 FOREIGN KEY (owner_id_user) REFERENCES public.utilisateur(id_user); -- -- Name: decaisser fk34d4q72gegjdxy7tv6xd1jj8j; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.decaisser ADD CONSTRAINT fk34d4q72gegjdxy7tv6xd1jj8j FOREIGN KEY (evenement_id_evenement) REFERENCES public.evenement(id_evenement); -- -- Name: session_tontine_transaction fk39q0flpv8xdib4qqft5kut0oo; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine_transaction ADD CONSTRAINT fk39q0flpv8xdib4qqft5kut0oo FOREIGN KEY (membre_id_membre) REFERENCES public.membre(id_membre); -- -- Name: utilisateur fk3at7367hsfq1i7ytn2b6sgt67; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.utilisateur ADD CONSTRAINT fk3at7367hsfq1i7ytn2b6sgt67 FOREIGN KEY (profile_id) REFERENCES public.profile(id_profile); -- -- Name: transaction fk6gkawgcnsnr65spgkl5lrdps1; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.transaction ADD CONSTRAINT fk6gkawgcnsnr65spgkl5lrdps1 FOREIGN KEY (type_transaction_id_type_transaction) REFERENCES public.type_transaction(id_type_transaction); -- -- Name: api fk7i3v6t68e3k7bx9s65oeuwwe4; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.api ADD CONSTRAINT fk7i3v6t68e3k7bx9s65oeuwwe4 FOREIGN KEY (partenaire_id_partenaire) REFERENCES public.partenaire(id_partenaire); -- -- Name: session_tontine_transaction fk7n2ceomtci73c2hwratrxe4o1; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine_transaction ADD CONSTRAINT fk7n2ceomtci73c2hwratrxe4o1 FOREIGN KEY (transaction_id) REFERENCES public.transaction(id_transaction); -- -- Name: session_tontine_transaction fkatilmoo1b265w5o1r3d37tc8o; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine_transaction ADD CONSTRAINT fkatilmoo1b265w5o1r3d37tc8o FOREIGN KEY (partenaire_id_partenaire) REFERENCES public.partenaire(id_partenaire); -- -- Name: transaction fkbao02xrp5kdhfgm928wjpym24; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.transaction ADD CONSTRAINT fkbao02xrp5kdhfgm928wjpym24 FOREIGN KEY (partenaire_id_partenaire) REFERENCES public.partenaire(id_partenaire); -- -- Name: decaisser fkc8mhyu8lnemahgvc6ls843n8y; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.decaisser ADD CONSTRAINT fkc8mhyu8lnemahgvc6ls843n8y FOREIGN KEY (app_client_id) REFERENCES public.application(id); -- -- Name: error_code_type fkcqq5yxvnm001715y0mx6n9wc6; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.error_code_type ADD CONSTRAINT fkcqq5yxvnm001715y0mx6n9wc6 FOREIGN KEY (partenaire_id_partenaire) REFERENCES public.partenaire(id_partenaire); -- -- Name: api fkfasptot5hpgyskwteygl9doi2; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.api ADD CONSTRAINT fkfasptot5hpgyskwteygl9doi2 FOREIGN KEY (action_id_type_action) REFERENCES public.type_action(id_type_action); -- -- Name: session_tontine_transaction fkfetn80erg4thom6xyw2xd8k72; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine_transaction ADD CONSTRAINT fkfetn80erg4thom6xyw2xd8k72 FOREIGN KEY (session_tontine_id_session_tontine) REFERENCES public.session_tontine(id_session_tontine); -- -- Name: evenement fkhll5exnomxssbh0sl4acxi49c; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.evenement ADD CONSTRAINT fkhll5exnomxssbh0sl4acxi49c FOREIGN KEY (user_id_user) REFERENCES public.utilisateur(id_user); -- -- Name: transaction fkhynbshqes8xpjlx4ipfhi6g9t; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.transaction ADD CONSTRAINT fkhynbshqes8xpjlx4ipfhi6g9t FOREIGN KEY (app_client_id) REFERENCES public.application(id); -- -- Name: session fkilcauvtis328o0t1kxd0l8ij; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session ADD CONSTRAINT fkilcauvtis328o0t1kxd0l8ij FOREIGN KEY (compagnie_id_partenaire) REFERENCES public.partenaire(id_partenaire); -- -- Name: application fkiwd0iru5pdyhg0u1pw2tss1ro; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.application ADD CONSTRAINT fkiwd0iru5pdyhg0u1pw2tss1ro FOREIGN KEY (user_id_user) REFERENCES public.utilisateur(id_user); -- -- Name: decaisser fkj0bbqo3xdhvtsl9o87obv2n1f; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.decaisser ADD CONSTRAINT fkj0bbqo3xdhvtsl9o87obv2n1f FOREIGN KEY (type_transaction_id_type_transaction) REFERENCES public.type_transaction(id_type_transaction); -- -- Name: api fkj6939j4q5j435msgov243ysta; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.api ADD CONSTRAINT fkj6939j4q5j435msgov243ysta FOREIGN KEY (response_param_id_reponse_param) REFERENCES public.reponse_param(id_reponse_param); -- -- Name: session_tontine fkj9r74an2iwlrmubwd98b8nuyn; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine ADD CONSTRAINT fkj9r74an2iwlrmubwd98b8nuyn FOREIGN KEY (tontine_id_tontine) REFERENCES public.tontine(id_tontine); -- -- Name: session_tontine_transaction fkjtmii0vs7jhpgoslje5kpjir6; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine_transaction ADD CONSTRAINT fkjtmii0vs7jhpgoslje5kpjir6 FOREIGN KEY (evenement_id_evenement) REFERENCES public.evenement(id_evenement); -- -- Name: parametre fkjudhmpit4n84924s03ftxv7hn; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.parametre ADD CONSTRAINT fkjudhmpit4n84924s03ftxv7hn FOREIGN KEY (api_id_api) REFERENCES public.api(id_api); -- -- Name: possible_values fkkngggil54l69gb67elg5soaiv; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.possible_values ADD CONSTRAINT fkkngggil54l69gb67elg5soaiv FOREIGN KEY (response_param_id_reponse_param) REFERENCES public.reponse_param(id_reponse_param); -- -- Name: membres_tontines fkl2bqhfl25o281y5avfxbxf1rq; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.membres_tontines ADD CONSTRAINT fkl2bqhfl25o281y5avfxbxf1rq FOREIGN KEY (id_membre) REFERENCES public.membre(id_membre); -- -- Name: error_code fklmfisekayeyches79fq6rk1yf; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.error_code ADD CONSTRAINT fklmfisekayeyches79fq6rk1yf FOREIGN KEY (error_code_type_id_error_code_type) REFERENCES public.error_code_type(id_error_code_type); -- -- Name: airtime fkoxeqq5gkm83lmc9o9l1sqe1po; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.airtime ADD CONSTRAINT fkoxeqq5gkm83lmc9o9l1sqe1po FOREIGN KEY (partenaire_id_partenaire) REFERENCES public.partenaire(id_partenaire); -- -- Name: api fkpf1f4ywca1vjo2xtyk7976yy1; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.api ADD CONSTRAINT fkpf1f4ywca1vjo2xtyk7976yy1 FOREIGN KEY (reponse_id_type_reponse) REFERENCES public.type_reponse(id_type_reponse); -- -- Name: decaisser fkpiqi3l0u10opktkrjvbt5hvgi; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.decaisser ADD CONSTRAINT fkpiqi3l0u10opktkrjvbt5hvgi FOREIGN KEY (partenaire_id_partenaire) REFERENCES public.partenaire(id_partenaire); -- -- Name: membres_tontines fkqge8y02jdtad7xxsmdwrp28g4; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.membres_tontines ADD CONSTRAINT fkqge8y02jdtad7xxsmdwrp28g4 FOREIGN KEY (id_tontine) REFERENCES public.tontine(id_tontine); -- -- Name: valider_compte_payement_visa fkqnt9am0nb7shaug2gwn0utsij; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.valider_compte_payement_visa ADD CONSTRAINT fkqnt9am0nb7shaug2gwn0utsij FOREIGN KEY (partenaire_id_partenaire) REFERENCES public.partenaire(id_partenaire); -- -- Name: app_client fkqy92xodke271sy3rd5y369qn3; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.app_client ADD CONSTRAINT fkqy92xodke271sy3rd5y369qn3 FOREIGN KEY (user_id) REFERENCES public.utilisateur(id_user); -- -- Name: session_tontine fks64i0snlmo5itvjqmby5nsxv0; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_tontine ADD CONSTRAINT fks64i0snlmo5itvjqmby5nsxv0 FOREIGN KEY (owner_id_user) REFERENCES public.utilisateur(id_user); -- -- Name: cash fktigoxwkj1gau842qa4h0a27qr; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.cash ADD CONSTRAINT fktigoxwkj1gau842qa4h0a27qr FOREIGN KEY (partenaire_id_partenaire) REFERENCES public.partenaire(id_partenaire); -- -- PostgreSQL database dump complete --