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

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


ALTER TABLE public.permission_to_exchange_goods_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.permission_to_exchange_goods_arr_seq OWNED BY public.permission_to_exchange_goods.arr;


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

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


ALTER TABLE public.permission_to_exchange_goods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.permission_to_exchange_goods_id_seq OWNED BY public.permission_to_exchange_goods.id;


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

CREATE TABLE public.permission_to_recived_goods (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Note" text,
    "Product_Numbers" text NOT NULL,
    "Total_Qty" text NOT NULL,
    "Total_Discount" text NOT NULL,
    "Total_BF_Taxes" text NOT NULL,
    "Total_Taxes" text NOT NULL,
    "Total_Price" text NOT NULL,
    "Account" bigint NOT NULL,
    "Store" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "To_Store" bigint,
    "Status" text,
    "Edit" text DEFAULT 0,
    "Delete" text DEFAULT 0,
    "Edit_New_Code" text DEFAULT 0,
    "DiscountBill" text DEFAULT 0
);


ALTER TABLE public.permission_to_recived_goods OWNER TO postgres;

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

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


ALTER TABLE public.permission_to_recived_goods_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.permission_to_recived_goods_arr_seq OWNED BY public.permission_to_recived_goods.arr;


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

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


ALTER TABLE public.permission_to_recived_goods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.permission_to_recived_goods_id_seq OWNED BY public.permission_to_recived_goods.id;


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

CREATE TABLE public.permissions (
    id bigint NOT NULL,
    name character varying(191) NOT NULL,
    guard_name character varying(191) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Parent" text,
    "Main" text,
    "nameEn" text,
    "Package" text
);


ALTER TABLE public.permissions OWNER TO postgres;

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

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


ALTER TABLE public.permissions_id_seq OWNER TO postgres;

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

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


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

CREATE TABLE public.places (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Ship_Price" text,
    "City" bigint,
    "Delivery" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "SearchCode" text
);


ALTER TABLE public.places OWNER TO postgres;

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

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


ALTER TABLE public.places_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.places_id_seq OWNED BY public.places.id;


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

