--
--


SELECT pg_catalog.set_config('search_path', '', false);

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

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


ALTER SCHEMA public OWNER TO postgres;

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

COMMENT ON SCHEMA public IS '';


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

CREATE TYPE public."deliveryOption" AS ENUM (
    'flat',
    'weight'
);


ALTER TYPE public."deliveryOption" OWNER TO postgres;

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

CREATE TYPE public."dropDownType" AS ENUM (
    'allergen',
    'production',
    'diet',
    'shelf_life',
    'storage',
    'supplier_value',
    'ship_time',
    'product_origin',
    'here_about_us',
    'type_of_store',
    'nutrition',
    'shipping_time',
    'brand_minimum',
    'volume_units',
    'weight_units'
);


ALTER TYPE public."dropDownType" OWNER TO postgres;

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

CREATE TYPE public."favouritesType" AS ENUM (
    'product',
    'brand'
);


ALTER TYPE public."favouritesType" OWNER TO postgres;

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

CREATE TYPE public."messageType" AS ENUM (
    'msg',
    'file',
    'image',
    'video'
);


ALTER TYPE public."messageType" OWNER TO postgres;

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

CREATE TYPE public."orderStatus" AS ENUM (
    'fulfilled',
    'returned',
    'pending',
    'cancelled'
);


ALTER TYPE public."orderStatus" OWNER TO postgres;

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

CREATE TYPE public."orderType" AS ENUM (
    'product',
    'sample'
);


ALTER TYPE public."orderType" OWNER TO postgres;

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

CREATE TYPE public."organizationVisibility" AS ENUM (
    'public',
    'hidden'
);


ALTER TYPE public."organizationVisibility" OWNER TO postgres;

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

CREATE TYPE public."paymentStatus" AS ENUM (
    'paid',
    'refunded',
    'failed',
    'free'
);


ALTER TYPE public."paymentStatus" OWNER TO postgres;

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

CREATE TYPE public."userType" AS ENUM (
    'buyer',
    'seller',
    'buyer_team',
    'seller_team'
);


ALTER TYPE public."userType" OWNER TO postgres;



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

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


ALTER TABLE public._prisma_migrations OWNER TO postgres;

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

