--
--





--
-- 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_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_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_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_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_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_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_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: 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: 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);


--
-- 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: 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: 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
\.



--
-- 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: 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: 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: 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: 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: 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: 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: 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: 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);


--
--

