backup.sql

--
-- PostgreSQL database dump
--

\restrict palVs49ZeXZ1Ae1ed3qJRWURA84t7uRpAUeFKlFnZxOFJsrMSJd6nXjoMKOEcQs

-- Dumped from database version 15.14 (Debian 15.14-1.pgdg13+1)
-- Dumped by pg_dump version 15.14 (Debian 15.14-1.pgdg13+1)

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: academics_course; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.academics_course (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    description text NOT NULL,
    created timestamp with time zone NOT NULL,
    teacher_id integer,
    start_date date,
    end_date date
);


ALTER TABLE public.academics_course OWNER TO scms_admin;

--
-- Name: academics_course_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: academics_enrollment; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.academics_enrollment (
    id bigint NOT NULL,
    enrolled_at timestamp with time zone NOT NULL,
    course_id bigint NOT NULL,
    student_id integer NOT NULL,
    completed boolean DEFAULT false NOT NULL,
    completed_at timestamp with time zone
);


ALTER TABLE public.academics_enrollment OWNER TO scms_admin;

--
-- Name: academics_enrollment_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: academics_lesson; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.academics_lesson (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    content text NOT NULL,
    "position" smallint,
    is_done boolean NOT NULL,
    created timestamp with time zone NOT NULL,
    course_id bigint NOT NULL,
    scheduled_date date,
    CONSTRAINT academics_lesson_position_check CHECK (("position" >= 0))
);


ALTER TABLE public.academics_lesson OWNER TO scms_admin;

--
-- Name: academics_lesson_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: academics_lessonchecklistitem; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.academics_lessonchecklistitem (
    id bigint NOT NULL,
    text character varying(255) NOT NULL,
    completed boolean NOT NULL,
    "position" smallint,
    lesson_id bigint NOT NULL,
    CONSTRAINT academics_lessonchecklistitem_position_check CHECK (("position" >= 0))
);


ALTER TABLE public.academics_lessonchecklistitem OWNER TO scms_admin;

--
-- Name: academics_lessonchecklistitem_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: academics_lessonprogress; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.academics_lessonprogress (
    id integer NOT NULL,
    completed boolean DEFAULT false NOT NULL,
    completed_at timestamp with time zone,
    last_accessed timestamp with time zone DEFAULT now() NOT NULL,
    student_id integer NOT NULL,
    lesson_id integer NOT NULL
);


ALTER TABLE public.academics_lessonprogress OWNER TO scms_admin;

--
-- Name: academics_lessonprogress_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


ALTER TABLE public.academics_lessonprogress_id_seq OWNER TO scms_admin;

--
-- Name: academics_lessonprogress_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: scms_admin
--

ALTER SEQUENCE public.academics_lessonprogress_id_seq OWNED BY public.academics_lessonprogress.id;


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

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


