--
--


SET transaction_timeout = 0;
SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: public; Type: SCHEMA; Schema: -; Owner: Anup
--

-- *not* creating schema, since initdb creates it


ALTER SCHEMA public OWNER TO "Anup";

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: Anup
--

COMMENT ON SCHEMA public IS '';


--
-- Name: AssignmentStatus; Type: TYPE; Schema: public; Owner: Anup
--

CREATE TYPE public."AssignmentStatus" AS ENUM (
    'submitted',
    'graded',
    'pending'
);


ALTER TYPE public."AssignmentStatus" OWNER TO "Anup";

--
-- Name: AttendanceStatus; Type: TYPE; Schema: public; Owner: Anup
--

CREATE TYPE public."AttendanceStatus" AS ENUM (
    'present',
    'absent'
);


ALTER TYPE public."AttendanceStatus" OWNER TO "Anup";

--
-- Name: EnrollmentStatus; Type: TYPE; Schema: public; Owner: Anup
--

CREATE TYPE public."EnrollmentStatus" AS ENUM (
    'pending',
    'active',
    'expired',
    'cancelled'
);


ALTER TYPE public."EnrollmentStatus" OWNER TO "Anup";

--
-- Name: Gateway; Type: TYPE; Schema: public; Owner: Anup
--

CREATE TYPE public."Gateway" AS ENUM (
    'khalti',
    'esewa',
    'stripe',
    'paypal',
    'cash'
);


ALTER TYPE public."Gateway" OWNER TO "Anup";

--
-- Name: PaymentStatus; Type: TYPE; Schema: public; Owner: Anup
--

CREATE TYPE public."PaymentStatus" AS ENUM (
    'pending',
    'paid',
    'failed'
);


ALTER TYPE public."PaymentStatus" OWNER TO "Anup";

--
-- Name: Role; Type: TYPE; Schema: public; Owner: Anup
--

CREATE TYPE public."Role" AS ENUM (
    'admin',
    'teacher',
    'student',
    'accountant'
);


ALTER TYPE public."Role" OWNER TO "Anup";



--
-- Name: Assignment; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."Assignment" (
    id integer NOT NULL,
    title text NOT NULL,
    description text,
    "fileUrl" text,
    "dueDate" timestamp(3) without time zone NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "subjectId" integer NOT NULL,
    "teacherId" integer NOT NULL,
    "fileSize" integer,
    "fileType" text,
    "lessonId" integer
);


ALTER TABLE public."Assignment" OWNER TO "Anup";

--
-- Name: Assignment_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."Assignment_id_seq" OWNER TO "Anup";

--
-- Name: Assignment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."Assignment_id_seq" OWNED BY public."Assignment".id;


--
-- Name: Attendance; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."Attendance" (
    id integer NOT NULL,
    status public."AttendanceStatus" DEFAULT 'present'::public."AttendanceStatus" NOT NULL,
    "timestamp" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "classId" integer NOT NULL,
    "studentId" integer NOT NULL
);


ALTER TABLE public."Attendance" OWNER TO "Anup";

--
-- Name: Attendance_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."Attendance_id_seq" OWNER TO "Anup";

--
-- Name: Attendance_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."Attendance_id_seq" OWNED BY public."Attendance".id;


