--
--



--
-- Name: permission_enum; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.permission_enum AS ENUM (
    'SUPERADMIN',
    'ADMIN',
    'EDITOR',
    'VIEWER'
);


ALTER TYPE public.permission_enum OWNER TO postgres;

--
-- Name: status_enum; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.status_enum AS ENUM (
    '0',
    '1'
);


ALTER TYPE public.status_enum OWNER TO postgres;



--
-- Name: cities; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.cities (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    state_id bigint NOT NULL,
    country_id bigint NOT NULL,
    status bigint NOT NULL,
    created_at bigint NOT NULL,
    updated_at bigint NOT NULL
);


ALTER TABLE public.cities OWNER TO postgres;

--
-- Name: cities_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.cities ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.cities_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);

--
-- Name: client_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.client_id_seq OWNER TO postgres;

--
-- Name: client_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.client_id_seq OWNED BY public.client.id;


--
-- Name: client_presence; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.client_presence (
    id integer NOT NULL,
    client_id integer NOT NULL,
    presence_name character varying(255) NOT NULL,
    payment_gateway character varying(255) NOT NULL,
    status boolean NOT NULL,
    currency_id bigint NOT NULL,
    country_name character(20) NOT NULL,
    county_code character(10) NOT NULL,
    created_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    updated_at timestamp(0) without time zone,
    CONSTRAINT client_presence_payment_gateway_check CHECK (((payment_gateway)::text = ''::text))
);


ALTER TABLE public.client_presence OWNER TO postgres;

--
-- Name: client_presence_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.client_presence_id_seq OWNER TO postgres;

--
-- Name: client_presence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.client_presence_id_seq OWNED BY public.client_presence.id;


--
-- Name: countries; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.countries (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    code character(10),
    iso2 character(10) NOT NULL,
    region character varying(255) NOT NULL,
    phone_code character varying(10) NOT NULL,
    currency_code character(10) NOT NULL,
    currency_name character varying(255) NOT NULL,
    status boolean NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL
);


ALTER TABLE public.countries OWNER TO postgres;

--
-- Name: coupon; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.coupon (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    description character varying(255) NOT NULL,
    promotional_text1 character varying(255) NOT NULL,
    promotional_text2 character varying(255) NOT NULL,
    promotional_text3 character varying(255) NOT NULL,
    promotional_banner1 character varying(255) NOT NULL,
    promotional_banner2 character varying(255) NOT NULL,
    promotional_banner3 character varying(255) NOT NULL,
    client_id bigint NOT NULL,
    client_presence_id bigint NOT NULL,
    start_date timestamp(0) without time zone NOT NULL,
    end_date timestamp(0) without time zone NOT NULL,
    coupon_type character varying(255) NOT NULL,
    discount_type character varying(255) NOT NULL,
    reedemed_type character varying(255) NOT NULL,
    reedmed_reward smallint NOT NULL,
    code character varying(255) NOT NULL,
    bulk_code json NOT NULL,
    reedmed_cap integer NOT NULL,
    reedmed_cap_per_user integer NOT NULL,
    status boolean NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    created_by integer NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    updated_by integer NOT NULL,
    CONSTRAINT coupon_coupon_type_check CHECK (((coupon_type)::text = ANY (ARRAY[('GROUP'::character varying)::text, ('INDIVIDUAL'::character varying)::text]))),
    CONSTRAINT coupon_discount_type_check CHECK (((discount_type)::text = ANY (ARRAY[('PERCENTAGE'::character varying)::text, ('ABSOLUTE'::character varying)::text]))),
    CONSTRAINT coupon_reedemed_type_check CHECK (((reedemed_type)::text = ''::text))
);


ALTER TABLE public.coupon OWNER TO postgres;

--
-- Name: COLUMN coupon.coupon_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.coupon.coupon_type IS 'Coupon type,Individual/bulk';


--
-- Name: COLUMN coupon.discount_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.coupon.discount_type IS 'Type of discount % or in currency';


--
-- Name: currency; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.currency (
    id bigint NOT NULL,
    currency_name character varying(255) NOT NULL,
    currency_description character varying(255) NOT NULL,
    currency_symbal character varying(255) NOT NULL,
    country_id json NOT NULL,
    currency_code character varying(255) NOT NULL,
    region character varying(255) NOT NULL
);


ALTER TABLE public.currency OWNER TO postgres;

--
-- Name: currency_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.currency_id_seq OWNER TO postgres;

--
-- Name: currency_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.currency_id_seq OWNED BY public.currency.id;


--
-- Name: customer_detail; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.customer_detail (
    id bigint NOT NULL,
    customer_id bigint NOT NULL,
    first_name character varying(255) NOT NULL,
    middle_name character varying(255) NOT NULL,
    last_name character varying(255) NOT NULL,
    birth_date timestamp(0) without time zone NOT NULL,
    age_grouo character varying(255) NOT NULL,
    marital_status character varying(255) NOT NULL,
    gender character varying(255) NOT NULL,
    address character varying(255) NOT NULL,
    streat character varying(255) NOT NULL,
    city character varying(255) NOT NULL,
    country character varying(255) NOT NULL,
    country_code character varying(255) NOT NULL,
    pincode character varying(255) NOT NULL,
    billing_address character varying(255) NOT NULL,
    billing_street character varying(255) NOT NULL,
    billing_city character varying(255) NOT NULL,
    billing_country character varying(255) NOT NULL,
    billing_country_code character varying(255) NOT NULL,
    billing_pincode character varying(255) NOT NULL,
    referral_code character varying(255) NOT NULL,
    referred_code character varying(255) NOT NULL,
    referred_id bigint NOT NULL,
    employment_profession character varying(255) NOT NULL,
    is_email_verified boolean NOT NULL,
    is_phone_verified boolean NOT NULL,
    sync_status boolean NOT NULL,
    enable_notification integer NOT NULL,
    notification_from timestamp(0) without time zone NOT NULL,
    notification_till timestamp(0) without time zone NOT NULL,
    enable_sms_promo integer NOT NULL,
    sms_from timestamp(0) without time zone NOT NULL,
    sms_till timestamp(0) without time zone NOT NULL,
    enable_whatsapp_promo integer NOT NULL,
    whatsapp_from timestamp(0) without time zone NOT NULL,
    whatsapp_till timestamp(0) without time zone NOT NULL,
    enable_email_promo integer NOT NULL,
    email_from timestamp(0) without time zone NOT NULL,
    email_till timestamp(0) without time zone NOT NULL,
    is_wallet character varying(255) NOT NULL,
    currency character(10) NOT NULL,
    wallet_balance numeric(8,2) NOT NULL,
    wallet_modifed_on timestamp(0) without time zone NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    additional_data json NOT NULL,
    CONSTRAINT customer_detail_is_wallet_check CHECK (((is_wallet)::text = ''::text))
);


ALTER TABLE public.customer_detail OWNER TO postgres;

--
-- Name: customer_device; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.customer_device (
    id bigint NOT NULL,
    customer_id bigint NOT NULL,
    platfrom character varying(255) NOT NULL,
    make_model character varying(255) NOT NULL,
    marketing_name character varying(255) NOT NULL,
    os_version character varying(255) NOT NULL,
    screen_resolution character varying(255) NOT NULL,
    device_unique_id character varying(255) NOT NULL,
    last_login timestamp(0) without time zone NOT NULL,
    device_added_on timestamp(0) without time zone NOT NULL,
    status boolean NOT NULL,
    logged_in_status timestamp(0) without time zone NOT NULL,
    current_device boolean NOT NULL,
    device_ip character varying(255) NOT NULL,
    device_location character varying(255) NOT NULL,
    additional_data json NOT NULL
);


ALTER TABLE public.customer_device OWNER TO postgres;

--
-- Name: customers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.customers (
    id bigint NOT NULL,
    user_name character varying(255) NOT NULL,
    email_id character varying(255) NOT NULL,
    phone_number bigint NOT NULL,
    client_id bigint NOT NULL,
    client_presence_id bigint NOT NULL,
    status boolean NOT NULL,
    subscription_status boolean NOT NULL,
    created_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    profile_update boolean NOT NULL,
    country_code character varying(255) NOT NULL
);


ALTER TABLE public.customers OWNER TO postgres;

--
-- Name: customers_presence_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.customers_presence_id_seq OWNER TO postgres;

--
-- Name: customers_presence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.customers_presence_id_seq OWNED BY public.customers.id;


--
-- Name: invoice; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.invoice (
    id bigint NOT NULL,
    invoice_number bigint NOT NULL,
    user_id bigint NOT NULL,
    user_name character varying(255) NOT NULL,
    user_email character varying(255) NOT NULL,
    user_phone character varying(255) NOT NULL,
    order_id bigint NOT NULL,
    user_address text NOT NULL,
    currency character(10) NOT NULL,
    state character(20) NOT NULL,
    country character(20) NOT NULL,
    payment_status character varying(255) NOT NULL,
    amount numeric(8,2) NOT NULL,
    tax_detail json NOT NULL,
    total_tax_amount numeric(8,2) NOT NULL,
    refund_amount numeric(8,2) NOT NULL,
    grand_total numeric(8,2) NOT NULL,
    coupon_used boolean NOT NULL,
    coupon_value numeric(8,2) NOT NULL,
    coupon_code character varying(255) NOT NULL,
    notes text NOT NULL,
    issue_date timestamp(0) without time zone NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    CONSTRAINT invoice_payment_status_check CHECK (((payment_status)::text = ANY (ARRAY[('PENDING'::character varying)::text, ('COMPLETED'::character varying)::text, ('FAILED'::character varying)::text, ('REVERSED'::character varying)::text])))
);


ALTER TABLE public.invoice OWNER TO postgres;

--
-- Name: order_detail; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.order_detail (
    id bigint NOT NULL,
    client_id bigint NOT NULL,
    customer_id bigint NOT NULL,
    client_presence_id bigint NOT NULL,
    package_id bigint NOT NULL,
    package_pricing_id bigint NOT NULL,
    package_name character varying(255) NOT NULL,
    selected_price double precision NOT NULL,
    selected_currency character(10) NOT NULL,
    gatway_id bigint NOT NULL,
    gateway_name character varying(255) NOT NULL,
    taxation_id bigint,
    coupon_id bigint,
    coupon_code character varying(255),
    coupon_amount double precision,
    gateway_raw_data text NOT NULL,
    auto_renewal boolean NOT NULL,
    transaction_id bigint NOT NULL,
    triggered_content_id bigint,
    triggered_content_name bigint,
    status character varying(255) NOT NULL,
    start_date timestamp(0) without time zone NOT NULL,
    end_date timestamp(0) without time zone NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    CONSTRAINT order_detail_status_check CHECK (((status)::text = ANY (ARRAY[('INITIATED'::character varying)::text, ('INPROCESS'::character varying)::text, ('COMPLETED'::character varying)::text, ('FAILED'::character varying)::text, ('REVERSED'::character varying)::text])))
);


ALTER TABLE public.order_detail OWNER TO postgres;

--
-- Name: order_detail_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.order_detail ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
    SEQUENCE NAME public.order_detail_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: payment_gateway_master; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.payment_gateway_master (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    description text NOT NULL,
    logo character varying(255) NOT NULL,
    status boolean NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL
);


ALTER TABLE public.payment_gateway_master OWNER TO postgres;

--
-- Name: payment_mode_saved; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.payment_mode_saved (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    source_type character varying(255) NOT NULL,
    source_detail json NOT NULL,
    is_default boolean NOT NULL,
    status character varying(255) NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    CONSTRAINT payment_mode_saved_source_type_check CHECK (((source_type)::text = ''::text)),
    CONSTRAINT payment_mode_saved_status_check CHECK (((status)::text = ANY (ARRAY[('ACTIVE'::character varying)::text, ('INACTIVE'::character varying)::text])))
);


ALTER TABLE public.payment_mode_saved OWNER TO postgres;

--
-- Name: role_mngt; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.role_mngt (
    id integer NOT NULL,
    created_by_id bigint NOT NULL,
    name character varying(255) NOT NULL,
    description character varying(255) NOT NULL,
    status bigint NOT NULL,
    access_control json NOT NULL,
    last_access_control json NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL
);


ALTER TABLE public.role_mngt OWNER TO postgres;

--
-- Name: states; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.states (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    state_code bigint NOT NULL,
    country_id bigint NOT NULL,
    status bigint NOT NULL,
    created_at bigint NOT NULL,
    updated_at bigint NOT NULL
);


ALTER TABLE public.states OWNER TO postgres;

--
-- Name: states_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.states ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.states_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: subscription_package_pricing; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.subscription_package_pricing (
    id bigint NOT NULL,
    description character varying(255) NOT NULL,
    subscription_package_id bigint NOT NULL,
    currency_id bigint NOT NULL,
    price double precision NOT NULL,
    discount_name bigint NOT NULL,
    discount_promotional_text1 character varying(255) NOT NULL,
    discount_promotional_text2 bigint NOT NULL,
    discount_promotional_text3 bigint NOT NULL,
    discount_promotional_banner1 character varying(255) NOT NULL,
    discount_promotional_banner2 character varying(255) NOT NULL,
    discount_promotional_banner3 bigint NOT NULL,
    discount_type character varying(255) NOT NULL,
    discount_amount double precision NOT NULL,
    platforms json NOT NULL,
    max_allowed_platform smallint NOT NULL,
    status boolean NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    CONSTRAINT subscription_package_pricing_discount_type_check CHECK (((discount_type)::text = ANY (ARRAY[('ABSOLUTE'::character varying)::text, ('PERCENTAGE'::character varying)::text])))
);


ALTER TABLE public.subscription_package_pricing OWNER TO postgres;

--
-- Name: subscription_packages; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.subscription_packages (
    id bigint NOT NULL,
    package_name character varying(255) NOT NULL,
    package_des bigint NOT NULL,
    package_type character varying(255) NOT NULL,
    content_type character varying(255) NOT NULL,
    package_thumb bigint NOT NULL,
    promotion_text1 character varying(255) NOT NULL,
    promotion_text2 character varying(255) NOT NULL,
    promotiona_text3 character varying(255) NOT NULL,
    promotion_thumb1 character varying(255) NOT NULL,
    promotion_thumb2 character varying(255) NOT NULL,
    promotion_thumb3 character varying(255) NOT NULL,
    client_id bigint NOT NULL,
    client_presence_id bigint NOT NULL,
    currency json NOT NULL,
    regional_presence json NOT NULL,
    start_date timestamp(0) without time zone NOT NULL,
    end_date timestamp(0) without time zone NOT NULL,
    availability_window character varying(255) NOT NULL,
    availability_duration integer NOT NULL,
    actual_watch_duration integer NOT NULL,
    status boolean NOT NULL,
    created_by bigint NOT NULL,
    updated_by bigint NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    CONSTRAINT subscription_packages_availability_window_check CHECK (((availability_window)::text = ANY (ARRAY[('HOUR'::character varying)::text, ('DAY'::character varying)::text, ('WEEK'::character varying)::text, ('MONTH'::character varying)::text, ('QUARTER'::character varying)::text, ('YEAR'::character varying)::text]))),
    CONSTRAINT subscription_packages_content_type_check CHECK (((content_type)::text = ANY (ARRAY[('EVENT'::character varying)::text, ('LIVE'::character varying)::text, ('VOD'::character varying)::text]))),
    CONSTRAINT subscription_packages_package_type_check CHECK (((package_type)::text = ANY (ARRAY[('SUBS'::character varying)::text, ('PPV'::character varying)::text, ('RENTAL'::character varying)::text])))
);


ALTER TABLE public.subscription_packages OWNER TO postgres;

--
-- Name: subscription_packages_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.subscription_packages ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.subscription_packages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: taxation; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.taxation (
    id bigint NOT NULL,
    tax_name character varying(255) NOT NULL,
    tax_type character varying(255) NOT NULL,
    tax_rate numeric(10,2) NOT NULL,
    country_id integer NOT NULL,
    state_id integer NOT NULL,
    city_id integer NOT NULL,
    client_id bigint NOT NULL,
    client_presence_id bigint NOT NULL,
    is_applicable boolean NOT NULL,
    effective_date timestamp(0) without time zone NOT NULL,
    end_date timestamp(0) without time zone NOT NULL,
    created_by bigint NOT NULL,
    updated_by bigint NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    CONSTRAINT taxation_tax_type_check CHECK (((tax_type)::text = ''::text))
);


ALTER TABLE public.taxation OWNER TO postgres;

--
-- Name: temp; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.temp (
    id integer NOT NULL,
    name text,
    email text
);


ALTER TABLE public.temp OWNER TO postgres;

--
-- Name: temp_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.temp_id_seq OWNER TO postgres;

--
-- Name: temp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.temp_id_seq OWNED BY public.temp.id;


--
-- Name: transaction; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.transaction (
    id bigint NOT NULL,
    client_id bigint NOT NULL,
    client_presence_id bigint NOT NULL,
    customer_id bigint NOT NULL,
    order_id bigint NOT NULL,
    gateway_transaction_id character varying(255) NOT NULL,
    gateway_transaction_id_completion character varying(255) NOT NULL,
    amount numeric(10,2) NOT NULL,
    currency character(10) NOT NULL,
    payment_status character varying(255) NOT NULL,
    payment_method character varying(255) NOT NULL,
    gateway_id bigint NOT NULL,
    auto_renew boolean NOT NULL,
    auto_renew_date timestamp(0) without time zone NOT NULL,
    auto_renew_expiry timestamp(0) without time zone NOT NULL,
    grace_period_type character varying(255) NOT NULL,
    grace_period_duration integer NOT NULL,
    cancel_date timestamp(0) without time zone NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    transaction_date timestamp(0) without time zone NOT NULL,
    start_date timestamp(0) without time zone NOT NULL,
    end_date timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    CONSTRAINT transaction_grace_period_type_check CHECK (((grace_period_type)::text = ANY (ARRAY[('HOUR'::character varying)::text, ('DAY'::character varying)::text, ('WEEK'::character varying)::text, ('MONTH'::character varying)::text, ('YEAR'::character varying)::text]))),
    CONSTRAINT transaction_payment_status_check CHECK (((payment_status)::text = ANY (ARRAY[('INITIATED'::character varying)::text, ('INPROCESS'::character varying)::text, ('COMPLETED'::character varying)::text, ('FAILED'::character varying)::text, ('REVERSED'::character varying)::text])))
);


ALTER TABLE public.transaction OWNER TO postgres;

--
-- Name: user_wallet; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.user_wallet (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    current_balance bigint NOT NULL,
    previous_balance bigint NOT NULL,
    last_added timestamp(0) without time zone NOT NULL,
    last_spent timestamp(0) without time zone NOT NULL,
    status character varying(255) NOT NULL,
    payment_source character varying(255) NOT NULL,
    currency character(10) NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    CONSTRAINT user_wallet_payment_source_check CHECK (((payment_source)::text = ANY (ARRAY[('CC'::character varying)::text, ('DC'::character varying)::text, ('UPI'::character varying)::text, ('NB'::character varying)::text]))),
    CONSTRAINT user_wallet_status_check CHECK (((status)::text = ANY (ARRAY[('ACTIVE'::character varying)::text, ('INACTIVE'::character varying)::text, ('SUSPENDED'::character varying)::text])))
);


ALTER TABLE public.user_wallet OWNER TO postgres;

--
-- Name: wallet_history; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.wallet_history (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    wallet_id bigint NOT NULL,
    offer_id bigint NOT NULL,
    current_balance double precision NOT NULL,
    previous_balance double precision NOT NULL,
    amount double precision NOT NULL,
    type character varying(255) NOT NULL,
    source character varying(255) NOT NULL,
    refernce_id character varying(255) NOT NULL,
    currency character(10) NOT NULL,
    "transaction _detail" text NOT NULL,
    status character varying(255) NOT NULL,
    initiated_by character varying(255) NOT NULL,
    last_modified timestamp(0) without time zone NOT NULL,
    CONSTRAINT wallet_history_initiated_by_check CHECK (((initiated_by)::text = ANY (ARRAY[('USER'::character varying)::text, ('SYSTEM'::character varying)::text]))),
    CONSTRAINT wallet_history_source_check CHECK (((source)::text = ANY (ARRAY[('WALLET'::character varying)::text, ('CC'::character varying)::text, ('DC'::character varying)::text, ('UPI'::character varying)::text, ('NB'::character varying)::text]))),
    CONSTRAINT wallet_history_status_check CHECK (((status)::text = ANY (ARRAY[('ACTIVE'::character varying)::text, ('INACTIVE'::character varying)::text]))),
    CONSTRAINT wallet_history_type_check CHECK (((type)::text = ANY (ARRAY[('CREDIT'::character varying)::text, ('DEBIT'::character varying)::text])))
);


ALTER TABLE public.wallet_history OWNER TO postgres;

--
-- Name: COLUMN wallet_history.type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.wallet_history.type IS 'Type of transaction, credit or debit';


--
-- Name: COLUMN wallet_history.source; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.wallet_history.source IS 'Source of transaction';


--
-- Name: COLUMN wallet_history.initiated_by; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.wallet_history.initiated_by IS 'Who initiated the payment, user or system';


--
-- Name: wallet_offer; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.wallet_offer (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    description character varying(255) NOT NULL,
    promotional_text1 text NOT NULL,
    promotional_text2 text NOT NULL,
    promotional_banner1 character varying(255) NOT NULL,
    promotional_banner2 character varying(255) NOT NULL,
    currency character(10) NOT NULL,
    amount numeric(8,2) NOT NULL,
    bonus_amount numeric(8,2) NOT NULL,
    max_bonus numeric(8,2) NOT NULL,
    status character varying(255) NOT NULL,
    start_date timestamp(0) without time zone NOT NULL,
    end_date timestamp(0) without time zone NOT NULL,
    created_at timestamp(0) without time zone NOT NULL,
    updated_at timestamp(0) without time zone NOT NULL,
    CONSTRAINT wallet_offer_status_check CHECK (((status)::text = ANY (ARRAY[('ACTIVE'::character varying)::text, ('INACTIVE'::character varying)::text])))
);


ALTER TABLE public.wallet_offer OWNER TO postgres;


--
-- Name: client_presence id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: currency id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: customers id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: temp id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


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

COPY public.cities (id, name, state_id, country_id, status, created_at, updated_at) FROM stdin;
1	New Delhi	1	1	1	1754297220	1754297220
2	gurugram	2	1	1	1754383200	1754383200
3	10003	2	1	1	1754633135	1754633135
4	10004	3	1	1	1754633135	1754633135
5	20001	4	2	1	1754633135	1754633135
\.


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

