backup.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 13.18
-- Dumped by pg_dump version 13.18

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

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

CREATE TABLE public.admin_dashboard_adminsettings (
    id integer NOT NULL,
    site_name character varying(255),
    site_description text,
    admin_name character varying(255) DEFAULT 'Admin'::character varying,
    admin_email character varying(255) DEFAULT 'admin@example.com'::character varying,
    admin_phone character varying(15),
    admin_avatar character varying(255),
    created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.admin_dashboard_adminsettings OWNER TO postgres;

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

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


ALTER TABLE public.admin_dashboard_adminsettings_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.admin_dashboard_adminsettings_id_seq OWNED BY public.admin_dashboard_adminsettings.id;


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

CREATE TABLE public.analytics_activitylog (
    id bigint NOT NULL,
    action character varying(255) NOT NULL,
    "timestamp" timestamp with time zone NOT NULL,
    user_id uuid NOT NULL
);


ALTER TABLE public.analytics_activitylog OWNER TO postgres;

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

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


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

CREATE TABLE public.auth_group (
    id integer NOT NULL,
    name character varying(150) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO postgres;

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

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


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

CREATE TABLE public.auth_group_permissions (
    id bigint NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO postgres;

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

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


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

CREATE TABLE public.auth_permission (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO postgres;

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

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


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

CREATE TABLE public.django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    content_type_id integer,
    user_id uuid NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO postgres;

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

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


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

CREATE TABLE public.django_celery_beat_clockedschedule (
    id integer NOT NULL,
    clocked_time timestamp with time zone NOT NULL
);


ALTER TABLE public.django_celery_beat_clockedschedule OWNER TO postgres;

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

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


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

CREATE TABLE public.django_celery_beat_crontabschedule (
    id integer NOT NULL,
    minute character varying(240) NOT NULL,
    hour character varying(96) NOT NULL,
    day_of_week character varying(64) NOT NULL,
    day_of_month character varying(124) NOT NULL,
    month_of_year character varying(64) NOT NULL,
    timezone character varying(63) NOT NULL
);


ALTER TABLE public.django_celery_beat_crontabschedule OWNER TO postgres;

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

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


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

CREATE TABLE public.django_celery_beat_intervalschedule (
    id integer NOT NULL,
    every integer NOT NULL,
    period character varying(24) NOT NULL
);


ALTER TABLE public.django_celery_beat_intervalschedule OWNER TO postgres;

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

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


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

CREATE TABLE public.django_celery_beat_periodictask (
    id integer NOT NULL,
    name character varying(200) NOT NULL,
    task character varying(200) NOT NULL,
    args text NOT NULL,
    kwargs text NOT NULL,
    queue character varying(200),
    exchange character varying(200),
    routing_key character varying(200),
    expires timestamp with time zone,
    enabled boolean NOT NULL,
    last_run_at timestamp with time zone,
    total_run_count integer NOT NULL,
    date_changed timestamp with time zone NOT NULL,
    description text NOT NULL,
    crontab_id integer,
    interval_id integer,
    solar_id integer,
    one_off boolean NOT NULL,
    start_time timestamp with time zone,
    priority integer,
    headers text NOT NULL,
    clocked_id integer,
    expire_seconds integer,
    CONSTRAINT django_celery_beat_periodictask_expire_seconds_check CHECK ((expire_seconds >= 0)),
    CONSTRAINT django_celery_beat_periodictask_priority_check CHECK ((priority >= 0)),
    CONSTRAINT django_celery_beat_periodictask_total_run_count_check CHECK ((total_run_count >= 0))
);


ALTER TABLE public.django_celery_beat_periodictask OWNER TO postgres;

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

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


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

CREATE TABLE public.django_celery_beat_periodictasks (
    ident smallint NOT NULL,
    last_update timestamp with time zone NOT NULL
);


ALTER TABLE public.django_celery_beat_periodictasks OWNER TO postgres;

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

CREATE TABLE public.django_celery_beat_solarschedule (
    id integer NOT NULL,
    event character varying(24) NOT NULL,
    latitude numeric(9,6) NOT NULL,
    longitude numeric(9,6) NOT NULL
);


ALTER TABLE public.django_celery_beat_solarschedule OWNER TO postgres;

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

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


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

CREATE TABLE public.django_content_type (
    id integer NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO postgres;

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

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


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

CREATE TABLE public.django_migrations (
    id bigint NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE public.django_migrations OWNER TO postgres;

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

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


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

CREATE TABLE public.django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE public.django_session OWNER TO postgres;

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

CREATE TABLE public.expense_categories (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    user_id uuid NOT NULL,
    name character varying(100) NOT NULL
);


ALTER TABLE public.expense_categories OWNER TO postgres;

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

CREATE TABLE public.group_expenses_group (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    description text,
    created_at timestamp with time zone NOT NULL
);


ALTER TABLE public.group_expenses_group OWNER TO postgres;

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

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


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

CREATE TABLE public.group_expenses_groupexpense (
    id bigint NOT NULL,
    description character varying(255) NOT NULL,
    amount numeric(10,2) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    category character varying(100) NOT NULL,
    group_id bigint NOT NULL,
    payer_id uuid NOT NULL
);


ALTER TABLE public.group_expenses_groupexpense OWNER TO postgres;

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

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


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

CREATE TABLE public.group_expenses_groupmember (
    id bigint NOT NULL,
    joined_at timestamp with time zone NOT NULL,
    group_id bigint NOT NULL,
    user_id uuid NOT NULL
);


ALTER TABLE public.group_expenses_groupmember OWNER TO postgres;

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

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


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

CREATE TABLE public.group_expenses_settlement (
    id bigint NOT NULL,
    amount numeric(10,2) NOT NULL,
    razorpay_payment_id character varying(255),
    settled_at timestamp with time zone NOT NULL,
    is_settled boolean NOT NULL,
    group_id bigint NOT NULL,
    payee_id uuid NOT NULL,
    payer_id uuid NOT NULL
);


ALTER TABLE public.group_expenses_settlement OWNER TO postgres;

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

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


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

CREATE TABLE public.insights_budgetinsight (
    id bigint NOT NULL,
    category character varying(100) NOT NULL,
    average_spending numeric(10,2) NOT NULL,
    forecasted_spending numeric(10,2) NOT NULL,
    savings_recommendation text,
    created_at timestamp with time zone NOT NULL,
    user_id uuid NOT NULL
);


ALTER TABLE public.insights_budgetinsight OWNER TO postgres;

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

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


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

CREATE TABLE public.insights_savingsgoal (
    id bigint NOT NULL,
    goal_name character varying(255) NOT NULL,
    target_amount numeric(10,2) NOT NULL,
    saved_amount numeric(10,2) NOT NULL,
    deadline date NOT NULL,
    status character varying(20) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    user_id uuid NOT NULL
);


ALTER TABLE public.insights_savingsgoal OWNER TO postgres;

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

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


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

CREATE TABLE public.notifications_notification (
    id bigint NOT NULL,
    recipients character varying(10) NOT NULL,
    title character varying(255) NOT NULL,
    message text NOT NULL,
    status character varying(10) NOT NULL,
    "timestamp" timestamp with time zone NOT NULL
);


ALTER TABLE public.notifications_notification OWNER TO postgres;

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

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


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

CREATE TABLE public.payments_payment (
    id bigint NOT NULL,
    razorpay_order_id character varying(100) NOT NULL,
    razorpay_payment_id character varying(100),
    razorpay_signature character varying(255),
    amount numeric(10,2) NOT NULL,
    status character varying(20) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    user_id uuid NOT NULL
);


ALTER TABLE public.payments_payment OWNER TO postgres;

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

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


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

CREATE TABLE public.payments_subscription (
    id bigint NOT NULL,
    razorpay_subscription_id character varying(255) NOT NULL,
    plan character varying(50) NOT NULL,
    status character varying(50) NOT NULL,
    start_date timestamp with time zone NOT NULL,
    end_date timestamp with time zone NOT NULL,
    created_at timestamp with time zone NOT NULL,
    user_id uuid NOT NULL
);


ALTER TABLE public.payments_subscription OWNER TO postgres;

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

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


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

CREATE TABLE public.token_blacklist_blacklistedtoken (
    id bigint NOT NULL,
    blacklisted_at timestamp with time zone NOT NULL,
    token_id bigint NOT NULL
);


ALTER TABLE public.token_blacklist_blacklistedtoken OWNER TO postgres;

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

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


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

CREATE TABLE public.token_blacklist_outstandingtoken (
    id bigint NOT NULL,
    token text NOT NULL,
    created_at timestamp with time zone,
    expires_at timestamp with time zone NOT NULL,
    user_id uuid,
    jti character varying(255) NOT NULL
);


ALTER TABLE public.token_blacklist_outstandingtoken OWNER TO postgres;

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

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


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

CREATE TABLE public.transactions (
    id uuid NOT NULL,
    amount numeric(10,2) NOT NULL,
    description text NOT NULL,
    date date NOT NULL,
    created_at timestamp with time zone NOT NULL,
    user_id uuid NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    category_type character varying(50) DEFAULT 'expense'::character varying,
    category_id uuid
);


ALTER TABLE public.transactions OWNER TO postgres;

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

CREATE TABLE public.user_budget (
    id bigint NOT NULL,
    monthly_budget numeric(10,2) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    user_id uuid NOT NULL
);


ALTER TABLE public.user_budget OWNER TO postgres;

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

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


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

CREATE TABLE public.users_user (
    password character varying(128) NOT NULL,
    last_login timestamp with time zone,
    is_superuser boolean NOT NULL,
    username character varying(150) NOT NULL,
    first_name character varying(150) NOT NULL,
    last_name character varying(150) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL,
    id uuid NOT NULL,
    email character varying(254) NOT NULL,
    phone_no character varying(15),
    is_premium boolean NOT NULL,
    role character varying(10) NOT NULL
);


ALTER TABLE public.users_user OWNER TO postgres;

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

CREATE TABLE public.users_user_groups (
    id bigint NOT NULL,
    user_id uuid NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.users_user_groups OWNER TO postgres;

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

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


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

CREATE TABLE public.users_user_user_permissions (
    id bigint NOT NULL,
    user_id uuid NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.users_user_user_permissions OWNER TO postgres;

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

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


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

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


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

COPY public.admin_dashboard_adminsettings (id, site_name, site_description, admin_name, admin_email, admin_phone, admin_avatar, created_at, updated_at) FROM stdin;
1	Finance Tracker	A simple finance tracking application	Admin	admin@example.com	1234567890		2025-02-25 14:48:36.990397	2025-02-25 14:48:36.990443
\.


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

COPY public.analytics_activitylog (id, action, "timestamp", user_id) FROM stdin;
\.


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

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


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

COPY public.auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


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

COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add log entry	1	add_logentry
2	Can change log entry	1	change_logentry
3	Can delete log entry	1	delete_logentry
4	Can view log entry	1	view_logentry
5	Can add permission	2	add_permission
6	Can change permission	2	change_permission
7	Can delete permission	2	delete_permission
8	Can view permission	2	view_permission
9	Can add group	3	add_group
10	Can change group	3	change_group
11	Can delete group	3	delete_group
12	Can view group	3	view_group
13	Can add content type	4	add_contenttype
14	Can change content type	4	change_contenttype
15	Can delete content type	4	delete_contenttype
16	Can view content type	4	view_contenttype
17	Can add session	5	add_session
18	Can change session	5	change_session
19	Can delete session	5	delete_session
20	Can view session	5	view_session
21	Can add user	6	add_user
22	Can change user	6	change_user
23	Can delete user	6	delete_user
24	Can view user	6	view_user
25	Can add transaction	7	add_transaction
26	Can change transaction	7	change_transaction
27	Can delete transaction	7	delete_transaction
28	Can view transaction	7	view_transaction
29	Can add budget	8	add_budget
30	Can change budget	8	change_budget
31	Can delete budget	8	delete_budget
32	Can view budget	8	view_budget
33	Can add category	9	add_category
34	Can change category	9	change_category
35	Can delete category	9	delete_category
36	Can view category	9	view_category
37	Can add blacklisted token	10	add_blacklistedtoken
38	Can change blacklisted token	10	change_blacklistedtoken
39	Can delete blacklisted token	10	delete_blacklistedtoken
40	Can view blacklisted token	10	view_blacklistedtoken
41	Can add outstanding token	11	add_outstandingtoken
42	Can change outstanding token	11	change_outstandingtoken
43	Can delete outstanding token	11	delete_outstandingtoken
44	Can view outstanding token	11	view_outstandingtoken
45	Can add crontab	12	add_crontabschedule
46	Can change crontab	12	change_crontabschedule
47	Can delete crontab	12	delete_crontabschedule
48	Can view crontab	12	view_crontabschedule
49	Can add interval	13	add_intervalschedule
50	Can change interval	13	change_intervalschedule
51	Can delete interval	13	delete_intervalschedule
52	Can view interval	13	view_intervalschedule
53	Can add periodic task	14	add_periodictask
54	Can change periodic task	14	change_periodictask
55	Can delete periodic task	14	delete_periodictask
56	Can view periodic task	14	view_periodictask
57	Can add periodic task track	15	add_periodictasks
58	Can change periodic task track	15	change_periodictasks
59	Can delete periodic task track	15	delete_periodictasks
60	Can view periodic task track	15	view_periodictasks
61	Can add solar event	16	add_solarschedule
62	Can change solar event	16	change_solarschedule
63	Can delete solar event	16	delete_solarschedule
64	Can view solar event	16	view_solarschedule
65	Can add clocked	17	add_clockedschedule
66	Can change clocked	17	change_clockedschedule
67	Can delete clocked	17	delete_clockedschedule
68	Can view clocked	17	view_clockedschedule
69	Can add payment	18	add_payment
70	Can change payment	18	change_payment
71	Can delete payment	18	delete_payment
72	Can view payment	18	view_payment
73	Can add subscription	19	add_subscription
74	Can change subscription	19	change_subscription
75	Can delete subscription	19	delete_subscription
76	Can view subscription	19	view_subscription
77	Can add group	20	add_group
78	Can change group	20	change_group
79	Can delete group	20	delete_group
80	Can view group	20	view_group
81	Can add group expense	21	add_groupexpense
82	Can change group expense	21	change_groupexpense
83	Can delete group expense	21	delete_groupexpense
84	Can view group expense	21	view_groupexpense
85	Can add group member	22	add_groupmember
86	Can change group member	22	change_groupmember
87	Can delete group member	22	delete_groupmember
88	Can view group member	22	view_groupmember
89	Can add settlement	23	add_settlement
90	Can change settlement	23	change_settlement
91	Can delete settlement	23	delete_settlement
92	Can view settlement	23	view_settlement
93	Can add transaction	24	add_transaction
94	Can change transaction	24	change_transaction
95	Can delete transaction	24	delete_transaction
96	Can view transaction	24	view_transaction
97	Can add transaction audit	25	add_transactionaudit
98	Can change transaction audit	25	change_transactionaudit
99	Can delete transaction audit	25	delete_transactionaudit
100	Can view transaction audit	25	view_transactionaudit
101	Can add notification	26	add_notification
102	Can change notification	26	change_notification
103	Can delete notification	26	delete_notification
104	Can view notification	26	view_notification
105	Can add activity log	27	add_activitylog
106	Can change activity log	27	change_activitylog
107	Can delete activity log	27	delete_activitylog
108	Can view activity log	27	view_activitylog
109	Can add notification	28	add_notification
110	Can change notification	28	change_notification
111	Can delete notification	28	delete_notification
112	Can view notification	28	view_notification
113	Can add admin settings	29	add_adminsettings
114	Can change admin settings	29	change_adminsettings
115	Can delete admin settings	29	delete_adminsettings
116	Can view admin settings	29	view_adminsettings
117	Can add budget insight	30	add_budgetinsight
118	Can change budget insight	30	change_budgetinsight
119	Can delete budget insight	30	delete_budgetinsight
120	Can view budget insight	30	view_budgetinsight
121	Can add savings goal	31	add_savingsgoal
122	Can change savings goal	31	change_savingsgoal
123	Can delete savings goal	31	delete_savingsgoal
124	Can view savings goal	31	view_savingsgoal
\.


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

COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
\.


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

COPY public.django_celery_beat_clockedschedule (id, clocked_time) FROM stdin;
\.


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

COPY public.django_celery_beat_crontabschedule (id, minute, hour, day_of_week, day_of_month, month_of_year, timezone) FROM stdin;
\.


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

COPY public.django_celery_beat_intervalschedule (id, every, period) FROM stdin;
\.


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

COPY public.django_celery_beat_periodictask (id, name, task, args, kwargs, queue, exchange, routing_key, expires, enabled, last_run_at, total_run_count, date_changed, description, crontab_id, interval_id, solar_id, one_off, start_time, priority, headers, clocked_id, expire_seconds) FROM stdin;
\.


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

COPY public.django_celery_beat_periodictasks (ident, last_update) FROM stdin;
\.


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

COPY public.django_celery_beat_solarschedule (id, event, latitude, longitude) FROM stdin;
\.


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

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	permission
3	auth	group
4	contenttypes	contenttype
5	sessions	session
6	users	user
7	transactions	transaction
8	transactions	budget
9	transactions	category
10	token_blacklist	blacklistedtoken
11	token_blacklist	outstandingtoken
12	django_celery_beat	crontabschedule
13	django_celery_beat	intervalschedule
14	django_celery_beat	periodictask
15	django_celery_beat	periodictasks
16	django_celery_beat	solarschedule
17	django_celery_beat	clockedschedule
18	payments	payment
19	payments	subscription
20	group_expenses	group
21	group_expenses	groupexpense
22	group_expenses	groupmember
23	group_expenses	settlement
24	admin_dashboard	transaction
25	admin_dashboard	transactionaudit
26	notifications	notification
27	analytics	activitylog
28	transactions	notification
29	admin_dashboard	adminsettings
30	insights	budgetinsight
31	insights	savingsgoal
\.


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

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2025-02-11 16:24:17.348781+05:30
2	contenttypes	0002_remove_content_type_name	2025-02-11 16:24:17.626894+05:30
3	auth	0001_initial	2025-02-11 16:24:19.114691+05:30
4	auth	0002_alter_permission_name_max_length	2025-02-11 16:24:19.183754+05:30
5	auth	0003_alter_user_email_max_length	2025-02-11 16:24:19.200752+05:30
6	auth	0004_alter_user_username_opts	2025-02-11 16:24:19.24409+05:30
7	auth	0005_alter_user_last_login_null	2025-02-11 16:24:19.260684+05:30
8	auth	0006_require_contenttypes_0002	2025-02-11 16:24:19.264778+05:30
9	auth	0007_alter_validators_add_error_messages	2025-02-11 16:24:19.281131+05:30
10	auth	0008_alter_user_username_max_length	2025-02-11 16:24:19.30016+05:30
11	auth	0009_alter_user_last_name_max_length	2025-02-11 16:24:19.319326+05:30
12	auth	0010_alter_group_name_max_length	2025-02-11 16:24:19.670211+05:30
13	auth	0011_update_proxy_permissions	2025-02-11 16:24:19.684677+05:30
14	auth	0012_alter_user_first_name_max_length	2025-02-11 16:24:19.712465+05:30
15	users	0001_initial	2025-02-11 16:24:21.253124+05:30
16	admin	0001_initial	2025-02-11 16:24:21.679246+05:30
17	admin	0002_logentry_remove_auto_add	2025-02-11 16:24:21.720973+05:30
18	admin	0003_logentry_add_action_flag_choices	2025-02-11 16:24:21.763704+05:30
19	sessions	0001_initial	2025-02-11 16:24:22.154138+05:30
20	transactions	0001_initial	2025-02-11 20:12:24.647414+05:30
21	transactions	0002_budget	2025-02-12 11:08:14.58442+05:30
22	transactions	0003_remove_transaction_created_at_and_more	2025-02-12 22:14:54.984434+05:30
32	transactions	0004_alter_transaction_category_type_and_more	2025-02-13 15:17:06.958472+05:30
33	transactions	0005_alter_transaction_id	2025-02-13 15:17:07.311472+05:30
34	transactions	0006_auto_20250212_2224	2025-02-13 15:17:07.325302+05:30
35	transactions	0005_fix_created_at	2025-02-13 19:54:19.787639+05:30
36	token_blacklist	0001_initial	2025-02-14 15:18:49.865363+05:30
37	token_blacklist	0002_outstandingtoken_jti_hex	2025-02-14 15:18:49.922985+05:30
38	token_blacklist	0003_auto_20171017_2007	2025-02-14 15:18:50.021556+05:30
39	token_blacklist	0004_auto_20171017_2013	2025-02-14 15:18:50.182401+05:30
40	token_blacklist	0005_remove_outstandingtoken_jti	2025-02-14 15:18:50.349459+05:30
41	token_blacklist	0006_auto_20171017_2113	2025-02-14 15:18:50.428448+05:30
42	token_blacklist	0007_auto_20171017_2214	2025-02-14 15:18:50.772088+05:30
43	token_blacklist	0008_migrate_to_bigautofield	2025-02-14 15:18:51.455847+05:30
44	token_blacklist	0010_fix_migrate_to_bigautofield	2025-02-14 15:18:51.633995+05:30
45	token_blacklist	0011_linearizes_history	2025-02-14 15:18:51.658275+05:30
46	token_blacklist	0012_alter_outstandingtoken_user	2025-02-14 15:18:51.732838+05:30
47	payments	0001_initial	2025-02-14 16:28:07.201849+05:30
48	django_celery_beat	0001_initial	2025-02-14 19:30:19.469172+05:30
49	django_celery_beat	0002_auto_20161118_0346	2025-02-14 19:30:19.61958+05:30
50	django_celery_beat	0003_auto_20161209_0049	2025-02-14 19:30:19.710208+05:30
51	django_celery_beat	0004_auto_20170221_0000	2025-02-14 19:30:19.726923+05:30
52	django_celery_beat	0005_add_solarschedule_events_choices	2025-02-14 19:30:19.743843+05:30
53	django_celery_beat	0006_auto_20180322_0932	2025-02-14 19:30:20.02351+05:30
54	django_celery_beat	0007_auto_20180521_0826	2025-02-14 19:30:20.101045+05:30
55	django_celery_beat	0008_auto_20180914_1922	2025-02-14 19:30:20.26424+05:30
56	django_celery_beat	0006_auto_20180210_1226	2025-02-14 19:30:20.367654+05:30
57	django_celery_beat	0006_periodictask_priority	2025-02-14 19:30:20.414603+05:30
58	django_celery_beat	0009_periodictask_headers	2025-02-14 19:30:20.460036+05:30
59	django_celery_beat	0010_auto_20190429_0326	2025-02-14 19:30:21.024255+05:30
60	django_celery_beat	0011_auto_20190508_0153	2025-02-14 19:30:21.173033+05:30
61	django_celery_beat	0012_periodictask_expire_seconds	2025-02-14 19:30:21.228799+05:30
62	django_celery_beat	0013_auto_20200609_0727	2025-02-14 19:30:21.273925+05:30
63	django_celery_beat	0014_remove_clockedschedule_enabled	2025-02-14 19:30:21.291833+05:30
64	django_celery_beat	0015_edit_solarschedule_events_choices	2025-02-14 19:30:21.30744+05:30
65	django_celery_beat	0016_alter_crontabschedule_timezone	2025-02-14 19:30:21.350035+05:30
66	django_celery_beat	0017_alter_crontabschedule_month_of_year	2025-02-14 19:30:21.38465+05:30
67	django_celery_beat	0018_improve_crontab_helptext	2025-02-14 19:30:21.405644+05:30
68	django_celery_beat	0019_alter_periodictasks_options	2025-02-14 19:30:21.40979+05:30
69	admin_dashboard	0001_initial	2025-02-15 21:14:58.270434+05:30
70	analytics	0001_initial	2025-02-15 21:14:59.170557+05:30
71	group_expenses	0001_initial	2025-02-15 21:15:00.988953+05:30
73	payments	0002_subscription	2025-02-15 21:15:02.403122+05:30
74	transactions	0006_add_category_type_column	2025-02-15 21:15:02.471427+05:30
75	transactions	0007_merge_20250213_2045	2025-02-15 21:15:02.482252+05:30
76	transactions	0008_rename_monthly_budget_budget_monthly_limit_and_more	2025-02-15 21:31:21.778283+05:30
77	transactions	0009_notification	2025-02-16 11:44:46.918047+05:30
78	transactions	0010_alter_notification_user_and_more	2025-02-16 11:44:47.747984+05:30
79	admin_dashboard	0002_adminsettings	2025-02-17 18:59:23.46495+05:30
80	transactions	0011_alter_category_name_alter_transaction_category_and_more	2025-02-20 15:55:09.20283+05:30
81	insights	0001_initial	2025-02-21 11:32:32.64972+05:30
82	admin_dashboard	0002_adminsettings_admin_avatar_adminsettings_admin_email_and_more	2025-02-22 22:03:16.731182+05:30
83	notifications	0002_remove_notification_is_sent_and_more	2025-02-22 22:03:17.08526+05:30
84	users	0002_user_role	2025-02-24 12:53:36.66312+05:30
85	notifications	0001_initial	2025-02-25 18:28:01.338751+05:30
\.


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

COPY public.django_session (session_key, session_data, expire_date) FROM stdin;
ezai455g3nm6kj8kon41yzgkngjaemig	.eJxVzDsOwjAQRdG9uCaW_3Yo6VlDNOOZIQGUSPlUiL1DpBRQv3veS3WwrX23LTx3A6mzSi1n8FWawKU2wSI0GCg0yVYQthQ9gTr9MoT64HG3dIfxNuk6jes8oN4TfayLvk7Ez8vR_h30sPRfHVvjETlF9pIYrSfnkEyouZWQgilgY7GSSahUsU7AgxRDiSlBFqfeH5e4QsA:1ti7dv:_GQxK-KSXh6snZ51TAsRKhCpy8174JVd16CZ7KExfe0	2025-02-26 13:28:47.696444+05:30
ik54gqre8ffr7v7ht3ae4z8dpvw98ppe	.eJxVzDsOwjAQRdG9uCaW_3Yo6VlDNOOZIQGUSPlUiL1DpBRQv3veS3WwrX23LTx3A6mzSi1n8FWawKU2wSI0GCg0yVYQthQ9gTr9MoT64HG3dIfxNuk6jes8oN4TfayLvk7Ez8vR_h30sPRfHVvjETlF9pIYrSfnkEyouZWQgilgY7GSSahUsU7AgxRDiSlBFqfeH5e4QsA:1tickh:-xhqx9Osupgu3QC4BKzXhg1H_IqDsRy09QV7zwk1c8g	2025-02-27 22:41:51.191539+05:30
5hhygr7t606dcvd9s1pnbu4r28boax51	.eJxVzDkOwjAQheG7uMaWx2O8UNJzhsj2zBAWJVKWCnF3iJQC6vd_76W6si59t848dTdSJ4UZ0bJkzS417eHodIaQNVHIJIUDZFKHX1ZLe_CwWbqX4TqaNg7LdKtmS8y-zuYyEj_Pe_t30Je5_2rvCcA1lEoBMCCLxJSsY4pNqm3eIzZ2RVIkB5UFYqyxoBUUD8Tq_QHom0Gw:1tmw4U:s5dElTBAulrM-_pEYSxC7MSorefTeqzdyVoyiA5hTH4	2025-03-11 20:08:06.76562+05:30
\.


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

COPY public.expense_categories (id, user_id, name) FROM stdin;
b40974e0-27e7-4047-a04c-0af2fcf51ef4	96a63e12-2e0d-490e-af07-4104deaa83a2	Food
41f2d404-9a8f-4a77-853c-6db1796aad90	77b1e776-2dac-44bc-be5f-a408eee1099b	Travel
b010c8de-bde4-422e-b64b-51e98be32639	6da7f23f-1a71-4c3f-b1b1-05302c7bc44e	Entertainment
d247c394-ddd5-4d8d-8368-87ffcc2cf0c3	74bcfcac-fc25-46d0-83f1-93b4e66b0aff	Shopping
\.


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

COPY public.group_expenses_group (id, name, description, created_at) FROM stdin;
1	Group 1	Group 1 description	2025-02-17 13:57:54.951093+05:30
2	Group 2	Group 2 description	2025-02-17 13:57:55.288141+05:30
3	Group 1	Group 1 description	2025-02-17 14:48:45.224766+05:30
4	Group 2	Group 2 description	2025-02-17 14:48:45.299043+05:30
\.


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

COPY public.group_expenses_groupexpense (id, description, amount, created_at, category, group_id, payer_id) FROM stdin;
1	Group lunch	150.00	2025-02-17 13:57:55.633614+05:30		1	e08c6fd0-81c0-4a30-a1ed-ca3137bb6c34
2	Group travel	300.00	2025-02-17 13:57:55.784277+05:30		1	b02fd172-0c46-4099-b2d2-241b7699dad7
3	Group movie	100.00	2025-02-17 13:57:55.801477+05:30		2	206e42ed-eea6-42e5-93e2-ea0aba3a85eb
4	Group lunch	150.00	2025-02-17 14:48:45.573828+05:30		3	b0172e60-965f-4a46-a45d-3dbdb96880da
5	Group travel	300.00	2025-02-17 14:48:45.604571+05:30		3	e260dc15-f3ec-40a5-876e-8a121bd04676
6	Group movie	100.00	2025-02-17 14:48:45.61448+05:30		4	3ea70030-b6a5-475e-8ac0-1e143ea05a8f
\.


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

COPY public.group_expenses_groupmember (id, joined_at, group_id, user_id) FROM stdin;
1	2025-02-17 13:57:55.304291+05:30	1	e08c6fd0-81c0-4a30-a1ed-ca3137bb6c34
2	2025-02-17 13:57:55.59083+05:30	1	b02fd172-0c46-4099-b2d2-241b7699dad7
3	2025-02-17 13:57:55.602628+05:30	2	206e42ed-eea6-42e5-93e2-ea0aba3a85eb
4	2025-02-17 14:48:45.313299+05:30	3	b0172e60-965f-4a46-a45d-3dbdb96880da
5	2025-02-17 14:48:45.531455+05:30	3	e260dc15-f3ec-40a5-876e-8a121bd04676
6	2025-02-17 14:48:45.546092+05:30	4	3ea70030-b6a5-475e-8ac0-1e143ea05a8f
\.


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

COPY public.group_expenses_settlement (id, amount, razorpay_payment_id, settled_at, is_settled, group_id, payee_id, payer_id) FROM stdin;
\.


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

COPY public.insights_budgetinsight (id, category, average_spending, forecasted_spending, savings_recommendation, created_at, user_id) FROM stdin;
\.


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

COPY public.insights_savingsgoal (id, goal_name, target_amount, saved_amount, deadline, status, created_at, user_id) FROM stdin;
\.


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

COPY public.notifications_notification (id, recipients, title, message, status, "timestamp") FROM stdin;
\.


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

COPY public.payments_payment (id, razorpay_order_id, razorpay_payment_id, razorpay_signature, amount, status, created_at, user_id) FROM stdin;
\.


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

COPY public.payments_subscription (id, razorpay_subscription_id, plan, status, start_date, end_date, created_at, user_id) FROM stdin;
\.


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

COPY public.token_blacklist_blacklistedtoken (id, blacklisted_at, token_id) FROM stdin;
\.


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

COPY public.token_blacklist_outstandingtoken (id, token, created_at, expires_at, user_id, jti) FROM stdin;
\.


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

COPY public.transactions (id, amount, description, date, created_at, user_id, updated_at, category_type, category_id) FROM stdin;
\.


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

COPY public.user_budget (id, monthly_budget, created_at, user_id) FROM stdin;
\.


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

COPY public.users_user (password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, id, email, phone_no, is_premium, role) FROM stdin;
pbkdf2_sha256$870000$uA6keVhKm1PArAx5bp7BPD$X+ppvxp3u32mh+f2x/eG0uh9BJZbVORV4mpvARcYFn4=	\N	f	Arya_stark			f	t	2025-02-11 16:33:39.659303+05:30	96a63e12-2e0d-490e-af07-4104deaa83a2	housestark@gmail.com	123456789	f	user
pbkdf2_sha256$870000$5dXEro2r5sQVk3AlJVRfgi$U1uLWTVjUYjz5rvciM1zM9LVYOYr8ghnm26aizvwn2M=	\N	f	user1			t	t	2025-02-17 13:57:39.65044+05:30	e08c6fd0-81c0-4a30-a1ed-ca3137bb6c34	user1@example.com	\N	f	user
pbkdf2_sha256$870000$uWeS4HdetmtJvwnA62kmpn$H2rKR0morXTPL7oEzicwG4gQVTIS0PtW81TTIcAtPM8=	\N	f	user2			f	t	2025-02-17 13:57:43.369306+05:30	b02fd172-0c46-4099-b2d2-241b7699dad7	user2@example.com	\N	f	user
pbkdf2_sha256$870000$phhTPs1OvuFxpWI3rjngEA$41VxkJrz5HAHLQoqo1i2TvDgEHoMBX/hhgG7yYkwJCU=	\N	f	user3			f	t	2025-02-17 13:57:45.402998+05:30	206e42ed-eea6-42e5-93e2-ea0aba3a85eb	user3@example.com	\N	f	user
pbkdf2_sha256$870000$0EKe1qlW1ROcCZHrAesgX9$ZUWD2VSLyhUmB5NR0xkGAr4rhD4dJ7GiydqdErKZbAM=	\N	f	boyd			t	t	2025-02-17 14:48:37.12341+05:30	b0172e60-965f-4a46-a45d-3dbdb96880da	boyd@example.com	\N	f	user
pbkdf2_sha256$870000$eqvflAubi2rKqIswpI1EDy$GbIQcCZ/2v+69e4FTGqQ+ZP7ip5k6c+qM7f5k0eJn+0=	\N	f	tabitha			f	t	2025-02-17 14:48:40.522175+05:30	e260dc15-f3ec-40a5-876e-8a121bd04676	tabitha@example.com	\N	f	user
pbkdf2_sha256$870000$24hGeomHCkkYixjY3icbx6$QDgJx+l0wtumXXulxteam4Fcd6pPlzBhPKhvqxvs1so=	\N	f	ethan			f	t	2025-02-17 14:48:42.619376+05:30	3ea70030-b6a5-475e-8ac0-1e143ea05a8f	ethan@example.com	\N	f	user
	\N	f	admin_aff			f	t	2025-02-24 14:20:53.229701+05:30	ce5f6294-1689-4e66-a57e-b94f3b89d99c	affrin8123@example.com	\N	f	admin
pbkdf2_sha256$870000$bFNtyI6Pw6HxK3scFUJwcn$fbytE1wunodQu+cBYgg5w48GRk867bl03tixQHWnnQE=	2025-02-25 20:08:06.710469+05:30	t	admin			t	t	2025-02-24 20:00:47.401953+05:30	39330ef9-e28c-4152-9169-dd69dfae619d	adminfinance_tracker@gmail.com	\N	f	user
password123	\N	f	Zainab			f	t	2025-02-25 20:36:04.062402+05:30	48c37d0b-2736-4ee9-be49-0b0806944952	zainab@example.com	\N	f	user
password123	\N	f	Arjun			f	t	2025-02-25 20:36:04.256221+05:30	77b1e776-2dac-44bc-be5f-a408eee1099b	arjun@example.com	\N	f	user
password123	\N	f	Mathan			f	t	2025-02-25 20:36:04.275609+05:30	6da7f23f-1a71-4c3f-b1b1-05302c7bc44e	mathan@example.com	\N	f	user
password123	\N	f	Nabila			f	t	2025-02-25 20:36:04.29278+05:30	74bcfcac-fc25-46d0-83f1-93b4e66b0aff	nabila@example.com	\N	f	user
\.


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

COPY public.users_user_groups (id, user_id, group_id) FROM stdin;
\.


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

COPY public.users_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


--
-- Name: admin_dashboard_adminsettings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.admin_dashboard_adminsettings_id_seq', 1, true);


--
-- Name: analytics_activitylog_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.analytics_activitylog_id_seq', 1, false);


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.auth_group_id_seq', 1, false);


--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.auth_group_permissions_id_seq', 1, false);


--
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.auth_permission_id_seq', 124, true);


--
-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_admin_log_id_seq', 1, false);


--
-- Name: django_celery_beat_clockedschedule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_celery_beat_clockedschedule_id_seq', 1, false);


--
-- Name: django_celery_beat_crontabschedule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_celery_beat_crontabschedule_id_seq', 1, false);


--
-- Name: django_celery_beat_intervalschedule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_celery_beat_intervalschedule_id_seq', 1, false);


--
-- Name: django_celery_beat_periodictask_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_celery_beat_periodictask_id_seq', 1, false);


--
-- Name: django_celery_beat_solarschedule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_celery_beat_solarschedule_id_seq', 1, false);


--
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_content_type_id_seq', 31, true);


--
-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_migrations_id_seq', 85, true);


--
-- Name: group_expenses_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.group_expenses_group_id_seq', 4, true);


--
-- Name: group_expenses_groupexpense_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.group_expenses_groupexpense_id_seq', 6, true);


--
-- Name: group_expenses_groupmember_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.group_expenses_groupmember_id_seq', 6, true);


--
-- Name: group_expenses_settlement_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.group_expenses_settlement_id_seq', 1, false);


--
-- Name: insights_budgetinsight_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.insights_budgetinsight_id_seq', 1, false);


--
-- Name: insights_savingsgoal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.insights_savingsgoal_id_seq', 1, false);


--
-- Name: notifications_notification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.notifications_notification_id_seq', 1, false);


--
-- Name: payments_payment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.payments_payment_id_seq', 1, false);


--
-- Name: payments_subscription_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.payments_subscription_id_seq', 1, false);


--
-- Name: token_blacklist_blacklistedtoken_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.token_blacklist_blacklistedtoken_id_seq', 1, false);


--
-- Name: token_blacklist_outstandingtoken_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.token_blacklist_outstandingtoken_id_seq', 1, false);


--
-- Name: transactions_budget_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.transactions_budget_id_seq', 1, false);


--
-- Name: users_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.users_user_groups_id_seq', 1, false);


--
-- Name: users_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.users_user_user_permissions_id_seq', 1, false);


--
-- Name: admin_dashboard_adminsettings admin_dashboard_adminsettings_admin_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_dashboard_adminsettings
    ADD CONSTRAINT admin_dashboard_adminsettings_admin_email_key UNIQUE (admin_email);


--
-- Name: admin_dashboard_adminsettings admin_dashboard_adminsettings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.admin_dashboard_adminsettings
    ADD CONSTRAINT admin_dashboard_adminsettings_pkey PRIMARY KEY (id);


--
-- Name: analytics_activitylog analytics_activitylog_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.analytics_activitylog
    ADD CONSTRAINT analytics_activitylog_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);


--
-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_celery_beat_clockedschedule django_celery_beat_clockedschedule_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_clockedschedule
    ADD CONSTRAINT django_celery_beat_clockedschedule_pkey PRIMARY KEY (id);


--
-- Name: django_celery_beat_crontabschedule django_celery_beat_crontabschedule_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_crontabschedule
    ADD CONSTRAINT django_celery_beat_crontabschedule_pkey PRIMARY KEY (id);


--
-- Name: django_celery_beat_intervalschedule django_celery_beat_intervalschedule_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_intervalschedule
    ADD CONSTRAINT django_celery_beat_intervalschedule_pkey PRIMARY KEY (id);


--
-- Name: django_celery_beat_periodictask django_celery_beat_periodictask_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_periodictask
    ADD CONSTRAINT django_celery_beat_periodictask_name_key UNIQUE (name);


--
-- Name: django_celery_beat_periodictask django_celery_beat_periodictask_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_periodictask
    ADD CONSTRAINT django_celery_beat_periodictask_pkey PRIMARY KEY (id);


--
-- Name: django_celery_beat_periodictasks django_celery_beat_periodictasks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_periodictasks
    ADD CONSTRAINT django_celery_beat_periodictasks_pkey PRIMARY KEY (ident);


--
-- Name: django_celery_beat_solarschedule django_celery_beat_solar_event_latitude_longitude_ba64999a_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_solarschedule
    ADD CONSTRAINT django_celery_beat_solar_event_latitude_longitude_ba64999a_uniq UNIQUE (event, latitude, longitude);


--
-- Name: django_celery_beat_solarschedule django_celery_beat_solarschedule_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_solarschedule
    ADD CONSTRAINT django_celery_beat_solarschedule_pkey PRIMARY KEY (id);


--
-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);


--
-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: group_expenses_group group_expenses_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_group
    ADD CONSTRAINT group_expenses_group_pkey PRIMARY KEY (id);


--
-- Name: group_expenses_groupexpense group_expenses_groupexpense_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_groupexpense
    ADD CONSTRAINT group_expenses_groupexpense_pkey PRIMARY KEY (id);


--
-- Name: group_expenses_groupmember group_expenses_groupmember_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_groupmember
    ADD CONSTRAINT group_expenses_groupmember_pkey PRIMARY KEY (id);


--
-- Name: group_expenses_settlement group_expenses_settlement_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_settlement
    ADD CONSTRAINT group_expenses_settlement_pkey PRIMARY KEY (id);


--
-- Name: insights_budgetinsight insights_budgetinsight_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.insights_budgetinsight
    ADD CONSTRAINT insights_budgetinsight_pkey PRIMARY KEY (id);


--
-- Name: insights_savingsgoal insights_savingsgoal_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.insights_savingsgoal
    ADD CONSTRAINT insights_savingsgoal_pkey PRIMARY KEY (id);


--
-- Name: notifications_notification notifications_notification_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notifications_notification
    ADD CONSTRAINT notifications_notification_pkey PRIMARY KEY (id);


--
-- Name: payments_payment payments_payment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payments_payment
    ADD CONSTRAINT payments_payment_pkey PRIMARY KEY (id);


--
-- Name: payments_payment payments_payment_razorpay_order_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payments_payment
    ADD CONSTRAINT payments_payment_razorpay_order_id_key UNIQUE (razorpay_order_id);


--
-- Name: payments_subscription payments_subscription_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payments_subscription
    ADD CONSTRAINT payments_subscription_pkey PRIMARY KEY (id);


--
-- Name: token_blacklist_blacklistedtoken token_blacklist_blacklistedtoken_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.token_blacklist_blacklistedtoken
    ADD CONSTRAINT token_blacklist_blacklistedtoken_pkey PRIMARY KEY (id);


--
-- Name: token_blacklist_blacklistedtoken token_blacklist_blacklistedtoken_token_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.token_blacklist_blacklistedtoken
    ADD CONSTRAINT token_blacklist_blacklistedtoken_token_id_key UNIQUE (token_id);


--
-- Name: token_blacklist_outstandingtoken token_blacklist_outstandingtoken_jti_hex_d9bdf6f7_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.token_blacklist_outstandingtoken
    ADD CONSTRAINT token_blacklist_outstandingtoken_jti_hex_d9bdf6f7_uniq UNIQUE (jti);


--
-- Name: token_blacklist_outstandingtoken token_blacklist_outstandingtoken_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.token_blacklist_outstandingtoken
    ADD CONSTRAINT token_blacklist_outstandingtoken_pkey PRIMARY KEY (id);


--
-- Name: user_budget transactions_budget_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_budget
    ADD CONSTRAINT transactions_budget_pkey PRIMARY KEY (id);


--
-- Name: user_budget transactions_budget_user_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_budget
    ADD CONSTRAINT transactions_budget_user_id_key UNIQUE (user_id);


--
-- Name: expense_categories transactions_category_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.expense_categories
    ADD CONSTRAINT transactions_category_name_key UNIQUE (name);


--
-- Name: expense_categories transactions_category_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.expense_categories
    ADD CONSTRAINT transactions_category_pkey PRIMARY KEY (id);


--
-- Name: transactions transactions_transaction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_transaction_pkey PRIMARY KEY (id);


--
-- Name: users_user users_user_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user
    ADD CONSTRAINT users_user_email_key UNIQUE (email);


--
-- Name: users_user_groups users_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_groups
    ADD CONSTRAINT users_user_groups_pkey PRIMARY KEY (id);


--
-- Name: users_user_groups users_user_groups_user_id_group_id_b88eab82_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_groups
    ADD CONSTRAINT users_user_groups_user_id_group_id_b88eab82_uniq UNIQUE (user_id, group_id);


--
-- Name: users_user users_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user
    ADD CONSTRAINT users_user_pkey PRIMARY KEY (id);


--
-- Name: users_user_user_permissions users_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_user_permissions
    ADD CONSTRAINT users_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: users_user_user_permissions users_user_user_permissions_user_id_permission_id_43338c45_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_user_permissions
    ADD CONSTRAINT users_user_user_permissions_user_id_permission_id_43338c45_uniq UNIQUE (user_id, permission_id);


--
-- Name: users_user users_user_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user
    ADD CONSTRAINT users_user_username_key UNIQUE (username);


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

CREATE INDEX analytics_activitylog_user_id_d7739206 ON public.analytics_activitylog USING btree (user_id);


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

CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);


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

CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);


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

CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);


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

CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);


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

CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id);


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

CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);


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

