-- Dumped from database version 17.9 (Homebrew) -- Dumped by pg_dump version 17.9 (Homebrew) SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_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: order_cart; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.order_cart ( user_id bigint NOT NULL, discount_id integer, status_id integer NOT NULL, order_id bigint NOT NULL, created_at timestamp without time zone NOT NULL, total_price numeric(12,2) NOT NULL, CONSTRAINT chk_order_total CHECK ((total_price >= (0)::numeric)) ); -- -- Name: Order_order_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public."Order_order_id_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: Order_order_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public."Order_order_id_seq" OWNED BY public.order_cart.order_id; -- -- Name: user_app; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.user_app ( user_id bigint NOT NULL, username character varying(20) NOT NULL, email character varying(50) NOT NULL, contact_phone character varying(50), CONSTRAINT chk_email_format CHECK (((email)::text ~~ '%@%.%'::text)) ); -- -- Name: User_user_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public."User_user_id_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: User_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public."User_user_id_seq" OWNED BY public.user_app.user_id; -- -- Name: attribute; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.attribute ( name text NOT NULL, attribute_id integer NOT NULL, data_type character varying(20) NOT NULL, description text, is_required boolean NOT NULL ); -- -- Name: attribute_attribute_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.attribute_attribute_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: attribute_attribute_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.attribute_attribute_id_seq OWNED BY public.attribute.attribute_id; -- -- Name: category; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.category ( id integer NOT NULL, name character varying(100) NOT NULL ); -- -- Name: category_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.category_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.category_id_seq OWNED BY public.category.id; -- -- Name: discount; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.discount ( event_id integer NOT NULL, discount_id integer NOT NULL, discount_percent numeric(5,2) NOT NULL, promo_code_id integer, CONSTRAINT chk_discount_percent CHECK (((discount_percent >= (0)::numeric) AND (discount_percent <= (100)::numeric))) ); -- -- Name: discount_discount_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.discount_discount_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: discount_discount_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.discount_discount_id_seq OWNED BY public.discount.discount_id; -- -- Name: event; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.event ( organiser_id integer NOT NULL, event_id integer NOT NULL, event_status_id integer NOT NULL, title character varying(64) NOT NULL, start_datetime timestamp without time zone NOT NULL, end_datetime timestamp without time zone, CONSTRAINT chk_event_chronology CHECK ((end_datetime > start_datetime)) ); -- -- Name: event_category; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.event_category ( event_id integer NOT NULL, category_id integer NOT NULL, event_category_id integer NOT NULL ); -- -- Name: event_category_event_category_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.event_category_event_category_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: event_category_event_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.event_category_event_category_id_seq OWNED BY public.event_category.event_category_id; -- -- Name: event_event_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.event_event_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: event_event_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.event_event_id_seq OWNED BY public.event.event_id; -- -- Name: event_schedule_session; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.event_schedule_session ( event_id integer NOT NULL, schedule_id integer NOT NULL, session_title character varying(50), start_time timestamp without time zone, end_time timestamp without time zone, section_id integer NOT NULL, CONSTRAINT chk_session_chronology CHECK ((end_time > start_time)) ); -- -- Name: event_schedule_session_schedule_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.event_schedule_session_schedule_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: event_schedule_session_schedule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.event_schedule_session_schedule_id_seq OWNED BY public.event_schedule_session.schedule_id; -- -- Name: event_status; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.event_status ( event_status_id integer NOT NULL, status_name character varying(50) NOT NULL ); -- -- Name: event_status_event_status_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.event_status_event_status_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: event_status_event_status_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.event_status_event_status_id_seq OWNED BY public.event_status.event_status_id; -- -- Name: exhibitor; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.exhibitor ( name character varying(50) NOT NULL, surname character varying(50), exhibitor_id integer NOT NULL, field_id integer NOT NULL ); -- -- Name: exhibitor_event_schedule_session; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.exhibitor_event_schedule_session ( exhibitor_id integer NOT NULL, event_schedule_session_id integer NOT NULL, start_time timestamp without time zone NOT NULL, end_time timestamp without time zone NOT NULL, exhibitor_event_schedule_session_id integer NOT NULL, CONSTRAINT chk_exhibitor_session_chronology CHECK ((end_time > start_time)) ); -- -- Name: exhibitor_event_schedule_sess_exhibitor_event_schedule_sess_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.exhibitor_event_schedule_sess_exhibitor_event_schedule_sess_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: exhibitor_event_schedule_sess_exhibitor_event_schedule_sess_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.exhibitor_event_schedule_sess_exhibitor_event_schedule_sess_seq OWNED BY public.exhibitor_event_schedule_session.exhibitor_event_schedule_session_id; -- -- Name: exhibitor_exhibitor_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.exhibitor_exhibitor_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: exhibitor_exhibitor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.exhibitor_exhibitor_id_seq OWNED BY public.exhibitor.exhibitor_id; -- -- Name: field; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.field ( field_id integer NOT NULL, field_name character varying(50) NOT NULL ); -- -- Name: field_field_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.field_field_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: field_field_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.field_field_id_seq OWNED BY public.field.field_id; -- -- Name: location; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.location ( location_id integer NOT NULL, name character varying(100) NOT NULL, type_id integer NOT NULL, address character varying(255), city character varying(255) NOT NULL, capacity integer NOT NULL, CONSTRAINT chk_location_capacity CHECK ((capacity > 0)) ); -- -- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.location_location_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.location_location_id_seq OWNED BY public.location.location_id; -- -- Name: location_type; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.location_type ( type_id integer NOT NULL, type_name character varying(100) NOT NULL ); -- -- Name: location_type_type_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.location_type_type_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: location_type_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.location_type_type_id_seq OWNED BY public.location_type.type_id; -- -- Name: order_status; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.order_status ( status_id integer NOT NULL, status_name character varying(50) NOT NULL ); -- -- Name: order_status_status_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.order_status_status_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: order_status_status_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.order_status_status_id_seq OWNED BY public.order_status.status_id; -- -- Name: organiser; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.organiser ( organiser_id integer NOT NULL, company_name character varying(255) NOT NULL, contact_phone character varying(50), website_url character varying(255) ); -- -- Name: organiser_organiser_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.organiser_organiser_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: organiser_organiser_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.organiser_organiser_id_seq OWNED BY public.organiser.organiser_id; -- -- Name: payment; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.payment ( order_id bigint NOT NULL, method_id integer NOT NULL, payment_id integer NOT NULL, amount_paid numeric(12,2), processed_at timestamp without time zone NOT NULL, transaction_id character varying(255) NOT NULL, is_refunded boolean, CONSTRAINT chk_payment_amount CHECK ((amount_paid >= (0)::numeric)) ); -- -- Name: payment_method; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.payment_method ( method_id integer NOT NULL, method_name character varying(50) NOT NULL ); -- -- Name: payment_method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.payment_method_method_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: payment_method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.payment_method_method_id_seq OWNED BY public.payment_method.method_id; -- -- Name: payment_payment_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.payment_payment_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: payment_payment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.payment_payment_id_seq OWNED BY public.payment.payment_id; -- -- Name: price_tier; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.price_tier ( ticket_type_id integer NOT NULL, price numeric(10,2) NOT NULL, valid_from timestamp without time zone NOT NULL, valid_to timestamp without time zone NOT NULL, price_tier_id integer NOT NULL, CONSTRAINT chk_price CHECK ((price >= (0)::numeric)), CONSTRAINT chk_price_tier_chronology CHECK ((valid_to > valid_from)) ); -- -- Name: price_tier_price_tier_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.price_tier_price_tier_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: price_tier_price_tier_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.price_tier_price_tier_id_seq OWNED BY public.price_tier.price_tier_id; -- -- Name: promo_code; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.promo_code ( promo_code_id integer NOT NULL, code character varying(64) NOT NULL ); -- -- Name: promo_code_promo_code_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.promo_code_promo_code_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: promo_code_promo_code_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.promo_code_promo_code_id_seq OWNED BY public.promo_code.promo_code_id; -- -- Name: refund_request; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.refund_request ( refund_request_id integer NOT NULL, reason text, requested_at timestamp without time zone NOT NULL, accepted_at timestamp without time zone, user_id bigint NOT NULL, payment_id integer NOT NULL ); -- -- Name: refund_request_refund_request_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.refund_request_refund_request_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: refund_request_refund_request_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.refund_request_refund_request_id_seq OWNED BY public.refund_request.refund_request_id; -- -- Name: review; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.review ( user_id bigint NOT NULL, event_id integer NOT NULL, review_id integer NOT NULL, star_rating integer NOT NULL, review_text text, created_at timestamp without time zone NOT NULL, CONSTRAINT chk_star_rating CHECK (((star_rating >= 1) AND (star_rating <= 5))) ); -- -- Name: review_review_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.review_review_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: review_review_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.review_review_id_seq OWNED BY public.review.review_id; -- -- Name: seat; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.seat ( seat_id integer NOT NULL, row_identifier character varying(10) NOT NULL, section_id integer NOT NULL, seat_number character varying(10) NOT NULL, is_accessible boolean NOT NULL, is_available boolean NOT NULL ); -- -- Name: seat_seat_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.seat_seat_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: seat_seat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.seat_seat_id_seq OWNED BY public.seat.seat_id; -- -- Name: section; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.section ( section_id integer NOT NULL, section_name character varying(100), capacity integer NOT NULL, location_id integer NOT NULL, CONSTRAINT chk_section_capacity CHECK ((capacity > 0)) ); -- -- Name: section_section_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.section_section_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: section_section_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.section_section_id_seq OWNED BY public.section.section_id; -- -- Name: sponsor; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.sponsor ( sponsor_id integer NOT NULL, name character varying(64) NOT NULL ); -- -- Name: sponsor_event; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.sponsor_event ( event_id integer NOT NULL, sponsor_id integer NOT NULL, sponsor_event_id integer NOT NULL, sponsor_type character varying(64) NOT NULL, sponsor_amount_paid numeric(5,2) NOT NULL, CONSTRAINT chk_sponsor_amount CHECK ((sponsor_amount_paid >= (0)::numeric)) ); -- -- Name: sponsor_event_sponsor_event_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.sponsor_event_sponsor_event_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: sponsor_event_sponsor_event_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.sponsor_event_sponsor_event_id_seq OWNED BY public.sponsor_event.sponsor_event_id; -- -- Name: sponsor_sponsor_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.sponsor_sponsor_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: sponsor_sponsor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.sponsor_sponsor_id_seq OWNED BY public.sponsor.sponsor_id; -- -- Name: sponsor_type; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.sponsor_type ( sponsor_type_id integer NOT NULL, sponsor_amount_paid numeric(5,2) NOT NULL, type character varying(64) NOT NULL, CONSTRAINT chk_sponsor_type_amount CHECK ((sponsor_amount_paid >= (0)::numeric)) ); -- -- Name: sponsor_type_sponsor; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.sponsor_type_sponsor ( sponsor_id integer NOT NULL, sponsor_type_id integer NOT NULL, sponsor_type_sponsor_id integer NOT NULL ); -- -- Name: sponsor_type_sponsor_sponsor_type_sponsor_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.sponsor_type_sponsor_sponsor_type_sponsor_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: sponsor_type_sponsor_sponsor_type_sponsor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.sponsor_type_sponsor_sponsor_type_sponsor_id_seq OWNED BY public.sponsor_type_sponsor.sponsor_type_sponsor_id; -- -- Name: sponsor_type_sponsor_type_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.sponsor_type_sponsor_type_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: sponsor_type_sponsor_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.sponsor_type_sponsor_type_id_seq OWNED BY public.sponsor_type.sponsor_type_id; -- -- Name: staff_member; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.staff_member ( assigned_role integer NOT NULL, staff_member_id integer NOT NULL, name character varying(20) NOT NULL, surname character varying(20) NOT NULL, contact_phone character varying(50), staff_team_id integer NOT NULL ); -- -- Name: staff_member_staff_member_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.staff_member_staff_member_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: staff_member_staff_member_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.staff_member_staff_member_id_seq OWNED BY public.staff_member.staff_member_id; -- -- Name: staff_role; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.staff_role ( staff_role_id integer NOT NULL, description character varying(100) NOT NULL ); -- -- Name: staff_role_staff_role_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.staff_role_staff_role_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: staff_role_staff_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.staff_role_staff_role_id_seq OWNED BY public.staff_role.staff_role_id; -- -- Name: staff_team; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.staff_team ( staff_team_id integer NOT NULL, team_name character varying(50) NOT NULL ); -- -- Name: staff_team_event_schedule; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.staff_team_event_schedule ( schedule_id integer NOT NULL, shift_start timestamp without time zone NOT NULL, shift_end timestamp without time zone NOT NULL, is_available boolean DEFAULT true NOT NULL, staff_team_id integer NOT NULL, event_id integer NOT NULL, CONSTRAINT chk_shift_chronology CHECK ((shift_end > shift_start)) ); -- -- Name: staff_team_event_schedule_schedule_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.staff_team_event_schedule_schedule_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: staff_team_event_schedule_schedule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.staff_team_event_schedule_schedule_id_seq OWNED BY public.staff_team_event_schedule.schedule_id; -- -- Name: staff_team_staff_team_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.staff_team_staff_team_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: staff_team_staff_team_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.staff_team_staff_team_id_seq OWNED BY public.staff_team.staff_team_id; -- -- Name: subscription_location; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.subscription_location ( user_id bigint NOT NULL, location_id integer NOT NULL, subscription_location_id integer NOT NULL, created_at timestamp without time zone NOT NULL ); -- -- Name: subscription_location_subscription_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.subscription_location_subscription_location_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: subscription_location_subscription_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.subscription_location_subscription_location_id_seq OWNED BY public.subscription_location.subscription_location_id; -- -- Name: subscription_organiser; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.subscription_organiser ( user_id bigint NOT NULL, organiser_id integer NOT NULL, subscription_organiser_id integer NOT NULL, created_at timestamp without time zone NOT NULL ); -- -- Name: subscription_organiser_subscription_organiser_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.subscription_organiser_subscription_organiser_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: subscription_organiser_subscription_organiser_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.subscription_organiser_subscription_organiser_id_seq OWNED BY public.subscription_organiser.subscription_organiser_id; -- -- Name: ticket; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.ticket ( order_id bigint NOT NULL, ticket_id bigint NOT NULL, ticket_type_id integer NOT NULL, lock_expires_at timestamp without time zone NOT NULL, status character varying(50) NOT NULL, barcode_hash character varying(255) NOT NULL, seat_id integer, is_scanned boolean NOT NULL, scanned_at timestamp without time zone, is_presale boolean NOT NULL, CONSTRAINT chk_ticket_scanned_at_consistency CHECK ((((is_scanned = true) AND (scanned_at IS NOT NULL)) OR ((is_scanned = false) AND (scanned_at IS NULL)))) ); -- -- Name: ticket_ticket_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.ticket_ticket_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: ticket_ticket_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.ticket_ticket_id_seq OWNED BY public.ticket.ticket_id; -- -- Name: ticket_type; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.ticket_type ( event_id integer NOT NULL, ticket_type_id integer NOT NULL, tier_name character varying(100) NOT NULL, total_allocated integer NOT NULL, presale_start timestamp without time zone, presale_end timestamp without time zone, CONSTRAINT chk_presale_chronology CHECK ((presale_end > presale_start)), CONSTRAINT chk_ticket_allocated CHECK ((total_allocated >= 0)) ); -- -- Name: ticket_type_ticket_type_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.ticket_type_ticket_type_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: ticket_type_ticket_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.ticket_type_ticket_type_id_seq OWNED BY public.ticket_type.ticket_type_id; -- -- Name: value; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.value ( attribute_id integer NOT NULL, value_id integer NOT NULL, value_string text, value_int integer, value_datetime timestamp without time zone, value_bool boolean, event_id integer NOT NULL ); -- -- Name: value_value_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.value_value_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: value_value_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.value_value_id_seq OWNED BY public.value.value_id; -- -- Name: waitlist_entry; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.waitlist_entry ( waitlist_id bigint NOT NULL, joined_at timestamp without time zone NOT NULL, status character varying(20) NOT NULL, notified_at timestamp without time zone, expires_at timestamp without time zone, user_id bigint NOT NULL, event_schedule_session_id integer NOT NULL ); -- -- Name: waitlist_entry_waitlist_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.waitlist_entry_waitlist_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: waitlist_entry_waitlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.waitlist_entry_waitlist_id_seq OWNED BY public.waitlist_entry.waitlist_id; -- -- Name: attribute attribute_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.attribute ALTER COLUMN attribute_id SET DEFAULT nextval('public.attribute_attribute_id_seq'::regclass); -- -- Name: category id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.category ALTER COLUMN id SET DEFAULT nextval('public.category_id_seq'::regclass); -- -- Name: discount discount_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.discount ALTER COLUMN discount_id SET DEFAULT nextval('public.discount_discount_id_seq'::regclass); -- -- Name: event event_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event ALTER COLUMN event_id SET DEFAULT nextval('public.event_event_id_seq'::regclass); -- -- Name: event_category event_category_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_category ALTER COLUMN event_category_id SET DEFAULT nextval('public.event_category_event_category_id_seq'::regclass); -- -- Name: event_schedule_session schedule_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_schedule_session ALTER COLUMN schedule_id SET DEFAULT nextval('public.event_schedule_session_schedule_id_seq'::regclass); -- -- Name: event_status event_status_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_status ALTER COLUMN event_status_id SET DEFAULT nextval('public.event_status_event_status_id_seq'::regclass); -- -- Name: exhibitor exhibitor_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.exhibitor ALTER COLUMN exhibitor_id SET DEFAULT nextval('public.exhibitor_exhibitor_id_seq'::regclass); -- -- Name: exhibitor_event_schedule_session exhibitor_event_schedule_session_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.exhibitor_event_schedule_session ALTER COLUMN exhibitor_event_schedule_session_id SET DEFAULT nextval('public.exhibitor_event_schedule_sess_exhibitor_event_schedule_sess_seq'::regclass); -- -- Name: field field_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.field ALTER COLUMN field_id SET DEFAULT nextval('public.field_field_id_seq'::regclass); -- -- Name: location location_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.location ALTER COLUMN location_id SET DEFAULT nextval('public.location_location_id_seq'::regclass); -- -- Name: location_type type_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.location_type ALTER COLUMN type_id SET DEFAULT nextval('public.location_type_type_id_seq'::regclass); -- -- Name: order_cart order_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.order_cart ALTER COLUMN order_id SET DEFAULT nextval('public."Order_order_id_seq"'::regclass); -- -- Name: order_status status_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.order_status ALTER COLUMN status_id SET DEFAULT nextval('public.order_status_status_id_seq'::regclass); -- -- Name: organiser organiser_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.organiser ALTER COLUMN organiser_id SET DEFAULT nextval('public.organiser_organiser_id_seq'::regclass); -- -- Name: payment payment_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.payment ALTER COLUMN payment_id SET DEFAULT nextval('public.payment_payment_id_seq'::regclass); -- -- Name: payment_method method_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.payment_method ALTER COLUMN method_id SET DEFAULT nextval('public.payment_method_method_id_seq'::regclass); -- -- Name: price_tier price_tier_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.price_tier ALTER COLUMN price_tier_id SET DEFAULT nextval('public.price_tier_price_tier_id_seq'::regclass); -- -- Name: promo_code promo_code_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.promo_code ALTER COLUMN promo_code_id SET DEFAULT nextval('public.promo_code_promo_code_id_seq'::regclass); -- -- Name: refund_request refund_request_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.refund_request ALTER COLUMN refund_request_id SET DEFAULT nextval('public.refund_request_refund_request_id_seq'::regclass); -- -- Name: review review_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.review ALTER COLUMN review_id SET DEFAULT nextval('public.review_review_id_seq'::regclass); -- -- Name: seat seat_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.seat ALTER COLUMN seat_id SET DEFAULT nextval('public.seat_seat_id_seq'::regclass); -- -- Name: section section_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.section ALTER COLUMN section_id SET DEFAULT nextval('public.section_section_id_seq'::regclass); -- -- Name: sponsor sponsor_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor ALTER COLUMN sponsor_id SET DEFAULT nextval('public.sponsor_sponsor_id_seq'::regclass); -- -- Name: sponsor_event sponsor_event_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor_event ALTER COLUMN sponsor_event_id SET DEFAULT nextval('public.sponsor_event_sponsor_event_id_seq'::regclass); -- -- Name: sponsor_type sponsor_type_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor_type ALTER COLUMN sponsor_type_id SET DEFAULT nextval('public.sponsor_type_sponsor_type_id_seq'::regclass); -- -- Name: sponsor_type_sponsor sponsor_type_sponsor_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor_type_sponsor ALTER COLUMN sponsor_type_sponsor_id SET DEFAULT nextval('public.sponsor_type_sponsor_sponsor_type_sponsor_id_seq'::regclass); -- -- Name: staff_member staff_member_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_member ALTER COLUMN staff_member_id SET DEFAULT nextval('public.staff_member_staff_member_id_seq'::regclass); -- -- Name: staff_role staff_role_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_role ALTER COLUMN staff_role_id SET DEFAULT nextval('public.staff_role_staff_role_id_seq'::regclass); -- -- Name: staff_team staff_team_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_team ALTER COLUMN staff_team_id SET DEFAULT nextval('public.staff_team_staff_team_id_seq'::regclass); -- -- Name: staff_team_event_schedule schedule_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_team_event_schedule ALTER COLUMN schedule_id SET DEFAULT nextval('public.staff_team_event_schedule_schedule_id_seq'::regclass); -- -- Name: subscription_location subscription_location_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.subscription_location ALTER COLUMN subscription_location_id SET DEFAULT nextval('public.subscription_location_subscription_location_id_seq'::regclass); -- -- Name: subscription_organiser subscription_organiser_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.subscription_organiser ALTER COLUMN subscription_organiser_id SET DEFAULT nextval('public.subscription_organiser_subscription_organiser_id_seq'::regclass); -- -- Name: ticket ticket_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.ticket ALTER COLUMN ticket_id SET DEFAULT nextval('public.ticket_ticket_id_seq'::regclass); -- -- Name: ticket_type ticket_type_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.ticket_type ALTER COLUMN ticket_type_id SET DEFAULT nextval('public.ticket_type_ticket_type_id_seq'::regclass); -- -- Name: user_app user_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.user_app ALTER COLUMN user_id SET DEFAULT nextval('public."User_user_id_seq"'::regclass); -- -- Name: value value_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.value ALTER COLUMN value_id SET DEFAULT nextval('public.value_value_id_seq'::regclass); -- -- Name: waitlist_entry waitlist_id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.waitlist_entry ALTER COLUMN waitlist_id SET DEFAULT nextval('public.waitlist_entry_waitlist_id_seq'::regclass); -- -- Name: order_cart Order_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.order_cart ADD CONSTRAINT "Order_pkey" PRIMARY KEY (order_id); -- -- Name: user_app User_email_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.user_app ADD CONSTRAINT "User_email_key" UNIQUE (email); -- -- Name: user_app User_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.user_app ADD CONSTRAINT "User_pkey" PRIMARY KEY (user_id); -- -- Name: attribute attribute_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.attribute ADD CONSTRAINT attribute_pkey PRIMARY KEY (attribute_id); -- -- Name: category category_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.category ADD CONSTRAINT category_name_key UNIQUE (name); -- -- Name: category category_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.category ADD CONSTRAINT category_pkey PRIMARY KEY (id); -- -- Name: discount discount_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.discount ADD CONSTRAINT discount_pkey PRIMARY KEY (discount_id); -- -- Name: event_category event_category_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_category ADD CONSTRAINT event_category_pkey PRIMARY KEY (event_category_id); -- -- Name: event event_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event ADD CONSTRAINT event_pkey PRIMARY KEY (event_id); -- -- Name: event_schedule_session event_schedule_session_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_schedule_session ADD CONSTRAINT event_schedule_session_pkey PRIMARY KEY (schedule_id); -- -- Name: event_status event_status_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_status ADD CONSTRAINT event_status_pkey PRIMARY KEY (event_status_id); -- -- Name: event_status event_status_status_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_status ADD CONSTRAINT event_status_status_name_key UNIQUE (status_name); -- -- Name: exhibitor_event_schedule_session exhibitor_event_schedule_session_event_schedule_session_id_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.exhibitor_event_schedule_session ADD CONSTRAINT exhibitor_event_schedule_session_event_schedule_session_id_key UNIQUE (event_schedule_session_id); -- -- Name: exhibitor_event_schedule_session exhibitor_event_schedule_session_exhibitor_id_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.exhibitor_event_schedule_session ADD CONSTRAINT exhibitor_event_schedule_session_exhibitor_id_key UNIQUE (exhibitor_id); -- -- Name: exhibitor_event_schedule_session exhibitor_event_schedule_session_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.exhibitor_event_schedule_session ADD CONSTRAINT exhibitor_event_schedule_session_pkey PRIMARY KEY (exhibitor_event_schedule_session_id); -- -- Name: exhibitor exhibitor_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.exhibitor ADD CONSTRAINT exhibitor_pkey PRIMARY KEY (exhibitor_id); -- -- Name: field field_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.field ADD CONSTRAINT field_pkey PRIMARY KEY (field_id); -- -- Name: location location_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.location ADD CONSTRAINT location_pkey PRIMARY KEY (location_id); -- -- Name: location_type location_type_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.location_type ADD CONSTRAINT location_type_pkey PRIMARY KEY (type_id); -- -- Name: location_type location_type_type_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.location_type ADD CONSTRAINT location_type_type_name_key UNIQUE (type_name); -- -- Name: order_status order_status_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.order_status ADD CONSTRAINT order_status_pkey PRIMARY KEY (status_id); -- -- Name: order_status order_status_status_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.order_status ADD CONSTRAINT order_status_status_name_key UNIQUE (status_name); -- -- Name: organiser organiser_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.organiser ADD CONSTRAINT organiser_pkey PRIMARY KEY (organiser_id); -- -- Name: payment_method payment_method_method_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.payment_method ADD CONSTRAINT payment_method_method_name_key UNIQUE (method_name); -- -- Name: payment_method payment_method_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.payment_method ADD CONSTRAINT payment_method_pkey PRIMARY KEY (method_id); -- -- Name: payment payment_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.payment ADD CONSTRAINT payment_pkey PRIMARY KEY (payment_id); -- -- Name: price_tier price_tier_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.price_tier ADD CONSTRAINT price_tier_pkey PRIMARY KEY (price_tier_id); -- -- Name: promo_code promo_code_code_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.promo_code ADD CONSTRAINT promo_code_code_key UNIQUE (code); -- -- Name: promo_code promo_code_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.promo_code ADD CONSTRAINT promo_code_pkey PRIMARY KEY (promo_code_id); -- -- Name: refund_request refund_request_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.refund_request ADD CONSTRAINT refund_request_pkey PRIMARY KEY (refund_request_id); -- -- Name: review review_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.review ADD CONSTRAINT review_pkey PRIMARY KEY (review_id); -- -- Name: seat seat_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.seat ADD CONSTRAINT seat_pkey PRIMARY KEY (seat_id); -- -- Name: section section_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.section ADD CONSTRAINT section_pkey PRIMARY KEY (section_id); -- -- Name: sponsor_event sponsor_event_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor_event ADD CONSTRAINT sponsor_event_pkey PRIMARY KEY (sponsor_event_id); -- -- Name: sponsor sponsor_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor ADD CONSTRAINT sponsor_name_key UNIQUE (name); -- -- Name: sponsor sponsor_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor ADD CONSTRAINT sponsor_pkey PRIMARY KEY (sponsor_id); -- -- Name: sponsor_type sponsor_type_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor_type ADD CONSTRAINT sponsor_type_pkey PRIMARY KEY (sponsor_type_id); -- -- Name: sponsor_type_sponsor sponsor_type_sponsor_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor_type_sponsor ADD CONSTRAINT sponsor_type_sponsor_pkey PRIMARY KEY (sponsor_type_sponsor_id); -- -- Name: staff_member staff_member_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_member ADD CONSTRAINT staff_member_pkey PRIMARY KEY (staff_member_id); -- -- Name: staff_role staff_role_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_role ADD CONSTRAINT staff_role_pkey PRIMARY KEY (staff_role_id); -- -- Name: staff_team_event_schedule staff_team_event_schedule_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_team_event_schedule ADD CONSTRAINT staff_team_event_schedule_pkey PRIMARY KEY (schedule_id); -- -- Name: staff_team staff_team_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_team ADD CONSTRAINT staff_team_pkey PRIMARY KEY (staff_team_id); -- -- Name: subscription_location subscription_location_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.subscription_location ADD CONSTRAINT subscription_location_pkey PRIMARY KEY (subscription_location_id); -- -- Name: subscription_organiser subscription_organiser_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.subscription_organiser ADD CONSTRAINT subscription_organiser_pkey PRIMARY KEY (subscription_organiser_id); -- -- Name: ticket ticket_barcode_hash_key; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.ticket ADD CONSTRAINT ticket_barcode_hash_key UNIQUE (barcode_hash); -- -- Name: ticket ticket_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.ticket ADD CONSTRAINT ticket_pkey PRIMARY KEY (ticket_id); -- -- Name: ticket_type ticket_type_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.ticket_type ADD CONSTRAINT ticket_type_pkey PRIMARY KEY (ticket_type_id); -- -- Name: exhibitor_event_schedule_session uq_exhibitor_session; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.exhibitor_event_schedule_session ADD CONSTRAINT uq_exhibitor_session UNIQUE (exhibitor_id, event_schedule_session_id); -- -- Name: review uq_user_event_review; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.review ADD CONSTRAINT uq_user_event_review UNIQUE (user_id, event_id); -- -- Name: subscription_location uq_user_location_sub; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.subscription_location ADD CONSTRAINT uq_user_location_sub UNIQUE (user_id, location_id); -- -- Name: subscription_organiser uq_user_organiser_sub; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.subscription_organiser ADD CONSTRAINT uq_user_organiser_sub UNIQUE (user_id, organiser_id); -- -- Name: waitlist_entry uq_user_session_waitlist; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.waitlist_entry ADD CONSTRAINT uq_user_session_waitlist UNIQUE (user_id, event_schedule_session_id); -- -- Name: value value_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.value ADD CONSTRAINT value_pkey PRIMARY KEY (value_id); -- -- Name: waitlist_entry waitlist_entry_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.waitlist_entry ADD CONSTRAINT waitlist_entry_pkey PRIMARY KEY (waitlist_id); -- -- Name: discount fk_discount_promo; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.discount ADD CONSTRAINT fk_discount_promo FOREIGN KEY (promo_code_id) REFERENCES public.promo_code(promo_code_id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: event_category fk_evcat_category; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_category ADD CONSTRAINT fk_evcat_category FOREIGN KEY (category_id) REFERENCES public.category(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: event_category fk_evcat_event; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_category ADD CONSTRAINT fk_evcat_event FOREIGN KEY (event_id) REFERENCES public.event(event_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: event fk_event_organiser; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event ADD CONSTRAINT fk_event_organiser FOREIGN KEY (organiser_id) REFERENCES public.organiser(organiser_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: event fk_event_status; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event ADD CONSTRAINT fk_event_status FOREIGN KEY (event_status_id) REFERENCES public.event_status(event_status_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: exhibitor fk_exhibitor_field; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.exhibitor ADD CONSTRAINT fk_exhibitor_field FOREIGN KEY (field_id) REFERENCES public.field(field_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: exhibitor_event_schedule_session fk_exsess_exhibitor; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.exhibitor_event_schedule_session ADD CONSTRAINT fk_exsess_exhibitor FOREIGN KEY (exhibitor_id) REFERENCES public.exhibitor(exhibitor_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: exhibitor_event_schedule_session fk_exsess_session; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.exhibitor_event_schedule_session ADD CONSTRAINT fk_exsess_session FOREIGN KEY (event_schedule_session_id) REFERENCES public.event_schedule_session(schedule_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: location fk_location_type; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.location ADD CONSTRAINT fk_location_type FOREIGN KEY (type_id) REFERENCES public.location_type(type_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: order_cart fk_order_discount; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.order_cart ADD CONSTRAINT fk_order_discount FOREIGN KEY (discount_id) REFERENCES public.discount(discount_id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: order_cart fk_order_status; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.order_cart ADD CONSTRAINT fk_order_status FOREIGN KEY (status_id) REFERENCES public.order_status(status_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: order_cart fk_order_user; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.order_cart ADD CONSTRAINT fk_order_user FOREIGN KEY (user_id) REFERENCES public.user_app(user_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: payment fk_payment_method; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.payment ADD CONSTRAINT fk_payment_method FOREIGN KEY (method_id) REFERENCES public.payment_method(method_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: payment fk_payment_order; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.payment ADD CONSTRAINT fk_payment_order FOREIGN KEY (order_id) REFERENCES public.order_cart(order_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: price_tier fk_pricetier_tickettype; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.price_tier ADD CONSTRAINT fk_pricetier_tickettype FOREIGN KEY (ticket_type_id) REFERENCES public.ticket_type(ticket_type_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: refund_request fk_refund_payment; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.refund_request ADD CONSTRAINT fk_refund_payment FOREIGN KEY (payment_id) REFERENCES public.payment(payment_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: refund_request fk_refund_user; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.refund_request ADD CONSTRAINT fk_refund_user FOREIGN KEY (user_id) REFERENCES public.user_app(user_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: review fk_review_event; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.review ADD CONSTRAINT fk_review_event FOREIGN KEY (event_id) REFERENCES public.event(event_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: review fk_review_user; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.review ADD CONSTRAINT fk_review_user FOREIGN KEY (user_id) REFERENCES public.user_app(user_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: seat fk_seat_section; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.seat ADD CONSTRAINT fk_seat_section FOREIGN KEY (section_id) REFERENCES public.section(section_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: section fk_section_location; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.section ADD CONSTRAINT fk_section_location FOREIGN KEY (location_id) REFERENCES public.location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: event_schedule_session fk_session_event; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_schedule_session ADD CONSTRAINT fk_session_event FOREIGN KEY (event_id) REFERENCES public.event(event_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: event_schedule_session fk_session_section; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.event_schedule_session ADD CONSTRAINT fk_session_section FOREIGN KEY (section_id) REFERENCES public.section(section_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: sponsor_event fk_spev_event; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor_event ADD CONSTRAINT fk_spev_event FOREIGN KEY (event_id) REFERENCES public.event(event_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sponsor_event fk_spev_sponsor; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor_event ADD CONSTRAINT fk_spev_sponsor FOREIGN KEY (sponsor_id) REFERENCES public.sponsor(sponsor_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sponsor_type_sponsor fk_sptypesp_sp; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor_type_sponsor ADD CONSTRAINT fk_sptypesp_sp FOREIGN KEY (sponsor_id) REFERENCES public.sponsor(sponsor_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sponsor_type_sponsor fk_sptypesp_type; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.sponsor_type_sponsor ADD CONSTRAINT fk_sptypesp_type FOREIGN KEY (sponsor_type_id) REFERENCES public.sponsor_type(sponsor_type_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: staff_member fk_staff_role; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_member ADD CONSTRAINT fk_staff_role FOREIGN KEY (assigned_role) REFERENCES public.staff_role(staff_role_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: staff_member fk_staff_team; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_member ADD CONSTRAINT fk_staff_team FOREIGN KEY (staff_team_id) REFERENCES public.staff_team(staff_team_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: staff_team_event_schedule fk_staffsched_event; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_team_event_schedule ADD CONSTRAINT fk_staffsched_event FOREIGN KEY (event_id) REFERENCES public.event(event_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: staff_team_event_schedule fk_staffsched_team; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.staff_team_event_schedule ADD CONSTRAINT fk_staffsched_team FOREIGN KEY (staff_team_id) REFERENCES public.staff_team(staff_team_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: subscription_location fk_subloc_loc; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.subscription_location ADD CONSTRAINT fk_subloc_loc FOREIGN KEY (location_id) REFERENCES public.location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: subscription_location fk_subloc_user; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.subscription_location ADD CONSTRAINT fk_subloc_user FOREIGN KEY (user_id) REFERENCES public.user_app(user_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: subscription_organiser fk_suborg_org; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.subscription_organiser ADD CONSTRAINT fk_suborg_org FOREIGN KEY (organiser_id) REFERENCES public.organiser(organiser_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: subscription_organiser fk_suborg_user; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.subscription_organiser ADD CONSTRAINT fk_suborg_user FOREIGN KEY (user_id) REFERENCES public.user_app(user_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: ticket fk_ticket_order; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.ticket ADD CONSTRAINT fk_ticket_order FOREIGN KEY (order_id) REFERENCES public.order_cart(order_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: ticket fk_ticket_seat; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.ticket ADD CONSTRAINT fk_ticket_seat FOREIGN KEY (seat_id) REFERENCES public.seat(seat_id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: ticket fk_ticket_type; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.ticket ADD CONSTRAINT fk_ticket_type FOREIGN KEY (ticket_type_id) REFERENCES public.ticket_type(ticket_type_id) ON UPDATE CASCADE ON DELETE RESTRICT; -- -- Name: ticket_type fk_tickettype_event; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.ticket_type ADD CONSTRAINT fk_tickettype_event FOREIGN KEY (event_id) REFERENCES public.event(event_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: value fk_value_attr; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.value ADD CONSTRAINT fk_value_attr FOREIGN KEY (attribute_id) REFERENCES public.attribute(attribute_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: value fk_value_event; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.value ADD CONSTRAINT fk_value_event FOREIGN KEY (event_id) REFERENCES public.event(event_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: waitlist_entry fk_waitlist_session; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.waitlist_entry ADD CONSTRAINT fk_waitlist_session FOREIGN KEY (event_schedule_session_id) REFERENCES public.event_schedule_session(schedule_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: waitlist_entry fk_waitlist_user; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.waitlist_entry ADD CONSTRAINT fk_waitlist_user FOREIGN KEY (user_id) REFERENCES public.user_app(user_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- PostgreSQL database dump complete --