COPY public.client_presence (id, client_id, presence_name, payment_gateway, status, currency_id, country_name, county_code, created_at, updated_at) FROM stdin;
1	2	parag.@multitvsolution.com		f	1	India               	IN        	2025-07-22 15:06:41	\N
2	1	TechCorp US		t	2	United States       	US        	2025-08-08 11:42:01	2025-08-08 11:42:01
3	2	MediaHouse India		t	1	India               	IN        	2025-08-08 11:42:01	2025-08-08 11:42:01
\.


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

COPY public.countries (id, name, code, iso2, region, phone_code, currency_code, currency_name, status, created_at, updated_at) FROM stdin;
1	India	IN        	IN        	Asia	+91	INR       	Rupee	t	2025-08-04 07:03:09	2025-08-04 07:03:09
2	United States	US        	US        	North America	+1	USD       	US Dollar	t	2025-08-08 11:33:25	2025-08-08 11:33:25
4	Afghanistan	AF        	AF        	Asia	+93	AFN       	Afghan Afghani	t	2025-08-11 11:30:21	2025-08-11 11:30:21
5	Bangladesh	BD        	BD        	Asia	+880	BDT       	Bangladeshi Taka	t	2025-08-11 11:30:21	2025-08-11 11:30:21
6	Bhutan	BT        	BT        	Asia	+975	BTN       	Bhutanese Ngultrum	t	2025-08-11 11:30:21	2025-08-11 11:30:21
7	Brunei	BN        	BN        	Asia	+673	BND       	Brunei Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
8	Cambodia	KH        	KH        	Asia	+855	KHR       	Cambodian Riel	t	2025-08-11 11:30:21	2025-08-11 11:30:21
9	China	CN        	CN        	Asia	+86	CNY       	Chinese Yuan	t	2025-08-11 11:30:21	2025-08-11 11:30:21
10	Indonesia	ID        	ID        	Asia	+62	IDR       	Indonesian Rupiah	t	2025-08-11 11:30:21	2025-08-11 11:30:21
11	Japan	JP        	JP        	Asia	+81	JPY       	Japanese Yen	t	2025-08-11 11:30:21	2025-08-11 11:30:21
12	Kazakhstan	KZ        	KZ        	Asia	+7	KZT       	Kazakhstani Tenge	t	2025-08-11 11:30:21	2025-08-11 11:30:21
13	Kyrgyzstan	KG        	KG        	Asia	+996	KGS       	Kyrgyzstani Som	t	2025-08-11 11:30:21	2025-08-11 11:30:21
14	Laos	LA        	LA        	Asia	+856	LAK       	Lao Kip	t	2025-08-11 11:30:21	2025-08-11 11:30:21
15	Malaysia	MY        	MY        	Asia	+60	MYR       	Malaysian Ringgit	t	2025-08-11 11:30:21	2025-08-11 11:30:21
16	Maldives	MV        	MV        	Asia	+960	MVR       	Maldivian Rufiyaa	t	2025-08-11 11:30:21	2025-08-11 11:30:21
17	Mongolia	MN        	MN        	Asia	+976	MNT       	Mongolian Tugrik	t	2025-08-11 11:30:21	2025-08-11 11:30:21
18	Myanmar	MM        	MM        	Asia	+95	MMK       	Myanmar Kyat	t	2025-08-11 11:30:21	2025-08-11 11:30:21
19	Nepal	NP        	NP        	Asia	+977	NPR       	Nepalese Rupee	t	2025-08-11 11:30:21	2025-08-11 11:30:21
20	North Korea	KP        	KP        	Asia	+850	KPW       	North Korean Won	t	2025-08-11 11:30:21	2025-08-11 11:30:21
21	Pakistan	PK        	PK        	Asia	+92	PKR       	Pakistani Rupee	t	2025-08-11 11:30:21	2025-08-11 11:30:21
22	Philippines	PH        	PH        	Asia	+63	PHP       	Philippine Peso	t	2025-08-11 11:30:21	2025-08-11 11:30:21
23	Singapore	SG        	SG        	Asia	+65	SGD       	Singapore Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
24	South Korea	KR        	KR        	Asia	+82	KRW       	South Korean Won	t	2025-08-11 11:30:21	2025-08-11 11:30:21
25	Sri Lanka	LK        	LK        	Asia	+94	LKR       	Sri Lankan Rupee	t	2025-08-11 11:30:21	2025-08-11 11:30:21
26	Taiwan	TW        	TW        	Asia	+886	TWD       	Taiwan Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
27	Tajikistan	TJ        	TJ        	Asia	+992	TJS       	Tajikistani Somoni	t	2025-08-11 11:30:21	2025-08-11 11:30:21
28	Thailand	TH        	TH        	Asia	+66	THB       	Thai Baht	t	2025-08-11 11:30:21	2025-08-11 11:30:21
29	Turkmenistan	TM        	TM        	Asia	+993	TMT       	Turkmenistani Manat	t	2025-08-11 11:30:21	2025-08-11 11:30:21
30	Uzbekistan	UZ        	UZ        	Asia	+998	UZS       	Uzbekistani Som	t	2025-08-11 11:30:21	2025-08-11 11:30:21
31	Vietnam	VN        	VN        	Asia	+84	VND       	Vietnamese Dong	t	2025-08-11 11:30:21	2025-08-11 11:30:21
32	Albania	AL        	AL        	Europe	+355	ALL       	Albanian Lek	t	2025-08-11 11:30:21	2025-08-11 11:30:21
33	Austria	AT        	AT        	Europe	+43	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
34	Belarus	BY        	BY        	Europe	+375	BYN       	Belarusian Ruble	t	2025-08-11 11:30:21	2025-08-11 11:30:21
35	Belgium	BE        	BE        	Europe	+32	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
36	Bosnia and Herzegovina	BA        	BA        	Europe	+387	BAM       	Bosnia and Herzegovina Convertible Mark	t	2025-08-11 11:30:21	2025-08-11 11:30:21
37	Bulgaria	BG        	BG        	Europe	+359	BGN       	Bulgarian Lev	t	2025-08-11 11:30:21	2025-08-11 11:30:21
38	Croatia	HR        	HR        	Europe	+385	HRK       	Croatian Kuna	t	2025-08-11 11:30:21	2025-08-11 11:30:21
39	Czech Republic	CZ        	CZ        	Europe	+420	CZK       	Czech Koruna	t	2025-08-11 11:30:21	2025-08-11 11:30:21
40	Denmark	DK        	DK        	Europe	+45	DKK       	Danish Krone	t	2025-08-11 11:30:21	2025-08-11 11:30:21
41	Estonia	EE        	EE        	Europe	+372	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
42	Finland	FI        	FI        	Europe	+358	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
43	France	FR        	FR        	Europe	+33	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
44	Germany	DE        	DE        	Europe	+49	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
45	Greece	GR        	GR        	Europe	+30	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
46	Hungary	HU        	HU        	Europe	+36	HUF       	Hungarian Forint	t	2025-08-11 11:30:21	2025-08-11 11:30:21
47	Iceland	IS        	IS        	Europe	+354	ISK       	Icelandic Krona	t	2025-08-11 11:30:21	2025-08-11 11:30:21
48	Ireland	IE        	IE        	Europe	+353	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
49	Italy	IT        	IT        	Europe	+39	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
50	Latvia	LV        	LV        	Europe	+371	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
51	Lithuania	LT        	LT        	Europe	+370	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
52	Luxembourg	LU        	LU        	Europe	+352	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
53	Moldova	MD        	MD        	Europe	+373	MDL       	Moldovan Leu	t	2025-08-11 11:30:21	2025-08-11 11:30:21
54	Montenegro	ME        	ME        	Europe	+382	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
55	Netherlands	NL        	NL        	Europe	+31	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
56	North Macedonia	MK        	MK        	Europe	+389	MKD       	Macedonian Denar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
57	Norway	NO        	NO        	Europe	+47	NOK       	Norwegian Krone	t	2025-08-11 11:30:21	2025-08-11 11:30:21
58	Poland	PL        	PL        	Europe	+48	PLN       	Polish Zloty	t	2025-08-11 11:30:21	2025-08-11 11:30:21
59	Portugal	PT        	PT        	Europe	+351	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
60	Romania	RO        	RO        	Europe	+40	RON       	Romanian Leu	t	2025-08-11 11:30:21	2025-08-11 11:30:21
61	Russia	RU        	RU        	Europe	+7	RUB       	Russian Ruble	t	2025-08-11 11:30:21	2025-08-11 11:30:21
62	Serbia	RS        	RS        	Europe	+381	RSD       	Serbian Dinar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
63	Slovakia	SK        	SK        	Europe	+421	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
64	Slovenia	SI        	SI        	Europe	+386	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
65	Spain	ES        	ES        	Europe	+34	EUR       	Euro	t	2025-08-11 11:30:21	2025-08-11 11:30:21
66	Sweden	SE        	SE        	Europe	+46	SEK       	Swedish Krona	t	2025-08-11 11:30:21	2025-08-11 11:30:21
67	Switzerland	CH        	CH        	Europe	+41	CHF       	Swiss Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
68	Ukraine	UA        	UA        	Europe	+380	UAH       	Ukrainian Hryvnia	t	2025-08-11 11:30:21	2025-08-11 11:30:21
69	Canada	CA        	CA        	North America	+1	CAD       	Canadian Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
70	Mexico	MX        	MX        	North America	+52	MXN       	Mexican Peso	t	2025-08-11 11:30:21	2025-08-11 11:30:21
71	Argentina	AR        	AR        	South America	+54	ARS       	Argentine Peso	t	2025-08-11 11:30:21	2025-08-11 11:30:21
72	Bolivia	BO        	BO        	South America	+591	BOB       	Bolivian Boliviano	t	2025-08-11 11:30:21	2025-08-11 11:30:21
73	Brazil	BR        	BR        	South America	+55	BRL       	Brazilian Real	t	2025-08-11 11:30:21	2025-08-11 11:30:21
74	Chile	CL        	CL        	South America	+56	CLP       	Chilean Peso	t	2025-08-11 11:30:21	2025-08-11 11:30:21
75	Colombia	CO        	CO        	South America	+57	COP       	Colombian Peso	t	2025-08-11 11:30:21	2025-08-11 11:30:21
76	Ecuador	EC        	EC        	South America	+593	USD       	US Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
77	Guyana	GY        	GY        	South America	+592	GYD       	Guyanese Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
78	Paraguay	PY        	PY        	South America	+595	PYG       	Paraguayan Guarani	t	2025-08-11 11:30:21	2025-08-11 11:30:21
79	Peru	PE        	PE        	South America	+51	PEN       	Peruvian Sol	t	2025-08-11 11:30:21	2025-08-11 11:30:21
80	Suriname	SR        	SR        	South America	+597	SRD       	Surinamese Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
81	Uruguay	UY        	UY        	South America	+598	UYU       	Uruguayan Peso	t	2025-08-11 11:30:21	2025-08-11 11:30:21
82	Venezuela	VE        	VE        	South America	+58	VES       	Venezuelan Bolívar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
83	Algeria	DZ        	DZ        	Africa	+213	DZD       	Algerian Dinar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
84	Angola	AO        	AO        	Africa	+244	AOA       	Angolan Kwanza	t	2025-08-11 11:30:21	2025-08-11 11:30:21
85	Benin	BJ        	BJ        	Africa	+229	XOF       	West African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
86	Botswana	BW        	BW        	Africa	+267	BWP       	Botswana Pula	t	2025-08-11 11:30:21	2025-08-11 11:30:21
87	Burkina Faso	BF        	BF        	Africa	+226	XOF       	West African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
88	Burundi	BI        	BI        	Africa	+257	BIF       	Burundian Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
89	Cameroon	CM        	CM        	Africa	+237	XAF       	Central African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
90	Cape Verde	CV        	CV        	Africa	+238	CVE       	Cape Verdean Escudo	t	2025-08-11 11:30:21	2025-08-11 11:30:21
91	Central African Republic	CF        	CF        	Africa	+236	XAF       	Central African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
92	Chad	TD        	TD        	Africa	+235	XAF       	Central African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
93	Comoros	KM        	KM        	Africa	+269	KMF       	Comorian Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
94	Democratic Republic of the Congo	CD        	CD        	Africa	+243	CDF       	Congolese Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
95	Republic of the Congo	CG        	CG        	Africa	+242	XAF       	Central African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
96	Djibouti	DJ        	DJ        	Africa	+253	DJF       	Djiboutian Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
97	Egypt	EG        	EG        	Africa	+20	EGP       	Egyptian Pound	t	2025-08-11 11:30:21	2025-08-11 11:30:21
98	Equatorial Guinea	GQ        	GQ        	Africa	+240	XAF       	Central African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
99	Eritrea	ER        	ER        	Africa	+291	ERN       	Eritrean Nakfa	t	2025-08-11 11:30:21	2025-08-11 11:30:21
100	Eswatini	SZ        	SZ        	Africa	+268	SZL       	Swazi Lilangeni	t	2025-08-11 11:30:21	2025-08-11 11:30:21
101	Ethiopia	ET        	ET        	Africa	+251	ETB       	Ethiopian Birr	t	2025-08-11 11:30:21	2025-08-11 11:30:21
102	Gabon	GA        	GA        	Africa	+241	XAF       	Central African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
103	Gambia	GM        	GM        	Africa	+220	GMD       	Gambian Dalasi	t	2025-08-11 11:30:21	2025-08-11 11:30:21
104	Ghana	GH        	GH        	Africa	+233	GHS       	Ghanaian Cedi	t	2025-08-11 11:30:21	2025-08-11 11:30:21
105	Guinea	GN        	GN        	Africa	+224	GNF       	Guinean Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
106	Guinea-Bissau	GW        	GW        	Africa	+245	XOF       	West African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
107	Ivory Coast	CI        	CI        	Africa	+225	XOF       	West African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
108	Kenya	KE        	KE        	Africa	+254	KES       	Kenyan Shilling	t	2025-08-11 11:30:21	2025-08-11 11:30:21
109	Lesotho	LS        	LS        	Africa	+266	LSL       	Lesotho Loti	t	2025-08-11 11:30:21	2025-08-11 11:30:21
110	Liberia	LR        	LR        	Africa	+231	LRD       	Liberian Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
111	Libya	LY        	LY        	Africa	+218	LYD       	Libyan Dinar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
112	Madagascar	MG        	MG        	Africa	+261	MGA       	Malagasy Ariary	t	2025-08-11 11:30:21	2025-08-11 11:30:21
113	Malawi	MW        	MW        	Africa	+265	MWK       	Malawian Kwacha	t	2025-08-11 11:30:21	2025-08-11 11:30:21
114	Mali	ML        	ML        	Africa	+223	XOF       	West African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
115	Mauritania	MR        	MR        	Africa	+222	MRU       	Mauritanian Ouguiya	t	2025-08-11 11:30:21	2025-08-11 11:30:21
116	Mauritius	MU        	MU        	Africa	+230	MUR       	Mauritian Rupee	t	2025-08-11 11:30:21	2025-08-11 11:30:21
117	Morocco	MA        	MA        	Africa	+212	MAD       	Moroccan Dirham	t	2025-08-11 11:30:21	2025-08-11 11:30:21
118	Mozambique	MZ        	MZ        	Africa	+258	MZN       	Mozambican Metical	t	2025-08-11 11:30:21	2025-08-11 11:30:21
119	Namibia	NA        	NA        	Africa	+264	NAD       	Namibian Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
120	Niger	NE        	NE        	Africa	+227	XOF       	West African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
121	Nigeria	NG        	NG        	Africa	+234	NGN       	Nigerian Naira	t	2025-08-11 11:30:21	2025-08-11 11:30:21
122	Rwanda	RW        	RW        	Africa	+250	RWF       	Rwandan Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
123	São Tomé and Príncipe	ST        	ST        	Africa	+239	STN       	São Tomé and Príncipe Dobra	t	2025-08-11 11:30:21	2025-08-11 11:30:21
124	Senegal	SN        	SN        	Africa	+221	XOF       	West African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
125	Seychelles	SC        	SC        	Africa	+248	SCR       	Seychellois Rupee	t	2025-08-11 11:30:21	2025-08-11 11:30:21
126	Sierra Leone	SL        	SL        	Africa	+232	SLL       	Sierra Leonean Leone	t	2025-08-11 11:30:21	2025-08-11 11:30:21
127	Somalia	SO        	SO        	Africa	+252	SOS       	Somali Shilling	t	2025-08-11 11:30:21	2025-08-11 11:30:21
128	South Africa	ZA        	ZA        	Africa	+27	ZAR       	South African Rand	t	2025-08-11 11:30:21	2025-08-11 11:30:21
129	South Sudan	SS        	SS        	Africa	+211	SSP       	South Sudanese Pound	t	2025-08-11 11:30:21	2025-08-11 11:30:21
130	Sudan	SD        	SD        	Africa	+249	SDG       	Sudanese Pound	t	2025-08-11 11:30:21	2025-08-11 11:30:21
131	Tanzania	TZ        	TZ        	Africa	+255	TZS       	Tanzanian Shilling	t	2025-08-11 11:30:21	2025-08-11 11:30:21
132	Togo	TG        	TG        	Africa	+228	XOF       	West African CFA Franc	t	2025-08-11 11:30:21	2025-08-11 11:30:21
133	Tunisia	TN        	TN        	Africa	+216	TND       	Tunisian Dinar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
134	Uganda	UG        	UG        	Africa	+256	UGX       	Ugandan Shilling	t	2025-08-11 11:30:21	2025-08-11 11:30:21
135	Zambia	ZM        	ZM        	Africa	+260	ZMW       	Zambian Kwacha	t	2025-08-11 11:30:21	2025-08-11 11:30:21
136	Zimbabwe	ZW        	ZW        	Africa	+263	ZWL       	Zimbabwean Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
137	Australia	AU        	AU        	Oceania	+61	AUD       	Australian Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
138	Fiji	FJ        	FJ        	Oceania	+679	FJD       	Fijian Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
139	Kiribati	KI        	KI        	Oceania	+686	AUD       	Australian Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
140	Marshall Islands	MH        	MH        	Oceania	+692	USD       	US Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
141	Micronesia	FM        	FM        	Oceania	+691	USD       	US Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
142	Nauru	NR        	NR        	Oceania	+674	AUD       	Australian Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
143	New Zealand	NZ        	NZ        	Oceania	+64	NZD       	New Zealand Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
144	Palau	PW        	PW        	Oceania	+680	USD       	US Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
145	Papua New Guinea	PG        	PG        	Oceania	+675	PGK       	Papua New Guinean Kina	t	2025-08-11 11:30:21	2025-08-11 11:30:21
146	Samoa	WS        	WS        	Oceania	+685	WST       	Samoan Tala	t	2025-08-11 11:30:21	2025-08-11 11:30:21
147	Solomon Islands	SB        	SB        	Oceania	+677	SBD       	Solomon Islands Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
148	Tonga	TO        	TO        	Oceania	+676	TOP       	Tongan Paʻanga	t	2025-08-11 11:30:21	2025-08-11 11:30:21
149	Tuvalu	TV        	TV        	Oceania	+688	AUD       	Australian Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
150	Vanuatu	VU        	VU        	Oceania	+678	VUV       	Vanuatu Vatu	t	2025-08-11 11:30:21	2025-08-11 11:30:21
151	Bahrain	BH        	BH        	Middle East	+973	BHD       	Bahraini Dinar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
152	Iran	IR        	IR        	Middle East	+98	IRR       	Iranian Rial	t	2025-08-11 11:30:21	2025-08-11 11:30:21
153	Iraq	IQ        	IQ        	Middle East	+964	IQD       	Iraqi Dinar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
154	Israel	IL        	IL        	Middle East	+972	ILS       	Israeli New Shekel	t	2025-08-11 11:30:21	2025-08-11 11:30:21
155	Jordan	JO        	JO        	Middle East	+962	JOD       	Jordanian Dinar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
156	Kuwait	KW        	KW        	Middle East	+965	KWD       	Kuwaiti Dinar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
157	Lebanon	LB        	LB        	Middle East	+961	LBP       	Lebanese Pound	t	2025-08-11 11:30:21	2025-08-11 11:30:21
158	Oman	OM        	OM        	Middle East	+968	OMR       	Omani Rial	t	2025-08-11 11:30:21	2025-08-11 11:30:21
159	Palestine	PS        	PS        	Middle East	+970	ILS       	Israeli New Shekel	t	2025-08-11 11:30:21	2025-08-11 11:30:21
160	Qatar	QA        	QA        	Middle East	+974	QAR       	Qatari Riyal	t	2025-08-11 11:30:21	2025-08-11 11:30:21
161	Saudi Arabia	SA        	SA        	Middle East	+966	SAR       	Saudi Riyal	t	2025-08-11 11:30:21	2025-08-11 11:30:21
162	Syria	SY        	SY        	Middle East	+963	SYP       	Syrian Pound	t	2025-08-11 11:30:21	2025-08-11 11:30:21
163	Turkey	TR        	TR        	Middle East	+90	TRY       	Turkish Lira	t	2025-08-11 11:30:21	2025-08-11 11:30:21
164	United Arab Emirates	AE        	AE        	Middle East	+971	AED       	UAE Dirham	t	2025-08-11 11:30:21	2025-08-11 11:30:21
165	Yemen	YE        	YE        	Middle East	+967	YER       	Yemeni Rial	t	2025-08-11 11:30:21	2025-08-11 11:30:21
166	Antigua and Barbuda	AG        	AG        	Caribbean	+1268	XCD       	East Caribbean Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
167	Bahamas	BS        	BS        	Caribbean	+1242	BSD       	Bahamian Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
168	Barbados	BB        	BB        	Caribbean	+1246	BBD       	Barbadian Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
169	Belize	BZ        	BZ        	Central America	+501	BZD       	Belize Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
170	Costa Rica	CR        	CR        	Central America	+506	CRC       	Costa Rican Colón	t	2025-08-11 11:30:21	2025-08-11 11:30:21
171	Cuba	CU        	CU        	Caribbean	+53	CUP       	Cuban Peso	t	2025-08-11 11:30:21	2025-08-11 11:30:21
172	Dominica	DM        	DM        	Caribbean	+1767	XCD       	East Caribbean Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
173	Dominican Republic	DO        	DO        	Caribbean	+1809	DOP       	Dominican Peso	t	2025-08-11 11:30:21	2025-08-11 11:30:21
174	El Salvador	SV        	SV        	Central America	+503	USD       	US Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
175	Grenada	GD        	GD        	Caribbean	+1473	XCD       	East Caribbean Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
176	Guatemala	GT        	GT        	Central America	+502	GTQ       	Guatemalan Quetzal	t	2025-08-11 11:30:21	2025-08-11 11:30:21
177	Haiti	HT        	HT        	Caribbean	+509	HTG       	Haitian Gourde	t	2025-08-11 11:30:21	2025-08-11 11:30:21
178	Honduras	HN        	HN        	Central America	+504	HNL       	Honduran Lempira	t	2025-08-11 11:30:21	2025-08-11 11:30:21
179	Jamaica	JM        	JM        	Caribbean	+1876	JMD       	Jamaican Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
180	Nicaragua	NI        	NI        	Central America	+505	NIO       	Nicaraguan Córdoba	t	2025-08-11 11:30:21	2025-08-11 11:30:21
181	Panama	PA        	PA        	Central America	+507	PAB       	Panamanian Balboa	t	2025-08-11 11:30:21	2025-08-11 11:30:21
182	Saint Kitts and Nevis	KN        	KN        	Caribbean	+1869	XCD       	East Caribbean Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
183	Saint Lucia	LC        	LC        	Caribbean	+1758	XCD       	East Caribbean Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
184	Saint Vincent and the Grenadines	VC        	VC        	Caribbean	+1784	XCD       	East Caribbean Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
185	Trinidad and Tobago	TT        	TT        	Caribbean	+1868	TTD       	Trinidad and Tobago Dollar	t	2025-08-11 11:30:21	2025-08-11 11:30:21
3	United Kingdom	UK        	UK        	Europe	+44	GBP       	British Pound	t	2025-08-08 11:33:25	2025-08-08 11:33:25
\.


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

