CREATE TABLE public.levels
(
    level_id integer NOT NULL DEFAULT 0,
    name character varying(50),
    tutor_quota_limit integer DEFAULT 1,
    course_id integer NOT NULL,
    description text,
    order_index smallint NOT NULL DEFAULT 0,
    active boolean NOT NULL DEFAULT true,
    zoom_room_name character varying(100),
    CONSTRAINT levels_course_id_fkey FOREIGN KEY (course_id) REFERENCES courses(course_id),
    CONSTRAINT levels_pkey PRIMARY KEY (level_id)
);