CREATE INDEX django_celery_beat_periodictask_clocked_id_47a69f82 ON public.django_celery_beat_periodictask USING btree (clocked_id);


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

CREATE INDEX django_celery_beat_periodictask_crontab_id_d3cba168 ON public.django_celery_beat_periodictask USING btree (crontab_id);


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

CREATE INDEX django_celery_beat_periodictask_interval_id_a8ca27da ON public.django_celery_beat_periodictask USING btree (interval_id);


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

CREATE INDEX django_celery_beat_periodictask_name_265a36b7_like ON public.django_celery_beat_periodictask USING btree (name varchar_pattern_ops);


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

CREATE INDEX django_celery_beat_periodictask_solar_id_a87ce72c ON public.django_celery_beat_periodictask USING btree (solar_id);


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

CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);


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

CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);


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

CREATE INDEX group_expenses_groupexpense_group_id_44b7ebed ON public.group_expenses_groupexpense USING btree (group_id);


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

CREATE INDEX group_expenses_groupexpense_payer_id_b9d1dbc8 ON public.group_expenses_groupexpense USING btree (payer_id);


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

CREATE INDEX group_expenses_groupmember_group_id_84ade392 ON public.group_expenses_groupmember USING btree (group_id);


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

CREATE INDEX group_expenses_groupmember_user_id_c2976dea ON public.group_expenses_groupmember USING btree (user_id);


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