COPY public.coupon (id, name, description, promotional_text1, promotional_text2, promotional_text3, promotional_banner1, promotional_banner2, promotional_banner3, client_id, client_presence_id, start_date, end_date, coupon_type, discount_type, reedemed_type, reedmed_reward, code, bulk_code, reedmed_cap, reedmed_cap_per_user, status, created_at, created_by, updated_at, updated_by) FROM stdin;
1	WELCOME10	Welcome discount	Get 10% off	For new users	Limited time	welcome1.jpg	welcome2.jpg	welcome3.jpg	1	1	2025-08-08 11:42:02	2025-11-08 11:42:02	INDIVIDUAL	PERCENTAGE		1	WELCOME10	[]	1000	1	t	2025-08-08 11:42:02	1	2025-08-08 11:42:02	1
2	SAVE20	Save 20%	Get 20% off	Premium users	Special offer	save1.jpg	save2.jpg	save3.jpg	1	1	2025-08-08 11:42:02	2026-02-08 11:42:02	GROUP	PERCENTAGE		2	SAVE20	[]	500	1	t	2025-08-08 11:42:02	1	2025-08-08 11:42:02	1
\.


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

COPY public.currency (id, currency_name, currency_description, currency_symbal, country_id, currency_code, region) FROM stdin;
1	Rupees	India Rupees	$	1	IN	India
2	US Dollar	Official currency of United States	$	[2]	USD	North America
3	British Pound	Official currency of United Kingdom	£	[3]	GBP	Europe
\.


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

COPY public.customer_detail (id, customer_id, first_name, middle_name, last_name, birth_date, age_grouo, marital_status, gender, address, streat, city, country, country_code, pincode, billing_address, billing_street, billing_city, billing_country, billing_country_code, billing_pincode, referral_code, referred_code, referred_id, employment_profession, is_email_verified, is_phone_verified, sync_status, enable_notification, notification_from, notification_till, enable_sms_promo, sms_from, sms_till, enable_whatsapp_promo, whatsapp_from, whatsapp_till, enable_email_promo, email_from, email_till, is_wallet, currency, wallet_balance, wallet_modifed_on, created_at, updated_at, additional_data) FROM stdin;
\.


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

COPY public.customer_device (id, customer_id, platfrom, make_model, marketing_name, os_version, screen_resolution, device_unique_id, last_login, device_added_on, status, logged_in_status, current_device, device_ip, device_location, additional_data) FROM stdin;
\.


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

