



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

CREATE TABLE public.agenda_items (
    id bigint NOT NULL,
    agenda_id bigint,
    start_times text NOT NULL,
    end_times text NOT NULL,
    topics text NOT NULL,
    created_by bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.agenda_items OWNER TO postgres;

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

CREATE SEQUENCE public.agenda_items_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.agenda_items_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.agenda_items_id_seq OWNED BY public.agenda_items.id;


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

CREATE TABLE public.agendas (
    id bigint NOT NULL,
    day_number integer NOT NULL,
    date character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.agendas OWNER TO postgres;

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

CREATE SEQUENCE public.agendas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.agendas_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.agendas_id_seq OWNED BY public.agendas.id;


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

CREATE TABLE public.booking_items (
    id bigint NOT NULL,
    booth_booking_id bigint NOT NULL,
    booth_id bigint NOT NULL,
    price_at_booking numeric(15,2) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.booking_items OWNER TO postgres;

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

CREATE SEQUENCE public.booking_items_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.booking_items_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.booking_items_id_seq OWNED BY public.booking_items.id;


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

CREATE TABLE public.booth_bookings (
    id bigint NOT NULL,
    usereventregistration_id bigint NOT NULL,
    company_id bigint NOT NULL,
    subtotal numeric(15,2) NOT NULL,
    add_on_total numeric(15,2) DEFAULT '0'::numeric NOT NULL,
    grand_total numeric(15,2) NOT NULL,
    status character varying(255) DEFAULT 'pending'::character varying NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT booth_bookings_status_check CHECK (((status)::text = ANY ((ARRAY['pending'::character varying, 'confirmed'::character varying, 'cancelled'::character varying])::text[])))
);


ALTER TABLE public.booth_bookings OWNER TO postgres;

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

CREATE SEQUENCE public.booth_bookings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.booth_bookings_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.booth_bookings_id_seq OWNED BY public.booth_bookings.id;


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

CREATE TABLE public.booths (
    id bigint NOT NULL,
    booth_number character varying(255) NOT NULL,
    dimensions character varying(255) DEFAULT '3m x 3m (9 SQM)'::character varying NOT NULL,
    scheme_type character varying(255) DEFAULT 'Standard Shell Scheme'::character varying NOT NULL,
    furniture_set text NOT NULL,
    utilities text NOT NULL,
    visibility character varying(255) DEFAULT 'Prime location'::character varying NOT NULL,
    price numeric(15,2) DEFAULT '45000'::numeric NOT NULL,
    status character varying(255) DEFAULT 'available'::character varying NOT NULL,
    type character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT booths_status_check CHECK (((status)::text = ANY ((ARRAY['available'::character varying, 'booked'::character varying, 'reserved'::character varying])::text[])))
);


ALTER TABLE public.booths OWNER TO postgres;

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

CREATE SEQUENCE public.booths_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.booths_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.booths_id_seq OWNED BY public.booths.id;


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

CREATE TABLE public.companies (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    website character varying(255),
    industry character varying(255),
    bio text,
    logo_path character varying(255),
    banner character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.companies OWNER TO postgres;

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

CREATE SEQUENCE public.companies_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.companies_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.companies_id_seq OWNED BY public.companies.id;


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

CREATE TABLE public.eventagenders (
    id bigint NOT NULL,
    event_id bigint NOT NULL,
    agenda text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.eventagenders OWNER TO postgres;

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

CREATE SEQUENCE public.eventagenders_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.eventagenders_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.eventagenders_id_seq OWNED BY public.eventagenders.id;


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

CREATE TABLE public.events (
    id bigint NOT NULL,
    institution_name character varying(255) NOT NULL,
    logo_url character varying(255),
    title character varying(255) NOT NULL,
    description text,
    start_date date,
    end_date date,
    photo_url character varying(255),
    control_number character varying(255),
    venue_id bigint,
    status bigint,
    createdby bigint,
    modifiedby bigint,
    company_id bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.events OWNER TO postgres;

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

CREATE SEQUENCE public.events_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.events_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.events_id_seq OWNED BY public.events.id;


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

CREATE TABLE public.eventsessions (
    id bigint NOT NULL,
    event_id bigint NOT NULL,
    quest_id bigint,
    title character varying(255) NOT NULL,
    description text,
    start_date date,
    end_date date,
    start_time time(0) without time zone,
    end_time time(0) without time zone,
    createdby bigint,
    modifiedby bigint,
    company_id bigint,
    status bigint,
    location character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.eventsessions OWNER TO postgres;

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

CREATE SEQUENCE public.eventsessions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.eventsessions_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.eventsessions_id_seq OWNED BY public.eventsessions.id;


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

CREATE TABLE public.facilities (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    venue_id bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.facilities OWNER TO postgres;

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

CREATE SEQUENCE public.facilities_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.facilities_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.facilities_id_seq OWNED BY public.facilities.id;


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

CREATE TABLE public.failed_jobs (
    id bigint NOT NULL,
    uuid character varying(255) NOT NULL,
    connection text NOT NULL,
    queue text NOT NULL,
    payload text NOT NULL,
    exception text NOT NULL,
    failed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.failed_jobs OWNER TO postgres;

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

CREATE SEQUENCE public.failed_jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.failed_jobs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id;


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

CREATE TABLE public.guests (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    title character varying(255),
    role character varying(255) NOT NULL,
    bio text,
    photo_url character varying(255),
    venue_id bigint,
    createdby bigint,
    modifiedby bigint,
    company_id bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.guests OWNER TO postgres;

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

CREATE SEQUENCE public.guests_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.guests_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.guests_id_seq OWNED BY public.guests.id;


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

CREATE TABLE public.media_attendance_days (
    id bigint NOT NULL,
    media_registration_id bigint NOT NULL,
    day character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.media_attendance_days OWNER TO postgres;

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

CREATE SEQUENCE public.media_attendance_days_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.media_attendance_days_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.media_attendance_days_id_seq OWNED BY public.media_attendance_days.id;


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

CREATE TABLE public.media_registrations (
    id bigint NOT NULL,
    usereventregistration_id bigint NOT NULL,
    media_name character varying(255) NOT NULL,
    website_url character varying(255),
    press_id_number character varying(255),
    dietary_accessibility character varying(255),
    terms_acceptance boolean DEFAULT false NOT NULL,
    portfolio_url text,
    media_type character varying(255),
    news_segment boolean DEFAULT false NOT NULL,
    interview_request boolean DEFAULT false NOT NULL,
    live_stream boolean DEFAULT false NOT NULL,
    social_media boolean DEFAULT false NOT NULL,
    assignment_letter character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.media_registrations OWNER TO postgres;

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

CREATE SEQUENCE public.media_registrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.media_registrations_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.media_registrations_id_seq OWNED BY public.media_registrations.id;


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

CREATE TABLE public.migrations (
    id integer NOT NULL,
    migration character varying(255) NOT NULL,
    batch integer NOT NULL
);


ALTER TABLE public.migrations OWNER TO postgres;

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

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


ALTER SEQUENCE public.migrations_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id;


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

CREATE TABLE public.notifications (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    content character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.notifications OWNER TO postgres;

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

CREATE SEQUENCE public.notifications_id_seq
    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: organizations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.organizations (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    business_model character varying(255) NOT NULL,
    usereventregistration_id bigint,
    createdby bigint,
    modifiedby bigint,
    status character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.organizations OWNER TO postgres;

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

CREATE SEQUENCE public.organizations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.organizations_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.organizations_id_seq OWNED BY public.organizations.id;


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

CREATE TABLE public.packages (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    features json NOT NULL,
    price numeric(10,2) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.packages OWNER TO postgres;

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

CREATE SEQUENCE public.packages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.packages_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.packages_id_seq OWNED BY public.packages.id;

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

CREATE TABLE public.permission_roles (
    id bigint NOT NULL,
    permission_id bigint NOT NULL,
    role_id bigint NOT NULL
);


ALTER TABLE public.permission_roles OWNER TO postgres;

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

CREATE SEQUENCE public.permission_roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.permission_roles_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.permission_roles_id_seq OWNED BY public.permission_roles.id;


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

CREATE TABLE public.permissions (
    id bigint NOT NULL,
    permission_name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.permissions OWNER TO postgres;

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

CREATE SEQUENCE public.permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.permissions_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.permissions_id_seq OWNED BY public.permissions.id;

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

CREATE SEQUENCE public.personal_access_tokens_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.personal_access_tokens_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.personal_access_tokens_id_seq OWNED BY public.personal_access_tokens.id;


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

CREATE TABLE public.registration_meeting_types (
    id bigint NOT NULL,
    usereventregistration_id bigint NOT NULL,
    meeting_type character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.registration_meeting_types OWNER TO postgres;

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

CREATE SEQUENCE public.registration_meeting_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.registration_meeting_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.registration_meeting_types_id_seq OWNED BY public.registration_meeting_types.id;


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

CREATE TABLE public.registration_target_entities (
    id bigint NOT NULL,
    usereventregistration_id bigint NOT NULL,
    entity_name character varying(255),
    entity_type character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.registration_target_entities OWNER TO postgres;

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

CREATE SEQUENCE public.registration_target_entities_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.registration_target_entities_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.registration_target_entities_id_seq OWNED BY public.registration_target_entities.id;


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

CREATE TABLE public.roles (
    id bigint NOT NULL,
    role_name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.roles OWNER TO postgres;

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

CREATE SEQUENCE public.roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.roles_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.roles_id_seq OWNED BY public.roles.id;


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

CREATE TABLE public.sectors (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    status boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sectors OWNER TO postgres;

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

CREATE SEQUENCE public.sectors_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.sectors_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sectors_id_seq OWNED BY public.sectors.id;


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

CREATE TABLE public.sessionparticipants (
    id bigint NOT NULL,
    eventsession_id bigint NOT NULL,
    participant character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sessionparticipants OWNER TO postgres;

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

CREATE SEQUENCE public.sessionparticipants_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.sessionparticipants_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sessionparticipants_id_seq OWNED BY public.sessionparticipants.id;


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

CREATE TABLE public.sessions (
    id character varying(255) NOT NULL,
    user_id bigint,
    ip_address character varying(45),
    user_agent text,
    payload text NOT NULL,
    last_activity integer NOT NULL
);


ALTER TABLE public.sessions OWNER TO postgres;

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

CREATE TABLE public.side_events (
    id bigint NOT NULL,
    event_date character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    theme text NOT NULL,
    created_by bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.side_events OWNER TO postgres;

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

CREATE SEQUENCE public.side_events_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.side_events_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.side_events_id_seq OWNED BY public.side_events.id;


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

CREATE TABLE public.speaker_agendas (
    id bigint NOT NULL,
    speaker_id bigint NOT NULL,
    agenda_id bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.speaker_agendas OWNER TO postgres;

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

CREATE SEQUENCE public.speaker_agendas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.speaker_agendas_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.speaker_agendas_id_seq OWNED BY public.speaker_agendas.id;


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

CREATE TABLE public.speaker_side_events (
    id bigint NOT NULL,
    speaker_id bigint NOT NULL,
    side_event_id bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.speaker_side_events OWNER TO postgres;

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

CREATE SEQUENCE public.speaker_side_events_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.speaker_side_events_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.speaker_side_events_id_seq OWNED BY public.speaker_side_events.id;


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

CREATE TABLE public.speakers (
    id bigint NOT NULL,
    usereventregistration_id bigint NOT NULL,
    name character varying(255),
    role character varying(255),
    cv_path character varying(255),
    have_you_spoken character varying(255),
    condition character varying(255),
    linkedin_url character varying(255),
    website_url character varying(255),
    request_description character varying(255),
    previous_speaking_experience character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.speakers OWNER TO postgres;

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

CREATE SEQUENCE public.speakers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.speakers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.speakers_id_seq OWNED BY public.speakers.id;


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

CREATE TABLE public.tournaments (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    description text NOT NULL,
    amount numeric(10,2),
    image_url character varying(255),
    type character varying(255),
    created_by bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.tournaments OWNER TO postgres;

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

CREATE SEQUENCE public.tournaments_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.tournaments_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tournaments_id_seq OWNED BY public.tournaments.id;


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

CREATE TABLE public.user_registration_tournament (
    id bigint NOT NULL,
    usereventregistration_id bigint NOT NULL,
    tournament_id bigint NOT NULL,
    amount_paid numeric(10,2),
    payment_control_number character varying(255),
    payment_status integer DEFAULT 0 NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.user_registration_tournament OWNER TO postgres;

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

CREATE SEQUENCE public.user_registration_tournament_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.user_registration_tournament_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.user_registration_tournament_id_seq OWNED BY public.user_registration_tournament.id;


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

CREATE TABLE public.user_roles (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    role_id bigint NOT NULL
);


ALTER TABLE public.user_roles OWNER TO postgres;

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

CREATE SEQUENCE public.user_roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.user_roles_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.user_roles_id_seq OWNED BY public.user_roles.id;


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

CREATE TABLE public.user_side_events (
    id bigint NOT NULL,
    usereventregistration_id bigint NOT NULL,
    side_event_id bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.user_side_events OWNER TO postgres;

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

CREATE SEQUENCE public.user_side_events_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.user_side_events_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.user_side_events_id_seq OWNED BY public.user_side_events.id;


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

CREATE TABLE public.usereventregistrations (
    id bigint NOT NULL,
    fullname character varying(255) NOT NULL,
    salutation character varying(255),
    email character varying(255) NOT NULL,
    organization character varying(255),
    nature_of_business character varying(255),
    jobtitle character varying(255),
    package_category character varying(255),
    package_price double precision,
    extra_commitment character varying(255),
    sector_specify character varying(255),
    organization_id bigint,
    sector_id bigint,
    networkcheck bigint,
    sideeventcheck bigint,
    galadinercheck bigint,
    phone character varying(255),
    "position" character varying(255),
    country character varying(255),
    home_country character varying(255),
    number_of_participants character varying(255),
    preferred_date date,
    meeting_purpose character varying(255),
    participant_type character varying(255),
    passport_photo character varying(255),
    passport_id character varying(255),
    controlnumber character varying(255),
    rejection_reason character varying(255),
    badge_url character varying(255),
    createdby bigint,
    modifiedby bigint,
    approvestatus bigint,
    status bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.usereventregistrations OWNER TO postgres;

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

CREATE SEQUENCE public.usereventregistrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.usereventregistrations_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.usereventregistrations_id_seq OWNED BY public.usereventregistrations.id;


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

CREATE TABLE public.userparticipants (
    id bigint NOT NULL,
    registration_id bigint NOT NULL,
    first_name character varying(255) NOT NULL,
    last_name character varying(255) NOT NULL,
    email character varying(255) NOT NULL,
    phone character varying(255) NOT NULL,
    photo_path character varying(255) NOT NULL,
    qr_code_path character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.userparticipants OWNER TO postgres;

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

CREATE SEQUENCE public.userparticipants_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.userparticipants_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.userparticipants_id_seq OWNED BY public.userparticipants.id;

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

CREATE SEQUENCE public.users_id_seq
    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: venues; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.venues (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    location text NOT NULL,
    capacity integer,
    description text,
    photo_url character varying(255),
    createdby bigint,
    modifiedby bigint,
    status bigint,
    company_id bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.venues OWNER TO postgres;

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

CREATE SEQUENCE public.venues_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.venues_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.venues_id_seq OWNED BY public.venues.id;


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

ALTER TABLE ONLY public.migrations ALTER COLUMN id SET DEFAULT nextval('public.migrations_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: organizations id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Data for Name: agenda_items; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.agenda_items (id, agenda_id, start_times, end_times, topics, created_by, created_at, updated_at) FROM stdin;
1	1	["10:22 PM"]	["10:21 PM"]	["Walkathon \\u2013 Health"]	3	2026-02-12 07:21:22	2026-02-12 07:21:22
2	1	["10:21 AM"]	["10:21 PM"]	["Welcome Remark and President Talk"]	3	2026-02-12 07:21:22	2026-02-12 07:21:22
3	2	["10:21 AM"]	["10:21 AM"]	["Welcome Remark and President Talk"]	3	2026-02-12 07:21:45	2026-02-12 07:21:45
\.


--
-- Data for Name: agendas; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.agendas (id, day_number, date, created_at, updated_at) FROM stdin;
1	1	2026-06-10	2026-02-12 07:21:22	2026-02-12 07:21:22
2	2	2026-07-09	2026-02-12 07:21:45	2026-02-12 07:21:45
\.


--
-- Data for Name: booking_items; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.booking_items (id, booth_booking_id, booth_id, price_at_booking, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: booth_bookings; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.booth_bookings (id, usereventregistration_id, company_id, subtotal, add_on_total, grand_total, status, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: booths; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.booths (id, booth_number, dimensions, scheme_type, furniture_set, utilities, visibility, price, status, type, created_at, updated_at) FROM stdin;
1	A-01	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
2	A-02	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
3	A-03	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	booked	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
4	A-04	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
5	B-01	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
6	B-02	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
7	B-03	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
8	B-04	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
9	C-01	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
10	C-02	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
11	C-03	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
12	C-04	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
13	D-01	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	booked	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
14	D-02	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
15	D-03	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
16	D-04	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
17	E-01	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
18	E-02	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
19	E-03	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
20	E-04	3m x 3m (9 SQM)	Standard Shell Scheme	1 Info Desk, 2 Chairs, 1 Waste Bin	1 Power (240V), 2 Spotlights, Wi-Fi	Prime location	45000.00	available	\N	2026-02-08 06:16:54	2026-02-08 06:16:54
\.


--
-- Data for Name: companies; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.companies (id, name, website, industry, bio, logo_path, banner, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: eventagenders; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.eventagenders (id, event_id, agenda, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.events (id, institution_name, logo_url, title, description, start_date, end_date, photo_url, control_number, venue_id, status, createdby, modifiedby, company_id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: eventsessions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.eventsessions (id, event_id, quest_id, title, description, start_date, end_date, start_time, end_time, createdby, modifiedby, company_id, status, location, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: facilities; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.facilities (id, name, venue_id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin;
\.


--
-- Data for Name: guests; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.guests (id, name, title, role, bio, photo_url, venue_id, createdby, modifiedby, company_id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: media_attendance_days; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.media_attendance_days (id, media_registration_id, day, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: media_registrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.media_registrations (id, usereventregistration_id, media_name, website_url, press_id_number, dietary_accessibility, terms_acceptance, portfolio_url, media_type, news_segment, interview_request, live_stream, social_media, assignment_letter, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.migrations (id, migration, batch) FROM stdin;
1	2014_10_12_000000_create_users_table	1
2	2014_10_12_100000_create_password_reset_tokens_table	1
3	2014_10_12_200000_add_two_factor_columns_to_users_table	1
4	2019_08_19_000000_create_failed_jobs_table	1
5	2019_12_14_000001_create_personal_access_tokens_table	1
6	2023_09_02_160625_create_roles_table	1
7	2023_09_02_160720_create_user_roles_table	1
8	2024_03_07_084653_create_sessions_table	1
9	2024_03_07_110802_create_permissions_table	1
10	2024_03_07_110813_create_permission_roles_table	1
11	2024_08_08_104657_create_notifications_table	1
12	2025_03_30_205508_create_venues_table	1
13	2025_03_31_204857_create_events_table	1
14	2025_03_31_205356_create_guests_table	1
15	2025_03_31_205440_create_eventsessions_table	1
16	2025_04_01_112818_create_facilities_table	1
17	2025_04_01_155030_create_eventagenders_table	1
18	2025_04_07_220019_add_remember_token_to_users_table	1
19	2025_04_10_185232_create_usereventregistrations_table	1
20	2025_04_12_200152_create_organizations_table	1
21	2025_06_27_055109_create_sessionparticipants_table	1
22	2025_07_04_190038_create_userparticipants_table	1
23	2026_01_23_085224_create_sectors_table	1
24	2026_01_28_041841_create_packages_table	1
25	2026_01_29_205829_create_agendas_table	1
26	2026_01_29_205829_create_side_events_table	1
27	2026_01_30_000206_create_tournaments_table	1
28	2026_01_30_075105_create_agenda_items_table	1
29	2026_01_31_180845_create_speakers_table	1
30	2026_02_01_094745_create_user_registration_tournament_table	1
31	2026_02_01_140323_create_companies_table	1
32	2026_02_01_140548_create_booths_table	1
33	2026_02_01_140800_create_booth_bookings_table	1
34	2026_02_01_141451_create_booking_items_table	1
35	2026_02_01_152002_create_media_registrations_table	1
36	2026_02_01_152005_create_media_attendance_days_table	1
37	2026_02_02_063302_create_speaker_agendas_table	1
38	2026_02_02_063308_create_speaker_side_events_table	1
39	2026_02_03_151411_create_registration_meeting_types_table	1
40	2026_02_03_151449_create_registration_target_entities_table	1
41	2026_02_07_083256_create_user_side_events_table	1
\.


--
-- Data for Name: notifications; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.notifications (id, title, content, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: organizations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.organizations (id, name, business_model, usereventregistration_id, createdby, modifiedby, status, created_at, updated_at) FROM stdin;
1	ZRA	B2G	\N	3	\N	1	2026-02-08 08:42:41	2026-02-08 08:42:41
2	ZIPA	B2G	\N	3	\N	1	2026-02-08 08:42:54	2026-02-08 08:42:54
3	ZIC	B2G	\N	3	\N	1	2026-02-08 08:43:05	2026-02-08 08:43:05
4	AZAM	B2B	\N	3	\N	1	2026-02-08 08:43:22	2026-02-08 08:43:22
\.


--
-- Data for Name: packages; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.packages (id, title, features, price, created_at, updated_at) FROM stdin;
1	PLATINUM	["Logo integrated into summit branding","Premium Exhibition space","10 VIP delegates passes","Opening key note speaking slot","Access to the high-level opening ceremony and sector-side events","Access to the Gala Dinner","Access to Site Visits  and networking","VIP seating and protocol recognition","Branding all media and press release"]	50000.00	2026-02-08 06:16:54	2026-02-10 05:30:01
2	GOLD	["Logo integrated into summit branding","Access to  Exhibition booth","5 VIP delegates passes","Panel speaking opportunity","Access to the high-level opening ceremony and sector-side events","Access to the Gala Dinner","Access to Site Visits and networking","Branding all media and press release"]	30000.00	2026-02-08 06:16:54	2026-02-10 05:31:37
3	SILVER	["Logo integrated into summit branding","Access to  Exhibition booth","3 VIP delegates passes","Access to the high-level opening ceremony and sector-side events","Access to the Gala Dinner","Access to Site Visits and networking","Branding all media and press release"]	20000.00	2026-02-08 06:16:54	2026-02-10 05:32:44
\.


--
-- Data for Name: permission_roles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.permission_roles (id, permission_id, role_id) FROM stdin;
1	1	1
2	2	1
3	3	1
4	4	1
5	5	1
6	6	1
\.


--
-- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.permissions (id, permission_name, created_at, updated_at) FROM stdin;
1	Admin access	2026-02-08 06:16:53	2026-02-08 06:16:53
2	adding new user	2026-02-08 06:16:53	2026-02-08 06:16:53
3	User management	2026-02-08 06:16:53	2026-02-08 06:16:53
4	disabling user	2026-02-08 06:16:53	2026-02-08 06:16:53
5	managing roles	2026-02-08 06:16:53	2026-02-08 06:16:53
6	adding roles to user	2026-02-08 06:16:53	2026-02-08 06:16:53
7	auditing system and activities	2026-02-08 06:16:53	2026-02-08 06:16:53
8	adding contract	2026-02-08 06:16:53	2026-02-08 06:16:53
9	view contract	2026-02-08 06:16:53	2026-02-08 06:16:53
10	adding consultant	2026-02-08 06:16:53	2026-02-08 06:16:53
11	viewing consultant	2026-02-08 06:16:53	2026-02-08 06:16:53
12	viewing report	2026-02-08 06:16:53	2026-02-08 06:16:53
13	approve contract	2026-02-08 06:16:53	2026-02-08 06:16:53
14	extend contract	2026-02-08 06:16:53	2026-02-08 06:16:53
15	terminate contract	2026-02-08 06:16:53	2026-02-08 06:16:53
16	viewing contract	2026-02-08 06:16:53	2026-02-08 06:16:53
17	resend contract	2026-02-08 06:16:53	2026-02-08 06:16:53
\.


--
-- Data for Name: registration_meeting_types; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.registration_meeting_types (id, usereventregistration_id, meeting_type, created_at, updated_at) FROM stdin;
1	1	B2G	2026-02-10 05:11:31	2026-02-10 05:11:31
\.


--
-- Data for Name: registration_target_entities; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.registration_target_entities (id, usereventregistration_id, entity_name, entity_type, created_at, updated_at) FROM stdin;
1	1	1	govt	2026-02-10 05:11:31	2026-02-10 05:11:31
\.


--
-- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.roles (id, role_name, created_at, updated_at) FROM stdin;
1	admin	2026-02-08 06:16:53	2026-02-08 06:16:53
\.


--
-- Data for Name: sectors; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sectors (id, name, status, created_at, updated_at) FROM stdin;
1	Tourisim	t	2026-02-08 08:41:03	2026-02-08 08:41:03
2	Manufucture	t	2026-02-08 08:41:17	2026-02-08 08:41:17
4	Transport	t	2026-02-08 08:42:07	2026-02-08 08:42:07
5	Real Estate	t	2026-02-08 08:42:23	2026-02-08 08:42:23
3	Renewable Energy	t	2026-02-08 08:42:00	2026-02-08 08:46:07
\.


--
-- Data for Name: sessionparticipants; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sessionparticipants (id, eventsession_id, participant, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: sessions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sessions (id, user_id, ip_address, user_agent, payload, last_activity) FROM stdin;
lD7n2lQJCKyQlSHJhfipNJ9RveatGDlOJ0mL8Clq	3	127.0.0.1	Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36	YTo1OntzOjY6Il90b2tlbiI7czo0MDoiaFBPaW05cFNBS0Z0aDJEU0NnS0g0OVlFeHQwM3VDMEpPcVlpeW1FYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hcGkvc2lkZWV2ZW50cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM7czoyMToicGFzc3dvcmRfaGFzaF9zYW5jdHVtIjtzOjYwOiIkMnkkMTIkL0pma294TmNNNGcxZE5kQk5haW5QdUNySDhxb1JHUnllL3pqZEVoclRlNHBYQ3Nhei40bi4iO30=	1770880978
\.


--
-- Data for Name: side_events; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.side_events (id, event_date, name, theme, created_by, created_at, updated_at) FROM stdin;
1	2026-06-10	Tourism	Test haajjaja jakajka kajkaj kjakjakj ajkjakja	3	2026-02-08 06:56:03	2026-02-08 06:56:03
2	2026-06-10	Renewable Energy	Test haajjaja jakajka kajkaj kjakjakj ajkjakja dsdsd	3	2026-02-08 06:56:03	2026-02-08 06:56:03
3	2026-06-10	ICT	Test haajjaja jakajka kajkaj kjakjakj ajkjakja dsdsd	3	2026-02-08 06:56:03	2026-02-08 06:56:03
4	2026-06-11	Agribusiness	Test haajjaja jakajka kajkaj kjakjakj ajkjakja dsdjjjh	3	2026-02-08 06:58:34	2026-02-08 06:58:34
5	2026-06-11	Blue Economy	Test haajjaja jakajka kajkaj kjakjakj ajkjakja sds fff	3	2026-02-08 06:58:34	2026-02-08 06:58:34
\.


--
-- Data for Name: speaker_agendas; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.speaker_agendas (id, speaker_id, agenda_id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: speaker_side_events; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.speaker_side_events (id, speaker_id, side_event_id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: speakers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.speakers (id, usereventregistration_id, name, role, cv_path, have_you_spoken, condition, linkedin_url, website_url, request_description, previous_speaking_experience, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: tournaments; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tournaments (id, title, description, amount, image_url, type, created_by, created_at, updated_at) FROM stdin;
1	Gala Dinner	The tournament is designed to strengthen relationships formed throughout the conference in a relaxed, informal setting. By moving interactions from the boardroom to the fairways, it allows investors and partners to deepen their connections and engage in open dialogue beyond the rigidity of formal meetings. This is an essential opportunity to solidify your network and cement the week's discussions before your departure.	5000.00	uploads/tournaments/1770532377_69882e19954e1.jpeg	vip	3	2026-02-08 06:32:57	2026-02-08 06:32:57
2	Gala Dinner	The tournament is designed to strengthen relationships formed throughout the conference in a relaxed, informal setting. By moving interactions from the boardroom to the fairways, it allows investors and partners to deepen their connections and engage in open dialogue beyond the rigidity of formal meetings. This is an essential opportunity to solidify your network and cement the week's discussions before your departure.	500.00	uploads/tournaments/1770532412_69882e3cac58e.jpeg	delegate	3	2026-02-08 06:33:32	2026-02-08 06:33:32
\.


--
-- Data for Name: user_registration_tournament; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.user_registration_tournament (id, usereventregistration_id, tournament_id, amount_paid, payment_control_number, payment_status, created_at, updated_at) FROM stdin;
1	2	2	\N	\N	0	2026-02-10 05:12:59	2026-02-10 05:12:59
\.


--
-- Data for Name: user_roles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.user_roles (id, user_id, role_id) FROM stdin;
1	1	1
2	2	1
\.


--
-- Data for Name: user_side_events; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.user_side_events (id, usereventregistration_id, side_event_id, created_at, updated_at) FROM stdin;
1	1	3	2026-02-10 05:11:31	2026-02-10 05:11:31
2	1	4	2026-02-10 05:11:31	2026-02-10 05:11:31
3	2	1	2026-02-10 05:12:59	2026-02-10 05:12:59
\.


--
-- Data for Name: usereventregistrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.usereventregistrations (id, fullname, salutation, email, organization, nature_of_business, jobtitle, package_category, package_price, extra_commitment, sector_specify, organization_id, sector_id, networkcheck, sideeventcheck, galadinercheck, phone, "position", country, home_country, number_of_participants, preferred_date, meeting_purpose, participant_type, passport_photo, passport_id, controlnumber, rejection_reason, badge_url, createdby, modifiedby, approvestatus, status, created_at, updated_at) FROM stdin;
1	Khamis Said Mohd	Mr	khasamoh.12@gmail.com	ZIPA	\N	ICT	\N	\N	\N	Please Specify	\N	5	1	1	\N	0773245757	\N	Åland Islands	American Samoa	\N	2026-06-12	test	delegate	uploads/documents/1770700291_698abe03b3c1f.png	uploads/documents/1770700291_698abe03b3c83_bio.png	CN-1770700485-5645	\N	\N	\N	\N	2	1	2026-02-10 05:11:31	2026-02-10 05:14:45
2	Ali Said Mohd	Mr	khasamoh.12@gmail.com	ZIPA	\N	ICT	\N	\N	\N	Please Specify	\N	1	0	1	\N	0773245757	\N	Åland Islands	American Samoa	\N	2026-06-12	test	delegate	uploads/documents/1770700379_698abe5b096c2.png	uploads/documents/1770700379_698abe5b09738_bio.png	CN-1770700644-5455	\N	\N	\N	\N	2	1	2026-02-10 05:12:59	2026-02-10 05:17:24
\.


--
-- Data for Name: userparticipants; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.userparticipants (id, registration_id, first_name, last_name, email, phone, photo_path, qr_code_path, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: venues; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.venues (id, name, location, capacity, description, photo_url, createdby, modifiedby, status, company_id, created_at, updated_at) FROM stdin;
\.



--
-- Name: agenda_items agenda_items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agenda_items
    ADD CONSTRAINT agenda_items_pkey PRIMARY KEY (id);


--
-- Name: agendas agendas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.agendas
    ADD CONSTRAINT agendas_pkey PRIMARY KEY (id);


--
-- Name: booking_items booking_items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_items
    ADD CONSTRAINT booking_items_pkey PRIMARY KEY (id);


--
-- Name: booth_bookings booth_bookings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booth_bookings
    ADD CONSTRAINT booth_bookings_pkey PRIMARY KEY (id);


--
-- Name: booths booths_booth_number_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booths
    ADD CONSTRAINT booths_booth_number_unique UNIQUE (booth_number);


--
-- Name: booths booths_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booths
    ADD CONSTRAINT booths_pkey PRIMARY KEY (id);


--
-- Name: companies companies_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.companies
    ADD CONSTRAINT companies_pkey PRIMARY KEY (id);


--
-- Name: eventagenders eventagenders_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eventagenders
    ADD CONSTRAINT eventagenders_pkey PRIMARY KEY (id);


--
-- Name: events events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.events
    ADD CONSTRAINT events_pkey PRIMARY KEY (id);


--
-- Name: eventsessions eventsessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.eventsessions
    ADD CONSTRAINT eventsessions_pkey PRIMARY KEY (id);


--
-- Name: facilities facilities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.facilities
    ADD CONSTRAINT facilities_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);


--
-- Name: guests guests_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.guests
    ADD CONSTRAINT guests_pkey PRIMARY KEY (id);


--
-- Name: media_attendance_days media_attendance_days_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.media_attendance_days
    ADD CONSTRAINT media_attendance_days_pkey PRIMARY KEY (id);


--
-- Name: media_registrations media_registrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.media_registrations
    ADD CONSTRAINT media_registrations_pkey PRIMARY KEY (id);


--
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_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: organizations organizations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.organizations
    ADD CONSTRAINT organizations_pkey PRIMARY KEY (id);


--
-- Name: packages packages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.packages
    ADD CONSTRAINT packages_pkey PRIMARY KEY (id);


--
-- Name: permission_roles permission_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.permission_roles
    ADD CONSTRAINT permission_roles_pkey PRIMARY KEY (id);


--
-- Name: permissions permissions_permission_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_permission_name_unique UNIQUE (permission_name);


--
-- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);


--
-- Name: registration_meeting_types registration_meeting_types_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.registration_meeting_types
    ADD CONSTRAINT registration_meeting_types_pkey PRIMARY KEY (id);


--
-- Name: registration_target_entities registration_target_entities_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.registration_target_entities
    ADD CONSTRAINT registration_target_entities_pkey PRIMARY KEY (id);


--
-- Name: roles roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);


--
-- Name: roles roles_role_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_role_name_unique UNIQUE (role_name);


--
-- Name: sectors sectors_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sectors
    ADD CONSTRAINT sectors_name_unique UNIQUE (name);


--
-- Name: sectors sectors_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sectors
    ADD CONSTRAINT sectors_pkey PRIMARY KEY (id);


--
-- Name: sessionparticipants sessionparticipants_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sessionparticipants
    ADD CONSTRAINT sessionparticipants_pkey PRIMARY KEY (id);


--
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);


--
-- Name: side_events side_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.side_events
    ADD CONSTRAINT side_events_pkey PRIMARY KEY (id);


--
-- Name: speaker_agendas speaker_agendas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.speaker_agendas
    ADD CONSTRAINT speaker_agendas_pkey PRIMARY KEY (id);


--
-- Name: speaker_side_events speaker_side_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.speaker_side_events
    ADD CONSTRAINT speaker_side_events_pkey PRIMARY KEY (id);


--
-- Name: speakers speakers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.speakers
    ADD CONSTRAINT speakers_pkey PRIMARY KEY (id);


--
-- Name: tournaments tournaments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tournaments
    ADD CONSTRAINT tournaments_pkey PRIMARY KEY (id);


--
-- Name: user_registration_tournament user_registration_tournament_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_registration_tournament
    ADD CONSTRAINT user_registration_tournament_pkey PRIMARY KEY (id);


--
-- Name: user_roles user_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_pkey PRIMARY KEY (id);


--
-- Name: user_side_events user_side_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_side_events
    ADD CONSTRAINT user_side_events_pkey PRIMARY KEY (id);


--
-- Name: usereventregistrations usereventregistrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.usereventregistrations
    ADD CONSTRAINT usereventregistrations_pkey PRIMARY KEY (id);


--
-- Name: userparticipants userparticipants_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.userparticipants
    ADD CONSTRAINT userparticipants_pkey PRIMARY KEY (id);


--
-- Name: venues venues_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.venues
    ADD CONSTRAINT venues_pkey PRIMARY KEY (id);


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

CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity);


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

CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id);


--
-- Name: permission_roles permission_roles_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.permission_roles
    ADD CONSTRAINT permission_roles_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;


--
-- Name: permission_roles permission_roles_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.permission_roles
    ADD CONSTRAINT permission_roles_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- Name: user_roles user_roles_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- Name: user_roles user_roles_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;