--
-- Name: ContactMessage; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."ContactMessage" (
    id integer NOT NULL,
    name text NOT NULL,
    email text NOT NULL,
    message text NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public."ContactMessage" OWNER TO "Anup";

--
-- Name: ContactMessage_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."ContactMessage_id_seq" OWNER TO "Anup";

--
-- Name: ContactMessage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."ContactMessage_id_seq" OWNED BY public."ContactMessage".id;


--
-- Name: Enrollment; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."Enrollment" (
    id integer NOT NULL,
    "studentId" integer NOT NULL,
    "subjectId" integer NOT NULL,
    status public."EnrollmentStatus" DEFAULT 'active'::public."EnrollmentStatus" NOT NULL,
    "startAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "expiresAt" timestamp(3) without time zone,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public."Enrollment" OWNER TO "Anup";

--
-- Name: Enrollment_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."Enrollment_id_seq" OWNER TO "Anup";

--
-- Name: Enrollment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."Enrollment_id_seq" OWNED BY public."Enrollment".id;


--
-- Name: Lesson; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."Lesson" (
    id integer NOT NULL,
    title text NOT NULL,
    "videoUrl" text,
    "pdfUrl" text,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "subjectId" integer NOT NULL,
    "teacherId" integer NOT NULL,
    description text NOT NULL,
    "thumbnailUrl" text,
    views integer DEFAULT 0 NOT NULL,
    "videoDurationSeconds" integer
);


ALTER TABLE public."Lesson" OWNER TO "Anup";

--
-- Name: LessonProgress; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."LessonProgress" (
    id integer NOT NULL,
    "studentId" integer NOT NULL,
    "lessonId" integer NOT NULL,
    "videoWatchedSeconds" integer DEFAULT 0,
    "videoCompleted" boolean DEFAULT false,
    "assignmentCompleted" boolean DEFAULT false,
    "pdfViewed" boolean DEFAULT false,
    completed boolean DEFAULT false,
    "updatedAt" timestamp(3) without time zone NOT NULL
);


ALTER TABLE public."LessonProgress" OWNER TO "Anup";

--
-- Name: LessonProgress_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."LessonProgress_id_seq" OWNER TO "Anup";

--
-- Name: LessonProgress_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."LessonProgress_id_seq" OWNED BY public."LessonProgress".id;


--
-- Name: Lesson_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."Lesson_id_seq" OWNER TO "Anup";

--
-- Name: Lesson_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."Lesson_id_seq" OWNED BY public."Lesson".id;


--
-- Name: LiveClass; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."LiveClass" (
    id integer NOT NULL,
    "startTime" timestamp(3) without time zone NOT NULL,
    "endTime" timestamp(3) without time zone,
    "meetingUrl" text,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "subjectId" integer NOT NULL,
    "teacherId" integer NOT NULL
);


ALTER TABLE public."LiveClass" OWNER TO "Anup";

--
-- Name: LiveClass_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."LiveClass_id_seq" OWNER TO "Anup";

--
-- Name: LiveClass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."LiveClass_id_seq" OWNED BY public."LiveClass".id;


--
-- Name: Message; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."Message" (
    id integer NOT NULL,
    content text NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "senderId" integer NOT NULL,
    "receiverId" integer NOT NULL
);


ALTER TABLE public."Message" OWNER TO "Anup";

--
-- Name: Message_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."Message_id_seq" OWNER TO "Anup";

--
-- Name: Message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."Message_id_seq" OWNED BY public."Message".id;


--
-- Name: Notification; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."Notification" (
    id integer NOT NULL,
    message text NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "isRead" boolean DEFAULT false NOT NULL,
    "userId" integer NOT NULL
);


ALTER TABLE public."Notification" OWNER TO "Anup";

--
-- Name: Notification_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."Notification_id_seq" OWNER TO "Anup";

--
-- Name: Notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."Notification_id_seq" OWNED BY public."Notification".id;


--
-- Name: Payment; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."Payment" (
    id integer NOT NULL,
    amount integer NOT NULL,
    status public."PaymentStatus" DEFAULT 'pending'::public."PaymentStatus" NOT NULL,
    gateway public."Gateway" NOT NULL,
    "transactionId" text,
    "paidAt" timestamp(3) without time zone,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "studentId" integer NOT NULL,
    "subjectId" integer NOT NULL
);


ALTER TABLE public."Payment" OWNER TO "Anup";

--
-- Name: PaymentGatewaySettings; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."PaymentGatewaySettings" (
    id integer NOT NULL,
    service text NOT NULL,
    wallet text NOT NULL,
    "qrBaseUrl" text,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL
);


ALTER TABLE public."PaymentGatewaySettings" OWNER TO "Anup";

--
-- Name: PaymentGatewaySettings_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."PaymentGatewaySettings_id_seq" OWNER TO "Anup";

--
-- Name: PaymentGatewaySettings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."PaymentGatewaySettings_id_seq" OWNED BY public."PaymentGatewaySettings".id;


--
-- Name: PaymentRequest; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."PaymentRequest" (
    id integer NOT NULL,
    "txnId" character varying(255) NOT NULL,
    "studentId" integer NOT NULL,
    "subjectId" integer NOT NULL,
    amount integer NOT NULL,
    status character varying(20) DEFAULT 'pending'::character varying,
    "proofImage" text,
    "createdAt" timestamp(6) without time zone DEFAULT CURRENT_TIMESTAMP,
    "approvedAt" timestamp(6) without time zone
);


ALTER TABLE public."PaymentRequest" OWNER TO "Anup";

--
-- Name: PaymentRequest_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."PaymentRequest_id_seq" OWNER TO "Anup";

--
-- Name: PaymentRequest_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."PaymentRequest_id_seq" OWNED BY public."PaymentRequest".id;


--
-- Name: Payment_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."Payment_id_seq" OWNER TO "Anup";

--
-- Name: Payment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."Payment_id_seq" OWNED BY public."Payment".id;


--
-- Name: Salary; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."Salary" (
    id integer NOT NULL,
    amount integer NOT NULL,
    month text NOT NULL,
    status text DEFAULT 'pending'::text NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "teacherId" integer NOT NULL
);


ALTER TABLE public."Salary" OWNER TO "Anup";

--
-- Name: Salary_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."Salary_id_seq" OWNER TO "Anup";

--
-- Name: Salary_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."Salary_id_seq" OWNED BY public."Salary".id;


--
-- Name: Subject; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."Subject" (
    id integer NOT NULL,
    title text NOT NULL,
    description text,
    price integer DEFAULT 0 NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "teacherId" integer NOT NULL
);


ALTER TABLE public."Subject" OWNER TO "Anup";

--
-- Name: Subject_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."Subject_id_seq" OWNER TO "Anup";

--
-- Name: Subject_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."Subject_id_seq" OWNED BY public."Subject".id;


--
-- Name: Submission; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."Submission" (
    id integer NOT NULL,
    "fileUrl" text,
    marks integer,
    status public."AssignmentStatus" DEFAULT 'pending'::public."AssignmentStatus" NOT NULL,
    "assignmentId" integer NOT NULL,
    "studentId" integer NOT NULL,
    "submittedAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    feedback text,
    "gradedAt" timestamp(3) without time zone
);


ALTER TABLE public."Submission" OWNER TO "Anup";

--
-- Name: Submission_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."Submission_id_seq" OWNER TO "Anup";

--
-- Name: Submission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."Submission_id_seq" OWNED BY public."Submission".id;


--
-- Name: User; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public."User" (
    id integer NOT NULL,
    "firstName" text NOT NULL,
    "lastName" text NOT NULL,
    email text NOT NULL,
    phone text,
    password text NOT NULL,
    role public."Role" DEFAULT 'student'::public."Role" NOT NULL,
    status text DEFAULT 'pending'::text,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "resetToken" text,
    "resetTokenExpiry" timestamp(3) without time zone,
    "refreshToken" text,
    "refreshTokenExpiresAt" timestamp(3) without time zone,
    "esewaNumber" text,
    "lastLogin" timestamp(3) without time zone,
    "lastActivity" timestamp(3) without time zone
);


ALTER TABLE public."User" OWNER TO "Anup";

--
-- Name: User_id_seq; Type: SEQUENCE; Schema: public; Owner: Anup
--

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


ALTER SEQUENCE public."User_id_seq" OWNER TO "Anup";

--
-- Name: User_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: Anup
--

ALTER SEQUENCE public."User_id_seq" OWNED BY public."User".id;


--
-- Name: _prisma_migrations; Type: TABLE; Schema: public; Owner: Anup
--

CREATE TABLE public._prisma_migrations (
    id character varying(36) NOT NULL,
    checksum character varying(64) NOT NULL,
    finished_at timestamp with time zone,
    migration_name character varying(255) NOT NULL,
    logs text,
    rolled_back_at timestamp with time zone,
    started_at timestamp with time zone DEFAULT now() NOT NULL,
    applied_steps_count integer DEFAULT 0 NOT NULL
);


ALTER TABLE public._prisma_migrations OWNER TO "Anup";

--
-- Name: Assignment id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Assignment" ALTER COLUMN id SET DEFAULT nextval('public."Assignment_id_seq"'::regclass);


--
-- Name: Attendance id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Attendance" ALTER COLUMN id SET DEFAULT nextval('public."Attendance_id_seq"'::regclass);


--
-- Name: ContactMessage id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."ContactMessage" ALTER COLUMN id SET DEFAULT nextval('public."ContactMessage_id_seq"'::regclass);


--
-- Name: Enrollment id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Enrollment" ALTER COLUMN id SET DEFAULT nextval('public."Enrollment_id_seq"'::regclass);


--
-- Name: Lesson id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Lesson" ALTER COLUMN id SET DEFAULT nextval('public."Lesson_id_seq"'::regclass);


--
-- Name: LessonProgress id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."LessonProgress" ALTER COLUMN id SET DEFAULT nextval('public."LessonProgress_id_seq"'::regclass);


--
-- Name: LiveClass id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."LiveClass" ALTER COLUMN id SET DEFAULT nextval('public."LiveClass_id_seq"'::regclass);


--
-- Name: Message id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Message" ALTER COLUMN id SET DEFAULT nextval('public."Message_id_seq"'::regclass);


--
-- Name: Notification id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Notification" ALTER COLUMN id SET DEFAULT nextval('public."Notification_id_seq"'::regclass);


--
-- Name: Payment id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Payment" ALTER COLUMN id SET DEFAULT nextval('public."Payment_id_seq"'::regclass);


--
-- Name: PaymentGatewaySettings id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."PaymentGatewaySettings" ALTER COLUMN id SET DEFAULT nextval('public."PaymentGatewaySettings_id_seq"'::regclass);


--
-- Name: PaymentRequest id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."PaymentRequest" ALTER COLUMN id SET DEFAULT nextval('public."PaymentRequest_id_seq"'::regclass);


--
-- Name: Salary id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Salary" ALTER COLUMN id SET DEFAULT nextval('public."Salary_id_seq"'::regclass);


--
-- Name: Subject id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Subject" ALTER COLUMN id SET DEFAULT nextval('public."Subject_id_seq"'::regclass);


--
-- Name: Submission id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Submission" ALTER COLUMN id SET DEFAULT nextval('public."Submission_id_seq"'::regclass);


--
-- Name: User id; Type: DEFAULT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."User" ALTER COLUMN id SET DEFAULT nextval('public."User_id_seq"'::regclass);


--
-- Data for Name: Assignment; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."Assignment" (id, title, description, "fileUrl", "dueDate", "createdAt", "subjectId", "teacherId", "fileSize", "fileType", "lessonId") FROM stdin;
1	aerfg	gdfgfgfg	https://res.cloudinary.com/dvck3axc5/image/upload/v1765698719/lms_lessons/lesson_1765698715947.pdf	2025-12-13 18:15:00	2025-12-14 07:52:00.288	1	3	646770	application/pdf	21
2	Introduction to TypeScript	`This assignment focuses on mastering the fundamentals of TypeScript. You are required to:\r\n\r\nDefine and use basic types: Create variables using string, number, boolean, and array types.\r\n\r\nImplement interfaces and types: Design at least two interfaces and one type alias to model real-world objects.\r\n\r\nUse classes and inheritance: Implement a class hierarchy demonstrating inheritance, encapsulation, and access modifiers.\r\n\r\nGenerics: Create a generic function or class to handle different data types.\r\n\r\nError handling: Implement proper error handling using try-catch blocks where necessary.\r\n\r\nYour submission should include:\r\n\r\nA .ts file or a zipped folder containing all your TypeScript code.\r\n\r\nComments explaining each section of your code.\r\n\r\nScreenshots demonstrating that your code compiles without errors.\r\n\r\nDeadline: Please submit your assignment before the due date. Late submissions may incur a deduction of marks.`	https://res.cloudinary.com/dvck3axc5/image/upload/v1765739372/lms_lessons/lesson_1765739370773.pdf	2025-12-17 18:15:00	2025-12-14 19:09:34.272	1	3	646770	application/pdf	22
3	Introduction to React	This assignment covers the fundamentals of React. You are required to create a simple To-Do application using React components. The app should include the following features:\r\n\r\nAdd new tasks.\r\n\r\nRemove tasks.\r\n\r\nMark tasks as completed.\r\n\r\nMaintain the task list state using React useState hook.\r\n\r\nSubmission Instructions:\r\n\r\nPackage your React project into a ZIP file.\r\n\r\nInclude a README file describing how to run your project.\r\n\r\nSubmit the ZIP file through the assignment submission portal.	https://res.cloudinary.com/dvck3axc5/image/upload/v1765816438/lms_lessons/lesson_1765816437612.pdf	2025-12-17 18:15:00	2025-12-15 16:34:00.925	1	3	128581	application/pdf	22
5	hiufadehiosad	dshuijhsdai	https://res.cloudinary.com/dvck3axc5/image/upload/v1765967871/lms_lessons/lesson_1765967870942.pdf	2025-12-20 10:35:00	2025-12-17 10:37:55.436	1	3	128581	application/pdf	23
6	huygdyu	hsuaiasuia	https://res.cloudinary.com/dvck3axc5/image/upload/v1765968531/lms_lessons/lesson_1765968528998.pdf	2025-12-19 18:30:00	2025-12-17 10:48:55.235	1	3	128581	application/pdf	24
7	jdheuids	hcsdhvhds	https://res.cloudinary.com/dvck3axc5/image/upload/v1766028672/lms_lessons/lesson_1766028673581.pdf	2025-12-19 22:15:00	2025-12-18 03:31:17.833	2	3	128581	application/pdf	25
8	njidshisa	dsck bjkx	https://res.cloudinary.com/dvck3axc5/image/upload/v1766029004/lms_lessons/lesson_1766029004149.pdf	2025-12-18 18:35:00	2025-12-18 03:36:49.42	2	3	128581	application/pdf	25
9	jhqijfhfiusd	 njcsbuis	https://res.cloudinary.com/dvck3axc5/image/upload/v1766029187/lms_lessons/lesson_1766029187810.pdf	2025-12-19 23:15:00	2025-12-18 03:39:52.848	2	3	128581	application/pdf	25
10	yudegys	sdjbjscdh	https://res.cloudinary.com/dvck3axc5/image/upload/v1766029339/lms_lessons/lesson_1766029340392.pdf	2025-12-19 18:40:00	2025-12-18 03:42:24.52	2	3	128581	application/pdf	25
11	yudegys	sdjbjscdh	https://res.cloudinary.com/dvck3axc5/image/upload/v1766029341/lms_lessons/lesson_1766029343187.pdf	2025-12-19 18:40:00	2025-12-18 03:42:26.659	2	3	128581	application/pdf	25
12	;hnduihdsui	cjnsishios	https://res.cloudinary.com/dvck3axc5/image/upload/v1766030481/lms_lessons/lesson_1766030481798.pdf	2025-12-19 18:15:00	2025-12-18 04:01:26.474	2	3	128581	application/pdf	26
13	 xcBhsz	bdsguysa	https://res.cloudinary.com/dvck3axc5/image/upload/v1766047112/lms_lessons/lesson_1766047111872.pdf	2025-12-18 03:15:00	2025-12-18 08:38:36.751	2	3	128581	application/pdf	26
\.


--
-- Data for Name: Attendance; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."Attendance" (id, status, "timestamp", "classId", "studentId") FROM stdin;
1	absent	2025-12-16 07:53:23.503	1	5
2	absent	2025-12-16 07:53:23.503	1	4
3	absent	2025-12-16 08:17:04.961	2	5
4	absent	2025-12-16 08:17:04.961	2	4
5	absent	2025-12-16 09:17:16.368	3	5
6	absent	2025-12-16 09:17:16.368	3	4
7	absent	2025-12-16 09:26:32.383	4	5
8	absent	2025-12-16 09:26:32.383	4	4
9	absent	2025-12-16 09:26:49.581	5	5
10	absent	2025-12-16 09:26:49.581	5	4
11	absent	2025-12-16 09:27:19.545	6	5
12	absent	2025-12-16 09:27:19.545	6	4
13	absent	2025-12-16 09:27:34.882	7	5
14	absent	2025-12-16 09:27:34.882	7	4
15	absent	2025-12-16 09:29:33.826	8	5
16	absent	2025-12-16 09:29:33.826	8	4
17	absent	2025-12-16 10:38:11.333	9	4
18	absent	2025-12-16 10:39:02.808	10	4
19	absent	2025-12-16 16:44:20.875	11	4
20	absent	2025-12-16 16:44:56.104	12	4
21	absent	2025-12-17 10:51:43.657	13	4
22	absent	2025-12-18 10:15:23.395	14	4
23	absent	2025-12-18 17:41:38.141	15	4
\.


--
-- Data for Name: ContactMessage; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."ContactMessage" (id, name, email, message, "createdAt") FROM stdin;
\.


--
-- Data for Name: Enrollment; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."Enrollment" (id, "studentId", "subjectId", status, "startAt", "expiresAt", "createdAt") FROM stdin;
1	4	3	active	2025-12-09 17:21:54.943	\N	2025-12-09 17:21:54.953
2	4	2	active	2025-12-09 17:22:04.461	\N	2025-12-09 17:22:04.463
3	4	1	active	2025-12-09 17:22:08.341	\N	2025-12-09 17:22:08.342
4	4	11	active	2025-12-10 17:52:13.378	\N	2025-12-10 17:52:13.382
5	4	7	active	2025-12-10 17:52:18.206	\N	2025-12-10 17:52:18.207
6	4	6	active	2025-12-11 10:52:49.992	\N	2025-12-11 10:52:50.032
8	4	5	active	2025-12-12 18:12:05.599	\N	2025-12-12 17:19:05.775
7	4	8	active	2025-12-12 20:16:43.372	\N	2025-12-12 16:53:38.946
15	5	8	active	2025-12-12 20:59:31.263	\N	2025-12-12 20:59:31.264
\.


--
-- Data for Name: Lesson; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."Lesson" (id, title, "videoUrl", "pdfUrl", "createdAt", "updatedAt", "subjectId", "teacherId", description, "thumbnailUrl", views, "videoDurationSeconds") FROM stdin;
1	Lesson 1: Introduction to Computers	https://www.youtube.com/watch?v=O5nskjZ_GoI	https://www.tutorialspoint.com/computer_fundamentals/computer_fundamentals.pdf	2025-12-09 07:43:35.61	2025-12-09 07:43:35.61	1	3	Learn about the history of computers, types of computers, and basic components like CPU, memory, and input/output devices.	http://localhost:8080/uploads/thumbnails/lesson_1765266215587.png	0	\N
2	Lesson 2: Course Overview	https://www.youtube.com/watch?v=abc001	\N	2025-12-13 16:59:26.866	2025-12-13 16:59:26.866	1	3	Understand what this course covers and how to navigate it.	http://localhost:8080/uploads/thumbnails/lesson_1765645166846.png	0	\N
3	Lesson 3: Tools & Setup	https://www.youtube.com/watch?v=abc002	https://example.com/setup.pdf	2025-12-13 16:59:26.916	2025-12-13 16:59:26.916	1	3	Install required tools and configure your development environment.	http://localhost:8080/uploads/thumbnails/lesson_1765645166900.png	0	\N
4	Lesson 4: Basics Concepts	https://www.youtube.com/watch?v=abc003	\N	2025-12-13 16:59:26.951	2025-12-13 16:59:26.951	1	3	Learn the fundamental concepts required for this subject.	http://localhost:8080/uploads/thumbnails/lesson_1765645166929.png	0	\N
5	Lesson 5: First Practical Example	https://www.youtube.com/watch?v=abc004	\N	2025-12-13 16:59:26.985	2025-12-13 16:59:26.985	1	3	Build your first practical example step by step.	http://localhost:8080/uploads/thumbnails/lesson_1765645166962.png	0	\N
6	Lesson 6: Understanding the Workflow	\N	\N	2025-12-13 16:59:27.016	2025-12-13 16:59:27.016	1	3	Learn the complete workflow used in real-world projects.	http://localhost:8080/uploads/thumbnails/lesson_1765645166997.png	0	\N
7	Lesson 7: Common Mistakes	\N	\N	2025-12-13 16:59:27.065	2025-12-13 16:59:27.065	1	3	Avoid common beginner mistakes and learn best practices.	http://localhost:8080/uploads/thumbnails/lesson_1765645167030.png	0	\N
8	Lesson 8: Project Structure	\N	\N	2025-12-13 16:59:27.116	2025-12-13 16:59:27.116	1	3	Understand how to organize files and folders properly.	http://localhost:8080/uploads/thumbnails/lesson_1765645167102.png	0	\N
9	Lesson 9: Working with Data	\N	\N	2025-12-13 16:59:27.154	2025-12-13 16:59:27.154	1	3	Learn how to manage and process data efficiently.	http://localhost:8080/uploads/thumbnails/lesson_1765645167127.png	0	\N
10	Lesson 10: Intermediate Concepts	\N	\N	2025-12-13 16:59:27.193	2025-12-13 16:59:27.193	1	3	Move beyond basics and explore intermediate-level concepts.	http://localhost:8080/uploads/thumbnails/lesson_1765645167173.png	0	\N
11	Lesson 11: Debugging Techniques	\N	\N	2025-12-13 16:59:27.22	2025-12-13 16:59:27.22	1	3	Learn how to debug issues like a professional.	http://localhost:8080/uploads/thumbnails/lesson_1765645167201.png	0	\N
12	Lesson 12: Performance Optimization	\N	\N	2025-12-13 16:59:27.261	2025-12-13 16:59:27.261	1	3	Optimize performance and improve efficiency.	http://localhost:8080/uploads/thumbnails/lesson_1765645167232.png	0	\N
13	Lesson 13: Security Best Practices	\N	\N	2025-12-13 16:59:27.307	2025-12-13 16:59:27.307	1	3	Understand common security risks and how to prevent them.	http://localhost:8080/uploads/thumbnails/lesson_1765645167278.png	0	\N
14	Lesson 14: Mini Project	\N	\N	2025-12-13 16:59:27.359	2025-12-13 16:59:27.359	1	3	Apply what you’ve learned by building a mini project.	http://localhost:8080/uploads/thumbnails/lesson_1765645167323.png	0	\N
15	Lesson 15: Real-world Use Cases	\N	\N	2025-12-13 16:59:27.411	2025-12-13 16:59:27.411	1	3	Explore real-world applications of the concepts.	http://localhost:8080/uploads/thumbnails/lesson_1765645167377.png	0	\N
16	Lesson 16: Final Review & Next Steps	\N	\N	2025-12-13 16:59:27.533	2025-12-13 16:59:27.533	1	3	Summarize the course and learn what to do next.	http://localhost:8080/uploads/thumbnails/lesson_1765645167508.png	0	\N
17	 Lesson 17 : Introduction to Computers	https://www.youtube.com/watch?v=dQw4w9WgXcQ	https://example.com/resources/computer-intro.pdf	2025-12-13 19:12:32.822	2025-12-13 19:12:32.822	1	3	Learn about the history of computers, types of computers, and basic components like CPU, memory, and input/output devices.	http://localhost:8080/uploads/thumbnails/lesson_1765653152450.png	0	214
18	lesson 18	https://www.youtube.com/watch?v=enjkcCdAlXc&list=RDenjkcCdAlXc&start_radio=1	\N	2025-12-14 03:50:48.072	2025-12-14 03:50:48.072	1	3	this is lesson 18 	http://localhost:8080/uploads/thumbnails/lesson_1765684247534.png	0	240
19	hiii	https://www.youtube.com/watch?v=O5nskjZ_GoI	https://www.tutorialspoint.com/computer_fundamentals/computer_fundamentals.pdf	2025-12-14 04:10:38.542	2025-12-14 04:10:38.542	1	3	iiiii	http://localhost:8080/uploads/thumbnails/lesson_1765685438267.png	0	713
20	gdcv	https://www.youtube.com/watch?v=O5nskjZ_GoI	\N	2025-12-14 07:26:30.098	2025-12-14 07:26:30.098	1	3	zxcvgrf	http://localhost:8080/uploads/thumbnails/lesson_1765697189334.png	0	713
21	effDdc	https://www.youtube.com/watch?v=O5nskjZ_GoI	\N	2025-12-14 07:37:41.622	2025-12-14 07:37:41.622	1	3	fsdsdv 	http://localhost:8080/uploads/thumbnails/lesson_1765697860064.png	0	713
22	GSDVv	https://www.youtube.com/watch?v=O5nskjZ_GoI	\N	2025-12-14 08:13:17.471	2025-12-14 08:13:17.471	1	3	vcdfdf	http://localhost:8080/uploads/thumbnails/lesson_1765699997098.png	0	713
23	bjsdjsak	https://www.youtube.com/watch?v=O5nskjZ_GoI	https://www.w3.org/WAI/testfiles/docs/ComputerBasics.pdf	2025-12-17 10:36:21.111	2025-12-17 10:36:21.111	1	3	;nsadjkosia	http://localhost:8080/uploads/thumbnails/lesson_1765967780376.png	0	713
24	jschius	https://www.youtube.com/watch?v=O5nskjZ_GoI	\N	2025-12-17 10:48:10.352	2025-12-17 10:48:10.352	1	3	sjidhisa	http://localhost:8080/uploads/thumbnails/lesson_1765968488718.png	0	713
25	ddsjhbjds	https://www.youtube.com/watch?v=O5nskjZ_GoI	https://www.w3.org/WAI/testfiles/docs/ComputerBasics.pdf	2025-12-18 03:30:33.317	2025-12-18 03:30:33.317	2	3	 cxzhbsj	http://localhost:8080/uploads/thumbnails/lesson_1766028630920.png	0	713
26	jhdwuijds	https://www.youtube.com/watch?v=O5nskjZ_GoI	https://www.w3.org/WAI/testfiles/docs/ComputerBasics.pdf	2025-12-18 04:00:05.894	2025-12-18 04:00:05.894	2	3	bjisadhbuisja	http://localhost:8080/uploads/thumbnails/lesson_1766030405058.png	0	713
\.


--
-- Data for Name: LessonProgress; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."LessonProgress" (id, "studentId", "lessonId", "videoWatchedSeconds", "videoCompleted", "assignmentCompleted", "pdfViewed", completed, "updatedAt") FROM stdin;
2	4	17	214	t	t	t	t	2025-12-14 03:46:26.96
5	4	13	0	f	t	f	f	2025-12-14 03:47:32.098
6	4	16	0	f	t	f	f	2025-12-14 03:47:39.132
8	4	18	240	t	t	f	f	2025-12-14 03:51:15.127
12	4	20	713	t	f	f	f	2025-12-14 07:34:02.332
1	4	1	0	t	f	f	f	2025-12-14 08:18:11.518
13	4	21	713	t	t	f	f	2025-12-14 18:29:38.658
14	4	22	713	t	t	f	f	2025-12-14 19:17:41.665
11	4	19	713	t	f	t	f	2025-12-15 14:06:28.742
46	4	23	713	t	f	t	f	2025-12-17 10:39:41.111
58	4	26	713	t	t	t	f	2025-12-18 04:01:53.06
56	4	25	713	t	t	t	t	2025-12-18 04:03:08.557
\.


--
-- Data for Name: LiveClass; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."LiveClass" (id, "startTime", "endTime", "meetingUrl", "createdAt", "updatedAt", "subjectId", "teacherId") FROM stdin;
1	2025-12-26 07:53:00	2025-12-16 08:11:08.301		2025-12-16 07:53:23.439	2025-12-16 08:11:08.307	1	3
6	2025-12-24 09:27:00	\N	https://meet.google.com/jwi-yyaz-hyy	2025-12-16 09:27:19.541	2025-12-16 09:27:19.541	1	3
7	2025-12-26 09:27:00	\N	https://meet.google.com/jwi-yyaz-hyy	2025-12-16 09:27:34.879	2025-12-16 09:27:34.879	5	3
2	2025-12-16 09:16:00	2025-12-16 09:27:54.285	https://meet.google.com/byq-insu-ovj	2025-12-16 08:17:04.894	2025-12-16 09:27:54.287	1	3
3	2025-12-16 09:23:00	2025-12-16 09:29:38.841	https://meet.google.com/nwf-wfct-hti	2025-12-16 09:17:16.336	2025-12-16 09:29:38.842	1	3
4	2025-12-16 09:41:00	2025-12-16 10:11:18.248	https://meet.google.com/jwi-yyaz-hyy	2025-12-16 09:26:32.361	2025-12-16 10:11:18.25	1	3
10	2025-12-16 10:40:00	2025-12-16 16:55:15.783	https://meet.google.com/vsb-rvgb-aeb	2025-12-16 10:39:02.803	2025-12-16 16:55:15.787	2	3
12	2025-12-16 16:48:00	2025-12-16 16:55:16.997	https://meet.google.com/dmo-zbev-cmk	2025-12-16 16:44:56.088	2025-12-16 16:55:16.998	2	3
11	2025-12-16 16:49:00	2025-12-16 16:55:18.442	https://meet.google.com/dmo-zbev-cmk	2025-12-16 16:44:20.805	2025-12-16 16:55:18.443	10	3
13	2025-12-17 10:54:00	2025-12-17 11:04:22.433	https://meet.google.com/riy-bkbb-rck	2025-12-17 10:51:43.627	2025-12-17 11:04:22.434	1	3
14	2025-12-18 10:19:00	2025-12-18 17:07:36.233	https://meet.google.com/vow-orom-fbs	2025-12-18 10:15:23.324	2025-12-18 17:07:36.234	1	3
9	2025-12-18 10:37:00	2025-12-18 17:07:37.468	https://meet.google.com/vsb-rvgb-aeb	2025-12-16 10:38:11.3	2025-12-18 17:07:37.469	9	3
8	2025-12-18 09:29:00	2025-12-18 17:07:38.644	https://meet.google.com/jwi-yyaz-hyy	2025-12-16 09:29:33.815	2025-12-18 17:07:38.646	1	3
5	2025-12-18 09:26:00	2025-12-18 17:07:39.958	https://meet.google.com/jwi-yyaz-hyy	2025-12-16 09:26:49.576	2025-12-18 17:07:39.959	1	3
15	2025-12-18 17:43:00	2025-12-18 18:07:30.55	https://meet.google.com/ptr-wrqv-xmk	2025-12-18 17:41:38.109	2025-12-18 18:07:30.555	1	3
\.


--
-- Data for Name: Message; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."Message" (id, content, "createdAt", "senderId", "receiverId") FROM stdin;
\.


--
-- Data for Name: Notification; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."Notification" (id, message, "createdAt", "isRead", "userId") FROM stdin;
\.


--
-- Data for Name: Payment; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."Payment" (id, amount, status, gateway, "transactionId", "paidAt", "createdAt", "studentId", "subjectId") FROM stdin;
\.


--
-- Data for Name: PaymentGatewaySettings; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."PaymentGatewaySettings" (id, service, wallet, "qrBaseUrl", "createdAt", "updatedAt") FROM stdin;
\.


--
-- Data for Name: PaymentRequest; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."PaymentRequest" (id, "txnId", "studentId", "subjectId", amount, status, "proofImage", "createdAt", "approvedAt") FROM stdin;
71	ENR-1765384985536-7212	4	2	2000	pending	\N	2025-12-10 16:43:05.538	\N
74	ENR-1765386013616-5489	4	7	799	approved	\N	2025-12-10 17:00:13.617	2025-12-10 17:52:18.209
70	ENR-1765384792375-7420	4	1	2200	pending	/uploads/payment-proofs/lms_lessons/lesson_1765389598739	2025-12-10 16:39:52.377	\N
72	ENR-1765385262826-8455	4	6	899	approved	\N	2025-12-10 16:47:42.829	2025-12-11 10:52:50.067
76	ENR-1765450569262-2646	4	3	599	pending	/uploads/payment-proofs/lms_lessons/lesson_1765450625279	2025-12-11 10:56:09.264	\N
77	ENR-1765535137106-4064	4	5	699	approved	https://res.cloudinary.com/dvck3axc5/image/upload/v1765535159/lms_lessons/lesson_1765535156650.png	2025-12-12 10:25:37.108	2025-12-12 18:12:05.644
78	ENR-1765567647396-3605	4	8	499	approved	https://res.cloudinary.com/dvck3axc5/image/upload/v1765567670/lms_lessons/lesson_1765567659690.png	2025-12-12 19:27:27.398	2025-12-12 19:28:20.791
73	ENR-1765385451157-3892	4	8	499	approved	/uploads/payment-proofs/lms_lessons/lesson_1765390023465	2025-12-10 16:50:51.159	2025-12-12 20:16:43.648
79	ENR-1765573102570-8334	5	8	499	approved	https://res.cloudinary.com/dvck3axc5/image/upload/v1765573113/lms_lessons/lesson_1765573113947.png	2025-12-12 20:58:22.572	2025-12-12 20:59:31.44
75	ENR-1765387625878-4313	4	11	999	rejected	\N	2025-12-10 17:27:05.881	2025-12-10 17:52:13.44
80	ENR-1765573723182-6429	4	4	599	rejected	\N	2025-12-12 21:08:43.185	\N
81	ENR-1765575878552-5086	4	10	799	pending	\N	2025-12-12 21:44:38.553	\N
82	ENR-1765575899275-2130	4	4	599	pending	\N	2025-12-12 21:44:59.276	\N
83	ENR-1765576167195-5046	4	9	1099	pending	\N	2025-12-12 21:49:27.197	\N
\.


--
-- Data for Name: Salary; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."Salary" (id, amount, month, status, "createdAt", "teacherId") FROM stdin;
\.


--
-- Data for Name: Subject; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."Subject" (id, title, description, price, "createdAt", "updatedAt", "teacherId") FROM stdin;
1	Computer	This is computer course	2200	2025-12-09 07:42:03.627	2025-12-09 07:42:03.627	3
2	Math	Math is number 1	2000	2025-12-09 08:57:26.187	2025-12-09 08:57:26.187	3
3	Python for Beginners	Start coding in Python with hands-on projects.	599	2025-12-09 08:58:50.07	2025-12-09 08:58:50.07	3
4	Python for Beginners	Start coding in Python with hands-on projects.	599	2025-12-09 09:00:27.251	2025-12-09 09:00:27.251	3
5	JavaScript Essentials	Learn JavaScript fundamentals and DOM manipulation.	699	2025-12-09 09:00:27.258	2025-12-09 09:00:27.258	3
6	React from Scratch	Build interactive UIs using React and hooks.	899	2025-12-09 09:00:27.261	2025-12-09 09:00:27.261	3
7	Node.js and Express	Create backend APIs with Node.js and Express framework.	799	2025-12-09 09:00:27.265	2025-12-09 09:00:27.265	3
8	HTML & CSS Mastery	Design responsive web pages with modern HTML and CSS.	499	2025-12-09 09:00:27.268	2025-12-09 09:00:27.268	3
9	Fullstack Web Development	Combine frontend and backend skills to build complete apps.	1099	2025-12-09 09:00:27.271	2025-12-09 09:00:27.271	3
10	Data Structures & Algorithms	Learn key data structures and algorithmic problem solving.	799	2025-12-09 09:00:27.274	2025-12-09 09:00:27.274	3
11	Python for Data Science	Analyze and visualize data using Python libraries.	999	2025-12-09 09:00:27.276	2025-12-09 09:00:27.276	3
12	Machine Learning Basics	Understand the fundamentals of machine learning and AI.	1299	2025-12-09 09:00:27.278	2025-12-09 09:00:27.278	3
13	Database Management with SQL	Learn to create, query, and manage relational databases.	699	2025-12-09 09:00:27.28	2025-12-09 09:00:27.28	3
14	OPT Maths	this is opt maths	2000	2025-12-09 09:01:16.519	2025-12-09 09:01:16.519	3
\.


--
-- Data for Name: Submission; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."Submission" (id, "fileUrl", marks, status, "assignmentId", "studentId", "submittedAt", feedback, "gradedAt") FROM stdin;
1	https://res.cloudinary.com/dvck3axc5/image/upload/v1765736976/lms_lessons/lesson_1765736963868.pdf	\N	submitted	1	4	2025-12-14 18:29:38.176	\N	\N
2	https://res.cloudinary.com/dvck3axc5/image/upload/v1765739859/lms_lessons/lesson_1765739856929.pdf	95	graded	2	4	2025-12-14 19:17:41.308	good job	\N
3	https://res.cloudinary.com/dvck3axc5/image/upload/v1765817001/lms_lessons/lesson_1765816999652.pdf	87	graded	3	4	2025-12-15 16:43:23.725	good job prepare more and try to cross 90	\N
4	https://res.cloudinary.com/dvck3axc5/image/upload/v1765968094/lms_lessons/lesson_1765968094847.pdf	95	graded	5	4	2025-12-17 10:41:39.269	good job	\N
5	https://res.cloudinary.com/dvck3axc5/image/upload/v1765968570/lms_lessons/lesson_1765968569221.pdf	\N	submitted	6	4	2025-12-17 10:49:34.841	\N	\N
6	https://res.cloudinary.com/dvck3axc5/image/upload/v1766028717/lms_lessons/lesson_1766028717879.pdf	\N	submitted	7	4	2025-12-18 03:32:03.126	\N	\N
7	https://res.cloudinary.com/dvck3axc5/image/upload/v1766029033/lms_lessons/lesson_1766029033169.pdf	\N	submitted	8	4	2025-12-18 03:37:18.024	\N	\N
8	https://res.cloudinary.com/dvck3axc5/image/upload/v1766029208/lms_lessons/lesson_1766029209122.pdf	\N	submitted	9	4	2025-12-18 03:40:13.902	\N	\N
9	https://res.cloudinary.com/dvck3axc5/image/upload/v1766029360/lms_lessons/lesson_1766029361585.pdf	\N	submitted	11	4	2025-12-18 03:42:45.386	\N	\N
10	https://res.cloudinary.com/dvck3axc5/image/upload/v1766030507/lms_lessons/lesson_1766030508391.pdf	70	graded	12	4	2025-12-18 04:01:53.038	work hard	\N
\.


--
-- Data for Name: User; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public."User" (id, "firstName", "lastName", email, phone, password, role, status, "createdAt", "updatedAt", "resetToken", "resetTokenExpiry", "refreshToken", "refreshTokenExpiresAt", "esewaNumber", "lastLogin", "lastActivity") FROM stdin;
4	Baskota	Anup	baskotanup@gmail.com	(+977) 9862773203	$2b$10$0Jt3V6aBw2SdFOFrXmEBwOaIfvG1Up3fqtmi.2RAd31Gh2./.Mi7K	student	approved	2025-12-09 07:39:05.572	2025-12-18 16:55:00.825	\N	\N	\N	\N	\N	2025-12-18 10:41:12.307	2025-12-18 16:55:00.82
5	Deepak	Gajamer	gajamerdipak19@gmail.com	9876543210	$2b$10$sM306ONYk8e8j1TVEJXDEOaQjUfkt0iB/blNrjLQI1E5t1KQg1YOS	teacher	approved	2025-12-11 10:43:04.456	2025-12-16 16:15:30.28	\N	\N	\N	\N	\N	2025-12-16 16:15:13.734	2025-12-16 16:15:30.278
2	LMS	Admin	admin@lms.com	+9779812345678	$2b$10$ELzvSOF1Ap3Bq85UiygWK.hCLlh/zWULIgH9C15Ij6cRu5X0oCrjq	admin	approved	2025-12-09 07:06:44.939	2025-12-18 04:12:21.296	\N	\N	\N	\N	9862773203	2025-12-18 04:03:31.553	2025-12-18 04:12:21.294
3	Anup	Banskota	baskotanoop@gmail.com	9876543210	$2b$10$V5/jwj95/ogSzpaK0eZKkO6KtPJAimzHtnSgP821u.UyjnxsAtBUK	teacher	approved	2025-12-09 07:38:20.689	2025-12-18 18:07:34.327	\N	\N	\N	\N	\N	2025-12-18 10:01:05.435	2025-12-18 18:07:34.325
\.


--
-- Data for Name: _prisma_migrations; Type: TABLE DATA; Schema: public; Owner: Anup
--

COPY public._prisma_migrations (id, checksum, finished_at, migration_name, logs, rolled_back_at, started_at, applied_steps_count) FROM stdin;
111dbc74-bece-454d-8ac8-8d1c0cae0681	fc8b11d9dd6b6897900ce1a7ca08107a576026a20719337be80722d31f283147	2025-12-09 12:36:15.585905+05:45	20251117071759_init	\N	\N	2025-12-09 12:36:15.504641+05:45	1
e1e00050-fe26-49b8-8378-dce2b1c3bf20	fb2361b2676a65d10b82e22d1545e6d12e174765dbd802a799aa61e3436a5498	2025-12-09 12:36:15.589299+05:45	20251118141837_add_price_to_subject	\N	\N	2025-12-09 12:36:15.58655+05:45	1
3a5f15e6-786f-4cd7-bdd5-cae8abd4167d	c46c137a59b072820e30d90925350924766b7a3529a7b1093db12165a198f0f4	2025-12-10 12:42:36.792705+05:45	20251210065736_add_esewa_number	\N	\N	2025-12-10 12:42:36.779978+05:45	1
ea5ee4dc-23cd-451f-b1bf-508765aaafea	79a9957bbfbe5ea605e6d047d7764cc863944c42846f0e0edec89c4a76f9d737	2025-12-09 12:36:15.592079+05:45	20251119145314_add_lesson_description	\N	\N	2025-12-09 12:36:15.589858+05:45	1
87df9dd5-e9d5-41f4-81bc-d9732f4d0f4a	6c5b301a872eab041d637b5fc7b5b988d8b88a9f63a36115dd3693d4a2d11c64	2025-12-09 12:36:15.594988+05:45	20251119172133_change_submission	\N	\N	2025-12-09 12:36:15.592594+05:45	1
299677e3-9a1b-4865-bde2-4971a69e104d	d70a69ee76f43eed4deed495d98faa2755f05cd4a5b8190db1c7a5bbc441e5e0	2025-12-09 12:36:15.597389+05:45	20251123161251_add_cash_on_gateway	\N	\N	2025-12-09 12:36:15.595494+05:45	1
af285738-1344-4928-b7f2-d17c6ab4c347	6df650a601467be6c2805570a42dfb08555b6b4f9d8431ebba3200883042f217	2025-12-13 00:51:54.991065+05:45	20251212190654_add_last_login_to_user	\N	\N	2025-12-13 00:51:54.986391+05:45	1
43f27a4e-c015-423e-b87e-d1bc2e42962a	6d11206a01b84bb72899156b5f209133cda11a4255ea9f0a8bbb87351b476113	2025-12-09 12:36:15.605943+05:45	20251127165147_contact_message	\N	\N	2025-12-09 12:36:15.598159+05:45	1
da7a69d0-6177-469b-8661-f9a0616fff4c	c70557eb98fd9e69d3b46a594c44870eec38ecc6c5cd70bce9bf7e01d51c4cee	2025-12-09 12:36:15.610978+05:45	20251128184727_add_reset_token_fields	\N	\N	2025-12-09 12:36:15.606586+05:45	1
144f5ddc-7323-4710-9daa-8d13690e69fb	cb6fa32be268bddea90192b1bdd830dd36d2044563dde55fb82677df8ca3d705	2025-12-09 12:36:15.613902+05:45	20251128191153_add_refresh_token_fields	\N	\N	2025-12-09 12:36:15.611537+05:45	1
7c87fba9-7a44-4629-961d-57b38432f91e	ab076ef3936b4c0a2230a38146201a7c7f281b683a6147f81b178f182cf806fe	2025-12-13 01:01:42.200994+05:45	20251212191642_add_last_activity_to_user	\N	\N	2025-12-13 01:01:42.195184+05:45	1
480d0a5d-0589-47e2-8869-fb0082a7f813	b65c3c8862971c78ecc0ab334c37d4db41a24e9b9241de96768b3a51bcf4e28e	2025-12-09 12:36:15.618005+05:45	20251208055855_add_thumbnail_url_to_lesson	\N	\N	2025-12-09 12:36:15.614625+05:45	1
61fb8b47-650e-41b4-8d38-df1c49b57cbd	5c0bb8417c90baf9e4e3ee8555dced5199fba795b2079923e3f8676fea329213	2025-12-09 12:36:15.624206+05:45	20251208094611_add_lesson_assignments	\N	\N	2025-12-09 12:36:15.618489+05:45	1
00b9ff43-0956-4e9b-8574-ae3530508afb	f471a7cfee8f5c51717d9f8af6e58f00ec7a2999d84419f622afb0e2710d9493	2025-12-09 12:36:53.294299+05:45	20251209065153_init_schema	\N	\N	2025-12-09 12:36:53.274507+05:45	1
0178fa47-f908-4dc6-a664-e6742b93140e	da46f46f01745ca1dc7a4e6b68461976212a6005e59428f1120a0aaf0a4ba35b	2025-12-13 23:17:59.406713+05:45	20251213173259_add_lesson_progress_fields	\N	\N	2025-12-13 23:17:59.375816+05:45	1
73f9558c-57fc-46ed-b91b-f0233d8c0e32	34db15a6de7eaa43381b4b886a00e341c1f553f2ed5bb4afd51a8fae86f3740d	2025-12-09 12:40:24.394123+05:45	20251209065524_add_enrollment_payment	\N	\N	2025-12-09 12:40:24.372676+05:45	1
76edd791-0209-46b5-b516-e6cf661d1b4a	758b4c232e168a124b5a1fb3ab16b8c7b5153b9bf462599fb4908319eaa4dd12	2025-12-10 12:34:31.001071+05:45	20251210064930_add_payment_gateway_settings	\N	\N	2025-12-10 12:34:30.952164+05:45	1
2c144f3b-1ffe-4d9a-87d9-eb1f676b62fd	77207413cc847debb1e73f7368ecddb0bb7e5ba358fd5ea4f3df09adeb6f71b7	2025-12-14 00:37:12.0459+05:45	20251213185212_add_viseo_duration_fields	\N	\N	2025-12-14 00:37:12.040636+05:45	1
\.


--
-- Name: Assignment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

SELECT pg_catalog.setval('public."Assignment_id_seq"', 13, true);


--
-- Name: Attendance_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

SELECT pg_catalog.setval('public."Attendance_id_seq"', 23, true);


--
-- Name: ContactMessage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

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


--
-- Name: Enrollment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

SELECT pg_catalog.setval('public."Enrollment_id_seq"', 15, true);


--
-- Name: LessonProgress_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

SELECT pg_catalog.setval('public."LessonProgress_id_seq"', 68, true);


--
-- Name: Lesson_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

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


--
-- Name: LiveClass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

SELECT pg_catalog.setval('public."LiveClass_id_seq"', 15, true);


--
-- Name: Message_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

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


--
-- Name: Notification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

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


--
-- Name: PaymentGatewaySettings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

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


--
-- Name: PaymentRequest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

SELECT pg_catalog.setval('public."PaymentRequest_id_seq"', 83, true);


--
-- Name: Payment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

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


--
-- Name: Salary_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

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


--
-- Name: Subject_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

SELECT pg_catalog.setval('public."Subject_id_seq"', 14, true);


--
-- Name: Submission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

SELECT pg_catalog.setval('public."Submission_id_seq"', 10, true);


--
-- Name: User_id_seq; Type: SEQUENCE SET; Schema: public; Owner: Anup
--

SELECT pg_catalog.setval('public."User_id_seq"', 5, true);


--
-- Name: Assignment Assignment_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Assignment"
    ADD CONSTRAINT "Assignment_pkey" PRIMARY KEY (id);


--
-- Name: Attendance Attendance_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Attendance"
    ADD CONSTRAINT "Attendance_pkey" PRIMARY KEY (id);


--
-- Name: ContactMessage ContactMessage_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."ContactMessage"
    ADD CONSTRAINT "ContactMessage_pkey" PRIMARY KEY (id);


--
-- Name: Enrollment Enrollment_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Enrollment"
    ADD CONSTRAINT "Enrollment_pkey" PRIMARY KEY (id);


--
-- Name: LessonProgress LessonProgress_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."LessonProgress"
    ADD CONSTRAINT "LessonProgress_pkey" PRIMARY KEY (id);


--
-- Name: Lesson Lesson_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Lesson"
    ADD CONSTRAINT "Lesson_pkey" PRIMARY KEY (id);


--
-- Name: LiveClass LiveClass_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."LiveClass"
    ADD CONSTRAINT "LiveClass_pkey" PRIMARY KEY (id);


--
-- Name: Message Message_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Message"
    ADD CONSTRAINT "Message_pkey" PRIMARY KEY (id);


--
-- Name: Notification Notification_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Notification"
    ADD CONSTRAINT "Notification_pkey" PRIMARY KEY (id);


--
-- Name: PaymentGatewaySettings PaymentGatewaySettings_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."PaymentGatewaySettings"
    ADD CONSTRAINT "PaymentGatewaySettings_pkey" PRIMARY KEY (id);


--
-- Name: PaymentRequest PaymentRequest_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."PaymentRequest"
    ADD CONSTRAINT "PaymentRequest_pkey" PRIMARY KEY (id);


--
-- Name: Payment Payment_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Payment"
    ADD CONSTRAINT "Payment_pkey" PRIMARY KEY (id);


--
-- Name: Salary Salary_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Salary"
    ADD CONSTRAINT "Salary_pkey" PRIMARY KEY (id);


--
-- Name: Subject Subject_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Subject"
    ADD CONSTRAINT "Subject_pkey" PRIMARY KEY (id);


--
-- Name: Submission Submission_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Submission"
    ADD CONSTRAINT "Submission_pkey" PRIMARY KEY (id);


--
-- Name: User User_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."User"
    ADD CONSTRAINT "User_pkey" PRIMARY KEY (id);


--
-- Name: _prisma_migrations _prisma_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public._prisma_migrations
    ADD CONSTRAINT _prisma_migrations_pkey PRIMARY KEY (id);


--
-- Name: Enrollment_studentId_subjectId_key; Type: INDEX; Schema: public; Owner: Anup
--

CREATE UNIQUE INDEX "Enrollment_studentId_subjectId_key" ON public."Enrollment" USING btree ("studentId", "subjectId");


--
-- Name: LessonProgress_studentId_lessonId_key; Type: INDEX; Schema: public; Owner: Anup
--

CREATE UNIQUE INDEX "LessonProgress_studentId_lessonId_key" ON public."LessonProgress" USING btree ("studentId", "lessonId");


--
-- Name: PaymentRequest_txnId_key; Type: INDEX; Schema: public; Owner: Anup
--

CREATE UNIQUE INDEX "PaymentRequest_txnId_key" ON public."PaymentRequest" USING btree ("txnId");


--
-- Name: User_email_key; Type: INDEX; Schema: public; Owner: Anup
--

CREATE UNIQUE INDEX "User_email_key" ON public."User" USING btree (email);


--
-- Name: Assignment Assignment_lessonId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Assignment"
    ADD CONSTRAINT "Assignment_lessonId_fkey" FOREIGN KEY ("lessonId") REFERENCES public."Lesson"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Assignment Assignment_subjectId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Assignment"
    ADD CONSTRAINT "Assignment_subjectId_fkey" FOREIGN KEY ("subjectId") REFERENCES public."Subject"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Assignment Assignment_teacherId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Assignment"
    ADD CONSTRAINT "Assignment_teacherId_fkey" FOREIGN KEY ("teacherId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Attendance Attendance_classId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Attendance"
    ADD CONSTRAINT "Attendance_classId_fkey" FOREIGN KEY ("classId") REFERENCES public."LiveClass"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Attendance Attendance_studentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Attendance"
    ADD CONSTRAINT "Attendance_studentId_fkey" FOREIGN KEY ("studentId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Enrollment Enrollment_studentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Enrollment"
    ADD CONSTRAINT "Enrollment_studentId_fkey" FOREIGN KEY ("studentId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Enrollment Enrollment_subjectId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Enrollment"
    ADD CONSTRAINT "Enrollment_subjectId_fkey" FOREIGN KEY ("subjectId") REFERENCES public."Subject"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: LessonProgress LessonProgress_lessonId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."LessonProgress"
    ADD CONSTRAINT "LessonProgress_lessonId_fkey" FOREIGN KEY ("lessonId") REFERENCES public."Lesson"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: LessonProgress LessonProgress_studentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."LessonProgress"
    ADD CONSTRAINT "LessonProgress_studentId_fkey" FOREIGN KEY ("studentId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Lesson Lesson_subjectId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Lesson"
    ADD CONSTRAINT "Lesson_subjectId_fkey" FOREIGN KEY ("subjectId") REFERENCES public."Subject"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Lesson Lesson_teacherId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Lesson"
    ADD CONSTRAINT "Lesson_teacherId_fkey" FOREIGN KEY ("teacherId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: LiveClass LiveClass_subjectId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."LiveClass"
    ADD CONSTRAINT "LiveClass_subjectId_fkey" FOREIGN KEY ("subjectId") REFERENCES public."Subject"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: LiveClass LiveClass_teacherId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."LiveClass"
    ADD CONSTRAINT "LiveClass_teacherId_fkey" FOREIGN KEY ("teacherId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Message Message_receiverId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Message"
    ADD CONSTRAINT "Message_receiverId_fkey" FOREIGN KEY ("receiverId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Message Message_senderId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Message"
    ADD CONSTRAINT "Message_senderId_fkey" FOREIGN KEY ("senderId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Notification Notification_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Notification"
    ADD CONSTRAINT "Notification_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Payment Payment_studentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Payment"
    ADD CONSTRAINT "Payment_studentId_fkey" FOREIGN KEY ("studentId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Payment Payment_subjectId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Payment"
    ADD CONSTRAINT "Payment_subjectId_fkey" FOREIGN KEY ("subjectId") REFERENCES public."Subject"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Salary Salary_teacherId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Salary"
    ADD CONSTRAINT "Salary_teacherId_fkey" FOREIGN KEY ("teacherId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Subject Subject_teacherId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Subject"
    ADD CONSTRAINT "Subject_teacherId_fkey" FOREIGN KEY ("teacherId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Submission Submission_assignmentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Submission"
    ADD CONSTRAINT "Submission_assignmentId_fkey" FOREIGN KEY ("assignmentId") REFERENCES public."Assignment"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Submission Submission_studentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."Submission"
    ADD CONSTRAINT "Submission_studentId_fkey" FOREIGN KEY ("studentId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: PaymentRequest fk_student; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."PaymentRequest"
    ADD CONSTRAINT fk_student FOREIGN KEY ("studentId") REFERENCES public."User"(id);


--
-- Name: PaymentRequest fk_subject; Type: FK CONSTRAINT; Schema: public; Owner: Anup
--

ALTER TABLE ONLY public."PaymentRequest"
    ADD CONSTRAINT fk_subject FOREIGN KEY ("subjectId") REFERENCES public."Subject"(id);


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

REVOKE USAGE ON SCHEMA public FROM PUBLIC;


--
--