COPY public.customers (id, user_name, email_id, phone_number, client_id, client_presence_id, status, subscription_status, created_at, profile_update, country_code) FROM stdin;
1	Parag Gulati	parag.@multitvsolution.com	8888888888	1	1	t	t	2025-07-22 15:12:15	f	IN
2	Ram Kumar	rk@gmail.com	9898989898	1	1	t	t	2025-07-22 15:19:50	t	IN
3	Ram Kumar	rk@gmail.com	9898989898	1	1	t	t	2025-07-22 15:25:42	t	IN
4	Sita Sharma	sita@gmail.com	9876543210	1	1	t	f	2025-07-22 15:25:42	t	IN
5	Mohan Das	mohan@gmail.com	9123456789	1	1	t	t	2025-07-22 15:25:42	f	IN
6	Rita Singh	rita@gmail.com	9000000001	1	1	t	f	2025-07-22 15:25:42	t	IN
7	Amit Jain	amit@gmail.com	9890001111	1	1	t	t	2025-07-22 15:25:42	f	IN
8	Geeta Kumari	geeta@gmail.com	9812345678	1	1	t	t	2025-07-22 15:25:42	t	IN
9	Sunil Mehta	sunil@gmail.com	9988776655	1	1	t	f	2025-07-22 15:25:42	t	IN
10	Neha Roy	neha@gmail.com	9900112233	1	1	t	t	2025-07-22 15:25:42	f	IN
11	Anil Kapoor	anil@gmail.com	9666554433	1	1	t	t	2025-07-22 15:25:42	f	IN
12	Priya Das	priya@gmail.com	9555222333	1	1	t	t	2025-07-22 15:25:42	t	IN
13	Karan Patel	karan@gmail.com	9234567890	1	1	t	f	2025-07-22 15:25:42	t	IN
14	Meena Kumari	meena@gmail.com	9999999999	1	1	t	f	2025-07-22 15:25:42	t	IN
15	Tina Sen	tina@gmail.com	9888888888	1	1	t	t	2025-07-22 15:25:42	t	IN
16	Ravi Rao	ravi@gmail.com	9777777777	1	1	t	t	2025-07-22 15:25:42	f	IN
17	Komal Singh	komal@gmail.com	9666666666	1	1	t	t	2025-07-22 15:25:42	t	IN
18	Aditya Verma	aditya@gmail.com	9555555555	1	1	t	f	2025-07-22 15:25:42	f	IN
19	Sneha Mishra	sneha@gmail.com	9444444444	1	1	t	t	2025-07-22 15:25:42	t	IN
20	Harsh Yadav	harsh@gmail.com	9333333333	1	1	t	f	2025-07-22 15:25:42	t	IN
21	Bhavna Joshi	bhavna@gmail.com	9222222222	1	1	t	t	2025-07-22 15:25:42	f	IN
22	Aakash Saxena	aakash@gmail.com	9111111111	1	1	t	t	2025-07-22 15:25:42	t	IN
23	Nidhi Arora	nidhi@gmail.com	9001234567	1	1	t	t	2025-07-22 15:25:42	f	IN
24	Varun Khanna	varun@gmail.com	9012345678	1	1	t	f	2025-07-22 15:25:42	t	IN
25	Pooja Batra	pooja@gmail.com	9023456789	1	1	t	t	2025-07-22 15:25:42	t	IN
26	Rajeev Sinha	rajeev@gmail.com	9034567890	1	1	t	t	2025-07-22 15:25:42	f	IN
27	Divya Mehra	divya@gmail.com	9045678901	1	1	t	f	2025-07-22 15:25:42	t	IN
28	Gaurav Kapoor	gaurav@gmail.com	9056789012	1	1	t	t	2025-07-22 15:25:42	t	IN
29	Anita Nair	anita@gmail.com	9067890123	1	1	t	f	2025-07-22 15:25:42	f	IN
30	Deepak Malik	deepak@gmail.com	9078901234	1	1	t	t	2025-07-22 15:25:42	t	IN
31	Rashmi Rani	rashmi@gmail.com	9089012345	1	1	t	t	2025-07-22 15:25:42	f	IN
32	Manoj Tiwari	manoj@gmail.com	9090123456	1	1	t	f	2025-07-22 15:25:42	t	IN
33	Kavita Kaul	kavita@gmail.com	9101234567	1	1	t	t	2025-07-22 15:25:42	t	IN
34	Arjun Reddy	arjun@gmail.com	9112345678	1	1	t	t	2025-07-22 15:25:42	f	IN
35	Sonam Kapoor	sonam@gmail.com	9123456789	1	1	t	t	2025-07-22 15:25:42	t	IN
36	Suresh Iyer	suresh@gmail.com	9134567890	1	1	t	f	2025-07-22 15:25:42	f	IN
37	Bhavya Rao	bhavya@gmail.com	9145678901	1	1	t	t	2025-07-22 15:25:42	t	IN
38	Nikhil Jain	nikhil@gmail.com	9156789012	1	1	t	t	2025-07-22 15:25:42	t	IN
39	Lavanya Pillai	lavanya@gmail.com	9167890123	1	1	t	f	2025-07-22 15:25:42	f	IN
40	Aarti Singh	aarti@gmail.com	9178901234	1	1	t	t	2025-07-22 15:25:42	t	IN
41	Dinesh Karthik	dinesh@gmail.com	9189012345	1	1	t	f	2025-07-22 15:25:42	t	IN
42	Sanjay Roy	sanjay@gmail.com	9190123456	1	1	t	t	2025-07-22 15:25:42	f	IN
43	Alice Johnson	alice1@example.com	9011110001	1	1	t	f	2025-07-22 18:12:16	t	US
44	Bob Smith	bob2@example.com	9011110002	1	1	f	t	2025-07-22 18:12:16	f	CA
45	Carol White	carol3@example.com	9011110003	1	1	t	t	2025-07-22 18:12:16	t	UK
46	David Brown	david4@example.com	9011110004	1	1	f	f	2025-07-22 18:12:16	t	AU
47	Eva Green	eva5@example.com	9011110005	1	1	t	f	2025-07-22 18:12:16	f	IN
48	Frank Lee	frank6@example.com	9011110006	1	1	t	t	2025-07-22 18:12:16	t	DE
49	Grace Kim	grace7@example.com	9011110007	1	1	f	t	2025-07-22 18:12:16	f	JP
50	Henry Park	henry8@example.com	9011110008	1	1	t	t	2025-07-22 18:12:16	t	KR
51	Ivy Chen	ivy9@example.com	9011110009	1	1	t	f	2025-07-22 18:12:16	t	CN
52	Jack Lin	jack10@example.com	9011110010	1	1	f	t	2025-07-22 18:12:16	f	SG
53	Kara Xu	kara11@example.com	9011110011	1	1	t	t	2025-07-22 18:12:16	t	MY
54	Leo Tan	leo12@example.com	9011110012	1	1	f	f	2025-07-22 18:12:16	f	NZ
55	Maya Patel	maya13@example.com	9011110013	1	1	t	t	2025-07-22 18:12:16	t	AE
56	Nolan Desai	nolan14@example.com	9011110014	1	1	f	f	2025-07-22 18:12:16	t	ZA
57	Olivia Singh	olivia15@example.com	9011110015	1	1	t	t	2025-07-22 18:12:16	f	NG
58	Peter Iqbal	peter16@example.com	9011110016	1	1	t	f	2025-07-22 18:12:16	t	PK
59	Quincy Rana	quincy17@example.com	9011110017	1	1	f	t	2025-07-22 18:12:16	t	BD
60	Rita Mehta	rita18@example.com	9011110018	1	1	t	t	2025-07-22 18:12:16	t	LK
61	Steve George	steve19@example.com	9011110019	1	1	f	f	2025-07-22 18:12:16	f	PH
62	Tina Das	tina20@example.com	9011110020	1	1	t	t	2025-07-22 18:12:16	t	TH
63	Uma Prasad	uma21@example.com	9011110021	1	1	f	t	2025-07-22 18:12:16	f	VN
64	Victor Ho	victor22@example.com	9011110022	1	1	t	f	2025-07-22 18:12:16	t	HK
65	Wendy Lau	wendy23@example.com	9011110023	1	1	t	t	2025-07-22 18:12:16	t	TW
66	Xander Cheung	xander24@example.com	9011110024	1	1	f	f	2025-07-22 18:12:16	f	ID
67	Yara Ng	yara25@example.com	9011110025	1	1	t	f	2025-07-22 18:12:16	t	NP
68	Zane Roy	zane26@example.com	9011110026	1	1	t	t	2025-07-22 18:12:16	f	SA
69	Amy Paul	amy27@example.com	9011110027	1	1	f	t	2025-07-22 18:12:16	t	QA
70	Ben Tom	ben28@example.com	9011110028	1	1	t	t	2025-07-22 18:12:16	t	OM
71	Cleo Zee	cleo29@example.com	9011110029	1	1	f	f	2025-07-22 18:12:16	t	KW
72	Dan Fox	dan30@example.com	9011110030	1	1	t	f	2025-07-22 18:12:16	f	BH
73	Ella Mac	ella31@example.com	9011110031	1	1	t	t	2025-07-22 18:12:16	t	EG
74	Fred Kent	fred32@example.com	9011110032	1	1	f	t	2025-07-22 18:12:16	t	KE
75	Gina Hall	gina33@example.com	9011110033	1	1	t	t	2025-07-22 18:12:16	f	GH
76	Hank Reid	hank34@example.com	9011110034	1	1	f	f	2025-07-22 18:12:16	t	TZ
77	Isla Ray	isla35@example.com	9011110035	1	1	t	f	2025-07-22 18:12:16	t	UG
78	Jay Hope	jay36@example.com	9011110036	1	1	t	t	2025-07-22 18:12:16	t	ET
79	Kate Hill	kate37@example.com	9011110037	1	1	f	t	2025-07-22 18:12:16	f	DZ
80	Luke Ford	luke38@example.com	9011110038	1	1	t	f	2025-07-22 18:12:16	t	MA
81	Mira Nash	mira39@example.com	9011110039	1	1	t	t	2025-07-22 18:12:16	f	TN
82	Nate Bose	nate40@example.com	9011110040	1	1	f	t	2025-07-22 18:12:16	t	CI
83	Opal Suri	opal41@example.com	9011110041	1	1	t	f	2025-07-22 18:12:16	t	SN
84	Perry Kim	perry42@example.com	9011110042	1	1	f	f	2025-07-22 18:12:16	t	UG
85	Quinn Vohra	quinn43@example.com	9011110043	1	1	t	t	2025-07-22 18:12:16	f	IR
86	Ricky Cho	ricky44@example.com	9011110044	1	1	t	f	2025-07-22 18:12:16	t	IQ
87	Sana Mir	sana45@example.com	9011110045	1	1	f	t	2025-07-22 18:12:16	t	SY
88	Tariq Shah	tariq46@example.com	9011110046	1	1	t	t	2025-07-22 18:12:16	f	JO
89	Usha Devi	usha47@example.com	9011110047	1	1	f	t	2025-07-22 18:12:16	t	YE
90	Vikram Rao	vikram48@example.com	9011110048	1	1	t	t	2025-07-22 18:12:16	t	AZ
91	Waseem Ali	waseem49@example.com	9011110049	1	1	f	f	2025-07-22 18:12:16	f	AM
92	Xena Kaur	xena50@example.com	9011110050	1	1	t	t	2025-07-22 18:12:16	t	GE
93	Zoe Khan	zoe51@example.com	9011110051	1	1	t	f	2025-07-22 18:12:16	t	US
94	Aaron Gill	aaron52@example.com	9011110052	1	1	t	t	2025-07-22 18:12:16	f	AU
95	Bella Singh	bella53@example.com	9011110053	1	1	f	t	2025-07-22 18:12:16	t	GB
96	Chris Wu	chris54@example.com	9011110054	1	1	t	f	2025-07-22 18:12:16	t	CA
97	Daisy Roy	daisy55@example.com	9011110055	1	1	t	t	2025-07-22 18:12:16	t	SG
98	Eliot Jain	eliot56@example.com	9011110056	1	1	f	t	2025-07-22 18:12:16	f	NZ
99	Farah Jha	farah57@example.com	9011110057	1	1	t	f	2025-07-22 18:12:16	t	IN
100	Gautam Nair	gautam58@example.com	9011110058	1	1	f	f	2025-07-22 18:12:16	t	AE
101	Hina Ali	hina59@example.com	9011110059	1	1	t	t	2025-07-22 18:12:16	t	PK
102	Ivan Patel	ivan60@example.com	9011110060	1	1	t	f	2025-07-22 18:12:16	f	BD
103	Kavya_Dubey_4855	Kavya.Dubey960@outlook.com	9089466105	1	1	t	t	2025-08-07 16:34:41	t	IN
104	Vikram_Gupta_4712	Vikram.Gupta753@test.com	9013887991	1	1	t	f	2025-08-07 16:34:41	f	IN
105	Sita_Gupta_8702	Sita.Gupta495@test.com	9542340125	1	1	t	t	2025-08-07 16:34:41	f	UK
106	Ramesh_Patel_1801	Ramesh.Patel329@gmail.com	9886925808	1	1	t	f	2025-08-07 16:34:41	t	CA
107	Anjali_Kumar_5732	Anjali.Kumar782@hotmail.com	9122735913	1	1	t	t	2025-08-07 16:34:41	f	AU
108	Vikram_Bansal_4413	Vikram.Bansal798@hotmail.com	9132440760	1	1	t	t	2025-08-07 16:34:41	t	US
109	Ravi_Malhotra_9404	Ravi.Malhotra434@outlook.com	9584887928	1	1	t	t	2025-08-07 16:34:42	f	IN
110	Karan_Gupta_604	Karan.Gupta350@yahoo.com	9678108267	1	1	t	f	2025-08-07 16:34:42	t	UK
111	Ramesh_Bhatia_1218	Ramesh.Bhatia740@test.com	9197739950	1	1	t	t	2025-08-07 16:34:42	t	CA
112	Rohit_Pandey_2472	Rohit.Pandey163@hotmail.com	9122634066	1	1	t	f	2025-08-07 16:34:42	t	US
113	Meera_Saxena_3790	Meera.Saxena320@yahoo.com	9776835138	1	1	t	f	2025-08-07 16:34:42	t	US
114	Arjun_Malhotra_825	Arjun.Malhotra802@test.com	9153857696	1	1	t	t	2025-08-07 16:34:42	t	IN
115	Rekha_Bansal_8015	Rekha.Bansal505@yahoo.com	9186936100	1	1	t	f	2025-08-07 16:34:42	t	UK
116	Rekha_Jain_1403	Rekha.Jain225@hotmail.com	9157426830	1	1	t	t	2025-08-07 16:34:42	t	CA
117	Karan_Malhotra_8598	Karan.Malhotra990@test.com	9020845108	1	1	t	f	2025-08-07 16:34:42	f	CA
133	Usha_Kapoor_2878	Usha.Kapoor221@yahoo.com	9112137358	1	1	t	f	2025-08-07 16:35:04	f	AU
134	Akash_Bansal_1023	Akash.Bansal561@gmail.com	9395250258	1	1	t	f	2025-08-07 16:35:04	f	IN
135	Geeta_Saxena_2233	Geeta.Saxena489@outlook.com	9872912993	1	1	t	t	2025-08-07 16:35:04	f	CA
136	Nisha_Kumar_9150	Nisha.Kumar659@test.com	9996823676	1	1	t	f	2025-08-07 16:35:05	t	CA
137	Anjali_Sharma_7337	Anjali.Sharma133@yahoo.com	9463831079	1	1	t	f	2025-08-07 16:35:05	t	AU
138	Vikram_Saxena_7324	Vikram.Saxena350@hotmail.com	9063707492	1	1	t	t	2025-08-07 16:35:05	f	IN
139	Rekha_Malhotra_5321	Rekha.Malhotra955@test.com	9737210705	1	1	t	f	2025-08-07 16:35:05	f	AU
140	Sneha_Sethi_3914	Sneha.Sethi694@yahoo.com	9363588745	1	1	t	f	2025-08-07 16:35:05	t	AU
141	Akash_Dubey_3758	Akash.Dubey725@test.com	9813994863	1	1	t	t	2025-08-07 16:35:06	t	CA
142	Anjali_Jain_1110	Anjali.Jain115@hotmail.com	9054333437	1	1	t	f	2025-08-07 16:35:06	t	IN
143	Sanjay_Joshi_5336	Sanjay.Joshi86@hotmail.com	9051330620	1	1	t	f	2025-08-07 16:35:06	t	UK
144	Kavya_Sethi_6149	Kavya.Sethi113@test.com	9786953071	1	1	t	t	2025-08-07 16:35:06	t	AU
145	Deepak_Bansal_5435	Deepak.Bansal485@hotmail.com	9752025278	1	1	t	t	2025-08-07 16:35:06	f	US
146	Kavya_Srivastava_8242	Kavya.Srivastava83@test.com	9746768839	1	1	t	t	2025-08-07 16:35:07	f	CA
147	Lata_Tiwari_3509	Lata.Tiwari85@yahoo.com	9549791777	1	1	t	t	2025-08-07 16:35:07	f	CA
148	Divya_Kumar_5870	Divya.Kumar545@hotmail.com	9406379036	2	1	t	t	2025-08-07 16:35:07	f	CA
149	Vinod_Jain_7991	Vinod.Jain395@test.com	9503380346	2	1	t	f	2025-08-07 16:35:08	f	US
150	Vikram_Kumar_8030	Vikram.Kumar176@outlook.com	9710262045	2	1	t	t	2025-08-07 16:35:08	t	UK
151	Divya_Agarwal_4113	Divya.Agarwal387@hotmail.com	9356511654	2	1	t	t	2025-08-07 16:35:08	f	US
152	Ravi_Agarwal_2686	Ravi.Agarwal834@outlook.com	9979471714	2	1	t	f	2025-08-07 16:35:08	f	US
153	Ravi_Srivastava_8551	Ravi.Srivastava837@gmail.com	9519263594	2	1	t	f	2025-08-07 16:35:08	t	CA
154	Divya_Joshi_8465	Divya.Joshi63@outlook.com	9592131652	2	1	t	t	2025-08-07 16:35:08	f	US
155	Karan_Tiwari_3124	Karan.Tiwari114@test.com	9966020599	2	1	t	t	2025-08-07 16:35:08	f	IN
156	Amit_Mishra_6934	Amit.Mishra255@hotmail.com	9689576108	2	1	t	f	2025-08-07 16:35:08	t	IN
157	Pooja_Sethi_6223	Pooja.Sethi535@test.com	9671992419	2	1	t	t	2025-08-07 16:35:09	t	AU
158	Sanjay_Pandey_4055	Sanjay.Pandey780@gmail.com	9770067819	2	1	t	f	2025-08-07 16:35:09	f	CA
159	Rajesh_Bansal_2659	Rajesh.Bansal182@hotmail.com	9347394658	2	1	t	t	2025-08-07 16:35:09	f	AU
160	Akash_Saxena_4315	Akash.Saxena632@outlook.com	9395912294	2	1	t	f	2025-08-07 16:35:09	f	IN
161	Priya_Dubey_1847	Priya.Dubey400@hotmail.com	9745213273	2	1	t	f	2025-08-07 16:35:09	f	US
162	Pooja_Gupta_8644	Pooja.Gupta823@test.com	9382409105	2	1	t	t	2025-08-07 16:35:09	f	UK
163	Rekha_Srivastava_8707	Rekha.Srivastava808@outlook.com	9233182527	1	1	t	t	2025-08-07 16:38:23	t	AU
164	Manoj_Sharma_5333	Manoj.Sharma801@outlook.com	9830139372	1	1	t	f	2025-08-07 16:38:23	t	IN
165	Ritu_Agarwal_1476	Ritu.Agarwal821@gmail.com	9410094243	1	1	t	f	2025-08-07 16:38:23	f	CA
166	Lata_Patel_3143	Lata.Patel845@gmail.com	9028929800	1	1	t	f	2025-08-07 16:38:23	f	CA
167	Usha_Pandey_4871	Usha.Pandey145@gmail.com	9594903117	1	1	t	f	2025-08-07 16:38:23	t	AU
168	Geeta_Mishra_1598	Geeta.Mishra836@gmail.com	9933756618	1	1	t	t	2025-08-07 16:38:23	t	US
169	Ashok_Tiwari_7539	Ashok.Tiwari450@gmail.com	9213525376	1	1	t	t	2025-08-07 16:38:23	t	CA
170	Usha_Sharma_7115	Usha.Sharma518@hotmail.com	9596030382	1	1	t	f	2025-08-07 16:38:23	t	AU
171	Sanjay_Bhatia_8005	Sanjay.Bhatia435@yahoo.com	9426098579	1	1	t	t	2025-08-07 16:38:23	t	UK
172	Ravi_Singh_1136	Ravi.Singh575@hotmail.com	9872839089	1	1	t	f	2025-08-07 16:38:23	t	IN
173	Vinod_Bansal_5127	Vinod.Bansal565@yahoo.com	9140454144	1	1	t	f	2025-08-07 16:38:24	t	UK
174	Ashok_Pandey_4060	Ashok.Pandey616@gmail.com	9844664180	1	1	t	t	2025-08-07 16:38:24	t	UK
175	Lata_Malhotra_3754	Lata.Malhotra310@outlook.com	9258796493	1	1	t	f	2025-08-07 16:38:24	f	US
176	Vikram_Tiwari_1821	Vikram.Tiwari211@gmail.com	9167501431	1	1	t	f	2025-08-07 16:38:24	t	CA
177	Ravi_Saxena_3894	Ravi.Saxena619@hotmail.com	9362627691	1	1	t	f	2025-08-07 16:38:24	f	US
178	Nisha_Singh_7706	Nisha.Singh862@yahoo.com	9821371748	2	1	t	t	2025-08-07 16:38:24	t	CA
179	Deepak_Malhotra_6092	Deepak.Malhotra1@gmail.com	9991181633	2	1	t	t	2025-08-07 16:38:25	t	US
180	Kavya_Joshi_5222	Kavya.Joshi692@outlook.com	9665179966	2	1	t	f	2025-08-07 16:38:25	f	IN
181	Amit_Singh_9399	Amit.Singh394@hotmail.com	9899199871	2	1	t	t	2025-08-07 16:38:25	f	CA
182	Nisha_Mishra_3748	Nisha.Mishra637@gmail.com	9233760260	2	1	t	t	2025-08-07 16:38:25	t	IN
183	Sita_Sharma_9062	Sita.Sharma727@outlook.com	9815671579	2	1	t	t	2025-08-07 16:38:25	f	UK
184	Amit_Kapoor_3175	Amit.Kapoor540@hotmail.com	9889830973	2	1	t	f	2025-08-07 16:38:25	f	UK
185	Arjun_Bhatia_2008	Arjun.Bhatia78@test.com	9846494891	2	1	t	f	2025-08-07 16:38:25	f	AU
186	Ravi_Sharma_9733	Ravi.Sharma319@gmail.com	9748022857	2	1	t	f	2025-08-07 16:38:26	t	CA
187	Akash_Sethi_120	Akash.Sethi861@hotmail.com	9025199264	2	1	t	f	2025-08-07 16:38:26	t	US
188	Manoj_Jain_6575	Manoj.Jain339@hotmail.com	9300585419	2	1	t	t	2025-08-07 16:38:26	f	AU
189	Sneha_Chopra_874	Sneha.Chopra648@hotmail.com	9571224064	2	1	t	t	2025-08-07 16:38:26	t	IN
190	Sunita_Verma_3702	Sunita.Verma694@gmail.com	9890807655	2	1	t	f	2025-08-07 16:38:26	t	CA
191	Sneha_Dubey_3128	Sneha.Dubey35@hotmail.com	9434790866	2	1	t	t	2025-08-07 16:38:27	t	AU
192	Manoj_Sharma_6217	Manoj.Sharma541@gmail.com	9031570930	2	1	t	f	2025-08-07 16:38:27	f	US
193	Sanjay_Jain_8513	Sanjay.Jain741@test.com	9651588377	1	1	t	t	2025-08-08 11:00:41	f	AU
194	Sneha_Dubey_5369	Sneha.Dubey664@gmail.com	9355839654	1	1	t	f	2025-08-08 11:00:41	t	AU
195	Usha_Agarwal_2993	Usha.Agarwal123@hotmail.com	9812966764	1	1	t	t	2025-08-08 11:00:41	f	US
196	Arjun_Kumar_8	Arjun.Kumar776@yahoo.com	9928061698	1	1	t	f	2025-08-08 11:00:41	t	IN
197	Sunita_Kumar_557	Sunita.Kumar902@test.com	9055092753	1	1	t	f	2025-08-08 11:00:41	t	US
198	Suresh_Sethi_1072	Suresh.Sethi53@yahoo.com	9106094431	1	1	t	f	2025-08-08 11:00:41	f	IN
199	Ritu_Patel_6441	Ritu.Patel448@hotmail.com	9759385764	1	1	t	t	2025-08-08 11:00:42	f	IN
200	Divya_Verma_1902	Divya.Verma553@hotmail.com	9986144733	1	1	t	t	2025-08-08 11:00:42	t	IN
201	Arjun_Yadav_36	Arjun.Yadav536@gmail.com	9320865280	1	1	t	t	2025-08-08 11:00:42	f	US
202	Arjun_Gupta_27	Arjun.Gupta329@gmail.com	9615501769	1	1	t	f	2025-08-08 11:00:42	t	UK
203	Ravi_Chopra_1495	Ravi.Chopra175@test.com	9992933362	1	1	t	t	2025-08-08 11:00:42	t	CA
204	Ritu_Srivastava_8370	Ritu.Srivastava974@yahoo.com	9046740057	1	1	t	f	2025-08-08 11:00:42	f	AU
205	Anjali_Agarwal_2028	Anjali.Agarwal490@test.com	9732243081	1	1	t	t	2025-08-08 11:00:43	f	US
206	Priya_Dubey_789	Priya.Dubey724@gmail.com	9289800671	1	1	t	t	2025-08-08 11:00:43	f	US
207	Rajesh_Pandey_727	Rajesh.Pandey405@yahoo.com	9813607782	1	1	t	f	2025-08-08 11:00:43	f	CA
208	Divya_Verma_740	Divya.Verma492@gmail.com	9565459627	2	1	t	t	2025-08-08 11:00:43	t	AU
209	Anjali_Gupta_1268	Anjali.Gupta204@hotmail.com	9898070190	2	1	t	t	2025-08-08 11:00:43	f	CA
210	Divya_Saxena_8310	Divya.Saxena405@test.com	9367474958	2	1	t	f	2025-08-08 11:00:43	t	IN
211	Rohit_Singh_5743	Rohit.Singh934@yahoo.com	9385931386	2	1	t	f	2025-08-08 11:00:44	t	UK
212	Manoj_Yadav_7743	Manoj.Yadav360@outlook.com	9225642214	2	1	t	f	2025-08-08 11:00:44	f	AU
213	Kavya_Sethi_9237	Kavya.Sethi555@yahoo.com	9057835184	2	1	t	t	2025-08-08 11:00:44	f	IN
214	Vikram_Sethi_2611	Vikram.Sethi358@yahoo.com	9960868235	2	1	t	f	2025-08-08 11:00:44	f	US
215	Rajesh_Jain_1095	Rajesh.Jain343@yahoo.com	9875627117	2	1	t	f	2025-08-08 11:00:44	t	AU
216	Sneha_Jain_642	Sneha.Jain979@test.com	9295393361	2	1	t	f	2025-08-08 11:00:45	f	US
217	Pooja_Bansal_2466	Pooja.Bansal193@test.com	9867897023	2	1	t	t	2025-08-08 11:00:45	t	AU
218	Deepak_Joshi_4881	Deepak.Joshi740@gmail.com	9749402125	2	1	t	t	2025-08-08 11:00:45	t	UK
219	Rajesh_Kumar_5624	Rajesh.Kumar650@outlook.com	9072322383	2	1	t	t	2025-08-08 11:00:45	f	CA
220	Arjun_Chopra_6051	Arjun.Chopra900@yahoo.com	9620172318	2	1	t	f	2025-08-08 11:00:46	t	AU
221	Ravi_Srivastava_8605	Ravi.Srivastava102@outlook.com	9392759147	2	1	t	f	2025-08-08 11:00:46	f	AU
222	Ravi_Sethi_9615	Ravi.Sethi967@yahoo.com	9868640063	2	1	t	t	2025-08-08 11:00:46	t	IN
223	Suresh_Srivastava_3156	Suresh.Srivastava733@test.com	9395288617	1	1	t	t	2025-08-08 11:07:08	t	US
224	Ravi_Dubey_4079	Ravi.Dubey371@outlook.com	9533986833	1	1	t	t	2025-08-08 11:07:08	t	US
225	Pooja_Chopra_1892	Pooja.Chopra545@gmail.com	9877602075	1	1	t	f	2025-08-08 11:07:08	t	CA
226	Pooja_Srivastava_9429	Pooja.Srivastava573@yahoo.com	9268743639	1	1	t	t	2025-08-08 11:07:08	t	UK
227	Ravi_Patel_8137	Ravi.Patel791@outlook.com	9653507164	1	1	t	f	2025-08-08 11:07:08	t	CA
228	Vikram_Srivastava_1162	Vikram.Srivastava830@gmail.com	9441652044	1	1	t	f	2025-08-08 11:07:09	f	UK
229	Usha_Srivastava_4851	Usha.Srivastava715@test.com	9471901951	1	1	t	t	2025-08-08 11:07:09	t	US
230	Meera_Joshi_5576	Meera.Joshi396@gmail.com	9042278134	1	1	t	t	2025-08-08 11:07:09	f	CA
231	Akash_Sethi_435	Akash.Sethi195@gmail.com	9739934071	1	1	t	t	2025-08-08 11:07:09	t	CA
232	Sunita_Yadav_5336	Sunita.Yadav476@test.com	9543401365	1	1	t	f	2025-08-08 11:07:09	t	CA
233	Akash_Chopra_4349	Akash.Chopra451@hotmail.com	9931441264	1	1	t	f	2025-08-08 11:07:09	t	UK
234	Usha_Patel_6218	Usha.Patel592@gmail.com	9244819583	1	1	t	t	2025-08-08 11:07:09	f	US
235	Arjun_Srivastava_2377	Arjun.Srivastava76@test.com	9375354678	1	1	t	f	2025-08-08 11:07:09	t	IN
236	Geeta_Mishra_4877	Geeta.Mishra823@yahoo.com	9980669120	1	1	t	f	2025-08-08 11:07:09	f	IN
237	Akash_Bhatia_7549	Akash.Bhatia324@yahoo.com	9972048237	1	1	t	f	2025-08-08 11:07:10	f	AU
238	Sanjay_Joshi_8364	Sanjay.Joshi485@outlook.com	9976208206	2	1	t	t	2025-08-08 11:07:10	f	UK
239	Meera_Dubey_5728	Meera.Dubey848@hotmail.com	9948500965	2	1	t	f	2025-08-08 11:07:10	t	AU
240	Manoj_Mishra_4674	Manoj.Mishra879@gmail.com	9800066828	2	1	t	t	2025-08-08 11:07:10	f	CA
241	Usha_Malhotra_426	Usha.Malhotra21@outlook.com	9980574481	2	1	t	t	2025-08-08 11:07:10	f	US
242	Suresh_Verma_4840	Suresh.Verma804@yahoo.com	9186367640	2	1	t	f	2025-08-08 11:07:10	t	IN
243	Meera_Bansal_6292	Meera.Bansal622@hotmail.com	9501023850	2	1	t	t	2025-08-08 11:07:10	f	IN
244	Ritu_Bhatia_6024	Ritu.Bhatia826@gmail.com	9831288175	2	1	t	t	2025-08-08 11:07:10	f	CA
245	Anjali_Joshi_4382	Anjali.Joshi736@outlook.com	9674599511	2	1	t	t	2025-08-08 11:07:10	f	US
246	Karan_Patel_9629	Karan.Patel444@outlook.com	9044869109	2	1	t	t	2025-08-08 11:07:11	f	IN
247	Kavya_Sharma_6646	Kavya.Sharma630@outlook.com	9726535940	2	1	t	f	2025-08-08 11:07:11	f	US
248	Anjali_Srivastava_9903	Anjali.Srivastava523@test.com	9000101409	2	1	t	t	2025-08-08 11:07:11	t	AU
249	Usha_Singh_5573	Usha.Singh551@outlook.com	9845319777	2	1	t	t	2025-08-08 11:07:11	t	CA
250	Ritu_Sethi_315	Ritu.Sethi615@test.com	9914750618	2	1	t	t	2025-08-08 11:07:11	t	CA
251	Geeta_Gupta_327	Geeta.Gupta594@hotmail.com	9324864401	2	1	t	f	2025-08-08 11:07:11	t	CA
252	Usha_Joshi_8245	Usha.Joshi196@hotmail.com	9652078653	2	1	t	t	2025-08-08 11:07:11	f	UK
253	Deepak_Mishra_4111	Deepak.Mishra527@outlook.com	9189504296	1	1	t	t	2025-08-08 11:08:54	f	UK
254	Manoj_Singh_6409	Manoj.Singh56@outlook.com	9825965228	1	1	t	t	2025-08-08 11:08:54	f	AU
255	Amit_Malhotra_4249	Amit.Malhotra559@outlook.com	9912563737	1	1	t	f	2025-08-08 11:08:54	t	UK
256	Rajesh_Srivastava_7009	Rajesh.Srivastava301@outlook.com	9445789608	1	1	t	t	2025-08-08 11:08:54	t	CA
257	Pooja_Bansal_8985	Pooja.Bansal339@gmail.com	9003948588	1	1	t	f	2025-08-08 11:08:55	t	AU
258	Priya_Gupta_9542	Priya.Gupta102@yahoo.com	9567391710	1	1	t	t	2025-08-08 11:08:55	f	AU
259	Ramesh_Sethi_3731	Ramesh.Sethi376@yahoo.com	9465331330	1	1	t	t	2025-08-08 11:08:55	f	AU
260	Rohit_Mishra_2440	Rohit.Mishra242@yahoo.com	9784976071	1	1	t	t	2025-08-08 11:08:55	f	UK
261	Meera_Sharma_6488	Meera.Sharma120@yahoo.com	9853707655	1	1	t	t	2025-08-08 11:08:55	f	IN
262	Geeta_Malhotra_8872	Geeta.Malhotra621@outlook.com	9418686236	1	1	t	f	2025-08-08 11:08:55	f	US
263	Suresh_Kapoor_250	Suresh.Kapoor424@hotmail.com	9704433999	1	1	t	f	2025-08-08 11:08:55	t	IN
264	Rekha_Srivastava_3476	Rekha.Srivastava323@gmail.com	9049455585	1	1	t	f	2025-08-08 11:08:55	f	IN
265	Pooja_Srivastava_507	Pooja.Srivastava454@gmail.com	9303929416	1	1	t	t	2025-08-08 11:08:55	f	CA
266	Sanjay_Chopra_7380	Sanjay.Chopra458@gmail.com	9455053753	1	1	t	t	2025-08-08 11:08:55	t	CA
267	Suresh_Tiwari_5848	Suresh.Tiwari718@gmail.com	9409507006	1	1	t	t	2025-08-08 11:08:55	t	CA
268	Ritu_Singh_535	Ritu.Singh946@test.com	9450426510	2	1	t	t	2025-08-08 11:08:55	f	CA
269	Rekha_Agarwal_5433	Rekha.Agarwal207@gmail.com	9250850185	2	1	t	t	2025-08-08 11:08:55	f	US
270	Priya_Joshi_2806	Priya.Joshi43@test.com	9266926764	2	1	t	t	2025-08-08 11:08:56	f	US
271	Vinod_Pandey_118	Vinod.Pandey968@outlook.com	9701638442	2	1	t	t	2025-08-08 11:08:56	f	CA
272	Usha_Tiwari_6029	Usha.Tiwari379@gmail.com	9658222143	2	1	t	f	2025-08-08 11:08:56	t	UK
273	Meera_Sethi_4187	Meera.Sethi309@test.com	9373688747	2	1	t	f	2025-08-08 11:08:56	t	IN
274	Vikram_Bhatia_6821	Vikram.Bhatia200@gmail.com	9538951768	2	1	t	t	2025-08-08 11:08:56	f	US
275	Ritu_Chopra_8203	Ritu.Chopra297@gmail.com	9332888600	2	1	t	f	2025-08-08 11:08:56	f	UK
276	Nisha_Dubey_7761	Nisha.Dubey591@gmail.com	9134228695	2	1	t	t	2025-08-08 11:08:56	t	US
277	Lata_Patel_6233	Lata.Patel33@test.com	9519212344	2	1	t	t	2025-08-08 11:08:56	f	US
278	Ashok_Patel_2710	Ashok.Patel858@test.com	9642535086	2	1	t	f	2025-08-08 11:08:56	t	US
279	Rekha_Singh_9392	Rekha.Singh987@gmail.com	9879405408	2	1	t	f	2025-08-08 11:08:56	t	CA
280	Arjun_Pandey_2945	Arjun.Pandey663@yahoo.com	9757952426	2	1	t	f	2025-08-08 11:08:57	f	CA
281	Rajesh_Agarwal_8788	Rajesh.Agarwal464@hotmail.com	9264774555	2	1	t	t	2025-08-08 11:08:57	t	IN
282	Ramesh_Verma_1448	Ramesh.Verma533@test.com	9917867526	2	1	t	t	2025-08-08 11:08:57	f	AU
283	Amit_Gupta_4427	Amit.Gupta119@gmail.com	9112012024	1	1	t	t	2025-08-08 11:10:13	f	US
284	Kavya_Singh_6796	Kavya.Singh34@test.com	9925325323	1	1	t	f	2025-08-08 11:10:13	t	AU
285	Pooja_Bhatia_9498	Pooja.Bhatia321@gmail.com	9331687503	1	1	t	f	2025-08-08 11:10:13	t	IN
286	Vikram_Pandey_2949	Vikram.Pandey473@test.com	9986123042	1	1	t	f	2025-08-08 11:10:14	t	AU
287	Ritu_Kumar_5595	Ritu.Kumar776@outlook.com	9002379364	1	1	t	t	2025-08-08 11:10:14	f	AU
288	Sita_Kumar_1790	Sita.Kumar171@outlook.com	9511637843	1	1	t	t	2025-08-08 11:10:14	f	IN
289	Anjali_Tiwari_4619	Anjali.Tiwari397@test.com	9014578278	1	1	t	t	2025-08-08 11:10:14	f	US
290	Priya_Kapoor_9252	Priya.Kapoor339@hotmail.com	9825246196	1	1	t	t	2025-08-08 11:10:14	f	AU
291	Usha_Bansal_6351	Usha.Bansal673@gmail.com	9768367372	1	1	t	t	2025-08-08 11:10:14	t	UK
292	Ravi_Sethi_7148	Ravi.Sethi258@hotmail.com	9260897221	1	1	t	t	2025-08-08 11:10:14	f	US
293	Meera_Singh_3069	Meera.Singh663@yahoo.com	9203801733	1	1	t	t	2025-08-08 11:10:14	t	AU
294	Pooja_Saxena_3316	Pooja.Saxena229@test.com	9707519997	1	1	t	f	2025-08-08 11:10:14	t	CA
295	Meera_Mishra_6513	Meera.Mishra513@test.com	9449117750	1	1	t	f	2025-08-08 11:10:14	t	UK
296	Rohit_Srivastava_7461	Rohit.Srivastava877@hotmail.com	9123141960	1	1	t	f	2025-08-08 11:10:14	t	US
297	Manoj_Pandey_4008	Manoj.Pandey534@hotmail.com	9277294968	1	1	t	f	2025-08-08 11:10:14	f	UK
298	Amit_Agarwal_9949	Amit.Agarwal630@hotmail.com	9166024852	2	1	t	t	2025-08-08 11:10:14	f	AU
299	Pooja_Chopra_3749	Pooja.Chopra329@yahoo.com	9550363021	2	1	t	f	2025-08-08 11:10:14	t	CA
300	Akash_Jain_3892	Akash.Jain41@hotmail.com	9606754776	2	1	t	f	2025-08-08 11:10:14	f	AU
301	Sanjay_Gupta_8206	Sanjay.Gupta58@outlook.com	9200680200	2	1	t	t	2025-08-08 11:10:15	f	UK
302	Sita_Chopra_4915	Sita.Chopra161@outlook.com	9119566967	2	1	t	f	2025-08-08 11:10:15	t	AU
303	Karan_Mishra_9605	Karan.Mishra126@test.com	9143332245	2	1	t	f	2025-08-08 11:10:15	t	IN
304	Karan_Patel_5802	Karan.Patel287@hotmail.com	9540309808	2	1	t	t	2025-08-08 11:10:15	f	CA
305	Sita_Jain_6310	Sita.Jain579@outlook.com	9185181147	2	1	t	f	2025-08-08 11:10:15	f	US
306	Vinod_Gupta_1719	Vinod.Gupta524@hotmail.com	9998996506	2	1	t	f	2025-08-08 11:10:15	t	US
307	Amit_Agarwal_6687	Amit.Agarwal758@yahoo.com	9311614113	2	1	t	f	2025-08-08 11:10:15	t	UK
308	Pooja_Malhotra_76	Pooja.Malhotra744@test.com	9645765123	2	1	t	t	2025-08-08 11:10:15	t	AU
309	Priya_Kapoor_1274	Priya.Kapoor217@yahoo.com	9744461246	2	1	t	t	2025-08-08 11:10:15	f	IN
310	Manoj_Sharma_7411	Manoj.Sharma176@outlook.com	9936665306	2	1	t	f	2025-08-08 11:10:15	f	UK
311	Sunita_Srivastava_4112	Sunita.Srivastava886@hotmail.com	9977712747	2	1	t	t	2025-08-08 11:10:15	f	AU
312	Manoj_Malhotra_882	Manoj.Malhotra384@test.com	9996283211	2	1	t	t	2025-08-08 11:10:15	f	UK
313	Ramesh_Bhatia_982	Ramesh.Bhatia971@hotmail.com	9711659940	1	1	t	t	2025-08-08 11:11:25	t	UK
314	Ritu_Agarwal_67	Ritu.Agarwal723@hotmail.com	9974702765	1	1	t	f	2025-08-08 11:11:25	t	CA
315	Deepak_Pandey_522	Deepak.Pandey855@yahoo.com	9149057098	1	1	t	f	2025-08-08 11:11:25	f	US
316	Kavya_Bansal_4153	Kavya.Bansal648@yahoo.com	9170545401	1	1	t	f	2025-08-08 11:11:26	f	US
317	Ritu_Jain_6495	Ritu.Jain664@test.com	9045150462	1	1	t	t	2025-08-08 11:11:26	t	US
318	Ravi_Pandey_2985	Ravi.Pandey19@hotmail.com	9734475764	1	1	t	t	2025-08-08 11:11:26	f	AU
319	Divya_Sethi_4431	Divya.Sethi745@gmail.com	9052018131	1	1	t	f	2025-08-08 11:11:26	t	CA
320	Rekha_Gupta_6917	Rekha.Gupta490@outlook.com	9892706532	1	1	t	t	2025-08-08 11:11:26	f	AU
321	Anjali_Singh_3240	Anjali.Singh788@hotmail.com	9732768616	1	1	t	f	2025-08-08 11:11:26	t	AU
322	Vinod_Mishra_115	Vinod.Mishra240@outlook.com	9118598894	1	1	t	t	2025-08-08 11:11:26	f	IN
323	Vikram_Bansal_1971	Vikram.Bansal892@yahoo.com	9553844316	1	1	t	f	2025-08-08 11:11:26	f	CA
324	Pooja_Tiwari_8963	Pooja.Tiwari358@test.com	9855736782	1	1	t	f	2025-08-08 11:11:26	t	AU
325	Anjali_Singh_181	Anjali.Singh956@yahoo.com	9062081075	1	1	t	t	2025-08-08 11:11:26	f	UK
326	Akash_Singh_3101	Akash.Singh882@yahoo.com	9997530368	1	1	t	t	2025-08-08 11:11:26	t	AU
327	Manoj_Kumar_9512	Manoj.Kumar437@yahoo.com	9284502352	1	1	t	t	2025-08-08 11:11:26	f	US
328	Deepak_Chopra_7243	Deepak.Chopra836@yahoo.com	9289614378	2	1	t	f	2025-08-08 11:11:26	f	CA
329	Sneha_Saxena_3231	Sneha.Saxena811@gmail.com	9189137456	2	1	t	t	2025-08-08 11:11:26	t	UK
330	Deepak_Malhotra_3746	Deepak.Malhotra420@hotmail.com	9379759968	2	1	t	f	2025-08-08 11:11:27	t	AU
331	Sanjay_Saxena_6994	Sanjay.Saxena100@outlook.com	9796585878	2	1	t	f	2025-08-08 11:11:27	t	IN
332	Sneha_Sethi_7736	Sneha.Sethi799@hotmail.com	9689480017	2	1	t	t	2025-08-08 11:11:27	f	AU
333	Usha_Yadav_3600	Usha.Yadav717@hotmail.com	9497545181	2	1	t	f	2025-08-08 11:11:27	f	CA
334	Kavya_Kumar_1273	Kavya.Kumar345@yahoo.com	9084461047	2	1	t	f	2025-08-08 11:11:27	f	AU
335	Ritu_Sethi_5684	Ritu.Sethi810@outlook.com	9671438514	2	1	t	t	2025-08-08 11:11:27	f	UK
336	Rekha_Singh_8389	Rekha.Singh699@gmail.com	9960327296	2	1	t	f	2025-08-08 11:11:27	f	IN
337	Ravi_Sharma_3811	Ravi.Sharma106@outlook.com	9395010250	2	1	t	f	2025-08-08 11:11:27	f	UK
338	Priya_Pandey_3818	Priya.Pandey797@outlook.com	9315323211	2	1	t	t	2025-08-08 11:11:27	f	CA
339	Divya_Srivastava_3285	Divya.Srivastava245@test.com	9508679446	2	1	t	f	2025-08-08 11:11:27	t	IN
340	Priya_Saxena_1480	Priya.Saxena861@yahoo.com	9118091970	2	1	t	f	2025-08-08 11:11:27	f	US
341	Deepak_Dubey_9489	Deepak.Dubey503@test.com	9688280384	2	1	t	f	2025-08-08 11:11:27	f	CA
342	Akash_Singh_3712	Akash.Singh942@hotmail.com	9169217656	2	1	t	f	2025-08-08 11:11:27	t	IN
343	Sunita_Mishra_4915	Sunita.Mishra8@hotmail.com	9555916490	1	1	t	f	2025-08-08 11:12:43	t	UK
344	Meera_Sharma_5542	Meera.Sharma858@gmail.com	9354519666	1	1	t	f	2025-08-08 11:12:43	t	UK
345	Priya_Gupta_4006	Priya.Gupta224@yahoo.com	9354749096	1	1	t	t	2025-08-08 11:12:43	f	UK
346	Rajesh_Sharma_5398	Rajesh.Sharma225@gmail.com	9914899805	1	1	t	t	2025-08-08 11:12:43	f	CA
347	Karan_Malhotra_4164	Karan.Malhotra398@outlook.com	9539355510	1	1	t	t	2025-08-08 11:12:43	f	CA
348	Rekha_Gupta_9750	Rekha.Gupta481@hotmail.com	9924999268	1	1	t	t	2025-08-08 11:12:43	t	US
349	Sneha_Gupta_5802	Sneha.Gupta254@hotmail.com	9208355132	1	1	t	t	2025-08-08 11:12:43	t	CA
350	Manoj_Jain_5145	Manoj.Jain132@yahoo.com	9133043556	1	1	t	f	2025-08-08 11:12:43	f	AU
351	Ramesh_Bansal_522	Ramesh.Bansal143@test.com	9251754308	1	1	t	f	2025-08-08 11:12:43	t	IN
352	Karan_Jain_4908	Karan.Jain864@yahoo.com	9485498868	1	1	t	f	2025-08-08 11:12:44	f	IN
353	Arjun_Patel_5422	Arjun.Patel589@yahoo.com	9130781659	1	1	t	f	2025-08-08 11:12:44	t	AU
354	Arjun_Pandey_5786	Arjun.Pandey390@gmail.com	9134244348	1	1	t	f	2025-08-08 11:12:44	f	US
355	Karan_Kapoor_5437	Karan.Kapoor40@gmail.com	9449690919	1	1	t	t	2025-08-08 11:12:44	t	CA
356	Rekha_Sharma_6617	Rekha.Sharma414@outlook.com	9044072311	1	1	t	t	2025-08-08 11:12:44	t	CA
357	Sunita_Saxena_8892	Sunita.Saxena280@test.com	9314125916	1	1	t	f	2025-08-08 11:12:44	f	AU
358	Kavya_Malhotra_8185	Kavya.Malhotra716@gmail.com	9003726830	2	1	t	t	2025-08-08 11:12:44	f	IN
359	Sunita_Mishra_9784	Sunita.Mishra177@test.com	9488630654	2	1	t	t	2025-08-08 11:12:44	t	US
360	Usha_Tiwari_6592	Usha.Tiwari7@gmail.com	9044654221	2	1	t	f	2025-08-08 11:12:44	f	IN
361	Arjun_Chopra_411	Arjun.Chopra781@test.com	9303197114	2	1	t	f	2025-08-08 11:12:44	t	UK
362	Vikram_Kapoor_826	Vikram.Kapoor516@yahoo.com	9301276249	2	1	t	t	2025-08-08 11:12:44	f	CA
363	Rohit_Kapoor_236	Rohit.Kapoor620@gmail.com	9312884703	2	1	t	t	2025-08-08 11:12:44	t	AU
364	Rajesh_Bansal_7132	Rajesh.Bansal114@test.com	9939760235	2	1	t	f	2025-08-08 11:12:44	f	US
365	Nisha_Malhotra_1583	Nisha.Malhotra718@gmail.com	9727970333	2	1	t	t	2025-08-08 11:12:44	f	AU
366	Amit_Patel_6134	Amit.Patel478@yahoo.com	9053027458	2	1	t	f	2025-08-08 11:12:45	t	IN
367	Kavya_Mishra_4626	Kavya.Mishra983@hotmail.com	9060986617	2	1	t	t	2025-08-08 11:12:45	t	AU
368	Arjun_Pandey_5187	Arjun.Pandey719@hotmail.com	9374321570	2	1	t	t	2025-08-08 11:12:45	t	AU
369	Manoj_Sethi_4570	Manoj.Sethi380@yahoo.com	9831514692	2	1	t	f	2025-08-08 11:12:45	t	AU
370	Lata_Srivastava_1590	Lata.Srivastava718@yahoo.com	9134279337	2	1	t	t	2025-08-08 11:12:45	f	AU
371	Rohit_Mishra_8797	Rohit.Mishra439@hotmail.com	9358995726	2	1	t	f	2025-08-08 11:12:45	t	IN
372	Vikram_Patel_9252	Vikram.Patel183@gmail.com	9486098277	2	1	t	t	2025-08-08 11:12:45	t	UK
373	Ramesh_Yadav_4226	Ramesh.Yadav136@gmail.com	9152797594	1	1	t	f	2025-08-08 11:14:34	f	IN
374	Rajesh_Bhatia_2917	Rajesh.Bhatia882@gmail.com	9032649171	1	1	t	f	2025-08-08 11:14:34	t	CA
375	Rekha_Dubey_1777	Rekha.Dubey211@gmail.com	9526032943	1	1	t	f	2025-08-08 11:14:34	f	CA
376	Ramesh_Dubey_5589	Ramesh.Dubey235@outlook.com	9575718104	1	1	t	t	2025-08-08 11:14:34	t	CA
377	Geeta_Bansal_3144	Geeta.Bansal872@gmail.com	9548495110	1	1	t	f	2025-08-08 11:14:34	f	UK
378	Suresh_Sharma_5399	Suresh.Sharma565@test.com	9237587616	1	1	t	t	2025-08-08 11:14:34	f	CA
379	Ramesh_Kumar_4862	Ramesh.Kumar619@yahoo.com	9509893313	1	1	t	t	2025-08-08 11:14:34	t	IN
380	Ravi_Tiwari_1717	Ravi.Tiwari767@test.com	9794661986	1	1	t	t	2025-08-08 11:14:34	t	US
381	Vikram_Patel_9386	Vikram.Patel553@outlook.com	9726273805	1	1	t	t	2025-08-08 11:14:34	t	AU
382	Meera_Gupta_5991	Meera.Gupta623@yahoo.com	9880582817	1	1	t	f	2025-08-08 11:14:35	t	AU
383	Amit_Joshi_1349	Amit.Joshi874@test.com	9651764458	1	1	t	t	2025-08-08 11:14:35	t	US
384	Vinod_Singh_7898	Vinod.Singh939@test.com	9513739594	1	1	t	t	2025-08-08 11:14:35	f	IN
385	Rohit_Bansal_5272	Rohit.Bansal897@yahoo.com	9919049817	1	1	t	t	2025-08-08 11:14:35	t	US
386	Suresh_Srivastava_3183	Suresh.Srivastava632@yahoo.com	9511304574	1	1	t	t	2025-08-08 11:14:35	f	CA
387	Vikram_Bansal_2153	Vikram.Bansal226@yahoo.com	9406691274	1	1	t	f	2025-08-08 11:14:35	t	IN
388	Ramesh_Mishra_1741	Ramesh.Mishra829@test.com	9829317398	2	1	t	t	2025-08-08 11:14:35	f	AU
389	Ravi_Jain_5171	Ravi.Jain93@outlook.com	9849369063	2	1	t	f	2025-08-08 11:14:35	f	IN
390	Geeta_Bansal_7363	Geeta.Bansal436@hotmail.com	9366502132	2	1	t	t	2025-08-08 11:14:35	f	IN
391	Ramesh_Gupta_1843	Ramesh.Gupta743@yahoo.com	9925802121	2	1	t	t	2025-08-08 11:14:35	f	IN
392	Rohit_Jain_4728	Rohit.Jain153@test.com	9882967531	2	1	t	f	2025-08-08 11:14:35	t	IN
393	Amit_Kumar_7628	Amit.Kumar956@outlook.com	9134521207	2	1	t	f	2025-08-08 11:14:35	t	CA
394	Akash_Mishra_9538	Akash.Mishra535@hotmail.com	9649576244	2	1	t	t	2025-08-08 11:14:35	f	US
395	Rajesh_Verma_5795	Rajesh.Verma102@yahoo.com	9517684157	2	1	t	f	2025-08-08 11:14:36	f	US
396	Vinod_Saxena_3064	Vinod.Saxena696@outlook.com	9895379405	2	1	t	f	2025-08-08 11:14:36	t	UK
397	Ravi_Saxena_4761	Ravi.Saxena103@test.com	9628024292	2	1	t	f	2025-08-08 11:14:36	t	AU
398	Ravi_Agarwal_8544	Ravi.Agarwal705@test.com	9675085859	2	1	t	f	2025-08-08 11:14:36	f	IN
399	Divya_Agarwal_772	Divya.Agarwal808@hotmail.com	9638214305	2	1	t	f	2025-08-08 11:14:36	t	UK
400	Vinod_Bhatia_3598	Vinod.Bhatia79@test.com	9061053707	2	1	t	f	2025-08-08 11:14:36	f	US
401	Lata_Kapoor_6005	Lata.Kapoor476@yahoo.com	9209056346	2	1	t	t	2025-08-08 11:14:36	f	AU
402	Deepak_Saxena_9314	Deepak.Saxena378@gmail.com	9017315291	2	1	t	t	2025-08-08 11:14:36	f	CA
403	Suresh_Kapoor_1969	Suresh.Kapoor305@gmail.com	9681577434	1	1	t	t	2025-08-08 11:19:49	t	US
404	Kavya_Saxena_6995	Kavya.Saxena830@yahoo.com	9754790230	1	1	t	t	2025-08-08 11:19:50	f	AU
405	Akash_Yadav_1684	Akash.Yadav505@hotmail.com	9853872893	1	1	t	t	2025-08-08 11:19:50	f	AU
406	Anjali_Saxena_6692	Anjali.Saxena65@test.com	9997771054	1	1	t	t	2025-08-08 11:19:50	t	IN
407	Pooja_Tiwari_8222	Pooja.Tiwari450@outlook.com	9930941192	1	1	t	t	2025-08-08 11:19:51	f	US
408	Vikram_Tiwari_7809	Vikram.Tiwari468@outlook.com	9421161006	1	1	t	t	2025-08-08 11:19:51	f	IN
409	Vikram_Jain_4335	Vikram.Jain758@gmail.com	9251359503	1	1	t	f	2025-08-08 11:19:51	t	UK
410	Ravi_Srivastava_5852	Ravi.Srivastava595@outlook.com	9318182682	1	1	t	f	2025-08-08 11:19:51	t	UK
411	Usha_Patel_3837	Usha.Patel753@hotmail.com	9511595959	1	1	t	t	2025-08-08 11:19:51	f	US
412	Vikram_Patel_3667	Vikram.Patel882@test.com	9052164180	1	1	t	f	2025-08-08 11:19:51	f	IN
413	Ramesh_Joshi_6185	Ramesh.Joshi586@outlook.com	9402097760	1	1	t	f	2025-08-08 11:19:51	f	IN
414	Nisha_Kapoor_6487	Nisha.Kapoor211@yahoo.com	9675754455	1	1	t	t	2025-08-08 11:19:51	t	UK
415	Lata_Verma_9882	Lata.Verma708@gmail.com	9897050984	1	1	t	t	2025-08-08 11:19:52	f	IN
416	Ravi_Gupta_3617	Ravi.Gupta287@gmail.com	9915937653	1	1	t	t	2025-08-08 11:19:52	f	IN
417	Usha_Sethi_6164	Usha.Sethi480@gmail.com	9165773831	1	1	t	t	2025-08-08 11:19:52	t	UK
418	Manoj_Yadav_2007	Manoj.Yadav737@gmail.com	9218239108	2	1	t	f	2025-08-08 11:19:52	f	US
419	Amit_Agarwal_9845	Amit.Agarwal975@gmail.com	9571385950	2	1	t	t	2025-08-08 11:19:52	f	CA
420	Ritu_Gupta_1251	Ritu.Gupta493@yahoo.com	9338188899	2	1	t	f	2025-08-08 11:19:52	f	US
421	Vikram_Gupta_3574	Vikram.Gupta238@hotmail.com	9804037053	2	1	t	f	2025-08-08 11:19:52	t	US
422	Ritu_Kapoor_6701	Ritu.Kapoor85@test.com	9362773678	2	1	t	f	2025-08-08 11:19:52	t	AU
423	Sneha_Joshi_4188	Sneha.Joshi601@gmail.com	9334827505	2	1	t	f	2025-08-08 11:19:53	t	US
424	Pooja_Dubey_9713	Pooja.Dubey819@test.com	9777937369	2	1	t	t	2025-08-08 11:19:53	f	AU
425	Anjali_Tiwari_426	Anjali.Tiwari189@yahoo.com	9307746712	2	1	t	t	2025-08-08 11:19:53	t	AU
426	Ramesh_Patel_9538	Ramesh.Patel391@yahoo.com	9523979175	2	1	t	f	2025-08-08 11:19:53	t	CA
427	Rajesh_Dubey_6506	Rajesh.Dubey895@outlook.com	9046793610	2	1	t	f	2025-08-08 11:19:53	t	US
428	Kavya_Jain_2145	Kavya.Jain131@hotmail.com	9876190619	2	1	t	f	2025-08-08 11:19:53	f	AU
429	Rohit_Agarwal_3134	Rohit.Agarwal118@hotmail.com	9074157025	2	1	t	f	2025-08-08 11:19:53	f	AU
430	Nisha_Verma_5325	Nisha.Verma22@hotmail.com	9603530148	2	1	t	f	2025-08-08 11:19:53	f	US
431	Pooja_Malhotra_6774	Pooja.Malhotra544@test.com	9104305713	2	1	t	t	2025-08-08 11:19:53	f	CA
432	Anjali_Singh_2233	Anjali.Singh419@hotmail.com	9869044501	2	1	t	t	2025-08-08 11:19:53	f	CA
433	Geeta_Dubey_3308	Geeta.Dubey559@hotmail.com	9039308111	1	1	t	t	2025-08-08 11:21:39	t	CA
434	Vikram_Saxena_7124	Vikram.Saxena273@outlook.com	9501846380	1	1	t	t	2025-08-08 11:21:39	t	CA
435	Karan_Joshi_3059	Karan.Joshi747@hotmail.com	9202084668	1	1	t	f	2025-08-08 11:21:39	f	UK
436	Rekha_Gupta_3791	Rekha.Gupta434@outlook.com	9124925576	1	1	t	t	2025-08-08 11:21:39	f	US
437	Manoj_Pandey_4053	Manoj.Pandey510@gmail.com	9141698124	1	1	t	f	2025-08-08 11:21:39	f	AU
438	Geeta_Malhotra_6534	Geeta.Malhotra977@gmail.com	9571018966	1	1	t	t	2025-08-08 11:21:40	f	AU
439	Manoj_Dubey_9972	Manoj.Dubey426@gmail.com	9560854554	1	1	t	t	2025-08-08 11:21:40	f	CA
440	Vikram_Jain_7071	Vikram.Jain380@outlook.com	9288238537	1	1	t	t	2025-08-08 11:21:40	t	CA
441	Pooja_Sharma_3997	Pooja.Sharma630@yahoo.com	9729943409	1	1	t	t	2025-08-08 11:21:40	f	UK
442	Geeta_Agarwal_6118	Geeta.Agarwal795@outlook.com	9646560728	1	1	t	f	2025-08-08 11:21:40	f	IN
443	Vinod_Singh_2977	Vinod.Singh933@gmail.com	9501741388	1	1	t	f	2025-08-08 11:21:40	t	CA
444	Akash_Pandey_6990	Akash.Pandey928@test.com	9921599747	1	1	t	t	2025-08-08 11:21:40	t	IN
445	Usha_Malhotra_3141	Usha.Malhotra225@outlook.com	9562227228	1	1	t	t	2025-08-08 11:21:40	t	AU
446	Divya_Kapoor_1916	Divya.Kapoor750@outlook.com	9823450668	1	1	t	t	2025-08-08 11:21:40	f	IN
447	Akash_Bansal_8576	Akash.Bansal548@yahoo.com	9831624387	1	1	t	t	2025-08-08 11:21:40	t	IN
448	Sita_Dubey_6035	Sita.Dubey467@test.com	9403758573	2	1	t	t	2025-08-08 11:21:40	t	CA
449	Karan_Malhotra_6838	Karan.Malhotra468@yahoo.com	9040845624	2	1	t	t	2025-08-08 11:21:40	f	UK
450	Arjun_Jain_5091	Arjun.Jain992@gmail.com	9352106783	2	1	t	f	2025-08-08 11:21:40	t	CA
451	Ashok_Sharma_3542	Ashok.Sharma432@hotmail.com	9178595056	2	1	t	f	2025-08-08 11:21:40	f	UK
452	Sunita_Gupta_8577	Sunita.Gupta356@yahoo.com	9666626275	2	1	t	f	2025-08-08 11:21:41	t	CA
453	Ashok_Sethi_8813	Ashok.Sethi421@hotmail.com	9943962468	2	1	t	t	2025-08-08 11:21:41	t	IN
454	Nisha_Jain_5957	Nisha.Jain866@hotmail.com	9178122273	2	1	t	f	2025-08-08 11:21:41	t	AU
455	Vinod_Verma_5922	Vinod.Verma165@gmail.com	9147712626	2	1	t	t	2025-08-08 11:21:41	f	IN
456	Akash_Kapoor_4638	Akash.Kapoor886@outlook.com	9340667675	2	1	t	f	2025-08-08 11:21:41	f	UK
457	Geeta_Yadav_142	Geeta.Yadav879@yahoo.com	9054377263	2	1	t	f	2025-08-08 11:21:41	t	US
458	Rajesh_Kumar_4167	Rajesh.Kumar260@yahoo.com	9886646563	2	1	t	t	2025-08-08 11:21:41	t	AU
459	Divya_Kumar_7026	Divya.Kumar514@outlook.com	9339800235	2	1	t	f	2025-08-08 11:21:41	t	UK
460	Karan_Chopra_7228	Karan.Chopra893@gmail.com	9429936558	2	1	t	t	2025-08-08 11:21:41	t	AU
461	Rohit_Malhotra_2614	Rohit.Malhotra888@yahoo.com	9914787941	2	1	t	t	2025-08-08 11:21:41	f	UK
462	Divya_Malhotra_167	Divya.Malhotra319@test.com	9191808603	2	1	t	t	2025-08-08 11:21:41	t	CA
463	Vikram_Pandey_1851	Vikram.Pandey900@yahoo.com	9043808624	1	1	t	f	2025-08-08 11:24:59	f	IN
464	Geeta_Kapoor_4171	Geeta.Kapoor359@outlook.com	9607272229	1	1	t	t	2025-08-08 11:24:59	t	AU
465	Sneha_Srivastava_9683	Sneha.Srivastava885@gmail.com	9538530566	1	1	t	t	2025-08-08 11:24:59	f	AU
466	Ramesh_Bansal_4526	Ramesh.Bansal950@hotmail.com	9254000743	1	1	t	f	2025-08-08 11:24:59	t	UK
467	Rajesh_Joshi_1909	Rajesh.Joshi554@hotmail.com	9119424612	1	1	t	t	2025-08-08 11:24:59	f	UK
468	Pooja_Dubey_4811	Pooja.Dubey391@yahoo.com	9541366987	1	1	t	t	2025-08-08 11:24:59	t	AU
469	Divya_Sethi_6405	Divya.Sethi90@test.com	9053209922	1	1	t	t	2025-08-08 11:24:59	t	US
470	Vikram_Srivastava_7455	Vikram.Srivastava123@yahoo.com	9311667335	1	1	t	f	2025-08-08 11:24:59	t	US
471	Arjun_Jain_299	Arjun.Jain920@gmail.com	9729649221	1	1	t	t	2025-08-08 11:25:00	t	IN
472	Anjali_Sethi_4381	Anjali.Sethi906@yahoo.com	9668074006	1	1	t	f	2025-08-08 11:25:00	t	AU
473	Rohit_Singh_9179	Rohit.Singh785@yahoo.com	9744019217	1	1	t	t	2025-08-08 11:25:00	f	CA
474	Rohit_Patel_7006	Rohit.Patel485@gmail.com	9302188012	1	1	t	f	2025-08-08 11:25:00	t	UK
475	Lata_Srivastava_3824	Lata.Srivastava930@outlook.com	9571982549	1	1	t	f	2025-08-08 11:25:00	f	AU
476	Vinod_Chopra_2216	Vinod.Chopra596@hotmail.com	9600275449	1	1	t	t	2025-08-08 11:25:00	t	AU
477	Suresh_Sethi_1078	Suresh.Sethi762@outlook.com	9346880467	1	1	t	f	2025-08-08 11:25:00	f	IN
478	Vinod_Patel_2240	Vinod.Patel272@hotmail.com	9500593970	2	1	t	t	2025-08-08 11:25:00	t	US
479	Sunita_Saxena_679	Sunita.Saxena379@hotmail.com	9253408979	2	1	t	f	2025-08-08 11:25:00	f	US
480	Ravi_Singh_8720	Ravi.Singh241@test.com	9112876876	2	1	t	t	2025-08-08 11:25:00	f	CA
481	Usha_Patel_572	Usha.Patel898@test.com	9878135582	2	1	t	t	2025-08-08 11:25:00	f	CA
482	Anjali_Jain_5251	Anjali.Jain550@outlook.com	9655447601	2	1	t	t	2025-08-08 11:25:01	f	AU
483	Rekha_Sethi_869	Rekha.Sethi801@gmail.com	9576412613	2	1	t	t	2025-08-08 11:25:01	f	UK
484	Nisha_Patel_8011	Nisha.Patel344@test.com	9129307973	2	1	t	t	2025-08-08 11:25:01	f	CA
485	Ritu_Gupta_1806	Ritu.Gupta960@test.com	9396581188	2	1	t	t	2025-08-08 11:25:01	t	UK
486	Ramesh_Joshi_1808	Ramesh.Joshi690@test.com	9007210814	2	1	t	t	2025-08-08 11:25:01	f	AU
487	Amit_Tiwari_7305	Amit.Tiwari500@outlook.com	9185447872	2	1	t	f	2025-08-08 11:25:01	t	US
488	Meera_Tiwari_7215	Meera.Tiwari791@hotmail.com	9094420078	2	1	t	t	2025-08-08 11:25:01	f	AU
489	Ashok_Tiwari_6906	Ashok.Tiwari485@outlook.com	9649800905	2	1	t	t	2025-08-08 11:25:01	t	UK
490	Ritu_Kapoor_6062	Ritu.Kapoor42@yahoo.com	9701626483	2	1	t	f	2025-08-08 11:25:01	f	US
491	Akash_Chopra_219	Akash.Chopra788@outlook.com	9583680316	2	1	t	f	2025-08-08 11:25:01	t	US
492	Akash_Pandey_4049	Akash.Pandey255@yahoo.com	9903257675	2	1	t	t	2025-08-08 11:25:01	f	US
\.


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