CREATE TABLE public.country (
    id bigint NOT NULL,
    short_name character varying(128) NOT NULL,
    name character varying(256) NOT NULL,
    phone_code character varying(128) NOT NULL,
    is_active boolean DEFAULT true,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.country OWNER TO postgres;

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

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


ALTER SEQUENCE public.country_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.country_id_seq OWNED BY public.country.id;


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

CREATE TABLE public.tbl_admin (
    id bigint NOT NULL,
    first_name character varying(256),
    last_name character varying(256),
    email character varying(256),
    password character varying(256),
    token text,
    forgot_token text,
    forgot_token_expiry timestamp(0) without time zone,
    is_online boolean DEFAULT false,
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    logined_at timestamp(3) without time zone,
    forgoted_at timestamp(3) without time zone,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_admin OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_admin_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_admin_id_seq OWNED BY public.tbl_admin.id;


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

CREATE TABLE public.tbl_billing_history (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    payment_id bigint NOT NULL,
    order_ids text,
    total_amount numeric(13,2),
    invoice_no character varying(64),
    invoice_file_name character varying(256),
    currency character varying(64),
    status character varying(128),
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_billing_history OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_billing_history_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_billing_history_id_seq OWNED BY public.tbl_billing_history.id;


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

CREATE TABLE public.tbl_blog (
    id integer NOT NULL,
    category_id integer NOT NULL,
    title text NOT NULL,
    image text,
    content text,
    updated_at timestamp(3) without time zone,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    description text
);


ALTER TABLE public.tbl_blog OWNER TO postgres;

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

CREATE TABLE public.tbl_blog_category (
    id integer NOT NULL,
    name text NOT NULL,
    updated_at timestamp(3) without time zone,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false
);


ALTER TABLE public.tbl_blog_category OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_blog_category_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_blog_category_id_seq OWNED BY public.tbl_blog_category.id;


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

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


ALTER SEQUENCE public.tbl_blog_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_blog_id_seq OWNED BY public.tbl_blog.id;


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

CREATE TABLE public.tbl_cart (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    brand_id bigint NOT NULL,
    product_id bigint NOT NULL,
    qty integer DEFAULT 1,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_cart OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_cart_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_cart_id_seq OWNED BY public.tbl_cart.id;


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

CREATE TABLE public.tbl_category (
    id bigint NOT NULL,
    parent_id bigint,
    category_name character varying(256),
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_category OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_category_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_category_id_seq OWNED BY public.tbl_category.id;


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

CREATE TABLE public.tbl_chat (
    id bigint NOT NULL,
    chat_room_id bigint NOT NULL,
    sender_id bigint NOT NULL,
    receiver_id bigint NOT NULL,
    message text,
    message_type public."messageType",
    is_read boolean DEFAULT false,
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone,
    receiver_type public."userType",
    sender_type public."userType"
);


ALTER TABLE public.tbl_chat OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_chat_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_chat_id_seq OWNED BY public.tbl_chat.id;


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

CREATE TABLE public.tbl_chat_room (
    id bigint NOT NULL,
    sender_id bigint NOT NULL,
    receiver_id bigint NOT NULL,
    last_message text,
    last_message_at timestamp(3) without time zone,
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone,
    receiver_type public."userType",
    sender_type public."userType"
);


ALTER TABLE public.tbl_chat_room OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_chat_room_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_chat_room_id_seq OWNED BY public.tbl_chat_room.id;


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

CREATE TABLE public.tbl_cms_page (
    id integer NOT NULL,
    title text NOT NULL,
    slug text NOT NULL,
    content text,
    created_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    updated_at timestamp(3) without time zone,
    short_description text
);


ALTER TABLE public.tbl_cms_page OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_cms_page_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_cms_page_id_seq OWNED BY public.tbl_cms_page.id;


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

CREATE TABLE public.tbl_currency (
    id bigint NOT NULL,
    currency_logo character varying(128),
    currency_short_name character varying(128),
    currency_full_name character varying(256),
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_currency OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_currency_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_currency_id_seq OWNED BY public.tbl_currency.id;


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

CREATE TABLE public.tbl_customer_order (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    brand_id bigint NOT NULL,
    total numeric(13,2),
    internal_note text,
    is_user_blocked boolean DEFAULT false,
    last_order_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_customer_order OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_customer_order_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_customer_order_id_seq OWNED BY public.tbl_customer_order.id;


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

CREATE TABLE public.tbl_dropdown_list (
    id bigint NOT NULL,
    name character varying(256),
    icon_image character varying(256),
    type public."dropDownType",
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_dropdown_list OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_dropdown_list_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_dropdown_list_id_seq OWNED BY public.tbl_dropdown_list.id;


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

CREATE TABLE public.tbl_favourites (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    product_id bigint,
    type public."favouritesType",
    is_active boolean DEFAULT true,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone,
    brand_id bigint
);


ALTER TABLE public.tbl_favourites OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_favourites_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_favourites_id_seq OWNED BY public.tbl_favourites.id;


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

CREATE TABLE public.tbl_fulfilment (
    id bigint NOT NULL,
    delivery_option public."deliveryOption",
    option_name character varying(256),
    per_order_fee numeric(13,2),
    per_order_currency character varying(64),
    fee_per_item numeric(13,2),
    fee_per_item_currency character varying(64),
    country_ids character varying(256),
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone,
    user_id bigint NOT NULL,
    is_default boolean DEFAULT false
);


ALTER TABLE public.tbl_fulfilment OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_fulfilment_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_fulfilment_id_seq OWNED BY public.tbl_fulfilment.id;


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

CREATE TABLE public.tbl_fulfilment_weight (
    id bigint NOT NULL,
    fulfilment_id bigint NOT NULL,
    starting_weight numeric(13,2),
    ending_weight numeric(13,2),
    cost numeric(13,2),
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_fulfilment_weight OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_fulfilment_weight_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_fulfilment_weight_id_seq OWNED BY public.tbl_fulfilment_weight.id;


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

CREATE TABLE public.tbl_order (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    brand_id bigint NOT NULL,
    payment_id bigint,
    order_no character varying(8),
    order_type public."orderType",
    payment_status public."paymentStatus",
    order_status public."orderStatus",
    refund numeric(13,2),
    discount numeric(13,2),
    sub_total numeric(13,2),
    vat_charges numeric(13,2),
    total numeric(13,2),
    address character varying(256),
    billing_user_name character varying(256),
    customer_note character varying(256),
    internal_note character varying(256),
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    ordered_at timestamp(3) without time zone,
    refunded_at timestamp(3) without time zone,
    fulfilled_at timestamp(3) without time zone,
    pending_at timestamp(3) without time zone,
    returned_at timestamp(3) without time zone,
    cancelled_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone,
    address_id bigint
);


ALTER TABLE public.tbl_order OWNER TO postgres;

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

CREATE TABLE public.tbl_order_carrier (
    id bigint NOT NULL,
    order_id bigint NOT NULL,
    tracking_number character varying(24),
    carrier character varying(128),
    is_active boolean DEFAULT true,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_order_carrier OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_order_carrier_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_order_carrier_id_seq OWNED BY public.tbl_order_carrier.id;


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

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


ALTER SEQUENCE public.tbl_order_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_order_id_seq OWNED BY public.tbl_order.id;


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

CREATE TABLE public.tbl_order_item (
    id bigint NOT NULL,
    order_id bigint NOT NULL,
    user_id bigint NOT NULL,
    brand_id bigint NOT NULL,
    product_id bigint NOT NULL,
    each_product_price numeric(13,2),
    total_product_price numeric(13,2),
    qty integer DEFAULT 1,
    reason_of_return character varying(256),
    return_qty integer,
    is_refund_requested boolean DEFAULT false,
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_order_item OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_order_item_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_order_item_id_seq OWNED BY public.tbl_order_item.id;


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

CREATE TABLE public.tbl_payment_history (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    customer_id character varying(128),
    payment_intent_id character varying(256),
    payment_method character varying(256),
    paid_amount numeric(13,2),
    status character varying(128),
    currency character varying(64),
    payment_intent_log text,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_payment_history OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_payment_history_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_payment_history_id_seq OWNED BY public.tbl_payment_history.id;


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

CREATE TABLE public.tbl_permission (
    id bigint NOT NULL,
    role_name character varying(256),
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_permission OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_permission_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_permission_id_seq OWNED BY public.tbl_permission.id;


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

CREATE TABLE public.tbl_product (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    product_name character varying(256),
    weight_type character varying(256),
    weight numeric(13,2),
    width_inch numeric(13,2),
    height_inch numeric(13,2),
    depth_inch numeric(13,2),
    description text,
    ingredients text,
    diet_ids character varying(256),
    nutrition_ids character varying(256),
    shelf_life_id bigint,
    storage_id bigint,
    production_ids character varying(256),
    allergens_ids character varying(256),
    values_ids character varying(256),
    sku_no character varying(256),
    product_origin character varying(256),
    product_price numeric(13,2),
    is_on_sale boolean DEFAULT false,
    retail_resale_price numeric(13,2),
    is_unlimited_stock boolean DEFAULT false,
    is_samples boolean DEFAULT false,
    sample_price numeric(13,2),
    is_sample_unlimited_stock boolean DEFAULT false,
    fulfilment_id bigint,
    organization_visibility public."organizationVisibility",
    category_ids character varying(256),
    is_publish boolean DEFAULT false,
    is_featured_product boolean DEFAULT false,
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    publish_at timestamp(3) without time zone,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone,
    case_size_quantity character varying(256),
    depth numeric(13,2),
    depth_type character varying(256),
    height numeric(13,2),
    height_type character varying(256),
    shipping_time_id bigint,
    width numeric(13,2),
    width_type character varying(256),
    product_volume numeric(13,2),
    product_volume_type character varying(256),
    converted_weight numeric(13,2),
    product_stock integer DEFAULT 0,
    is_allow_custom_quantity_order boolean DEFAULT false,
    sample_stock integer DEFAULT 0,
    fluid_ounces_product_volume numeric(13,2)
);


ALTER TABLE public.tbl_product OWNER TO postgres;

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

CREATE TABLE public.tbl_product_category (
    id bigint NOT NULL,
    product_id bigint NOT NULL,
    category_id bigint,
    sub_category_id bigint,
    sub_child_category_id bigint,
    is_active boolean DEFAULT true,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_product_category OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_product_category_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_product_category_id_seq OWNED BY public.tbl_product_category.id;


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

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


ALTER SEQUENCE public.tbl_product_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_product_id_seq OWNED BY public.tbl_product.id;


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

CREATE TABLE public.tbl_product_images (
    id bigint NOT NULL,
    product_id bigint NOT NULL,
    image character varying(256),
    is_thumbnail boolean DEFAULT false,
    is_active boolean DEFAULT true,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone,
    is_image_link boolean DEFAULT false
);


ALTER TABLE public.tbl_product_images OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_product_images_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_product_images_id_seq OWNED BY public.tbl_product_images.id;


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

CREATE TABLE public.tbl_product_volume (
    id bigint NOT NULL,
    product_id bigint NOT NULL,
    value numeric(13,2),
    unit_type character varying(8),
    is_active boolean DEFAULT true,
    inserted_at timestamp(6) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(6) without time zone
);


ALTER TABLE public.tbl_product_volume OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_product_volume_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_product_volume_id_seq OWNED BY public.tbl_product_volume.id;


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

CREATE TABLE public.tbl_product_weight (
    id bigint NOT NULL,
    product_id bigint NOT NULL,
    value numeric(13,2),
    unit_type character varying(8),
    is_active boolean DEFAULT true,
    inserted_at timestamp(6) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(6) without time zone
);


ALTER TABLE public.tbl_product_weight OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_product_weight_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_product_weight_id_seq OWNED BY public.tbl_product_weight.id;


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

CREATE TABLE public.tbl_user (
    id bigint NOT NULL,
    reseller_id bigint DEFAULT 0,
    parent_id bigint DEFAULT 0,
    first_name character varying(216),
    last_name character varying(216),
    email character varying(256) NOT NULL,
    password character varying(256),
    country_code character varying(8),
    mobile_number character varying(18),
    profile_image character varying(256),
    type public."userType",
    business_name character varying(256),
    business_email character varying(256),
    type_of_store_id bigint,
    address character varying(256),
    city character varying(128),
    country character varying(128),
    country_id bigint,
    zip_code character varying(64),
    wholesale_accounts_products bigint DEFAULT 0,
    wholesale_products bigint DEFAULT 0,
    website character varying(256),
    minimum_order_amount_currency character varying(128),
    minimum_order_amount numeric(13,2),
    category_in_stock character varying(256),
    note text,
    here_about_us_id bigint,
    otp character varying(6),
    otp_expiry timestamp(0) without time zone,
    forgoted_at timestamp(3) without time zone,
    is_offering_subscription boolean DEFAULT false,
    is_individual_updates_for_order boolean DEFAULT false,
    is_daily_summary_reminder_for_order boolean DEFAULT false,
    is_email_reminder_for_messages boolean DEFAULT false,
    is_email_reminder_for_payment boolean DEFAULT false,
    is_email_reminder_for_new_features boolean DEFAULT false,
    is_email_reminder_for_trending_products boolean DEFAULT false,
    is_account_reviewed_by_admin boolean DEFAULT false,
    is_verify boolean DEFAULT false,
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    verified_at timestamp(3) without time zone,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone,
    is_online boolean DEFAULT false,
    logined_at timestamp(3) without time zone,
    about text,
    annual_sales_id bigint,
    business_profile_banner_image character varying(256),
    business_profile_image character varying(256),
    company_values_ids character varying(256),
    founding_year character varying(128),
    instagram_account character varying(256),
    lead_time_id bigint,
    linkedin_account character varying(256),
    located_in_id bigint,
    number_of_locations bigint DEFAULT 0,
    profile_banner_image character varying(256),
    shipping_fee numeric(13,2),
    shipping_fee_currency character varying(128),
    year_in_business character varying(128),
    permission_id bigint,
    role character varying(256),
    is_offering_samples boolean DEFAULT false,
    free_shipping_order_amount numeric(13,2) DEFAULT 0,
    is_free_shipping boolean DEFAULT false,
    is_max_samples_requested boolean DEFAULT false,
    samples_max_quantity_order_amount integer DEFAULT 1,
    flat_rate_shipping_fee_for_samples_order numeric(13,2) DEFAULT 0,
    stripe_customer_id character varying(256)
);


ALTER TABLE public.tbl_user OWNER TO postgres;

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

CREATE TABLE public.tbl_user_address (
    id bigint NOT NULL,
    user_id bigint,
    first_name character varying(216),
    last_name character varying(216),
    address character varying(256),
    city character varying(128),
    country character varying(128),
    country_id bigint,
    zip_code character varying(64),
    country_code character varying(8),
    mobile_number character varying(18),
    vat_number character varying(128),
    is_dont_have_vat_number boolean DEFAULT false,
    is_default boolean DEFAULT false,
    is_active boolean DEFAULT true,
    is_delete boolean DEFAULT false,
    deleted_at timestamp(3) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_user_address OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_user_address_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_user_address_id_seq OWNED BY public.tbl_user_address.id;


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

CREATE TABLE public.tbl_user_device (
    id bigint NOT NULL,
    user_id bigint,
    uuid character varying(256),
    token text,
    token_expiry timestamp(0) without time zone,
    inserted_at timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp(3) without time zone
);


ALTER TABLE public.tbl_user_device OWNER TO postgres;

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

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


ALTER SEQUENCE public.tbl_user_device_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_user_device_id_seq OWNED BY public.tbl_user_device.id;


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

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


ALTER SEQUENCE public.tbl_user_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.tbl_user_id_seq OWNED BY public.tbl_user.id;


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COPY public._prisma_migrations (id, checksum, finished_at, migration_name, logs, rolled_back_at, started_at, applied_steps_count) FROM stdin;
1ef251d5-8264-42cf-9cc4-c142daad709d	501902a2b774a6ba20e483456c5597ee1659f8eda6bc56b0a2741b53dda9394f	2024-11-12 12:29:35.121815+00	20241016045437_changes_on_product_stock_string_to_int	\N	\N	2024-11-12 12:29:34.462225+00	1
c9b696a1-2c02-4730-8add-8b00af940593	67535661bfc133354c683c0f6529334aac049ac8801ad85c1beea30d5b505554	2024-11-12 12:29:09.167682+00	20240906113117_user_drop_down_role_state_city_country	\N	\N	2024-11-12 12:29:08.477289+00	1
019c4ed2-f99e-49a9-be97-774836fb324b	ff7929f74300ff7668569c3a155a7ef5f9e03187e57d4f9b858806e95529d144	2024-11-12 12:29:20.297771+00	20240920061111_test_field_added_and_remove_is_offering_samples_field	\N	\N	2024-11-12 12:29:19.637751+00	1
940855cf-7d28-4f43-b79d-be7924198575	837068a2a1e1d8e947c6e21e89118bdb8fc2cb5c19997bb89129b0abb3f36190	2024-11-12 12:29:10.094796+00	20240906122333_user_device	\N	\N	2024-11-12 12:29:09.430897+00	1
11ba9439-2319-4c47-bc6d-93b63bd11ed6	ced6a8ace7918b75fff3f1feb720865b69a8f41db3105fc46c01cce14c5a0cd2	2024-11-12 12:29:11.018944+00	20240910063139_user_changes	\N	\N	2024-11-12 12:29:10.357956+00	1
0dd803c6-6cad-4951-9918-affffacd4e97	0edc6593d2e97117ab4c8a75813dfc5a9f13865bda2a661ad33647b495be04fe	2024-11-12 12:29:27.682336+00	20241009063409_password_field_optional	\N	\N	2024-11-12 12:29:27.023539+00	1
0d767c8c-3d75-43fb-b333-8a859f85e3e6	3d941ca8d5fbe3fcc7dff86123e3e161da8f643bcd8b644be66fc6e1e58b40af	2024-11-12 12:29:11.949597+00	20240911101105_changes_in_user_and_remove_state_and_city	\N	\N	2024-11-12 12:29:11.28192+00	1
47a8c330-c46b-446d-bd16-3bbe21521d62	2145bc991d1b43513371242615a66b9194e4da443dfc4cc3e351787b7b012dcb	2024-11-12 12:29:21.220178+00	20240920061303_setup_changes_as_it_is	\N	\N	2024-11-12 12:29:20.560312+00	1
04814376-d2e5-4349-8693-3c9b776335c2	f2c71274b7456f0f8bbb20c3238836caa5dce5a21b886742c31ed1bda8cc16d9	2024-11-12 12:29:12.877009+00	20240911113900_changes_in_dropdown_and_user_and_dropdown_type	\N	\N	2024-11-12 12:29:12.216789+00	1
47ed447c-f662-43df-a1d1-ecaac5aacc40	6922b0c48bfd4a051d3b087421f92882b2bfdc50f4868040dff192518a41f004	2024-11-12 12:29:13.807407+00	20240911123507_create_category	\N	\N	2024-11-12 12:29:13.139828+00	1
5ab73442-66dd-419b-92fd-53df771bcb29	4c962b3f7ccd8f6788f6fdc70374f4b80a080ef55b723305baaa013e1f122025	2024-11-12 12:29:14.732147+00	20240912054125_changes_country	\N	\N	2024-11-12 12:29:14.070201+00	1
7e6048a7-ce01-43c0-8cdf-a1a79ab18af5	ecc724cf7360c3653e3b5b4aba9a8e92d54b075521827c2b646d6915d133dec2	2024-11-12 12:29:22.142365+00	20241001085318_add_nutrition_dropdown_type	\N	\N	2024-11-12 12:29:21.483299+00	1
1584902d-55c5-440d-abfc-9458f24ca9a7	ea77b0aa176ca26ebbafd980390309774ca5a1b9cae7d4c907a52438546d5118	2024-11-12 12:29:15.659093+00	20240912055051_changes_permission_and_user	\N	\N	2024-11-12 12:29:14.99416+00	1
565011f1-5a89-40ea-9fea-3cec4e8a28be	e0c94b5a08fc22553ef76e14afc791ebf12c6ba3727db5352d1792fdd02f96fe	2024-11-12 12:29:16.584939+00	20240912060348_create_currency	\N	\N	2024-11-12 12:29:15.922594+00	1
b7d40d58-0ac6-4a99-a417-7d16c26f96d5	7a398e19d46c7bf3c0f49e6d1b964571d657692ea586ef12ec8ab6a27365e515	2024-11-12 12:29:32.342332+00	20241015043854_changes_on_product_table_client_changes	\N	\N	2024-11-12 12:29:31.68076+00	1
6b27f6a0-3f90-4a53-a3d7-4c65e706de80	26a5e199dc89800acae2616b80c1616b29f4f2b89735b917b221e344650df901	2024-11-12 12:29:17.508475+00	20240918083716_create_all_table_with_changes	\N	\N	2024-11-12 12:29:16.848152+00	1
b7636c6d-30a3-441b-b8d9-1e6501a4a838	ad6e58d1997b61197cf63ff802d868aa3d5e138bdc209a5c78f5a70c4930e7c6	2024-11-12 12:29:23.065527+00	20241001121116_add_user_id_in_fulfilment_table	\N	\N	2024-11-12 12:29:22.40556+00	1
47b548d5-cdee-47ee-a0d5-aea5d6d51a63	23ec47853d2d9893409de0bea14d5ae5a70c558aa82d9b49067098b45ba0122b	2024-11-12 12:29:18.443509+00	20240919085201_create_product_product_images_fulfilment_fulfilment_weight	\N	\N	2024-11-12 12:29:17.771991+00	1
f96a7542-3775-43a0-a63f-9e53d10a68a3	574d945eadea7f613b7031f92ac650ce1a79c61fc994ca466d8725b73bf1f973	2024-11-12 12:29:19.374706+00	20240920045713_in_user_admin_remove_and_admin_table_create	\N	\N	2024-11-12 12:29:18.706653+00	1
db384184-44ea-4134-abf4-ce2906db3f23	31e16986a77cd6ad0a7c1c86632e94cb2f167b5d77acbce229f40db0027083b8	2024-11-12 12:29:28.605298+00	20241009105651_user_and_fulfilment	\N	\N	2024-11-12 12:29:27.945407+00	1
e2684d79-1e4a-41b7-aac7-6963395cb677	df8c281da3c7ff1024befee6cb51d90656528d1bf11d816eb2b2c363479b885a	2024-11-12 12:29:23.988349+00	20241001124331_add_user_id_in_fulfilment_table	\N	\N	2024-11-12 12:29:23.328391+00	1
4dd2a5fb-38f3-48bd-89f7-1aa9865bdeaa	b9cdc873695c825bafbaa287973d0237b37c036bf5188ad104f607664e410ae7	2024-11-12 12:29:24.911729+00	20241001124725_user_id_add_in_fulfilement	\N	\N	2024-11-12 12:29:24.251353+00	1
261306b7-3fb2-4d7f-bea4-5e146fab3bd3	0f16f8657e97556b147a6ba41a9681e61d63979f920223f2130b6935d6e27ddb	2024-11-12 12:29:25.836797+00	20241007080636_add_dropdown_type_like_shipping_time_and_brand_minimum	\N	\N	2024-11-12 12:29:25.177953+00	1
ae74b7ae-d077-4b78-b1e7-f766ee0d7ef1	0599f42fb8fc5ee07ab5ca4d2b5302051cabb70a61431da5bb087ebc5c2c6e7a	2024-11-12 12:29:29.529173+00	20241010082206_flat_rate_shipping_fee_for_samples_order_on_user	\N	\N	2024-11-12 12:29:28.869542+00	1
5db9f22c-4bee-4f89-81f4-60af76955648	75f17f61cd80ba508edbe42c40011028094391662fdf4aad75830d3983136865	2024-11-12 12:29:26.760247+00	20241007090100_fk_set_in_dropdown_for_lead_time	\N	\N	2024-11-12 12:29:26.100462+00	1
06c12edc-d0d1-4b4d-9980-ecb2e32d4dca	6c9574a6655724377b82e97ef21c1d7c806ed262583a45fb9c939a8dd227e9b3	2024-11-12 12:29:30.491683+00	20241014052658_create_tbl_favourites	\N	\N	2024-11-12 12:29:29.792638+00	1
5c8c0b06-8795-4d4e-b149-08904ad6e77e	df74dfafeba5b6a7f05ec0ab3f9797ca7d4adcd36d5b5e703164a9f14ba534d7	2024-11-12 12:29:33.274643+00	20241015044620_add_product_volume_in_product_table	\N	\N	2024-11-12 12:29:32.605256+00	1
56077ef7-4c33-47d4-bafe-7337c72204c1	4b30ff6a768f2526d2c1170827e7c5254042e3d6999e769db27824d407c4248c	2024-11-12 12:29:31.417462+00	20241014061115_add_brand_id_in_favourites_table	\N	\N	2024-11-12 12:29:30.754852+00	1
97ae59e2-ff59-44a0-8ec6-eec22a21774e	c12f102410709db7d89c2752b470e17f01128d8df2e794d801c3a8cc8496e6ca	2024-11-12 12:29:36.973799+00	20241016100212_create_tbl_product_category_table_and_set_relation	\N	\N	2024-11-12 12:29:36.310951+00	1
182b439d-a833-4a1c-b1cc-43b17ff5ee7f	a77bc807bef155aee2533d78442d2126d468c5efeeba07905a4ed4732ad770eb	2024-11-12 12:29:34.198994+00	20241015060244_key_name_change_converted_weight_in_product	\N	\N	2024-11-12 12:29:33.538911+00	1
27b74fd1-04a9-4318-9b60-45ea03f545ee	078da8b692e9c86ec1e7e34a6451d37d356ef0c5d4fc080d0ff932e959b1c2cd	2024-11-12 12:29:36.047807+00	20241016070421_add_is_allow_custom_quantity_order_in_product	\N	\N	2024-11-12 12:29:35.384823+00	1
477bc331-8e67-49f4-b364-42cd94388571	62450db684019a9fd7c35f75d147ff0f706ec7d65a3b9ff80fd6463a960ff050	2024-11-12 12:29:38.833354+00	20241019074450_fulfilment_fk_set_in_product_table	\N	\N	2024-11-12 12:29:38.172356+00	1
f01d9f43-761f-4d07-a1ec-c1db8c811afe	91f64c7a08dff189579fcf94fbc29d1598c8925510a90a0256b019fef9e78dae	2024-11-12 12:29:37.909145+00	20241018051809_cart_table_add	\N	\N	2024-11-12 12:29:37.237023+00	1
2d85aa61-54bc-4379-9d31-f9da849b2a01	69536e92b00b9c32bd061cdd90e92939e08c49defce258fd5734d4e3e0bcb676	2024-11-12 12:29:39.771209+00	20241021060626_create_order_and_order_item_table	\N	\N	2024-11-12 12:29:39.096414+00	1
88c51f4d-bbc2-49c1-b720-b42c8e5d43c4	0711921ce1e3255cdff166476e6eb71e74001af9d40b0b051a02bd462461d371	2024-11-12 12:29:40.695641+00	20241022045849_index_set_in_order_table	\N	\N	2024-11-12 12:29:40.03441+00	1
8a7b8aed-6daa-4261-a8ff-bf7623ba2821	43d3c99a257e5bff33105e22f6a845f97f0d72f71c803b8f5f8acbddda2a5bda	2024-11-12 12:29:41.621471+00	20241022084408_create_tbl_order_carrier_and_remove_carrier_id_in_order_table	\N	\N	2024-11-12 12:29:40.958425+00	1
17f8e979-282f-49ee-818f-0f943f8c1c16	1f10be4d5bbe7dd47c19d421a2a36faf00a75cf3bf8287fa2ace88ce020a1327	2024-11-12 12:29:42.558813+00	20241023071122_add_tbl_user_address	\N	\N	2024-11-12 12:29:41.884748+00	1
13f371cd-502b-4021-9fce-da2d334c6f84	917e0378c60f8d9ad1295336a0ddd3130d08109e9eb85e9ca87acc1b700ce67e	2024-11-12 14:58:46.560113+00	20241112145845_add_weight_volume_units	\N	\N	2024-11-12 14:58:45.843133+00	1
daf14958-10eb-4df7-add3-5275ff0c9841	575188a3c1d52e0be57008d950b2b5a9d8d7f36f0c49b84a50bfef6c196fb324	2024-11-12 12:29:43.482995+00	20241023092635_set_fk_in_order_table_as_address_id	\N	\N	2024-11-12 12:29:42.821947+00	1
9760f958-0a87-4f3d-871f-298f026b3958	072d916359c43178a4165155b38d344e64f9faed03d3af2e76792b840b6101f9	2024-11-12 12:29:44.406056+00	20241023112122_sample_stock_change_into_int	\N	\N	2024-11-12 12:29:43.746003+00	1
31f99947-daa8-4065-8f96-c0d2a8c9ee11	ab8a5215f070ddbefcc59d1cf45d9d3b27df12d2e5b01306556d25381cb91542	2024-11-12 12:29:45.367171+00	20241024083706_add_tbl_customer_order	\N	\N	2024-11-12 12:29:44.66905+00	1
d48f5775-600f-4ba1-9915-c0e611e15d9f	48b6562ce97441b90d632927936424e12c1918bbebf0251f3bcedaff1fcf3811	2024-11-13 09:52:49.546857+00	20241113095247_changes_in_tbl_blog_category_is_active_and_is_delete_set	\N	\N	2024-11-13 09:52:48.698088+00	1
b300a2d1-2e35-4781-9c0f-992064721f90	56884a874bec53630820613ff5e30b0ad00500f92c4a4699c96e9b400a9c4a09	2024-11-12 12:29:46.301938+00	20241026043739_add_tbl_chat_room_and_tbl_chat	\N	\N	2024-11-12 12:29:45.630366+00	1
0f9adc63-8248-4696-b208-67be392f7471	d715f92ed0849bc9712a7ee4d9601fccfeb2dec39574699a1466125dbc238ff7	2024-11-12 12:29:47.224778+00	20241026065324_add_sender_type_and_reciver_type_in_chat_and_chat_room_table	\N	\N	2024-11-12 12:29:46.565364+00	1
53af9879-0ca8-4588-a551-b51e92b61fbe	cf278e4170801d8987b4e57a11e22e511289254b537047e7ba1ce2b60b57f467	2024-11-12 12:29:48.148319+00	20241028102234_add_stripe_customer_id_in_user_table	\N	\N	2024-11-12 12:29:47.487868+00	1
dbae198e-bed6-4948-8d3a-d065e7ca717f	4b42dafddb6c43cd9afb812d1087c8a5cf8388572d6cbd2451d369053bb2b473	2024-11-13 11:47:43.937188+00	20241113114742_fluid_ounces_product_volume_add_in_tbl_product	\N	\N	2024-11-13 11:47:43.121745+00	1
72560379-cb20-43c6-b179-4dd690b2c127	27ecb425258ee493244edf6bd6d0d3c62eb449544124919915f4c14018b8ec70	2024-11-12 12:29:49.079279+00	20241029075400_add_tbl_payment_history	\N	\N	2024-11-12 12:29:48.41151+00	1
145960d5-746d-48e4-a5b7-aba0215001e4	a8ae8e0ab592be2fca66c20eda3f9d719be9402c813beca095b24f402626e187	2024-11-12 12:29:50.016031+00	20241030100435_add_tbl_billing_history_and_changes_in_tbl_payment_history	\N	\N	2024-11-12 12:29:49.342812+00	1
5681327e-10ee-4cff-ab1c-88b64f7f1a26	d68e833d0ca5aa218838f00fb76dea21f52cdd1b141ee3ad3ad13f239a0e2d3e	2024-11-12 12:29:50.940198+00	20241107100637_add_tbl_cms_pages	\N	\N	2024-11-12 12:29:50.279055+00	1
b3f62e43-4926-4391-8d09-eae306374e26	e29ddf15720438fef5e88f7aa7fdc498907c98478aded33e54a0dca0a73f7435	2024-11-14 05:15:03.660603+00	20241114051502_add_description_in_tbl_blog	\N	\N	2024-11-14 05:15:02.961037+00	1
ed3c616f-8459-409b-b94b-878a9e1f755c	1c455524eb27f30f8c33fb31c9e5ba54a8cdf12f0c1967e6c33cc078c0871a46	2024-11-12 12:29:51.862693+00	20241107105201_e	\N	\N	2024-11-12 12:29:51.203947+00	1
45589833-1c16-4480-9242-e868481eea65	e3bf5133a39dfe26de9ee81e9d114f5fb4eda9d265a4c682d17e00bc3556e872	2024-11-12 12:29:52.785367+00	20241107130625_e	\N	\N	2024-11-12 12:29:52.125961+00	1
c6cf38b9-d44b-4d9e-9238-a8d01592f2fb	42ff0841e574dee21686721072518d5e8c4cf555214dde969d49cfc229445a02	2024-11-12 12:29:53.71158+00	20241112121310_add_blog_category_table	\N	\N	2024-11-12 12:29:53.049089+00	1
2a6dad9e-b67b-42cc-bd48-96316621be0a	6a1609140d90811f14f42cecf81c8196fa10f6f2aa58076f11c559ef164fb788	2024-11-14 10:23:48.986394+00	20241114102347_set_index_in_tbl_product	\N	\N	2024-11-14 10:23:48.142149+00	1
\.


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

COPY public.country (id, short_name, name, phone_code, is_active, updated_at) FROM stdin;
1	AF	Afghanistan	93	t	\N
2	AL	Albania	355	t	\N
3	DZ	Algeria	213	t	\N
4	AS	American Samoa	1684	t	\N
5	AD	Andorra	376	t	\N
6	AO	Angola	244	t	\N
7	AI	Anguilla	1264	t	\N
8	AQ	Antarctica	0	t	\N
9	AG	Antigua And Barbuda	1268	t	\N
10	AR	Argentina	54	t	\N
11	AM	Armenia	374	t	\N
12	AW	Aruba	297	t	\N
13	AU	Australia	61	t	\N
14	AT	Austria	43	t	\N
15	AZ	Azerbaijan	994	t	\N
16	BS	Bahamas The	1242	t	\N
17	BH	Bahrain	973	t	\N
18	BD	Bangladesh	880	t	\N
19	BB	Barbados	1246	t	\N
20	BY	Belarus	375	t	\N
21	BE	Belgium	32	t	\N
22	BZ	Belize	501	t	\N
23	BJ	Benin	229	t	\N
24	BM	Bermuda	1441	t	\N
25	BT	Bhutan	975	t	\N
26	BO	Bolivia	591	t	\N
27	BA	Bosnia and Herzegovina	387	t	\N
28	BW	Botswana	267	t	\N
29	BV	Bouvet Island	0	t	\N
30	BR	Brazil	55	t	\N
31	IO	British Indian Ocean Territory	246	t	\N
32	BN	Brunei	673	t	\N
33	BG	Bulgaria	359	t	\N
34	BF	Burkina Faso	226	t	\N
35	BI	Burundi	257	t	\N
36	KH	Cambodia	855	t	\N
37	CM	Cameroon	237	t	\N
38	CA	Canada	1	t	\N
39	CV	Cape Verde	238	t	\N
40	KY	Cayman Islands	1345	t	\N
41	CF	Central African Republic	236	t	\N
42	TD	Chad	235	t	\N
43	CL	Chile	56	t	\N
44	CN	China	86	t	\N
45	CX	Christmas Island	61	t	\N
46	CC	Cocos (Keeling) Islands	672	t	\N
47	CO	Colombia	57	t	\N
48	KM	Comoros	269	t	\N
49	CG	Republic Of The Congo	242	t	\N
50	CD	Democratic Republic Of The Congo	242	t	\N
51	CK	Cook Islands	682	t	\N
52	CR	Costa Rica	506	t	\N
53	CI	Cote D'Ivoire (Ivory Coast)	225	t	\N
54	HR	Croatia (Hrvatska)	385	t	\N
55	CU	Cuba	53	t	\N
56	CY	Cyprus	357	t	\N
57	CZ	Czech Republic	420	t	\N
58	DK	Denmark	45	t	\N
59	DJ	Djibouti	253	t	\N
60	DM	Dominica	1767	t	\N
61	DO	Dominican Republic	1809	t	\N
62	TP	East Timor	670	t	\N
63	EC	Ecuador	593	t	\N
64	EG	Egypt	20	t	\N
65	SV	El Salvador	503	t	\N
66	GQ	Equatorial Guinea	240	t	\N
67	ER	Eritrea	291	t	\N
68	EE	Estonia	372	t	\N
69	ET	Ethiopia	251	t	\N
70	XA	External Territories of Australia	61	t	\N
71	FK	Falkland Islands	500	t	\N
72	FO	Faroe Islands	298	t	\N
73	FJ	Fiji Islands	679	t	\N
74	FI	Finland	358	t	\N
75	FR	France	33	t	\N
76	GF	French Guiana	594	t	\N
77	PF	French Polynesia	689	t	\N
78	TF	French Southern Territories	0	t	\N
79	GA	Gabon	241	t	\N
80	GM	Gambia The	220	t	\N
81	GE	Georgia	995	t	\N
82	DE	Germany	49	t	\N
83	GH	Ghana	233	t	\N
84	GI	Gibraltar	350	t	\N
85	GR	Greece	30	t	\N
86	GL	Greenland	299	t	\N
87	GD	Grenada	1473	t	\N
88	GP	Guadeloupe	590	t	\N
89	GU	Guam	1671	t	\N
90	GT	Guatemala	502	t	\N
91	XU	Guernsey and Alderney	44	t	\N
92	GN	Guinea	224	t	\N
93	GW	Guinea-Bissau	245	t	\N
94	GY	Guyana	592	t	\N
95	HT	Haiti	509	t	\N
96	HM	Heard and McDonald Islands	0	t	\N
97	HN	Honduras	504	t	\N
98	HK	Hong Kong S.A.R.	852	t	\N
99	HU	Hungary	36	t	\N
100	IS	Iceland	354	t	\N
101	IN	India	91	t	\N
102	ID	Indonesia	62	t	\N
103	IR	Iran	98	t	\N
104	IQ	Iraq	964	t	\N
105	IE	Ireland	353	t	\N
106	IL	Israel	972	t	\N
107	IT	Italy	39	t	\N
108	JM	Jamaica	1876	t	\N
109	JP	Japan	81	t	\N
110	XJ	Jersey	44	t	\N
111	JO	Jordan	962	t	\N
112	KZ	Kazakhstan	7	t	\N
113	KE	Kenya	254	t	\N
114	KI	Kiribati	686	t	\N
115	KP	Korea North	850	t	\N
116	KR	Korea South	82	t	\N
117	KW	Kuwait	965	t	\N
118	KG	Kyrgyzstan	996	t	\N
119	LA	Laos	856	t	\N
120	LV	Latvia	371	t	\N
121	LB	Lebanon	961	t	\N
122	LS	Lesotho	266	t	\N
123	LR	Liberia	231	t	\N
124	LY	Libya	218	t	\N
125	LI	Liechtenstein	423	t	\N
126	LT	Lithuania	370	t	\N
127	LU	Luxembourg	352	t	\N
128	MO	Macau S.A.R.	853	t	\N
129	MK	Macedonia	389	t	\N
130	MG	Madagascar	261	t	\N
131	MW	Malawi	265	t	\N
132	MY	Malaysia	60	t	\N
133	MV	Maldives	960	t	\N
134	ML	Mali	223	t	\N
135	MT	Malta	356	t	\N
136	XM	Man (Isle of)	44	t	\N
137	MH	Marshall Islands	692	t	\N
138	MQ	Martinique	596	t	\N
139	MR	Mauritania	222	t	\N
140	MU	Mauritius	230	t	\N
141	YT	Mayotte	269	t	\N
142	MX	Mexico	52	t	\N
143	FM	Micronesia	691	t	\N
144	MD	Moldova	373	t	\N
145	MC	Monaco	377	t	\N
146	MN	Mongolia	976	t	\N
147	MS	Montserrat	1664	t	\N
148	MA	Morocco	212	t	\N
149	MZ	Mozambique	258	t	\N
150	MM	Myanmar	95	t	\N
151	NA	Namibia	264	t	\N
152	NR	Nauru	674	t	\N
153	NP	Nepal	977	t	\N
154	AN	Netherlands Antilles	599	t	\N
155	NL	Netherlands The	31	t	\N
156	NC	New Caledonia	687	t	\N
157	NZ	New Zealand	64	t	\N
158	NI	Nicaragua	505	t	\N
159	NE	Niger	227	t	\N
160	NG	Nigeria	234	t	\N
161	NU	Niue	683	t	\N
162	NF	Norfolk Island	672	t	\N
163	MP	Northern Mariana Islands	1670	t	\N
164	NO	Norway	47	t	\N
165	OM	Oman	968	t	\N
166	PK	Pakistan	92	t	\N
167	PW	Palau	680	t	\N
168	PS	Palestinian Territory Occupied	970	t	\N
169	PA	Panama	507	t	\N
170	PG	Papua new Guinea	675	t	\N
171	PY	Paraguay	595	t	\N
172	PE	Peru	51	t	\N
173	PH	Philippines	63	t	\N
174	PN	Pitcairn Island	0	t	\N
175	PL	Poland	48	t	\N
176	PT	Portugal	351	t	\N
177	PR	Puerto Rico	1787	t	\N
178	QA	Qatar	974	t	\N
179	RE	Reunion	262	t	\N
180	RO	Romania	40	t	\N
181	RU	Russia	7	t	\N
182	RW	Rwanda	250	t	\N
183	SH	Saint Helena	290	t	\N
184	KN	Saint Kitts And Nevis	1869	t	\N
185	LC	Saint Lucia	1758	t	\N
186	PM	Saint Pierre and Miquelon	508	t	\N
187	VC	Saint Vincent And The Grenadines	1784	t	\N
188	WS	Samoa	684	t	\N
189	SM	San Marino	378	t	\N
190	ST	Sao Tome and Principe	239	t	\N
191	SA	Saudi Arabia	966	t	\N
192	SN	Senegal	221	t	\N
193	RS	Serbia	381	t	\N
194	SC	Seychelles	248	t	\N
195	SL	Sierra Leone	232	t	\N
196	SG	Singapore	65	t	\N
197	SK	Slovakia	421	t	\N
198	SI	Slovenia	386	t	\N
199	XG	Smaller Territories of the UK	44	t	\N
200	SB	Solomon Islands	677	t	\N
201	SO	Somalia	252	t	\N
202	ZA	South Africa	27	t	\N
203	GS	South Georgia	0	t	\N
204	SS	South Sudan	211	t	\N
205	ES	Spain	34	t	\N
206	LK	Sri Lanka	94	t	\N
207	SD	Sudan	249	t	\N
208	SR	Suriname	597	t	\N
209	SJ	Svalbard And Jan Mayen Islands	47	t	\N
210	SZ	Swaziland	268	t	\N
211	SE	Sweden	46	t	\N
212	CH	Switzerland	41	t	\N
213	SY	Syria	963	t	\N
214	TW	Taiwan	886	t	\N
215	TJ	Tajikistan	992	t	\N
216	TZ	Tanzania	255	t	\N
217	TH	Thailand	66	t	\N
218	TG	Togo	228	t	\N
219	TK	Tokelau	690	t	\N
220	TO	Tonga	676	t	\N
221	TT	Trinidad And Tobago	1868	t	\N
222	TN	Tunisia	216	t	\N
223	TR	Turkey	90	t	\N
224	TM	Turkmenistan	993	t	\N
225	TC	Turks And Caicos Islands	1649	t	\N
226	TV	Tuvalu	688	t	\N
227	UG	Uganda	256	t	\N
228	UA	Ukraine	380	t	\N
229	AE	United Arab Emirates	971	t	\N
230	GB	United Kingdom	44	t	\N
231	US	United States	1	t	\N
232	UM	United States Minor Outlying Islands	1	t	\N
233	UY	Uruguay	598	t	\N
234	UZ	Uzbekistan	998	t	\N
235	VU	Vanuatu	678	t	\N
236	VA	Vatican City State (Holy See)	39	t	\N
237	VE	Venezuela	58	t	\N
238	VN	Vietnam	84	t	\N
239	VG	Virgin Islands (British)	1284	t	\N
240	VI	Virgin Islands (US)	1340	t	\N
241	WF	Wallis And Futuna Islands	681	t	\N
242	EH	Western Sahara	212	t	\N
243	YE	Yemen	967	t	\N
244	YU	Yugoslavia	38	t	\N
245	ZM	Zambia	260	t	\N
246	ZW	Zimbabwe	263	t	\N
247	ALL	🌐 Rest of the World - (246) countries		t	\N
\.


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

COPY public.tbl_admin (id, first_name, last_name, email, password, token, forgot_token, forgot_token_expiry, is_online, is_active, is_delete, logined_at, forgoted_at, deleted_at, inserted_at, updated_at) FROM stdin;
2	NOM	Admin	adminnom@yopmail.com	$2a$10$ycqmeSOQ6OoBtDLBW4yAB.Uajd.DkbdVy4luFEDihyWwtDPiD1ec.	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6Mn0sImlhdCI6MTczMTUwOTY4Nn0.0VJ_ytm9uL4n2ldMkMqMKStbl3XLS_ayBmYn4uacxzc		\N	t	t	f	2024-11-13 14:54:46.187	\N	\N	2024-09-20 10:58:57.435	2024-11-13 14:54:46.189
1	NOM	Admin	nomadmin@yopmail.com	$2a$10$ycqmeSOQ6OoBtDLBW4yAB.Uajd.DkbdVy4luFEDihyWwtDPiD1ec.	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MX0sImlhdCI6MTczMTU2NzQ1MH0.Xt7mD_slK_kndUM5aAFF7zrvBuPMdVKuk8gmG-P1hwQ	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIyMDI0LTA5LTI0VDA3OjE0OjM4LjQzMFoiLCJkYXRhIjp7InVzZXJfaWQiOjEsInVzZXJfdHlwZSI6ImZvcmdvdCJ9LCJpYXQiOjE3MjcxNTg0Nzh9.84KWquBU19n3_6EVPJW-r-ZBa3N7_q9mjJh9cb2xzDw	2024-09-24 07:14:38	t	t	f	2024-11-14 06:57:30.636	2024-09-20 07:21:43.632	\N	2024-09-20 10:58:57.435	2024-11-14 06:57:30.637
\.


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

COPY public.tbl_billing_history (id, user_id, payment_id, order_ids, total_amount, invoice_no, invoice_file_name, currency, status, inserted_at, updated_at) FROM stdin;
1	23	1	1	25116.00	INV-428624109	INV-428624109.pdf	usd	succeeded	2024-11-13 05:35:42.837	2024-11-13 05:35:42.837
\.


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

COPY public.tbl_blog (id, category_id, title, image, content, updated_at, deleted_at, inserted_at, is_active, is_delete, description) FROM stdin;
1	4	Ditch Uniformity	\N	This summer, we're ditching uniformity in stone fruit to find next-level flavour. The mainstream would have us believe that conformity means perfection in stone fruit.	\N	\N	2024-11-13 18:27:00.958	t	f	\N
2	4	Dianna opening in UK	\N	Our expectation of what produce should taste like has been radically altered by the industrial food system.	\N	\N	2024-11-13 18:34:15.812	t	f	\N
\.


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

COPY public.tbl_blog_category (id, name, updated_at, deleted_at, inserted_at, is_active, is_delete) FROM stdin;
1	Campaigns	\N	\N	2024-11-13 15:26:26.212	t	f
2	Events	\N	\N	2024-11-13 15:26:26.405	t	f
3	Films	\N	\N	2024-11-13 15:26:26.567	t	f
4	Growers	\N	\N	2024-11-13 15:26:26.73	t	f
5	Interview	\N	\N	2024-11-13 15:26:26.893	t	f
6	Podcast	\N	\N	2024-11-13 15:26:27.055	t	f
\.


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

COPY public.tbl_cart (id, user_id, brand_id, product_id, qty, inserted_at, updated_at) FROM stdin;
4	23	18	2	1	2024-11-13 05:55:08.072	2024-11-13 05:55:08.072
5	23	4	1	1	2024-11-13 05:59:25.633	2024-11-13 05:59:25.633
\.


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

COPY public.tbl_category (id, parent_id, category_name, is_active, is_delete, deleted_at, inserted_at, updated_at) FROM stdin;
7	1	Tea	t	f	\N	2024-09-18 14:47:19.362	\N
8	1	Milk Alternatives	t	f	\N	2024-09-18 14:47:19.362	\N
9	1	Accessories & Enhancers	t	f	\N	2024-09-18 14:47:19.362	\N
12	6	Coffee Alternatives	t	f	\N	2024-09-18 14:50:21.696	\N
14	6	Coffee Pods	t	f	\N	2024-09-18 14:50:21.699	\N
15	6	Ground Coffee	t	f	\N	2024-09-18 14:50:21.701	\N
16	6	Instant Coffee	t	f	\N	2024-09-18 14:50:21.703	\N
17	6	Espresso	t	f	\N	2024-09-18 14:50:21.705	\N
18	6	Decaffeinated Coffee	t	f	\N	2024-09-18 14:50:21.706	\N
19	7	Ready-to-Drink Tea	t	f	\N	2024-09-18 14:50:21.708	\N
20	7	Loose Leaf	t	f	\N	2024-09-18 14:50:21.71	\N
21	7	Tea Bags	t	f	\N	2024-09-18 14:50:21.712	\N
22	7	Yerba Mate	t	f	\N	2024-09-18 14:50:21.714	\N
23	7	Matcha & Chai	t	f	\N	2024-09-18 14:50:21.716	\N
24	8	Almond Milk	t	f	\N	2024-09-18 14:52:04.219	\N
25	8	Ready-to-Drink Milks	t	f	\N	2024-09-18 14:52:04.229	\N
26	8	Soy Milk	t	f	\N	2024-09-18 14:52:04.231	\N
27	8	Oat Milk	t	f	\N	2024-09-18 14:52:04.234	\N
28	8	Pecan Milk	t	f	\N	2024-09-18 14:52:04.236	\N
29	9	Sweeteners	t	f	\N	2024-09-18 14:52:04.238	\N
30	9	Creamers	t	f	\N	2024-09-18 14:52:04.24	\N
31	9	Syrups	t	f	\N	2024-09-18 14:52:04.242	\N
32	9	Hot Cocoa	t	f	\N	2024-09-18 14:52:04.244	\N
10	6	Ready-to-Drink Coffee	t	f	\N	2024-09-18 14:50:21.692	2024-10-03 08:43:01.028
11	6	Mushroom Coffee	t	f	\N	2024-09-18 14:50:21.694	2024-10-03 08:43:22.808
13	6	Coffee Beans	t	f	\N	2024-09-18 14:50:21.697	2024-10-03 08:43:28.247
49	5	Test	t	t	2024-10-04 11:17:55.693	2024-10-04 11:17:46.092	2024-10-04 11:17:55.694
2	0	NON-ALCOHOLIC	t	f	\N	2024-09-18 14:47:19.375	2024-10-30 10:06:32.135
3	0	DRINKS	t	f	\N	2024-09-18 14:47:19.377	2024-10-30 10:06:39.074
4	0	SEAFOOD  MEAT	t	f	\N	2024-09-18 14:47:19.379	2024-10-30 10:06:49.014
5	0	DAIRY	t	f	\N	2024-09-18 14:47:19.381	2024-10-30 10:07:01.327
50	0	CONDIMENTS  SAUCES	t	f	\N	2024-10-30 10:07:16.177	2024-10-30 10:07:16.177
51	0	CEREALS GRAINS PULSES  PASTA	t	f	\N	2024-10-30 10:07:27.601	2024-10-30 10:07:27.601
52	0	NUTS  SEEDS	t	f	\N	2024-10-30 10:07:35.861	2024-10-30 10:07:35.861
53	0	BAKING	t	f	\N	2024-10-30 10:07:44.872	2024-10-30 10:07:44.872
54	0	HEALTH  WELLNESS	t	f	\N	2024-10-30 10:07:52.161	2024-10-30 10:07:52.161
55	0	CONFECTIONS  CHOCOLATE	t	f	\N	2024-10-30 10:08:00.453	2024-10-30 10:08:00.453
56	0	SNACKS	t	f	\N	2024-10-30 10:08:09.515	2024-10-30 10:08:09.515
57	0	PASTRIED CAKED AND DESSERTS	t	f	\N	2024-10-30 10:08:40.875	2024-10-30 10:08:40.875
58	0	PREPARED MEALS AND SEAFOOD	t	f	\N	2024-10-30 10:09:10.035	2024-10-30 10:09:10.035
59	1	WINE	t	f	\N	2024-10-30 10:09:50.98	2024-10-30 10:09:50.98
1	0	Alcoholic	t	f	\N	2024-09-18 14:47:19.362	2024-11-08 14:41:51.384
33	9	Coffee Filters	t	f	2024-09-25 10:29:52.672	2024-09-18 14:52:04.247	2024-09-25 10:29:52.674
40	39	Test Test Test	t	t	2024-10-01 08:46:05.851	2024-10-01 08:41:08.905	2024-10-01 08:46:05.852
39	38	Test Test	t	t	2024-10-01 08:46:21.457	2024-10-01 08:40:57.436	2024-10-01 08:46:21.458
38	0	Test	f	t	2024-10-01 08:46:30.224	2024-10-01 08:40:43.944	2024-10-01 08:46:30.225
41	1	Superfoods	t	f	\N	2024-10-02 15:30:41.639	2024-10-02 15:30:41.639
42	41	Acai Berries	t	f	\N	2024-10-02 15:31:32.894	2024-10-02 15:32:13.528
43	2	whiskey2	t	f	\N	2024-10-02 15:43:38.409	2024-10-03 07:33:54.304
6	1	Coffee	t	f	\N	2024-09-18 14:47:19.362	2024-10-03 08:08:19.723
\.


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

COPY public.tbl_chat (id, chat_room_id, sender_id, receiver_id, message, message_type, is_read, is_active, is_delete, deleted_at, inserted_at, updated_at, receiver_type, sender_type) FROM stdin;
\.


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

COPY public.tbl_chat_room (id, sender_id, receiver_id, last_message, last_message_at, is_active, is_delete, deleted_at, inserted_at, updated_at, receiver_type, sender_type) FROM stdin;
\.


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

COPY public.tbl_cms_page (id, title, slug, content, created_at, updated_at, short_description) FROM stdin;
6	Connect Common Content	connect-common-content	<p>Sign up to start selling on Nom’s B2B marketplace. No set-up fees. No commitments.</p>	2024-11-07 18:51:46.656	2024-11-11 07:42:55.233	Connect with independent buyers from the United Kingdom, the EU and beyond.
5	Our Story	our-story	{"section_1":{"section1_title":"It started with a peach","section1_banner_image":"/uploads/cms_images/our_story_banner_img_sec_1_219811819_61Dro4x3NoL.jpg","section1_short_description":"How a mission to find flavour grew into a food system revolution.","section1_description":"<p>New York City in the weeks leading up to Christmas, 1999. The story goes that Franco Fubini — Natoora’s founder — visited Citarella. It was the second Citarella on 1313 3rd Ave in the Upper East Side, which was just around the block from where he lived. The family-run grocery store was already known for its fish, but it had a fresh produce section right at the entrance. This is where Franco overheard a woman asking for peaches. Peaches in December.</p>","section1_image":"/uploads/cms_images/our_story_img_sec_1_921308311_pexels-photo-672630.jpeg","section1_image_description":"<p>Franco clearly recollects this moment — a single snapshot of his frustrations with New York’s food scene at the time. Cooking for friends, Franco spent his free time searching farmers markets for produce as exceptional as the foods he remembers eating growing up. Everything came up short.</p><p>Born in Argentina to a German-Jewish mother and Italian father, Franco spent his childhood immersed in varied and vibrant food cultures. His step-father’s work took the family to Italy, Egypt and the Netherlands in the 1970s and 80s.</p>"},"section_2":{"section2_quotes":"For close to 20 years, we’ve built our sourcing around a very simple, yet immensely powerful ethos: flavour first.","section2_quotes_author":"Franco Fubini, Natoora Founder & CEO"},"section_3":{"section3_description_1":"<p>It was the direct relationships forged at and through these markets that became springboards for radical change. At the Milan market, Franco tasted a White Peach with flesh almost entirely blushed with deep purple streaks. Two years of hunting around the Italian countryside to trace that peach back to its grower led him to Domenico, whose stone fruits have become an institution for us in Europe over the warmer months.</p>","section3_image_1":"/uploads/cms_images/our_story_img_1_sec_3_39699398_pexels-pixabay-268533.jpg","section3_description_2":"<p>Today, we've taken the revolution beyond London to New York, Miami, Paris, Malmö, Copenhagen and Melbourne. Each city has its own, unique supply chain adapted to its locality. Preserving this granularity is vital to the integrity of our expansion. Far from an extensive, opaque export system, we have built local chains which thrive by way of their direct connections.</p>","section3_image_2":"/uploads/cms_images/our_story_img_2_sec_3_471406902_art_KqCjXuoLHW (1).jpg"},"section_4":{"section4_image":"/uploads/cms_images/our_story_img_sec_4_271303287_wp2555730.jpg","section4_image_title":"Our story is far from finished. In fact, it's only just getting started."}}	2024-11-07 18:51:46.656	2024-11-11 09:45:35.5	We use some cookies to help improve your experience on this website. Here's some more info about what we do with information we collect.
1	Term and Conditions	term-conditions	<p>Mi tincidunt elit, id quisque ligula ac diam, amet. Vel etiam suspendisse morbi eleifend faucibus eget vestibulum felis. Dictum quis montes, sit sit. Tellus aliquam enim urna, etiam. Mauris posuere vulputate arcu amet, vitae nisi, tellus tincidunt. At feugiat sapien varius id.</p><p>Eget quis mi enim, leo lacinia pharetra, semper. Eget in volutpat mollis at volutpat lectus velit, sed auctor. Porttitor fames arcu quis fusce augue enim. Quis at habitant diam at. Suscipit tristique risus, at donec. In turpis vel et quam imperdiet. Ipsum molestie aliquet sodales id est ac volutpat.</p><p><strong>What information do we collect?</strong></p><p>Dolor enim eu tortor urna sed duis nulla. Aliquam vestibulum, nulla odio nisl vitae. In aliquet pellentesque aenean hac vestibulum turpis mi bibendum diam. Tempor integer aliquam in vitae malesuada fringilla.</p><p>Elit nisi in eleifend sed nisi. Pulvinar at orci, proin imperdiet commodo consectetur convallis risus. Sed condimentum enim dignissim adipiscing faucibus consequat, urna. Viverra purus et erat auctor aliquam. Risus, volutpat vulputate posuere purus sit congue convallis aliquet. Arcu id augue ut feugiat donec porttitor neque. Mauris, neque ultricies eu vestibulum, bibendum quam lorem id. Dolor lacus, eget nunc lectus in tellus, pharetra, porttitor.</p><p>Ipsum sit mattis nulla quam nulla. Gravida id gravida ac enim mauris id. Non pellentesque congue eget consectetur turpis. Sapien, dictum molestie sem tempor. Diam elit, orci, tincidunt aenean tempus. Quis velit eget ut tortor tellus. Sed vel, congue felis elit erat nam nibh orci.</p><p><strong>How do we use your information?</strong></p><p>Dolor enim eu tortor urna sed duis nulla. Aliquam vestibulum, nulla odio nisl vitae. In aliquet pellentesque aenean hac vestibulum turpis mi bibendum diam. Tempor integer aliquam in vitae malesuada fringilla.</p><p>Elit nisi in eleifend sed nisi. Pulvinar at orci, proin imperdiet commodo consectetur convallis risus. Sed condimentum enim dignissim adipiscing faucibus consequat, urna. Viverra purus et erat auctor aliquam. Risus, volutpat vulputate posuere purus sit congue convallis aliquet. Arcu id augue ut feugiat donec porttitor neque. Mauris, neque ultricies eu vestibulum, bibendum quam lorem id. Dolor lacus, eget nunc lectus in tellus, pharetra, porttitor.</p><p>Ipsum sit mattis nulla quam nulla. Gravida id gravida ac enim mauris id. Non pellentesque congue eget consectetur turpis. Sapien, dictum molestie sem tempor. Diam elit, orci, tincidunt aenean tempus. Quis velit eget ut tortor tellus. Sed vel, congue felis elit erat nam nibh orci.</p><p><strong>Do we use cookies and other tracking technologies?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>How long do we keep your information?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>How do we keep your information safe?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>What are your privacy rights?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>How can you contact us about this policy?</strong></p><p>Sagittis et eu at elementum, quis in. Proin praesent volutpat egestas sociis sit lorem nunc nunc sit. Eget diam curabitur mi ac. Auctor rutrum lacus malesuada massa ornare et. Vulputate consectetur ac ultrices at diam dui eget fringilla tincidunt. Arcu sit dignissim massa erat cursus vulputate gravida id. Sed quis auctor vulputate hac elementum gravida cursus dis.</p><ul><li>Lectus id duis vitae porttitor enim gravida morbi.</li><li>Eu turpis posuere semper feugiat volutpat elit, ultrices suspendisse. Auctor vel in vitae placerat.</li><li>Suspendisse maecenas ac donec scelerisque diam sed est duis purus.</li></ul>	2024-11-07 18:51:46.656	2024-11-11 09:47:02.575	By accessing our website, you are agreeing to be bound by these terms of service, all applicable laws and regulations, and agree that you are responsible for compliance with any applicable local laws.
2	Privacy Policy	privacy-policy	<p>Mi tincidunt elit, id quisque ligula ac diam, amet. Vel etiam suspendisse morbi eleifend faucibus eget vestibulum felis. Dictum quis montes, sit sit. Tellus aliquam enim urna, etiam. Mauris posuere vulputate arcu amet, vitae nisi, tellus tincidunt. At feugiat sapien varius id.</p><p>Eget quis mi enim, leo lacinia pharetra, semper. Eget in volutpat mollis at volutpat lectus velit, sed auctor. Porttitor fames arcu quis fusce augue enim. Quis at habitant diam at. Suscipit tristique risus, at donec. In turpis vel et quam imperdiet. Ipsum molestie aliquet sodales id est ac volutpat.</p><p><strong>What information do we collect?</strong></p><p>Dolor enim eu tortor urna sed duis nulla. Aliquam vestibulum, nulla odio nisl vitae. In aliquet pellentesque aenean hac vestibulum turpis mi bibendum diam. Tempor integer aliquam in vitae malesuada fringilla.</p><p>Elit nisi in eleifend sed nisi. Pulvinar at orci, proin imperdiet commodo consectetur convallis risus. Sed condimentum enim dignissim adipiscing faucibus consequat, urna. Viverra purus et erat auctor aliquam. Risus, volutpat vulputate posuere purus sit congue convallis aliquet. Arcu id augue ut feugiat donec porttitor neque. Mauris, neque ultricies eu vestibulum, bibendum quam lorem id. Dolor lacus, eget nunc lectus in tellus, pharetra, porttitor.</p><p>Ipsum sit mattis nulla quam nulla. Gravida id gravida ac enim mauris id. Non pellentesque congue eget consectetur turpis. Sapien, dictum molestie sem tempor. Diam elit, orci, tincidunt aenean tempus. Quis velit eget ut tortor tellus. Sed vel, congue felis elit erat nam nibh orci.</p><p><strong>How do we use your information?</strong></p><p>Dolor enim eu tortor urna sed duis nulla. Aliquam vestibulum, nulla odio nisl vitae. In aliquet pellentesque aenean hac vestibulum turpis mi bibendum diam. Tempor integer aliquam in vitae malesuada fringilla.</p><p>Elit nisi in eleifend sed nisi. Pulvinar at orci, proin imperdiet commodo consectetur convallis risus. Sed condimentum enim dignissim adipiscing faucibus consequat, urna. Viverra purus et erat auctor aliquam. Risus, volutpat vulputate posuere purus sit congue convallis aliquet. Arcu id augue ut feugiat donec porttitor neque. Mauris, neque ultricies eu vestibulum, bibendum quam lorem id. Dolor lacus, eget nunc lectus in tellus, pharetra, porttitor.</p><p>Ipsum sit mattis nulla quam nulla. Gravida id gravida ac enim mauris id. Non pellentesque congue eget consectetur turpis. Sapien, dictum molestie sem tempor. Diam elit, orci, tincidunt aenean tempus. Quis velit eget ut tortor tellus. Sed vel, congue felis elit erat nam nibh orci.</p><p><strong>Do we use cookies and other tracking technologies?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>How long do we keep your information?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>How do we keep your information safe?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>What are your privacy rights?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>How can you contact us about this policy?</strong></p><p>Sagittis et eu at elementum, quis in. Proin praesent volutpat egestas sociis sit lorem nunc nunc sit. Eget diam curabitur mi ac. Auctor rutrum lacus malesuada massa ornare et. Vulputate consectetur ac ultrices at diam dui eget fringilla tincidunt. Arcu sit dignissim massa erat cursus vulputate gravida id. Sed quis auctor vulputate hac elementum gravida cursus dis.</p><ul><li>Lectus id duis vitae porttitor enim gravida morbi.</li><li>Eu turpis posuere semper feugiat volutpat elit, ultrices suspendisse. Auctor vel in vitae placerat.</li><li>Suspendisse maecenas ac donec scelerisque diam sed est duis purus.</li></ul>	2024-11-07 18:51:46.656	2024-11-08 06:13:08.091	Your privacy is important to us at Untitled. We respect your privacy regarding any information we may collect from you across our website.
3	Cookie Policy	cookie-policy	<p>Mi tincidunt elit, id quisque ligula ac diam, amet. Vel etiam suspendisse morbi eleifend faucibus eget vestibulum felis. Dictum quis montes, sit sit. Tellus aliquam enim urna, etiam. Mauris posuere vulputate arcu amet, vitae nisi, tellus tincidunt. At feugiat sapien varius id.</p><p>Eget quis mi enim, leo lacinia pharetra, semper. Eget in volutpat mollis at volutpat lectus velit, sed auctor. Porttitor fames arcu quis fusce augue enim. Quis at habitant diam at. Suscipit tristique risus, at donec. In turpis vel et quam imperdiet. Ipsum molestie aliquet sodales id est ac volutpat.</p><p><strong>What information do we collect?</strong></p><p>Dolor enim eu tortor urna sed duis nulla. Aliquam vestibulum, nulla odio nisl vitae. In aliquet pellentesque aenean hac vestibulum turpis mi bibendum diam. Tempor integer aliquam in vitae malesuada fringilla.</p><p>Elit nisi in eleifend sed nisi. Pulvinar at orci, proin imperdiet commodo consectetur convallis risus. Sed condimentum enim dignissim adipiscing faucibus consequat, urna. Viverra purus et erat auctor aliquam. Risus, volutpat vulputate posuere purus sit congue convallis aliquet. Arcu id augue ut feugiat donec porttitor neque. Mauris, neque ultricies eu vestibulum, bibendum quam lorem id. Dolor lacus, eget nunc lectus in tellus, pharetra, porttitor.</p><p>Ipsum sit mattis nulla quam nulla. Gravida id gravida ac enim mauris id. Non pellentesque congue eget consectetur turpis. Sapien, dictum molestie sem tempor. Diam elit, orci, tincidunt aenean tempus. Quis velit eget ut tortor tellus. Sed vel, congue felis elit erat nam nibh orci.</p><p><strong>How do we use your information?</strong></p><p>Dolor enim eu tortor urna sed duis nulla. Aliquam vestibulum, nulla odio nisl vitae. In aliquet pellentesque aenean hac vestibulum turpis mi bibendum diam. Tempor integer aliquam in vitae malesuada fringilla.</p><p>Elit nisi in eleifend sed nisi. Pulvinar at orci, proin imperdiet commodo consectetur convallis risus. Sed condimentum enim dignissim adipiscing faucibus consequat, urna. Viverra purus et erat auctor aliquam. Risus, volutpat vulputate posuere purus sit congue convallis aliquet. Arcu id augue ut feugiat donec porttitor neque. Mauris, neque ultricies eu vestibulum, bibendum quam lorem id. Dolor lacus, eget nunc lectus in tellus, pharetra, porttitor.</p><p>Ipsum sit mattis nulla quam nulla. Gravida id gravida ac enim mauris id. Non pellentesque congue eget consectetur turpis. Sapien, dictum molestie sem tempor. Diam elit, orci, tincidunt aenean tempus. Quis velit eget ut tortor tellus. Sed vel, congue felis elit erat nam nibh orci.</p><p><strong>Do we use cookies and other tracking technologies?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>How long do we keep your information?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>How do we keep your information safe?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>What are your privacy rights?</strong></p><p>Pharetra morbi libero id aliquam elit massa integer tellus. Quis felis aliquam ullamcorper porttitor. Pulvinar ullamcorper sit dictumst ut eget a, elementum eu. Maecenas est morbi mattis id in ac pellentesque ac.</p><p><strong>How can you contact us about this policy?</strong></p><p>Sagittis et eu at elementum, quis in. Proin praesent volutpat egestas sociis sit lorem nunc nunc sit. Eget diam curabitur mi ac. Auctor rutrum lacus malesuada massa ornare et. Vulputate consectetur ac ultrices at diam dui eget fringilla tincidunt. Arcu sit dignissim massa erat cursus vulputate gravida id. Sed quis auctor vulputate hac elementum gravida cursus dis.</p><ul><li>Lectus id duis vitae porttitor enim gravida morbi.</li><li>Eu turpis posuere semper feugiat volutpat elit, ultrices suspendisse. Auctor vel in vitae placerat.</li><li>Suspendisse maecenas ac donec scelerisque diam sed est duis purus.</li></ul>	2024-11-07 18:51:46.656	2024-11-08 11:22:45.069	We use some cookies to help improve your experience on this website. Here's some more info about what we do with information we collect.
8	Food System Common Content	food-system-common-content	<p>People are more cut off from the origins of their food than ever. This makes flavour, nutrition and farming practices that protect the planet, almost impossible to find.</p><p>By working directly with growers, we create a more sustainable way forward for farming. By giving everyone the tools to understand the power of our food choices, we empower everybody to become drivers of change.</p><p>Now is the time for action. Join the food system revolution.</p>	2024-11-07 18:51:46.656	2024-11-11 07:48:17.033	We exist to fix the food system
7	Sell on Nom	sell-on-nom	{"section_1":{"section1_title_1":"It started with a peach","section1_description_1":"<p>It started with a peach</p>","section1_image_1":"/uploads/cms_images/sell_on_nom_img_1_sec_1_521782522_Group 888.png","section1_title_2":"It started with a peach","section1_description_2":"<p>It started with a peach</p>","section1_image_2":"/uploads/cms_images/sell_on_nom_img_2_sec_1_232715524_Group 886.jpg","section1_title_3":"It started with a peach","section1_description_3":"<p>It started with a peach</p>","section1_image_3":"/uploads/cms_images/our_story_banner_img_sec_1_317996229_tree-736885_1280.jpg"},"section_2":{"section2_heading":"It started with a peach","section2_image_1":"/uploads/cms_images/our_story_banner_img_sec_1_317996229_tree-736885_1280.jpg","section2_title_1":"It started with a peach","section2_description_1":"<p>It started with a peach</p>","section2_image_2":"/uploads/cms_images/our_story_banner_img_sec_1_317996229_tree-736885_1280.jpg","section2_title_2":"It started with a peach","section2_description_2":"<p>It started with a peach</p>","section2_image_3":"/uploads/cms_images/our_story_banner_img_sec_1_317996229_tree-736885_1280.jpg","section2_title_3":"It started with a peach","section2_description_3":"<p>It started with a peach</p>","section2_image_4":"/uploads/cms_images/our_story_banner_img_sec_1_317996229_tree-736885_1280.jpg","section2_title_4":"It started with a peach","section2_description_4":"<p>It started with a peach</p>"},"section_4":{"section4_title":"It started with a peach","section4_image":"/uploads/cms_images/our_story_banner_img_sec_1_317996229_tree-736885_1280.jpg"},"section_5":{"section5_image":"/uploads/cms_images/our_story_banner_img_sec_1_317996229_tree-736885_1280.jpg","section5_image_title":"It started with a peach"}}	2024-11-07 18:51:46.656	2024-11-13 08:58:08.369	We use some cookies to help improve your experience on this website. Here's some more info about what we do with information we collect.
\.


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

COPY public.tbl_currency (id, currency_logo, currency_short_name, currency_full_name, is_active, is_delete, deleted_at, inserted_at, updated_at) FROM stdin;
1	$	USD	United States Dollar	t	f	\N	2024-09-18 17:15:34.425	\N
2	₹	INR	Indian Rupee	t	f	\N	2024-09-18 17:15:34.427	\N
3	£	GBP	Great Britain Pound	t	f	\N	2024-09-18 17:15:34.428	\N
\.


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

COPY public.tbl_customer_order (id, user_id, brand_id, total, internal_note, is_user_blocked, last_order_at, inserted_at, updated_at) FROM stdin;
1	23	18	25116.00	\N	f	2024-11-13 05:35:37.207	2024-11-13 05:35:37.209	2024-11-13 05:35:37.209
2	1	18	49228.00	\N	f	2024-11-14 17:29:02.85	2024-11-14 17:29:02.852	2024-11-14 17:29:02.852
\.


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

COPY public.tbl_dropdown_list (id, name, icon_image, type, is_active, is_delete, deleted_at, inserted_at, updated_at) FROM stdin;
2	Eggs		allergen	t	f	\N	2024-09-18 14:55:53.71	\N
3	Fish		allergen	t	f	\N	2024-09-18 14:55:53.712	\N
4	Crustacean Shellfish		allergen	t	f	\N	2024-09-18 14:55:53.714	\N
5	Tree Nuts		allergen	t	f	\N	2024-09-18 14:55:53.716	\N
6	Peanuts		allergen	t	f	\N	2024-09-18 14:55:53.717	\N
7	Sesame		allergen	t	f	\N	2024-09-18 14:55:53.719	\N
8	Wheat		allergen	t	f	\N	2024-09-18 14:55:53.721	\N
9	Soybeans		allergen	t	f	\N	2024-09-18 14:55:53.722	\N
10	Gluten		allergen	t	f	\N	2024-09-18 14:55:53.724	\N
11	Lupin		allergen	t	f	\N	2024-09-18 14:55:53.726	\N
12	Molluscs		allergen	t	f	\N	2024-09-18 14:55:53.728	\N
13	Mustard		allergen	t	f	\N	2024-09-18 14:55:53.73	\N
14	Sulphur Dioxide & Sulphites		allergen	t	f	\N	2024-09-18 14:55:53.733	\N
15	Celery		allergen	t	f	\N	2024-09-18 14:55:53.735	\N
16	Fair trade		production	t	f	\N	2024-09-18 14:57:59.202	\N
17	Grass-fed		production	t	f	\N	2024-09-18 14:57:59.211	\N
18	Free-range		production	t	f	\N	2024-09-18 14:57:59.213	\N
19	Locally sourced		production	t	f	\N	2024-09-18 14:57:59.214	\N
20	No added hormones		production	t	f	\N	2024-09-18 14:57:59.216	\N
21	No Antibiotics		production	t	f	\N	2024-09-18 14:57:59.217	\N
22	No Preservatives		production	t	f	\N	2024-09-18 14:57:59.219	\N
23	No added Nitrates or Nitrites		production	t	f	\N	2024-09-18 14:57:59.22	\N
24	No Artificial Sweeteners		production	t	f	\N	2024-09-18 14:57:59.221	\N
25	Non-GMO		production	t	f	\N	2024-09-18 14:57:59.223	\N
26	Regenerative		production	t	f	\N	2024-09-18 14:57:59.224	\N
27	Vegan		diet	t	f	\N	2024-09-18 15:00:53.533	\N
28	Vegetarian		diet	t	f	\N	2024-09-18 15:00:53.543	\N
29	Paleo		diet	t	f	\N	2024-09-18 15:00:53.545	\N
30	Plant-based		diet	t	f	\N	2024-09-18 15:00:53.547	\N
31	Ketogenic		diet	t	f	\N	2024-09-18 15:00:53.549	\N
32	Halal		diet	t	f	\N	2024-09-18 15:00:53.552	\N
33	Kosher		diet	t	f	\N	2024-09-18 15:00:53.555	\N
34	Organic		diet	t	f	\N	2024-09-18 15:00:53.557	\N
35	Alcohol-free		diet	t	f	\N	2024-09-18 15:00:53.559	\N
36	Dairy-free		diet	t	f	\N	2024-09-18 15:00:53.561	\N
37	Grain-free		diet	t	f	\N	2024-09-18 15:00:53.567	\N
38	Gluten-free		diet	t	f	\N	2024-09-18 15:00:53.57	\N
39	Nut-free		diet	t	f	\N	2024-09-18 15:00:53.572	\N
40	Sodium-free		diet	t	f	\N	2024-09-18 15:00:53.575	\N
41	Low-sodium		diet	t	f	\N	2024-09-18 15:00:53.577	\N
42	Low Fat		diet	t	f	\N	2024-09-18 15:00:53.579	\N
43	Low Sugar		diet	t	f	\N	2024-09-18 15:00:53.581	\N
44	Soy-free		diet	t	f	\N	2024-09-18 15:00:53.584	\N
45	Whole Foods		diet	t	f	\N	2024-09-18 15:00:53.587	\N
46	Under a week		shelf_life	t	f	\N	2024-09-18 15:02:48.713	\N
47	Up to 2 weeks		shelf_life	t	f	\N	2024-09-18 15:02:48.722	\N
48	1 Month		shelf_life	t	f	\N	2024-09-18 15:02:48.723	\N
49	1-3 Months		shelf_life	t	f	\N	2024-09-18 15:02:48.725	\N
50	3-6 Months		shelf_life	t	f	\N	2024-09-18 15:02:48.726	\N
51	6-12 Months		shelf_life	t	f	\N	2024-09-18 15:02:48.728	\N
52	12-24 Months		shelf_life	t	f	\N	2024-09-18 15:02:48.729	\N
53	24-36 Months		shelf_life	t	f	\N	2024-09-18 15:02:48.73	\N
54	Eco-friendly		supplier_value	t	f	\N	2024-09-18 15:02:48.732	\N
55	Gives Back		supplier_value	t	f	\N	2024-09-18 15:02:48.732	\N
56	Local		supplier_value	t	f	\N	2024-09-18 15:02:48.732	\N
57	Sustainable		supplier_value	t	f	\N	2024-09-18 15:02:48.732	\N
58	Carbon Neutral		supplier_value	t	f	\N	2024-09-18 15:02:48.732	\N
59	Recycled		supplier_value	t	f	\N	2024-09-18 15:02:48.732	\N
60	Women-owned		supplier_value	t	f	\N	2024-09-18 15:02:48.732	\N
61	Regenerative		supplier_value	t	f	\N	2024-09-18 15:02:48.732	\N
62	Not on Amazon		supplier_value	t	f	\N	2024-09-18 15:02:48.732	\N
63	Freeze		storage	t	f	\N	2024-09-18 15:02:48.732	\N
64	Shelf-stable		storage	t	f	\N	2024-09-18 15:02:48.732	\N
65	Refrigerate		storage	t	f	\N	2024-09-18 15:02:48.732	\N
66	Online Only		type_of_store	t	f	\N	2024-09-18 15:09:04.082	\N
67	Social Media		here_about_us	t	f	\N	2024-09-18 15:09:33.203	\N
68	Offline		type_of_store	t	f	\N	2024-09-25 12:11:47.205	2024-10-04 10:10:57.741
76	No Allergens		allergen	t	f	\N	2024-10-04 21:07:46.988	2024-10-04 21:07:46.988
77	Non-GMO		diet	t	f	\N	2024-10-04 21:09:23.749	2024-10-04 21:09:23.749
78	Family-owned		supplier_value	t	f	\N	2024-10-04 21:10:54.537	2024-10-04 21:10:54.537
88	Same Day		shipping_time	t	f	\N	2024-10-07 08:34:48.578	2024-10-07 08:56:07.297
79	Preservative-free		diet	t	f	\N	2024-10-04 21:12:00.424	2024-10-04 21:12:00.424
80	No added nitrates		diet	t	f	\N	2024-10-04 21:12:17.908	2024-10-04 21:12:17.908
81	No artificial sweeteners		diet	t	f	\N	2024-10-04 21:12:32.218	2024-10-04 21:12:32.218
74	Offline		nutrition	f	t	2024-10-01 10:21:02.859	2024-10-01 10:20:55.339	2024-10-01 10:21:02.86
82	No added hormones		diet	t	f	\N	2024-10-04 21:12:46.905	2024-10-04 21:12:46.905
75	12		nutrition	t	t	2024-10-04 10:10:47.259	2024-10-04 10:10:31.875	2024-10-04 10:10:47.261
69	Friends Through		here_about_us	t	f	2024-09-25 12:50:43.27	2024-09-25 12:13:20.499	2024-10-04 10:10:56.886
70	Preservative-free		nutrition	t	f	\N	2024-10-01 09:11:45.038	2024-10-07 04:36:46.202
71	No added nitrates		nutrition	t	f	\N	2024-10-01 09:12:19.851	2024-10-07 04:36:48.624
72	No artificial sweeteners		nutrition	t	f	\N	2024-10-01 09:12:29.174	2024-10-07 04:36:49.31
73	No added hormones		nutrition	t	f	\N	2024-10-01 09:12:39.106	2024-10-07 04:36:49.955
89	Next Day		shipping_time	t	f	\N	2024-10-07 08:35:05.069	2024-10-07 08:56:07.899
91	6 days or less		shipping_time	t	f	\N	2024-10-07 08:35:25.962	2024-10-07 08:56:09.498
92	14 days or less		shipping_time	t	f	\N	2024-10-07 08:35:36.925	2024-10-07 08:56:10.178
90	3 days or less		shipping_time	t	f	\N	2024-10-07 08:35:17.012	2024-10-07 08:56:08.587
84	no minimum		brand_minimum	t	f	\N	2024-10-07 08:33:48.659	2024-10-07 09:07:17.632
85	100 or less		brand_minimum	t	f	\N	2024-10-07 08:33:57.826	2024-10-07 09:07:18.154
86	200 or less		brand_minimum	t	f	\N	2024-10-07 08:34:06.474	2024-10-07 09:07:19.04
87	300 or less		brand_minimum	t	f	\N	2024-10-07 08:34:15.879	2024-10-07 09:07:19.998
93	mg		weight_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
83	UK		product_origin	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
95	kg		weight_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
97	oz		weight_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
98	lb		weight_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
99	st		weight_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
101	ml		volume_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
94	gm		weight_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
96	mt		weight_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
102	l		volume_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
103	fl_oz		volume_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
104	pt		volume_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
105	qt		volume_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
106	gal		volume_units	t	f	\N	2024-10-07 08:03:15.787	2024-10-07 08:51:23.71
1	Milk		allergen	t	f	2024-09-25 11:47:25.189	2024-09-18 14:55:53.7	2024-11-13 12:03:33.35
\.


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

COPY public.tbl_favourites (id, user_id, product_id, type, is_active, inserted_at, updated_at, brand_id) FROM stdin;
\.


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

COPY public.tbl_fulfilment (id, delivery_option, option_name, per_order_fee, per_order_currency, fee_per_item, fee_per_item_currency, country_ids, is_active, is_delete, deleted_at, inserted_at, updated_at, user_id, is_default) FROM stdin;
2	flat	Test 1	89.00	\N	89.00	\N	3	t	f	\N	2024-11-12 15:49:07.65	2024-11-12 15:49:07.65	18	f
3	flat	Next day	5.00	\N	10.00	\N	230,1,3,2,4,5,6,7	t	f	\N	2024-11-13 15:16:04.693	2024-11-13 18:53:00.691	4	f
5	flat	test 1	1.00	\N	1.00	\N	3,4	t	f	\N	2024-11-13 19:12:44.059	2024-11-13 19:13:02.281	4	f
4	flat	Europe	5.00	\N	15.00	\N	247,59,121	t	f	\N	2024-11-13 18:53:46.341	2024-11-13 19:13:59.888	4	f
6	flat	test 2	5.00	\N	5.00	\N	3	t	f	\N	2024-11-13 19:13:59.879	2024-11-14 06:54:59.861	4	f
8	flat	Royal fedex	10.00	\N	2.00	\N	247	t	f	\N	2024-11-14 11:26:40.258	2024-11-14 11:26:40.258	18	t
7	flat	Default Fulfilment set	22.00	\N	2.00	\N	1	t	f	\N	2024-11-14 06:54:59.837	2024-11-14 14:35:28.127	4	f
9	flat	Test	20.00	\N	30.00	\N	3	t	f	\N	2024-11-14 14:35:55.701	2024-11-14 14:35:55.701	4	t
1	flat	Royal Mall	13.00	\N	24.00	\N	247,2	t	f	\N	2024-11-12 15:28:37.241	2024-11-14 14:35:55.715	4	f
\.


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

COPY public.tbl_fulfilment_weight (id, fulfilment_id, starting_weight, ending_weight, cost, is_active, is_delete, deleted_at, inserted_at, updated_at) FROM stdin;
\.


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

COPY public.tbl_order (id, user_id, brand_id, payment_id, order_no, order_type, payment_status, order_status, refund, discount, sub_total, vat_charges, total, address, billing_user_name, customer_note, internal_note, is_active, is_delete, deleted_at, ordered_at, refunded_at, fulfilled_at, pending_at, returned_at, cancelled_at, inserted_at, updated_at, address_id) FROM stdin;
1	23	18	1	125449	product	paid	pending	\N	\N	24849.00	267.00	25116.00	65, asdasdasd sasdas ssa sassa, 382350	Test First	\N	\N	t	f	\N	2024-11-13 05:35:31.595	\N	\N	2024-11-13 05:35:31.595	\N	\N	2024-11-13 05:35:32.915	2024-11-13 05:35:37.56	1
2	1	18	\N	180014	product	paid	pending	\N	\N	49050.00	178.00	49228.00	65, asdasdasd sasdas ssa sassa, 382350	Test First	\N	\N	t	f	\N	2024-11-14 17:29:02.584	\N	\N	2024-11-14 17:29:02.584	\N	\N	2024-11-14 17:29:02.687	2024-11-14 17:29:02.687	1
\.


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

COPY public.tbl_order_carrier (id, order_id, tracking_number, carrier, is_active, inserted_at, updated_at) FROM stdin;
\.


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

COPY public.tbl_order_item (id, order_id, user_id, brand_id, product_id, each_product_price, total_product_price, qty, reason_of_return, return_qty, is_refund_requested, is_active, is_delete, deleted_at, inserted_at, updated_at) FROM stdin;
1	1	23	18	3	324.00	324.00	1	\N	\N	f	t	f	\N	2024-11-13 05:35:33.268	2024-11-13 05:35:33.268
2	1	23	18	2	24525.00	24525.00	1	\N	\N	f	t	f	\N	2024-11-13 05:35:33.268	2024-11-13 05:35:33.268
3	2	1	18	2	24525.00	49050.00	2	\N	\N	f	t	f	\N	2024-11-14 17:29:02.707	2024-11-14 17:29:02.707
\.


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

COPY public.tbl_payment_history (id, user_id, customer_id, payment_intent_id, payment_method, paid_amount, status, currency, payment_intent_log, inserted_at, updated_at) FROM stdin;
1	23	cus_R7NUYA1Vlim74b	pi_3QKZEjAg8fCxyONO1kyS1y50	pm_1QF8srAg8fCxyONOIk6oX50n	25116.00	succeeded	usd	{"id":"pi_3QKZEjAg8fCxyONO1kyS1y50","object":"payment_intent","amount":2511600,"amount_capturable":0,"amount_details":{"tip":{}},"amount_received":2511600,"application":null,"application_fee_amount":null,"automatic_payment_methods":{"allow_redirects":"always","enabled":true},"canceled_at":null,"cancellation_reason":null,"capture_method":"automatic_async","client_secret":"pi_3QKZEjAg8fCxyONO1kyS1y50_secret_RTZPaoAFN1e03atIFbTVTjWux","confirmation_method":"automatic","created":1731476129,"currency":"usd","customer":"cus_R7NUYA1Vlim74b","description":null,"invoice":null,"last_payment_error":null,"latest_charge":"ch_3QKZEjAg8fCxyONO1UgrNxn4","livemode":false,"metadata":{},"next_action":null,"on_behalf_of":null,"payment_method":"pm_1QF8srAg8fCxyONOIk6oX50n","payment_method_configuration_details":null,"payment_method_options":{"card":{"installments":null,"mandate_options":null,"network":null,"request_three_d_secure":"automatic"}},"payment_method_types":["card"],"processing":null,"receipt_email":null,"review":null,"setup_future_usage":null,"shipping":null,"source":null,"statement_descriptor":null,"statement_descriptor_suffix":null,"status":"succeeded","transfer_data":null,"transfer_group":null}	2024-11-13 05:35:31.269	2024-11-13 05:35:31.269
\.


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

COPY public.tbl_permission (id, role_name, is_active, is_delete, deleted_at, inserted_at, updated_at) FROM stdin;
\.


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

COPY public.tbl_product (id, user_id, product_name, weight_type, weight, width_inch, height_inch, depth_inch, description, ingredients, diet_ids, nutrition_ids, shelf_life_id, storage_id, production_ids, allergens_ids, values_ids, sku_no, product_origin, product_price, is_on_sale, retail_resale_price, is_unlimited_stock, is_samples, sample_price, is_sample_unlimited_stock, fulfilment_id, organization_visibility, category_ids, is_publish, is_featured_product, is_active, is_delete, publish_at, deleted_at, inserted_at, updated_at, case_size_quantity, depth, depth_type, height, height_type, shipping_time_id, width, width_type, product_volume, product_volume_type, converted_weight, product_stock, is_allow_custom_quantity_order, sample_stock, fluid_ounces_product_volume) FROM stdin;
3	18	Test Product 45	\N	646.00	20.87	21.26	1666.93	diowd	dfsff	36,37	73	47	65	17	3	78	UF14590750	UK	324.00	f	0.00	f	f	0.00	f	2	public	\N	t	f	t	t	2024-11-12 16:09:44.242	2024-11-12 16:31:45.393	2024-11-12 16:09:45.434	2024-11-13 05:35:34.953	5353	4234.00	cm	54.00	cm	91	53.00	cm	\N	\N	646.00	31	f	\N	\N
4	18	Felix Stone	94	1.00	\N	\N	\N	Duis exercitationem illo necessitatibus excepturi non do qui	Eiusmod odio omnis optio animi obcaecati esse id lorem esse in odio tempora rem	35,38	73,71	52	65	16,18,20	15,4,2	54,55,59	WN54031734	UK	6.53	t	23.55	t	f	0.00	f	8	hidden	\N	t	f	t	f	2024-11-14 11:23:37.99	\N	2024-11-14 11:23:37.992	2024-11-14 11:46:54.456	6	\N	in	\N	in	92	\N	in	\N	103	1.00	0	f	0	\N
5	4	Test product	gm	23.00	8.66	13.39	21.26	Lorem ipsum dolor sit amet consectetur adipiscing elit, morbi lacus rhoncus nibh egestas dictum, lobortis inceptos pulvinar arcu nullam ante.	Lorem ipsum dolor sit amet consectetur adipiscing elit, morbi lacus rhoncus nibh egestas dictum, lobortis inceptos pulvinar arcu nullam ante.	\N	\N	\N	\N	\N	\N	\N	NOM5456425	\N	23.65	t	20.23	f	f	\N	f	\N	hidden	\N	f	f	t	f	\N	\N	2024-11-14 13:06:19.835	2024-11-14 13:14:19.794	12	54.00	cm	34.00	cm	\N	22.00	cm	2.00	fl_oz	0.81	23	f	\N	0.06
6	18	Test Product 45	94	342.00	42.00	54.00	423.00	fsfrw	fwrw	35	73	48	65	18	4	78	PZ28165446	UK	42.00	f	0.00	f	f	0.00	f	8	public	\N	t	f	t	f	2024-11-14 13:51:50.895	\N	2024-11-14 13:51:50.898	2024-11-14 13:51:50.898	895	423.00	\N	54.00	\N	90	42.00	\N	\N	103	342.00	2424	f	\N	\N
2	18	Coca Cola	\N	1000.00	138.98	13.78	18.11	Demo	No 	38	70	49	65	17	3	54	CP15694540	UK	24525.00	f	0.00	f	f	0.00	f	2	public	\N	t	f	t	f	2024-11-13 04:45:58.776	\N	2024-11-12 15:54:22.796	2024-11-14 17:29:02.828	3124	46.00	cm	35.00	cm	90	353.00	cm	\N	\N	1000.00	5352	f	0	\N
1	4	Coca Cola	\N	15.00	206.30	9.45	9.84	No Description	No Ingredients	36	72	49	63	17	4,2	78	HD199355299	UK	450.00	f	0.00	f	f	0.00	f	1	hidden	\N	t	f	t	f	2024-11-13 19:38:01.807	\N	2024-11-12 15:30:18.689	2024-11-13 19:38:01.81	3536	25.00	cm	24.00	cm	90	524.00	cm	\N	\N	15.00	42	f	0	\N
\.


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

COPY public.tbl_product_category (id, product_id, category_id, sub_category_id, sub_child_category_id, is_active, inserted_at, updated_at) FROM stdin;
3	3	1	6	12	t	2024-11-12 16:09:47.962	2024-11-12 16:09:47.962
6	2	1	9	30	t	2024-11-13 09:30:28.769	2024-11-13 09:30:28.769
10	1	1	9	33	t	2024-11-13 13:13:51.811	2024-11-13 13:13:51.811
11	6	1	9	33	t	2024-11-14 13:51:50.99	2024-11-14 13:51:50.99
\.


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

COPY public.tbl_product_images (id, product_id, image, is_thumbnail, is_active, inserted_at, updated_at, is_image_link) FROM stdin;
2	1	product_image_896977617_new-brands-1.png	f	t	2024-11-12 15:30:18.842	2024-11-12 15:30:18.842	f
3	1	product_image_937012684_noti-img.png	f	t	2024-11-12 15:30:18.842	2024-11-12 15:30:18.842	f
5	2	product_image_977806803_product.png	f	t	2024-11-12 15:54:22.968	2024-11-12 15:54:22.968	f
6	2	product_image_641576622_product-2.png	f	t	2024-11-12 15:54:22.968	2024-11-12 15:54:22.968	f
7	3	product_image_877111479_blog-4.png	t	t	2024-11-12 16:09:48.593	2024-11-12 16:09:48.593	f
4	2	product_image_590678578_product-1.png	t	t	2024-11-12 15:54:22.968	2024-11-13 09:30:28.808	f
1	1	product_image_74962866_new-brands-3.png	t	t	2024-11-12 15:30:18.842	2024-11-13 13:13:51.822	f
8	4	product_image_466104292_Group 888.png	t	t	2024-11-14 11:23:38.075	2024-11-14 11:24:30.914	f
9	5	https://dummyimage.com/480&text=400x250	t	t	2024-11-14 13:06:21.473	2024-11-14 13:06:21.473	t
10	5	https://res.cloudinary.com/demo/image/upload/v1312461204/sample.jpg	f	t	2024-11-14 13:06:21.473	2024-11-14 13:06:21.473	t
11	5	https://www.pakainfo.com/wp-content/uploads/2021/09/image-url-for-testing-300x198.jpg	f	t	2024-11-14 13:06:21.473	2024-11-14 13:06:21.473	t
\.


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

COPY public.tbl_product_volume (id, product_id, value, unit_type, is_active, inserted_at, updated_at) FROM stdin;
1	3	10439.45	ml	t	2024-11-12 16:09:46.404	2024-11-12 16:09:46.404
2	3	10.44	l	t	2024-11-12 16:09:46.404	2024-11-12 16:09:46.404
3	3	353.00	fl_oz	t	2024-11-12 16:09:46.404	2024-11-12 16:09:46.404
4	3	22.06	pt	t	2024-11-12 16:09:46.404	2024-11-12 16:09:46.404
5	3	11.03	qt	t	2024-11-12 16:09:46.404	2024-11-12 16:09:46.404
6	3	2.76	gal	t	2024-11-12 16:09:46.404	2024-11-12 16:09:46.404
7	2	1330.81	ml	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
8	2	1.33	l	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
9	2	45.00	fl_oz	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
10	2	2.81	pt	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
11	2	1.41	qt	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
12	2	0.35	gal	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
19	1	10.06	ml	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
20	1	0.01	l	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
21	1	0.34	fl_oz	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
22	1	0.02	pt	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
23	1	0.01	qt	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
24	1	0.00	gal	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
31	4	29.57	ml	t	2024-11-14 11:24:30.879	2024-11-14 11:24:30.879
32	4	0.03	l	t	2024-11-14 11:24:30.879	2024-11-14 11:24:30.879
33	4	1.00	fl_oz	t	2024-11-14 11:24:30.879	2024-11-14 11:24:30.879
34	4	0.06	pt	t	2024-11-14 11:24:30.879	2024-11-14 11:24:30.879
35	4	0.03	qt	t	2024-11-14 11:24:30.879	2024-11-14 11:24:30.879
36	4	0.01	gal	t	2024-11-14 11:24:30.879	2024-11-14 11:24:30.879
37	6	1242.09	ml	t	2024-11-14 13:51:50.961	2024-11-14 13:51:50.961
38	6	1.24	l	t	2024-11-14 13:51:50.961	2024-11-14 13:51:50.961
39	6	42.00	fl_oz	t	2024-11-14 13:51:50.961	2024-11-14 13:51:50.961
40	6	2.63	pt	t	2024-11-14 13:51:50.961	2024-11-14 13:51:50.961
41	6	1.31	qt	t	2024-11-14 13:51:50.961	2024-11-14 13:51:50.961
42	6	0.33	gal	t	2024-11-14 13:51:50.961	2024-11-14 13:51:50.961
\.


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

COPY public.tbl_product_weight (id, product_id, value, unit_type, is_active, inserted_at, updated_at) FROM stdin;
1	3	646000.00	mg	t	2024-11-12 16:09:45.774	2024-11-12 16:09:45.774
2	3	646.00	g	t	2024-11-12 16:09:45.774	2024-11-12 16:09:45.774
3	3	0.65	kg	t	2024-11-12 16:09:45.774	2024-11-12 16:09:45.774
4	3	0.00	t	t	2024-11-12 16:09:45.774	2024-11-12 16:09:45.774
5	3	22.79	oz	t	2024-11-12 16:09:45.774	2024-11-12 16:09:45.774
6	3	1.42	lb	t	2024-11-12 16:09:45.774	2024-11-12 16:09:45.774
7	3	0.10	st	t	2024-11-12 16:09:45.774	2024-11-12 16:09:45.774
8	3	0.00	mt	t	2024-11-12 16:09:45.774	2024-11-12 16:09:45.774
9	2	1000000.00	mg	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
10	2	1000.00	g	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
11	2	1.00	kg	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
12	2	0.00	t	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
13	2	35.27	oz	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
14	2	2.21	lb	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
15	2	0.16	st	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
16	2	0.00	mt	t	2024-11-13 07:15:44.269	2024-11-13 07:15:44.269
33	1	15.00	mg	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
34	1	0.02	g	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
35	1	0.00	kg	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
36	1	0.00	t	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
37	1	0.00	oz	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
38	1	0.00	lb	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
39	1	0.00	st	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
40	1	0.00	mt	t	2024-11-13 13:13:51.754	2024-11-13 13:13:51.754
41	4	1000.00	mg	t	2024-11-14 11:23:38.026	2024-11-14 11:23:38.026
42	4	1.00	g	t	2024-11-14 11:23:38.026	2024-11-14 11:23:38.026
43	4	0.00	kg	t	2024-11-14 11:23:38.026	2024-11-14 11:23:38.026
44	4	0.00	t	t	2024-11-14 11:23:38.026	2024-11-14 11:23:38.026
45	4	0.04	oz	t	2024-11-14 11:23:38.026	2024-11-14 11:23:38.026
46	4	0.00	lb	t	2024-11-14 11:23:38.026	2024-11-14 11:23:38.026
47	4	0.00	st	t	2024-11-14 11:23:38.026	2024-11-14 11:23:38.026
48	4	0.00	mt	t	2024-11-14 11:23:38.026	2024-11-14 11:23:38.026
49	6	342000.00	mg	t	2024-11-14 13:51:50.944	2024-11-14 13:51:50.944
50	6	342.00	g	t	2024-11-14 13:51:50.944	2024-11-14 13:51:50.944
51	6	0.34	kg	t	2024-11-14 13:51:50.944	2024-11-14 13:51:50.944
52	6	0.00	t	t	2024-11-14 13:51:50.944	2024-11-14 13:51:50.944
53	6	12.06	oz	t	2024-11-14 13:51:50.944	2024-11-14 13:51:50.944
54	6	0.75	lb	t	2024-11-14 13:51:50.944	2024-11-14 13:51:50.944
55	6	0.05	st	t	2024-11-14 13:51:50.944	2024-11-14 13:51:50.944
56	6	0.00	mt	t	2024-11-14 13:51:50.944	2024-11-14 13:51:50.944
\.


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

COPY public.tbl_user (id, reseller_id, parent_id, first_name, last_name, email, password, country_code, mobile_number, profile_image, type, business_name, business_email, type_of_store_id, address, city, country, country_id, zip_code, wholesale_accounts_products, wholesale_products, website, minimum_order_amount_currency, minimum_order_amount, category_in_stock, note, here_about_us_id, otp, otp_expiry, forgoted_at, is_offering_subscription, is_individual_updates_for_order, is_daily_summary_reminder_for_order, is_email_reminder_for_messages, is_email_reminder_for_payment, is_email_reminder_for_new_features, is_email_reminder_for_trending_products, is_account_reviewed_by_admin, is_verify, is_active, is_delete, verified_at, deleted_at, inserted_at, updated_at, is_online, logined_at, about, annual_sales_id, business_profile_banner_image, business_profile_image, company_values_ids, founding_year, instagram_account, lead_time_id, linkedin_account, located_in_id, number_of_locations, profile_banner_image, shipping_fee, shipping_fee_currency, year_in_business, permission_id, role, is_offering_samples, free_shipping_order_amount, is_free_shipping, is_max_samples_requested, samples_max_quantity_order_amount, flat_rate_shipping_fee_for_samples_order, stripe_customer_id) FROM stdin;
6	0	0	sara	cha	mlle.sara@hotmail.co.uk	$2a$10$JwKMc/MwPY./2lAEEmcJaud8pijl0UKEX.Iq.BIucL7saNFSIOGG.	+44	07711409971		seller	Nom	mlle.sara@Hotmail.co.uk	\N	9 riverdale	london	United Kingdom	230	839393	2	99	www.nom.com		89.00	3,1		67		2024-09-23 18:04:42	\N	t	f	f	f	f	f	f	f	t	t	t	2024-09-23 18:04:12.548	2024-10-02 15:27:00.56	2024-09-23 18:03:42.222	2024-10-02 15:27:00.561	t	2024-09-23 18:03:42.221		\N						\N		\N	0		\N			\N		t	0.00	f	f	1	0.00	
7	0	0	Sara	cha	sarachalhoub@icloud.com	$2a$10$pU6IiJxnN7kulb5JyBvvPu3A03LlVhPBaidcsV5g3rE3eh8q.qOrm	+93	88888888		buyer	nom		66	9 iririr	london	United Kingdom	230	1234	0	0	www.nom.com		\N	3		67		2024-09-23 18:09:40	\N	f	f	f	f	f	f	f	t	t	t	t	2024-09-23 18:09:00.467	2024-10-02 15:27:09.29	2024-09-23 18:08:40.108	2024-10-02 15:27:09.293	t	2024-09-23 18:08:40.106		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
5	0	0	ssss	sss	shsh@hotmail.com	$2a$10$jdi8Bq8Q.5ZE6mBh22/M4OKx9nry.rMRhlaDhJJ.G5RCZE4aOYD0K	+93	093939393939		seller			\N				\N		0	0			\N			\N	1234	2024-09-23 18:03:53	\N	f	f	f	f	f	f	f	f	f	t	t	\N	2024-10-02 15:26:17.137	2024-09-23 18:02:52.591	2024-10-02 15:26:17.138	t	2024-09-23 18:02:52.59		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
10	0	0	Sara	cha	buyernom@yopmail.com	$2a$10$SpKnBhv69EbA0.b157nowO43Z/ZFMMiruCqJVs4nMZfRLheqipBFq	+93	999992929292		buyer	Nom buyer		66	Nom buyer	Nom buyer	India	101	34532	0	0			\N	1,3		67		2024-10-16 07:41:41	\N	f	f	f	f	f	f	f	t	t	t	f	2024-10-16 07:40:55.497	\N	2024-10-01 14:34:51.56	2024-10-16 07:46:35.36	f	2024-10-16 07:41:48.849		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
2	1	0	Tirth	Gaudani	tirth.gaudani1@yopmail.com	$2a$10$uiimi0Nk8OBo8/Ed88i6CuRqCEjAtzg6G10MM0mNI0OTOc2UiEsqe	+93	121212122	profile_image_321002183_pexels-pixabay-33045.jpg	buyer	Test	tirth.gaudani1@yopmail.com	1	64, laxmi society near cenal opp kavya new naroda	Ahmedabad	India	91	382350	0	0	google.com	usd	45.00	1,5,6,8,7		67		2024-09-20 13:09:40	\N	f	f	f	f	f	f	f	t	t	t	f	2024-09-20 13:08:45.862	\N	2024-09-20 13:08:39.614	2024-10-30 10:16:40.002	f	2024-10-14 05:40:39.004	testtesttest	1	profile_image_71487252_pexels-ahmedadly-1270184.jpg	profile_image_810593385_pexels-mccutcheon-1148998.jpg	1,2,3,4	2020	testaccount	1	testaccount	1	5	profile_image_46913988_pexels-pixabay-36762.jpg	4.00	usd	4	\N		f	0.00	f	f	1	0.00	
9	0	0	Sara	cha	mlle.hot@hotmail.com	$2a$10$l1o8avNDS0FFWnHUft903uU4LWUAyCqdjy5ahNLew07HpHUnaLaea	+93	88888888888		seller			\N				\N		0	0			\N			\N	1234	2024-10-01 14:33:19	\N	f	f	f	f	f	f	f	f	f	t	t	\N	2024-10-02 15:26:00.496	2024-10-01 14:32:19.429	2024-10-02 15:26:00.497	t	2024-10-01 14:32:19.426		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
8	0	0	Sara	cha	sararticles@gmail.com	$2a$10$QEWGYnKTDSx3uqqL9azkbeP3izS5KA/HrspHw9m6k8uARt0beTjRa	+93	7711409971		seller			\N				\N		0	0			\N			\N	1234	2024-10-01 14:28:19	\N	f	f	f	f	f	f	f	f	f	t	t	\N	2024-10-02 15:26:47.115	2024-10-01 14:27:18.766	2024-10-02 15:26:47.117	t	2024-10-01 14:27:18.762		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
14	0	0	Bhavna	Rawat	bhavna@yopmail.com	$2a$10$CmNUYn2Pk57nkDlGKf4qN.Gi9nSXQIZC/6Hnq4tXpTRoAyjo1Ejym	+93	1234567890		seller	Test	test@yopmail.com	\N	test	Ahmedabad	India	101	123456	10	10			100.00	3		67		2024-10-03 09:40:44	\N	f	f	f	f	f	f	f	f	t	t	f	2024-10-03 09:40:14.457	\N	2024-10-03 09:39:43.884	2024-10-03 09:41:25.246	t	2024-10-03 09:39:43.882		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
21	0	0	ROGER	ROGER	ROGER@HOTMAIL.COM	$2a$10$VWsla418nDVENRiFy1gDRubaIkB8TcfqOmXt3S1PHaldPSscMgByq	+93	879789787		buyer			\N				\N		0	0			\N			\N		2024-10-14 17:14:02	\N	f	f	f	f	f	f	f	f	t	t	t	2024-10-14 17:13:06.047	2024-10-14 17:13:28.169	2024-10-14 17:13:01.662	2024-10-14 17:13:28.172	t	2024-10-14 17:13:01.659		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
17	0	0	asfdasd	asfdasd	tirth.gaudani@yopmail.com	$2a$10$CAmks3V6t5DZMx4J5BYSUeYMoVfp/gpkSTdeWUhc0thDNODGsB2Zu	+91	7600753011		buyer			\N				\N		0	0			\N			\N		2024-10-09 06:40:19	\N	f	f	f	f	f	f	f	f	t	t	f	2024-10-09 06:40:12.275	\N	2024-10-09 06:39:19.836	2024-10-30 10:16:27.829	t	2024-10-09 06:39:18.772		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
20	0	0	Emma	cha	emma@yopmail.co.uk	$2a$10$dIq34KXC5gihJO5yLwcn3.shOCtL8T0Q6S64VZ4OKhIbjqk3dDzfS	+93	888888888		buyer	xx		68	xx	xx	United Kingdom	230	xxxxx	0	0	www.xxx.com		\N	5,3,1		69		2024-10-14 17:10:55	\N	f	f	f	f	f	f	f	f	t	t	f	2024-10-14 17:10:03.077	\N	2024-10-14 17:09:54.578	2024-10-14 17:11:58.309	t	2024-10-14 17:09:54.577		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
25	0	0	Bevis	Park	pobakevy@mailinator.com	$2a$10$mwCof5DpVe3xk8k7bSQPyujrOOXOJdNVnitRaEi1SGZGuytQEIqlK	+355	54154154154		buyer	Ivan Juarez		66	Mollit veritatis qui	Deleniti non cum qui	India	101	39130	0	0	https://www.vapygybygaruzi.org.uk		\N	4,2		67		2024-10-16 07:53:17	\N	f	f	f	f	f	f	f	t	t	t	f	2024-10-16 07:52:23.957	\N	2024-10-16 07:52:17.972	2024-10-16 07:52:47.771	t	2024-10-16 07:52:16.927		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
26	0	0	Taylor	Howell	caxiha@mailinator.com	$2a$10$MrRaEMkyqZ4u6cHIpe1VTeaem05eg2rXHuAhPc8ghIzWyx3YHc1Ee	+93	6565655454		buyer	Karly Austin		66	Voluptate sit ut ad 	Rerum rerum ex molli	India	101	15073	0	0	https://www.caweloxiwavyr.me		\N	1,3		67		2024-10-16 07:55:14	\N	f	f	f	f	f	f	f	t	t	t	f	2024-10-16 07:54:21.21	\N	2024-10-16 07:54:15.021	2024-10-16 07:54:39.983	t	2024-10-16 07:54:13.976		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
27	0	0	Dean	Wong	ducygusyc@mailinator.com	$2a$10$RUMbjce.ZcLDk9KdWP4i3OzFbErh5d2E4gKWwJy3HAsMfM0bfq5v2	+376	4545455485		buyer	Lavinia Ray		66	Nihil consectetur e	Dolores voluptate ex	Algeria	3	98711	0	0	https://www.nubijavuvulufe.com.au		\N	1,3		67		2024-10-16 07:57:08	\N	f	f	f	f	f	f	f	t	t	t	f	2024-10-16 07:56:14.923	\N	2024-10-16 07:56:08.968	2024-10-30 10:16:10.202	t	2024-10-16 07:56:07.972		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
3	0	0	Bhavna	Rawat	bhavna.nyusoft@gmail.com	$2a$10$a/utrOw9SqOMc.R6MDzYZ.1tBR2xZmXdffaaKrXPv6wSM6rFr.rqm	+91	8980117914		buyer	Bhavna		66	123	Ahmedabad	India	101	12345	0	0	https://wearenom.nyusoft.in/		\N	5		67		2024-10-11 11:02:59	\N	f	f	f	f	f	f	f	t	t	t	f	2024-09-20 16:28:22.186	\N	2024-09-20 16:27:58.443	2024-11-12 07:35:22.34	t	2024-11-12 07:35:22.338		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
16	0	0	Sara	cha	sara@yopmail.com	$2a$10$x53K3yDlgOOR.dhKQgHK.OdlDmeeoFe9.s/JJEZJGRp7c2KFO1CBC	+93	44444444444		buyer			\N				\N		0	0			\N			\N	1234	2024-10-03 12:10:19	\N	f	f	f	f	f	f	f	f	f	t	f	\N	\N	2024-10-03 12:09:19.279	2024-10-30 10:16:14.336	t	2024-10-03 12:09:19.276		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
4	0	0	Seller	Seller	nomseller@yopmail.com	$2a$10$7WRZR5haMk4ygrcpaM6to.aoCIU7vO7chEfVHvpbrZQNsQZG0YUWm	+91	548548455		seller	Seller Business Name		\N	Seller Address	Seller City	Afghanistan	1	234244	5	28		£	55.00	4,1,2,3		67		2024-09-23 07:14:28	\N	t	f	f	f	f	f	f	t	t	t	f	2024-09-23 07:13:32.477	\N	2024-10-20 07:13:28.092	2024-11-14 10:22:43.869	t	2024-11-14 10:22:43.867		\N						\N		\N	0		\N			\N		t	55.00	t	t	10	5.00	
23	0	0	Buyer	Buyer	nombuyer@yopmail.com	$2a$10$JGc9B0o5Eo85wvQ572Psue4VXS8rI7raqGHXOsDCo2m2bMmpDWnWq	+93	654848484848	profile_image_321002183_pexels-pixabay-33045.jpg	buyer	Buyer		66	asdasd	adad	India	101	234422	0	0			\N	1,3,4,2		67		2024-10-15 07:48:54	\N	f	f	f	f	f	f	f	t	t	t	f	2024-10-15 07:47:59.017	\N	2024-10-15 07:47:53.614	2024-11-13 05:09:38.263	t	2024-11-13 05:09:38.261		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	cus_R7NUYA1Vlim74b
28	0	0	Dora	Faulkner	misuxoqot@mailinator.com	$2a$10$bfj3uRr.A2KSmyRxGiLVNOjJLQQmR0sVS0ayPlu2Leye4c2i4obpe	+1684	6956845844		buyer	Clayton Boyer		66	Nesciunt ut magni v	Magni aut voluptate 	Algeria	3	65676	0	0	https://www.jynoqihimy.cc		\N	1,3		67		2024-10-16 07:58:22	\N	f	f	f	f	f	f	f	t	t	t	f	2024-10-16 07:57:29.576	\N	2024-10-16 07:57:23.044	2024-10-16 07:57:50.806	t	2024-10-16 07:57:22.053		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
33	0	0	Roger	Roger	roger@yopmail.com	$2a$10$YwwUngx2g8GVd4bSDUHIp.9hTGVFbD.4cNmrIF3ijX5bpPl/YKGla	+93	007711409999		buyer			\N				\N		0	0			\N			\N	1234	2024-10-30 13:43:06	\N	f	f	f	f	f	f	f	f	f	t	f	\N	\N	2024-10-30 13:41:29.599	2024-10-30 13:42:05.631	t	2024-10-30 13:42:04.228		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
31	0	0	Jalish	Chauhan	jalishchauhan06@gmail.com	$2a$10$s6U2XYy14aniN.J2a1W2u.UPRRgSxi5uJbg1GqkxT5MV17id5SHJ.	+91	9933442211		seller	Dicot		\N	Ahmedabad	Ahmedabad	India	101	380051	1000	100		£	6000.00	0		67		2024-10-17 10:50:11	\N	f	f	f	f	f	f	f	t	t	t	f	2024-10-17 10:49:15.397	\N	2024-10-17 10:49:10.579	2024-10-21 05:35:39.435	t	2024-10-21 05:35:39.433		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
29	0	0	Nash	Langley	suzysazef@mailinator.com	$2a$10$ckIyNYE/wiVE9a.H3zuaE.Yufn4WZoUFwBr0mdBQ7xqzXWrG7Zh9G	+213	656459454		buyer	Shoshana Cervantes		66	Non necessitatibus i	Natus fuga Ipsum of	India	101	12397	0	0	https://www.cocymonydy.cc		\N	2,5		67		2024-10-16 08:02:34	\N	f	f	f	f	f	f	f	t	t	t	f	2024-10-16 08:01:50.619	\N	2024-10-16 08:01:35.415	2024-10-16 08:35:43.488	t	2024-10-16 08:35:43.486		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
32	0	0	Hemal	Joshi	hemaljoshi738@gmail.com	$2a$10$2yzMigrk4YgtWPHKoS7Fy.ZVuXlY.hN3Z5UIbv26OzKvRNsvwL/hC	+93	7383890133		seller			\N				\N		0	0			\N			\N		2024-10-23 15:14:01	\N	f	f	f	f	f	f	f	f	t	t	f	2024-10-23 15:13:24.477	\N	2024-10-23 15:13:01.483	2024-10-23 15:13:24.479	t	2024-10-23 15:13:01.481		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
18	0	0	Seller	sdvf	nomseller1@yopmail.com	$2a$10$7WRZR5haMk4ygrcpaM6to.aoCIU7vO7chEfVHvpbrZQNsQZG0YUWm	+91	6541651024	profile_image_321002183_pexels-pixabay-33045.jpg	seller	Test seller		68	sd	asd	India	101	78557	0	0			300.00	1,3,4,2		67		2024-10-11 11:45:02	\N	f	f	f	f	f	f	f	t	t	t	f	2024-10-11 11:44:08.099	\N	2024-10-11 11:44:01.747	2024-11-14 15:57:58.702	f	2024-11-14 15:56:39.742		\N	profile_image_321002183_pexels-pixabay-33045.jpg	profile_image_321002183_pexels-pixabay-33045.jpg				\N		\N	0		\N			\N		f	1.00	t	t	4242	0.00	
1	0	0	asfdasd	asfdasd	tirth.gaudani@nyusoft.com	$2a$10$.U3K6QsQR3H4HcqhVnF2fel.L0jC9ZE.8Z.WGV9XN1UrYIyg5FtCC	+91	7600753012		buyer	demo		68	4, gota	ahmedabad	India	101	380001	0	0	https://ex.com		\N	5		67	1234	2024-11-05 17:37:45	\N	f	f	f	f	f	f	f	t	t	t	f	2024-09-20 12:49:13.961	2024-09-23 11:04:46.145	2024-09-20 12:48:08.666	2024-11-14 15:58:07.205	t	2024-11-14 15:58:07.203		\N						\N		\N	0		\N			\N		f	0.00	f	f	1	0.00	
\.


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

COPY public.tbl_user_address (id, user_id, first_name, last_name, address, city, country, country_id, zip_code, country_code, mobile_number, vat_number, is_dont_have_vat_number, is_default, is_active, is_delete, deleted_at, inserted_at, updated_at) FROM stdin;
2	23	Test	second	5, sdafds gsdg sdf sdfsdf sdf	Ahmedabad	India	101	382350	+91	6556265353		f	f	t	f	\N	2024-10-23 08:14:03.814	2024-10-23 09:03:31.323
1	23	Test	First	65, asdasdasd sasdas ssa sassa	Ahmedabad	India	101	382350	+91	2545457478		t	t	t	f	\N	2024-10-23 08:12:58.858	2024-10-23 09:13:41.737
3	1	TestDummy	First	65, asdasdasd sasdas ssa sassa	Ahmedabad	India	101	382350	+91	2545457478		t	t	t	f	\N	2024-10-24 15:40:33.421	2024-10-24 15:41:32.872
\.


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

COPY public.tbl_user_device (id, user_id, uuid, token, token_expiry, inserted_at, updated_at) FROM stdin;
3	4	44b76c61-ee35-4237-8bfe-20df7f059dc7	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6NCwidXNlcl90eXBlIjoic2VsbGVyIn0sImlhdCI6MTczMTQyMzAzN30.8mqGU3H1d_wyOlpDJInWITuMe62nCKR7gVYXSxYzDE0	2024-11-13 14:50:37	2024-11-12 14:50:37.332	2024-11-12 14:50:37.332
4	18	8460e266-52df-4797-9cc8-8dbd1df8225c	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE0MjY0NzJ9.W46FOxBmuicwuasg5KjAZUlKp3dwSe-eMdAFjd2AxyE	2024-11-13 15:47:53	2024-11-12 15:47:52.575	2024-11-12 15:47:52.575
5	18	8540867d-43d1-4791-bc10-01335ba0cd5e	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE0Mjc0MTB9.nLlO22VedobNMCA28EBgoT2yPZ3pPFuiqYzfO5a17O8	2024-11-13 16:03:32	2024-11-12 16:03:31.906	2024-11-12 16:03:31.906
6	18	a63890ff-e0f4-4d43-9020-7b8d155305a7	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE0Mjc2OTF9.OrGsP82y1ognrBktZW6TjGj_rYGmxGK3i089HSk27Sk	2024-11-13 16:08:13	2024-11-12 16:08:12.899	2024-11-12 16:08:12.899
7	18	10319cac-4a82-40cd-9972-2f73d011afb5	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE0Mjc5MTV9.G_o4xDVahkX6dOT3dAJri8Rr36SXHqtP050k-FRwGGA	2024-11-13 16:11:55	2024-11-12 16:11:55.222	2024-11-12 16:11:55.222
8	18	52e3d7fe-22b1-47aa-9108-94cbf11812f0	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE0MjkwODJ9.QkqMoSqfvIlBeAfNwmtX66I3F973yxA98Cg-Q05DvU0	2024-11-13 16:31:22	2024-11-12 16:31:22.153	2024-11-12 16:31:22.153
9	18	6980c28e-d2f2-419f-b548-f1d458f9483a	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE0MzAyOTF9.ga-HmOirRXo3jjkOQ8Gr26uZnZB3Z8v-3kZIGs7hyaU	2024-11-13 16:51:31	2024-11-12 16:51:31.396	2024-11-12 16:51:31.396
11	18	c18cf822-8825-4640-acea-722a52943f53	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE0Mzg1NDB9.XOuMFHyt4uSQAEtawU5kevTj7F8GIHEbvoBXVuQryQc	2024-11-13 19:09:00	2024-11-12 19:09:00.346	2024-11-12 19:09:00.346
12	23	1373d92e-8fab-48a9-862d-b6840bee5e91	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIzMGRheXMiLCJkYXRhIjp7InVzZXJfaWQiOjIzLCJ1c2VyX3R5cGUiOiJidXllciJ9LCJpYXQiOjE3MzE0NzQ1Nzh9.paI0R9Qv6kz8RO4ChPNZq79RmUC-ea6GhVoYze6VHow	2024-12-13 05:09:38	2024-11-13 05:09:38.285	2024-11-13 05:09:38.285
13	4	4e649089-b5fd-4394-9762-c40bc9751114	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIzMGRheXMiLCJkYXRhIjp7InVzZXJfaWQiOjQsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE0NzQ2Nzl9.PcKgbY0CKlstFfAilc6hGQ25LzV-RBgtAIkwq9kADV4	2024-12-13 05:11:19	2024-11-13 05:11:19.297	2024-11-13 05:11:19.297
15	18	e9cd0324-ceae-4443-ab91-73ae172b5caf	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE0ODc0MjB9.cthcIBuTWQGR15gqCegJJD7Lq16_Nvj1iYW32GPgt74	2024-11-14 08:43:41	2024-11-13 08:43:40.656	2024-11-13 08:43:40.656
1	18	123456789	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE0ODc1OTh9.ltqgqk4Md0I6_thoXmrugKFz-CyQjw8atiKV5f6XUO8	2024-11-14 08:46:39	2024-11-12 14:43:40.687	2024-11-13 08:46:38.556
17	4	a253e0bc-619e-4066-87a8-34083fee17c4	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6NCwidXNlcl90eXBlIjoic2VsbGVyIn0sImlhdCI6MTczMTQ5NjU3MX0.jIxO6dYwpq9nxerW7wd1SPBvzRpsvlTXJnx9BlFFG1o	2024-11-14 11:16:12	2024-11-13 11:16:12.004	2024-11-13 11:16:12.004
18	4	19df7633-a117-40f2-bdd9-67c2542ec2b9	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6NCwidXNlcl90eXBlIjoic2VsbGVyIn0sImlhdCI6MTczMTUxMDU3OX0.-5IR8AwD9wdBojn9o3aq7BY6CLoJvBUTlVQ2qxrauGA	2024-11-14 15:09:39	2024-11-13 15:09:39.104	2024-11-13 15:09:39.104
20	18	7c49a3c9-7386-4636-b0d3-faa61ab7ed9c	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE1MTcyNDh9.IipbaJ0j039xT3Az1lv7HOXSNjA_gA2SIOVFoRPr7is	2024-11-14 17:00:49	2024-11-13 17:00:48.914	2024-11-13 17:00:48.914
21	4	a28a9f3c-d017-4755-aa06-94665796c9f7	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6NCwidXNlcl90eXBlIjoic2VsbGVyIn0sImlhdCI6MTczMTUzNDI4NH0.QeqlUnwS22gh2KDlvXzEdXJETNFpf2YEKnkAEl2bP_o	2024-11-14 21:44:45	2024-11-13 21:44:44.519	2024-11-13 21:44:44.519
22	1	9884cb4e-3ded-48b5-b4ab-957c76bd5eb5	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MSwidXNlcl90eXBlIjoiYnV5ZXIifSwiaWF0IjoxNzMxNTYyNTI0fQ.GTeY4VnIW3pM2wCWTUrpOxKM5S62YGRz_i27VW8zbwU	2024-11-15 05:35:25	2024-11-14 05:35:24.578	2024-11-14 05:35:24.578
24	1	76df13ec-2032-4ec3-affd-6b87681bd70c	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MSwidXNlcl90eXBlIjoiYnV5ZXIifSwiaWF0IjoxNzMxNTY0MjAyfQ.4R6i_E6CUduvUMdPnDohmrr-hf0ukPFadXJ5Zv5N4XY	2024-11-15 06:03:23	2024-11-14 06:03:22.565	2024-11-14 06:03:22.565
25	18	cc3e5e0c-2951-4d33-824d-027a89217937	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE1NjgxMDl9.uEEouPCOpp-9ELUiozHilqraanh_-TAfouqOhcScR6c	2024-11-15 07:08:30	2024-11-14 07:08:29.769	2024-11-14 07:08:29.769
26	18	08cdb8cb-b253-4b77-89ac-5cfe4de93ad3	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE1NzA1NzV9.KsUAgasYCh27NrIBEUmNI-lxImoZf7DNXnDvtb6p23k	2024-11-15 07:49:36	2024-11-14 07:49:36.053	2024-11-14 07:49:36.053
27	4	53e0c6bc-2e1f-4abc-a233-62aa467c9be5	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6NCwidXNlcl90eXBlIjoic2VsbGVyIn0sImlhdCI6MTczMTU3OTc2M30.JqTnuRVDzK_BrQhUjPvdKbxI0v9TwcLO8ZbBF8E1zZo	2024-11-15 10:22:44	2024-11-14 10:22:43.991	2024-11-14 10:22:43.991
28	18	522808d9-2f47-4dc7-9eb2-608df2858b49	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE1ODMxNjJ9.pcsWNP_0o_Vbb3BTF7wBwfKHh6-z62Fa_mZwohJRkJ4	2024-11-15 11:19:23	2024-11-14 11:19:22.823	2024-11-14 11:19:22.823
29	1	8500df59-6fda-402a-8c1b-ddd0dcba3215	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MSwidXNlcl90eXBlIjoiYnV5ZXIifSwiaWF0IjoxNzMxNTg5ODA0fQ._whJ5NZXOehAWu6Pa-cBr4L3OEbAAzClKdzsVyiOVBY	2024-11-15 13:10:04	2024-11-14 13:10:04.513	2024-11-14 13:10:04.513
30	1	f8896c14-6a2c-4ca6-8ab9-ea36cf92bfa2	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MSwidXNlcl90eXBlIjoiYnV5ZXIifSwiaWF0IjoxNzMxNTg5ODA0fQ._whJ5NZXOehAWu6Pa-cBr4L3OEbAAzClKdzsVyiOVBY	2024-11-15 13:10:05	2024-11-14 13:10:04.877	2024-11-14 13:10:04.877
31	18	2d1a3032-d119-4848-a16b-332ba2ea6702	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIzMGRheXMiLCJkYXRhIjp7InVzZXJfaWQiOjE4LCJ1c2VyX3R5cGUiOiJzZWxsZXIifSwiaWF0IjoxNzMxNTkxNjk5fQ.ZQ3nILaaGsnanSv-lHXAbK4hUIzBquOVGc87BGsvz50	2024-12-14 13:41:39	2024-11-14 13:41:39.243	2024-11-14 13:41:39.243
2	1	123456789	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MSwidXNlcl90eXBlIjoiYnV5ZXIifSwiaWF0IjoxNzMxNTk5MzA5fQ.vKeQkc0w4WJj_jAe9XPOMxEc8z69cdriMm9HHraqhPY	2024-11-15 15:48:30	2024-11-12 14:44:44.082	2024-11-14 15:48:29.551
32	18	76ad76dd-9427-4457-ba71-0481d5f8ff68	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MTgsInVzZXJfdHlwZSI6InNlbGxlciJ9LCJpYXQiOjE3MzE1OTk3OTF9.vyvAaf7_lPZxf1_3UaEVK4Ap_Dm8y4w5vy5lOtGsSz8	2024-11-15 15:56:31	2024-11-14 15:56:31.303	2024-11-14 15:56:31.303
34	1	54982d0e-1e22-424e-b062-f0c8984da3af	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHBpcmVzSW4iOiIxZGF5cyIsImRhdGEiOnsidXNlcl9pZCI6MSwidXNlcl90eXBlIjoiYnV5ZXIifSwiaWF0IjoxNzMxNTk5ODg3fQ.a4A7i_TaTPjssJ2OY4s22eSZTjH0fZucAIcFopI3eD8	2024-11-15 15:58:07	2024-11-14 15:58:07.216	2024-11-14 15:58:07.216
\.


--
-- Name: country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_admin_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_billing_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_billing_history_id_seq', 1, true);


--
-- Name: tbl_blog_category_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_blog_category_id_seq', 6, true);


--
-- Name: tbl_blog_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_blog_id_seq', 2, true);


--
-- Name: tbl_cart_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_cart_id_seq', 8, true);


--
-- Name: tbl_category_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_chat_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_chat_room_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_cms_page_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_currency_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_customer_order_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_customer_order_id_seq', 2, true);


--
-- Name: tbl_dropdown_list_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_dropdown_list_id_seq', 11, true);


--
-- Name: tbl_favourites_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_fulfilment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_fulfilment_id_seq', 9, true);


--
-- Name: tbl_fulfilment_weight_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_order_carrier_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_order_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_order_id_seq', 2, true);


--
-- Name: tbl_order_item_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_order_item_id_seq', 3, true);


--
-- Name: tbl_payment_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_payment_history_id_seq', 1, true);


--
-- Name: tbl_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_product_category_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_product_category_id_seq', 11, true);


--
-- Name: tbl_product_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_product_id_seq', 6, true);


--
-- Name: tbl_product_images_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_product_images_id_seq', 11, true);


--
-- Name: tbl_product_volume_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_product_volume_id_seq', 42, true);


--
-- Name: tbl_product_weight_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_product_weight_id_seq', 56, true);


--
-- Name: tbl_user_address_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: tbl_user_device_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_user_device_id_seq', 34, true);


--
-- Name: tbl_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.tbl_user_id_seq', 1, true);


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

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


--
-- Name: country country_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.country
    ADD CONSTRAINT country_pkey PRIMARY KEY (id);


--
-- Name: tbl_admin tbl_admin_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_admin
    ADD CONSTRAINT tbl_admin_pkey PRIMARY KEY (id);


--
-- Name: tbl_billing_history tbl_billing_history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_billing_history
    ADD CONSTRAINT tbl_billing_history_pkey PRIMARY KEY (id);


--
-- Name: tbl_blog_category tbl_blog_category_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_blog_category
    ADD CONSTRAINT tbl_blog_category_pkey PRIMARY KEY (id);


--
-- Name: tbl_blog tbl_blog_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_blog
    ADD CONSTRAINT tbl_blog_pkey PRIMARY KEY (id);


--
-- Name: tbl_cart tbl_cart_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_cart
    ADD CONSTRAINT tbl_cart_pkey PRIMARY KEY (id);


--
-- Name: tbl_category tbl_category_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_category
    ADD CONSTRAINT tbl_category_pkey PRIMARY KEY (id);


--
-- Name: tbl_chat tbl_chat_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_chat
    ADD CONSTRAINT tbl_chat_pkey PRIMARY KEY (id);


--
-- Name: tbl_chat_room tbl_chat_room_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_chat_room
    ADD CONSTRAINT tbl_chat_room_pkey PRIMARY KEY (id);


--
-- Name: tbl_cms_page tbl_cms_page_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_cms_page
    ADD CONSTRAINT tbl_cms_page_pkey PRIMARY KEY (id);


--
-- Name: tbl_currency tbl_currency_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_currency
    ADD CONSTRAINT tbl_currency_pkey PRIMARY KEY (id);


--
-- Name: tbl_customer_order tbl_customer_order_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_customer_order
    ADD CONSTRAINT tbl_customer_order_pkey PRIMARY KEY (id);


--
-- Name: tbl_dropdown_list tbl_dropdown_list_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_dropdown_list
    ADD CONSTRAINT tbl_dropdown_list_pkey PRIMARY KEY (id);


--
-- Name: tbl_favourites tbl_favourites_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_favourites
    ADD CONSTRAINT tbl_favourites_pkey PRIMARY KEY (id);


--
-- Name: tbl_fulfilment tbl_fulfilment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_fulfilment
    ADD CONSTRAINT tbl_fulfilment_pkey PRIMARY KEY (id);


--
-- Name: tbl_fulfilment_weight tbl_fulfilment_weight_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_fulfilment_weight
    ADD CONSTRAINT tbl_fulfilment_weight_pkey PRIMARY KEY (id);


--
-- Name: tbl_order_carrier tbl_order_carrier_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order_carrier
    ADD CONSTRAINT tbl_order_carrier_pkey PRIMARY KEY (id);


--
-- Name: tbl_order_item tbl_order_item_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order_item
    ADD CONSTRAINT tbl_order_item_pkey PRIMARY KEY (id);


--
-- Name: tbl_order tbl_order_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order
    ADD CONSTRAINT tbl_order_pkey PRIMARY KEY (id);


--
-- Name: tbl_payment_history tbl_payment_history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_payment_history
    ADD CONSTRAINT tbl_payment_history_pkey PRIMARY KEY (id);


--
-- Name: tbl_permission tbl_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_permission
    ADD CONSTRAINT tbl_permission_pkey PRIMARY KEY (id);


--
-- Name: tbl_product_category tbl_product_category_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_category
    ADD CONSTRAINT tbl_product_category_pkey PRIMARY KEY (id);


--
-- Name: tbl_product_images tbl_product_images_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_images
    ADD CONSTRAINT tbl_product_images_pkey PRIMARY KEY (id);


--
-- Name: tbl_product tbl_product_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product
    ADD CONSTRAINT tbl_product_pkey PRIMARY KEY (id);


--
-- Name: tbl_product_volume tbl_product_volume_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_volume
    ADD CONSTRAINT tbl_product_volume_pkey PRIMARY KEY (id);


--
-- Name: tbl_product_weight tbl_product_weight_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_weight
    ADD CONSTRAINT tbl_product_weight_pkey PRIMARY KEY (id);


--
-- Name: tbl_user_address tbl_user_address_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_user_address
    ADD CONSTRAINT tbl_user_address_pkey PRIMARY KEY (id);


--
-- Name: tbl_user_device tbl_user_device_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_user_device
    ADD CONSTRAINT tbl_user_device_pkey PRIMARY KEY (id);


--
-- Name: tbl_user tbl_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_user
    ADD CONSTRAINT tbl_user_pkey PRIMARY KEY (id);


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

CREATE INDEX country_name_idx ON public.country USING btree (name);


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

CREATE INDEX country_phone_code_idx ON public.country USING btree (phone_code);


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

CREATE INDEX country_short_name_idx ON public.country USING btree (short_name);


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

CREATE INDEX idx_product_volume_product_id ON public.tbl_product_volume USING btree (product_id);


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

CREATE INDEX idx_product_weight_product_id ON public.tbl_product_weight USING btree (product_id);


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

CREATE INDEX tbl_billing_history_currency_idx ON public.tbl_billing_history USING btree (currency);


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

CREATE INDEX tbl_billing_history_invoice_file_name_idx ON public.tbl_billing_history USING btree (invoice_file_name);


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

CREATE INDEX tbl_billing_history_invoice_no_idx ON public.tbl_billing_history USING btree (invoice_no);


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

CREATE INDEX tbl_billing_history_order_ids_idx ON public.tbl_billing_history USING btree (order_ids);


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

CREATE INDEX tbl_billing_history_payment_id_idx ON public.tbl_billing_history USING btree (payment_id);


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

CREATE INDEX tbl_billing_history_status_idx ON public.tbl_billing_history USING btree (status);


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

CREATE INDEX tbl_billing_history_total_amount_idx ON public.tbl_billing_history USING btree (total_amount);


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

CREATE INDEX tbl_billing_history_user_id_idx ON public.tbl_billing_history USING btree (user_id);


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

CREATE INDEX tbl_cart_brand_id_idx ON public.tbl_cart USING btree (brand_id);


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

CREATE INDEX tbl_cart_product_id_idx ON public.tbl_cart USING btree (product_id);


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

CREATE INDEX tbl_cart_user_id_idx ON public.tbl_cart USING btree (user_id);


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

CREATE INDEX tbl_category_category_name_idx ON public.tbl_category USING btree (category_name);


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

CREATE INDEX tbl_category_parent_id_idx ON public.tbl_category USING btree (parent_id);


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

CREATE INDEX tbl_chat_chat_room_id_idx ON public.tbl_chat USING btree (chat_room_id);


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

CREATE INDEX tbl_chat_is_read_idx ON public.tbl_chat USING btree (is_read);


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

CREATE INDEX tbl_chat_message_idx ON public.tbl_chat USING btree (message);


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

CREATE INDEX tbl_chat_message_type_idx ON public.tbl_chat USING btree (message_type);


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

CREATE INDEX tbl_chat_receiver_id_idx ON public.tbl_chat USING btree (receiver_id);


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

CREATE INDEX tbl_chat_room_last_message_at_idx ON public.tbl_chat_room USING btree (last_message_at);


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

CREATE INDEX tbl_chat_room_last_message_idx ON public.tbl_chat_room USING btree (last_message);


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

CREATE INDEX tbl_chat_room_receiver_id_idx ON public.tbl_chat_room USING btree (receiver_id);


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

CREATE INDEX tbl_chat_room_sender_id_idx ON public.tbl_chat_room USING btree (sender_id);


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

CREATE INDEX tbl_chat_sender_id_idx ON public.tbl_chat USING btree (sender_id);


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

CREATE UNIQUE INDEX tbl_cms_page_slug_key ON public.tbl_cms_page USING btree (slug);


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

CREATE INDEX tbl_customer_order_brand_id_idx ON public.tbl_customer_order USING btree (brand_id);


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

CREATE INDEX tbl_customer_order_internal_note_idx ON public.tbl_customer_order USING btree (internal_note);


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

CREATE INDEX tbl_customer_order_is_user_blocked_idx ON public.tbl_customer_order USING btree (is_user_blocked);


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

CREATE INDEX tbl_customer_order_last_order_at_idx ON public.tbl_customer_order USING btree (last_order_at);


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

CREATE INDEX tbl_customer_order_total_idx ON public.tbl_customer_order USING btree (total);


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

CREATE INDEX tbl_customer_order_user_id_idx ON public.tbl_customer_order USING btree (user_id);


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

CREATE INDEX tbl_dropdown_list_name_idx ON public.tbl_dropdown_list USING btree (name);


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

CREATE INDEX tbl_dropdown_list_type_idx ON public.tbl_dropdown_list USING btree (type);


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

CREATE INDEX tbl_favourites_brand_id_idx ON public.tbl_favourites USING btree (brand_id);


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

CREATE INDEX tbl_favourites_product_id_idx ON public.tbl_favourites USING btree (product_id);


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

CREATE INDEX tbl_favourites_user_id_idx ON public.tbl_favourites USING btree (user_id);


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

CREATE INDEX tbl_order_brand_id_idx ON public.tbl_order USING btree (brand_id);


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

CREATE INDEX tbl_order_carrier_carrier_idx ON public.tbl_order_carrier USING btree (carrier);


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

CREATE INDEX tbl_order_carrier_order_id_idx ON public.tbl_order_carrier USING btree (order_id);


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

CREATE INDEX tbl_order_carrier_tracking_number_idx ON public.tbl_order_carrier USING btree (tracking_number);


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

CREATE INDEX tbl_order_item_brand_id_idx ON public.tbl_order_item USING btree (brand_id);


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

CREATE INDEX tbl_order_item_each_product_price_idx ON public.tbl_order_item USING btree (each_product_price);


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

CREATE INDEX tbl_order_item_order_id_idx ON public.tbl_order_item USING btree (order_id);


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

CREATE INDEX tbl_order_item_product_id_idx ON public.tbl_order_item USING btree (product_id);


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

CREATE INDEX tbl_order_item_qty_idx ON public.tbl_order_item USING btree (qty);


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

CREATE INDEX tbl_order_item_total_product_price_idx ON public.tbl_order_item USING btree (total_product_price);


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

CREATE INDEX tbl_order_item_user_id_idx ON public.tbl_order_item USING btree (user_id);


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

CREATE INDEX tbl_order_order_no_idx ON public.tbl_order USING btree (order_no);


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

CREATE INDEX tbl_order_order_status_idx ON public.tbl_order USING btree (order_status);


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

CREATE INDEX tbl_order_order_type_idx ON public.tbl_order USING btree (order_type);


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

CREATE INDEX tbl_order_payment_id_idx ON public.tbl_order USING btree (payment_id);


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

CREATE INDEX tbl_order_payment_status_idx ON public.tbl_order USING btree (payment_status);


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

CREATE INDEX tbl_order_total_idx ON public.tbl_order USING btree (total);


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

CREATE INDEX tbl_order_user_id_idx ON public.tbl_order USING btree (user_id);


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

CREATE INDEX tbl_payment_history_currency_idx ON public.tbl_payment_history USING btree (currency);


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

CREATE INDEX tbl_payment_history_customer_id_idx ON public.tbl_payment_history USING btree (customer_id);


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

CREATE INDEX tbl_payment_history_paid_amount_idx ON public.tbl_payment_history USING btree (paid_amount);


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

CREATE INDEX tbl_payment_history_payment_intent_id_idx ON public.tbl_payment_history USING btree (payment_intent_id);


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

CREATE INDEX tbl_payment_history_payment_method_idx ON public.tbl_payment_history USING btree (payment_method);


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

CREATE INDEX tbl_payment_history_status_idx ON public.tbl_payment_history USING btree (status);


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

CREATE INDEX tbl_payment_history_user_id_idx ON public.tbl_payment_history USING btree (user_id);


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

CREATE INDEX tbl_product_case_size_quantity_idx ON public.tbl_product USING btree (case_size_quantity);


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

CREATE INDEX tbl_product_category_ids_idx ON public.tbl_product USING btree (category_ids);


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

CREATE INDEX tbl_product_description_idx ON public.tbl_product USING btree (description);


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

CREATE INDEX tbl_product_ingredients_idx ON public.tbl_product USING btree (ingredients);


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

CREATE INDEX tbl_product_product_name_idx ON public.tbl_product USING btree (product_name);


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

CREATE INDEX tbl_product_product_price_idx ON public.tbl_product USING btree (product_price);


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

CREATE INDEX tbl_product_product_stock_idx ON public.tbl_product USING btree (product_stock);


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

CREATE INDEX tbl_product_retail_resale_price_idx ON public.tbl_product USING btree (retail_resale_price);


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

CREATE INDEX tbl_product_sample_price_idx ON public.tbl_product USING btree (sample_price);


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

CREATE INDEX tbl_product_sample_stock_idx ON public.tbl_product USING btree (sample_stock);


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

CREATE INDEX tbl_product_user_id_idx ON public.tbl_product USING btree (user_id);


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

CREATE INDEX tbl_user_address_address_idx ON public.tbl_user_address USING btree (address);


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

CREATE INDEX tbl_user_address_city_idx ON public.tbl_user_address USING btree (city);


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

CREATE INDEX tbl_user_address_country_code_idx ON public.tbl_user_address USING btree (country_code);


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

CREATE INDEX tbl_user_address_country_idx ON public.tbl_user_address USING btree (country);


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

CREATE INDEX tbl_user_address_first_name_idx ON public.tbl_user_address USING btree (first_name);


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

CREATE INDEX tbl_user_address_is_default_idx ON public.tbl_user_address USING btree (is_default);


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

CREATE INDEX tbl_user_address_is_dont_have_vat_number_idx ON public.tbl_user_address USING btree (is_dont_have_vat_number);


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

CREATE INDEX tbl_user_address_last_name_idx ON public.tbl_user_address USING btree (last_name);


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

CREATE INDEX tbl_user_address_mobile_number_idx ON public.tbl_user_address USING btree (mobile_number);


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

CREATE INDEX tbl_user_address_user_id_idx ON public.tbl_user_address USING btree (user_id);


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

CREATE INDEX tbl_user_address_vat_number_idx ON public.tbl_user_address USING btree (vat_number);


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

CREATE INDEX tbl_user_address_zip_code_idx ON public.tbl_user_address USING btree (zip_code);


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

CREATE INDEX tbl_user_business_name_idx ON public.tbl_user USING btree (business_name);


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

CREATE INDEX tbl_user_business_profile_banner_image_idx ON public.tbl_user USING btree (business_profile_banner_image);


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

CREATE INDEX tbl_user_business_profile_image_idx ON public.tbl_user USING btree (business_profile_image);


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

CREATE INDEX tbl_user_country_code_idx ON public.tbl_user USING btree (country_code);


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

CREATE INDEX tbl_user_device_token_idx ON public.tbl_user_device USING btree (token);


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

CREATE INDEX tbl_user_device_user_id_idx ON public.tbl_user_device USING btree (user_id);


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

CREATE INDEX tbl_user_email_idx ON public.tbl_user USING btree (email);


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

CREATE UNIQUE INDEX tbl_user_email_key ON public.tbl_user USING btree (email);


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

CREATE INDEX tbl_user_first_name_idx ON public.tbl_user USING btree (first_name);


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

CREATE INDEX tbl_user_last_name_idx ON public.tbl_user USING btree (last_name);


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

CREATE INDEX tbl_user_mobile_number_idx ON public.tbl_user USING btree (mobile_number);


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

CREATE UNIQUE INDEX tbl_user_mobile_number_key ON public.tbl_user USING btree (mobile_number);


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

CREATE INDEX tbl_user_profile_banner_image_idx ON public.tbl_user USING btree (profile_banner_image);


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

CREATE INDEX tbl_user_profile_image_idx ON public.tbl_user USING btree (profile_image);


--
-- Name: tbl_billing_history tbl_billing_history_payment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_billing_history
    ADD CONSTRAINT tbl_billing_history_payment_id_fkey FOREIGN KEY (payment_id) REFERENCES public.tbl_payment_history(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_billing_history tbl_billing_history_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_billing_history
    ADD CONSTRAINT tbl_billing_history_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_blog tbl_blog_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_blog
    ADD CONSTRAINT tbl_blog_category_id_fkey FOREIGN KEY (category_id) REFERENCES public.tbl_blog_category(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_cart tbl_cart_brand_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_cart
    ADD CONSTRAINT tbl_cart_brand_id_fkey FOREIGN KEY (brand_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_cart tbl_cart_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_cart
    ADD CONSTRAINT tbl_cart_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.tbl_product(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_cart tbl_cart_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_cart
    ADD CONSTRAINT tbl_cart_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_chat tbl_chat_chat_room_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_chat
    ADD CONSTRAINT tbl_chat_chat_room_id_fkey FOREIGN KEY (chat_room_id) REFERENCES public.tbl_chat_room(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_chat tbl_chat_receiver_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_chat
    ADD CONSTRAINT tbl_chat_receiver_id_fkey FOREIGN KEY (receiver_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_chat_room tbl_chat_room_receiver_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_chat_room
    ADD CONSTRAINT tbl_chat_room_receiver_id_fkey FOREIGN KEY (receiver_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_chat_room tbl_chat_room_sender_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_chat_room
    ADD CONSTRAINT tbl_chat_room_sender_id_fkey FOREIGN KEY (sender_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_chat tbl_chat_sender_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_chat
    ADD CONSTRAINT tbl_chat_sender_id_fkey FOREIGN KEY (sender_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_customer_order tbl_customer_order_brand_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_customer_order
    ADD CONSTRAINT tbl_customer_order_brand_id_fkey FOREIGN KEY (brand_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_customer_order tbl_customer_order_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_customer_order
    ADD CONSTRAINT tbl_customer_order_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_favourites tbl_favourites_brand_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_favourites
    ADD CONSTRAINT tbl_favourites_brand_id_fkey FOREIGN KEY (brand_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_favourites tbl_favourites_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_favourites
    ADD CONSTRAINT tbl_favourites_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.tbl_product(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_favourites tbl_favourites_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_favourites
    ADD CONSTRAINT tbl_favourites_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_fulfilment tbl_fulfilment_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_fulfilment
    ADD CONSTRAINT tbl_fulfilment_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_fulfilment_weight tbl_fulfilment_weight_fulfilment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_fulfilment_weight
    ADD CONSTRAINT tbl_fulfilment_weight_fulfilment_id_fkey FOREIGN KEY (fulfilment_id) REFERENCES public.tbl_fulfilment(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_order tbl_order_address_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order
    ADD CONSTRAINT tbl_order_address_id_fkey FOREIGN KEY (address_id) REFERENCES public.tbl_user_address(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_order tbl_order_brand_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order
    ADD CONSTRAINT tbl_order_brand_id_fkey FOREIGN KEY (brand_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_order_carrier tbl_order_carrier_order_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order_carrier
    ADD CONSTRAINT tbl_order_carrier_order_id_fkey FOREIGN KEY (order_id) REFERENCES public.tbl_order(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_order_item tbl_order_item_brand_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order_item
    ADD CONSTRAINT tbl_order_item_brand_id_fkey FOREIGN KEY (brand_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_order_item tbl_order_item_order_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order_item
    ADD CONSTRAINT tbl_order_item_order_id_fkey FOREIGN KEY (order_id) REFERENCES public.tbl_order(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_order_item tbl_order_item_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order_item
    ADD CONSTRAINT tbl_order_item_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.tbl_product(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_order_item tbl_order_item_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order_item
    ADD CONSTRAINT tbl_order_item_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_order tbl_order_payment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order
    ADD CONSTRAINT tbl_order_payment_id_fkey FOREIGN KEY (payment_id) REFERENCES public.tbl_payment_history(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_order tbl_order_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_order
    ADD CONSTRAINT tbl_order_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_payment_history tbl_payment_history_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_payment_history
    ADD CONSTRAINT tbl_payment_history_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_product_category tbl_product_category_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_category
    ADD CONSTRAINT tbl_product_category_category_id_fkey FOREIGN KEY (category_id) REFERENCES public.tbl_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_product_category tbl_product_category_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_category
    ADD CONSTRAINT tbl_product_category_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.tbl_product(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_product_category tbl_product_category_sub_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_category
    ADD CONSTRAINT tbl_product_category_sub_category_id_fkey FOREIGN KEY (sub_category_id) REFERENCES public.tbl_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_product_category tbl_product_category_sub_child_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_category
    ADD CONSTRAINT tbl_product_category_sub_child_category_id_fkey FOREIGN KEY (sub_child_category_id) REFERENCES public.tbl_category(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tbl_product tbl_product_fulfilment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product
    ADD CONSTRAINT tbl_product_fulfilment_id_fkey FOREIGN KEY (fulfilment_id) REFERENCES public.tbl_fulfilment(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_product_images tbl_product_images_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_images
    ADD CONSTRAINT tbl_product_images_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.tbl_product(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_product tbl_product_shelf_life_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product
    ADD CONSTRAINT tbl_product_shelf_life_id_fkey FOREIGN KEY (shelf_life_id) REFERENCES public.tbl_dropdown_list(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_product tbl_product_shipping_time_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product
    ADD CONSTRAINT tbl_product_shipping_time_id_fkey FOREIGN KEY (shipping_time_id) REFERENCES public.tbl_dropdown_list(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_product tbl_product_storage_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product
    ADD CONSTRAINT tbl_product_storage_id_fkey FOREIGN KEY (storage_id) REFERENCES public.tbl_dropdown_list(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_product tbl_product_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product
    ADD CONSTRAINT tbl_product_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: tbl_product_volume tbl_product_volume_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_volume
    ADD CONSTRAINT tbl_product_volume_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.tbl_product(id) ON DELETE CASCADE;


--
-- Name: tbl_product_weight tbl_product_weight_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_product_weight
    ADD CONSTRAINT tbl_product_weight_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.tbl_product(id) ON DELETE CASCADE;


--
-- Name: tbl_user_address tbl_user_address_country_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_user_address
    ADD CONSTRAINT tbl_user_address_country_id_fkey FOREIGN KEY (country_id) REFERENCES public.country(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_user_address tbl_user_address_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_user_address
    ADD CONSTRAINT tbl_user_address_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_user tbl_user_country_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_user
    ADD CONSTRAINT tbl_user_country_id_fkey FOREIGN KEY (country_id) REFERENCES public.country(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_user_device tbl_user_device_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_user_device
    ADD CONSTRAINT tbl_user_device_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.tbl_user(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_user tbl_user_here_about_us_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_user
    ADD CONSTRAINT tbl_user_here_about_us_id_fkey FOREIGN KEY (here_about_us_id) REFERENCES public.tbl_dropdown_list(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_user tbl_user_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_user
    ADD CONSTRAINT tbl_user_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES public.tbl_permission(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: tbl_user tbl_user_type_of_store_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_user
    ADD CONSTRAINT tbl_user_type_of_store_id_fkey FOREIGN KEY (type_of_store_id) REFERENCES public.tbl_dropdown_list(id) ON UPDATE CASCADE ON DELETE SET NULL;


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

REVOKE USAGE ON SCHEMA public FROM PUBLIC;


--
--