ALTER TABLE public.auth_group OWNER TO scms_admin;

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

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: scms_admin
--

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 scms_admin;

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

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: scms_admin
--

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 scms_admin;

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

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: auth_user; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.auth_user (
    id integer NOT NULL,
    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,
    email character varying(254) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE public.auth_user OWNER TO scms_admin;

--
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: scms_admin
--

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


ALTER TABLE public.auth_user_groups OWNER TO scms_admin;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: scms_admin
--

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


ALTER TABLE public.auth_user_user_permissions OWNER TO scms_admin;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


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

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 integer NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO scms_admin;

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

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: scms_admin
--

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 scms_admin;

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

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: scms_admin
--

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 scms_admin;

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

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: scms_admin
--

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 scms_admin;

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

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: scms_admin
--

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 scms_admin;

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

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: scms_admin
--

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 scms_admin;

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

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 scms_admin;

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

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: scms_admin
--

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 scms_admin;

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

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: scms_admin
--

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 scms_admin;

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

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: scms_admin
--

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 scms_admin;

--
-- Name: notifications_notificationdelivery; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.notifications_notificationdelivery (
    id bigint NOT NULL,
    channel character varying(10) NOT NULL,
    status character varying(10) NOT NULL,
    message text NOT NULL,
    sent_at timestamp with time zone,
    error text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    recipient_id integer NOT NULL,
    schedule_id bigint NOT NULL
);


ALTER TABLE public.notifications_notificationdelivery OWNER TO scms_admin;

--
-- Name: notifications_notificationdelivery_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: notifications_notificationpreference; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.notifications_notificationpreference (
    id bigint NOT NULL,
    email_enabled boolean NOT NULL,
    in_app_enabled boolean NOT NULL,
    push_enabled boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.notifications_notificationpreference OWNER TO scms_admin;

--
-- Name: notifications_notificationpreference_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: notifications_notificationschedule; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.notifications_notificationschedule (
    id bigint NOT NULL,
    object_id integer NOT NULL,
    scheduled_for timestamp with time zone NOT NULL,
    context jsonb NOT NULL,
    channels jsonb NOT NULL,
    sent boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    content_type_id integer NOT NULL,
    template_id bigint NOT NULL,
    CONSTRAINT notifications_notificationschedule_object_id_check CHECK ((object_id >= 0))
);


ALTER TABLE public.notifications_notificationschedule OWNER TO scms_admin;

--
-- Name: notifications_notificationschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: notifications_notificationschedule_recipients; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.notifications_notificationschedule_recipients (
    id bigint NOT NULL,
    notificationschedule_id bigint NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.notifications_notificationschedule_recipients OWNER TO scms_admin;

--
-- Name: notifications_notificationschedule_recipients_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: notifications_notificationtemplate; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.notifications_notificationtemplate (
    id bigint NOT NULL,
    name character varying(100) NOT NULL,
    subject character varying(200) NOT NULL,
    body text NOT NULL,
    channels jsonb NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);


ALTER TABLE public.notifications_notificationtemplate OWNER TO scms_admin;

--
-- Name: notifications_notificationtemplate_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: timetable_classsession; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.timetable_classsession (
    id bigint NOT NULL,
    title character varying(200) NOT NULL,
    start_at timestamp with time zone NOT NULL,
    duration_minutes integer NOT NULL,
    notify_before_minutes integer NOT NULL,
    active boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    course_id bigint NOT NULL,
    lesson_id bigint,
    CONSTRAINT timetable_classsession_duration_minutes_check CHECK ((duration_minutes >= 0)),
    CONSTRAINT timetable_classsession_notify_before_minutes_check CHECK ((notify_before_minutes >= 0))
);


ALTER TABLE public.timetable_classsession OWNER TO scms_admin;

--
-- Name: timetable_classsession_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: timetable_timetable; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.timetable_timetable (
    id bigint NOT NULL,
    day_of_week character varying(10) NOT NULL,
    start_time time without time zone NOT NULL,
    end_time time without time zone NOT NULL,
    location character varying(255) NOT NULL,
    notes text NOT NULL,
    is_active boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    course_id bigint NOT NULL,
    lesson_id bigint,
    teacher_id integer NOT NULL
);


ALTER TABLE public.timetable_timetable OWNER TO scms_admin;

--
-- Name: timetable_timetable_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: timetable_timetablenotification; Type: TABLE; Schema: public; Owner: scms_admin
--

CREATE TABLE public.timetable_timetablenotification (
    id bigint NOT NULL,
    notification_type character varying(20) NOT NULL,
    message text NOT NULL,
    send_to_students boolean NOT NULL,
    send_to_teachers boolean NOT NULL,
    sent_at timestamp with time zone,
    is_sent boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    timetable_entry_id bigint NOT NULL
);


ALTER TABLE public.timetable_timetablenotification OWNER TO scms_admin;

--
-- Name: timetable_timetablenotification_id_seq; Type: SEQUENCE; Schema: public; Owner: scms_admin
--

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


--
-- Name: academics_lessonprogress id; Type: DEFAULT; Schema: public; Owner: scms_admin
--

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


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

COPY public.academics_course (id, title, description, created, teacher_id, start_date, end_date) FROM stdin;
1	Introduction to Computer Science	Fundamentals of computing, algorithms and problem solving.	2025-10-13 16:49:44.001434+00	\N	\N	\N
2	Programming in Python	Core Python language features and practical programming.	2025-10-13 16:49:44.064998+00	\N	\N	\N
3	Data Structures & Algorithms	Common data structures and algorithm design techniques.	2025-10-13 16:49:44.071344+00	\N	\N	\N
5	Web Development with Django	Build web apps with Django: models, views, templates and auth.	2025-10-13 16:49:44.078263+00	\N	\N	\N
6	Operating Systems & Networking	Intro to OS concepts and fundamental networking principles.	2025-10-13 16:49:44.080938+00	\N	\N	\N
7	Software Engineering Practices	Design, testing and team practices for reliable software.	2025-10-13 16:49:44.083842+00	\N	\N	\N
8	Microeconomics	Foundations of microeconomics: consumers, firms and markets.	2025-10-13 16:49:44.086577+00	\N	\N	\N
9	Macroeconomics	Aggregate economy: GDP, inflation, unemployment and policy.	2025-10-13 16:49:44.089183+00	\N	\N	\N
10	Intro to Econometrics	Basics of data analysis and causal inference in economics.	2025-10-13 16:49:44.091784+00	\N	2025-11-01	2025-11-30
4	Databases & SQL	Relational databases, SQL and basic database design.	2025-10-13 16:49:44.075639+00	\N	2025-11-01	2025-11-30
11	test		2025-12-01 15:24:12.113025+00	\N	\N	\N
\.


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

COPY public.academics_enrollment (id, enrolled_at, course_id, student_id, completed, completed_at) FROM stdin;
\.


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

COPY public.academics_lesson (id, title, content, "position", is_done, created, course_id, scheduled_date) FROM stdin;
1	What is Computer Science?	Lesson: What is Computer Science?\n\nIntroduction to Computer Science - detailed content.	1	f	2025-10-13 16:49:44.034032+00	1	\N
2	Algorithms & Pseudocode	Lesson: Algorithms & Pseudocode\n\nIntroduction to Computer Science - detailed content.	2	f	2025-10-13 16:49:44.057382+00	1	\N
3	Basic Data Types	Lesson: Basic Data Types\n\nIntroduction to Computer Science - detailed content.	3	f	2025-10-13 16:49:44.058504+00	1	\N
4	Control Flow	Lesson: Control Flow\n\nIntroduction to Computer Science - detailed content.	4	f	2025-10-13 16:49:44.059448+00	1	\N
5	Functions and Procedures	Lesson: Functions and Procedures\n\nIntroduction to Computer Science - detailed content.	5	f	2025-10-13 16:49:44.060305+00	1	\N
6	Basic Data Structures	Lesson: Basic Data Structures\n\nIntroduction to Computer Science - detailed content.	6	f	2025-10-13 16:49:44.061042+00	1	\N
7	Complexity & Big-O	Lesson: Complexity & Big-O\n\nIntroduction to Computer Science - detailed content.	7	f	2025-10-13 16:49:44.061815+00	1	\N
8	Debugging Techniques	Lesson: Debugging Techniques\n\nIntroduction to Computer Science - detailed content.	8	f	2025-10-13 16:49:44.062541+00	1	\N
9	Version Control (git)	Lesson: Version Control (git)\n\nIntroduction to Computer Science - detailed content.	9	f	2025-10-13 16:49:44.063323+00	1	\N
10	Next Steps & Resources	Lesson: Next Steps & Resources\n\nIntroduction to Computer Science - detailed content.	10	f	2025-10-13 16:49:44.064217+00	1	\N
11	Python setup & REPL	Lesson: Python setup & REPL\n\nProgramming in Python - detailed content.	1	f	2025-10-13 16:49:44.065724+00	2	\N
12	Variables and Types	Lesson: Variables and Types\n\nProgramming in Python - detailed content.	2	f	2025-10-13 16:49:44.06642+00	2	\N
13	Control Flow in Python	Lesson: Control Flow in Python\n\nProgramming in Python - detailed content.	3	f	2025-10-13 16:49:44.067064+00	2	\N
14	Functions and Modules	Lesson: Functions and Modules\n\nProgramming in Python - detailed content.	4	f	2025-10-13 16:49:44.067694+00	2	\N
15	Data Structures: lists & tuples	Lesson: Data Structures: lists & tuples\n\nProgramming in Python - detailed content.	5	f	2025-10-13 16:49:44.068289+00	2	\N
16	Dictionaries & Sets	Lesson: Dictionaries & Sets\n\nProgramming in Python - detailed content.	6	f	2025-10-13 16:49:44.068747+00	2	\N
17	File I/O	Lesson: File I/O\n\nProgramming in Python - detailed content.	7	f	2025-10-13 16:49:44.069542+00	2	\N
18	Error Handling	Lesson: Error Handling\n\nProgramming in Python - detailed content.	8	f	2025-10-13 16:49:44.070029+00	2	\N
19	Iterators & Generators	Lesson: Iterators & Generators\n\nProgramming in Python - detailed content.	9	f	2025-10-13 16:49:44.070482+00	2	\N
20	Virtualenv & Packaging	Lesson: Virtualenv & Packaging\n\nProgramming in Python - detailed content.	10	f	2025-10-13 16:49:44.070934+00	2	\N
22	Stacks and Queues	Lesson: Stacks and Queues\n\nData Structures & Algorithms - detailed content.	2	f	2025-10-13 16:49:44.072313+00	3	\N
23	Trees and Binary Trees	Lesson: Trees and Binary Trees\n\nData Structures & Algorithms - detailed content.	3	f	2025-10-13 16:49:44.072819+00	3	\N
24	Graphs Basics	Lesson: Graphs Basics\n\nData Structures & Algorithms - detailed content.	4	f	2025-10-13 16:49:44.073268+00	3	\N
25	Searching & Sorting	Lesson: Searching & Sorting\n\nData Structures & Algorithms - detailed content.	5	f	2025-10-13 16:49:44.073834+00	3	\N
26	Hashing and Dictionaries	Lesson: Hashing and Dictionaries\n\nData Structures & Algorithms - detailed content.	6	f	2025-10-13 16:49:44.074279+00	3	\N
27	Recursion & Divide & Conquer	Lesson: Recursion & Divide & Conquer\n\nData Structures & Algorithms - detailed content.	7	f	2025-10-13 16:49:44.074541+00	3	\N
28	Greedy Algorithms	Lesson: Greedy Algorithms\n\nData Structures & Algorithms - detailed content.	8	f	2025-10-13 16:49:44.074791+00	3	\N
29	Dynamic Programming	Lesson: Dynamic Programming\n\nData Structures & Algorithms - detailed content.	9	f	2025-10-13 16:49:44.075062+00	3	\N
30	Algorithm Analysis	Lesson: Algorithm Analysis\n\nData Structures & Algorithms - detailed content.	10	f	2025-10-13 16:49:44.075359+00	3	\N
42	Models and Migrations	Lesson: Models and Migrations\n\nWeb Development with Django - detailed content.	2	f	2025-10-13 16:49:44.078751+00	5	\N
43	Admin Customisation	Lesson: Admin Customisation\n\nWeb Development with Django - detailed content.	3	f	2025-10-13 16:49:44.079014+00	5	\N
44	Views and URL routing	Lesson: Views and URL routing\n\nWeb Development with Django - detailed content.	4	f	2025-10-13 16:49:44.07927+00	5	\N
45	Templates and static files	Lesson: Templates and static files\n\nWeb Development with Django - detailed content.	5	f	2025-10-13 16:49:44.079522+00	5	\N
46	Forms and validation	Lesson: Forms and validation\n\nWeb Development with Django - detailed content.	6	f	2025-10-13 16:49:44.079758+00	5	\N
47	Authentication & Permissions	Lesson: Authentication & Permissions\n\nWeb Development with Django - detailed content.	7	f	2025-10-13 16:49:44.079991+00	5	\N
48	File uploads	Lesson: File uploads\n\nWeb Development with Django - detailed content.	8	f	2025-10-13 16:49:44.080226+00	5	\N
49	Testing Django apps	Lesson: Testing Django apps\n\nWeb Development with Django - detailed content.	9	f	2025-10-13 16:49:44.080473+00	5	\N
50	Deployment basics	Lesson: Deployment basics\n\nWeb Development with Django - detailed content.	10	f	2025-10-13 16:49:44.080713+00	5	\N
51	Processes and Threads	Lesson: Processes and Threads\n\nOperating Systems & Networking - detailed content.	1	f	2025-10-13 16:49:44.081167+00	6	\N
52	Memory Management	Lesson: Memory Management\n\nOperating Systems & Networking - detailed content.	2	f	2025-10-13 16:49:44.081427+00	6	\N
41	Django project setup	Lesson: Django project setup\n\nWeb Development with Django - detailed content.	1	t	2025-10-13 16:49:44.078499+00	5	\N
21	Arrays and Linked Lists	Lesson: Arrays and Linked Lists\n\nData Structures & Algorithms - detailed content.	1	t	2025-10-13 16:49:44.07167+00	3	\N
53	File Systems	Lesson: File Systems\n\nOperating Systems & Networking - detailed content.	3	f	2025-10-13 16:49:44.081687+00	6	\N
54	I/O and Drivers	Lesson: I/O and Drivers\n\nOperating Systems & Networking - detailed content.	4	f	2025-10-13 16:49:44.082104+00	6	\N
55	Concurrency basics	Lesson: Concurrency basics\n\nOperating Systems & Networking - detailed content.	5	f	2025-10-13 16:49:44.082396+00	6	\N
56	Networking models (OSI/TCP/IP)	Lesson: Networking models (OSI/TCP/IP)\n\nOperating Systems & Networking - detailed content.	6	f	2025-10-13 16:49:44.082652+00	6	\N
57	Sockets and TCP/UDP	Lesson: Sockets and TCP/UDP\n\nOperating Systems & Networking - detailed content.	7	f	2025-10-13 16:49:44.082902+00	6	\N
58	Network troubleshooting	Lesson: Network troubleshooting\n\nOperating Systems & Networking - detailed content.	8	f	2025-10-13 16:49:44.083146+00	6	\N
59	Security basics	Lesson: Security basics\n\nOperating Systems & Networking - detailed content.	9	f	2025-10-13 16:49:44.083383+00	6	\N
60	System monitoring	Lesson: System monitoring\n\nOperating Systems & Networking - detailed content.	10	f	2025-10-13 16:49:44.083618+00	6	\N
61	Software development lifecycle	Lesson: Software development lifecycle\n\nSoftware Engineering Practices - detailed content.	1	f	2025-10-13 16:49:44.084086+00	7	\N
62	Design patterns overview	Lesson: Design patterns overview\n\nSoftware Engineering Practices - detailed content.	2	f	2025-10-13 16:49:44.084337+00	7	\N
63	Modular design	Lesson: Modular design\n\nSoftware Engineering Practices - detailed content.	3	f	2025-10-13 16:49:44.084578+00	7	\N
64	Unit testing	Lesson: Unit testing\n\nSoftware Engineering Practices - detailed content.	4	f	2025-10-13 16:49:44.084813+00	7	\N
65	Integration testing	Lesson: Integration testing\n\nSoftware Engineering Practices - detailed content.	5	f	2025-10-13 16:49:44.085088+00	7	\N
66	CI/CD basics	Lesson: CI/CD basics\n\nSoftware Engineering Practices - detailed content.	6	f	2025-10-13 16:49:44.085334+00	7	\N
67	Code review best practices	Lesson: Code review best practices\n\nSoftware Engineering Practices - detailed content.	7	f	2025-10-13 16:49:44.085622+00	7	\N
68	Documentation	Lesson: Documentation\n\nSoftware Engineering Practices - detailed content.	8	f	2025-10-13 16:49:44.085878+00	7	\N
69	Project management basics	Lesson: Project management basics\n\nSoftware Engineering Practices - detailed content.	9	f	2025-10-13 16:49:44.086118+00	7	\N
70	Maintenance and refactoring	Lesson: Maintenance and refactoring\n\nSoftware Engineering Practices - detailed content.	10	f	2025-10-13 16:49:44.086352+00	7	\N
71	Supply and Demand	Lesson: Supply and Demand\n\nMicroeconomics - detailed content.	1	f	2025-10-13 16:49:44.086804+00	8	\N
72	Elasticity	Lesson: Elasticity\n\nMicroeconomics - detailed content.	2	f	2025-10-13 16:49:44.087045+00	8	\N
73	Consumer Choice	Lesson: Consumer Choice\n\nMicroeconomics - detailed content.	3	f	2025-10-13 16:49:44.087287+00	8	\N
74	Production & Costs	Lesson: Production & Costs\n\nMicroeconomics - detailed content.	4	f	2025-10-13 16:49:44.087525+00	8	\N
75	Perfect Competition	Lesson: Perfect Competition\n\nMicroeconomics - detailed content.	5	f	2025-10-13 16:49:44.08776+00	8	\N
76	Monopoly & Market Power	Lesson: Monopoly & Market Power\n\nMicroeconomics - detailed content.	6	f	2025-10-13 16:49:44.087996+00	8	\N
77	Oligopoly basics	Lesson: Oligopoly basics\n\nMicroeconomics - detailed content.	7	f	2025-10-13 16:49:44.08823+00	8	\N
78	Market Failures	Lesson: Market Failures\n\nMicroeconomics - detailed content.	8	f	2025-10-13 16:49:44.088471+00	8	\N
79	Externalities	Lesson: Externalities\n\nMicroeconomics - detailed content.	9	f	2025-10-13 16:49:44.08872+00	8	\N
80	Public Policy & Regulation	Lesson: Public Policy & Regulation\n\nMicroeconomics - detailed content.	10	f	2025-10-13 16:49:44.08896+00	8	\N
95	Hypothesis testing	Lesson: Hypothesis testing\n\nIntro to Econometrics - detailed content.	4	f	2025-10-13 16:49:44.093005+00	10	\N
91	Data types & sources	Lesson: Data types & sources\n\nIntro to Econometrics - detailed content.	0	t	2025-10-13 16:49:44.092023+00	10	2025-11-01
81	Measuring the Economy (GDP)	Lesson: Measuring the Economy (GDP)\n\nMacroeconomics - detailed content.	0	f	2025-10-13 16:49:44.089425+00	9	\N
82	Unemployment & Labor Markets	Lesson: Unemployment & Labor Markets\n\nMacroeconomics - detailed content.	1	f	2025-10-13 16:49:44.089679+00	9	\N
83	Inflation & Price Indexes	Lesson: Inflation & Price Indexes\n\nMacroeconomics - detailed content.	2	f	2025-10-13 16:49:44.089913+00	9	\N
84	Aggregate Demand & Supply	Lesson: Aggregate Demand & Supply\n\nMacroeconomics - detailed content.	3	f	2025-10-13 16:49:44.090153+00	9	\N
85	Fiscal Policy	Lesson: Fiscal Policy\n\nMacroeconomics - detailed content.	4	f	2025-10-13 16:49:44.090389+00	9	\N
92	Statistical foundations	Lesson: Statistical foundations\n\nIntro to Econometrics - detailed content.	1	f	2025-10-13 16:49:44.092279+00	10	\N
93	Simple linear regression	Lesson: Simple linear regression\n\nIntro to Econometrics - detailed content.	2	f	2025-10-13 16:49:44.092526+00	10	\N
94	Multiple regression	Lesson: Multiple regression\n\nIntro to Econometrics - detailed content.	3	f	2025-10-13 16:49:44.092763+00	10	\N
96	Model specification	Lesson: Model specification\n\nIntro to Econometrics - detailed content.	5	f	2025-10-13 16:49:44.093354+00	10	\N
97	Heteroskedasticity & remedies	Lesson: Heteroskedasticity & remedies\n\nIntro to Econometrics - detailed content.	6	f	2025-10-13 16:49:44.093662+00	10	\N
98	Instrumental variables (intro)	Lesson: Instrumental variables (intro)\n\nIntro to Econometrics - detailed content.	7	f	2025-10-13 16:49:44.093914+00	10	\N
99	Panel data basics	Lesson: Panel data basics\n\nIntro to Econometrics - detailed content.	8	f	2025-10-13 16:49:44.094155+00	10	\N
100	Interpreting results	Lesson: Interpreting results\n\nIntro to Econometrics - detailed content.	9	f	2025-10-13 16:49:44.094453+00	10	\N
86	Monetary Policy	Lesson: Monetary Policy\n\nMacroeconomics - detailed content.	5	f	2025-10-13 16:49:44.090624+00	9	\N
87	Economic Growth	Lesson: Economic Growth\n\nMacroeconomics - detailed content.	6	f	2025-10-13 16:49:44.090858+00	9	\N
88	Business Cycles	Lesson: Business Cycles\n\nMacroeconomics - detailed content.	7	f	2025-10-13 16:49:44.09109+00	9	\N
89	Open Economy / Exchange Rates	Lesson: Open Economy / Exchange Rates\n\nMacroeconomics - detailed content.	8	f	2025-10-13 16:49:44.091319+00	9	\N
90	Policy Tradeoffs	Lesson: Policy Tradeoffs\n\nMacroeconomics - detailed content.	9	f	2025-10-13 16:49:44.091562+00	9	\N
33	Filtering and Sorting	Lesson: Filtering and Sorting\n\nDatabases & SQL - detailed content.	2	f	2025-10-13 16:49:44.076363+00	4	\N
34	JOINs	Lesson: JOINs\n\nDatabases & SQL - detailed content.	3	f	2025-10-13 16:49:44.076597+00	4	\N
35	Aggregations & GROUP BY	Lesson: Aggregations & GROUP BY\n\nDatabases & SQL - detailed content.	4	f	2025-10-13 16:49:44.076838+00	4	\N
36	Indexes and Performance	Lesson: Indexes and Performance\n\nDatabases & SQL - detailed content.	5	f	2025-10-13 16:49:44.077072+00	4	\N
37	Transactions & Concurrency	Lesson: Transactions & Concurrency\n\nDatabases & SQL - detailed content.	6	f	2025-10-13 16:49:44.077313+00	4	\N
38	Schema Design	Lesson: Schema Design\n\nDatabases & SQL - detailed content.	7	f	2025-10-13 16:49:44.077569+00	4	\N
39	ORM Basics	Lesson: ORM Basics\n\nDatabases & SQL - detailed content.	8	f	2025-10-13 16:49:44.077807+00	4	\N
40	Backups & Migrations	Lesson: Backups & Migrations\n\nDatabases & SQL - detailed content.	9	f	2025-10-13 16:49:44.078041+00	4	\N
31	Introduction to Databases	Lesson: Introduction to Databases\n\nDatabases & SQL - detailed content.	0	f	2025-10-13 16:49:44.075881+00	4	2025-11-01
32	Basic SELECT queries	Lesson: Basic SELECT queries\n\nDatabases & SQL - detailed content.	1	f	2025-10-13 16:49:44.076125+00	4	2025-11-02
\.


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

COPY public.academics_lessonchecklistitem (id, text, completed, "position", lesson_id) FROM stdin;
3	Complete assignment	t	\N	92
1	Complete assignment	t	\N	1
4	Complete assignment	t	\N	41
2	Complete assignment	t	\N	21
\.


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

COPY public.academics_lessonprogress (id, completed, completed_at, last_accessed, student_id, lesson_id) FROM stdin;
\.


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

COPY public.auth_group (id, name) FROM stdin;
3	Teachers
4	Students
\.


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

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


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

COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add content type	1	add_contenttype
2	Can change content type	1	change_contenttype
3	Can delete content type	1	delete_contenttype
4	Can view content type	1	view_contenttype
5	Can add log entry	2	add_logentry
6	Can change log entry	2	change_logentry
7	Can delete log entry	2	delete_logentry
8	Can view log entry	2	view_logentry
9	Can add permission	3	add_permission
10	Can change permission	3	change_permission
11	Can delete permission	3	delete_permission
12	Can view permission	3	view_permission
13	Can add group	4	add_group
14	Can change group	4	change_group
15	Can delete group	4	delete_group
16	Can view group	4	view_group
17	Can add user	5	add_user
18	Can change user	5	change_user
19	Can delete user	5	delete_user
20	Can view user	5	view_user
21	Can add session	6	add_session
22	Can change session	6	change_session
23	Can delete session	6	delete_session
24	Can view session	6	view_session
25	Can add course	7	add_course
26	Can change course	7	change_course
27	Can delete course	7	delete_course
28	Can view course	7	view_course
29	Can add lesson	8	add_lesson
30	Can change lesson	8	change_lesson
31	Can delete lesson	8	delete_lesson
32	Can view lesson	8	view_lesson
33	Can add lesson checklist item	9	add_lessonchecklistitem
34	Can change lesson checklist item	9	change_lessonchecklistitem
35	Can delete lesson checklist item	9	delete_lessonchecklistitem
36	Can view lesson checklist item	9	view_lessonchecklistitem
37	Can add enrollment	10	add_enrollment
38	Can change enrollment	10	change_enrollment
39	Can delete enrollment	10	delete_enrollment
40	Can view enrollment	10	view_enrollment
41	Can add Teacher Assignment	11	add_teacherassignedproxy
42	Can change Teacher Assignment	11	change_teacherassignedproxy
43	Can delete Teacher Assignment	11	delete_teacherassignedproxy
44	Can view Teacher Assignment	11	view_teacherassignedproxy
45	Can add Student Enrollment	12	add_enrollmentadminproxy
46	Can change Student Enrollment	12	change_enrollmentadminproxy
47	Can delete Student Enrollment	12	delete_enrollmentadminproxy
48	Can view Student Enrollment	12	view_enrollmentadminproxy
49	Can add Lesson Progress	13	add_lessonprogress
50	Can change Lesson Progress	13	change_lessonprogress
51	Can delete Lesson Progress	13	delete_lessonprogress
52	Can view Lesson Progress	13	view_lessonprogress
53	Can add Timetable Notification	14	add_timetablenotification
54	Can change Timetable Notification	14	change_timetablenotification
55	Can delete Timetable Notification	14	delete_timetablenotification
56	Can view Timetable Notification	14	view_timetablenotification
57	Can add Time Table Entry	15	add_timetable
58	Can change Time Table Entry	15	change_timetable
59	Can delete Time Table Entry	15	delete_timetable
60	Can view Time Table Entry	15	view_timetable
61	Can add crontab	16	add_crontabschedule
62	Can change crontab	16	change_crontabschedule
63	Can delete crontab	16	delete_crontabschedule
64	Can view crontab	16	view_crontabschedule
65	Can add interval	17	add_intervalschedule
66	Can change interval	17	change_intervalschedule
67	Can delete interval	17	delete_intervalschedule
68	Can view interval	17	view_intervalschedule
69	Can add periodic task	18	add_periodictask
70	Can change periodic task	18	change_periodictask
71	Can delete periodic task	18	delete_periodictask
72	Can view periodic task	18	view_periodictask
73	Can add periodic task track	19	add_periodictasks
74	Can change periodic task track	19	change_periodictasks
75	Can delete periodic task track	19	delete_periodictasks
76	Can view periodic task track	19	view_periodictasks
77	Can add solar event	20	add_solarschedule
78	Can change solar event	20	change_solarschedule
79	Can delete solar event	20	delete_solarschedule
80	Can view solar event	20	view_solarschedule
81	Can add clocked	21	add_clockedschedule
82	Can change clocked	21	change_clockedschedule
83	Can delete clocked	21	delete_clockedschedule
84	Can view clocked	21	view_clockedschedule
85	Can add Class Session	22	add_classsession
86	Can change Class Session	22	change_classsession
87	Can delete Class Session	22	delete_classsession
88	Can view Class Session	22	view_classsession
89	Can add notification template	23	add_notificationtemplate
90	Can change notification template	23	change_notificationtemplate
91	Can delete notification template	23	delete_notificationtemplate
92	Can view notification template	23	view_notificationtemplate
93	Can add notification schedule	24	add_notificationschedule
94	Can change notification schedule	24	change_notificationschedule
95	Can delete notification schedule	24	delete_notificationschedule
96	Can view notification schedule	24	view_notificationschedule
97	Can add notification preference	25	add_notificationpreference
98	Can change notification preference	25	change_notificationpreference
99	Can delete notification preference	25	delete_notificationpreference
100	Can view notification preference	25	view_notificationpreference
101	Can add notification delivery	26	add_notificationdelivery
102	Can change notification delivery	26	change_notificationdelivery
103	Can delete notification delivery	26	delete_notificationdelivery
104	Can view notification delivery	26	view_notificationdelivery
\.


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

COPY public.auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) FROM stdin;
114	pbkdf2_sha256$600000$2MHPHlDBOQDypRBFmUXRrf$6fxNGPLWJA668y7wplw8hNB0AMDulDOflAekSd+cJU0=	\N	f	keyadash	Keya	Dash	keyadash@sample.org	t	t	2025-12-01 11:34:06.495849+00
115	pbkdf2_sha256$600000$w58u8NxB0GWcDplAJZHeoA$1HbFmN6dtdAaZtQHYbkezp1DP50EweKhcHcH7azVaK0=	\N	f	ranbirkota	Ranbir	Kota	ranbirkota@demo.edu	t	t	2025-12-01 11:34:06.836436+00
116	pbkdf2_sha256$600000$0S5naRPpXiJUUjwefYQ4hs$45IdiwGMM26BINlupc9jwFwRbxbUAO6ltB5vL5qWTjE=	\N	f	ojaschander	Ojas	Chander	ojaschander@demo.edu	t	t	2025-12-01 11:34:07.054259+00
117	pbkdf2_sha256$600000$n8DcYxSTcRTdOcjCUo5ibM$qNnFhgoBEDjDWTunk4jnrTlagT55YrClWinPn8JFuwA=	\N	f	aarnavarughese	Aarna	Varughese	aarnavarughese@demo.edu	t	t	2025-12-01 11:34:07.27193+00
118	pbkdf2_sha256$600000$GoT3gmaqrFTpNOGB2LPwvv$MLrTz+LBNP7Ac/9l40yfuF0cj+BXVtaXgbhcrFr8YgA=	\N	f	deepagaba	Deepa	Gaba	deepagaba@sample.org	t	t	2025-12-01 11:34:07.501859+00
119	pbkdf2_sha256$600000$GL98y2vDnRrSi6ymrR0MgC$OErmywqkNj+PQ7/zNeMg36E9MnKodTLdv6rn2xwcY6g=	\N	f	lavanyagoda	Lavanya	Goda	lavanyagoda@demo.edu	t	t	2025-12-01 11:34:07.72003+00
120	pbkdf2_sha256$600000$qvqQuiZgrOJHtbIqG674pc$aSyIhG7rpcRRzTX/R4UQdk+vK/jL11QgGzRTX0d8uUo=	\N	f	avideshmukh	Avi	Deshmukh	avideshmukh@example.com	t	t	2025-12-01 11:34:07.938649+00
121	pbkdf2_sha256$600000$zt6Ni8pxpilN6WHgIw6G0D$XLURm7DQuv1WJNpdBr+NUlb+Bf7se1tcIgz0WMS/ZBQ=	\N	f	charleschokshi	Charles	Chokshi	charleschokshi@test.local	t	t	2025-12-01 11:34:08.157271+00
122	pbkdf2_sha256$600000$rmCeEtRVLHWY0m95XzFZ4z$qUAOqJHSKVLpIxckHHtTpOHwmSFbdt/SkUWTr5SGIfw=	\N	f	alexandernatarajan	Alexander	Natarajan	alexandernatarajan@demo.edu	t	t	2025-12-01 11:34:08.386508+00
123	pbkdf2_sha256$600000$QfZztVLMHWWypnhzlwApLV$HE3Rp7hOKNz2GMtmSBRkwrIHTNwTmnVOF0Qbbt9I2vE=	\N	f	mitaliravel	Mitali	Ravel	mitaliravel@sample.org	t	t	2025-12-01 11:34:08.638748+00
124	pbkdf2_sha256$600000$MPz80lVzNIfc2VId4y0gO7$lHZpw1fwaf/bU8Phehff8sa3MfpiZVX7xi11VzVHDrU=	\N	f	abhaghosh	Abha	Ghosh	abhaghosh@demo.edu	f	t	2025-12-01 11:34:08.856864+00
125	pbkdf2_sha256$600000$sVPewZe1nLSIlY6TCNdUgY$ScN19NrrjLubDoqvgb++NWFdnLgKQiaogZWkUDLcHhY=	\N	f	triptigaba	Tripti	Gaba	triptigaba@demo.edu	f	t	2025-12-01 11:34:09.085646+00
126	pbkdf2_sha256$600000$vozAhQgLsWsGuHj6r8Ozwe$W4YLAg5shVNGz3HDrkvSyaTVPZlxWONQuqkUkGJnt98=	\N	f	darikakapur	Darika	Kapur	darikakapur@sample.org	f	t	2025-12-01 11:34:09.315454+00
127	pbkdf2_sha256$600000$jlUoqaQE5XsIQHup7voYMi$UC+h6kSXujZxFgpGjxyFSlK4qV5wgL9+/McQJZcddeU=	\N	f	zehaanbobal	Zehaan	Bobal	zehaanbobal@example.com	f	t	2025-12-01 11:34:09.656601+00
128	pbkdf2_sha256$600000$GUMewOTd6Strg4rI2xeENd$Ec6pNCx4BHnctsRxHXtt5clyd6XC0K6Hslb6JNyddTk=	\N	f	chamanbassi	Chaman	Bassi	chamanbassi@demo.edu	f	t	2025-12-01 11:34:09.894253+00
129	pbkdf2_sha256$600000$dUD0RHZaELWUFD8twCJ0uQ$I+H8TbYOUdV/gb4UfPNpoZlV1LMmj/gBkIqRMs0jKNA=	\N	f	vihaantak	Vihaan	Tak	vihaantak@demo.edu	f	t	2025-12-01 11:34:10.104064+00
130	pbkdf2_sha256$600000$NylpLQbWmX6TOvYxyXNSi9$M8bE2L4a1+2oi6zvLW5ylwkom5jJ1JSgSd0Ff0irdNA=	\N	f	chatreshoak	Chatresh	Oak	chatreshoak@test.local	f	t	2025-12-01 11:34:10.333198+00
131	pbkdf2_sha256$600000$Hc83aZvRQUQEDez3rfyPNy$0/vHntdmX2GSoWoYEkmywehSRmXlRrr7Bn5DqxDJTLk=	\N	f	yatandubey	Yatan	Dubey	yatandubey@example.com	f	t	2025-12-01 11:34:10.563473+00
132	pbkdf2_sha256$600000$lMdmi1Vr1coNSnTIDyhIoj$C68AsiPtrMP/i7p/rBp45Rh6AQ+40tTtWKwe2Mr8N0o=	\N	f	yashodababu	Yashoda	Babu	yashodababu@demo.edu	f	t	2025-12-01 11:34:10.792633+00
133	pbkdf2_sha256$600000$cXE1eK7bityQMzt9xljcHn$vyuNR5BCY8u3oCDzQAIZ62JgVUN+XdQHGsI6m9DyyKQ=	\N	f	adyahegde	Adya	Hegde	adyahegde@test.local	f	t	2025-12-01 11:34:11.42203+00
134	pbkdf2_sha256$600000$Fz69qLW7CzifCWyxPEqFhN$1jIr3iBR53dI4Gn49zCSDdPh5UKGMoKmISqWRJInrpI=	\N	f	radhakorpal	Radha	Korpal	radhakorpal@example.com	f	t	2025-12-01 11:34:11.665214+00
135	pbkdf2_sha256$600000$T2wD9pV9uiCUDwm4enZ9bU$SxiFBK07RRkqLE0wyVkke1VNe1rv4WGFQpGeU/fG5+M=	\N	f	dayitamani	Dayita	Mani	dayitamani@sample.org	f	t	2025-12-01 11:34:11.894781+00
136	pbkdf2_sha256$600000$D1QUy7MgMtlp2DAF1L8kyi$2BoDDwNY5ULF1iTmHVf6HSdtd9F+96Q0dzmG2SjAm7k=	\N	f	reyanshdeo	Reyansh	Deo	reyanshdeo@demo.edu	f	t	2025-12-01 11:34:12.123705+00
137	pbkdf2_sha256$600000$M2oQjekR5H6puYtlJ2zbeh$ppsc0hB4zZZIgphKrMyRbotQ9sOhTt+uMYEmvpZEC64=	\N	f	wrideshmanne	Wridesh	Manne	wrideshmanne@example.com	f	t	2025-12-01 11:34:12.342161+00
138	pbkdf2_sha256$600000$Qrt09YBbgfHcsDccqTQUGr$nYQT3aCSK7rTGr/NChHFiBHLwUAE4fEDtxfzIbnKqjA=	\N	f	vasudharatta	Vasudha	Ratta	vasudharatta@example.com	f	t	2025-12-01 11:34:12.560562+00
139	pbkdf2_sha256$600000$hDmS7tSNVd8Oldj6yLrKrI$XOdF80EUb1abUxCxBpMjlsw1sXpgfs01qkRFTiqhUEY=	\N	f	yashvigrewal	Yashvi	Grewal	yashvigrewal@demo.edu	f	t	2025-12-01 11:34:12.790383+00
140	pbkdf2_sha256$600000$9eqvVIJszOn0CsTawZ4mTd$iZiMF1uW+TjsrNVYjRIWOt05gCiHqBT7/8Qrxh1TNSI=	\N	f	nidrachowdhury	Nidra	Chowdhury	nidrachowdhury@example.com	f	t	2025-12-01 11:34:13.018834+00
141	pbkdf2_sha256$600000$WFdV883ga4xw9J8vNkfLcP$nf9KY7VXVt3/s7/OFYukxBbwCckelFzV79qTGV5jGvg=	\N	f	pranitpandit	Pranit	Pandit	pranitpandit@example.com	f	t	2025-12-01 11:34:13.259882+00
142	pbkdf2_sha256$600000$Qc4DwIrumEXtfvatolQeCb$FuIw8QwxK1y//Do0oLwHZmKpPAJrqct6QPKeyc4KdIU=	\N	f	jackgour	Jack	Gour	jackgour@test.local	f	t	2025-12-01 11:34:13.500461+00
143	pbkdf2_sha256$600000$6xnnvKFlVg6dhSGxSx8gFr$qYA2ToyWyqwqY1aCyJ0Y6YyJ4UVilS+YfvJWm+0en2s=	\N	f	pallaviram	Pallavi	Ram	pallaviram@demo.edu	f	t	2025-12-01 11:34:13.843611+00
144	pbkdf2_sha256$600000$nm58SSvjoZeYj7ebPWOI4V$L3TunxfDauvc3jL4RMnlPmkEPyh6r+S0+QJKhnfvA7Q=	\N	f	tanishmitra	Tanish	Mitra	tanishmitra@sample.org	f	t	2025-12-01 11:34:14.26503+00
145	pbkdf2_sha256$600000$z4PBmMYAfn8j9mo1zEg9pp$vW0QEzAItMXcT/Yj+7gr6o/h2odfLNKeXhUxIZFbf30=	\N	f	pranavchahal	Pranav	Chahal	pranavchahal@demo.edu	f	t	2025-12-01 11:34:14.505149+00
146	pbkdf2_sha256$600000$ik8I0eEJaMTLjLij4A8xJ6$0n4NcB0YBMaVfmGeQrHMYQrrDSl3EFZG+IIDRxxHXGE=	\N	f	tristantailor	Tristan	Tailor	tristantailor@test.local	f	t	2025-12-01 11:34:14.734773+00
147	pbkdf2_sha256$600000$R0N8ocAFk7h46iSntxcbPl$o7myzQZ/LuGD5kyHrd3dHU6PP1hnR5zZpHeXvLyRzVQ=	\N	f	orinderwable	Orinder	Wable	orinderwable@demo.edu	f	t	2025-12-01 11:34:15.030935+00
148	pbkdf2_sha256$600000$aruyyCfSzTKxoitVSlf3Ri$GvmZn/gEXEbIW9EhntfJ63b/rtWxXp8t91BTTCBpk+E=	\N	f	aarinibajwa	Aarini	Bajwa	aarinibajwa@example.com	f	t	2025-12-01 11:34:15.269753+00
149	pbkdf2_sha256$600000$p5fEkOTFJMBQYYW0xtW68r$dFfyo/ozRsx2w91aLayRP7kz0+dABGmf/tNXJXNA9Fw=	\N	f	qasimray	Qasim	Ray	qasimray@test.local	f	t	2025-12-01 11:34:15.511674+00
150	pbkdf2_sha256$600000$M0Ec1L91LNHG4m3l91OLAZ$gTPppqxjmah0xIKmzRJxyi+wpGGbRk1vHKuPP6v2dt0=	\N	f	raghavmaster	Raghav	Master	raghavmaster@test.local	f	t	2025-12-01 11:34:15.762739+00
151	pbkdf2_sha256$600000$5OXduvpbkBolCWIVUBov3B$Nyzg+ePkDjKRygIEppBknhUXRe6IxCeTFAm27jydD4U=	\N	f	aarinidatta	Aarini	Datta	aarinidatta@sample.org	f	t	2025-12-01 11:34:16.017113+00
152	pbkdf2_sha256$600000$N1LtZmXrrlZuEc2fYRYb5M$PZ3KxQEiNjgiWOyzWSI75sLCnTE3aemrf8CCZByPGTY=	\N	f	reyanshbabu	Reyansh	Babu	reyanshbabu@demo.edu	f	t	2025-12-01 11:34:16.247403+00
153	pbkdf2_sha256$600000$Azutr91xj4EmROg1CTJOrs$yZvoJ5dT12j7LHwHRl2zol3laqP2BLJ19VbIuG58vyU=	\N	f	ekantikahanda	Ekantika	Handa	ekantikahanda@sample.org	f	t	2025-12-01 11:34:16.498617+00
154	pbkdf2_sha256$600000$vgB06ki12xnFFoKej0WGKP$GV20ibMoB2e9o0iD0W0tewD8emP1qDtIN9j/vByPqbk=	\N	f	banjeetlal	Banjeet	Lal	banjeetlal@example.com	f	t	2025-12-01 11:34:16.75014+00
155	pbkdf2_sha256$600000$LTRsAJn1HyFv1ta8bAhqte$SOiumuSknA1W4CECaVeBPKnydpCYIcJSemLGF2qUutk=	\N	f	falakyohannan	Falak	Yohannan	falakyohannan@sample.org	f	t	2025-12-01 11:34:17.002734+00
156	pbkdf2_sha256$600000$HIBrMgfn3T9QLaHPkfbdWc$Dyx6V5OOxE6450mZh7jQmTJro5jmduW3553A8R5x10Y=	\N	f	ishitakhosla	Ishita	Khosla	ishitakhosla@sample.org	f	t	2025-12-01 11:34:17.253964+00
157	pbkdf2_sha256$600000$Oxzi5dLkdKQkLZuEhhb1yt$LA2AWHHFreS6qi3CIDOywvR2oZgAokgKrsbeCoXDhys=	\N	f	zayanratti	Zayan	Ratti	zayanratti@example.com	f	t	2025-12-01 11:34:17.549884+00
158	pbkdf2_sha256$600000$I4d8oKoAsGLOlIIHCCzZa9$UaHefLbXmnIis9HrjRBwmYsihJQa7WzOEVj2Va6+5gw=	\N	f	fradodeol	Frado	Deol	fradodeol@sample.org	f	t	2025-12-01 11:34:17.790858+00
159	pbkdf2_sha256$600000$PAmnHeL997Dmp2dAZ2NLBf$+YoTOWkKwzN3vcNfBlBfAoW/AUIb7eSqgx8J+o2nvfA=	\N	f	daminilala	Damini	Lala	daminilala@test.local	f	t	2025-12-01 11:34:18.052724+00
160	pbkdf2_sha256$600000$GwFY2ksnBTk6VB5sU6zF7I$vmZzLmrbexjRVAdUW4FZ9fTDFXhQxelp6pJByS56Qb4=	\N	f	chandreshvarghese	Chandresh	Varghese	chandreshvarghese@test.local	f	t	2025-12-01 11:34:18.270076+00
161	pbkdf2_sha256$600000$7T6YStRxjj15W9FH9YGYL5$d6Irq3UNAAA9rhramV03H3WHo1IYxCaO6nPvF97mWCM=	\N	f	tanmayibhatia	Tanmayi	Bhatia	tanmayibhatia@example.com	f	t	2025-12-01 11:34:18.489748+00
162	pbkdf2_sha256$600000$KCZWoYhkGw2n9kX2t2EAkK$t0rDcI9T9Y+/Kdh/3wc75jHHV2LaQcZ3hC2j804mgO4=	\N	f	agastyawadhwa	Agastya	Wadhwa	agastyawadhwa@example.com	f	t	2025-12-01 11:34:18.706768+00
163	pbkdf2_sha256$600000$cgaX2TzGV0bfY33EusBcRA$gi7B81Pc0J9oxfk/P87Ti/5eTbKMAfYR+axbIp2kMwE=	\N	f	faraspall	Faras	Pall	faraspall@test.local	f	t	2025-12-01 11:34:18.926143+00
164	pbkdf2_sha256$600000$3gVqAl1f7qFVsGLQcGwFFf$xiu0OL2jw6SRAhOIWKp+AZRyd8CAMGFW+ayVi++2Aag=	\N	f	aarnachar	Aarna	Char	aarnachar@demo.edu	f	t	2025-12-01 11:34:19.231078+00
165	pbkdf2_sha256$600000$kModwT7ff98ad2TYzvNJEP$AnAR2k7tZdQ9rFAABrjmJ+LPizqhAbXr7xhxliRGxs8=	\N	f	jonathanpurohit	Jonathan	Purohit	jonathanpurohit@example.com	f	t	2025-12-01 11:34:19.46325+00
166	pbkdf2_sha256$600000$PVmM6LwE5CIcSlB6zaG0O0$pkQi+NUQrg0MaxhzFcXmi49zOt1JdU2KvES+uvTdnKk=	\N	f	parthissac	Parth	Issac	parthissac@sample.org	f	t	2025-12-01 11:34:19.692046+00
167	pbkdf2_sha256$600000$sXTAARBiKvdDZwR8QbMZdY$yiB6G9ljQKctLyPEWcZcSDmlJZVDkZulPSJ/dBsXDpE=	\N	f	yochanabali	Yochana	Bali	yochanabali@example.com	f	t	2025-12-01 11:34:20.070567+00
168	pbkdf2_sha256$600000$kjwXb7VBfQg18n9KohXdix$RoCAQqDuQtjiQWajo2nHMnzt43SywnCFIDJfDEImH08=	\N	f	isaackrishnan	Isaac	Krishnan	isaackrishnan@example.com	f	t	2025-12-01 11:34:20.502536+00
169	pbkdf2_sha256$600000$TSAUa8KOeY5yvyoRYb5cO6$/aDmVC6CKxVCrvlc3m0gfeUFYDMstPrEk1p39KpiBoU=	\N	f	azaangola	Azaan	Gola	azaangola@demo.edu	f	t	2025-12-01 11:34:20.720958+00
170	pbkdf2_sha256$600000$IdLncFJM2k5KzoZHfIBxj3$eRiI0OuV2w7fbYf5lvVm1sewERi0WTwn9SGE7nuk23s=	\N	f	haritabera	Harita	Bera	haritabera@demo.edu	f	t	2025-12-01 11:34:20.939375+00
171	pbkdf2_sha256$600000$vKgRxNfTKZwwcqgAbD0r15$p0RQQt6aC+q3hHKOUMUc9vsjSVcu/JW23dcProQO9p4=	\N	f	saisingh	Sai	Singh	saisingh@example.com	f	t	2025-12-01 11:34:21.158106+00
172	pbkdf2_sha256$600000$KNtHDqKnAYtkDIruueT0E2$55k7NqDSroye6ZnpFTla4BfCsrTr9768B4P7YFbVVn4=	\N	f	hemanginihari	Hemangini	Hari	hemanginihari@demo.edu	f	t	2025-12-01 11:34:21.376058+00
173	pbkdf2_sha256$600000$dlFTXLzux1GzsoVg5JOgFs$0RPkQ9juCcMG1Xtv0B38k9EDy9+ZL6n+7QKmL4e9/BI=	\N	f	dominicnanda	Dominic	Nanda	dominicnanda@demo.edu	f	t	2025-12-01 11:34:21.605321+00
174	pbkdf2_sha256$600000$gaI53DVAGenZ6xDu3acdcH$PIGqYQzrfHSGtZxi2hfW2o+gpV8FcQDs/tM7kLuQcQY=	\N	f	diyabalay	Diya	Balay	diyabalay@example.com	f	t	2025-12-01 11:34:21.83578+00
175	pbkdf2_sha256$600000$pVbkt8ewFVzLowN878dsvo$ASORGY9qVuCzuuFaqklRWPDIIiaKbxB1lUKrSFPJ1WA=	\N	f	rachitchand	Rachit	Chand	rachitchand@test.local	f	t	2025-12-01 11:34:22.064387+00
176	pbkdf2_sha256$600000$m5Zsq1pRLY79xWy23RxZY3$l/hvInPBsW7Ct9f3OeQPPoBUzVs/gHTyHvuJjdbyX8E=	\N	f	eesharadhakrishnan	Eesha	Radhakrishnan	eesharadhakrishnan@demo.edu	f	t	2025-12-01 11:34:22.371797+00
177	pbkdf2_sha256$600000$yDdzun8xszWFUG64ftnGlx$hHb/I+EUHcprmORN8QVY0uNoVcRUp+UtfZR8N1Zgq5g=	\N	f	gauribarad	Gauri	Barad	gauribarad@test.local	f	t	2025-12-01 11:34:22.60146+00
178	pbkdf2_sha256$600000$rRuWXhmu8fs1h0iqtduYmp$dfMU4x5ERBXsNSoIHROhjBafLF0vlcQ2nGzrPOpxpPw=	\N	f	meeranaidu	Meera	Naidu	meeranaidu@test.local	f	t	2025-12-01 11:34:22.830504+00
179	pbkdf2_sha256$600000$L0d2IszSozadYzyhTINtvb$uso0tunhCGpITMuTuG/iuqnXY3m9q0QyzmnZ0HN5+9k=	\N	f	nandinitiwari	Nandini	Tiwari	nandinitiwari@demo.edu	f	t	2025-12-01 11:34:23.048096+00
180	pbkdf2_sha256$600000$hgyHortRQcn7elVhGQ82ox$CW6Pi7quLnR9HZCZKaFT5UwRrczgqHpn6e9ndbGTeNg=	\N	f	vedasahni	Veda	Sahni	vedasahni@demo.edu	f	t	2025-12-01 11:34:23.255919+00
181	pbkdf2_sha256$600000$8dMlgb7c8zkpkyPEfhTdam$k8ap4yJMtokBuA2NZksfaQV9hPsg9/wY47TwMqBVyzQ=	\N	f	maanasgoel	Maanas	Goel	maanasgoel@example.com	f	t	2025-12-01 11:34:23.474321+00
182	pbkdf2_sha256$600000$BSSHyt9MQBCQ1r2D2HMU9D$RqfhI1TsEC09OKSfXm8ttvfRUrAaBMCIzIKcrUpZxb8=	\N	f	masonmand	Mason	Mand	masonmand@demo.edu	f	t	2025-12-01 11:34:23.692522+00
183	pbkdf2_sha256$600000$4x0igu24iaabGaRUGBmLlV$b9O+yobB+z9nnTHKZAgLccu5M1r4EzOphQYd8C94jxs=	\N	f	radhikachaudhuri	Radhika	Chaudhuri	radhikachaudhuri@sample.org	f	t	2025-12-01 11:34:23.910091+00
184	pbkdf2_sha256$600000$oB0D2rfEi421obk0T3qPh1$w+pMwPae2f5xEOCO75xC+gej+slJvvYZFl2LGys7eJw=	\N	f	jagratireddy	Jagrati	Reddy	jagratireddy@example.com	f	t	2025-12-01 11:34:24.129117+00
185	pbkdf2_sha256$600000$PkzyhjW34wI9REk58oVYah$dlqJLraqjMgZk5M9bKjdSN1h+mNintQWXHVXuhcdPNQ=	\N	f	aarnamall	Aarna	Mall	aarnamall@demo.edu	f	t	2025-12-01 11:34:24.347309+00
186	pbkdf2_sha256$600000$el4Xi1DbLz22rEDpknWpZv$Im9enmwU8erBcQIBeiM6TAVnBFDS7xWmwzMBAdxlip4=	\N	f	daksheshkonda	Dakshesh	Konda	daksheshkonda@example.com	f	t	2025-12-01 11:34:24.566219+00
187	pbkdf2_sha256$600000$HvW55NGVWNQMU1ZR3TCE80$aVh5kJ6RrJyjCGA7Q6ASPlK6G6pp7kvRdmAayJM/uI8=	\N	f	gautamsabharwal	Gautam	Sabharwal	gautamsabharwal@demo.edu	f	t	2025-12-01 11:34:24.78429+00
188	pbkdf2_sha256$600000$60cRarCAFKmlMy0CFoEtEf$IG7OR3KVlfMDGD9OLun76G0zd5Cut/hx5kPyE8e8REQ=	\N	f	harshilgala	Harshil	Gala	harshilgala@test.local	f	t	2025-12-01 11:34:25.015727+00
189	pbkdf2_sha256$600000$sSoZRwrrF32uBYKPyOwQ3W$lAmyhhy0+e02+xs0ielVsCXMLWCgO7MhQXsapJSLDLE=	\N	f	yachanaraman	Yachana	Raman	yachanaraman@demo.edu	f	t	2025-12-01 11:34:25.298507+00
190	pbkdf2_sha256$600000$GNUt8YxfFil5puGzR0mP3v$0ezI9ep0MjNgco1HQrdUb0EQkGEYvBgL9Ii/kbLYS8k=	\N	f	samarchakraborty	Samar	Chakraborty	samarchakraborty@demo.edu	f	t	2025-12-01 11:34:25.629131+00
191	pbkdf2_sha256$600000$Pa6YosI0SsGAFuWmFaSJ5f$/EJyfaEgy7F64LMshWRVoHbwD6iTDqlO50JPq5nYN6k=	\N	f	bahadurjitranganathan	Bahadurjit	Ranganathan	bahadurjitranganathan@test.local	f	t	2025-12-01 11:34:25.867552+00
192	pbkdf2_sha256$600000$et0c9KSLJ8PdGuF1q9Lwsn$5pkoQJcJcSSudwQAUNXBQm3nYdQdm/HgSNkl1Yc5OBI=	\N	f	netrabhandari	Netra	Bhandari	netrabhandari@sample.org	f	t	2025-12-01 11:34:26.401952+00
193	pbkdf2_sha256$600000$O1xXfvBpOHC3UOl0FCXYRQ$0/ugSa8PP03RerwKPTwJ0j2EQV1HoyG2XwLytcvW0uc=	\N	f	falakarora	Falak	Arora	falakarora@example.com	f	t	2025-12-01 11:34:26.632555+00
194	pbkdf2_sha256$600000$k08rI1DlYFFrBi0a7XrjJA$8MYqHhog5YJPJC0I0SCQQQkHUf/mrmVSKunOASvyOEY=	\N	f	farhanboase	Farhan	Boase	farhanboase@sample.org	f	t	2025-12-01 11:34:26.851024+00
195	pbkdf2_sha256$600000$8YdTqBsLk13EeLIrBNwPl8$pBwrOkLlljM9oW2UCKmzklKballGX4oPE+Qt2mPimv8=	\N	f	labangupta	Laban	Gupta	labangupta@sample.org	f	t	2025-12-01 11:34:27.068461+00
196	pbkdf2_sha256$600000$E3ldOpoROp0mx3824SNkh7$Ddwl2/AHsvbYkUB33k0Fim3KJbvrBcaYbMZO48OBhh8=	\N	f	qasimmaster	Qasim	Master	qasimmaster@demo.edu	f	t	2025-12-01 11:34:27.287494+00
197	pbkdf2_sha256$600000$S8OCimw4cQPeA5pgFtzLQz$WxdZQQfeRr3Bkbgm3WmwqCTT1w1lYx8IAF6IzGlc9no=	\N	f	oeshigoel	Oeshi	Goel	oeshigoel@demo.edu	f	t	2025-12-01 11:34:27.50606+00
198	pbkdf2_sha256$600000$NRrY5VaoeQCiVBPjpgNirJ$sszyS+L0WgLDDbvYgKAJ984jdGRU+bEbm5GdmSjhEW4=	\N	f	wazirjohal	Wazir	Johal	wazirjohal@example.com	f	t	2025-12-01 11:34:27.802333+00
199	pbkdf2_sha256$600000$P7ACQoHohffAyxA2pc5APb$n7i1YZWGpcnAdpGo/7YUvW2q5lj5BOQKZk0aYOiX9yY=	\N	f	bhavikakata	Bhavika	Kata	bhavikakata@example.com	f	t	2025-12-01 11:34:28.021034+00
200	pbkdf2_sha256$600000$8w8zhbHElW4YbbCO0G6TZL$IXJJPR8H+JcvNLEbsLD3/vNVd7OsNqrzx88uRem7aI4=	\N	f	qarinbassi	Qarin	Bassi	qarinbassi@demo.edu	f	t	2025-12-01 11:34:28.24092+00
201	pbkdf2_sha256$600000$AQjUG2sjXIM9INahwALDOI$34cZY9OYpGtHBzeb+BoIVHZRQ6sUPEQRWmrD8awVAGc=	\N	f	ayushsibal	Ayush	Sibal	ayushsibal@example.com	f	t	2025-12-01 11:34:28.459193+00
202	pbkdf2_sha256$600000$lQcn93OHbvrxPiBDk4PV8G$rnFdFwLfxK16KEqdKIoNxATWpSWhf2g5VSl/Oily+8U=	\N	f	riyasaini	Riya	Saini	riyasaini@test.local	f	t	2025-12-01 11:34:28.677652+00
203	pbkdf2_sha256$600000$G1aO8UBEcdHpEm19xpwWlA$a1H7nb3VyhXq98EJyFq7xTpqBlmt2lS243fxX9hrJLw=	\N	f	radhikaramachandran	Radhika	Ramachandran	radhikaramachandran@test.local	f	t	2025-12-01 11:34:28.895403+00
204	pbkdf2_sha256$600000$MGU3XE7xJSjfGtSEdVuiz9$OiNNtx6wfO4RiOJicJC5zczwqPiNRDnLy4eb/6YluLs=	\N	f	jananidayal	Janani	Dayal	jananidayal@demo.edu	f	t	2025-12-01 11:34:29.114293+00
205	pbkdf2_sha256$600000$rEZ8aqKUHdh8SKKNY6pRfo$vnDtzeTYXyEYmTIDXn6oE5q3VLGRKPD74lmXVS0I5mQ=	\N	f	ikshitagrewal	Ikshita	Grewal	ikshitagrewal@sample.org	f	t	2025-12-01 11:34:29.332546+00
206	pbkdf2_sha256$600000$pJeKWA3MaN40dyxTNw6qzZ$MrcglKHr6+WNGY2E4BG6Nm805ZYs6BM/CRzCAVtloRY=	\N	f	yahvijaggi	Yahvi	Jaggi	yahvijaggi@example.com	f	t	2025-12-01 11:34:29.550421+00
207	pbkdf2_sha256$600000$YVkMtQqPnngtDlYLDb8ol1$swtygOOVm0S2dvLvTotWR5QwsxwCHgQPN6cJY8SZXqE=	\N	f	qabilchaudhary	Qabil	Chaudhary	qabilchaudhary@demo.edu	f	t	2025-12-01 11:34:29.769595+00
208	pbkdf2_sha256$600000$IE6gF2HXAMFBk55NrviB4S$VdX9PASAyXiWGMV6Rr0K674cdCfdXSobl/5HNTJXcGs=	\N	f	aryanchokshi	Aryan	Chokshi	aryanchokshi@sample.org	f	t	2025-12-01 11:34:29.998874+00
209	pbkdf2_sha256$600000$kl9qq6sRsibe1LaaeWLYEL$DxwcN0EtuSBaSkkfwHqzrc8bCy1EbH+U2HD41XD8da4=	\N	f	ikshitachad	Ikshita	Chad	ikshitachad@example.com	f	t	2025-12-01 11:34:30.228526+00
210	pbkdf2_sha256$600000$9iCMMNK8ZlwQe7vLN8vZtX$+Dn2WP+t4zXlid2B2lCr/xdntgO349I9cNTERAUpdHQ=	\N	f	tanaytalwar	Tanay	Talwar	tanaytalwar@example.com	f	t	2025-12-01 11:34:30.446961+00
211	pbkdf2_sha256$600000$W0frykwDy4FsFb0wTI0Gpw$CzApb4TMhks5+jnDjn0mxEgM3jvN6ocwZLMXUkIj/Zk=	\N	f	theodoreradhakrishnan	Theodore	Radhakrishnan	theodoreradhakrishnan@test.local	f	t	2025-12-01 11:34:30.761276+00
224	pbkdf2_sha256$600000$5WSWk1A7v3f4DquEHhh6PK$bRyUMP+gcy/3KNPA7XN/rBQlp/jgSVE2G8HLFyEgtg8=	2025-12-02 05:30:37.195573+00	t	sahil				t	t	2025-12-02 05:26:25+00
212	pbkdf2_sha256$600000$XTdoGDpde1IENczkFptGo8$ZdoBS/9lhfASdSzHH3po6UR+VJZhpjpcIwh9N8a6ZHg=	\N	f	xalaksarraf	Xalak	Sarraf	xalaksarraf@example.com	f	t	2025-12-01 11:34:31.0054+00
213	pbkdf2_sha256$600000$wpKmkAdr8xFAPTYvPAko9p$6O7on6lxm5Wd4djvs/ZgtIskizU8D5QD6pENZBzF7pc=	\N	f	snehashanker	Sneha	Shanker	snehashanker@test.local	f	t	2025-12-01 11:34:31.224307+00
214	pbkdf2_sha256$600000$6SZ24yBsVNQjxnb71YmdFt$hlsBMu7QECgBRi0aJ1kOXlLIEJxCvXMblxT+8pO/t/o=	\N	f	baljiwansood	Baljiwan	Sood	baljiwansood@example.com	f	t	2025-12-01 11:34:31.453739+00
215	pbkdf2_sha256$600000$auOYVIJ5KbLNPov9Y2TZz0$FAiKCQvrmBeHJJ+dsbzDWhNDrodfMJCxGJwJRHx42X0=	\N	f	raaginiram	Raagini	Ram	raaginiram@test.local	f	t	2025-12-01 11:34:31.816595+00
216	pbkdf2_sha256$600000$5uvVM3zZVlXCbCogEIsYxH$mCQAKCnRBxtEPTzjt7v5jUFTzkkBo6bKHbQlBjoxFUY=	\N	f	devanshrajan	Devansh	Rajan	devanshrajan@example.com	f	t	2025-12-01 11:34:32.04518+00
217	pbkdf2_sha256$600000$8zUT6jLSftnYtgnorfPGR4$OA6y1IBhPkfflahFW3rbkcrcQe+89NvkXE1IlkkppFI=	\N	f	rianatt	Ria	Natt	rianatt@example.com	f	t	2025-12-01 11:34:32.261629+00
218	pbkdf2_sha256$600000$R37OSiQmEMEbuL28hV3Pb0$NoXTwCUoiH8Zg7bzZDMhOZVu+FiNidsuie1aR7YjkmQ=	\N	f	dhruvchaudhari	Dhruv	Chaudhari	dhruvchaudhari@test.local	f	t	2025-12-01 11:34:32.482668+00
219	pbkdf2_sha256$600000$ofojIIPN6fNgUH4SROL0wb$N5fGRIaDAA5zat9HI3nvHzVJpj5O53G2L59uYQ3p86o=	\N	f	onkarnazareth	Onkar	Nazareth	onkarnazareth@demo.edu	f	t	2025-12-01 11:34:32.723051+00
220	pbkdf2_sha256$600000$EZXLQJQXJkxdGcF2sJqH59$Do7u0hLw8MVWBGTwCeJziDMhXby/JdR2lSCarAAgyfc=	\N	f	urishillawalia	Urishilla	Walia	urishillawalia@sample.org	f	t	2025-12-01 11:34:32.941613+00
221	pbkdf2_sha256$600000$7SVmMsAx25ljjgWUzvyESE$EZofWxVwtLpDgFyvJsXN+J21pD2eTu7KsjkN9QI0XuU=	\N	f	mugdhasekhon	Mugdha	Sekhon	mugdhasekhon@test.local	f	t	2025-12-01 11:34:33.170524+00
222	pbkdf2_sha256$600000$nbkZMzbIilAtUvzmMYhnKq$owTrA5n+S8xDWQLRxQj8pvJExBd/zFZrcaDhvVL4FlI=	\N	f	upkaarganesh	Upkaar	Ganesh	upkaarganesh@demo.edu	f	t	2025-12-01 11:34:33.389333+00
223	pbkdf2_sha256$600000$jBxxyUigr1nGNpm6QlXAse$eDvhILcqWjB+88UP6ocKzJYjn/mN20br5EUEETqr0lY=	\N	f	prishagade	Prisha	Gade	prishagade@sample.org	f	t	2025-12-01 11:34:33.619123+00
225	pbkdf2_sha256$600000$lvQBMo2OEYwi8DyynuAzrL$axVHrFUNDqKgRhvmQoQEjpnhNr3bp90NG9lPYTBQhKA=	\N	t	admin				t	t	2025-12-02 05:30:57+00
\.


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

COPY public.auth_user_groups (id, user_id, group_id) FROM stdin;
111	114	3
112	115	3
113	116	3
114	117	3
115	118	3
116	119	3
117	120	3
118	121	3
119	122	3
120	123	3
121	124	4
122	125	4
123	126	4
124	127	4
125	128	4
126	129	4
127	130	4
128	131	4
129	132	4
130	133	4
131	134	4
132	135	4
133	136	4
134	137	4
135	138	4
136	139	4
137	140	4
138	141	4
139	142	4
140	143	4
141	144	4
142	145	4
143	146	4
144	147	4
145	148	4
146	149	4
147	150	4
148	151	4
149	152	4
150	153	4
151	154	4
152	155	4
153	156	4
154	157	4
155	158	4
156	159	4
157	160	4
158	161	4
159	162	4
160	163	4
161	164	4
162	165	4
163	166	4
164	167	4
165	168	4
166	169	4
167	170	4
168	171	4
169	172	4
170	173	4
171	174	4
172	175	4
173	176	4
174	177	4
175	178	4
176	179	4
177	180	4
178	181	4
179	182	4
180	183	4
181	184	4
182	185	4
183	186	4
184	187	4
185	188	4
186	189	4
187	190	4
188	191	4
189	192	4
190	193	4
191	194	4
192	195	4
193	196	4
194	197	4
195	198	4
196	199	4
197	200	4
198	201	4
199	202	4
200	203	4
201	204	4
202	205	4
203	206	4
204	207	4
205	208	4
206	209	4
207	210	4
208	211	4
209	212	4
210	213	4
211	214	4
212	215	4
213	216	4
214	217	4
215	218	4
216	219	4
217	220	4
218	221	4
219	222	4
220	223	4
\.


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

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


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

COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
151	2025-12-02 05:30:57.531063+00	225	admin	1	[{"added": {}}]	5	224
152	2025-12-02 05:31:08.285177+00	225	admin	2	[{"changed": {"fields": ["Staff status", "Superuser status"]}}]	5	224
\.


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

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


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

COPY public.django_celery_beat_crontabschedule (id, minute, hour, day_of_week, day_of_month, month_of_year, timezone) FROM stdin;
1	0	4	*	*	*	Asia/Kolkata
2	*	*	*	*	*	Asia/Kolkata
\.


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

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


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

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;
2	enqueue-notifications-every-minute	notifications.tasks.enqueue_due_notifications	[]	{}	\N	\N	\N	\N	t	2025-12-02 05:41:00.005928+00	705	2025-12-02 05:41:05.037795+00		2	\N	\N	f	\N	\N	{}	\N	\N
1	celery.backend_cleanup	celery.backend_cleanup	[]	{}	\N	\N	\N	\N	t	\N	0	2025-12-01 16:45:41.157015+00		1	\N	\N	f	\N	\N	{}	\N	43200
\.


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

COPY public.django_celery_beat_periodictasks (ident, last_update) FROM stdin;
1	2025-12-01 16:45:41.288988+00
\.


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

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


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

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	contenttypes	contenttype
2	admin	logentry
3	auth	permission
4	auth	group
5	auth	user
6	sessions	session
7	academics	course
8	academics	lesson
9	academics	lessonchecklistitem
10	academics	enrollment
11	academics	teacherassignedproxy
12	academics	enrollmentadminproxy
13	academics	lessonprogress
14	timetable	timetablenotification
15	timetable	timetable
16	django_celery_beat	crontabschedule
17	django_celery_beat	intervalschedule
18	django_celery_beat	periodictask
19	django_celery_beat	periodictasks
20	django_celery_beat	solarschedule
21	django_celery_beat	clockedschedule
22	timetable	classsession
23	notifications	notificationtemplate
24	notifications	notificationschedule
25	notifications	notificationpreference
26	notifications	notificationdelivery
\.


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

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2025-10-18 02:58:40.603878+00
2	auth	0001_initial	2025-10-18 02:58:44.472596+00
3	academics	0001_initial	2025-10-18 02:58:45.829882+00
4	academics	0002_historicallessonchecklistitem_historicallesson_and_more	2025-10-18 02:58:48.634703+00
5	academics	0003_historicaluser_historicalgroup	2025-10-18 02:58:50.920906+00
6	academics	0004_remove_historicalgroup_history_user_and_more	2025-10-18 02:58:51.021142+00
7	admin	0001_initial	2025-10-18 02:58:51.946921+00
8	admin	0002_logentry_remove_auto_add	2025-10-18 02:58:51.982804+00
9	admin	0003_logentry_add_action_flag_choices	2025-10-18 02:58:52.030623+00
10	contenttypes	0002_remove_content_type_name	2025-10-18 02:58:52.085354+00
11	auth	0002_alter_permission_name_max_length	2025-10-18 02:58:52.121522+00
12	auth	0003_alter_user_email_max_length	2025-10-18 02:58:52.152729+00
13	auth	0004_alter_user_username_opts	2025-10-18 02:58:52.191307+00
14	auth	0005_alter_user_last_login_null	2025-10-18 02:58:52.229471+00
15	auth	0006_require_contenttypes_0002	2025-10-18 02:58:52.25537+00
16	auth	0007_alter_validators_add_error_messages	2025-10-18 02:58:52.301029+00
17	auth	0008_alter_user_username_max_length	2025-10-18 02:58:52.572987+00
18	auth	0009_alter_user_last_name_max_length	2025-10-18 02:58:52.622052+00
19	auth	0010_alter_group_name_max_length	2025-10-18 02:58:52.657947+00
20	auth	0011_update_proxy_permissions	2025-10-18 02:58:52.693603+00
21	auth	0012_alter_user_first_name_max_length	2025-10-18 02:58:52.726846+00
22	sessions	0001_initial	2025-10-18 02:58:53.413335+00
23	academics	0005_enrollment_course_students	2025-10-18 14:46:07.814889+00
24	academics	0005_course_teacher_enrollment_course_students	2025-11-28 15:09:57.943973+00
27	academics	0005_teacherassignedproxy_alter_course_options_and_more	2025-11-30 05:10:54.904016+00
28	timetable	0001_initial	2025-11-30 12:49:52.248981+00
29	django_celery_beat	0001_initial	2025-11-30 16:42:22.220621+00
30	django_celery_beat	0002_auto_20161118_0346	2025-11-30 16:42:22.632292+00
31	django_celery_beat	0003_auto_20161209_0049	2025-11-30 16:42:22.824375+00
32	django_celery_beat	0004_auto_20170221_0000	2025-11-30 16:42:22.867544+00
33	django_celery_beat	0005_add_solarschedule_events_choices	2025-11-30 16:42:22.903361+00
34	django_celery_beat	0006_auto_20180322_0932	2025-11-30 16:42:23.681584+00
35	django_celery_beat	0007_auto_20180521_0826	2025-11-30 16:42:23.768331+00
36	django_celery_beat	0008_auto_20180914_1922	2025-11-30 16:42:23.838386+00
37	django_celery_beat	0006_auto_20180210_1226	2025-11-30 16:42:23.966535+00
38	django_celery_beat	0006_periodictask_priority	2025-11-30 16:42:24.075599+00
39	django_celery_beat	0009_periodictask_headers	2025-11-30 16:42:24.137362+00
40	django_celery_beat	0010_auto_20190429_0326	2025-11-30 16:42:24.32733+00
41	django_celery_beat	0011_auto_20190508_0153	2025-11-30 16:42:24.747629+00
42	django_celery_beat	0012_periodictask_expire_seconds	2025-11-30 16:42:24.799306+00
43	django_celery_beat	0013_auto_20200609_0727	2025-11-30 16:42:24.84473+00
44	django_celery_beat	0014_remove_clockedschedule_enabled	2025-11-30 16:42:24.961148+00
45	django_celery_beat	0015_edit_solarschedule_events_choices	2025-11-30 16:42:25.00872+00
46	django_celery_beat	0016_alter_crontabschedule_timezone	2025-11-30 16:42:25.054995+00
47	django_celery_beat	0017_alter_crontabschedule_month_of_year	2025-11-30 16:42:25.098657+00
48	django_celery_beat	0018_improve_crontab_helptext	2025-11-30 16:42:25.143688+00
49	django_celery_beat	0019_alter_periodictasks_options	2025-11-30 16:42:25.195165+00
50	notifications	0001_initial	2025-11-30 16:42:29.219853+00
51	timetable	0002_classsession	2025-11-30 16:42:29.825018+00
52	academics	0006_alter_course_description_alter_lesson_content	2025-12-01 14:23:49.180317+00
53	timetable	0002_alter_timetable_notes_and_more	2025-12-01 14:24:55.145998+00
\.


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

COPY public.django_session (session_key, session_data, expire_date) FROM stdin;
zi2qhkbpy3kzcpyj4htth2a7t19rmrfr	.eJxVjMsOwiAQRf-FtSHAYAdcuu83kBkeUjU0Ke3K-O_apAvd3nPOfYlA21rD1vMSpiQuQovT78YUH7ntIN2p3WYZ57YuE8tdkQftcpxTfl4P9--gUq_fuvgCXtlSBjSOnUdrAcCzBTznFBOTIkDPClTRBpUbStaMnrKBpBWK9wfPSTdN:1v8LH2:wai1JTVQyH7ew-mNl1XCG0hMTBOrmbgwI7_bVvXszaM	2025-10-27 16:19:48.092355+00
avru082s2fr5aekct1nnmj113lvt2mbs	.eJxVjMsOwiAQRf-FtSHAYAdcuu83kBkeUjU0Ke3K-O_apAvd3nPOfYlA21rD1vMSpiQuQovT78YUH7ntIN2p3WYZ57YuE8tdkQftcpxTfl4P9--gUq_fuvgCXtlSBjSOnUdrAcCzBTznFBOTIkDPClTRBpUbStaMnrKBpBWK9wfPSTdN:1vA7f4:RDReN3vkVrYqOGRUaf0zpkfYdtalEOplSsO-eKEdJ-0	2025-11-01 14:11:58.214435+00
1h9bfee9wevfri2lx7xwxkw06ycu5t9g	.eJxVjMsOwiAQRf-FtSHAYAdcuu83kBkeUjU0Ke3K-O_apAvd3nPOfYlA21rD1vMSpiQuQovT78YUH7ntIN2p3WYZ57YuE8tdkQftcpxTfl4P9--gUq_fuvgCXtlSBjSOnUdrAcCzBTznFBOTIkDPClTRBpUbStaMnrKBpBWK9wfPSTdN:1vPBbi:dnMps9NsCv_y9-aJUp6VDfGTcDFlqDQb52xQP1HBAb8	2025-12-13 03:26:46.482957+00
fs4l5i3zlwhylbjuftj9jrtfmaxrbnwy	.eJxVjMsOwiAQRf-FtSHAYAdcuu83kBkeUjU0Ke3K-O_apAvd3nPOfYlA21rD1vMSpiQuQovT78YUH7ntIN2p3WYZ57YuE8tdkQftcpxTfl4P9--gUq_fuvgCXtlSBjSOnUdrAcCzBTznFBOTIkDPClTRBpUbStaMnrKBpBWK9wfPSTdN:1vPszS:fTQPt8YKvKRuYkQeKi41ujeNtdAefYiTJcz2R24EXlc	2025-12-15 01:46:10.013193+00
2xjof1raon03dxqla6own09yk63aywl4	.eJxVjDsOwjAQRO_iGlmL_6ak5wzRrr3GAWRL-VSIu5NIKaAbzXszbzHgutRhnXkaxiwuQikjTr8tYXpy21F-YLt3mXpbppHkrsiDzvLWM7-uh_t3UHGu2zoGD6UkQodna5zyYCjo6MHFUMiYLZYIZBOYHCKwZmIOGjAqst4H8fkCFYs3mA:1vQIyD:SSwydnB1cBd8OgHFGQp34Yw-tomGM615gSGQprt0aoo	2025-12-16 05:30:37.323314+00
\.


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

COPY public.notifications_notificationdelivery (id, channel, status, message, sent_at, error, created_at, recipient_id, schedule_id) FROM stdin;
\.


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

COPY public.notifications_notificationpreference (id, email_enabled, in_app_enabled, push_enabled, created_at, updated_at, user_id) FROM stdin;
\.


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

COPY public.notifications_notificationschedule (id, object_id, scheduled_for, context, channels, sent, created_at, updated_at, content_type_id, template_id) FROM stdin;
1	1	2025-12-01 03:48:23.371342+00	{"course": "Databases & SQL", "lesson": "Test Notification", "duration": 60, "start_at": "2025-12-01 03:58"}	[]	t	2025-12-01 03:46:23.695071+00	2025-12-01 03:46:23.695089+00	22	1
2	2	2025-12-01 03:59:44.590129+00	{"course": "Databases & SQL", "lesson": "Test 2", "duration": 60, "start_at": "2025-12-01 04:09"}	[]	t	2025-12-01 03:57:44.742682+00	2025-12-01 03:57:44.742703+00	22	1
3	3	2025-12-01 04:41:49.345159+00	{"course": "Databases & SQL", "lesson": "Final Test", "duration": 60, "start_at": "2025-12-01 04:51"}	[]	t	2025-12-01 04:39:49.799561+00	2025-12-01 04:39:49.799579+00	22	1
4	4	2025-12-01 04:50:35.898133+00	{"course": "Databases & SQL", "lesson": "Test Notification", "duration": 60, "start_at": "2025-12-01 05:00"}	[]	t	2025-12-01 04:48:35.999444+00	2025-12-01 04:48:35.999452+00	22	1
\.


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

COPY public.notifications_notificationschedule_recipients (id, notificationschedule_id, user_id) FROM stdin;
\.


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

COPY public.notifications_notificationtemplate (id, name, subject, body, channels, created_at, updated_at) FROM stdin;
1	upcoming_class	Upcoming Class: {course}	Your class "{lesson}" for {course} starts at {start_at}. Duration: {duration} minutes.	["email"]	2025-12-01 03:46:23.637491+00	2025-12-01 03:46:23.637521+00
\.


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

COPY public.timetable_classsession (id, title, start_at, duration_minutes, notify_before_minutes, active, created_at, updated_at, course_id, lesson_id) FROM stdin;
1	Test Notification	2025-12-01 03:58:23.371342+00	60	10	t	2025-12-01 03:46:23.372083+00	2025-12-01 03:46:23.372098+00	4	\N
2	Test 2	2025-12-01 04:09:44.590129+00	60	10	t	2025-12-01 03:57:44.591449+00	2025-12-01 03:57:44.591459+00	4	\N
3	Final Test	2025-12-01 04:51:49.345159+00	60	10	t	2025-12-01 04:39:49.351255+00	2025-12-01 04:39:49.351285+00	4	\N
4	Test Notification	2025-12-01 05:00:35.898133+00	60	10	t	2025-12-01 04:48:35.898673+00	2025-12-01 04:48:35.898682+00	4	\N
\.


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

COPY public.timetable_timetable (id, day_of_week, start_time, end_time, location, notes, is_active, created_at, updated_at, course_id, lesson_id, teacher_id) FROM stdin;
\.


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

COPY public.timetable_timetablenotification (id, notification_type, message, send_to_students, send_to_teachers, sent_at, is_sent, created_at, timetable_entry_id) FROM stdin;
\.


--
-- Name: academics_course_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

SELECT pg_catalog.setval('public.academics_course_id_seq', 11, true);


--
-- Name: academics_enrollment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

SELECT pg_catalog.setval('public.academics_enrollment_id_seq', 300, true);


--
-- Name: academics_lesson_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

SELECT pg_catalog.setval('public.academics_lesson_id_seq', 100, true);


--
-- Name: academics_lessonchecklistitem_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

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


--
-- Name: academics_lessonprogress_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

SELECT pg_catalog.setval('public.academics_lessonprogress_id_seq', 102, true);


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

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


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

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


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

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


--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

SELECT pg_catalog.setval('public.auth_user_groups_id_seq', 220, true);


--
-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

SELECT pg_catalog.setval('public.auth_user_id_seq', 225, true);


--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

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


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

SELECT pg_catalog.setval('public.django_admin_log_id_seq', 152, true);


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

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: scms_admin
--

SELECT pg_catalog.setval('public.django_celery_beat_crontabschedule_id_seq', 2, true);


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

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: scms_admin
--

SELECT pg_catalog.setval('public.django_celery_beat_periodictask_id_seq', 2, true);


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

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: scms_admin
--

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


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

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


--
-- Name: notifications_notificationdelivery_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

SELECT pg_catalog.setval('public.notifications_notificationdelivery_id_seq', 489, true);


--
-- Name: notifications_notificationpreference_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

SELECT pg_catalog.setval('public.notifications_notificationpreference_id_seq', 100, true);


--
-- Name: notifications_notificationschedule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

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


--
-- Name: notifications_notificationschedule_recipients_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

SELECT pg_catalog.setval('public.notifications_notificationschedule_recipients_id_seq', 400, true);


--
-- Name: notifications_notificationtemplate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

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


--
-- Name: timetable_classsession_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

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


--
-- Name: timetable_timetable_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

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


--
-- Name: timetable_timetablenotification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: scms_admin
--

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


--
-- Name: academics_course academics_course_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_course
    ADD CONSTRAINT academics_course_pkey PRIMARY KEY (id);


--
-- Name: academics_enrollment academics_enrollment_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_enrollment
    ADD CONSTRAINT academics_enrollment_pkey PRIMARY KEY (id);


--
-- Name: academics_enrollment academics_enrollment_student_id_course_id_623a59e2_uniq; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_enrollment
    ADD CONSTRAINT academics_enrollment_student_id_course_id_623a59e2_uniq UNIQUE (student_id, course_id);


--
-- Name: academics_lesson academics_lesson_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_lesson
    ADD CONSTRAINT academics_lesson_pkey PRIMARY KEY (id);


--
-- Name: academics_lessonchecklistitem academics_lessonchecklistitem_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_lessonchecklistitem
    ADD CONSTRAINT academics_lessonchecklistitem_pkey PRIMARY KEY (id);


--
-- Name: academics_lessonprogress academics_lessonprogress_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_lessonprogress
    ADD CONSTRAINT academics_lessonprogress_pkey PRIMARY KEY (id);


--
-- Name: academics_lessonprogress academics_lessonprogress_student_id_lesson_id_key; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_lessonprogress
    ADD CONSTRAINT academics_lessonprogress_student_id_lesson_id_key UNIQUE (student_id, lesson_id);


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

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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


--
-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_user_id_group_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_group_id_94350c0c_uniq UNIQUE (user_id, group_id);


--
-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_14a6b632_uniq UNIQUE (user_id, permission_id);


--
-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


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

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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


--
-- Name: notifications_notificationschedule_recipients notifications_notificati_notificationschedule_id__a3e81d11_uniq; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationschedule_recipients
    ADD CONSTRAINT notifications_notificati_notificationschedule_id__a3e81d11_uniq UNIQUE (notificationschedule_id, user_id);


--
-- Name: notifications_notificationdelivery notifications_notificati_schedule_id_recipient_id_94864b76_uniq; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationdelivery
    ADD CONSTRAINT notifications_notificati_schedule_id_recipient_id_94864b76_uniq UNIQUE (schedule_id, recipient_id, channel);


--
-- Name: notifications_notificationdelivery notifications_notificationdelivery_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationdelivery
    ADD CONSTRAINT notifications_notificationdelivery_pkey PRIMARY KEY (id);


--
-- Name: notifications_notificationpreference notifications_notificationpreference_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationpreference
    ADD CONSTRAINT notifications_notificationpreference_pkey PRIMARY KEY (id);


--
-- Name: notifications_notificationpreference notifications_notificationpreference_user_id_key; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationpreference
    ADD CONSTRAINT notifications_notificationpreference_user_id_key UNIQUE (user_id);


--
-- Name: notifications_notificationschedule notifications_notificationschedule_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationschedule
    ADD CONSTRAINT notifications_notificationschedule_pkey PRIMARY KEY (id);


--
-- Name: notifications_notificationschedule_recipients notifications_notificationschedule_recipients_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationschedule_recipients
    ADD CONSTRAINT notifications_notificationschedule_recipients_pkey PRIMARY KEY (id);


--
-- Name: notifications_notificationtemplate notifications_notificationtemplate_name_key; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationtemplate
    ADD CONSTRAINT notifications_notificationtemplate_name_key UNIQUE (name);


--
-- Name: notifications_notificationtemplate notifications_notificationtemplate_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationtemplate
    ADD CONSTRAINT notifications_notificationtemplate_pkey PRIMARY KEY (id);


--
-- Name: timetable_classsession timetable_classsession_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.timetable_classsession
    ADD CONSTRAINT timetable_classsession_pkey PRIMARY KEY (id);


--
-- Name: timetable_timetable timetable_timetable_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.timetable_timetable
    ADD CONSTRAINT timetable_timetable_pkey PRIMARY KEY (id);


--
-- Name: timetable_timetablenotification timetable_timetablenotification_pkey; Type: CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.timetable_timetablenotification
    ADD CONSTRAINT timetable_timetablenotification_pkey PRIMARY KEY (id);


--
-- Name: academics_enrollment_course_id_9ed2e9a1; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX academics_enrollment_course_id_9ed2e9a1 ON public.academics_enrollment USING btree (course_id);


--
-- Name: academics_enrollment_student_id_b0ee2adf; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX academics_enrollment_student_id_b0ee2adf ON public.academics_enrollment USING btree (student_id);


--
-- Name: academics_lesson_course_id_f335c036; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX academics_lesson_course_id_f335c036 ON public.academics_lesson USING btree (course_id);


--
-- Name: academics_lessonchecklistitem_lesson_id_1f580d6a; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX academics_lessonchecklistitem_lesson_id_1f580d6a ON public.academics_lessonchecklistitem USING btree (lesson_id);


--
-- Name: academics_lessonprogress_lesson_id_idx; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX academics_lessonprogress_lesson_id_idx ON public.academics_lessonprogress USING btree (lesson_id);


--
-- Name: academics_lessonprogress_student_id_idx; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX academics_lessonprogress_student_id_idx ON public.academics_lessonprogress USING btree (student_id);


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

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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


--
-- Name: auth_user_groups_group_id_97559544; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX auth_user_groups_group_id_97559544 ON public.auth_user_groups USING btree (group_id);


--
-- Name: auth_user_groups_user_id_6a12ed8b; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX auth_user_groups_user_id_6a12ed8b ON public.auth_user_groups USING btree (user_id);


--
-- Name: auth_user_user_permissions_permission_id_1fbb5f2c; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON public.auth_user_user_permissions USING btree (permission_id);


--
-- Name: auth_user_user_permissions_user_id_a95ead1b; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX auth_user_user_permissions_user_id_a95ead1b ON public.auth_user_user_permissions USING btree (user_id);


--
-- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX auth_user_username_6821ab7c_like ON public.auth_user USING btree (username varchar_pattern_ops);


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

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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


--
-- Name: notificatio_schedul_b03cb8_idx; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notificatio_schedul_b03cb8_idx ON public.notifications_notificationschedule USING btree (scheduled_for, sent);


--
-- Name: notificatio_status_1e9b53_idx; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notificatio_status_1e9b53_idx ON public.notifications_notificationdelivery USING btree (status, created_at);


--
-- Name: notifications_notification_notificationschedule_id_2d0cbc7d; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notification_notificationschedule_id_2d0cbc7d ON public.notifications_notificationschedule_recipients USING btree (notificationschedule_id);


--
-- Name: notifications_notificationdelivery_recipient_id_25a85803; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notificationdelivery_recipient_id_25a85803 ON public.notifications_notificationdelivery USING btree (recipient_id);


--
-- Name: notifications_notificationdelivery_schedule_id_6052b63d; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notificationdelivery_schedule_id_6052b63d ON public.notifications_notificationdelivery USING btree (schedule_id);


--
-- Name: notifications_notificationdelivery_status_4649228b; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notificationdelivery_status_4649228b ON public.notifications_notificationdelivery USING btree (status);


--
-- Name: notifications_notificationdelivery_status_4649228b_like; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notificationdelivery_status_4649228b_like ON public.notifications_notificationdelivery USING btree (status varchar_pattern_ops);


--
-- Name: notifications_notificationschedule_content_type_id_b402d88b; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notificationschedule_content_type_id_b402d88b ON public.notifications_notificationschedule USING btree (content_type_id);


--
-- Name: notifications_notificationschedule_recipients_user_id_9a0527c8; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notificationschedule_recipients_user_id_9a0527c8 ON public.notifications_notificationschedule_recipients USING btree (user_id);


--
-- Name: notifications_notificationschedule_scheduled_for_6e4528ab; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notificationschedule_scheduled_for_6e4528ab ON public.notifications_notificationschedule USING btree (scheduled_for);


--
-- Name: notifications_notificationschedule_sent_66a80108; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notificationschedule_sent_66a80108 ON public.notifications_notificationschedule USING btree (sent);


--
-- Name: notifications_notificationschedule_template_id_a700e801; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notificationschedule_template_id_a700e801 ON public.notifications_notificationschedule USING btree (template_id);


--
-- Name: notifications_notificationtemplate_name_427721ce_like; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX notifications_notificationtemplate_name_427721ce_like ON public.notifications_notificationtemplate USING btree (name varchar_pattern_ops);


--
-- Name: timetable_classsession_course_id_077b6426; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX timetable_classsession_course_id_077b6426 ON public.timetable_classsession USING btree (course_id);


--
-- Name: timetable_classsession_lesson_id_1fdbd18e; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX timetable_classsession_lesson_id_1fdbd18e ON public.timetable_classsession USING btree (lesson_id);


--
-- Name: timetable_timetable_course_id_a666e058; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX timetable_timetable_course_id_a666e058 ON public.timetable_timetable USING btree (course_id);


--
-- Name: timetable_timetable_lesson_id_1e249502; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX timetable_timetable_lesson_id_1e249502 ON public.timetable_timetable USING btree (lesson_id);


--
-- Name: timetable_timetable_teacher_id_baef13cc; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX timetable_timetable_teacher_id_baef13cc ON public.timetable_timetable USING btree (teacher_id);


--
-- Name: timetable_timetablenotification_timetable_entry_id_17330bf3; Type: INDEX; Schema: public; Owner: scms_admin
--

CREATE INDEX timetable_timetablenotification_timetable_entry_id_17330bf3 ON public.timetable_timetablenotification USING btree (timetable_entry_id);


--
-- Name: academics_course academics_course_teacher_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_course
    ADD CONSTRAINT academics_course_teacher_id_fkey FOREIGN KEY (teacher_id) REFERENCES public.auth_user(id) ON DELETE SET NULL;


--
-- Name: academics_enrollment academics_enrollment_course_id_9ed2e9a1_fk_academics_course_id; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_enrollment
    ADD CONSTRAINT academics_enrollment_course_id_9ed2e9a1_fk_academics_course_id FOREIGN KEY (course_id) REFERENCES public.academics_course(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: academics_enrollment academics_enrollment_student_id_b0ee2adf_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_enrollment
    ADD CONSTRAINT academics_enrollment_student_id_b0ee2adf_fk_auth_user_id FOREIGN KEY (student_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: academics_lesson academics_lesson_course_id_f335c036_fk_academics_course_id; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_lesson
    ADD CONSTRAINT academics_lesson_course_id_f335c036_fk_academics_course_id FOREIGN KEY (course_id) REFERENCES public.academics_course(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: academics_lessonchecklistitem academics_lessonchec_lesson_id_1f580d6a_fk_academics; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_lessonchecklistitem
    ADD CONSTRAINT academics_lessonchec_lesson_id_1f580d6a_fk_academics FOREIGN KEY (lesson_id) REFERENCES public.academics_lesson(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: academics_lessonprogress academics_lessonprogress_lesson_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_lessonprogress
    ADD CONSTRAINT academics_lessonprogress_lesson_id_fkey FOREIGN KEY (lesson_id) REFERENCES public.academics_lesson(id) ON DELETE CASCADE;


--
-- Name: academics_lessonprogress academics_lessonprogress_student_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.academics_lessonprogress
    ADD CONSTRAINT academics_lessonprogress_student_id_fkey FOREIGN KEY (student_id) REFERENCES public.auth_user(id) ON DELETE CASCADE;


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

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: scms_admin
--

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: scms_admin
--

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: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

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


--
-- Name: auth_user_groups auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

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


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


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

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_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: scms_admin
--

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: notifications_notificationschedule notifications_notifi_content_type_id_b402d88b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

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


--
-- Name: notifications_notificationschedule_recipients notifications_notifi_notificationschedule_2d0cbc7d_fk_notificat; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationschedule_recipients
    ADD CONSTRAINT notifications_notifi_notificationschedule_2d0cbc7d_fk_notificat FOREIGN KEY (notificationschedule_id) REFERENCES public.notifications_notificationschedule(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: notifications_notificationdelivery notifications_notifi_recipient_id_25a85803_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationdelivery
    ADD CONSTRAINT notifications_notifi_recipient_id_25a85803_fk_auth_user FOREIGN KEY (recipient_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: notifications_notificationdelivery notifications_notifi_schedule_id_6052b63d_fk_notificat; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationdelivery
    ADD CONSTRAINT notifications_notifi_schedule_id_6052b63d_fk_notificat FOREIGN KEY (schedule_id) REFERENCES public.notifications_notificationschedule(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: notifications_notificationschedule notifications_notifi_template_id_a700e801_fk_notificat; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationschedule
    ADD CONSTRAINT notifications_notifi_template_id_a700e801_fk_notificat FOREIGN KEY (template_id) REFERENCES public.notifications_notificationtemplate(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: notifications_notificationpreference notifications_notifi_user_id_7cfb3d3a_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationpreference
    ADD CONSTRAINT notifications_notifi_user_id_7cfb3d3a_fk_auth_user FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: notifications_notificationschedule_recipients notifications_notifi_user_id_9a0527c8_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.notifications_notificationschedule_recipients
    ADD CONSTRAINT notifications_notifi_user_id_9a0527c8_fk_auth_user FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: timetable_classsession timetable_classsessi_course_id_077b6426_fk_academics; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.timetable_classsession
    ADD CONSTRAINT timetable_classsessi_course_id_077b6426_fk_academics FOREIGN KEY (course_id) REFERENCES public.academics_course(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: timetable_classsession timetable_classsessi_lesson_id_1fdbd18e_fk_academics; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.timetable_classsession
    ADD CONSTRAINT timetable_classsessi_lesson_id_1fdbd18e_fk_academics FOREIGN KEY (lesson_id) REFERENCES public.academics_lesson(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: timetable_timetable timetable_timetable_course_id_a666e058_fk_academics_course_id; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.timetable_timetable
    ADD CONSTRAINT timetable_timetable_course_id_a666e058_fk_academics_course_id FOREIGN KEY (course_id) REFERENCES public.academics_course(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: timetable_timetable timetable_timetable_lesson_id_1e249502_fk_academics_lesson_id; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.timetable_timetable
    ADD CONSTRAINT timetable_timetable_lesson_id_1e249502_fk_academics_lesson_id FOREIGN KEY (lesson_id) REFERENCES public.academics_lesson(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: timetable_timetable timetable_timetable_teacher_id_baef13cc_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.timetable_timetable
    ADD CONSTRAINT timetable_timetable_teacher_id_baef13cc_fk_auth_user_id FOREIGN KEY (teacher_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: timetable_timetablenotification timetable_timetablen_timetable_entry_id_17330bf3_fk_timetable; Type: FK CONSTRAINT; Schema: public; Owner: scms_admin
--

ALTER TABLE ONLY public.timetable_timetablenotification
    ADD CONSTRAINT timetable_timetablen_timetable_entry_id_17330bf3_fk_timetable FOREIGN KEY (timetable_entry_id) REFERENCES public.timetable_timetable(id) DEFERRABLE INITIALLY DEFERRED;


--
-- PostgreSQL database dump complete
--

\unrestrict palVs49ZeXZ1Ae1ed3qJRWURA84t7uRpAUeFKlFnZxOFJsrMSJd6nXjoMKOEcQs