CREATE TABLE public.places_reals (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.places_reals OWNER TO postgres;

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

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


ALTER TABLE public.places_reals_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.places_reals_id_seq OWNED BY public.places_reals.id;


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

CREATE TABLE public.platforms (
    id bigint NOT NULL,
    "Arabic_Name" text NOT NULL,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.platforms OWNER TO postgres;

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

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


ALTER TABLE public.platforms_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.platforms_id_seq OWNED BY public.platforms.id;


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

CREATE TABLE public.polices (
    id bigint NOT NULL,
    "Arabic_Desc" text NOT NULL,
    "English_Desc" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.polices OWNER TO postgres;

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

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


ALTER TABLE public.polices_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.polices_id_seq OWNED BY public.polices.id;


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

CREATE TABLE public.pro_details_imgs (
    id bigint NOT NULL,
    "Image" text NOT NULL,
    "Arabic_Title" text NOT NULL,
    "Arabic_Desc" text NOT NULL,
    "English_Title" text NOT NULL,
    "English_Desc" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.pro_details_imgs OWNER TO postgres;

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

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


ALTER TABLE public.pro_details_imgs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.pro_details_imgs_id_seq OWNED BY public.pro_details_imgs.id;


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

CREATE TABLE public.pro_notes (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.pro_notes OWNER TO postgres;

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

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


ALTER TABLE public.pro_notes_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.pro_notes_id_seq OWNED BY public.pro_notes.id;


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

CREATE TABLE public.product_colors (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_colors OWNER TO postgres;

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

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


ALTER TABLE public.product_colors_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_colors_id_seq OWNED BY public.product_colors.id;


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

CREATE TABLE public.product_details_e_com_designs (
    id bigint NOT NULL,
    "Title_Color" text,
    "Txt_Color" text,
    "Price_Color" text,
    "Rate_Color" text,
    "Select_BG_Color" text,
    "Select_Txt_Color" text,
    "Qty_BG_Color" text,
    "Qty_Txt_Color" text,
    "Qty_Input_BG_Color" text,
    "Qty_Input_Txt_Color" text,
    "Comment_Input_BG_Color" text,
    "Comment_Button_BG_Color" text,
    "Comment_Button_Txt_Color" text,
    "Comment_Button_BG_Hover_Color" text,
    "Comment_Button_Txt_Hover_Color" text,
    "Related_Title_BG_Color" text,
    "Related_Title_Txt_Color" text,
    "Related_Product_BG_Color" text,
    "Related_Product_Group_BG_Color" text,
    "Related_Product_Group_Txt_Color" text,
    "Related_Product_Group_Hover_BG_Color" text,
    "Related_Product_Group_Hover_Txt_Color" text,
    "Related_Product_Icon_BG_Color" text,
    "Related_Product_Icon_Txt_Color" text,
    "Related_Product_Icon_Hover_BG_Color" text,
    "Related_Product_Icon_Hover_Txt_Color" text,
    "Related_Product_Txt_Color" text,
    "Related_Product_Price_Color" text,
    "Related_Product_Hover_Price_Color" text,
    "Related_Product_Rate_Color" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_details_e_com_designs OWNER TO postgres;

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

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


ALTER TABLE public.product_details_e_com_designs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_details_e_com_designs_id_seq OWNED BY public.product_details_e_com_designs.id;


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

CREATE TABLE public.product_executing_receiving_secretariats (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "Qty" text,
    "Dep" text,
    "Price" text,
    "Workmanship_Price" text,
    "Total" text,
    "StoreIn" text,
    "StoreOut" text,
    "Product" text,
    "Unit" text,
    "Executing" text,
    type text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_executing_receiving_secretariats OWNER TO postgres;

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

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


ALTER TABLE public.product_executing_receiving_secretariats_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_executing_receiving_secretariats_id_seq OWNED BY public.product_executing_receiving_secretariats.id;


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

CREATE TABLE public.product_inventories (
    id bigint NOT NULL,
    "Av_Qty" text NOT NULL,
    "Inventory" text NOT NULL,
    "Deficit" text NOT NULL,
    "Excess" text NOT NULL,
    "Inv_ID" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "P_Code" text,
    "Price" text,
    "TotalExcessP" text,
    "TotalDificitP" text,
    "Exp_Date" text
);


ALTER TABLE public.product_inventories OWNER TO postgres;

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

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


ALTER TABLE public.product_inventories_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_inventories_id_seq OWNED BY public.product_inventories.id;


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

CREATE TABLE public.product_job_orders (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "TDiscount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total_Tax" text,
    "Total" text,
    "Store" text,
    "Length" text,
    "Width" text,
    "Height" text,
    "Thickness" text,
    "Size" text,
    "Product" text,
    "Unit" text,
    "Order" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Executor" text
);


ALTER TABLE public.product_job_orders OWNER TO postgres;

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

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


ALTER TABLE public.product_job_orders_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_job_orders_id_seq OWNED BY public.product_job_orders.id;


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

CREATE TABLE public.product_maintainc_bills (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text NOT NULL,
    "AvQty" text NOT NULL,
    "Qty" text NOT NULL,
    "Price" text NOT NULL,
    "Discount" text NOT NULL,
    "Tax" text NOT NULL,
    "Total_Bf_Tax" text NOT NULL,
    "Total_Tax" text NOT NULL,
    "Total" text NOT NULL,
    "Exp_Date" text,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Maintaince" bigint NOT NULL,
    "TDiscount" text,
    "Branch" text,
    "Group" text,
    "Brand" text,
    "Date" text
);


ALTER TABLE public.product_maintainc_bills OWNER TO postgres;

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

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


ALTER TABLE public.product_maintainc_bills_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_maintainc_bills_id_seq OWNED BY public.product_maintainc_bills.id;


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

CREATE TABLE public.product_manufacturing_executions (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text NOT NULL,
    "P_En_Name" text NOT NULL,
    "Qty" text NOT NULL,
    "Precent" text,
    "RequiredQty" text,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "Unit" bigint,
    "ManuExecution" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Patch_Number" text
);


ALTER TABLE public.product_manufacturing_executions OWNER TO postgres;

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

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


ALTER TABLE public.product_manufacturing_executions_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_manufacturing_executions_id_seq OWNED BY public.product_manufacturing_executions.id;


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

CREATE TABLE public.product_moves (
    id bigint NOT NULL,
    "Date" text,
    "Type" text,
    "Bill_Num" text,
    "Incom" text,
    "Outcom" text,
    "Current" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "P_Code" text,
    "Unit" bigint,
    "Group" bigint,
    "Store" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "CostIn" text,
    "CostOut" text,
    "CostCurrent" text,
    "QTY" text,
    "Brand" text,
    "Branch" text,
    "SalePrice" text,
    "ProductPrice" text,
    "Delegate" text,
    "Payment_Method" text,
    "Safe" bigint,
    "TypeEn" text,
    "Delete" text DEFAULT 0,
    "Edit" text DEFAULT 0,
    "Edit_New_Code" text
);


ALTER TABLE public.product_moves OWNER TO postgres;

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

CREATE TABLE public.product_moves_columns (
    id bigint NOT NULL,
    "Date" text,
    "Product_Code" text,
    "Product_Name" text,
    "Unit" text,
    "Type" text,
    "Bill_Num" text,
    "Incom" text,
    "Outcom" text,
    "Credit" text,
    "Group" text,
    "Brand" text,
    "Store" text,
    "User" text,
    "Safe" text,
    "Branch" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_moves_columns OWNER TO postgres;

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

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


ALTER TABLE public.product_moves_columns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_moves_columns_id_seq OWNED BY public.product_moves_columns.id;


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

CREATE TABLE public.product_moves_columns_sechdules (
    id bigint NOT NULL,
    "Date" text,
    "Product_Code" text,
    "Product_Name" text,
    "Unit" text,
    "Type" text,
    "Bill_Num" text,
    "Incom" text,
    "Outcom" text,
    "Credit" text,
    "Group" text,
    "Brand" text,
    "Store" text,
    "User" text,
    "Safe" text,
    "Branch" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_moves_columns_sechdules OWNER TO postgres;

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

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


ALTER TABLE public.product_moves_columns_sechdules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_moves_columns_sechdules_id_seq OWNED BY public.product_moves_columns_sechdules.id;


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

CREATE TABLE public.product_moves_filter_twos (
    id bigint NOT NULL,
    "Date" text,
    "Type" text,
    "Bill_Num" text,
    "Incom" text,
    "Outcom" text,
    "Current" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "P_Code" text,
    "Unit" text,
    "Group" text,
    "Store" text,
    "Product" text,
    "V1" text,
    "V2" text,
    "User" text,
    "CostIn" text,
    "CostOut" text,
    "CostCurrent" text,
    "CostOneIn" text,
    "CostOneOut" text,
    "CostOneCurrent" text,
    "QTY" text,
    "Brand" text,
    "Safe" text,
    "Branch" text,
    "SalePrice" text,
    "ProductPrice" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_moves_filter_twos OWNER TO postgres;

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

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


ALTER TABLE public.product_moves_filter_twos_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_moves_filter_twos_id_seq OWNED BY public.product_moves_filter_twos.id;


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

CREATE TABLE public.product_moves_filters (
    id bigint NOT NULL,
    "Date" text,
    "Type" text,
    "Bill_Num" text,
    "Incom" text,
    "Outcom" text,
    "Current" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "P_Code" text,
    "Unit" text,
    "Group" text,
    "Store" text,
    "Product" text,
    "V1" text,
    "V2" text,
    "User" text,
    "CostIn" text,
    "CostOut" text,
    "CostCurrent" text,
    "CostOneIn" text,
    "CostOneOut" text,
    "CostOneCurrent" text,
    "QTY" text,
    "Brand" text,
    "Safe" text,
    "Branch" text,
    "SalePrice" text,
    "ProductPrice" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_moves_filters OWNER TO postgres;

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

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


ALTER TABLE public.product_moves_filters_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_moves_filters_id_seq OWNED BY public.product_moves_filters.id;


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

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


ALTER TABLE public.product_moves_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_moves_id_seq OWNED BY public.product_moves.id;


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

CREATE TABLE public.product_quote_images (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text NOT NULL,
    "P_En_Name" text NOT NULL,
    "V_Name" text,
    "VV_Name" text,
    "Qty" text NOT NULL,
    "Price" text NOT NULL,
    "Discount" text NOT NULL,
    "Tax" text NOT NULL,
    "Total_Bf_Tax" text NOT NULL,
    "Total" text NOT NULL,
    "Total_Tax" text NOT NULL,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "QuoteImage" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "TDiscount" text,
    "Original_Qty" text,
    "AvQty" text,
    "Store" text,
    "Exp_Date" text,
    "Total_Wight" text,
    "UnitRate" text,
    weight text,
    "SalesProDesc" text,
    "TotCostNew" text,
    "SmallQty" text,
    "SmallCode" text,
    "CostPrice" text,
    "Date" text,
    "Patch_Number" text,
    "Branch" text,
    "Group" text,
    "Brand" text,
    "Pro_Note" text,
    "SubVID" text,
    "Total_Net" text
);


ALTER TABLE public.product_quote_images OWNER TO postgres;

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

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


ALTER TABLE public.product_quote_images_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_quote_images_id_seq OWNED BY public.product_quote_images.id;


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

CREATE TABLE public.product_return_without_bills (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text,
    "SmallCode" text,
    "Qty" text,
    "SmallQty" text,
    "Price" text,
    "Cost" text,
    "Discount" text,
    "TDiscount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total_Tax" text,
    "Total" text,
    "Total_Cost" text,
    "Store" text,
    "Exp_Date" text,
    "V1" text,
    "V2" text,
    "Unit" text,
    "Date" text,
    "Code" text,
    "Refernce_Number" text,
    "Safe" text,
    "Vendor" text,
    "Delegate" text,
    "Coin" text,
    "User" text,
    "Cost_Center" text,
    "Type" text,
    "Payment_Method" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Bill" bigint,
    "Product" bigint
);


ALTER TABLE public.product_return_without_bills OWNER TO postgres;

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

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


ALTER TABLE public.product_return_without_bills_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_return_without_bills_id_seq OWNED BY public.product_return_without_bills.id;


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

CREATE TABLE public.product_sales (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text NOT NULL,
    "AvQty" text NOT NULL,
    "Qty" text NOT NULL,
    "Price" text NOT NULL,
    "Discount" text NOT NULL,
    "Tax" text NOT NULL,
    "Total_Bf_Tax" text NOT NULL,
    "Total_Tax" text NOT NULL,
    "Total" text NOT NULL,
    "Exp_Date" text,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Sales" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Date" text,
    "Code" text,
    "Delegate" bigint,
    "Client" bigint,
    "Executor" bigint,
    "Refernce_Number" text,
    "Type" text,
    "Cost_Center" bigint,
    "User" bigint,
    "Coin" bigint,
    "Safe" bigint,
    "Ship" bigint,
    "Patch_Number" text,
    "Later_Collection" text DEFAULT 1,
    "SmallQty" text,
    "SmallCode" text,
    "TDiscount" text,
    "CostPrice" text,
    "Branch" text,
    "Group" text,
    "Brand" text,
    "Status" text,
    "CustomerGroup" text,
    "Payment_Method" text,
    "CoinCode" text,
    "CoinRate" text,
    "CoinPrice" text,
    "AmountEGP" text,
    "SalesTotal" text,
    "DiscountAmount" text,
    "NetTotal" text,
    "TaxType" text,
    "TaxAmount" text,
    "TaxSubType" text,
    "TaxRate" text,
    "TotalBill" text,
    "TypeEn" text,
    "Pro_Note" text,
    "SubVID" text,
    "Total_Wight" text,
    "UnitRate" text,
    weight text,
    "SalesProDesc" text,
    "TotCostNew" text,
    "Total_Net" text,
    "Pro_Lenght" text,
    "Pro_Height" text,
    "Pro_Num" text,
    "Pro_Cost_Center" text
);


ALTER TABLE public.product_sales OWNER TO postgres;

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

CREATE TABLE public.product_sales_gifts (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "AvQty" text,
    "Qty" text,
    "Price" text,
    "CostPrice" text,
    "Total" text,
    "TotCost" text,
    "Store" text,
    "Exp_Date" text,
    "V1" text,
    "V2" text,
    "Unit" text,
    "Gift" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Product" text
);


ALTER TABLE public.product_sales_gifts OWNER TO postgres;

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

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


ALTER TABLE public.product_sales_gifts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_sales_gifts_id_seq OWNED BY public.product_sales_gifts.id;


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

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


ALTER TABLE public.product_sales_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_sales_id_seq OWNED BY public.product_sales.id;


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

CREATE TABLE public.product_sales_orders (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text NOT NULL,
    "AvQty" text NOT NULL,
    "Qty" text NOT NULL,
    "Price" text NOT NULL,
    "Discount" text NOT NULL,
    "Tax" text NOT NULL,
    "Total_Bf_Tax" text NOT NULL,
    "Total_Tax" text NOT NULL,
    "Total" text NOT NULL,
    "Exp_Date" text,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "SalesOrder" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Patch_Number" text,
    "TDiscount" text,
    "CostPrice" text,
    "Pro_Note" text,
    "SubVID" text,
    "Total_Wight" text,
    "UnitRate" text,
    weight text,
    "SalesProDesc" text,
    "TotCostNew" text,
    "SmallQty" text,
    "SmallCode" text,
    "Date" text,
    "Branch" text,
    "Group" text,
    "Brand" text,
    "Total_Net" text,
    "Pro_Lenght" text,
    "Pro_Height" text,
    "Pro_Num" text,
    "Pro_Cost_Center" text
);


ALTER TABLE public.product_sales_orders OWNER TO postgres;

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

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


ALTER TABLE public.product_sales_orders_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_sales_orders_id_seq OWNED BY public.product_sales_orders.id;


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

CREATE TABLE public.product_sales_subscribes (
    id bigint NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "Product_Code" text,
    "V_Name" text,
    "VV_Name" text,
    "Price" text,
    "Total" text,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Subscribe" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Sub_Date" text,
    "Sub_Type" text
);


ALTER TABLE public.product_sales_subscribes OWNER TO postgres;

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

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


ALTER TABLE public.product_sales_subscribes_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_sales_subscribes_id_seq OWNED BY public.product_sales_subscribes.id;


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

CREATE TABLE public.product_settlements (
    id bigint NOT NULL,
    "Av_Qty" text NOT NULL,
    "Inventory" text NOT NULL,
    "Deficit" text NOT NULL,
    "Excess" text NOT NULL,
    "Set_ID" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "P_Code" text,
    "Price" text,
    "TotalDificitP" text,
    "TotalExcessP" text,
    "Store" bigint,
    "User" bigint,
    "Coin" bigint,
    "Date" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Exp_Date" text
);


ALTER TABLE public.product_settlements OWNER TO postgres;

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

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


ALTER TABLE public.product_settlements_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_settlements_id_seq OWNED BY public.product_settlements.id;


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

CREATE TABLE public.product_sizes (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_sizes OWNER TO postgres;

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

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


ALTER TABLE public.product_sizes_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_sizes_id_seq OWNED BY public.product_sizes.id;


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

CREATE TABLE public.product_thicknesses (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_thicknesses OWNER TO postgres;

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

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


ALTER TABLE public.product_thicknesses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_thicknesses_id_seq OWNED BY public.product_thicknesses.id;


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

CREATE TABLE public.product_type_defaults (
    id bigint NOT NULL,
    "Type" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_type_defaults OWNER TO postgres;

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

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


ALTER TABLE public.product_type_defaults_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_type_defaults_id_seq OWNED BY public.product_type_defaults.id;


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

CREATE TABLE public.product_units (
    id bigint NOT NULL,
    "Rate" text NOT NULL,
    "Barcode" text NOT NULL,
    "Price" text NOT NULL,
    "Price_Two" text,
    "Price_Three" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "P_Type" text,
    "Unit" bigint,
    "Product" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Def" character varying DEFAULT 0,
    "Brand" text,
    "Group" text
);


ALTER TABLE public.product_units OWNER TO postgres;

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

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


ALTER TABLE public.product_units_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.product_units_id_seq OWNED BY public.product_units.id;


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

CREATE TABLE public.products (
    id bigint NOT NULL,
    "P_Type" text NOT NULL,
    "P_Ar_Name" text NOT NULL,
    "P_En_Name" text,
    "Brand" bigint,
    "Group" bigint NOT NULL,
    "Image" text,
    "Minimum" text,
    "Maximum" text,
    "Length" text,
    "Width" text,
    "Height" text,
    "Weight" text,
    "Saller_Point" text,
    "Customer_Point" text,
    "Tax" bigint NOT NULL,
    "Validity" text,
    "Days_Notify" text,
    "Ar_Desc" text,
    "En_Desc" text,
    "Ar_Spec" text,
    "En_Spec" text,
    "Store_Show" text,
    "Store_Type" text,
    "Status" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Sub_Cost" character varying,
    subscribe_type bigint,
    "Cas_No" text,
    "HSN" text,
    "Uni_Code" text,
    "Image2" text,
    "Offer" text,
    "OfferPrice" text,
    rate text,
    "Code_Type" text,
    "World_Code" text,
    "Origin_Number" text,
    "Origin_Country" text,
    "SearchCode1" text,
    "SearchCode2" text,
    "Space" text,
    "Storage" text,
    "Processor" text,
    "Camera" text,
    "Screen" text,
    "OS" text,
    "Battery" text,
    "Warranty" text,
    "Color" text,
    "Category" text,
    "Model" text,
    "Guess_Price" text,
    "Arrange" bigint,
    "Added" text,
    "Offer_Start_Date" text,
    "Offer_End_Date" text,
    "English_Brief_Desc" text,
    "Arabic_Brief_Desc" text,
    "Show_Other_Store" text,
    "Calories" text,
    "Thickness" text,
    "Maximum_Sales_Qty" text,
    "Delete" text DEFAULT 0,
    "Cost_Price" text DEFAULT 0,
    "Faveorite" text DEFAULT 0,
    "Bonus" text DEFAULT 0,
    "ProductThickness" text,
    "ProductSizes" text,
    "ProductColors" text,
    "Colors_Code" text,
    "Purchases_Code" text
);


ALTER TABLE public.products OWNER TO postgres;

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

CREATE TABLE public.products_client_requests (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Qty" text,
    "V1" text,
    "V2" text,
    "Unit" text,
    "Desc" text,
    "Product" text,
    "Request" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.products_client_requests OWNER TO postgres;

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

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


ALTER TABLE public.products_client_requests_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_client_requests_id_seq OWNED BY public.products_client_requests.id;


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

CREATE TABLE public.products_consists (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Qty" text,
    "Consist" text,
    "Price" text,
    "Total" text,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Consist_ID" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Exp_Date" text
);


ALTER TABLE public.products_consists OWNER TO postgres;

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

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


ALTER TABLE public.products_consists_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_consists_id_seq OWNED BY public.products_consists.id;


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

CREATE TABLE public.products_executing_receivings (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text NOT NULL,
    "P_En_Name" text NOT NULL,
    "Qty" text NOT NULL,
    "Price" text NOT NULL,
    "Total" text NOT NULL,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "Unit" bigint,
    "Executing" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    type text,
    "Dep" text
);


ALTER TABLE public.products_executing_receivings OWNER TO postgres;

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

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


ALTER TABLE public.products_executing_receivings_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_executing_receivings_id_seq OWNED BY public.products_executing_receivings.id;


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

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


ALTER TABLE public.products_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_id_seq OWNED BY public.products.id;


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

CREATE TABLE public.products_manufacturing_orders (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Store_Qty" text,
    "Required_Qty" text,
    "Qty" text,
    "Store" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "ManuOrder" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Precent" text
);


ALTER TABLE public.products_manufacturing_orders OWNER TO postgres;

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

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


ALTER TABLE public.products_manufacturing_orders_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_manufacturing_orders_id_seq OWNED BY public.products_manufacturing_orders.id;


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

CREATE TABLE public.products_manufacturing_requests (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Qty" text NOT NULL,
    "Price" text NOT NULL,
    "Discount" text NOT NULL,
    "Tax" text NOT NULL,
    "Total_Bf_Tax" text NOT NULL,
    "Total_Tax" text NOT NULL,
    "Total" text NOT NULL,
    "Exp_Date" text,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Request" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.products_manufacturing_requests OWNER TO postgres;

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

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


ALTER TABLE public.products_manufacturing_requests_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_manufacturing_requests_id_seq OWNED BY public.products_manufacturing_requests.id;


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

CREATE TABLE public.products_permission_to_exchange_goods (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text NOT NULL,
    "AvQty" text NOT NULL,
    "Qty" text NOT NULL,
    "Date" text NOT NULL,
    "Price" text NOT NULL,
    "Discount" text NOT NULL,
    "Tax" text NOT NULL,
    "Total_Bf_Tax" text NOT NULL,
    "Total_Tax" text NOT NULL,
    "Total" text NOT NULL,
    "Exp_Date" text,
    "Store" bigint NOT NULL,
    "To_Store" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Exchange" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "CostPrice" text,
    "TDiscount" text,
    "Patch_Number" text,
    "Pro_Note" text,
    "SubVID" text,
    "Total_Wight" text,
    "UnitRate" text,
    weight text,
    "SalesProDesc" text,
    "TotCostNew" text,
    "SmallQty" text,
    "SmallCode" text,
    "Total_Net" text
);


ALTER TABLE public.products_permission_to_exchange_goods OWNER TO postgres;

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

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


ALTER TABLE public.products_permission_to_exchange_goods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_permission_to_exchange_goods_id_seq OWNED BY public.products_permission_to_exchange_goods.id;


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

CREATE TABLE public.products_permission_to_recived_goods (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text NOT NULL,
    "AvQty" text NOT NULL,
    "Qty" text NOT NULL,
    "Date" text NOT NULL,
    "Price" text NOT NULL,
    "Discount" text NOT NULL,
    "Tax" text NOT NULL,
    "Total_Bf_Tax" text NOT NULL,
    "Total_Tax" text NOT NULL,
    "Total" text NOT NULL,
    "Exp_Date" text,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Recived" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "To_Store" bigint,
    "TDiscount" text,
    "SmallCode" text,
    "SmallQty" text,
    "Total_Net" text
);


ALTER TABLE public.products_permission_to_recived_goods OWNER TO postgres;

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

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


ALTER TABLE public.products_permission_to_recived_goods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_permission_to_recived_goods_id_seq OWNED BY public.products_permission_to_recived_goods.id;


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

CREATE TABLE public.products_purchase_petrols (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "Qty" text,
    "Price" text,
    "Total" text,
    "Store" bigint,
    "Product" bigint,
    "Unit" bigint,
    "Petrol" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "SmallCode" text,
    "SmallQty" text
);


ALTER TABLE public.products_purchase_petrols OWNER TO postgres;

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

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


ALTER TABLE public.products_purchase_petrols_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_purchase_petrols_id_seq OWNED BY public.products_purchase_petrols.id;


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

CREATE TABLE public.products_purchases (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total" text,
    "Total_Tax" text,
    "Exp_Date" text,
    "Store" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Purchase" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Date" text,
    "Code" text,
    "Refernce_Number" text,
    "Safe" bigint,
    "Vendor" bigint,
    "Delegate" bigint,
    "Coin" bigint,
    "User" bigint,
    "Cost_Center" bigint,
    "Type" text,
    "Ship" bigint,
    "SmallQty" text,
    "SmallCode" text,
    "TDiscount" text,
    "Payment_Method" text,
    "TypeEn" text,
    "Total_Net" text,
    "ChassisNumber" text,
    "MotorNumber" text
);


ALTER TABLE public.products_purchases OWNER TO postgres;

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

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


ALTER TABLE public.products_purchases_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_purchases_id_seq OWNED BY public.products_purchases.id;


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

CREATE TABLE public.products_purchases_orders (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total" text,
    "Store" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "P_Order" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Total_Tax" text,
    "Exp_Date" text,
    "Date" text,
    "Vendor" bigint,
    "TDiscount" text,
    "SmallCode" text,
    "SmallQty" text,
    "Code" text,
    "Refernce_Number" text,
    "Safe" text,
    "Delegate" text,
    "Coin" text,
    "User" text,
    "Cost_Center" text,
    "Type" text,
    "Ship" text,
    "Payment_Method" text,
    "Total_Net" text,
    "ChassisNumber" text,
    "MotorNumber" text
);


ALTER TABLE public.products_purchases_orders OWNER TO postgres;

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

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


ALTER TABLE public.products_purchases_orders_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_purchases_orders_id_seq OWNED BY public.products_purchases_orders.id;


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

CREATE TABLE public.products_qties (
    id bigint NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "P_Code" text,
    "V_Name" text,
    "VV_Name" text,
    "Qty" text,
    "Price" text,
    "Pro_Stores" bigint,
    "Store" bigint,
    "Unit" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Low_Unit" bigint,
    "Original" text,
    "Patch_Number" text,
    "PP_Code" text,
    "PPP_Code" text,
    "PPPP_Code" text,
    "Exp_Date" text,
    "Price_Sale" text,
    "SearchCode1" text,
    "SearchCode2" text,
    "Group" text,
    "Brand" text,
    "Branch" text,
    "TotalCost" text,
    "Hold_Qty" text DEFAULT 0,
    "ChassisNumber" text,
    "MotorNumber" text
);


ALTER TABLE public.products_qties OWNER TO postgres;

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

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


ALTER TABLE public.products_qties_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_qties_id_seq OWNED BY public.products_qties.id;


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

CREATE TABLE public.products_quotes (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text,
    "AvQty" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total" text,
    "Store" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "S_Quote" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Total_Tax" text,
    "Exp_Date" text,
    "Patch_Number" text,
    "TDiscount" text,
    "Total_Wight" text,
    "UnitRate" text,
    weight text,
    "SalesProDesc" text,
    "TotCostNew" text,
    "SmallQty" text,
    "SmallCode" text,
    "CostPrice" text,
    "Date" text,
    "Branch" text,
    "Group" text,
    "Brand" text,
    "Pro_Note" text,
    "SubVID" text,
    "Total_Net" text,
    "Pro_Lenght" text,
    "Pro_Height" text,
    "Pro_Num" text,
    "Pro_Cost_Center" text
);


ALTER TABLE public.products_quotes OWNER TO postgres;

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

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


ALTER TABLE public.products_quotes_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_quotes_id_seq OWNED BY public.products_quotes.id;


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

CREATE TABLE public.products_return_maintaince_bills (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text NOT NULL,
    "AvQty" text NOT NULL,
    "Qty" text NOT NULL,
    "Price" text NOT NULL,
    "Discount" text NOT NULL,
    "Tax" text NOT NULL,
    "Total_Bf_Tax" text NOT NULL,
    "Total_Tax" text NOT NULL,
    "Total" text NOT NULL,
    "Exp_Date" text,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Return" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Recived_Qty" text,
    "Out" text,
    "Date" text,
    "User" bigint,
    "Eng" bigint,
    "Brand" bigint,
    "Group" bigint,
    "Branch" bigint,
    "Recipient" bigint
);


ALTER TABLE public.products_return_maintaince_bills OWNER TO postgres;

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

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


ALTER TABLE public.products_return_maintaince_bills_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_return_maintaince_bills_id_seq OWNED BY public.products_return_maintaince_bills.id;


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

CREATE TABLE public.products_secretariat_export_goods (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Qty" text,
    "Date" text,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Export" bigint,
    "Store" bigint NOT NULL,
    "Unit" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Note" text,
    "RecivedQty" text,
    "Impotence" text,
    "Price" text,
    "Total" text
);


ALTER TABLE public.products_secretariat_export_goods OWNER TO postgres;

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

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


ALTER TABLE public.products_secretariat_export_goods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_secretariat_export_goods_id_seq OWNED BY public.products_secretariat_export_goods.id;


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

CREATE TABLE public.products_secretariat_import_goods (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Qty" text,
    "Date" text,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Import" bigint,
    "Unit" bigint,
    "Store" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.products_secretariat_import_goods OWNER TO postgres;

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

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


ALTER TABLE public.products_secretariat_import_goods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_secretariat_import_goods_id_seq OWNED BY public.products_secretariat_import_goods.id;


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

CREATE TABLE public.products_shortcomings (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Av_Qty" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Tax" text NOT NULL,
    "Total_Bf_Tax" text NOT NULL,
    "Total" text NOT NULL,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Shortmings" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Total_Tax" text,
    "Exp_Date" text,
    "TDiscount" text,
    "Original_Qty" text,
    "SmallCode" text,
    "SmallQty" text,
    "Date" text,
    "Code" text,
    "Refernce_Number" text,
    "Safe" text,
    "Vendor" text,
    "Delegate" text,
    "Coin" text,
    "User" text,
    "Cost_Center" text,
    "Type" text,
    "Ship" text,
    "Payment_Method" text,
    "Total_Net" text
);


ALTER TABLE public.products_shortcomings OWNER TO postgres;

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

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


ALTER TABLE public.products_shortcomings_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_shortcomings_id_seq OWNED BY public.products_shortcomings.id;


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

CREATE TABLE public.products_start_periods (
    id bigint NOT NULL,
    "P_Code" text NOT NULL,
    "Qty" text NOT NULL,
    "Price" text NOT NULL,
    "Total" text NOT NULL,
    "Old_Qty" text NOT NULL,
    "Exp_Date" text,
    "SP_ID" bigint,
    "Unit" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Date" text,
    "User" bigint,
    "Store" bigint,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Patch_Number" text,
    "SmallQty" text,
    "SmallCode" text
);


ALTER TABLE public.products_start_periods OWNER TO postgres;

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

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


ALTER TABLE public.products_start_periods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_start_periods_id_seq OWNED BY public.products_start_periods.id;


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

CREATE TABLE public.products_stores (
    id bigint NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "P_Code" text,
    "V_Name" text,
    "VV_Name" text,
    "Exp_Date" text,
    "Product" bigint,
    "Store" bigint,
    "V1" bigint,
    "V2" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.products_stores OWNER TO postgres;

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

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


ALTER TABLE public.products_stores_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_stores_id_seq OWNED BY public.products_stores.id;


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

CREATE TABLE public.products_stores_transfers (
    id bigint NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "P_Code" text,
    "Price" text,
    "Av_Qty" text,
    "Trans_Qty" text,
    "Total" text,
    "ST_ID" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "To_Store" text,
    "OldPrice" text,
    "SmallTrans_Qty" text,
    "SmallCode" text,
    "Original_Trans_Qty" text,
    "CostPrice" text,
    "Exp_Date" text
);


ALTER TABLE public.products_stores_transfers OWNER TO postgres;

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

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


ALTER TABLE public.products_stores_transfers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_stores_transfers_id_seq OWNED BY public.products_stores_transfers.id;


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

CREATE TABLE public.products_viras (
    id bigint NOT NULL,
    "Cost" text,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.products_viras OWNER TO postgres;

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

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


ALTER TABLE public.products_viras_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.products_viras_id_seq OWNED BY public.products_viras.id;


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

CREATE TABLE public.profit_sales_product_column_sechdulrs (
    id bigint NOT NULL,
    "Product_Code" text,
    "Product_Name" text,
    "Unit" text,
    "Qty" text,
    "Price" text,
    "Cost" text,
    "Profit" text,
    "Store" text,
    "Branch" text,
    "Group" text,
    "Brand" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.profit_sales_product_column_sechdulrs OWNER TO postgres;

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

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


ALTER TABLE public.profit_sales_product_column_sechdulrs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.profit_sales_product_column_sechdulrs_id_seq OWNED BY public.profit_sales_product_column_sechdulrs.id;


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

CREATE TABLE public.profit_sales_product_columns (
    id bigint NOT NULL,
    "Product_Code" text,
    "Product_Name" text,
    "Unit" text,
    "Qty" text,
    "Price" text,
    "Cost" text,
    "Profit" text,
    "Store" text,
    "Branch" text,
    "Group" text,
    "Brand" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.profit_sales_product_columns OWNER TO postgres;

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

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


ALTER TABLE public.profit_sales_product_columns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.profit_sales_product_columns_id_seq OWNED BY public.profit_sales_product_columns.id;


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

CREATE TABLE public.project_statuses (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Color" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.project_statuses OWNER TO postgres;

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

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


ALTER TABLE public.project_statuses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.project_statuses_id_seq OWNED BY public.project_statuses.id;


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

CREATE TABLE public.project_teams (
    id bigint NOT NULL,
    "Member" bigint,
    "Project" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.project_teams OWNER TO postgres;

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

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


ALTER TABLE public.project_teams_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.project_teams_id_seq OWNED BY public.project_teams.id;


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

CREATE TABLE public.projects (
    id bigint NOT NULL,
    "Name" text NOT NULL,
    "Start_Date" text NOT NULL,
    "End_Date" text NOT NULL,
    "Duration" text NOT NULL,
    "Value" text NOT NULL,
    "File" text,
    "Client" bigint NOT NULL,
    "Manager" bigint,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Status" text DEFAULT 0,
    "NameEn" text
);


ALTER TABLE public.projects OWNER TO postgres;

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

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


ALTER TABLE public.projects_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.projects_id_seq OWNED BY public.projects.id;


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

CREATE TABLE public.purch_bills_columns (
    id bigint NOT NULL,
    "Date" text,
    "Code" text,
    "Time" text,
    "Refrence_Number" text,
    "Branch" text,
    "Store" text,
    "Payment_Method" text,
    "Safe" text,
    "Type" text,
    "Shipping" text,
    "Cost_Center" text,
    "User" text,
    "Coin" text,
    "Due_Date" text,
    "Delegate" text,
    "Note" text,
    "Total_Return" text,
    "Total_Price" text,
    "Total_Discount" text,
    "Total_Tax" text,
    "Total_Net" text,
    "Paid" text,
    "Residual" text,
    "Vendor" text,
    "Product_Code" text,
    "Product_Name" text,
    "Unit" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Total_BF_Tax" text,
    "Tax" text,
    "Total" text,
    "Group" text,
    "Brand" text,
    "Exp_Date" text,
    "Product_Store" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Rate" text,
    "Name_Width" text
);


ALTER TABLE public.purch_bills_columns OWNER TO postgres;

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

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


ALTER TABLE public.purch_bills_columns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purch_bills_columns_id_seq OWNED BY public.purch_bills_columns.id;


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

CREATE TABLE public.purch_bills_columns_sechdules (
    id bigint NOT NULL,
    "Date" text,
    "Code" text,
    "Time" text,
    "Refrence_Number" text,
    "Branch" text,
    "Store" text,
    "Payment_Method" text,
    "Safe" text,
    "Type" text,
    "Shipping" text,
    "Cost_Center" text,
    "User" text,
    "Coin" text,
    "Due_Date" text,
    "Delegate" text,
    "Note" text,
    "Total_Return" text,
    "Total_Price" text,
    "Total_Discount" text,
    "Total_Tax" text,
    "Total_Net" text,
    "Paid" text,
    "Residual" text,
    "Vendor" text,
    "Product_Code" text,
    "Product_Name" text,
    "Unit" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Total_BF_Tax" text,
    "Tax" text,
    "Total" text,
    "Group" text,
    "Brand" text,
    "Exp_Date" text,
    "Product_Store" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Rate" text,
    "Name_Width" text
);


ALTER TABLE public.purch_bills_columns_sechdules OWNER TO postgres;

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

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


ALTER TABLE public.purch_bills_columns_sechdules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purch_bills_columns_sechdules_id_seq OWNED BY public.purch_bills_columns_sechdules.id;


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

CREATE TABLE public.purch_bills_filter_twos (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Payment_Method" text,
    "Status" text,
    "Refernce_Number" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Pay" text,
    "Safe" text,
    "Vendor" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Ship" text,
    "Later_Due" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "Type" text,
    "ID" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.purch_bills_filter_twos OWNER TO postgres;

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

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


ALTER TABLE public.purch_bills_filter_twos_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purch_bills_filter_twos_id_seq OWNED BY public.purch_bills_filter_twos.id;


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

CREATE TABLE public.purch_bills_filters (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Payment_Method" text,
    "Status" text,
    "Refernce_Number" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Pay" text,
    "Safe" text,
    "Vendor" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Ship" text,
    "Later_Due" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "Type" text,
    "ID" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.purch_bills_filters OWNER TO postgres;

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

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


ALTER TABLE public.purch_bills_filters_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purch_bills_filters_id_seq OWNED BY public.purch_bills_filters.id;


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

CREATE TABLE public.purchase_petrols (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Later_Due" text,
    "Vendor_Bill_Date" text,
    "Refernce_Number" text,
    "Draw" text,
    "Payment_Method" text,
    "Note" text,
    "File" text,
    "Car_Number" text,
    "Delivery_Method" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Price" text,
    "Pay" text,
    "Full" text,
    "Vendor" bigint,
    "Coin" bigint,
    "Safe" bigint,
    "CompanyCar" bigint,
    "Store" bigint,
    "Recipient" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Number" text
);


ALTER TABLE public.purchase_petrols OWNER TO postgres;

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

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


ALTER TABLE public.purchase_petrols_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purchase_petrols_arr_seq OWNED BY public.purchase_petrols.arr;


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

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


ALTER TABLE public.purchase_petrols_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purchase_petrols_id_seq OWNED BY public.purchase_petrols.id;


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

CREATE TABLE public.purchases (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Payment_Method" text NOT NULL,
    "Status" text NOT NULL,
    "Vendor_Bill_Date" text,
    "Refernce_Number" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Pay" text,
    "P_Order_Num" text,
    "Safe" bigint NOT NULL,
    "Vendor" bigint NOT NULL,
    "Delegate" bigint,
    "Store" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Ship" bigint,
    "Check_Type" bigint,
    "Check_Number" text,
    "Due_Date" text,
    "ShipStatus" text DEFAULT 0,
    "Later_Due" text,
    "Sent" text,
    "TaxBill" text DEFAULT 0,
    "TaxCode" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "File" text,
    "Current_Credit" text,
    "Residual" text,
    "Total_Net" text,
    "Edit" text DEFAULT 0,
    "Delete" text DEFAULT 0,
    "Edit_New_Code" text,
    "DiscountBill" text DEFAULT 0,
    "ImportTotalCost" text,
    "Documentary_ID" text
);


ALTER TABLE public.purchases OWNER TO postgres;

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

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


ALTER TABLE public.purchases_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purchases_arr_seq OWNED BY public.purchases.arr;


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

CREATE TABLE public.purchases_default_data (
    id bigint NOT NULL,
    "Payment_Method" text,
    "Status" text,
    "V_and_C" text,
    "Safe" bigint,
    "Vendor" bigint,
    "Delegate" bigint,
    "Store" bigint,
    "Coin" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Brand" text,
    "Group" text,
    "English_Name" text,
    "Expire" text,
    "Empp" text,
    "Quality_Qty" text,
    "Discount" text,
    "Hide_Product" text,
    "Hide_Edit_Delete" text,
    "Duplicate_Items" text,
    "Import_Invoice" text,
    "Import_Account" text
);


ALTER TABLE public.purchases_default_data OWNER TO postgres;

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

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


ALTER TABLE public.purchases_default_data_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purchases_default_data_id_seq OWNED BY public.purchases_default_data.id;


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

CREATE TABLE public.purchases_expenses_types (
    id bigint NOT NULL,
    "Type" text,
    "Cost" text,
    "Purchases" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.purchases_expenses_types OWNER TO postgres;

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

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


ALTER TABLE public.purchases_expenses_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purchases_expenses_types_id_seq OWNED BY public.purchases_expenses_types.id;


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

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


ALTER TABLE public.purchases_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purchases_id_seq OWNED BY public.purchases.id;


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

CREATE TABLE public.purchases_order_expenses_types (
    id bigint NOT NULL,
    "Type" text,
    "Cost" text,
    "PurchasesOrder" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.purchases_order_expenses_types OWNER TO postgres;

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

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


ALTER TABLE public.purchases_order_expenses_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purchases_order_expenses_types_id_seq OWNED BY public.purchases_order_expenses_types.id;


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

CREATE TABLE public.purchases_orders (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Draw" text,
    "Payment_Method" text,
    "Status" text,
    "Vendor_Bill_Date" text,
    "Refernce_Number" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Pay" text,
    "P_Order_Num" text,
    "Safe" bigint,
    "Vendor" bigint,
    "Delegate" bigint,
    "Store" bigint,
    "Coin" bigint,
    "Cost_Center" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "ToPurch" text DEFAULT 0,
    "Quality" text DEFAULT 0,
    "Quality_Note" text,
    "Quantity" text DEFAULT 0,
    "Quantity_Note" text,
    "Purchases_Date" text,
    "ShipStatus" text,
    "Ship" text,
    "Check_Type" text,
    "Due_Date" text,
    "Check_Number" text,
    "Later_Due" text,
    "Sent" text,
    "TaxBill" text,
    "TaxCode" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "File" text,
    "Current_Credit" text,
    "Residual" text,
    "Total_Net" text,
    "Edit" text DEFAULT 0,
    "Delete" text DEFAULT 0,
    "Edit_New_Code" text,
    "DiscountBill" text DEFAULT 0,
    "ImportTotalCost" text
);


ALTER TABLE public.purchases_orders OWNER TO postgres;

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

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


ALTER TABLE public.purchases_orders_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purchases_orders_arr_seq OWNED BY public.purchases_orders.arr;


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

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


ALTER TABLE public.purchases_orders_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purchases_orders_id_seq OWNED BY public.purchases_orders.id;


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

CREATE TABLE public.purpose_travel (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.purpose_travel OWNER TO postgres;

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

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


ALTER TABLE public.purpose_travel_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.purpose_travel_id_seq OWNED BY public.purpose_travel.id;


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

CREATE TABLE public.q_r_s (
    id bigint NOT NULL,
    "QR" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.q_r_s OWNER TO postgres;

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

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


ALTER TABLE public.q_r_s_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.q_r_s_id_seq OWNED BY public.q_r_s.id;


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

CREATE TABLE public.qualities (
    id bigint NOT NULL,
    "Code" text,
    "Execution_Code" text,
    "Date" text,
    "Outcome_Name" text,
    "Outcome_Code" text,
    "Outcome_Qty" text,
    "Except_Qty" text,
    "Outcome_Unit" text,
    "Outcome_Store" text,
    "Production_Manager" bigint,
    "Quality_Manager" bigint,
    "ManuExecution" bigint NOT NULL,
    "Note" text,
    "Status" text,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.qualities OWNER TO postgres;

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

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


ALTER TABLE public.qualities_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.qualities_arr_seq OWNED BY public.qualities.arr;


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

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


ALTER TABLE public.qualities_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.qualities_id_seq OWNED BY public.qualities.id;


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

CREATE TABLE public.quality_details (
    id bigint NOT NULL,
    "Exmine_Type" text,
    "Exmine_Unit" text,
    "Exmine_Allow_From" text,
    "Exmine_Allow_To" text,
    "Result" text,
    "Accept" text,
    "Exmine" bigint,
    "Quality" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.quality_details OWNER TO postgres;

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

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


ALTER TABLE public.quality_details_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.quality_details_id_seq OWNED BY public.quality_details.id;


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

CREATE TABLE public.quote_images (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Payment_Method" text NOT NULL,
    "Note" text,
    "Product_Numbers" text NOT NULL,
    "Total_Qty" text NOT NULL,
    "Total_Discount" text NOT NULL,
    "Total_BF_Taxes" text NOT NULL,
    "Total_Taxes" text NOT NULL,
    "Total_Price" text NOT NULL,
    "Client" text NOT NULL,
    "User" text NOT NULL,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Pay" text,
    "Safe" text,
    "Executor" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    presenter text,
    annual_interest text,
    monthly_installment text,
    "Years_Number" text,
    total text,
    "installment_Num" text,
    "Date_First_installment" text,
    "Later_Due" text,
    "Sale_Date" text,
    "Total_Wight_Bill" text,
    "ToSales" text,
    "Shipping" text,
    "Delivery_Status" text,
    "Order_Type" text,
    "ProfitPrecent" text,
    "InstallCompany" text,
    "ContractNumber" text,
    "PayFees" text,
    "ServiceFee" text,
    "CompanyPrecent" text,
    "Time" text,
    "TaxBill" text,
    "TaxCode" text,
    "TaxOnTotal" text,
    "TaxOnTotalType" text,
    "Check_Type" text,
    "Due_Date" text,
    "Check_Number" text,
    "Shift_Code" text,
    "Client_Address" text,
    "Delivery" text,
    "ProfitTax" text,
    "Branch" text,
    "CustomerGroup" text,
    "Total_Cost" text,
    "File" text,
    "Edit" text DEFAULT 0,
    "Delete" text DEFAULT 0,
    "Edit_New_Code" text,
    "Total_Net" text,
    "Residual" text,
    "Current_Credit" text,
    "DiscountTax" text,
    "Draw" text,
    "Status" text,
    "Refernce_Number" text,
    "Ship" text,
    "DiscountBill" text DEFAULT 0,
    "Client_Accept" text DEFAULT 0,
    "Done" text DEFAULT 0,
    "EMP_Quote" text
);


ALTER TABLE public.quote_images OWNER TO postgres;

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

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


ALTER TABLE public.quote_images_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.quote_images_arr_seq OWNED BY public.quote_images.arr;


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

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


ALTER TABLE public.quote_images_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.quote_images_id_seq OWNED BY public.quote_images.id;


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

CREATE TABLE public.quotes (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Payment_Method" text NOT NULL,
    "Status" text NOT NULL,
    "Refernce_Number" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Pay" text,
    "Safe" bigint NOT NULL,
    "Client" bigint NOT NULL,
    "Delegate" bigint,
    "Executor" bigint,
    "Store" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    presenter text,
    annual_interest text,
    monthly_installment text,
    "Years_Number" text,
    total text,
    "installment_Num" text,
    "Date_First_installment" text,
    "Later_Due" text,
    "Sale_Date" text,
    "Total_Wight_Bill" text,
    "ToSales" text,
    "Shipping" text,
    "Delivery_Status" text,
    "Order_Type" text,
    "ProfitPrecent" text,
    "InstallCompany" text,
    "ContractNumber" text,
    "PayFees" text,
    "ServiceFee" text,
    "CompanyPrecent" text,
    "Time" text,
    "TaxBill" text,
    "TaxCode" text,
    "TaxOnTotal" text,
    "TaxOnTotalType" text,
    "Check_Type" text,
    "Due_Date" text,
    "Check_Number" text,
    "Shift_Code" text,
    "Client_Address" text,
    "Delivery" text,
    "ProfitTax" text,
    "Branch" text,
    "CustomerGroup" text,
    "Total_Cost" text,
    "File" text,
    "Edit" text DEFAULT 0,
    "Delete" text DEFAULT 0,
    "Edit_New_Code" text,
    "Total_Net" text,
    "Residual" text,
    "Current_Credit" text,
    "DiscountTax" text,
    "Ship" text,
    "DiscountBill" text DEFAULT 0,
    "Shipping_Price" text,
    "Email" text,
    "Phone" text,
    "Expire_Date" text,
    "Care" text,
    "Location" text,
    "Desc" text
);


ALTER TABLE public.quotes OWNER TO postgres;

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

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


ALTER TABLE public.quotes_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.quotes_arr_seq OWNED BY public.quotes.arr;


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

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


ALTER TABLE public.quotes_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.quotes_id_seq OWNED BY public.quotes.id;


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

CREATE TABLE public.rabih_education (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Video" text,
    "Package" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.rabih_education OWNER TO postgres;

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

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


ALTER TABLE public.rabih_education_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.rabih_education_id_seq OWNED BY public.rabih_education.id;


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

CREATE TABLE public.rates (
    id bigint NOT NULL,
    "Rate" text NOT NULL,
    "Product" bigint,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.rates OWNER TO postgres;

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

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


ALTER TABLE public.rates_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.rates_id_seq OWNED BY public.rates.id;


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

CREATE TABLE public.real_sate_projects (
    id bigint NOT NULL,
    "Code" text,
    "Name" text,
    "Start_Date" text,
    "End_Date" text,
    "Period" text,
    "Value" text,
    "Expect_Cost" text,
    "Expect_Profit" text,
    "Project_File" text,
    "Contract_File" text,
    "Contract_Type" text,
    "Completed" text,
    "Account" text,
    "Goods_Account" text,
    "Client" text,
    "Client_Account" text,
    "Manager" text,
    "Reponsible" text,
    "Store" text,
    "Contract_Status" text,
    "Project_Status" text,
    "Cost_Center" text,
    "Governrate" text,
    "City" text,
    "Place" text,
    "Location" text,
    "Address_Details" text,
    "Coin" text,
    "Draw" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Contractor_Account" text,
    "Category" text
);


ALTER TABLE public.real_sate_projects OWNER TO postgres;

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

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


ALTER TABLE public.real_sate_projects_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.real_sate_projects_id_seq OWNED BY public.real_sate_projects.id;


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

CREATE TABLE public.real_sate_projects_payments (
    id bigint NOT NULL,
    "Date" text,
    "Value" text,
    "Status" text,
    "Project" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.real_sate_projects_payments OWNER TO postgres;

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

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


ALTER TABLE public.real_sate_projects_payments_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.real_sate_projects_payments_id_seq OWNED BY public.real_sate_projects_payments.id;


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

CREATE TABLE public.real_state_default_data (
    id bigint NOT NULL,
    "Draw" text,
    "Coin" text,
    "Safe" text,
    "Contract_Type" text,
    "Manager" text,
    "Reponsible" text,
    "Store" text,
    "Contract_Status" text,
    "Project_Status" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.real_state_default_data OWNER TO postgres;

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

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


ALTER TABLE public.real_state_default_data_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.real_state_default_data_id_seq OWNED BY public.real_state_default_data.id;


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

CREATE TABLE public.real_units (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "System" text,
    "Arabic_Name" text,
    "English_Name" text,
    "Area" text,
    "Category" text,
    "Sort" text,
    "Owner" text,
    "OwnerType" text,
    "OwnerPrecent" text,
    "PlaceReal" text,
    "Gov" text,
    "City" text,
    "Place" text,
    "Address" text,
    "Level" text,
    "Elevator" text,
    "Parking" text,
    "Arabic_Desc" text,
    "English_Desc" text,
    "Video_Link" text,
    "Image" text,
    "License" text,
    "Map" text,
    "Website" text,
    "Price_Sale" text,
    "Daily_Rent_Price" text,
    "Weekly_Rent_Price" text,
    "Monthly_Rent_Price" text,
    "Quarter_Year_Rent_Price" text,
    "Half_Year_Rent_Price" text,
    "Year_Rent_Price" text,
    "Rooms_Num" text,
    "Kitchens_Num" text,
    "Bathrooms_Num" text,
    "Levels_Num" text,
    "Apartments_Num" text,
    "Buliding_Age" text,
    "Activity" text,
    "Activity_Type" text,
    "Cultivated_Area" text,
    "Crop_Type" text,
    "Residential_House" text,
    "Inverter_Room" text,
    "Solar_Energy" text,
    "Diesel_Machine" text,
    "Government_Electricity" text,
    "Irrigation_Type" text,
    "Water_Quality" text,
    "Account" text,
    "StartRentDate" text,
    "EndRentDate" text,
    "Status" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "RentAccount" text
);


ALTER TABLE public.real_units OWNER TO postgres;

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

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


ALTER TABLE public.real_units_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.real_units_id_seq OWNED BY public.real_units.id;


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

CREATE TABLE public.real_units_services (
    id bigint NOT NULL,
    "Unit" text,
    "Service" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.real_units_services OWNER TO postgres;

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

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


ALTER TABLE public.real_units_services_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.real_units_services_id_seq OWNED BY public.real_units_services.id;


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

CREATE TABLE public.reasons (
    id bigint NOT NULL,
    "Arabic_Name" text NOT NULL,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.reasons OWNER TO postgres;

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

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


ALTER TABLE public.reasons_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reasons_id_seq OWNED BY public.reasons.id;


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

CREATE TABLE public.recipt_maintaince_errors (
    id bigint NOT NULL,
    "Recipt" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Error" bigint NOT NULL,
    "Recived" text DEFAULT 0,
    "Eng" text DEFAULT 0
);


ALTER TABLE public.recipt_maintaince_errors OWNER TO postgres;

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

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


ALTER TABLE public.recipt_maintaince_errors_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recipt_maintaince_errors_id_seq OWNED BY public.recipt_maintaince_errors.id;


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

CREATE TABLE public.recipt_maintainces (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Note" text,
    "Serial_Num" text,
    "Total" text NOT NULL,
    "Draw" text NOT NULL,
    "Company" bigint,
    "Device_Type" bigint,
    "Device_Case" bigint,
    "Coin" bigint,
    "Cost_Center" bigint,
    "Account" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Status" text DEFAULT 0,
    "Pattern_Image" text,
    "Time" text,
    "Password" text,
    "Pay" text,
    "Eng_Note" text,
    "Reason" text,
    "Report_Client" text,
    "Work" text,
    "Store" bigint,
    "Eng" bigint,
    "Recipient" bigint,
    "Branch" bigint,
    "Payment_Method" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_Bf_Taxes" text,
    "Total_Taxes" text,
    "RefuseReason" text,
    "NoteRecived" text,
    "Returned" text DEFAULT 0,
    "CustomerGroup" text,
    "Total_Cost" text
);


ALTER TABLE public.recipt_maintainces OWNER TO postgres;

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

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


ALTER TABLE public.recipt_maintainces_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recipt_maintainces_arr_seq OWNED BY public.recipt_maintainces.arr;


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

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


ALTER TABLE public.recipt_maintainces_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recipt_maintainces_id_seq OWNED BY public.recipt_maintainces.id;


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

CREATE TABLE public.recipt_voucher_details (
    id bigint NOT NULL,
    "Creditor" text NOT NULL,
    "Statement" text,
    "Account" bigint NOT NULL,
    "RV_ID" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Bill_Num" text
);


ALTER TABLE public.recipt_voucher_details OWNER TO postgres;

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

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


ALTER TABLE public.recipt_voucher_details_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recipt_voucher_details_id_seq OWNED BY public.recipt_voucher_details.id;


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

CREATE TABLE public.recipt_vouchers (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Total_Creditor" text NOT NULL,
    "Note" text,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "Safe" bigint NOT NULL,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Store" text,
    "Shift" text,
    "User" text,
    "Status" text,
    "File" text,
    "Collector" text,
    "Edit" text,
    "Delete" text,
    "Edit_New_Code" text,
    "Sales_Bill" text,
    "Show_Num" text
);


ALTER TABLE public.recipt_vouchers OWNER TO postgres;

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

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


ALTER TABLE public.recipt_vouchers_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recipt_vouchers_arr_seq OWNED BY public.recipt_vouchers."Code";


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

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


ALTER TABLE public.recipt_vouchers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recipt_vouchers_id_seq OWNED BY public.recipt_vouchers.id;


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

CREATE TABLE public.recipts_sales_petrols (
    id bigint NOT NULL,
    "Recipt_Amount" text NOT NULL,
    "Recipt" bigint,
    "SalesPetrol" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.recipts_sales_petrols OWNER TO postgres;

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

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


ALTER TABLE public.recipts_sales_petrols_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recipts_sales_petrols_id_seq OWNED BY public.recipts_sales_petrols.id;


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

CREATE TABLE public.recipts_types (
    id bigint NOT NULL,
    "Name" text,
    "Account" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "NameEn" text
);


ALTER TABLE public.recipts_types OWNER TO postgres;

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

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


ALTER TABLE public.recipts_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recipts_types_id_seq OWNED BY public.recipts_types.id;


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

CREATE TABLE public.recived_purch_products (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text,
    "Recived_Qty" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total" text,
    "Total_Tax" text,
    "Exp_Date" text,
    "Store" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Recived" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.recived_purch_products OWNER TO postgres;

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

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


ALTER TABLE public.recived_purch_products_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recived_purch_products_id_seq OWNED BY public.recived_purch_products.id;


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

CREATE TABLE public.recived_purchts (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Total_Trans_Qty" text NOT NULL,
    "Total_Trans_Value" text NOT NULL,
    "Purchase" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "User" bigint,
    arr bigint
);


ALTER TABLE public.recived_purchts OWNER TO postgres;

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

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


ALTER TABLE public.recived_purchts_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recived_purchts_arr_seq OWNED BY public.recived_purchts.arr;


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

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


ALTER TABLE public.recived_purchts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recived_purchts_id_seq OWNED BY public.recived_purchts.id;


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

CREATE TABLE public.recived_sales (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Total_Trans_Qty" text NOT NULL,
    "Total_Trans_Value" text NOT NULL,
    "Total_BF_Taxes" text NOT NULL,
    "Total_Taxes" text NOT NULL,
    "Sales" bigint NOT NULL,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "User" bigint
);


ALTER TABLE public.recived_sales OWNER TO postgres;

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

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


ALTER TABLE public.recived_sales_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recived_sales_arr_seq OWNED BY public.recived_sales.arr;


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

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


ALTER TABLE public.recived_sales_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recived_sales_id_seq OWNED BY public.recived_sales.id;


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

CREATE TABLE public.recived_sales_products (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text,
    "Recived_Qty" text,
    "AvQty" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total" text,
    "Total_Tax" text,
    "Exp_Date" text,
    "Store" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Recived" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.recived_sales_products OWNER TO postgres;

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

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


ALTER TABLE public.recived_sales_products_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recived_sales_products_id_seq OWNED BY public.recived_sales_products.id;


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

CREATE TABLE public.recived_shipment_goods (
    id bigint NOT NULL,
    "Shipment_ID" text,
    "Code" text,
    "Barcode" text,
    "Total_Weight" text,
    "Total_Pieces" text,
    "Total_Cost" text,
    "Client" text,
    "RecivedShipment" text,
    "Status" text,
    "Unloading_Goods_ID" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "PayShip" text
);


ALTER TABLE public.recived_shipment_goods OWNER TO postgres;

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

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


ALTER TABLE public.recived_shipment_goods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recived_shipment_goods_id_seq OWNED BY public.recived_shipment_goods.id;


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

CREATE TABLE public.recived_shipments (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Time" text,
    "Safe" text,
    "Coin" text,
    "Draw" text,
    "Store" text,
    "Delegate" text,
    "Driver" text,
    "Total_Pieces" text,
    "Total_Weight" text,
    "Total_Cost" text,
    "Count_Shipmets" text,
    "Status" text,
    "User" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Type" text,
    "Residual" text
);


ALTER TABLE public.recived_shipments OWNER TO postgres;

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

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


ALTER TABLE public.recived_shipments_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recived_shipments_arr_seq OWNED BY public.recived_shipments."Code";


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

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


ALTER TABLE public.recived_shipments_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.recived_shipments_id_seq OWNED BY public.recived_shipments.id;


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

CREATE TABLE public.reg_courses (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Hall" text,
    "Reserve_Course" text,
    "Teacher" text,
    "Teacher_Attend" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Teacher_Attend_From" text,
    "Teacher_Attend_To" text,
    "Teacher_Time" text
);


ALTER TABLE public.reg_courses OWNER TO postgres;

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

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


ALTER TABLE public.reg_courses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reg_courses_id_seq OWNED BY public.reg_courses.id;


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

CREATE TABLE public.reg_courses_students (
    id bigint NOT NULL,
    "Student" text,
    "Attend" text,
    "Date" text,
    "Reg" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.reg_courses_students OWNER TO postgres;

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

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


ALTER TABLE public.reg_courses_students_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reg_courses_students_id_seq OWNED BY public.reg_courses_students.id;


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

CREATE TABLE public.reg_over_times (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Amount" text NOT NULL,
    "Hours_Number" text NOT NULL,
    "Hour_Rate" text NOT NULL,
    "Total_Hours" text NOT NULL,
    "Hour_Cost" text NOT NULL,
    "Note" text,
    "Emp" bigint,
    "Type" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.reg_over_times OWNER TO postgres;

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

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


ALTER TABLE public.reg_over_times_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reg_over_times_arr_seq OWNED BY public.reg_over_times.arr;


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

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


ALTER TABLE public.reg_over_times_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reg_over_times_id_seq OWNED BY public.reg_over_times.id;


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

CREATE TABLE public.remove_products_halls (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "AvQty" text,
    "Qty" text,
    "Price" text,
    "CostPrice" text,
    "Discount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total_Tax" text,
    "Total" text,
    "Store" text,
    "Product" text,
    "Exp_Date" text,
    "V1" text,
    "V2" text,
    "Unit" text,
    "SalesOrder" text,
    "Pro_Note" text,
    "KitchenEnd" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.remove_products_halls OWNER TO postgres;

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

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


ALTER TABLE public.remove_products_halls_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.remove_products_halls_id_seq OWNED BY public.remove_products_halls.id;


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

CREATE TABLE public.rent_contracts (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "System" text,
    "Unit" text,
    "Client" text,
    "Delegate" text,
    "Contract_Num" text,
    "Value" text,
    "Deposit" text,
    "Residual" text,
    "Start_Date" text,
    "End_Date" text,
    "Insurance" text,
    "RentPeriod" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Safe" text,
    "Coin" text,
    "Draw" text,
    "Recipt" text
);


ALTER TABLE public.rent_contracts OWNER TO postgres;

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

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


ALTER TABLE public.rent_contracts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.rent_contracts_id_seq OWNED BY public.rent_contracts.id;


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

CREATE TABLE public.rent_period_reals (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.rent_period_reals OWNER TO postgres;

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

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


ALTER TABLE public.rent_period_reals_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.rent_period_reals_id_seq OWNED BY public.rent_period_reals.id;


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

CREATE TABLE public.reports_settings (
    id bigint NOT NULL,
    "Product_Info" text,
    "Product_Order_Limit" text,
    "ReportStartPeriodProducts" text,
    "SettlementsReports" text,
    "StoresCost" text,
    "StoresInventory" text,
    "Collection_Delegates" text,
    "Sales_Delegates" text,
    "StagnantItems" text,
    "ItemsMoves" text,
    "StoresBalancesTwo" text,
    "NetPurchases" text,
    "NetSales" text,
    "ClientSales" text,
    "ExecutorSales" text,
    "InstallmentReport" text,
    "ExpiredProucts" text,
    "StoresSalesDetails" text,
    "TotalNetPurchases" text,
    "TotalNetSales" text,
    "Profits" text,
    "Shifts" text,
    "Shifts_Details" text,
    "DailyClosing" text,
    "Products" text,
    "DailyShifts" text,
    "ExpensesReport" text,
    "DailyProducts" text,
    "EmployeeCommissionDiscounts" text,
    "VendorPricesReport" text,
    "DailyMoves" text,
    "GroupsSales" text,
    "VendorPurchases" text,
    "ExceptProfits" text,
    "DelegateSalesDetails" text,
    "CreditStores" text,
    "ProductProfits" text,
    "ExceptProductProfits" text,
    "SalesBills" text,
    "PurchasesBills" text,
    "StoresMovesReport" text,
    "StoresTransferReport" text,
    "SafesTransferReport" text,
    "CompareSalesPrice" text,
    "ProductMoveDetails" text,
    "MostSalesProducts" text,
    "ProfitSalesProduct" text,
    "ClientAccountStatement" text,
    "ClientsStatement" text,
    "VendorAccountStatement" text,
    "VendorsStatement" text,
    "EmpGoals" text,
    "InventorySerial" text,
    "TotalExpensesSafes" text,
    "SubIncomList" text,
    "ExpensesList" text,
    "StoresBalances" text,
    "StoresBalancesCat" text,
    "ItemCost" text,
    "StoresInventoryy" text,
    "DelegateSalesDetailss" text,
    "ProfitDelegateSalesDetails" text,
    "InstallmentCompaniesSales" text,
    "StoresCosts" text,
    "DailyClosingDetails" text,
    "SalesProsMoreDetails" text,
    "StagnantItemss" text,
    "SalesCustomersGroups" text,
    "BrandsSales" text,
    "Customer_Debts" text,
    "Vendor_Debts" text,
    "MaintanceSalesReport" text,
    "Maintenance_Tune" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "ProfitGroupsReport" text,
    "IncomListReport" text,
    "AssemblyProQties" text
);


ALTER TABLE public.reports_settings OWNER TO postgres;

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

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


ALTER TABLE public.reports_settings_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reports_settings_id_seq OWNED BY public.reports_settings.id;


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

CREATE TABLE public.reservations (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "From" text,
    "To" text,
    "Amount" text,
    "Checkout" text,
    "Expire" text,
    "Draw" text,
    "Client" bigint,
    "Safe" bigint,
    "Coin" bigint,
    "Room" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "User" text,
    "Note" text
);


ALTER TABLE public.reservations OWNER TO postgres;

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

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


ALTER TABLE public.reservations_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reservations_arr_seq OWNED BY public.reservations.arr;


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

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


ALTER TABLE public.reservations_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reservations_id_seq OWNED BY public.reservations.id;


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

CREATE TABLE public.reserve_course_days (
    id bigint NOT NULL,
    "Day" text,
    "Reserve" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "From_Time" text,
    "To_Time" text
);


ALTER TABLE public.reserve_course_days OWNER TO postgres;

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

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


ALTER TABLE public.reserve_course_days_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reserve_course_days_id_seq OWNED BY public.reserve_course_days.id;


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

CREATE TABLE public.reserve_course_students (
    id bigint NOT NULL,
    "Student" text,
    "Pay" text,
    "Cost" text,
    "Residual" text,
    "Constraint" text,
    "Reserve" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Dollar_Value" text
);


ALTER TABLE public.reserve_course_students OWNER TO postgres;

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

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


ALTER TABLE public.reserve_course_students_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reserve_course_students_id_seq OWNED BY public.reserve_course_students.id;


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

CREATE TABLE public.reserve_courses (
    id bigint NOT NULL,
    "Code" text,
    "Course" text,
    "Start_Date" text,
    "End_Date" text,
    "Course_Type" text,
    "Teacher" text,
    "Required_Number" text,
    "Certificate" text,
    "Cost" text,
    "Total_Required" text,
    "Status" text,
    "Days" text,
    "Time" text,
    "Total_Paid" text,
    "Total_Num" text,
    "Total_Cost" text,
    "Safe" text,
    "Draw" text,
    "Coin" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Hall" text
);


ALTER TABLE public.reserve_courses OWNER TO postgres;

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

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


ALTER TABLE public.reserve_courses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.reserve_courses_id_seq OWNED BY public.reserve_courses.id;


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

CREATE TABLE public.resignation_requests (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Resignation_Date" text,
    "File" text,
    "Emp" text,
    "Note" text,
    "Status" text,
    "Reason" text,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resignation_requests OWNER TO postgres;

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

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


ALTER TABLE public.resignation_requests_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resignation_requests_arr_seq OWNED BY public.resignation_requests."Code";


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

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


ALTER TABLE public.resignation_requests_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resignation_requests_id_seq OWNED BY public.resignation_requests.id;


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

CREATE TABLE public.resturant_abouts (
    id bigint NOT NULL,
    "Image_1" text,
    "Image_2" text,
    "Title_Image" text,
    "Arabic_Title" text,
    "English_Title" text,
    "Arabic_Desc" text,
    "English_Desc" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_abouts OWNER TO postgres;

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

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


ALTER TABLE public.resturant_abouts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_abouts_id_seq OWNED BY public.resturant_abouts.id;


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

CREATE TABLE public.resturant_blogs (
    id bigint NOT NULL,
    "Image" text,
    "Sub_Image" text,
    "Date" text,
    "Arabic_Title" text,
    "English_Title" text,
    "Arabic_Desc" text,
    "English_Desc" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_blogs OWNER TO postgres;

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

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


ALTER TABLE public.resturant_blogs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_blogs_id_seq OWNED BY public.resturant_blogs.id;


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

CREATE TABLE public.resturant_cart_check_styles (
    id bigint NOT NULL,
    "Cart_BG_Type" text,
    "Cart_BG_Image" text,
    "Cart_BG_Color" text,
    "Cart_Title_Color" text,
    "Cart_Txt_Color" text,
    "Cart_Top_Image" text,
    "Cart_Box_BG" text,
    "Cart_Box_Border" text,
    "Cart_Table_Color" text,
    "Cart_Table_BG" text,
    "Cart_Btn_BG" text,
    "Cart_Btn_Color" text,
    "Checkout_Image" text,
    "Checkout_Title_Color" text,
    "Checkout_BG_Type" text,
    "Checkout_BG_Image" text,
    "Checkout_BG_Color" text,
    "Checkout_Box_BG" text,
    "Checkout_Box_Border" text,
    "Checkout_Input_BG" text,
    "Checkout_Input_Color" text,
    "Checkout_Btn_Color" text,
    "Checkout_Btn_BG" text,
    "Checkout_Txt_Color" text,
    "Checkout_Txt_Hover_Color" text,
    "Checkout_Price_Color" text,
    "MyAccount_BG_Type" text,
    "MyAccount_BG_Image" text,
    "MyAccount_BG_Color" text,
    "MyAccount_Box_BG" text,
    "MyAccount_Box_Border" text,
    "MyAccount_Table_BG" text,
    "MyAccount_Table_Color" text,
    "MyAccount_Table_Head_BG" text,
    "MyAccount_Table_Head_Color" text,
    "MyAccount_Txt_Color" text,
    "MyAccount_Btn_BG" text,
    "MyAccount_Btn_Color" text,
    "MyAccount_Input_BG" text,
    "MyAccount_Input_Color" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Collapse_BG" text,
    "Collapse_Border" text,
    "Collapse_Color" text
);


ALTER TABLE public.resturant_cart_check_styles OWNER TO postgres;

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

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


ALTER TABLE public.resturant_cart_check_styles_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_cart_check_styles_id_seq OWNED BY public.resturant_cart_check_styles.id;


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

CREATE TABLE public.resturant_carts (
    id bigint NOT NULL,
    "Product" text,
    "Name" text,
    "NameEn" text,
    "V_ID" text,
    "P_Code" text,
    "Qty" text,
    "Price" text,
    "Image" text,
    "Total" text,
    "User" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_carts OWNER TO postgres;

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

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


ALTER TABLE public.resturant_carts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_carts_id_seq OWNED BY public.resturant_carts.id;


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

CREATE TABLE public.resturant_cupon_codes (
    id bigint NOT NULL,
    "Code" text,
    "Amount" text,
    "Status" text,
    "Num" text,
    "Used" text,
    "Expire" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_cupon_codes OWNER TO postgres;

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

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


ALTER TABLE public.resturant_cupon_codes_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_cupon_codes_id_seq OWNED BY public.resturant_cupon_codes.id;


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

CREATE TABLE public.resturant_galleries (
    id bigint NOT NULL,
    "Image" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_galleries OWNER TO postgres;

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

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


ALTER TABLE public.resturant_galleries_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_galleries_id_seq OWNED BY public.resturant_galleries.id;


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

CREATE TABLE public.resturant_homes (
    id bigint NOT NULL,
    "Image_1" text,
    "Image_2" text,
    "Image_3" text,
    "Image_4" text,
    "Title_Image" text,
    "Arabic_Title" text,
    "English_Title" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "English_Sub_Title" text,
    "Arabic_Sub_Title" text,
    "Year" text
);


ALTER TABLE public.resturant_homes OWNER TO postgres;

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

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


ALTER TABLE public.resturant_homes_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_homes_id_seq OWNED BY public.resturant_homes.id;


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

CREATE TABLE public.resturant_index_style_i_i_s (
    id bigint NOT NULL,
    "About_Body_BG_Type" text,
    "About_Body_BG_Image" text,
    "About_Body_BG_Color" text,
    "About_Txt_Color" text,
    "Gallery_Border_Color" text,
    "Reviews_Image_1" text,
    "Reviews_Image_2" text,
    "Reviews_Nxt_Prev_Color" text,
    "Reviews_Nxt_Prev_BG" text,
    "Reviews_Nxt_Prev_Border" text,
    "Reviews_Txt_Color" text,
    "Reviews_Body_BG_Type" text,
    "Reviews_Body_BG_Image" text,
    "Reviews_Body_BG_Color" text,
    "Reservations_Body_BG_Type" text,
    "Reservations_Body_BG_Image" text,
    "Reservations_Body_BG_Color" text,
    "Reservations_Box_BG" text,
    "Reservations_Input_BG" text,
    "Reservations_Input_Color" text,
    "Reservations_Btn_Color" text,
    "Reservations_Btn_BG" text,
    "Blogs_Home_Body_BG_Type" text,
    "Blogs_Home_Body_BG_Image" text,
    "Blogs_Home_Body_BG_Color" text,
    "Blogs_Home_Box_BG_Color" text,
    "Blogs_Home_Box_Border_Color" text,
    "Blogs_Home_Txt_Color" text,
    "Blogs_Home_Txt_Hover_Color" text,
    "Blogs_Home_Btn_BG" text,
    "Blogs_Home_Btn_Color" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_index_style_i_i_s OWNER TO postgres;

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

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


ALTER TABLE public.resturant_index_style_i_i_s_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_index_style_i_i_s_id_seq OWNED BY public.resturant_index_style_i_i_s.id;


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

CREATE TABLE public.resturant_index_style_i_s (
    id bigint NOT NULL,
    "Home_1_Nxt_Prev_Color" text,
    "Home_1_Nxt_Prev_BG" text,
    "Home_1_Nxt_Prev_Border" text,
    "Home_2_Image_1" text,
    "Home_2_Image_2" text,
    "Home_2_Image_Arrow" text,
    "Home_2_Number_BG" text,
    "Home_2_Image_Border" text,
    "Home_2_Number_Color" text,
    "Category_Bar_BG" text,
    "Category_Bar_Color" text,
    "Video_Section_Body_BG_Type" text,
    "Video_Section_Body_BG_Image" text,
    "Video_Section_Body_BG_Color" text,
    "Video_Section_Image_1" text,
    "Video_Section_Image_2" text,
    "Menu_Index_Body_BG_Type" text,
    "Menu_Index_Body_BG_Image" text,
    "Menu_Index_Body_BG_Color" text,
    "Menu_Index_Txt_Color" text,
    "Menu_Index_Txt_Hover_Color" text,
    "Menu_Index_Btn_BG" text,
    "Menu_Index_Btn_Txt_Color" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Icon_Image" text
);


ALTER TABLE public.resturant_index_style_i_s OWNER TO postgres;

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

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


ALTER TABLE public.resturant_index_style_i_s_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_index_style_i_s_id_seq OWNED BY public.resturant_index_style_i_s.id;


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

CREATE TABLE public.resturant_menu_styles (
    id bigint NOT NULL,
    "Menu_1_BG_Type" text,
    "Menu_1_BG_Image" text,
    "Menu_1_BG_Color" text,
    "Menu_1_Image" text,
    "Menu_1_Icon_Image" text,
    "Menu_1_Title" text,
    "Menu_1_Bar_BG" text,
    "Menu_1_Bar_Color" text,
    "Menu_1_Btn_BG" text,
    "Menu_1_Btn_Color" text,
    "Menu_1_Icon_Color" text,
    "Menu_1_Icon_Hover_Color" text,
    "Menu_1_Icon_Active_Color" text,
    "Menu_1_Price_Color" text,
    "Menu_1_Offer_Price_Color" text,
    "Menu_2_Gallery_Border" text,
    "Menu_2_BG_Type" text,
    "Menu_2_BG_Image" text,
    "Menu_2_BG_Color" text,
    "Menu_2_Title" text,
    "Menu_2_Category_Color" text,
    "Menu_2_Category_Hover_Color" text,
    "Menu_2_Category_Active_Color" text,
    "Menu_2_Lines_Color" text,
    "Menu_2_Btn_BG" text,
    "Menu_2_Btn_Color" text,
    "Menu_2_Name_BG" text,
    "Menu_2_Name_Color" text,
    "Menu_2_Icon_Color" text,
    "Menu_2_Icon_Hover_Color" text,
    "Menu_2_Icon_Active_Color" text,
    "Menu_2_Price_Color" text,
    "Menu_2_Offer_Price_Color" text,
    "Menu_3_BG_Type" text,
    "Menu_3_BG_Image" text,
    "Menu_3_BG_Color" text,
    "Menu_3_Image" text,
    "Menu_3_Icon_Image" text,
    "Menu_3_Title" text,
    "Menu_3_Category_Color" text,
    "Menu_3_Category_Hover_Color" text,
    "Menu_3_Category_Active_Color" text,
    "Menu_3_Box_BG" text,
    "Menu_3_Box_Color" text,
    "Menu_3_Btn_BG" text,
    "Menu_3_Btn_Color" text,
    "Menu_3_Icon_Color" text,
    "Menu_3_Icon_Hover_Color" text,
    "Menu_3_Icon_Active_Color" text,
    "Menu_3_Price_Color" text,
    "Menu_3_Offer_Price_Color" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_menu_styles OWNER TO postgres;

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

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


ALTER TABLE public.resturant_menu_styles_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_menu_styles_id_seq OWNED BY public.resturant_menu_styles.id;


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

CREATE TABLE public.resturant_nav_foot_styles (
    id bigint NOT NULL,
    "Navbar_BG" text,
    "Navbar_Txt_Color" text,
    "Navbar_Txt_Hover_Color" text,
    "Navbar_Btn_BG" text,
    "Navbar_Btn_Color" text,
    "Navbar_Sub_Menu_BG" text,
    "Navbar_Sub_Menu_Color" text,
    "Footer_BG_Type" text,
    "Footer_BG_Color" text,
    "Footer_BG_Image" text,
    "Footer_Title_Color" text,
    "Footer_Txt_Color" text,
    "Footer_Social_Color" text,
    "Footer_Social_Hover_Color" text,
    "Footer_CopyRight_Color" text,
    "Footer_CopyRight_Company_Color" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_nav_foot_styles OWNER TO postgres;

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

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


ALTER TABLE public.resturant_nav_foot_styles_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_nav_foot_styles_id_seq OWNED BY public.resturant_nav_foot_styles.id;


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

CREATE TABLE public.resturant_privacies (
    id bigint NOT NULL,
    "Arabic_Desc" text,
    "English_Desc" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_privacies OWNER TO postgres;

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

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


ALTER TABLE public.resturant_privacies_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_privacies_id_seq OWNED BY public.resturant_privacies.id;


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

CREATE TABLE public.resturant_reservations (
    id bigint NOT NULL,
    "Name" text,
    "Phone" text,
    "Persons" text,
    "Date" text,
    "Time" text,
    "Message" text,
    "Approve" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_reservations OWNER TO postgres;

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

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


ALTER TABLE public.resturant_reservations_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_reservations_id_seq OWNED BY public.resturant_reservations.id;


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

CREATE TABLE public.resturant_reviews (
    id bigint NOT NULL,
    "Image" text,
    "Arabic_Name" text,
    "English_Name" text,
    "Arabic_Desc" text,
    "English_Desc" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_reviews OWNER TO postgres;

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

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


ALTER TABLE public.resturant_reviews_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_reviews_id_seq OWNED BY public.resturant_reviews.id;


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

CREATE TABLE public.resturant_sliders (
    id bigint NOT NULL,
    "Status" text,
    "Arabic_Title" text,
    "English_Title" text,
    "Arabic_Desc" text,
    "English_Desc" text,
    "Image" text,
    "Type" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_sliders OWNER TO postgres;

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

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


ALTER TABLE public.resturant_sliders_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_sliders_id_seq OWNED BY public.resturant_sliders.id;


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

CREATE TABLE public.resturant_socials (
    id bigint NOT NULL,
    "Facebook" text,
    "Twitter" text,
    "Instagram" text,
    "Youtube" text,
    "Snapchat" text,
    "Whatsapp" text,
    "Google_Plus" text,
    "LinkedIn" text,
    "Pinterest" text,
    "Telegram" text,
    "iOS" text,
    "Android" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_socials OWNER TO postgres;

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

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


ALTER TABLE public.resturant_socials_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_socials_id_seq OWNED BY public.resturant_socials.id;


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

CREATE TABLE public.resturant_styles (
    id bigint NOT NULL,
    "Font" text,
    "Home" text,
    "Menu" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Reviews" text,
    "Privacy" text,
    "Terms" text,
    "Gallery" text,
    "Blogs" text,
    "Cart" text,
    "PDF" text,
    "Reservations" text,
    "Body_BG_Type" text,
    "Modal_Txt_Color" text,
    "Modal_BG_Color" text,
    "Pagination_Active_Txt_Color" text,
    "Pagination_Active_BG_Color" text,
    "Pagination_Txt_Color" text,
    "Pagination_BG_Color" text,
    "Body_Title_Color" text,
    "Modal_Button_Txt_Color" text,
    "Modal_Button_BG_Color" text,
    "Form_Input_Txt_Color" text,
    "Form_Input_BG" text,
    "Form_Txt_Hover_Color" text,
    "Form_Txt_Color" text,
    "Form_Box_Border_Color" text,
    "Form_Box_BG" text,
    "Preloader_Circle_3_Color" text,
    "Preloader_Circle_2_Color" text,
    "Preloader_Circle_1_Color" text,
    "Form_Btn_Txt_Color" text,
    "Form_Btn_BG" text,
    "Body_BG_Image" text,
    "Body_BG_Color" text
);


ALTER TABLE public.resturant_styles OWNER TO postgres;

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

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


ALTER TABLE public.resturant_styles_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_styles_id_seq OWNED BY public.resturant_styles.id;


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

CREATE TABLE public.resturant_sup_page_styles (
    id bigint NOT NULL,
    "Blogs_BG_Type" text,
    "Blogs_BG_Image" text,
    "Blogs_BG_Color" text,
    "Blogs_Title_Color" text,
    "Blogs_Top_Image" text,
    "Blogs_Box_BG" text,
    "Blogs_Box_Border" text,
    "Blogs_Box_Txt_Color" text,
    "Blogs_Box_Txt_Hover_Color" text,
    "Blogs_Btn_Color" text,
    "Blogs_Btn_BG" text,
    "Blogs_Details_Box_BG" text,
    "Blogs_Details_Box_Border" text,
    "Blogs_Details_Box_Txt_Color" text,
    "Reviews_Top_Image" text,
    "Reviews_Title_Color" text,
    "Reviews_BG_Type" text,
    "Reviews_BG_Image" text,
    "Reviews_BG_Color" text,
    "Reviews_Box_BG" text,
    "Reviews_Box_Border" text,
    "Reviews_Icon_Color" text,
    "Gallery_Top_Image" text,
    "Gallery_Title_Color" text,
    "Gallery__BG_Type" text,
    "Gallery__BG_Image" text,
    "Gallery__BG_Color" text,
    "Terms_Privacy_Top_Image" text,
    "Terms_Privacy_Title_Color" text,
    "Terms_Privacy_Box_BG" text,
    "Terms_Privacy_Box_Border" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_sup_page_styles OWNER TO postgres;

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

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


ALTER TABLE public.resturant_sup_page_styles_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_sup_page_styles_id_seq OWNED BY public.resturant_sup_page_styles.id;


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

CREATE TABLE public.resturant_tables (
    id bigint NOT NULL,
    "Table_Number" text,
    "Arabic_Name" text,
    "English_Name" text,
    "Place_Ar" text,
    "Place_En" text,
    "Chairs_Num" text,
    "QR" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_tables OWNER TO postgres;

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

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


ALTER TABLE public.resturant_tables_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_tables_id_seq OWNED BY public.resturant_tables.id;


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

CREATE TABLE public.resturant_terms (
    id bigint NOT NULL,
    "Arabic_Desc" text,
    "English_Desc" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_terms OWNER TO postgres;

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

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


ALTER TABLE public.resturant_terms_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_terms_id_seq OWNED BY public.resturant_terms.id;


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

CREATE TABLE public.resturant_video_sections (
    id bigint NOT NULL,
    "BG_Image" text,
    "Icon" text,
    "Title_Image" text,
    "Video_Link" text,
    "Image_1" text,
    "Image_2" text,
    "Image_3" text,
    "Image_4" text,
    "Number_1" text,
    "Number_2" text,
    "Number_3" text,
    "Number_4" text,
    "Arabic_Title_1" text,
    "Arabic_Title_2" text,
    "Arabic_Title_3" text,
    "Arabic_Title_4" text,
    "English_Title_1" text,
    "English_Title_2" text,
    "English_Title_3" text,
    "English_Title_4" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.resturant_video_sections OWNER TO postgres;

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

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


ALTER TABLE public.resturant_video_sections_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resturant_video_sections_id_seq OWNED BY public.resturant_video_sections.id;


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

CREATE TABLE public.return_maintaince_bills (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Note" text,
    "Serial_Num" text,
    "Pattern_Image" text,
    "Time" text,
    "Payment_Method" text,
    "Password" text,
    "Pay" text,
    "Work" text,
    "Total" text,
    "Total_Cost" text,
    "Cost_Precent" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_Bf_Taxes" text,
    "Total_Taxes" text,
    "Draw" text,
    "Bill" text,
    "Company" bigint,
    "Device_Type" bigint,
    "Device_Case" bigint,
    "Coin" bigint,
    "Cost_Center" bigint,
    "Account" bigint,
    "Store" bigint,
    "Eng" bigint,
    "Recipient" bigint,
    "Branch" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "CustomerGroup" text,
    "Total_Talf" text
);


ALTER TABLE public.return_maintaince_bills OWNER TO postgres;

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

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


ALTER TABLE public.return_maintaince_bills_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_maintaince_bills_arr_seq OWNED BY public.return_maintaince_bills.arr;


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

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


ALTER TABLE public.return_maintaince_bills_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_maintaince_bills_id_seq OWNED BY public.return_maintaince_bills.id;


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

CREATE TABLE public.return_products_stores_transfers (
    id bigint NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "P_Code" text,
    "Price" text,
    "OldPrice" text,
    "Av_Qty" text,
    "SmallCode" text,
    "ReturnQty" text,
    "Trans_Qty" text,
    "Original_Trans_Qty" text,
    "SmallTrans_Qty" text,
    "Total" text,
    "ST_ID" text,
    "Product" text,
    "V1" text,
    "V2" text,
    "Unit" text,
    "To_Store" text,
    "CostPrice" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.return_products_stores_transfers OWNER TO postgres;

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

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


ALTER TABLE public.return_products_stores_transfers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_products_stores_transfers_id_seq OWNED BY public.return_products_stores_transfers.id;


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

CREATE TABLE public.return_purch_bills_filter_twos (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Total_Return_Qty" text,
    "Total_Return_Value" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Discount" text,
    "Purchase" text,
    "Pay" text,
    "Payment_Method" text,
    "User" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "Refernce_Number" text,
    "Safe" text,
    "Vendor" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "Ship" text,
    "Later_Due" text,
    "Type" text,
    "ID" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.return_purch_bills_filter_twos OWNER TO postgres;

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

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


ALTER TABLE public.return_purch_bills_filter_twos_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_purch_bills_filter_twos_id_seq OWNED BY public.return_purch_bills_filter_twos.id;


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

CREATE TABLE public.return_purch_bills_filters (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Total_Return_Qty" text,
    "Total_Return_Value" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Discount" text,
    "Purchase" text,
    "Pay" text,
    "Payment_Method" text,
    "User" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "Refernce_Number" text,
    "Safe" text,
    "Vendor" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "Ship" text,
    "Later_Due" text,
    "Type" text,
    "ID" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.return_purch_bills_filters OWNER TO postgres;

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

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


ALTER TABLE public.return_purch_bills_filters_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_purch_bills_filters_id_seq OWNED BY public.return_purch_bills_filters.id;


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

CREATE TABLE public.return_purch_products (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text,
    "Return_Qty" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total" text,
    "Total_Tax" text,
    "Exp_Date" text,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Return" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Date" text,
    "Code" text,
    "Refernce_Number" text,
    "Safe" bigint,
    "Vendor" bigint,
    "Delegate" bigint,
    "Coin" bigint,
    "User" bigint,
    "Cost_Center" bigint,
    "Type" text,
    "Ship" bigint,
    "TDiscount" text,
    "TypeEn" text
);


ALTER TABLE public.return_purch_products OWNER TO postgres;

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

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


ALTER TABLE public.return_purch_products_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_purch_products_id_seq OWNED BY public.return_purch_products.id;


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

CREATE TABLE public.return_purches (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Total_Return_Qty" text NOT NULL,
    "Total_Return_Value" text NOT NULL,
    "Total_BF_Taxes" text NOT NULL,
    "Total_Taxes" text NOT NULL,
    "Purchase" bigint NOT NULL,
    "User" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Pay" text,
    "Payment_Method" text,
    "TDiscount" text,
    "Total_Discount" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "Refernce_Number" text,
    "Later_Due" text,
    "Cost_Center" bigint,
    "Safe" bigint,
    "Vendor" bigint,
    "Delegate" bigint,
    "Store" bigint,
    "Coin" bigint,
    arr bigint,
    "Ship" bigint,
    "Delete" text DEFAULT 0,
    "Edit" text DEFAULT 0,
    "Edit_New_Code" text DEFAULT 0,
    "Reason" text
);


ALTER TABLE public.return_purches OWNER TO postgres;

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

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


ALTER TABLE public.return_purches_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_purches_arr_seq OWNED BY public.return_purches.arr;


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

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


ALTER TABLE public.return_purches_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_purches_id_seq OWNED BY public.return_purches.id;


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

CREATE TABLE public.return_resons (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.return_resons OWNER TO postgres;

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

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


ALTER TABLE public.return_resons_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_resons_id_seq OWNED BY public.return_resons.id;


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

CREATE TABLE public.return_sales (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Total_Return_Qty" text NOT NULL,
    "Total_Return_Value" text NOT NULL,
    "Total_BF_Taxes" text NOT NULL,
    "Total_Taxes" text NOT NULL,
    "Sales" bigint NOT NULL,
    "User" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Pay" text,
    "Payment_Method" text,
    "TDiscount" text,
    "Total_Discount" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "Refernce_Number" text,
    "Executor" text,
    "Later_Due" text,
    "InstallCompany" text,
    "Delivery" text,
    "TaxBill" text,
    "TaxCode" text,
    uuid text,
    "longId" text,
    "hashKey" text,
    "submissionId" text,
    "Sent" text,
    "Safe" bigint,
    "Cost_Center" bigint,
    "Client" bigint,
    "Delegate" bigint,
    "Store" bigint,
    "Coin" bigint,
    arr bigint,
    "Ship" bigint,
    "Edit" text,
    "Delete" text,
    "Edit_New_Code" text,
    "Current_Credit" text,
    "Cost" text,
    "TotalCost" text,
    "Reason" text
);


ALTER TABLE public.return_sales OWNER TO postgres;

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

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


ALTER TABLE public.return_sales_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_sales_arr_seq OWNED BY public.return_sales.arr;


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

CREATE TABLE public.return_sales_bills_filter_twos (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Total_Return_Qty" text,
    "Total_Return_Value" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Discount" text,
    "Sales" text,
    "Pay" text,
    "Payment_Method" text,
    "User" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "Refernce_Number" text,
    "Safe" text,
    "Client" text,
    "Executor" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "Ship" text,
    "Later_Due" text,
    "InstallCompany" text,
    "Delivery" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "ID" text,
    "Type" text
);


ALTER TABLE public.return_sales_bills_filter_twos OWNER TO postgres;

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

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


ALTER TABLE public.return_sales_bills_filter_twos_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_sales_bills_filter_twos_id_seq OWNED BY public.return_sales_bills_filter_twos.id;


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

CREATE TABLE public.return_sales_bills_filters (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Total_Return_Qty" text,
    "Total_Return_Value" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Discount" text,
    "Sales" text,
    "Pay" text,
    "Payment_Method" text,
    "User" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "Refernce_Number" text,
    "Safe" text,
    "Client" text,
    "Executor" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "Ship" text,
    "Later_Due" text,
    "InstallCompany" text,
    "Delivery" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Type" text,
    "ID" text
);


ALTER TABLE public.return_sales_bills_filters OWNER TO postgres;

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

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


ALTER TABLE public.return_sales_bills_filters_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_sales_bills_filters_id_seq OWNED BY public.return_sales_bills_filters.id;


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

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


ALTER TABLE public.return_sales_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_sales_id_seq OWNED BY public.return_sales.id;


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

CREATE TABLE public.return_sales_products (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Original_Qty" text,
    "Recived_Qty" text,
    "AvQty" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total" text,
    "Total_Tax" text,
    "Exp_Date" text,
    "Store" bigint,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    "Return" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Code" text,
    "Type" text,
    "Cost_Center" bigint,
    "User" bigint,
    "Delegate" bigint,
    "Executor" bigint,
    "Safe" bigint,
    "Coin" bigint,
    "Date" text,
    "Client" bigint,
    "Refernce_Number" text,
    "Ship" bigint,
    "Patch_Number" text,
    "CoinCode" text,
    "CoinPrice" text,
    "CoinRate" text,
    "AmountEGP" text,
    "DiscountAmount" text,
    "TaxType" text,
    "TaxAmount" text,
    "TaxSubType" text,
    "TaxRate" text,
    "TotalBill" text,
    "SalesTotal" text,
    "NetTotal" text
);


ALTER TABLE public.return_sales_products OWNER TO postgres;

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

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


ALTER TABLE public.return_sales_products_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_sales_products_id_seq OWNED BY public.return_sales_products.id;


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

CREATE TABLE public.return_stors_transfers (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Draw" text,
    "Total" text,
    "TotalQty" text,
    "Note" text,
    "From_Store" text,
    "To_Store" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Status" text,
    "Ship" text,
    "CostShip" text,
    "RecivedShip" text,
    "OldQty" text,
    "Edit" text,
    "Delegate" text,
    "Time" text,
    "Branch" text,
    "Total_Cost" text,
    "TypeTransfer" text,
    "Cost_Store" text,
    "OriginalID" text,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.return_stors_transfers OWNER TO postgres;

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

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


ALTER TABLE public.return_stors_transfers_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_stors_transfers_arr_seq OWNED BY public.return_stors_transfers.arr;


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

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


ALTER TABLE public.return_stors_transfers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_stors_transfers_id_seq OWNED BY public.return_stors_transfers.id;


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

CREATE TABLE public.return_without_bills (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Draw" text,
    "Payment_Method" text,
    "Status" text,
    "Vendor_Bill_Date" text,
    "Refernce_Number" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Total_Cost" text,
    "Pay" text,
    "Safe" text,
    "Vendor" text,
    "Deficit_Account" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Due_Date" text,
    "Later_Due" text,
    "TaxBill" text,
    "TaxCode" text,
    "Time" text,
    "Branch" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" text DEFAULT 0,
    "Current_Credit" text
);


ALTER TABLE public.return_without_bills OWNER TO postgres;

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

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


ALTER TABLE public.return_without_bills_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_without_bills_arr_seq OWNED BY public.return_without_bills."Code";


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

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


ALTER TABLE public.return_without_bills_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.return_without_bills_id_seq OWNED BY public.return_without_bills.id;


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

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


ALTER TABLE public.role_has_permissions OWNER TO postgres;

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

CREATE TABLE public.roles (
    id bigint NOT NULL,
    name character varying(191) NOT NULL,
    guard_name character varying(191) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "nameEn" text
);


ALTER TABLE public.roles OWNER TO postgres;

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

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


ALTER TABLE public.roles_id_seq OWNER TO postgres;

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

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


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

CREATE TABLE public.room_reservations (
    id bigint NOT NULL,
    "Date" text,
    "Room" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.room_reservations OWNER TO postgres;

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

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


ALTER TABLE public.room_reservations_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.room_reservations_id_seq OWNED BY public.room_reservations.id;


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

CREATE TABLE public.rooms (
    id bigint NOT NULL,
    "Code" text,
    "Floor" text,
    "Bulding_Name" text,
    "Adults_Num" text,
    "Childs_Num" text,
    "Beds_Num" text,
    "Desc" text,
    "Price" text,
    "Reserved" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "RoomsType" text,
    "DescEn" text
);


ALTER TABLE public.rooms OWNER TO postgres;

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

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


ALTER TABLE public.rooms_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.rooms_id_seq OWNED BY public.rooms.id;


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

CREATE TABLE public.rooms_types (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.rooms_types OWNER TO postgres;

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

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


ALTER TABLE public.rooms_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.rooms_types_id_seq OWNED BY public.rooms_types.id;


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

CREATE TABLE public.rqst_transports (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Time" text,
    "Arrival_Date" text,
    "Arrival_Time" text,
    "Reference_Num" text,
    "Weight" text,
    "Note" text,
    "Payment_Method" text,
    "Insurance" text,
    "Pay" text,
    "Value" text,
    "Type" text,
    "Sender_Name" text,
    "Sender_Governorate" text,
    "Sender_City" text,
    "Sender_Place" text,
    "Sender_Address" text,
    "Sender_Phone1" text,
    "Sender_Phone2" text,
    "Sender_Location" text,
    "Receiver_Name" text,
    "Receiver_Governorate" text,
    "Receiver_City" text,
    "Receiver_Place" text,
    "Receiver_Address" text,
    "Receiver_Phone1" text,
    "Receiver_Phone2" text,
    "Receiver_Location" text,
    "Safe" text,
    "Coin" text,
    "Draw" text,
    "Cost_Center" text,
    "Driver" text,
    "Car" text,
    "Driver_Precent" text,
    "Driver_Value" text,
    "Contractor" text,
    "Contractor_Precent" text,
    "Contractor_Value" text,
    "Expenses_Precent" text,
    "Expenses_Value" text,
    "The_Net" text,
    "Sender" text,
    "Received" text,
    "Transfer" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "User" text
);


ALTER TABLE public.rqst_transports OWNER TO postgres;

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

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


ALTER TABLE public.rqst_transports_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.rqst_transports_arr_seq OWNED BY public.rqst_transports."Code";


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

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


ALTER TABLE public.rqst_transports_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.rqst_transports_id_seq OWNED BY public.rqst_transports.id;


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

CREATE TABLE public.safe_transfer_columns (
    id bigint NOT NULL,
    "Date" text,
    "Code" text,
    "Time" text,
    "Amount" text,
    "From_Safe" text,
    "To_Safe" text,
    "User" text,
    "Coin" text,
    "Cost_Center" text,
    "Note" text,
    "Delegate" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Branch" text
);


ALTER TABLE public.safe_transfer_columns OWNER TO postgres;

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

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


ALTER TABLE public.safe_transfer_columns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.safe_transfer_columns_id_seq OWNED BY public.safe_transfer_columns.id;


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

CREATE TABLE public.safe_transfer_columns_sechdules (
    id bigint NOT NULL,
    "Date" text,
    "Code" text,
    "Time" text,
    "Amount" text,
    "From_Safe" text,
    "To_Safe" text,
    "User" text,
    "Coin" text,
    "Cost_Center" text,
    "Note" text,
    "Delegate" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Branch" text
);


ALTER TABLE public.safe_transfer_columns_sechdules OWNER TO postgres;

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

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


ALTER TABLE public.safe_transfer_columns_sechdules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.safe_transfer_columns_sechdules_id_seq OWNED BY public.safe_transfer_columns_sechdules.id;


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

CREATE TABLE public.safe_transfer_filter_twos (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Draw" text,
    "Amount" text,
    "Note" text,
    "From_Safe" text,
    "To_Safe" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Status" text,
    "File" text,
    "OldAmount" text,
    "Edit" text,
    "Delegate" text,
    "Time" text,
    "ID" text,
    "Type" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Branch" text
);


ALTER TABLE public.safe_transfer_filter_twos OWNER TO postgres;

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

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


ALTER TABLE public.safe_transfer_filter_twos_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.safe_transfer_filter_twos_id_seq OWNED BY public.safe_transfer_filter_twos.id;


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

CREATE TABLE public.safe_transfer_filters (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Draw" text,
    "Amount" text,
    "Note" text,
    "From_Safe" text,
    "To_Safe" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Status" text,
    "File" text,
    "OldAmount" text,
    "Edit" text,
    "Delegate" text,
    "Time" text,
    "ID" text,
    "Type" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Branch" text
);


ALTER TABLE public.safe_transfer_filters OWNER TO postgres;

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

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


ALTER TABLE public.safe_transfer_filters_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.safe_transfer_filters_id_seq OWNED BY public.safe_transfer_filters.id;


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

CREATE TABLE public.safe_transfers (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Amount" text NOT NULL,
    "Note" text,
    "From_Safe" bigint NOT NULL,
    "To_Safe" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Status" text DEFAULT 0,
    "File" text,
    "OldAmount" text,
    "Edit" text,
    "Time" text,
    "Delegate" bigint,
    arr bigint,
    "Branch" bigint
);


ALTER TABLE public.safe_transfers OWNER TO postgres;

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

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


ALTER TABLE public.safe_transfers_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.safe_transfers_arr_seq OWNED BY public.safe_transfers."Code";


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

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


ALTER TABLE public.safe_transfers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.safe_transfers_id_seq OWNED BY public.safe_transfers.id;


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

CREATE TABLE public.safes_banks (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Name" text NOT NULL,
    "Type" text NOT NULL,
    "Note" text,
    "Account" bigint NOT NULL,
    "User" bigint NOT NULL,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Branch" text,
    "Service_Fee" text,
    "NameEn" text
);


ALTER TABLE public.safes_banks OWNER TO postgres;

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

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


ALTER TABLE public.safes_banks_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.safes_banks_arr_seq OWNED BY public.safes_banks."Code";


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

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


ALTER TABLE public.safes_banks_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.safes_banks_id_seq OWNED BY public.safes_banks.id;


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

CREATE TABLE public.sales (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Payment_Method" text NOT NULL,
    "Status" text NOT NULL,
    "Refernce_Number" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Pay" text,
    presenter text,
    annual_interest text,
    monthly_installment text,
    "Years_Number" text,
    total text,
    "installment_Num" text,
    "Date_First_installment" text,
    "Quote" text,
    "SalesOrder" text,
    "Safe" bigint NOT NULL,
    "Client" bigint NOT NULL,
    "Delegate" bigint,
    "Executor" bigint,
    "Store" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Ship" bigint,
    arr bigint,
    "Check_Type" bigint,
    "Check_Number" text,
    "Due_Date" text,
    "ShipStatus" text DEFAULT 0,
    "Cash" text,
    "Visa" text,
    "Sale_Type" text,
    "Hold" text,
    "Shift_Code" text,
    emp bigint,
    "Store_Code" text,
    "Later_Due" text,
    "Later_Collection" text DEFAULT 1,
    "Client_Address" text,
    "Delivery" text,
    "Delivery_Status" text,
    "Sale_User" text,
    "Sent" text,
    "TaxBill" text DEFAULT 0,
    "TaxCode" text,
    "ProfitPrecent" text,
    "TaxOnTotal" text,
    "TaxOnTotalType" text,
    "ProfitTax" text DEFAULT 0,
    "ContractNumber" text,
    "PayFees" text,
    "ServiceFee" text,
    "CompanyPrecent" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "Total_Cost" text,
    uuid text,
    "longId" text,
    "hashKey" text,
    "submissionId" text,
    "statusBill" text,
    "DiscountTax" text,
    "RecivedDate" text,
    "InstallCompany" bigint,
    "File" text,
    "ResturantOrderType" text,
    "DeliveryTime" text,
    "RecivedOrderTime" text,
    "RecivedOrder" text,
    "KitchenEndTime" text,
    "KitchenEnd" text,
    "Witer" text,
    "TakeawayTime" text,
    "TakeawayStatus" text,
    "Table" bigint,
    "Total_Wight_Bill" text,
    "Edit" text DEFAULT 0,
    "Delete" text DEFAULT 0,
    "Edit_New_Code" text,
    "Total_Net" text,
    "Residual" text,
    "Current_Credit" text,
    "DiscountBill" text DEFAULT 0,
    "ServiceType" text,
    "ServiceFees" text,
    "ServiceValue" text,
    bill_lat text,
    bill_lng text,
    "App" bigint,
    "Shipping_Price" text,
    "Warranty_Expire_Date" text,
    "Use_Qty" text DEFAULT 0
);


ALTER TABLE public.sales OWNER TO postgres;

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

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


ALTER TABLE public.sales_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_arr_seq OWNED BY public.sales.arr;


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

CREATE TABLE public.sales_bills_columns (
    id bigint NOT NULL,
    "Date" text,
    "Code" text,
    "Time" text,
    "Refrence_Number" text,
    "Branch" text,
    "Store" text,
    "Payment_Method" text,
    "Safe" text,
    "Type" text,
    "Shipping" text,
    "Cost_Center" text,
    "ShiftCode" text,
    "Executor" text,
    "User" text,
    "Coin" text,
    "Due_Date" text,
    "Delegate" text,
    "Note" text,
    "Total_Return" text,
    "Total_Price" text,
    "Total_Discount" text,
    "Total_Tax" text,
    "Total_Net" text,
    "Paid" text,
    "Residual" text,
    "Product_Code" text,
    "Product_Name" text,
    "Unit" text,
    "Av_Qty" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Total_BF_Tax" text,
    "Tax" text,
    "Total" text,
    "Group" text,
    "Brand" text,
    "Exp_Date" text,
    "Product_Store" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Client" text,
    "Rate" text,
    "Name_Width" text
);


ALTER TABLE public.sales_bills_columns OWNER TO postgres;

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

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


ALTER TABLE public.sales_bills_columns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_bills_columns_id_seq OWNED BY public.sales_bills_columns.id;


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

CREATE TABLE public.sales_bills_columns_sechdules (
    id bigint NOT NULL,
    "Date" text,
    "Code" text,
    "Time" text,
    "Refrence_Number" text,
    "Branch" text,
    "Store" text,
    "Payment_Method" text,
    "Safe" text,
    "Type" text,
    "Shipping" text,
    "Cost_Center" text,
    "ShiftCode" text,
    "Executor" text,
    "User" text,
    "Coin" text,
    "Due_Date" text,
    "Delegate" text,
    "Note" text,
    "Total_Return" text,
    "Total_Price" text,
    "Total_Discount" text,
    "Total_Tax" text,
    "Total_Net" text,
    "Paid" text,
    "Residual" text,
    "Product_Code" text,
    "Product_Name" text,
    "Unit" text,
    "Av_Qty" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Total_BF_Tax" text,
    "Tax" text,
    "Total" text,
    "Group" text,
    "Brand" text,
    "Exp_Date" text,
    "Product_Store" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Client" text,
    "Rate" text,
    "Name_Width" text
);


ALTER TABLE public.sales_bills_columns_sechdules OWNER TO postgres;

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

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


ALTER TABLE public.sales_bills_columns_sechdules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_bills_columns_sechdules_id_seq OWNED BY public.sales_bills_columns_sechdules.id;


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

CREATE TABLE public.sales_bills_filter_twos (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Payment_Method" text,
    "Status" text,
    "Refernce_Number" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Pay" text,
    "Safe" text,
    "Client" text,
    "Executor" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Ship" text,
    "Shift_Code" text,
    "Later_Due" text,
    "Later_Collection" text,
    "Delivery" text,
    "ProfitPrecent" text,
    "TaxOnTotal" text,
    "TaxOnTotalType" text,
    "ProfitTax" text,
    "InstallCompany" text,
    "ServiceFee" text,
    "CompanyPrecent" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "ID" text,
    "Type" text
);


ALTER TABLE public.sales_bills_filter_twos OWNER TO postgres;

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

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


ALTER TABLE public.sales_bills_filter_twos_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_bills_filter_twos_id_seq OWNED BY public.sales_bills_filter_twos.id;


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

CREATE TABLE public.sales_bills_filters (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Payment_Method" text,
    "Status" text,
    "Refernce_Number" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Pay" text,
    "Safe" text,
    "Client" text,
    "Executor" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Ship" text,
    "Shift_Code" text,
    "Later_Due" text,
    "Later_Collection" text,
    "Delivery" text,
    "ProfitPrecent" text,
    "TaxOnTotal" text,
    "TaxOnTotalType" text,
    "ProfitTax" text,
    "InstallCompany" text,
    "ServiceFee" text,
    "CompanyPrecent" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Type" text,
    "ID" text
);


ALTER TABLE public.sales_bills_filters OWNER TO postgres;

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

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


ALTER TABLE public.sales_bills_filters_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_bills_filters_id_seq OWNED BY public.sales_bills_filters.id;


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

CREATE TABLE public.sales_contracts (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "System" text,
    "Unit" text,
    "Client" text,
    "Delegate" text,
    "Contract_Num" text,
    "Value" text,
    "Deposit" text,
    "Residual" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Safe" text,
    "Coin" text,
    "Draw" text,
    "Recipt" text
);


ALTER TABLE public.sales_contracts OWNER TO postgres;

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

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


ALTER TABLE public.sales_contracts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_contracts_id_seq OWNED BY public.sales_contracts.id;

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

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


ALTER TABLE public.sales_default_data_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_default_data_id_seq OWNED BY public.sales_default_data.id;


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

CREATE TABLE public.sales_fifo_qties (
    id bigint NOT NULL,
    "Sales_Qty" text,
    "Sales_ID" text,
    "Fifo_ID" text,
    "Store" text,
    "Product" text,
    "Cost_Price" text,
    "Purchases_Date" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sales_fifo_qties OWNER TO postgres;

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

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


ALTER TABLE public.sales_fifo_qties_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_fifo_qties_id_seq OWNED BY public.sales_fifo_qties.id;


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

CREATE TABLE public.sales_gifts (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Draw" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Price" text,
    "Total_Cost" text,
    "Client" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "Edit" text DEFAULT '0'::text,
    "Delete" text DEFAULT '0'::text,
    "Edit_New_Code" text,
    "User" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Account" text
);


ALTER TABLE public.sales_gifts OWNER TO postgres;

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

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


ALTER TABLE public.sales_gifts_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_gifts_arr_seq OWNED BY public.sales_gifts."Code";


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

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


ALTER TABLE public.sales_gifts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_gifts_id_seq OWNED BY public.sales_gifts.id;


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

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


ALTER TABLE public.sales_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_id_seq OWNED BY public.sales.id;


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

CREATE TABLE public.sales_maint_fifo_qties (
    id bigint NOT NULL,
    "Sales_Qty" text,
    "Sales_ID" text,
    "Fifo_ID" text,
    "Store" text,
    "Product" text,
    "Cost_Price" text,
    "Purchases_Date" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sales_maint_fifo_qties OWNER TO postgres;

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

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


ALTER TABLE public.sales_maint_fifo_qties_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_maint_fifo_qties_id_seq OWNED BY public.sales_maint_fifo_qties.id;


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

CREATE TABLE public.sales_orders (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Payment_Method" text NOT NULL,
    "Status" text NOT NULL,
    "Refernce_Number" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Pay" text,
    presenter text,
    annual_interest text,
    monthly_installment text,
    "Years_Number" text,
    total text,
    "installment_Num" text,
    "Date_First_installment" text,
    "Quote" text,
    "Safe" bigint NOT NULL,
    "Client" bigint NOT NULL,
    "Delegate" bigint,
    "Executor" bigint,
    "Store" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "ToSales" text DEFAULT 0,
    "Hold" text DEFAULT 0,
    "Later_Due" text,
    "Sale_Date" text,
    "CuponCode" text,
    "Shipping" text,
    "Delivery_Status" text,
    "Order_Type" text,
    "Name" text,
    "Email" text,
    "Phone" text,
    "OtherPhone" text,
    "Address_Name" text,
    "Special_MarkAdd" text,
    "StreetAdd" text,
    "BulidingAdd" text,
    "FloorAdd" text,
    "FlatAdd" text,
    "Governrate" text,
    "City" text,
    "Place" text,
    "LocationAdd" text,
    "Address_DetailsAdd" text,
    "ProfitPrecent" text,
    "InstallCompany" text,
    "ContractNumber" text,
    "PayFees" text,
    "ServiceFee" text,
    "CompanyPrecent" text,
    "Cancel_Order" text,
    "Time" text,
    "Delegate_Recived" text,
    "Delegate_Recived_Time" text,
    "To_Sales_Time" text,
    "Cancel_Order_Time" text,
    "Hold_Qty" text,
    "ResturantOrderType" text,
    "DeliveryTime" text,
    "RecivedOrderTime" text,
    "RecivedOrder" text,
    "KitchenEndTime" text,
    "KitchenEnd" text,
    "Witer" text,
    "TakeawayStatus" text,
    "TakeawayTime" text,
    "Table" bigint,
    "Total_Wight_Bill" text,
    "TaxBill" text,
    "TaxCode" text,
    "TaxOnTotal" text,
    "TaxOnTotalType" text,
    "Check_Type" text,
    "Due_Date" text,
    "Check_Number" text,
    "Shift_Code" text,
    "Client_Address" text,
    "Delivery" text,
    "ProfitTax" text,
    "Branch" text,
    "CustomerGroup" text,
    "Total_Cost" text,
    "File" text,
    "Edit" text DEFAULT 0,
    "Delete" text DEFAULT 0,
    "Edit_New_Code" text DEFAULT 0,
    "Total_Net" text,
    "Residual" text,
    "DiscountTax" text,
    "Current_Credit" text,
    "Ship" text,
    "DiscountBill" text DEFAULT 0,
    "Shipping_Price" text
);


ALTER TABLE public.sales_orders OWNER TO postgres;

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

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


ALTER TABLE public.sales_orders_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_orders_arr_seq OWNED BY public.sales_orders.arr;


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

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


ALTER TABLE public.sales_orders_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_orders_id_seq OWNED BY public.sales_orders.id;


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

CREATE TABLE public.sales_petrols (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Draw" text,
    "Note" text,
    "Counter_Name" text,
    "Pervious_Read" text,
    "Petrol_Name" text,
    "Current_Raed" text,
    "Value" text,
    "Total" text,
    "Consumption" text,
    "Cash" text,
    "Calibers" text,
    "Counter" bigint,
    "Coin" bigint,
    "Safe" bigint,
    "Store" bigint,
    "Recipient" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sales_petrols OWNER TO postgres;

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

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


ALTER TABLE public.sales_petrols_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_petrols_arr_seq OWNED BY public.sales_petrols.arr;


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

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


ALTER TABLE public.sales_petrols_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_petrols_id_seq OWNED BY public.sales_petrols.id;


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

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


ALTER TABLE public.sales_serial OWNER TO postgres;

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

CREATE TABLE public.sales_subscribes (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Payment_Method" text,
    "Later_Due" text,
    "Product_Numbers" text,
    "Total_Price" text,
    "Notes" text,
    "Coin" bigint,
    "Delegate" bigint,
    "Account" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Safe" bigint,
    "Delete" text DEFAULT 0,
    "Edit" text DEFAULT 0,
    "Edit_New_Code" text,
    "Current_Credit" text
);


ALTER TABLE public.sales_subscribes OWNER TO postgres;

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

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


ALTER TABLE public.sales_subscribes_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_subscribes_arr_seq OWNED BY public.sales_subscribes.arr;


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

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


ALTER TABLE public.sales_subscribes_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sales_subscribes_id_seq OWNED BY public.sales_subscribes.id;


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

CREATE TABLE public.scientific_materials (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.scientific_materials OWNER TO postgres;

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

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


ALTER TABLE public.scientific_materials_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.scientific_materials_id_seq OWNED BY public.scientific_materials.id;


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

CREATE TABLE public.secretariat_export_goods (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Note" text,
    "Product_Numbers" text NOT NULL,
    "Total_Qty" text NOT NULL,
    "Account" bigint NOT NULL,
    "Store" bigint NOT NULL,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Status" text DEFAULT 0,
    "StoreGoods" text,
    "Total_Recived_Qty" text,
    "Total_Price" text,
    "Draw" text,
    "Coin" text,
    "Safe" text
);


ALTER TABLE public.secretariat_export_goods OWNER TO postgres;

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

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


ALTER TABLE public.secretariat_export_goods_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.secretariat_export_goods_arr_seq OWNED BY public.secretariat_export_goods."Code";


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

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


ALTER TABLE public.secretariat_export_goods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.secretariat_export_goods_id_seq OWNED BY public.secretariat_export_goods.id;


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

CREATE TABLE public.secretariat_import_goods (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Note" text,
    "Product_Numbers" text NOT NULL,
    "Total_Qty" text NOT NULL,
    "Account" bigint NOT NULL,
    "Store" bigint NOT NULL,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.secretariat_import_goods OWNER TO postgres;

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

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


ALTER TABLE public.secretariat_import_goods_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.secretariat_import_goods_arr_seq OWNED BY public.secretariat_import_goods.arr;


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

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


ALTER TABLE public.secretariat_import_goods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.secretariat_import_goods_id_seq OWNED BY public.secretariat_import_goods.id;


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

CREATE TABLE public.secretariat_qties (
    id bigint NOT NULL,
    "Product_Code" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "V_Name" text,
    "VV_Name" text,
    "Qty" text,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Store" bigint NOT NULL,
    "Unit" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "PP_Code" text,
    "PPP_Code" text,
    "PPPP_Code" text
);


ALTER TABLE public.secretariat_qties OWNER TO postgres;

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

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


ALTER TABLE public.secretariat_qties_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.secretariat_qties_id_seq OWNED BY public.secretariat_qties.id;


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

CREATE TABLE public.secretariat_stores (
    id bigint NOT NULL,
    "Arabic_Name" text NOT NULL,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Account" text
);


ALTER TABLE public.secretariat_stores OWNER TO postgres;

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

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


ALTER TABLE public.secretariat_stores_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.secretariat_stores_id_seq OWNED BY public.secretariat_stores.id;


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

CREATE TABLE public.select_a_p_i_s (
    id bigint NOT NULL,
    id_ text NOT NULL,
    name text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.select_a_p_i_s OWNER TO postgres;

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

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


ALTER TABLE public.select_a_p_i_s_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.select_a_p_i_s_id_seq OWNED BY public.select_a_p_i_s.id;


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

CREATE TABLE public.server_d_b_s (
    id bigint NOT NULL,
    "DB_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.server_d_b_s OWNER TO postgres;

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

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


ALTER TABLE public.server_d_b_s_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.server_d_b_s_id_seq OWNED BY public.server_d_b_s.id;


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

CREATE TABLE public.services_reals (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.services_reals OWNER TO postgres;

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

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


ALTER TABLE public.services_reals_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.services_reals_id_seq OWNED BY public.services_reals.id;


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

CREATE TABLE public.settlements (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Total_Dificit" text NOT NULL,
    "Total_Excess" text NOT NULL,
    "Total_Dificit_Price" text NOT NULL,
    "Total_Excess_Price" text NOT NULL,
    "Inv_ID" bigint,
    "Account_Excess" bigint NOT NULL,
    "Account_Dificit" bigint NOT NULL,
    "Store" bigint,
    "Coin" bigint,
    "Cost_Center" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Note" text,
    "Time" text,
    "Branch" text
);


ALTER TABLE public.settlements OWNER TO postgres;

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

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


ALTER TABLE public.settlements_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.settlements_arr_seq OWNED BY public.settlements.arr;


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

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


ALTER TABLE public.settlements_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.settlements_id_seq OWNED BY public.settlements.id;


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

CREATE TABLE public.sewing_accessories (
    id bigint NOT NULL,
    "Product" bigint,
    "Qty" text,
    "Price" text,
    "Total" text,
    "Cost" text,
    "TotalCost" text,
    "SewingOrder" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sewing_accessories OWNER TO postgres;

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

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


ALTER TABLE public.sewing_accessories_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sewing_accessories_id_seq OWNED BY public.sewing_accessories.id;


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

CREATE TABLE public.sewing_al_kabkat (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_al_kabkat OWNER TO postgres;

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

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


ALTER TABLE public.sewing_al_kabkat_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.sewing_al_kabkat_id_seq OWNED BY public.sewing_al_kabkat.id;


--
-- Name: sewing_al_taktak; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_al_taktak (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_al_taktak OWNER TO postgres;

--
-- Name: sewing_al_taktak_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_al_taktak_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_al_taktak_id_seq OWNER TO postgres;

--
-- Name: sewing_al_taktak_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_al_taktak_id_seq OWNED BY public.sewing_al_taktak.id;


--
-- Name: sewing_buttons; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_buttons (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_buttons OWNER TO postgres;

--
-- Name: sewing_buttons_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_buttons_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_buttons_id_seq OWNER TO postgres;

--
-- Name: sewing_buttons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_buttons_id_seq OWNED BY public.sewing_buttons.id;


--
-- Name: sewing_chest_pocket_fillings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_chest_pocket_fillings (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_chest_pocket_fillings OWNER TO postgres;

--
-- Name: sewing_chest_pocket_fillings_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_chest_pocket_fillings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_chest_pocket_fillings_id_seq OWNER TO postgres;

--
-- Name: sewing_chest_pocket_fillings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_chest_pocket_fillings_id_seq OWNED BY public.sewing_chest_pocket_fillings.id;


--
-- Name: sewing_chest_pockets; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_chest_pockets (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_chest_pockets OWNER TO postgres;

--
-- Name: sewing_chest_pockets_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_chest_pockets_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_chest_pockets_id_seq OWNER TO postgres;

--
-- Name: sewing_chest_pockets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_chest_pockets_id_seq OWNED BY public.sewing_chest_pockets.id;


--
-- Name: sewing_collar_paddings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_collar_paddings (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_collar_paddings OWNER TO postgres;

--
-- Name: sewing_collar_paddings_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_collar_paddings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_collar_paddings_id_seq OWNER TO postgres;

--
-- Name: sewing_collar_paddings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_collar_paddings_id_seq OWNED BY public.sewing_collar_paddings.id;


--
-- Name: sewing_collars; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_collars (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_collars OWNER TO postgres;

--
-- Name: sewing_collars_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_collars_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_collars_id_seq OWNER TO postgres;

--
-- Name: sewing_collars_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_collars_id_seq OWNED BY public.sewing_collars.id;


--
-- Name: sewing_cseed_sleeves; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_cseed_sleeves (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_cseed_sleeves OWNER TO postgres;

--
-- Name: sewing_cseed_sleeves_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_cseed_sleeves_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_cseed_sleeves_id_seq OWNER TO postgres;

--
-- Name: sewing_cseed_sleeves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_cseed_sleeves_id_seq OWNED BY public.sewing_cseed_sleeves.id;


--
-- Name: sewing_cupcake_fillings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_cupcake_fillings (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_cupcake_fillings OWNER TO postgres;

--
-- Name: sewing_cupcake_fillings_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_cupcake_fillings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_cupcake_fillings_id_seq OWNER TO postgres;

--
-- Name: sewing_cupcake_fillings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_cupcake_fillings_id_seq OWNED BY public.sewing_cupcake_fillings.id;


--
-- Name: sewing_embroideries; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_embroideries (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_embroideries OWNER TO postgres;

--
-- Name: sewing_embroideries_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_embroideries_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_embroideries_id_seq OWNER TO postgres;

--
-- Name: sewing_embroideries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_embroideries_id_seq OWNED BY public.sewing_embroideries.id;


--
-- Name: sewing_order_modules; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_order_modules (
    id bigint NOT NULL,
    "Sleeves" bigint,
    "CseedSleeves" bigint,
    "AlKabkat" bigint,
    "AlTaktak" bigint,
    "SidePocket" bigint,
    "CupcakeFilling" bigint,
    "Collar" bigint,
    "CollarPadding" bigint,
    "ChestPocket" bigint,
    "ChestPocketFilling" bigint,
    "Seeds" bigint,
    "SeedFilling" bigint,
    "Embroidery" bigint,
    "Buttons" bigint,
    "SewingOrder" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "DXF_File" text,
    "Kabak_Sewing" text,
    "Product" text,
    "Product_Cost" text
);


ALTER TABLE public.sewing_order_modules OWNER TO postgres;

--
-- Name: sewing_order_modules_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_order_modules_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_order_modules_id_seq OWNER TO postgres;

--
-- Name: sewing_order_modules_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_order_modules_id_seq OWNED BY public.sewing_order_modules.id;


--
-- Name: sewing_orders; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_orders (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Time" text,
    "RecivedDate" text,
    "Draw" text,
    "Payment_Method" text,
    "Status" text,
    "Refernce_Number" text,
    "Notes" text,
    "Qty" text,
    "DXF_Height_cm" text,
    "SizeName" text,
    "L" text,
    "LB" text,
    "B" text,
    "S" text,
    "AH" text,
    "CH" text,
    chest_full text,
    "BK" text,
    "HD" text,
    cuff text,
    gusset_len text,
    gusset_width_mm text,
    front text,
    net_chest text,
    neck_size text,
    front_shoulder_height text,
    shoulder_height text,
    back_neck_depth text,
    front_neck_depth text,
    back_down_shoulder text,
    shoulder_opening text,
    hand_cuff text,
    arm_rotation text,
    arm_length text,
    arm_elbow_width text,
    neck_height text,
    "Pocket_chest_height" text,
    neck_height_qalap text,
    hand_length_kabk text,
    hand_rotation_kabk text,
    "Total_Price" text,
    "TotalTax" text,
    "Total_af_Tax" text,
    "Discount" text,
    "Total_Af_Discount" text,
    "The_Net" text,
    "Pay" text,
    "DXF_File" text,
    "Branch" bigint,
    "RecivedBranch" bigint,
    "Safe" bigint,
    "Coin" bigint,
    "Cost_Center" bigint,
    "Delegate" bigint,
    "Client" bigint,
    "Product" bigint,
    "SewingType" bigint,
    "TaxType" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "User" text,
    "Execute" text DEFAULT '0'::text NOT NULL,
    "Kabak_Width" text,
    "Kabak_Sewing" text,
    "SewingSort" text,
    "TotalCost" text,
    "Done_Pay" text DEFAULT '0'::text,
    neck_size_qalap text,
    "B_Net" text,
    "BK_Net" text,
    "HD_Net" text,
    "IshtakTopWidth" text,
    "IshtakBottomWidth" text,
    "SideTopWidth" text,
    "SideBottomWidth" text
);


ALTER TABLE public.sewing_orders OWNER TO postgres;

--
-- Name: sewing_orders_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_orders_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_orders_arr_seq OWNER TO postgres;

--
-- Name: sewing_orders_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_orders_arr_seq OWNED BY public.sewing_orders."Code";


--
-- Name: sewing_orders_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_orders_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_orders_id_seq OWNER TO postgres;

--
-- Name: sewing_orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_orders_id_seq OWNED BY public.sewing_orders.id;


--
-- Name: sewing_request_details; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_request_details (
    id bigint NOT NULL,
    "SewingRequest" bigint,
    "Type" bigint,
    "Product" bigint,
    "Qty" text,
    "Price" text,
    "Total" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sewing_request_details OWNER TO postgres;

--
-- Name: sewing_request_details_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_request_details_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_request_details_id_seq OWNER TO postgres;

--
-- Name: sewing_request_details_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_request_details_id_seq OWNED BY public.sewing_request_details.id;


--
-- Name: sewing_requests; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_requests (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Time" text,
    "RecivedDate" text,
    "Draw" text,
    "Payment_Method" text,
    "Status" text,
    "Refernce_Number" text,
    "Notes" text,
    "Total_Price" text,
    "TotalTax" text,
    "Total_af_Tax" text,
    "Discount" text,
    "Total_Af_Discount" text,
    "The_Net" text,
    "Pay" text,
    "SewingSort" text,
    "Qty" text,
    "SewingCost" text,
    "Branch" bigint,
    "RecivedBranch" bigint,
    "Safe" bigint,
    "Coin" bigint,
    "Cost_Center" bigint,
    "Delegate" bigint,
    "Client" bigint,
    "TaxType" bigint,
    "User" bigint,
    "SewingOrderID" bigint,
    "Transferred" smallint DEFAULT '0'::smallint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "OutsideSewingType" bigint
);


ALTER TABLE public.sewing_requests OWNER TO postgres;

--
-- Name: sewing_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_requests_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_requests_id_seq OWNER TO postgres;

--
-- Name: sewing_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_requests_id_seq OWNED BY public.sewing_requests.id;


--
-- Name: sewing_seed_fillings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_seed_fillings (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_seed_fillings OWNER TO postgres;

--
-- Name: sewing_seed_fillings_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_seed_fillings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_seed_fillings_id_seq OWNER TO postgres;

--
-- Name: sewing_seed_fillings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_seed_fillings_id_seq OWNED BY public.sewing_seed_fillings.id;


--
-- Name: sewing_seeds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_seeds (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_seeds OWNER TO postgres;

--
-- Name: sewing_seeds_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_seeds_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_seeds_id_seq OWNER TO postgres;

--
-- Name: sewing_seeds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_seeds_id_seq OWNED BY public.sewing_seeds.id;


--
-- Name: sewing_side_pockets; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_side_pockets (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_side_pockets OWNER TO postgres;

--
-- Name: sewing_side_pockets_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_side_pockets_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_side_pockets_id_seq OWNER TO postgres;

--
-- Name: sewing_side_pockets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_side_pockets_id_seq OWNED BY public.sewing_side_pockets.id;


--
-- Name: sewing_sleeves; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_sleeves (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "SewingType" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Guest" integer DEFAULT 0 NOT NULL,
    "Delete" integer DEFAULT 0 NOT NULL,
    "Type" integer DEFAULT 0,
    "Sort_Order" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.sewing_sleeves OWNER TO postgres;

--
-- Name: sewing_sleeves_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_sleeves_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_sleeves_id_seq OWNER TO postgres;

--
-- Name: sewing_sleeves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_sleeves_id_seq OWNED BY public.sewing_sleeves.id;


--
-- Name: sewing_types; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sewing_types (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Image" text,
    "Status" smallint DEFAULT '1'::smallint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Price_Normal" text,
    "Price_Urgent" text,
    "Max_Price" text,
    "Min_Price" text,
    "Sewing_Price_Normal" text,
    "Sewing_Price_Urgent" text,
    "Sewing_Max_Price" text,
    "Sewing_Min_Price" text
);


ALTER TABLE public.sewing_types OWNER TO postgres;

--
-- Name: sewing_types_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sewing_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sewing_types_id_seq OWNER TO postgres;

--
-- Name: sewing_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sewing_types_id_seq OWNED BY public.sewing_types.id;


--
-- Name: shifts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.shifts (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Note" text,
    "Total_Cash" text DEFAULT 0,
    "Total_Later" text DEFAULT 0,
    "Total_Visa" text DEFAULT 0,
    "Total" text DEFAULT 0,
    "Pass" text,
    "Emp" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Close" text,
    "Amount" text,
    "Total_Recipt" text DEFAULT 0,
    "Total_Payment" text DEFAULT 0,
    "Store" text,
    "Safe" text,
    "Total_Later_Not_Paid" text DEFAULT 0,
    "Total_Later_Paid" text DEFAULT 0,
    "Total_Installment" text DEFAULT 0,
    "Total_Checks" text DEFAULT 0,
    "Total_Delivery" text DEFAULT 0,
    "Total_Installment_Companies" text DEFAULT 0,
    "Close_Date" text,
    "Open_Amount" text,
    "Open_Note" text,
    "Apps" text DEFAULT 0
);


ALTER TABLE public.shifts OWNER TO postgres;

--
-- Name: shifts_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shifts_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shifts_arr_seq OWNER TO postgres;

--
-- Name: shifts_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shifts_arr_seq OWNED BY public.shifts.arr;


--
-- Name: shifts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shifts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shifts_id_seq OWNER TO postgres;

--
-- Name: shifts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shifts_id_seq OWNED BY public.shifts.id;


--
-- Name: shipment_moves; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.shipment_moves (
    id bigint NOT NULL,
    "Code" text,
    "Barcode" text,
    "Date" text,
    "Time" text,
    "Sender" text,
    "Sender_Name" text,
    "Reciver" text,
    "Reciver_Name" text,
    "Status" text,
    "Status_Code" text,
    "Delegate" text,
    "Driver" text,
    "Note" text,
    "User" text,
    "Shipment_ID" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Shipment_Dist_ID" text,
    "Shipment_Unload_ID" text,
    "Shipment_Recived_ID" text
);


ALTER TABLE public.shipment_moves OWNER TO postgres;

--
-- Name: shipment_moves_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shipment_moves_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shipment_moves_id_seq OWNER TO postgres;

--
-- Name: shipment_moves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shipment_moves_id_seq OWNED BY public.shipment_moves.id;


--
-- Name: shipment_receipts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.shipment_receipts (
    id bigint NOT NULL,
    "Recived_Store" text,
    "Code" text,
    "Date" text,
    "Total_Cash" text,
    "Total_Later" text,
    "Total_Price" text,
    "Tickets_Numbers" text,
    "Status" text,
    "ShippingList" text,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.shipment_receipts OWNER TO postgres;

--
-- Name: shipment_receipts_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shipment_receipts_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shipment_receipts_arr_seq OWNER TO postgres;

--
-- Name: shipment_receipts_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shipment_receipts_arr_seq OWNED BY public.shipment_receipts.arr;


--
-- Name: shipment_receipts_clients; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.shipment_receipts_clients (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "ShipmentReceipts" text,
    "ShipmentReceiptsList" text,
    "Total_Price" text,
    "Total_Qty" text,
    "Pay" text,
    "Payment_Method" text,
    "Safe" text,
    "Coin" text,
    "Draw" text,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.shipment_receipts_clients OWNER TO postgres;

--
-- Name: shipment_receipts_clients_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shipment_receipts_clients_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shipment_receipts_clients_arr_seq OWNER TO postgres;

--
-- Name: shipment_receipts_clients_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shipment_receipts_clients_arr_seq OWNED BY public.shipment_receipts_clients.arr;


--
-- Name: shipment_receipts_clients_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shipment_receipts_clients_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shipment_receipts_clients_id_seq OWNER TO postgres;

--
-- Name: shipment_receipts_clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shipment_receipts_clients_id_seq OWNED BY public.shipment_receipts_clients.id;


--
-- Name: shipment_receipts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shipment_receipts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shipment_receipts_id_seq OWNER TO postgres;

--
-- Name: shipment_receipts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shipment_receipts_id_seq OWNED BY public.shipment_receipts.id;


--
-- Name: shipment_receipts_lists; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.shipment_receipts_lists (
    id bigint NOT NULL,
    "Shipping_List" text,
    "Code" text,
    "Sender_Name" text,
    "Addressees_Name" text,
    "Total_Qty" text,
    "Total_Price" text,
    "Payment_Method" text,
    "Notes" text,
    "Ticket" text,
    "ShipmentReceipts" text,
    "Status" text,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.shipment_receipts_lists OWNER TO postgres;

--
-- Name: shipment_receipts_lists_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shipment_receipts_lists_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shipment_receipts_lists_arr_seq OWNER TO postgres;

--
-- Name: shipment_receipts_lists_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shipment_receipts_lists_arr_seq OWNED BY public.shipment_receipts_lists.arr;


--
-- Name: shipment_receipts_lists_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shipment_receipts_lists_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shipment_receipts_lists_id_seq OWNER TO postgres;

--
-- Name: shipment_receipts_lists_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shipment_receipts_lists_id_seq OWNED BY public.shipment_receipts_lists.id;


--
-- Name: shipment_requests; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.shipment_requests (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Time" text,
    "Status" text,
    "Pieces_Num" text,
    "Desc" text,
    "Weight" text,
    "Length" text,
    "Width" text,
    "Height" text,
    "Note" text,
    "Payment_Method" text,
    "Breakable" text,
    "Delivery_To_Others" text,
    "Opening_Package" text,
    "Sender_Name" text,
    "Sender_Governorate" text,
    "Sender_City" text,
    "Sender_Place" text,
    "Sender_Address" text,
    "Sender_Phone1" text,
    "Sender_Phone2" text,
    "Sender_Location" text,
    "Receiver_Name" text,
    "Receiver_Governorate" text,
    "Receiver_City" text,
    "Receiver_Place" text,
    "Receiver_Address" text,
    "Receiver_Phone1" text,
    "Receiver_Phone2" text,
    "Receiver_Location" text,
    "Delegate" text,
    "Sender" text,
    "Received" text,
    "Shipment_Cost" text,
    "Total" text,
    "User" text,
    "Pay" text,
    "Safe" text,
    "Coin" text,
    "Draw" text,
    "Transfer" text DEFAULT '0'::text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Shipment_Type" text,
    "Receipt_Date" text,
    "Receipt_Time" text,
    "Arrival_Date" text,
    "Arrival_Time" text
);


ALTER TABLE public.shipment_requests OWNER TO postgres;

--
-- Name: shipment_requests_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shipment_requests_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shipment_requests_arr_seq OWNER TO postgres;

--
-- Name: shipment_requests_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shipment_requests_arr_seq OWNED BY public.shipment_requests."Code";


--
-- Name: shipment_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.shipment_requests_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.shipment_requests_id_seq OWNER TO postgres;

--
-- Name: shipment_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.shipment_requests_id_seq OWNED BY public.shipment_requests.id;


--
-- Name: shipments; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.shipments (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Time" text,
    "Arrival_Date" text,
    "Arrival_Time" text,
    "Barcode" text,
    "Status" text DEFAULT '0'::text,
    "Pieces_Num" text,
    "Desc" text,
    "Reference_Num" text,
    "Weight" text,
    "Length" text,
    "Width" text,
    "Height" text,
    "Note" text,
    "Shipment_Class" text,
    "Payment_Method" text,
    "Breakable" text,
    "Delivery_To_Others" text,
    "Shipping_Costs_Included" text,
    "Opening_Package" text,
    "Sender_Name" text,
    "Sender_Governorate" text,
    "Sender_City" text,
    "Sender_Place" text,
    "Sender_Address" text,
    "Sender_Phone1" text,
    "Sender_Phone2" text,
    "Sender_Location" text,
    "Receiver_Name" text,
    "Receiver_Governorate" text,
    "Receiver_City" text,
    "Receiver_Place" text,
    "Receiver_Address" text,
    "Receiver_Phone1" text,
    "Receiver_Phone2" text,
    "Receiver_Location" text,
    "Delegate" text,
    "Driver" text,
    "Sender" text,
    "Received" text,
    "Shipment_Type" text,
    "Shipment_Rqst_Type" text,
    "Shipment_Category" text,
    "Shipment_Cost" text,
    "Goods_Cost" text,
    "Delivery_Cost" text,
    "Overload_Weight_Cost" text,
    "Collection_Commission" text,
    "Delivery_Commission" text,
    "Return_Cost" text,
    "Total" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "User" text,
    "Pay" text,
    "Insurance" text,
    "Safe" text,
    "Coin" text,
    "Draw" text,
    "Store" text,
    "Car" text,
    "ToStore" text
);


ALTER TABLE public.shipments OWNER TO postgres;

--