COPY public.invoice (id, invoice_number, user_id, user_name, user_email, user_phone, order_id, user_address, currency, state, country, payment_status, amount, tax_detail, total_tax_amount, refund_amount, grand_total, coupon_used, coupon_value, coupon_code, notes, issue_date, created_at, updated_at) FROM stdin;
\.


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

COPY public.order_detail (id, client_id, customer_id, client_presence_id, package_id, package_pricing_id, package_name, selected_price, selected_currency, gatway_id, gateway_name, taxation_id, coupon_id, coupon_code, coupon_amount, gateway_raw_data, auto_renewal, transaction_id, triggered_content_id, triggered_content_name, status, start_date, end_date, created_at, updated_at) FROM stdin;
4703	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 11:43:27	2025-09-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27
4704	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 11:43:27	2025-09-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27
4705	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 11:43:27	2026-08-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27
4706	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 11:43:27	2025-09-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27
4707	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 11:43:27	2025-09-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27
4708	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 11:44:15	2025-09-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15
4709	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 11:44:15	2025-09-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15
4710	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 11:44:15	2026-08-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15
4711	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 11:44:15	2025-09-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15
4712	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 11:44:15	2025-09-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15
4713	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 11:45:12	2025-09-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12
4714	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 11:45:12	2025-09-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12
4715	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 11:45:12	2026-08-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12
4716	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 11:45:12	2025-09-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12
4717	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 11:45:12	2025-09-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12
4718	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 11:46:31	2025-09-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31
4719	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 11:46:31	2025-09-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31
4720	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 11:46:31	2026-08-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31
4721	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 11:46:31	2025-09-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31
4722	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 11:46:31	2025-09-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31
4723	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 11:46:54	2025-09-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54
4724	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 11:46:54	2025-09-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54
4725	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 11:46:54	2026-08-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54
4726	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 11:46:54	2025-09-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54
4727	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 11:46:54	2025-09-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54
4728	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 11:47:15	2025-09-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15
4729	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 11:47:15	2025-09-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15
4730	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 11:47:15	2026-08-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15
4731	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 11:47:15	2025-09-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15
4732	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 11:47:15	2025-09-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15
4733	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 11:50:36	2025-09-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36
4734	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 11:50:36	2025-09-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36
4735	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 11:50:36	2026-08-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36
4736	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 11:50:36	2025-09-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36
4737	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 11:50:36	2025-09-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36
4738	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 12:02:30	2025-09-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30
4739	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 12:02:30	2025-09-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30
4740	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 12:02:30	2026-08-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30
4741	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 12:02:30	2025-09-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30
4742	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 12:02:30	2025-09-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30
4743	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 12:03:34	2025-09-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34
4744	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 12:03:34	2025-09-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34
4745	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 12:03:34	2026-08-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34
4746	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 12:03:34	2025-09-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34
4747	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 12:03:34	2025-09-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34
4748	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 12:04:02	2025-09-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02
4749	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 12:04:02	2025-09-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02
4750	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 12:04:02	2026-08-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02
4751	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 12:04:02	2025-09-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02
4752	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 12:04:02	2025-09-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02
4753	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-08 12:05:31	2025-09-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31
4754	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-08 12:05:31	2025-09-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31
4755	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-08 12:05:31	2026-08-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31
4756	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-08 12:05:31	2025-09-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31
4757	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-08 12:05:31	2025-09-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31
4758	1	1	1	1	1	Basic Monthly	199	INR       	1	Razorpay	1	1	WELCOME10	19.9	{"gateway_response": "success"}	f	1001	1	1	COMPLETED	2025-08-11 11:30:37	2025-09-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37
4759	1	2	1	2	2	Premium Monthly	499	INR       	1	Razorpay	1	2	SAVE20	99.8	{"gateway_response": "success"}	t	1002	1	1	COMPLETED	2025-08-11 11:30:37	2025-09-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37
4760	1	3	1	3	3	Basic Yearly	1999	INR       	1	Razorpay	1	1	WELCOME10	199.9	{"gateway_response": "success"}	t	1003	1	1	COMPLETED	2025-08-11 11:30:37	2026-08-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37
4761	2	4	3	1	1	Basic Monthly	199	INR       	3	Razorpay	1	2	SAVE20	39.8	{"gateway_response": "success"}	f	1004	1	1	COMPLETED	2025-08-11 11:30:37	2025-09-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37
4762	2	5	3	2	2	Premium Monthly	499	INR       	3	Razorpay	1	1	WELCOME10	49.9	{"gateway_response": "success"}	t	1005	1	1	COMPLETED	2025-08-11 11:30:37	2025-09-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37
\.


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