CREATE INDEX group_expenses_settlement_group_id_dd931ce9 ON public.group_expenses_settlement USING btree (group_id);


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

CREATE INDEX group_expenses_settlement_payee_id_461ad5c8 ON public.group_expenses_settlement USING btree (payee_id);


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

CREATE INDEX group_expenses_settlement_payer_id_1f1eeabb ON public.group_expenses_settlement USING btree (payer_id);


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

CREATE INDEX insights_budgetinsight_user_id_f9f6dc92 ON public.insights_budgetinsight USING btree (user_id);


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

CREATE INDEX insights_savingsgoal_user_id_6abbec33 ON public.insights_savingsgoal USING btree (user_id);


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

CREATE INDEX payments_payment_razorpay_order_id_f38fef72_like ON public.payments_payment USING btree (razorpay_order_id varchar_pattern_ops);


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

CREATE INDEX payments_payment_user_id_f9db060a ON public.payments_payment USING btree (user_id);


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

CREATE INDEX payments_subscription_user_id_1b2156fc ON public.payments_subscription USING btree (user_id);


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

CREATE INDEX token_blacklist_outstandingtoken_jti_hex_d9bdf6f7_like ON public.token_blacklist_outstandingtoken USING btree (jti varchar_pattern_ops);


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

CREATE INDEX token_blacklist_outstandingtoken_user_id_83bc629a ON public.token_blacklist_outstandingtoken USING btree (user_id);


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

