current_schema.sql

--
-- PostgreSQL database dump
--

\restrict ibAqxDEcc77PJjoMHEBkQ3fzKszyxHtcY1d0cRathrPkxdoJ7doJUQsiRB0okJp

-- Dumped from database version 16.10 (Ubuntu 16.10-0ubuntu0.24.04.1)
-- Dumped by pg_dump version 16.10 (Ubuntu 16.10-0ubuntu0.24.04.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;

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

CREATE TYPE public.enum_approval_history_action AS ENUM (
    'created',
    'submitted',
    'reviewed',
    'approved',
    'denied',
    'processed',
    'cancelled',
    'modified',
    'reassigned'
);


ALTER TYPE public.enum_approval_history_action OWNER TO postgres;

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

CREATE TYPE public."enum_approval_history_newStatus" AS ENUM (
    'pending',
    'approved',
    'denied',
    'processed',
    'cancelled'
);


ALTER TYPE public."enum_approval_history_newStatus" OWNER TO postgres;

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

CREATE TYPE public."enum_approval_history_previousStatus" AS ENUM (
    'pending',
    'approved',
    'denied',
    'processed',
    'cancelled'
);


ALTER TYPE public."enum_approval_history_previousStatus" OWNER TO postgres;

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

CREATE TYPE public.enum_approvals_priority AS ENUM (
    'low',
    'medium',
    'high',
    'urgent'
);


ALTER TYPE public.enum_approvals_priority OWNER TO postgres;

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

CREATE TYPE public.enum_approvals_status AS ENUM (
    'pending',
    'approved',
    'denied',
    'processed',
    'cancelled'
);


ALTER TYPE public.enum_approvals_status OWNER TO postgres;

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

CREATE TYPE public.enum_approvals_status_new AS ENUM (
    'pending',
    'approved',
    'denied',
    'processed',
    'cancelled'
);


ALTER TYPE public.enum_approvals_status_new OWNER TO postgres;

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

CREATE TYPE public.enum_approvals_type AS ENUM (
    'program_change',
    'schedule_change',
    'coop_request'
);


ALTER TYPE public.enum_approvals_type OWNER TO postgres;

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

CREATE TYPE public.enum_notifications_category AS ENUM (
    'academic',
    'administrative',
    'approval',
    'system',
    'deadline',
    'personal',
    'emergency'
);


ALTER TYPE public.enum_notifications_category OWNER TO postgres;

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

CREATE TYPE public.enum_notifications_priority AS ENUM (
    'low',
    'medium',
    'high',
    'urgent'
);


ALTER TYPE public.enum_notifications_priority OWNER TO postgres;

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

CREATE TYPE public."enum_notifications_relatedType" AS ENUM (
    'approval',
    'schedule',
    'program',
    'course',
    'user'
);


ALTER TYPE public."enum_notifications_relatedType" OWNER TO postgres;

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

CREATE TYPE public.enum_notifications_related_type AS ENUM (
    'approval',
    'schedule',
    'program',
    'course',
    'user'
);


ALTER TYPE public.enum_notifications_related_type OWNER TO postgres;

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

CREATE TYPE public.enum_notifications_type AS ENUM (
    'info',
    'warning',
    'success',
    'error',
    'approval_request',
    'approval_approved',
    'approval_denied',
    'approval_processed',
    'schedule_change',
    'program_change',
    'coop_update',
    'system_announcement',
    'deadline_reminder',
    'urgent'
);


ALTER TYPE public.enum_notifications_type OWNER TO postgres;

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

CREATE TYPE public.enum_programs_type AS ENUM (
    'major',
    'minor'
);


ALTER TYPE public.enum_programs_type OWNER TO postgres;

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

CREATE TYPE public.enum_schedules_semester AS ENUM (
    'fall',
    'spring',
    'summer'
);


ALTER TYPE public.enum_schedules_semester OWNER TO postgres;

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

CREATE TYPE public.enum_schedules_status AS ENUM (
    'planned',
    'enrolled',
    'completed',
    'failed',
    'withdrawn'
);


ALTER TYPE public.enum_schedules_status OWNER TO postgres;

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

CREATE TYPE public.enum_user_programs_status AS ENUM (
    'pending',
    'approved',
    'active',
    'completed'
);


ALTER TYPE public.enum_user_programs_status OWNER TO postgres;

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

CREATE TYPE public.enum_users_role AS ENUM (
    'student',
    'faculty',
    'admin'
);


ALTER TYPE public.enum_users_role OWNER TO postgres;

SET default_tablespace = '';

SET default_table_access_method = heap;

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

CREATE TABLE public."SequelizeMeta" (
    name character varying(255) NOT NULL
);


ALTER TABLE public."SequelizeMeta" OWNER TO postgres;

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

CREATE TABLE public.approval_history (
    id integer NOT NULL,
    "approvalId" integer NOT NULL,
    action public.enum_approval_history_action NOT NULL,
    "performedBy" integer NOT NULL,
    "previousStatus" public."enum_approval_history_previousStatus",
    "newStatus" public."enum_approval_history_newStatus",
    comments text,
    metadata jsonb,
    "ipAddress" inet,
    "userAgent" character varying(255),
    "processingTime" integer,
    "createdAt" timestamp with time zone NOT NULL,
    "updatedAt" timestamp with time zone NOT NULL
);


ALTER TABLE public.approval_history OWNER TO postgres;

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

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


ALTER SEQUENCE public.approval_history_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.approval_history_id_seq OWNED BY public.approval_history.id;


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

CREATE TABLE public.approvals (
    id integer NOT NULL,
    "studentId" integer NOT NULL,
    "facultyId" integer NOT NULL,
    type public.enum_approvals_type NOT NULL,
    status public.enum_approvals_status DEFAULT 'pending'::public.enum_approvals_status NOT NULL,
    "requestData" jsonb NOT NULL,
    comments text,
    "reviewedAt" timestamp with time zone,
    "createdAt" timestamp with time zone NOT NULL,
    "updatedAt" timestamp with time zone NOT NULL,
    "processedAt" timestamp with time zone,
    "reviewedBy" integer,
    "processedBy" integer,
    priority public.enum_approvals_priority DEFAULT 'medium'::public.enum_approvals_priority NOT NULL,
    metadata jsonb
);


ALTER TABLE public.approvals OWNER TO postgres;

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

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


ALTER SEQUENCE public.approvals_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.approvals_id_seq OWNED BY public.approvals.id;


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

CREATE TABLE public.courses (
    id integer NOT NULL,
    code character varying(10) NOT NULL,
    name character varying(255) NOT NULL,
    credits integer DEFAULT 3 NOT NULL,
    description text,
    "semesterOffered" character varying(255) DEFAULT 'both'::character varying,
    "createdAt" timestamp with time zone NOT NULL,
    "updatedAt" timestamp with time zone NOT NULL
);


ALTER TABLE public.courses OWNER TO postgres;

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

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


ALTER SEQUENCE public.courses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.courses_id_seq OWNED BY public.courses.id;


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

CREATE TABLE public.notifications (
    id integer NOT NULL,
    "userId" integer NOT NULL,
    title character varying(255) NOT NULL,
    message text NOT NULL,
    type public.enum_notifications_type DEFAULT 'info'::public.enum_notifications_type NOT NULL,
    "isRead" boolean DEFAULT false NOT NULL,
    "createdAt" timestamp with time zone NOT NULL,
    "updatedAt" timestamp with time zone NOT NULL,
    priority public.enum_notifications_priority DEFAULT 'medium'::public.enum_notifications_priority NOT NULL,
    category public.enum_notifications_category DEFAULT 'academic'::public.enum_notifications_category NOT NULL,
    metadata jsonb,
    "expiresAt" timestamp with time zone,
    "actionUrl" character varying(255),
    "relatedId" integer,
    "relatedType" public."enum_notifications_relatedType"
);


ALTER TABLE public.notifications OWNER TO postgres;

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

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


ALTER SEQUENCE public.notifications_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.notifications_id_seq OWNED BY public.notifications.id;


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

CREATE TABLE public.prerequisites (
    id integer NOT NULL,
    "courseId" integer NOT NULL,
    "prerequisiteId" integer NOT NULL,
    "minimumGrade" character varying(2) DEFAULT 'D'::character varying,
    "createdAt" timestamp with time zone NOT NULL,
    "updatedAt" timestamp with time zone NOT NULL
);


ALTER TABLE public.prerequisites OWNER TO postgres;

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

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


ALTER SEQUENCE public.prerequisites_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.prerequisites_id_seq OWNED BY public.prerequisites.id;


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

CREATE TABLE public.program_courses (
    id integer NOT NULL,
    "programId" integer NOT NULL,
    "courseId" integer NOT NULL,
    "isRequired" boolean DEFAULT true NOT NULL,
    "createdAt" timestamp with time zone NOT NULL,
    "updatedAt" timestamp with time zone NOT NULL,
    "semesterRecommended" integer
);


ALTER TABLE public.program_courses OWNER TO postgres;

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

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


ALTER SEQUENCE public.program_courses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.program_courses_id_seq OWNED BY public.program_courses.id;


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

CREATE TABLE public.programs (
    id integer NOT NULL,
    code character varying(10) NOT NULL,
    name character varying(255) NOT NULL,
    type public.enum_programs_type NOT NULL,
    "totalCredits" integer NOT NULL,
    description text,
    "createdAt" timestamp with time zone NOT NULL,
    "updatedAt" timestamp with time zone NOT NULL
);


ALTER TABLE public.programs OWNER TO postgres;

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

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


ALTER SEQUENCE public.programs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.programs_id_seq OWNED BY public.programs.id;


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

CREATE TABLE public.schedules (
    id integer NOT NULL,
    "studentId" integer NOT NULL,
    "courseId" integer NOT NULL,
    semester public.enum_schedules_semester NOT NULL,
    year integer NOT NULL,
    status public.enum_schedules_status DEFAULT 'planned'::public.enum_schedules_status NOT NULL,
    grade character varying(500),
    "createdAt" timestamp with time zone NOT NULL,
    "updatedAt" timestamp with time zone NOT NULL
);


ALTER TABLE public.schedules OWNER TO postgres;

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

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


ALTER SEQUENCE public.schedules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.schedules_id_seq OWNED BY public.schedules.id;


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

CREATE TABLE public.user_programs (
    id integer NOT NULL,
    "userId" integer NOT NULL,
    "programId" integer NOT NULL,
    status public.enum_user_programs_status DEFAULT 'pending'::public.enum_user_programs_status NOT NULL,
    "enrollmentDate" timestamp with time zone,
    "createdAt" timestamp with time zone NOT NULL,
    "updatedAt" timestamp with time zone NOT NULL
);


ALTER TABLE public.user_programs OWNER TO postgres;

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

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


ALTER SEQUENCE public.user_programs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.user_programs_id_seq OWNED BY public.user_programs.id;


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

CREATE TABLE public.users (
    id integer NOT NULL,
    username character varying(8) NOT NULL,
    password character varying(12) NOT NULL,
    role public.enum_users_role NOT NULL,
    "firstName" character varying(255) NOT NULL,
    "lastName" character varying(255) NOT NULL,
    email character varying(255),
    "advisorId" integer,
    "createdAt" timestamp with time zone NOT NULL,
    "updatedAt" timestamp with time zone NOT NULL
);


ALTER TABLE public.users OWNER TO postgres;

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

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


ALTER SEQUENCE public.users_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: SequelizeMeta SequelizeMeta_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public."SequelizeMeta"
    ADD CONSTRAINT "SequelizeMeta_pkey" PRIMARY KEY (name);


--
-- Name: approval_history approval_history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.approval_history
    ADD CONSTRAINT approval_history_pkey PRIMARY KEY (id);


--
-- Name: approvals approvals_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.approvals
    ADD CONSTRAINT approvals_pkey PRIMARY KEY (id);


--
-- Name: courses courses_code_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.courses
    ADD CONSTRAINT courses_code_key UNIQUE (code);


--
-- Name: courses courses_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.courses
    ADD CONSTRAINT courses_pkey PRIMARY KEY (id);


--
-- Name: notifications notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_pkey PRIMARY KEY (id);


--
-- Name: prerequisites prerequisites_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.prerequisites
    ADD CONSTRAINT prerequisites_pkey PRIMARY KEY (id);


--
-- Name: program_courses program_courses_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.program_courses
    ADD CONSTRAINT program_courses_pkey PRIMARY KEY (id);


--
-- Name: programs programs_code_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.programs
    ADD CONSTRAINT programs_code_key UNIQUE (code);


--
-- Name: programs programs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.programs
    ADD CONSTRAINT programs_pkey PRIMARY KEY (id);


--
-- Name: schedules schedules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedules
    ADD CONSTRAINT schedules_pkey PRIMARY KEY (id);


--
-- Name: prerequisites unique_course_prerequisite; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.prerequisites
    ADD CONSTRAINT unique_course_prerequisite UNIQUE ("courseId", "prerequisiteId");


--
-- Name: program_courses unique_program_course; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.program_courses
    ADD CONSTRAINT unique_program_course UNIQUE ("programId", "courseId");


--
-- Name: schedules unique_student_course_semester; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedules
    ADD CONSTRAINT unique_student_course_semester UNIQUE ("studentId", "courseId", semester, year);


--
-- Name: user_programs user_programs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_programs
    ADD CONSTRAINT user_programs_pkey PRIMARY KEY (id);


--
-- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_key UNIQUE (email);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: users users_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_username_key UNIQUE (username);


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

CREATE INDEX approval_history_approval_id ON public.approval_history USING btree ("approvalId");


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

CREATE INDEX approval_history_created_at ON public.approval_history USING btree ("createdAt");


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

CREATE INDEX approval_history_performed_by ON public.approval_history USING btree ("performedBy");


--
-- Name: approval_history approval_history_approvalId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.approval_history
    ADD CONSTRAINT "approval_history_approvalId_fkey" FOREIGN KEY ("approvalId") REFERENCES public.approvals(id) ON DELETE CASCADE;


--
-- Name: approval_history approval_history_performedBy_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.approval_history
    ADD CONSTRAINT "approval_history_performedBy_fkey" FOREIGN KEY ("performedBy") REFERENCES public.users(id);


--
-- Name: approvals approvals_facultyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.approvals
    ADD CONSTRAINT "approvals_facultyId_fkey" FOREIGN KEY ("facultyId") REFERENCES public.users(id);


--
-- Name: approvals approvals_processedBy_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.approvals
    ADD CONSTRAINT "approvals_processedBy_fkey" FOREIGN KEY ("processedBy") REFERENCES public.users(id);


--
-- Name: approvals approvals_reviewedBy_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.approvals
    ADD CONSTRAINT "approvals_reviewedBy_fkey" FOREIGN KEY ("reviewedBy") REFERENCES public.users(id);


--
-- Name: approvals approvals_studentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.approvals
    ADD CONSTRAINT "approvals_studentId_fkey" FOREIGN KEY ("studentId") REFERENCES public.users(id);


--
-- Name: notifications notifications_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT "notifications_userId_fkey" FOREIGN KEY ("userId") REFERENCES public.users(id);


--
-- Name: prerequisites prerequisites_courseId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.prerequisites
    ADD CONSTRAINT "prerequisites_courseId_fkey" FOREIGN KEY ("courseId") REFERENCES public.courses(id);


--
-- Name: prerequisites prerequisites_prerequisiteId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.prerequisites
    ADD CONSTRAINT "prerequisites_prerequisiteId_fkey" FOREIGN KEY ("prerequisiteId") REFERENCES public.courses(id);


--
-- Name: program_courses program_courses_courseId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.program_courses
    ADD CONSTRAINT "program_courses_courseId_fkey" FOREIGN KEY ("courseId") REFERENCES public.courses(id);


--
-- Name: program_courses program_courses_programId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.program_courses
    ADD CONSTRAINT "program_courses_programId_fkey" FOREIGN KEY ("programId") REFERENCES public.programs(id);


--
-- Name: schedules schedules_courseId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedules
    ADD CONSTRAINT "schedules_courseId_fkey" FOREIGN KEY ("courseId") REFERENCES public.courses(id);


--
-- Name: schedules schedules_studentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.schedules
    ADD CONSTRAINT "schedules_studentId_fkey" FOREIGN KEY ("studentId") REFERENCES public.users(id);


--
-- Name: user_programs user_programs_programId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_programs
    ADD CONSTRAINT "user_programs_programId_fkey" FOREIGN KEY ("programId") REFERENCES public.programs(id);


--
-- Name: user_programs user_programs_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_programs
    ADD CONSTRAINT "user_programs_userId_fkey" FOREIGN KEY ("userId") REFERENCES public.users(id);


--
-- Name: users users_advisorId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT "users_advisorId_fkey" FOREIGN KEY ("advisorId") REFERENCES public.users(id);


--
-- PostgreSQL database dump complete
--

\unrestrict ibAqxDEcc77PJjoMHEBkQ3fzKszyxHtcY1d0cRathrPkxdoJ7doJUQsiRB0okJp