COPY public.payment_gateway_master (id, name, description, logo, status, created_at, updated_at) FROM stdin;
1	PayU	PayU Payment Gateway	https://yourdomain.com/logos/payu.png	t	2025-08-04 05:55:11	2025-08-04 05:55:11
2	Stripe	Global payment processing platform	stripe_logo.png	t	2025-08-08 11:35:36	2025-08-08 11:35:36
3	PayPal	International payment system	paypal_logo.png	t	2025-08-08 11:35:36	2025-08-08 11:35:36
\.


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

COPY public.payment_mode_saved (id, user_id, source_type, source_detail, is_default, status, created_at, updated_at) FROM stdin;
\.


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

COPY public.role_mngt (id, created_by_id, name, description, status, access_control, last_access_control, created_at, updated_at) FROM stdin;
1	1	SUPERADMIN	Super Admin role	1	{}	{}	2025-08-06 09:03:07	2025-08-06 09:03:07
2	1	ADMIN	Administrator role	1	{}	{}	2025-08-06 09:03:07	2025-08-06 09:03:07
3	1	FINANCE	Finance team role	1	{}	{}	2025-08-06 09:03:07	2025-08-06 09:03:07
4	1	SUPPORT	Support team role	1	{}	{}	2025-08-06 09:03:07	2025-08-06 09:03:07
5	1	SALES	Sales team role	1	{}	{}	2025-08-06 09:03:07	2025-08-06 09:03:07
6	1	OPERATION	Operations team role	1	{}	{}	2025-08-06 09:03:07	2025-08-06 09:03:07
7	1	MARKETING	Marketing team role	1	{}	{}	2025-08-06 09:03:07	2025-08-06 09:03:07
\.


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

COPY public.states (id, name, state_code, country_id, status, created_at, updated_at) FROM stdin;
1	Delhi	7	1	1	1754296814	1754296814
2	haryana	7	1	1	1754382762	1754382762
3	1003	29	1	1	1754633134	1754633134
4	2001	5	2	1	1754633134	1754633134
5	2002	36	2	1	1754633134	1754633134
\.


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

COPY public.subscription_package_pricing (id, description, subscription_package_id, currency_id, price, discount_name, discount_promotional_text1, discount_promotional_text2, discount_promotional_text3, discount_promotional_banner1, discount_promotional_banner2, discount_promotional_banner3, discount_type, discount_amount, platforms, max_allowed_platform, status, created_at, updated_at) FROM stdin;
1	Basic Monthly INR	1	1	199	1	Save 10%	2	3	banner1.jpg	banner2.jpg	4	PERCENTAGE	10	["web", "mobile"]	2	t	2025-08-08 11:42:01	2025-08-08 11:42:01
2	Premium Monthly INR	2	1	499	2	Save 20%	3	4	banner3.jpg	banner4.jpg	5	PERCENTAGE	20	["web", "mobile", "tv"]	3	t	2025-08-08 11:42:01	2025-08-08 11:42:01
3	Basic Yearly INR	3	1	1999	3	Save 30%	4	5	banner5.jpg	banner6.jpg	6	PERCENTAGE	30	["web", "mobile", "tv"]	3	t	2025-08-08 11:42:01	2025-08-08 11:42:01
4	Basic Monthly USD	1	2	2.99	4	Save 15%	5	6	banner7.jpg	banner8.jpg	7	PERCENTAGE	15	["web", "mobile"]	2	t	2025-08-08 11:42:01	2025-08-08 11:42:01
\.


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

COPY public.subscription_packages (id, package_name, package_des, package_type, content_type, package_thumb, promotion_text1, promotion_text2, promotiona_text3, promotion_thumb1, promotion_thumb2, promotion_thumb3, client_id, client_presence_id, currency, regional_presence, start_date, end_date, availability_window, availability_duration, actual_watch_duration, status, created_by, updated_by, created_at, updated_at) FROM stdin;
1	Basic Monthly	1	SUBS	VOD	1	Basic Plan	Affordable pricing	Best for individuals	thumb1.jpg	thumb2.jpg	thumb3.jpg	1	1	[1]	[1]	2025-08-08 11:42:01	2026-08-08 11:42:01	MONTH	30	720	t	1	1	2025-08-08 11:42:01	2025-08-08 11:42:01
2	Premium Monthly	2	SUBS	VOD	2	Premium Plan	Full access	Best for families	premium1.jpg	premium2.jpg	premium3.jpg	1	1	[1]	[1]	2025-08-08 11:42:01	2026-08-08 11:42:01	MONTH	30	720	t	1	1	2025-08-08 11:42:01	2025-08-08 11:42:01
3	Basic Yearly	3	SUBS	VOD	3	Yearly Plan	Save more	Best value	yearly1.jpg	yearly2.jpg	yearly3.jpg	1	1	[1]	[1]	2025-08-08 11:42:01	2026-08-08 11:42:01	YEAR	365	8760	t	1	1	2025-08-08 11:42:01	2025-08-08 11:42:01
5	Premium HD Streaming Package	100	SUBS	VOD	1001	Best streaming experience with HD quality	Unlimited access to premium content	24/7 customer support included	https://example.com/thumb1.jpg	https://example.com/thumb2.jpg	https://example.com/thumb3.jpg	1	1	{"INR": 299, "USD": 3.99}	{"regions": ["IN", "US"], "countries": ["India", "United States"]}	2025-01-01 00:00:00	2025-12-31 23:59:59	MONTH	12	2160	t	1	1	2025-08-13 17:59:24	2025-08-13 17:59:24
4	Prime Yearly	105	SUBS	VOD	1001	Updated promotion text	Unlimited access to premium content with improved features	24/7 customer support included	https://example.com/thumb1.jpg	https://example.com/thumb2.jpg	https://example.com/thumb3.jpg	1	1	{"INR": 499, "USD": 5.99}	{"regions": ["IN", "US"], "countries": ["India", "United States"]}	2025-01-01 00:00:00	2025-12-31 23:59:59	MONTH	36	2160	t	1	1	2025-08-13 17:55:28	2025-08-13 18:46:10
\.


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

COPY public.taxation (id, tax_name, tax_type, tax_rate, country_id, state_id, city_id, client_id, client_presence_id, is_applicable, effective_date, end_date, created_by, updated_by, created_at, updated_at) FROM stdin;
1	GST		18.00	1	1	1	1	1	t	2025-08-08 11:42:02	2030-08-08 11:42:02	1	1	2025-08-08 11:42:02	2025-08-08 11:42:02
2	State Tax		5.00	1	1	1	1	1	t	2025-08-08 11:42:02	2030-08-08 11:42:02	1	1	2025-08-08 11:42:02	2025-08-08 11:42:02
3	Sales Tax		8.25	2	4	5	1	2	t	2025-08-08 11:42:02	2030-08-08 11:42:02	1	1	2025-08-08 11:42:02	2025-08-08 11:42:02
\.


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

COPY public.temp (id, name, email) FROM stdin;
\.


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