CREATE INDEX transactions_transaction_user_id_b9ecc248 ON public.transactions USING btree (user_id);


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

CREATE INDEX users_user_email_243f6e77_like ON public.users_user USING btree (email varchar_pattern_ops);


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

CREATE INDEX users_user_groups_group_id_9afc8d0e ON public.users_user_groups USING btree (group_id);


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

CREATE INDEX users_user_groups_user_id_5f6f5a90 ON public.users_user_groups USING btree (user_id);


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

CREATE INDEX users_user_user_permissions_permission_id_0b93982e ON public.users_user_user_permissions USING btree (permission_id);


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

CREATE INDEX users_user_user_permissions_user_id_20aca447 ON public.users_user_user_permissions USING btree (user_id);


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

CREATE INDEX users_user_username_06e46fe6_like ON public.users_user USING btree (username varchar_pattern_ops);


--
-- Name: analytics_activitylog analytics_activitylog_user_id_d7739206_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.analytics_activitylog
    ADD CONSTRAINT analytics_activitylog_user_id_d7739206_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_user_id_c564eba6_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_celery_beat_periodictask django_celery_beat_p_clocked_id_47a69f82_fk_django_ce; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_periodictask
    ADD CONSTRAINT django_celery_beat_p_clocked_id_47a69f82_fk_django_ce FOREIGN KEY (clocked_id) REFERENCES public.django_celery_beat_clockedschedule(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_celery_beat_periodictask django_celery_beat_p_crontab_id_d3cba168_fk_django_ce; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_periodictask
    ADD CONSTRAINT django_celery_beat_p_crontab_id_d3cba168_fk_django_ce FOREIGN KEY (crontab_id) REFERENCES public.django_celery_beat_crontabschedule(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_celery_beat_periodictask django_celery_beat_p_interval_id_a8ca27da_fk_django_ce; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_periodictask
    ADD CONSTRAINT django_celery_beat_p_interval_id_a8ca27da_fk_django_ce FOREIGN KEY (interval_id) REFERENCES public.django_celery_beat_intervalschedule(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_celery_beat_periodictask django_celery_beat_p_solar_id_a87ce72c_fk_django_ce; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_celery_beat_periodictask
    ADD CONSTRAINT django_celery_beat_p_solar_id_a87ce72c_fk_django_ce FOREIGN KEY (solar_id) REFERENCES public.django_celery_beat_solarschedule(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: group_expenses_groupexpense group_expenses_group_group_id_44b7ebed_fk_group_exp; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_groupexpense
    ADD CONSTRAINT group_expenses_group_group_id_44b7ebed_fk_group_exp FOREIGN KEY (group_id) REFERENCES public.group_expenses_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: group_expenses_groupmember group_expenses_group_group_id_84ade392_fk_group_exp; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_groupmember
    ADD CONSTRAINT group_expenses_group_group_id_84ade392_fk_group_exp FOREIGN KEY (group_id) REFERENCES public.group_expenses_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: group_expenses_groupexpense group_expenses_groupexpense_payer_id_b9d1dbc8_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_groupexpense
    ADD CONSTRAINT group_expenses_groupexpense_payer_id_b9d1dbc8_fk_users_user_id FOREIGN KEY (payer_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: group_expenses_groupmember group_expenses_groupmember_user_id_c2976dea_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_groupmember
    ADD CONSTRAINT group_expenses_groupmember_user_id_c2976dea_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: group_expenses_settlement group_expenses_settl_group_id_dd931ce9_fk_group_exp; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_settlement
    ADD CONSTRAINT group_expenses_settl_group_id_dd931ce9_fk_group_exp FOREIGN KEY (group_id) REFERENCES public.group_expenses_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: group_expenses_settlement group_expenses_settlement_payee_id_461ad5c8_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_settlement
    ADD CONSTRAINT group_expenses_settlement_payee_id_461ad5c8_fk_users_user_id FOREIGN KEY (payee_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: group_expenses_settlement group_expenses_settlement_payer_id_1f1eeabb_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_expenses_settlement
    ADD CONSTRAINT group_expenses_settlement_payer_id_1f1eeabb_fk_users_user_id FOREIGN KEY (payer_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: insights_budgetinsight insights_budgetinsight_user_id_f9f6dc92_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.insights_budgetinsight
    ADD CONSTRAINT insights_budgetinsight_user_id_f9f6dc92_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: insights_savingsgoal insights_savingsgoal_user_id_6abbec33_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.insights_savingsgoal
    ADD CONSTRAINT insights_savingsgoal_user_id_6abbec33_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: payments_payment payments_payment_user_id_f9db060a_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payments_payment
    ADD CONSTRAINT payments_payment_user_id_f9db060a_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: payments_subscription payments_subscription_user_id_1b2156fc_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.payments_subscription
    ADD CONSTRAINT payments_subscription_user_id_1b2156fc_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: token_blacklist_blacklistedtoken token_blacklist_blacklistedtoken_token_id_3cc7fe56_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.token_blacklist_blacklistedtoken
    ADD CONSTRAINT token_blacklist_blacklistedtoken_token_id_3cc7fe56_fk FOREIGN KEY (token_id) REFERENCES public.token_blacklist_outstandingtoken(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: token_blacklist_outstandingtoken token_blacklist_outs_user_id_83bc629a_fk_users_use; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.token_blacklist_outstandingtoken
    ADD CONSTRAINT token_blacklist_outs_user_id_83bc629a_fk_users_use FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: user_budget transactions_budget_user_id_f9ddc59a_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_budget
    ADD CONSTRAINT transactions_budget_user_id_f9ddc59a_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: expense_categories transactions_category_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.expense_categories
    ADD CONSTRAINT transactions_category_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users_user(id) ON DELETE CASCADE;


--
-- Name: transactions transactions_transaction_category_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_transaction_category_id_fk FOREIGN KEY (category_id) REFERENCES public.expense_categories(id) ON DELETE SET NULL;


--
-- Name: transactions transactions_transaction_user_id_b9ecc248_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT transactions_transaction_user_id_b9ecc248_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: users_user_groups users_user_groups_group_id_9afc8d0e_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_groups
    ADD CONSTRAINT users_user_groups_group_id_9afc8d0e_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: users_user_groups users_user_groups_user_id_5f6f5a90_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_groups
    ADD CONSTRAINT users_user_groups_user_id_5f6f5a90_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: users_user_user_permissions users_user_user_perm_permission_id_0b93982e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_user_permissions
    ADD CONSTRAINT users_user_user_perm_permission_id_0b93982e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: users_user_user_permissions users_user_user_permissions_user_id_20aca447_fk_users_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_user_permissions
    ADD CONSTRAINT users_user_user_permissions_user_id_20aca447_fk_users_user_id FOREIGN KEY (user_id) REFERENCES public.users_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- PostgreSQL database dump complete
--