COPY public.transaction (id, client_id, client_presence_id, customer_id, order_id, gateway_transaction_id, gateway_transaction_id_completion, amount, currency, payment_status, payment_method, gateway_id, auto_renew, auto_renew_date, auto_renew_expiry, grace_period_type, grace_period_duration, cancel_date, created_at, transaction_date, start_date, end_date, updated_at) FROM stdin;
1	1	1	1	4708	txn_razorpay_001	comp_razorpay_001	179.10	INR       	COMPLETED	UPI	1	f	2025-09-08 11:44:15	2025-09-15 11:44:15	DAY	7	2025-10-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15	2025-09-08 11:44:15	2025-08-08 11:44:15
2	1	1	2	4709	txn_razorpay_002	comp_razorpay_002	399.20	INR       	COMPLETED	CREDIT_CARD	1	t	2025-09-08 11:44:15	2025-09-15 11:44:15	DAY	7	2025-10-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15	2025-09-08 11:44:15	2025-08-08 11:44:15
3	1	1	3	4710	txn_razorpay_003	comp_razorpay_003	1799.10	INR       	COMPLETED	NET_BANKING	1	t	2026-08-08 11:44:15	2026-08-15 11:44:15	DAY	7	2026-09-07 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15	2026-08-08 11:44:15	2025-08-08 11:44:15
4	2	3	4	4711	txn_razorpay_004	comp_razorpay_004	159.20	INR       	COMPLETED	DEBIT_CARD	3	f	2025-09-08 11:44:15	2025-09-15 11:44:15	DAY	7	2025-10-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15	2025-09-08 11:44:15	2025-08-08 11:44:15
5	2	3	5	4712	txn_razorpay_005	comp_razorpay_005	449.10	INR       	COMPLETED	UPI	3	t	2025-09-08 11:44:15	2025-09-15 11:44:15	DAY	7	2025-10-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15	2025-08-08 11:44:15	2025-09-08 11:44:15	2025-08-08 11:44:15
6	1	1	1	4703	txn_auto_4703_1754634814	comp_auto_4703_1754634814	179.10	INR       	COMPLETED	UPI	1	t	2025-09-08 11:43:27	2025-09-15 11:43:27	DAY	7	2025-10-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27	2025-09-08 11:43:27	2025-08-08 12:03:35
7	1	1	2	4704	txn_auto_4704_1754634814	comp_auto_4704_1754634814	449.10	INR       	COMPLETED	CREDIT_CARD	1	f	2025-09-08 11:43:27	2025-09-15 11:43:27	DAY	7	2025-10-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27	2025-09-08 11:43:27	2025-08-08 12:03:35
8	1	1	3	4705	txn_auto_4705_1754634815	comp_auto_4705_1754634815	1799.10	INR       	COMPLETED	DEBIT_CARD	1	f	2025-09-08 11:43:27	2025-09-15 11:43:27	DAY	7	2025-10-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27	2025-09-08 11:43:27	2025-08-08 12:03:36
9	2	3	4	4706	txn_auto_4706_1754634815	comp_auto_4706_1754634815	0.00	INR       	FAILED	NET_BANKING	1	t	2025-09-08 11:43:27	2025-09-15 11:43:27	DAY	7	2025-10-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27	2025-09-08 11:43:27	2025-08-08 12:03:36
11	1	1	1	4713	txn_auto_4713_1754634817	comp_auto_4713_1754634817	179.10	INR       	COMPLETED	UPI	1	f	2025-09-08 11:45:12	2025-09-15 11:45:12	DAY	7	2025-10-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12	2025-09-08 11:45:12	2025-08-08 12:03:37
12	1	1	2	4714	txn_auto_4714_1754634817	comp_auto_4714_1754634817	449.10	INR       	COMPLETED	CREDIT_CARD	1	f	2025-09-08 11:45:12	2025-09-15 11:45:12	DAY	7	2025-10-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12	2025-09-08 11:45:12	2025-08-08 12:03:37
13	1	1	3	4715	txn_auto_4715_1754634817	comp_auto_4715_1754634817	1799.10	INR       	COMPLETED	DEBIT_CARD	1	t	2025-09-08 11:45:12	2025-09-15 11:45:12	DAY	7	2025-10-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12	2025-09-08 11:45:12	2025-08-08 12:03:37
14	2	3	4	4716	txn_auto_4716_1754634817	comp_auto_4716_1754634817	0.00	INR       	FAILED	NET_BANKING	1	f	2025-09-08 11:45:12	2025-09-15 11:45:12	DAY	7	2025-10-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12	2025-09-08 11:45:12	2025-08-08 12:03:38
16	1	1	1	4718	txn_auto_4718_1754634817	comp_auto_4718_1754634817	179.10	INR       	COMPLETED	UPI	1	t	2025-09-08 11:46:31	2025-09-15 11:46:31	DAY	7	2025-10-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31	2025-09-08 11:46:31	2025-08-08 12:03:38
17	1	1	2	4719	txn_auto_4719_1754634817	comp_auto_4719_1754634817	449.10	INR       	COMPLETED	CREDIT_CARD	1	f	2025-09-08 11:46:31	2025-09-15 11:46:31	DAY	7	2025-10-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31	2025-09-08 11:46:31	2025-08-08 12:03:38
18	1	1	3	4720	txn_auto_4720_1754634818	comp_auto_4720_1754634818	1799.10	INR       	COMPLETED	DEBIT_CARD	1	f	2025-09-08 11:46:31	2025-09-15 11:46:31	DAY	7	2025-10-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31	2025-09-08 11:46:31	2025-08-08 12:03:38
19	2	3	4	4721	txn_auto_4721_1754634818	comp_auto_4721_1754634818	0.00	INR       	FAILED	NET_BANKING	1	t	2025-09-08 11:46:31	2025-09-15 11:46:31	DAY	7	2025-10-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31	2025-09-08 11:46:31	2025-08-08 12:03:38
21	1	1	1	4723	txn_auto_4723_1754634818	comp_auto_4723_1754634818	179.10	INR       	COMPLETED	UPI	1	f	2025-09-08 11:46:54	2025-09-15 11:46:54	DAY	7	2025-10-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54	2025-09-08 11:46:54	2025-08-08 12:03:39
22	1	1	2	4724	txn_auto_4724_1754634818	comp_auto_4724_1754634818	449.10	INR       	COMPLETED	CREDIT_CARD	1	t	2025-09-08 11:46:54	2025-09-15 11:46:54	DAY	7	2025-10-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54	2025-09-08 11:46:54	2025-08-08 12:03:39
23	1	1	3	4725	txn_auto_4725_1754634818	comp_auto_4725_1754634818	1799.10	INR       	COMPLETED	DEBIT_CARD	1	f	2025-09-08 11:46:54	2025-09-15 11:46:54	DAY	7	2025-10-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54	2025-09-08 11:46:54	2025-08-08 12:03:39
24	2	3	4	4726	txn_auto_4726_1754634818	comp_auto_4726_1754634818	0.00	INR       	FAILED	NET_BANKING	1	f	2025-09-08 11:46:54	2025-09-15 11:46:54	DAY	7	2025-10-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54	2025-09-08 11:46:54	2025-08-08 12:03:39
26	1	1	1	4728	txn_auto_4728_1754634819	comp_auto_4728_1754634819	179.10	INR       	COMPLETED	UPI	1	f	2025-09-08 11:47:15	2025-09-15 11:47:15	DAY	7	2025-10-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15	2025-09-08 11:47:15	2025-08-08 12:03:39
27	1	1	2	4729	txn_auto_4729_1754634819	comp_auto_4729_1754634819	449.10	INR       	COMPLETED	CREDIT_CARD	1	f	2025-09-08 11:47:15	2025-09-15 11:47:15	DAY	7	2025-10-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15	2025-09-08 11:47:15	2025-08-08 12:03:39
28	1	1	3	4730	txn_auto_4730_1754634819	comp_auto_4730_1754634819	1799.10	INR       	COMPLETED	DEBIT_CARD	1	t	2025-09-08 11:47:15	2025-09-15 11:47:15	DAY	7	2025-10-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15	2025-09-08 11:47:15	2025-08-08 12:03:40
29	2	3	4	4731	txn_auto_4731_1754634819	comp_auto_4731_1754634819	0.00	INR       	FAILED	NET_BANKING	1	f	2025-09-08 11:47:15	2025-09-15 11:47:15	DAY	7	2025-10-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15	2025-09-08 11:47:15	2025-08-08 12:03:40
31	1	1	1	4733	txn_auto_4733_1754634820	comp_auto_4733_1754634820	179.10	INR       	COMPLETED	UPI	1	t	2025-09-08 11:50:36	2025-09-15 11:50:36	DAY	7	2025-10-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36	2025-09-08 11:50:36	2025-08-08 12:03:40
32	1	1	2	4734	txn_auto_4734_1754634820	comp_auto_4734_1754634820	449.10	INR       	COMPLETED	CREDIT_CARD	1	f	2025-09-08 11:50:36	2025-09-15 11:50:36	DAY	7	2025-10-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36	2025-09-08 11:50:36	2025-08-08 12:03:40
33	1	1	3	4735	txn_auto_4735_1754634820	comp_auto_4735_1754634820	1799.10	INR       	COMPLETED	DEBIT_CARD	1	f	2025-09-08 11:50:36	2025-09-15 11:50:36	DAY	7	2025-10-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36	2025-09-08 11:50:36	2025-08-08 12:03:41
34	2	3	4	4736	txn_auto_4736_1754634820	comp_auto_4736_1754634820	0.00	INR       	FAILED	NET_BANKING	1	t	2025-09-08 11:50:36	2025-09-15 11:50:36	DAY	7	2025-10-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36	2025-09-08 11:50:36	2025-08-08 12:03:41
36	1	1	1	4738	txn_auto_4738_1754634821	comp_auto_4738_1754634821	179.10	INR       	COMPLETED	UPI	1	f	2025-09-08 12:02:30	2025-09-15 12:02:30	DAY	7	2025-10-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30	2025-09-08 12:02:30	2025-08-08 12:03:41
37	1	1	2	4739	txn_auto_4739_1754634821	comp_auto_4739_1754634821	449.10	INR       	COMPLETED	CREDIT_CARD	1	t	2025-09-08 12:02:30	2025-09-15 12:02:30	DAY	7	2025-10-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30	2025-09-08 12:02:30	2025-08-08 12:03:41
38	1	1	3	4740	txn_auto_4740_1754634821	comp_auto_4740_1754634821	1799.10	INR       	COMPLETED	DEBIT_CARD	1	f	2025-09-08 12:02:30	2025-09-15 12:02:30	DAY	7	2025-10-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30	2025-09-08 12:02:30	2025-08-08 12:03:41
39	2	3	4	4741	txn_auto_4741_1754634821	comp_auto_4741_1754634821	0.00	INR       	FAILED	NET_BANKING	1	f	2025-09-08 12:02:30	2025-09-15 12:02:30	DAY	7	2025-10-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30	2025-09-08 12:02:30	2025-08-08 12:03:42
41	1	1	1	4743	txn_auto_4743_1754634822	comp_auto_4743_1754634822	179.10	INR       	COMPLETED	UPI	1	f	2025-09-08 12:03:34	2025-09-15 12:03:34	DAY	7	2025-10-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34	2025-09-08 12:03:34	2025-08-08 12:03:42
42	1	1	2	4744	txn_auto_4744_1754634822	comp_auto_4744_1754634822	449.10	INR       	COMPLETED	CREDIT_CARD	1	f	2025-09-08 12:03:34	2025-09-15 12:03:34	DAY	7	2025-10-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34	2025-09-08 12:03:34	2025-08-08 12:03:42
43	1	1	3	4745	txn_auto_4745_1754634822	comp_auto_4745_1754634822	1799.10	INR       	COMPLETED	DEBIT_CARD	1	t	2025-09-08 12:03:34	2025-09-15 12:03:34	DAY	7	2025-10-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34	2025-09-08 12:03:34	2025-08-08 12:03:42
44	2	3	4	4746	txn_auto_4746_1754634822	comp_auto_4746_1754634822	0.00	INR       	FAILED	NET_BANKING	1	f	2025-09-08 12:03:34	2025-09-15 12:03:34	DAY	7	2025-10-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34	2025-09-08 12:03:34	2025-08-08 12:03:43
45	2	3	5	4707	txn_auto_4707_1754634842	comp_auto_4707_1754634842	449.10	INR       	INPROCESS	WALLET	1	f	2025-09-08 11:43:27	2025-09-15 11:43:27	DAY	7	2025-10-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27	2025-08-08 11:43:27	2025-09-08 11:43:27	2025-08-08 12:04:03
46	2	3	5	4717	txn_auto_4717_1754634844	comp_auto_4717_1754634844	449.10	INR       	INPROCESS	WALLET	1	f	2025-09-08 11:45:12	2025-09-15 11:45:12	DAY	7	2025-10-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12	2025-08-08 11:45:12	2025-09-08 11:45:12	2025-08-08 12:04:04
47	2	3	5	4722	txn_auto_4722_1754634845	comp_auto_4722_1754634845	449.10	INR       	INPROCESS	WALLET	1	f	2025-09-08 11:46:31	2025-09-15 11:46:31	DAY	7	2025-10-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31	2025-08-08 11:46:31	2025-09-08 11:46:31	2025-08-08 12:04:05
48	2	3	5	4727	txn_auto_4727_1754634846	comp_auto_4727_1754634846	449.10	INR       	INPROCESS	WALLET	1	t	2025-09-08 11:46:54	2025-09-15 11:46:54	DAY	7	2025-10-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54	2025-08-08 11:46:54	2025-09-08 11:46:54	2025-08-08 12:04:06
49	2	3	5	4732	txn_auto_4732_1754634846	comp_auto_4732_1754634846	449.10	INR       	INPROCESS	WALLET	1	f	2025-09-08 11:47:15	2025-09-15 11:47:15	DAY	7	2025-10-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15	2025-08-08 11:47:15	2025-09-08 11:47:15	2025-08-08 12:04:07
50	2	3	5	4737	txn_auto_4737_1754634848	comp_auto_4737_1754634848	449.10	INR       	INPROCESS	WALLET	1	f	2025-09-08 11:50:36	2025-09-15 11:50:36	DAY	7	2025-10-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36	2025-08-08 11:50:36	2025-09-08 11:50:36	2025-08-08 12:04:08
51	2	3	5	4742	txn_auto_4742_1754634849	comp_auto_4742_1754634849	449.10	INR       	INPROCESS	WALLET	1	t	2025-09-08 12:02:30	2025-09-15 12:02:30	DAY	7	2025-10-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30	2025-08-08 12:02:30	2025-09-08 12:02:30	2025-08-08 12:04:09
52	2	3	5	4747	txn_auto_4747_1754634850	comp_auto_4747_1754634850	449.10	INR       	INPROCESS	WALLET	1	f	2025-09-08 12:03:34	2025-09-15 12:03:34	DAY	7	2025-10-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34	2025-08-08 12:03:34	2025-09-08 12:03:34	2025-08-08 12:04:11
53	1	1	1	4748	txn_auto_4748_1754634851	comp_auto_4748_1754634851	179.10	INR       	COMPLETED	UPI	1	t	2025-09-08 12:04:02	2025-09-15 12:04:02	DAY	7	2025-10-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02	2025-09-08 12:04:02	2025-08-08 12:04:11
54	1	1	2	4749	txn_auto_4749_1754634851	comp_auto_4749_1754634851	449.10	INR       	COMPLETED	CREDIT_CARD	1	f	2025-09-08 12:04:02	2025-09-15 12:04:02	DAY	7	2025-10-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02	2025-09-08 12:04:02	2025-08-08 12:04:11
55	1	1	3	4750	txn_auto_4750_1754634851	comp_auto_4750_1754634851	1799.10	INR       	COMPLETED	DEBIT_CARD	1	f	2025-09-08 12:04:02	2025-09-15 12:04:02	DAY	7	2025-10-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02	2025-09-08 12:04:02	2025-08-08 12:04:12
56	2	3	4	4751	txn_auto_4751_1754634851	comp_auto_4751_1754634851	0.00	INR       	FAILED	NET_BANKING	1	t	2025-09-08 12:04:02	2025-09-15 12:04:02	DAY	7	2025-10-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02	2025-09-08 12:04:02	2025-08-08 12:04:12
57	2	3	5	4752	txn_auto_4752_1754634852	comp_auto_4752_1754634852	449.10	INR       	INPROCESS	WALLET	1	f	2025-09-08 12:04:02	2025-09-15 12:04:02	DAY	7	2025-10-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02	2025-08-08 12:04:02	2025-09-08 12:04:02	2025-08-08 12:04:12
58	1	1	1	4753	txn_auto_4753_1754634941	comp_auto_4753_1754634941	179.10	INR       	COMPLETED	UPI	1	f	2025-09-08 12:05:31	2025-09-15 12:05:31	DAY	7	2025-10-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31	2025-09-08 12:05:31	2025-08-08 12:05:42
59	1	1	2	4754	txn_auto_4754_1754634942	comp_auto_4754_1754634942	449.10	INR       	COMPLETED	CREDIT_CARD	1	t	2025-09-08 12:05:31	2025-09-15 12:05:31	DAY	7	2025-10-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31	2025-09-08 12:05:31	2025-08-08 12:05:42
60	1	1	3	4755	txn_auto_4755_1754634942	comp_auto_4755_1754634942	1799.10	INR       	COMPLETED	DEBIT_CARD	1	f	2025-09-08 12:05:31	2025-09-15 12:05:31	DAY	7	2025-10-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31	2025-09-08 12:05:31	2025-08-08 12:05:43
61	2	3	4	4756	txn_auto_4756_1754634943	comp_auto_4756_1754634943	0.00	INR       	FAILED	NET_BANKING	1	f	2025-09-08 12:05:31	2025-09-15 12:05:31	DAY	7	2025-10-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31	2025-09-08 12:05:31	2025-08-08 12:05:43
62	2	3	5	4757	txn_auto_4757_1754634943	comp_auto_4757_1754634943	449.10	INR       	INPROCESS	WALLET	1	t	2025-09-08 12:05:31	2025-09-15 12:05:31	DAY	7	2025-10-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31	2025-08-08 12:05:31	2025-09-08 12:05:31	2025-08-08 12:05:44
63	1	1	1	4758	txn_auto_4758_1754892041	comp_auto_4758_1754892041	179.10	INR       	COMPLETED	UPI	1	f	2025-09-11 11:30:37	2025-09-18 11:30:37	DAY	7	2025-10-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37	2025-09-11 11:30:37	2025-08-11 11:30:42
64	1	1	2	4759	txn_auto_4759_1754892041	comp_auto_4759_1754892041	449.10	INR       	COMPLETED	CREDIT_CARD	1	f	2025-09-11 11:30:37	2025-09-18 11:30:37	DAY	7	2025-10-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37	2025-09-11 11:30:37	2025-08-11 11:30:42
65	1	1	3	4760	txn_auto_4760_1754892041	comp_auto_4760_1754892041	1799.10	INR       	COMPLETED	DEBIT_CARD	1	t	2025-09-11 11:30:37	2025-09-18 11:30:37	DAY	7	2025-10-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37	2025-09-11 11:30:37	2025-08-11 11:30:42
66	2	3	4	4761	txn_auto_4761_1754892041	comp_auto_4761_1754892041	0.00	INR       	FAILED	NET_BANKING	1	f	2025-09-11 11:30:37	2025-09-18 11:30:37	DAY	7	2025-10-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37	2025-09-11 11:30:37	2025-08-11 11:30:42
67	2	3	5	4762	txn_auto_4762_1754892042	comp_auto_4762_1754892042	449.10	INR       	INPROCESS	WALLET	1	f	2025-09-11 11:30:37	2025-09-18 11:30:37	DAY	7	2025-10-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37	2025-08-11 11:30:37	2025-09-11 11:30:37	2025-08-11 11:30:42
\.


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

COPY public.user_wallet (id, user_id, current_balance, previous_balance, last_added, last_spent, status, payment_source, currency, created_at) FROM stdin;
\.


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

COPY public.wallet_history (id, user_id, wallet_id, offer_id, current_balance, previous_balance, amount, type, source, refernce_id, currency, "transaction _detail", status, initiated_by, last_modified) FROM stdin;
\.


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

COPY public.wallet_offer (id, title, description, promotional_text1, promotional_text2, promotional_banner1, promotional_banner2, currency, amount, bonus_amount, max_bonus, status, start_date, end_date, created_at, updated_at) FROM stdin;
\.



--
-- Name: cities cities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_pkey PRIMARY KEY (id);


--
-- Name: client_presence client_presence_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.client_presence
    ADD CONSTRAINT client_presence_pkey PRIMARY KEY (id);


--
-- Name: countries countries_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.countries
    ADD CONSTRAINT countries_pkey PRIMARY KEY (id);


--
-- Name: coupon coupon_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupon
    ADD CONSTRAINT coupon_pkey PRIMARY KEY (id);


--
-- Name: currency currency_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.currency
    ADD CONSTRAINT currency_pkey PRIMARY KEY (id);


--
-- Name: customer_detail customer_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customer_detail
    ADD CONSTRAINT customer_detail_pkey PRIMARY KEY (id);


--
-- Name: customer_device customer_device_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customer_device
    ADD CONSTRAINT customer_device_pkey PRIMARY KEY (id);


--
-- Name: customers customers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_pkey PRIMARY KEY (id);


--
-- Name: invoice invoice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoice
    ADD CONSTRAINT invoice_pkey PRIMARY KEY (id);


--
-- Name: order_detail order_detail_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.order_detail
    ADD CONSTRAINT order_detail_pkey PRIMARY KEY (id);


--
-- Name: payment_gateway_master payment_gateway_master_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payment_gateway_master
    ADD CONSTRAINT payment_gateway_master_pkey PRIMARY KEY (id);


--
-- Name: payment_mode_saved payment_mode_saved_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payment_mode_saved
    ADD CONSTRAINT payment_mode_saved_pkey PRIMARY KEY (id);


--
-- Name: role_mngt role_mngt_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.role_mngt
    ADD CONSTRAINT role_mngt_pkey PRIMARY KEY (id);


--
-- Name: states states_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.states
    ADD CONSTRAINT states_pkey PRIMARY KEY (id);


--
-- Name: subscription_package_pricing subscription_package_pricing_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscription_package_pricing
    ADD CONSTRAINT subscription_package_pricing_pkey PRIMARY KEY (id);


--
-- Name: subscription_packages subscription_packages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscription_packages
    ADD CONSTRAINT subscription_packages_pkey PRIMARY KEY (id);


--
-- Name: taxation taxation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxation
    ADD CONSTRAINT taxation_pkey PRIMARY KEY (id);


--
-- Name: temp temp_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.temp
    ADD CONSTRAINT temp_pkey PRIMARY KEY (id);


--
-- Name: transaction transaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transaction
    ADD CONSTRAINT transaction_pkey PRIMARY KEY (id);


--
-- Name: user_wallet user_wallet_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_wallet
    ADD CONSTRAINT user_wallet_pkey PRIMARY KEY (id);


--
-- Name: wallet_history wallet_history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wallet_history
    ADD CONSTRAINT wallet_history_pkey PRIMARY KEY (id);


--
-- Name: wallet_offer wallet_offer_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wallet_offer
    ADD CONSTRAINT wallet_offer_pkey PRIMARY KEY (id);


--
-- Name: cities_country_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX cities_country_id_index ON public.cities USING btree (country_id);


--
-- Name: cities_state_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX cities_state_id_index ON public.cities USING btree (state_id);


--
-- Name: cities_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX cities_status_index ON public.cities USING btree (status);


--
-- Name: client_presence_client_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX client_presence_client_id_index ON public.client_presence USING btree (client_id);


--
-- Name: client_presence_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX client_presence_created_at_index ON public.client_presence USING btree (created_at);


--
-- Name: client_presence_currency_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX client_presence_currency_id_index ON public.client_presence USING btree (currency_id);


--
-- Name: client_presence_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX client_presence_status_index ON public.client_presence USING btree (status);


--
-- Name: client_presence_updated_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX client_presence_updated_at_index ON public.client_presence USING btree (updated_at);


--
-- Name: countries_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX countries_status_index ON public.countries USING btree (status);


--
-- Name: coupon_client_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX coupon_client_id_index ON public.coupon USING btree (client_id);


--
-- Name: coupon_client_presence_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX coupon_client_presence_id_index ON public.coupon USING btree (client_presence_id);


--
-- Name: coupon_code_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX coupon_code_index ON public.coupon USING btree (code);


--
-- Name: coupon_coupon_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX coupon_coupon_type_index ON public.coupon USING btree (coupon_type);


--
-- Name: coupon_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX coupon_created_at_index ON public.coupon USING btree (created_at);


--
-- Name: coupon_created_by_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX coupon_created_by_index ON public.coupon USING btree (created_by);


--
-- Name: coupon_discount_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX coupon_discount_type_index ON public.coupon USING btree (discount_type);


--
-- Name: coupon_end_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX coupon_end_date_index ON public.coupon USING btree (end_date);


--
-- Name: coupon_start_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX coupon_start_date_index ON public.coupon USING btree (start_date);


--
-- Name: customer_detail_age_grouo_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_age_grouo_index ON public.customer_detail USING btree (age_grouo);


--
-- Name: customer_detail_billing_city_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_billing_city_index ON public.customer_detail USING btree (billing_city);


--
-- Name: customer_detail_billing_country_code_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_billing_country_code_index ON public.customer_detail USING btree (billing_country_code);


--
-- Name: customer_detail_billing_country_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_billing_country_index ON public.customer_detail USING btree (billing_country);


--
-- Name: customer_detail_billing_pincode_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_billing_pincode_index ON public.customer_detail USING btree (billing_pincode);


--
-- Name: customer_detail_city_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_city_index ON public.customer_detail USING btree (city);


--
-- Name: customer_detail_country_code_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_country_code_index ON public.customer_detail USING btree (country_code);


--
-- Name: customer_detail_country_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_country_index ON public.customer_detail USING btree (country);


--
-- Name: customer_detail_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_created_at_index ON public.customer_detail USING btree (created_at);


--
-- Name: customer_detail_customer_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_customer_id_index ON public.customer_detail USING btree (customer_id);


--
-- Name: customer_detail_email_from_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_email_from_index ON public.customer_detail USING btree (email_from);


--
-- Name: customer_detail_email_till_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_email_till_index ON public.customer_detail USING btree (email_till);


--
-- Name: customer_detail_first_name_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_first_name_index ON public.customer_detail USING btree (first_name);


--
-- Name: customer_detail_gender_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_gender_index ON public.customer_detail USING btree (gender);


--
-- Name: customer_detail_is_email_verified_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_is_email_verified_index ON public.customer_detail USING btree (is_email_verified);


--
-- Name: customer_detail_is_phone_verified_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_is_phone_verified_index ON public.customer_detail USING btree (is_phone_verified);


--
-- Name: customer_detail_last_name_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_last_name_index ON public.customer_detail USING btree (last_name);


--
-- Name: customer_detail_marital_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_marital_status_index ON public.customer_detail USING btree (marital_status);


--
-- Name: customer_detail_middle_name_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_middle_name_index ON public.customer_detail USING btree (middle_name);


--
-- Name: customer_detail_notification_from_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_notification_from_index ON public.customer_detail USING btree (notification_from);


--
-- Name: customer_detail_notification_till_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_notification_till_index ON public.customer_detail USING btree (notification_till);


--
-- Name: customer_detail_pincode_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_pincode_index ON public.customer_detail USING btree (pincode);


--
-- Name: customer_detail_sms_from_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_sms_from_index ON public.customer_detail USING btree (sms_from);


--
-- Name: customer_detail_sms_till_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_sms_till_index ON public.customer_detail USING btree (sms_till);


--
-- Name: customer_detail_sync_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_sync_status_index ON public.customer_detail USING btree (sync_status);


--
-- Name: customer_detail_updated_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_updated_at_index ON public.customer_detail USING btree (updated_at);


--
-- Name: customer_detail_whatsapp_from_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_whatsapp_from_index ON public.customer_detail USING btree (whatsapp_from);


--
-- Name: customer_detail_whatsapp_till_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_detail_whatsapp_till_index ON public.customer_detail USING btree (whatsapp_till);


--
-- Name: customer_device_customer_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_device_customer_id_index ON public.customer_device USING btree (customer_id);


--
-- Name: customer_device_device_added_on_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_device_device_added_on_index ON public.customer_device USING btree (device_added_on);


--
-- Name: customer_device_platfrom_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_device_platfrom_index ON public.customer_device USING btree (platfrom);


--
-- Name: customer_device_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customer_device_status_index ON public.customer_device USING btree (status);


--
-- Name: customers_client_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customers_client_id_index ON public.customers USING btree (client_id);


--
-- Name: customers_client_presence_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customers_client_presence_id_index ON public.customers USING btree (client_presence_id);


--
-- Name: customers_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customers_created_at_index ON public.customers USING btree (created_at);


--
-- Name: customers_email_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customers_email_id_index ON public.customers USING btree (email_id);


--
-- Name: customers_phone_number_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customers_phone_number_index ON public.customers USING btree (phone_number);


--
-- Name: customers_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customers_status_index ON public.customers USING btree (status);


--
-- Name: customers_subscription_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX customers_subscription_status_index ON public.customers USING btree (subscription_status);


--
-- Name: invoice_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoice_created_at_index ON public.invoice USING btree (created_at);


--
-- Name: invoice_currency_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoice_currency_index ON public.invoice USING btree (currency);


--
-- Name: invoice_order_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoice_order_id_index ON public.invoice USING btree (order_id);


--
-- Name: invoice_state_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoice_state_index ON public.invoice USING btree (state);


--
-- Name: invoice_updated_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoice_updated_at_index ON public.invoice USING btree (updated_at);


--
-- Name: invoice_user_email_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoice_user_email_index ON public.invoice USING btree (user_email);


--
-- Name: invoice_user_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoice_user_id_index ON public.invoice USING btree (user_id);


--
-- Name: invoice_user_phone_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoice_user_phone_index ON public.invoice USING btree (user_phone);


--
-- Name: order_detail_auto_renewal_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_auto_renewal_index ON public.order_detail USING btree (auto_renewal);


--
-- Name: order_detail_client_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_client_id_index ON public.order_detail USING btree (client_id);


--
-- Name: order_detail_client_presence_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_client_presence_id_index ON public.order_detail USING btree (client_presence_id);


--
-- Name: order_detail_coupon_code_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_coupon_code_index ON public.order_detail USING btree (coupon_code);


--
-- Name: order_detail_coupon_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_coupon_id_index ON public.order_detail USING btree (coupon_id);


--
-- Name: order_detail_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_created_at_index ON public.order_detail USING btree (created_at);


--
-- Name: order_detail_customer_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_customer_id_index ON public.order_detail USING btree (customer_id);


--
-- Name: order_detail_end_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_end_date_index ON public.order_detail USING btree (end_date);


--
-- Name: order_detail_gatway_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_gatway_id_index ON public.order_detail USING btree (gatway_id);


--
-- Name: order_detail_package_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_package_id_index ON public.order_detail USING btree (package_id);


--
-- Name: order_detail_start_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_start_date_index ON public.order_detail USING btree (start_date);


--
-- Name: order_detail_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_status_index ON public.order_detail USING btree (status);


--
-- Name: order_detail_taxation_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_taxation_id_index ON public.order_detail USING btree (taxation_id);


--
-- Name: order_detail_triggered_content_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_triggered_content_id_index ON public.order_detail USING btree (triggered_content_id);


--
-- Name: order_detail_updated_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX order_detail_updated_at_index ON public.order_detail USING btree (updated_at);


--
-- Name: payment_mode_saved_source_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX payment_mode_saved_source_type_index ON public.payment_mode_saved USING btree (source_type);


--
-- Name: payment_mode_saved_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX payment_mode_saved_status_index ON public.payment_mode_saved USING btree (status);


--
-- Name: payment_mode_saved_user_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX payment_mode_saved_user_id_index ON public.payment_mode_saved USING btree (user_id);


--
-- Name: role_mngt_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX role_mngt_created_at_index ON public.role_mngt USING btree (created_at);


--
-- Name: role_mngt_created_by_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX role_mngt_created_by_id_index ON public.role_mngt USING btree (created_by_id);


--
-- Name: role_mngt_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX role_mngt_status_index ON public.role_mngt USING btree (status);


--
-- Name: role_mngt_updated_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX role_mngt_updated_at_index ON public.role_mngt USING btree (updated_at);


--
-- Name: states_country_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX states_country_id_index ON public.states USING btree (country_id);


--
-- Name: states_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX states_status_index ON public.states USING btree (status);


--
-- Name: subscription_package_pricing_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_package_pricing_created_at_index ON public.subscription_package_pricing USING btree (created_at);


--
-- Name: subscription_package_pricing_currency_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_package_pricing_currency_id_index ON public.subscription_package_pricing USING btree (currency_id);


--
-- Name: subscription_package_pricing_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_package_pricing_status_index ON public.subscription_package_pricing USING btree (status);


--
-- Name: subscription_package_pricing_subscription_package_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_package_pricing_subscription_package_id_index ON public.subscription_package_pricing USING btree (subscription_package_id);


--
-- Name: subscription_package_pricing_updated_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_package_pricing_updated_at_index ON public.subscription_package_pricing USING btree (updated_at);


--
-- Name: subscription_packages_client_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_packages_client_id_index ON public.subscription_packages USING btree (client_id);


--
-- Name: subscription_packages_client_presence_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_packages_client_presence_id_index ON public.subscription_packages USING btree (client_presence_id);


--
-- Name: subscription_packages_content_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_packages_content_type_index ON public.subscription_packages USING btree (content_type);


--
-- Name: subscription_packages_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_packages_created_at_index ON public.subscription_packages USING btree (created_at);


--
-- Name: subscription_packages_end_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_packages_end_date_index ON public.subscription_packages USING btree (end_date);


--
-- Name: subscription_packages_package_name_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_packages_package_name_index ON public.subscription_packages USING btree (package_name);


--
-- Name: subscription_packages_package_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_packages_package_type_index ON public.subscription_packages USING btree (package_type);


--
-- Name: subscription_packages_start_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_packages_start_date_index ON public.subscription_packages USING btree (start_date);


--
-- Name: subscription_packages_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_packages_status_index ON public.subscription_packages USING btree (status);


--
-- Name: subscription_packages_updated_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscription_packages_updated_at_index ON public.subscription_packages USING btree (updated_at);


--
-- Name: taxation_city_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX taxation_city_id_index ON public.taxation USING btree (city_id);


--
-- Name: taxation_client_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX taxation_client_id_index ON public.taxation USING btree (client_id);


--
-- Name: taxation_client_presence_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX taxation_client_presence_id_index ON public.taxation USING btree (client_presence_id);


--
-- Name: taxation_country_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX taxation_country_id_index ON public.taxation USING btree (country_id);


--
-- Name: taxation_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX taxation_created_at_index ON public.taxation USING btree (created_at);


--
-- Name: taxation_state_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX taxation_state_id_index ON public.taxation USING btree (state_id);


--
-- Name: taxation_tax_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX taxation_tax_type_index ON public.taxation USING btree (tax_type);


--
-- Name: taxation_updated_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX taxation_updated_at_index ON public.taxation USING btree (updated_at);


--
-- Name: transaction_amount_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_amount_index ON public.transaction USING btree (amount);


--
-- Name: transaction_auto_renew_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_auto_renew_index ON public.transaction USING btree (auto_renew);


--
-- Name: transaction_cancel_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_cancel_date_index ON public.transaction USING btree (cancel_date);


--
-- Name: transaction_client_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_client_id_index ON public.transaction USING btree (client_id);


--
-- Name: transaction_client_presence_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_client_presence_id_index ON public.transaction USING btree (client_presence_id);


--
-- Name: transaction_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_created_at_index ON public.transaction USING btree (created_at);


--
-- Name: transaction_currency_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_currency_index ON public.transaction USING btree (currency);


--
-- Name: transaction_customer_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_customer_id_index ON public.transaction USING btree (customer_id);


--
-- Name: transaction_end_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_end_date_index ON public.transaction USING btree (end_date);


--
-- Name: transaction_gateway_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_gateway_id_index ON public.transaction USING btree (gateway_id);


--
-- Name: transaction_order_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_order_id_index ON public.transaction USING btree (order_id);


--
-- Name: transaction_payment_method_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_payment_method_index ON public.transaction USING btree (payment_method);


--
-- Name: transaction_payment_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_payment_status_index ON public.transaction USING btree (payment_status);


--
-- Name: transaction_start_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_start_date_index ON public.transaction USING btree (start_date);


--
-- Name: transaction_transaction_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_transaction_date_index ON public.transaction USING btree (transaction_date);


--
-- Name: transaction_updated_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX transaction_updated_at_index ON public.transaction USING btree (updated_at);


--
-- Name: user_wallet_currency_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX user_wallet_currency_index ON public.user_wallet USING btree (currency);


--
-- Name: user_wallet_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX user_wallet_status_index ON public.user_wallet USING btree (status);


--
-- Name: user_wallet_user_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX user_wallet_user_id_index ON public.user_wallet USING btree (user_id);


--
-- Name: wallet_history_currency_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_history_currency_index ON public.wallet_history USING btree (currency);


--
-- Name: wallet_history_initiated_by_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_history_initiated_by_index ON public.wallet_history USING btree (initiated_by);


--
-- Name: wallet_history_last_modified_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_history_last_modified_index ON public.wallet_history USING btree (last_modified);


--
-- Name: wallet_history_offer_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_history_offer_id_index ON public.wallet_history USING btree (offer_id);


--
-- Name: wallet_history_source_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_history_source_index ON public.wallet_history USING btree (source);


--
-- Name: wallet_history_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_history_status_index ON public.wallet_history USING btree (status);


--
-- Name: wallet_history_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_history_type_index ON public.wallet_history USING btree (type);


--
-- Name: wallet_history_user_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_history_user_id_index ON public.wallet_history USING btree (user_id);


--
-- Name: wallet_history_wallet_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_history_wallet_id_index ON public.wallet_history USING btree (wallet_id);


--
-- Name: wallet_offer_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_offer_created_at_index ON public.wallet_offer USING btree (created_at);


--
-- Name: wallet_offer_currency_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_offer_currency_index ON public.wallet_offer USING btree (currency);


--
-- Name: wallet_offer_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_offer_status_index ON public.wallet_offer USING btree (status);


--
-- Name: wallet_offer_updated_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX wallet_offer_updated_at_index ON public.wallet_offer USING btree (updated_at);


--
-- Name: cities cities_country_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_country_id_foreign FOREIGN KEY (country_id) REFERENCES public.countries(id);


--
-- Name: cities cities_state_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_state_id_foreign FOREIGN KEY (state_id) REFERENCES public.states(id);


--
-- Name: client_presence client_presence_client_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.client_presence
    ADD CONSTRAINT client_presence_client_id_foreign FOREIGN KEY (client_id) REFERENCES public.client(id);


--
-- Name: client_presence client_presence_currency_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.client_presence
    ADD CONSTRAINT client_presence_currency_id_foreign FOREIGN KEY (currency_id) REFERENCES public.currency(id);


--
-- Name: coupon coupon_client_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupon
    ADD CONSTRAINT coupon_client_id_foreign FOREIGN KEY (client_id) REFERENCES public.client(id);


--
-- Name: coupon coupon_client_presence_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupon
    ADD CONSTRAINT coupon_client_presence_id_foreign FOREIGN KEY (client_presence_id) REFERENCES public.client_presence(id);


--
-- Name: coupon coupon_created_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupon
    ADD CONSTRAINT coupon_created_by_foreign FOREIGN KEY (created_by) REFERENCES public.client_user_mngt(id);


--
-- Name: coupon coupon_updated_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.coupon
    ADD CONSTRAINT coupon_updated_by_foreign FOREIGN KEY (updated_by) REFERENCES public.client_user_mngt(id);


--
-- Name: customer_detail customer_detail_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customer_detail
    ADD CONSTRAINT customer_detail_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id);


--
-- Name: customer_detail customer_detail_referred_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customer_detail
    ADD CONSTRAINT customer_detail_referred_id_foreign FOREIGN KEY (referred_id) REFERENCES public.customers(id);


--
-- Name: customer_device customer_device_customer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customer_device
    ADD CONSTRAINT customer_device_customer_id_foreign FOREIGN KEY (customer_id) REFERENCES public.customers(id);


--
-- Name: customers customers_client_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_client_id_foreign FOREIGN KEY (client_id) REFERENCES public.client(id);


--
-- Name: customers customers_client_presence_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_client_presence_id_foreign FOREIGN KEY (client_presence_id) REFERENCES public.client_presence(id);


--
-- Name: invoice invoice_order_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoice
    ADD CONSTRAINT invoice_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.order_detail(id);


--
-- Name: invoice invoice_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoice
    ADD CONSTRAINT invoice_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.customers(id);


--
-- Name: order_detail order_detail_client_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.order_detail
    ADD CONSTRAINT order_detail_client_id_foreign FOREIGN KEY (client_id) REFERENCES public.client(id);


--
-- Name: order_detail order_detail_client_presence_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.order_detail
    ADD CONSTRAINT order_detail_client_presence_id_foreign FOREIGN KEY (client_presence_id) REFERENCES public.client_presence(id);


--
-- Name: order_detail order_detail_coupon_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.order_detail
    ADD CONSTRAINT order_detail_coupon_id_foreign FOREIGN KEY (coupon_id) REFERENCES public.coupon(id);


--
-- Name: order_detail order_detail_gatway_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.order_detail
    ADD CONSTRAINT order_detail_gatway_id_foreign FOREIGN KEY (gatway_id) REFERENCES public.gateway_configuration(id);


--
-- Name: order_detail order_detail_package_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.order_detail
    ADD CONSTRAINT order_detail_package_id_foreign FOREIGN KEY (package_id) REFERENCES public.subscription_packages(id);


--
-- Name: order_detail order_detail_package_pricing_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.order_detail
    ADD CONSTRAINT order_detail_package_pricing_id_foreign FOREIGN KEY (package_pricing_id) REFERENCES public.subscription_package_pricing(id);


--
-- Name: order_detail order_detail_taxation_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.order_detail
    ADD CONSTRAINT order_detail_taxation_id_foreign FOREIGN KEY (taxation_id) REFERENCES public.taxation(id);


--
-- Name: payment_mode_saved payment_mode_saved_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payment_mode_saved
    ADD CONSTRAINT payment_mode_saved_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.customers(id);


--
-- Name: states states_country_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.states
    ADD CONSTRAINT states_country_id_foreign FOREIGN KEY (country_id) REFERENCES public.countries(id);


--
-- Name: subscription_package_pricing subscription_package_pricing_currency_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscription_package_pricing
    ADD CONSTRAINT subscription_package_pricing_currency_id_foreign FOREIGN KEY (currency_id) REFERENCES public.currency(id);


--
-- Name: subscription_package_pricing subscription_package_pricing_subscription_package_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscription_package_pricing
    ADD CONSTRAINT subscription_package_pricing_subscription_package_id_foreign FOREIGN KEY (subscription_package_id) REFERENCES public.subscription_packages(id);


--
-- Name: subscription_packages subscription_packages_client_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscription_packages
    ADD CONSTRAINT subscription_packages_client_id_foreign FOREIGN KEY (client_id) REFERENCES public.client(id);


--
-- Name: subscription_packages subscription_packages_client_presence_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscription_packages
    ADD CONSTRAINT subscription_packages_client_presence_id_foreign FOREIGN KEY (client_presence_id) REFERENCES public.client_presence(id);


--
-- Name: subscription_packages subscription_packages_created_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscription_packages
    ADD CONSTRAINT subscription_packages_created_by_foreign FOREIGN KEY (created_by) REFERENCES public.client_user_mngt(id);


--
-- Name: subscription_packages subscription_packages_updated_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscription_packages
    ADD CONSTRAINT subscription_packages_updated_by_foreign FOREIGN KEY (updated_by) REFERENCES public.client_user_mngt(id);


--
-- Name: taxation taxation_city_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxation
    ADD CONSTRAINT taxation_city_id_foreign FOREIGN KEY (city_id) REFERENCES public.cities(id);


--
-- Name: taxation taxation_client_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxation
    ADD CONSTRAINT taxation_client_id_foreign FOREIGN KEY (client_id) REFERENCES public.client(id);


--
-- Name: taxation taxation_client_presence_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxation
    ADD CONSTRAINT taxation_client_presence_id_foreign FOREIGN KEY (client_presence_id) REFERENCES public.client_presence(id);


--
-- Name: taxation taxation_country_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxation
    ADD CONSTRAINT taxation_country_id_foreign FOREIGN KEY (country_id) REFERENCES public.countries(id);


--
-- Name: taxation taxation_created_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxation
    ADD CONSTRAINT taxation_created_by_foreign FOREIGN KEY (created_by) REFERENCES public.client_user_mngt(id);


--
-- Name: taxation taxation_state_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxation
    ADD CONSTRAINT taxation_state_id_foreign FOREIGN KEY (state_id) REFERENCES public.states(id);


--
-- Name: taxation taxation_updated_by_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.taxation
    ADD CONSTRAINT taxation_updated_by_foreign FOREIGN KEY (updated_by) REFERENCES public.client_user_mngt(id);


--
-- Name: transaction transaction_client_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transaction
    ADD CONSTRAINT transaction_client_id_foreign FOREIGN KEY (client_id) REFERENCES public.client(id);


--
-- Name: transaction transaction_client_presence_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transaction
    ADD CONSTRAINT transaction_client_presence_id_foreign FOREIGN KEY (client_presence_id) REFERENCES public.client_presence(id);


--
-- Name: transaction transaction_gateway_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transaction
    ADD CONSTRAINT transaction_gateway_id_foreign FOREIGN KEY (gateway_id) REFERENCES public.gateway_configuration(id);


--
-- Name: transaction transaction_order_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transaction
    ADD CONSTRAINT transaction_order_id_foreign FOREIGN KEY (order_id) REFERENCES public.order_detail(id);


--
-- Name: user_wallet user_wallet_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_wallet
    ADD CONSTRAINT user_wallet_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.customers(id);


--
-- Name: wallet_history wallet_history_offer_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wallet_history
    ADD CONSTRAINT wallet_history_offer_id_foreign FOREIGN KEY (offer_id) REFERENCES public.wallet_offer(id);


--
-- Name: wallet_history wallet_history_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wallet_history
    ADD CONSTRAINT wallet_history_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.customers(id);


--
-- Name: wallet_history wallet_history_wallet_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.wallet_history
    ADD CONSTRAINT wallet_history_wallet_id_foreign FOREIGN KEY (wallet_id) REFERENCES public.user_wallet(id);


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

GRANT CREATE ON SCHEMA public TO multitv_sms;


--
-- Name: TABLE cities; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.cities TO multitv_sms;


--
-- Name: SEQUENCE cities_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.cities_id_seq TO multitv_sms;


--
-- Name: TABLE client; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.client TO multitv_sms;


--
-- Name: SEQUENCE client_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.client_id_seq TO multitv_sms;


--
-- Name: TABLE client_presence; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.client_presence TO multitv_sms;


--
-- Name: SEQUENCE client_presence_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.client_presence_id_seq TO multitv_sms;


--
-- Name: TABLE client_user_mngt; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.client_user_mngt TO multitv_sms;


--
-- Name: SEQUENCE client_user_mngt_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.client_user_mngt_id_seq TO multitv_sms;


--
-- Name: TABLE countries; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.countries TO multitv_sms;


--
-- Name: TABLE coupon; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.coupon TO multitv_sms;


--
-- Name: TABLE currency; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.currency TO multitv_sms;


--
-- Name: SEQUENCE currency_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.currency_id_seq TO multitv_sms;


--
-- Name: TABLE customer_detail; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.customer_detail TO multitv_sms;


--
-- Name: TABLE customer_device; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.customer_device TO multitv_sms;


--
-- Name: TABLE customers; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.customers TO multitv_sms;


--
-- Name: SEQUENCE customers_presence_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.customers_presence_id_seq TO multitv_sms;


--
-- Name: TABLE gateway_configuration; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.gateway_configuration TO multitv_sms;


--
-- Name: SEQUENCE gateway_configuration_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.gateway_configuration_id_seq TO multitv_sms;


--
-- Name: TABLE invoice; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.invoice TO multitv_sms;


--
-- Name: TABLE order_detail; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.order_detail TO multitv_sms;


--
-- Name: SEQUENCE order_detail_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.order_detail_id_seq TO multitv_sms;


--
-- Name: TABLE payment_gateway_master; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.payment_gateway_master TO multitv_sms;


--
-- Name: TABLE payment_mode_saved; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.payment_mode_saved TO multitv_sms;


--
-- Name: TABLE role_mngt; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.role_mngt TO multitv_sms;


--
-- Name: TABLE states; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.states TO multitv_sms;


--
-- Name: SEQUENCE states_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.states_id_seq TO multitv_sms;


--
-- Name: TABLE subscription_package_pricing; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.subscription_package_pricing TO multitv_sms;


--
-- Name: TABLE subscription_packages; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.subscription_packages TO multitv_sms;


--
-- Name: SEQUENCE subscription_packages_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.subscription_packages_id_seq TO multitv_sms;


--
-- Name: TABLE taxation; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.taxation TO multitv_sms;


--
-- Name: TABLE temp; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.temp TO multitv_sms;


--
-- Name: SEQUENCE temp_id_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON SEQUENCE public.temp_id_seq TO multitv_sms;


--
-- Name: TABLE transaction; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.transaction TO multitv_sms;


--
-- Name: TABLE user_wallet; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.user_wallet TO multitv_sms;


--
-- Name: TABLE users; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.users TO multitv_sms;


--
-- Name: TABLE wallet_history; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.wallet_history TO multitv_sms;


--
-- Name: TABLE wallet_offer; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.wallet_offer TO multitv_sms;


--
-- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: public; Owner: postgres
--

ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT ALL ON SEQUENCES  TO multitv_sms;


--
-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: public; Owner: postgres
--

ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT SELECT,INSERT,DELETE,UPDATE ON TABLES  TO multitv_sms;


--
--

