--
--



--
-- Name: rand(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.rand() RETURNS double precision
    LANGUAGE sql
    AS $$SELECT random();$$;


ALTER FUNCTION public.rand() OWNER TO postgres;


ALTER FUNCTION public.soundex(input text) OWNER TO postgres;

--
-- Name: substring_index(text, text, integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.substring_index(text, text, integer) RETURNS text
    LANGUAGE sql
    AS $_$SELECT array_to_string((string_to_array($1, $2)) [1:$3], $2);$_$;


ALTER FUNCTION public.substring_index(text, text, integer) OWNER TO postgres;



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

CREATE TABLE public.a_v_pro_check_qties (
    id bigint NOT NULL,
    "Product" text,
    "AvQty" text,
    "Qty" text,
    "RequestQty" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "OriginalProduct" text,
    "NewRequestQty" text
);


ALTER TABLE public.a_v_pro_check_qties OWNER TO postgres;

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

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


ALTER TABLE public.a_v_pro_check_qties_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.a_v_pro_check_qties_id_seq OWNED BY public.a_v_pro_check_qties.id;


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

CREATE TABLE public.abouts (
    id bigint NOT NULL,
    "Image" text,
    "Image_2" text,
    "Image_3" 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.abouts OWNER TO postgres;

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

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


ALTER TABLE public.abouts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.abouts_id_seq OWNED BY public.abouts.id;


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

CREATE TABLE public.abstracts_contractors (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Name" text,
    "Value" text,
    "Statement" text,
    "Contractor" text,
    "Project" text,
    "Edit" text,
    "Delete" text,
    "Edit_New_Code" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.abstracts_contractors OWNER TO postgres;

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

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


ALTER TABLE public.abstracts_contractors_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.abstracts_contractors_id_seq OWNED BY public.abstracts_contractors.id;


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

CREATE TABLE public.acccounting_manuals (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Name" text NOT NULL,
    "Type" text NOT NULL,
    "Parent" text NOT NULL,
    "Note" text,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Account_Code" text,
    "Pro_Group" text,
    "NameEn" text,
    "SearchCode" text
);


ALTER TABLE public.acccounting_manuals OWNER TO postgres;

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

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


ALTER TABLE public.acccounting_manuals_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.acccounting_manuals_id_seq OWNED BY public.acccounting_manuals.id;


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

CREATE TABLE public.accounts_default_data (
    id bigint NOT NULL,
    "Draw" text,
    "Coin" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Sure_Recipts" text,
    "Show_Group" text,
    "Account_Balance" text,
    "Salary" text,
    "Commission" text,
    "Coin_Show" text,
    "Cost_Show" text,
    "Draw_Show" text,
    "Collect_Show" text,
    "Sales_Bill_Show" text,
    "Hide_Edit_Delete" text,
    "Order_Number" text,
    "Tax_Show" text,
    "Cost_Center_Show" text,
    "Emp_Vouchers_Accounts" text
);


ALTER TABLE public.accounts_default_data OWNER TO postgres;

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

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


ALTER TABLE public.accounts_default_data_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.accounts_default_data_id_seq OWNED BY public.accounts_default_data.id;


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

CREATE TABLE public.activites (
    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.activites OWNER TO postgres;

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

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


ALTER TABLE public.activites_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.activites_id_seq OWNED BY public.activites.id;


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

CREATE TABLE public.add_translates (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Client" text,
    "Client_Type" text,
    "From_Lang" text,
    "To_Lang" text,
    "Company" text,
    "Num_Translted_Word" text,
    "ID_Name" text,
    "ID_Profession" text,
    "ID_Martial_Status" text,
    "Passport_Name" text,
    "Passport_Profession" text,
    "Passport_Martial_Status" text,
    "Extracted" text,
    "Extracted_Birthplace" text,
    "Extracted_Issuer" text,
    "CommercialRegistration" text,
    "Commercial_Name" text,
    "Commercial_Type" text,
    "Commercial_Start_Date" text,
    "Commercial_Number" text,
    "Commercial_Capital" text,
    "Commercial_Issuer" text,
    "Commercial_Address" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.add_translates OWNER TO postgres;

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

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


ALTER TABLE public.add_translates_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.add_translates_id_seq OWNED BY public.add_translates.id;


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

CREATE TABLE public.additional_products (
    id bigint NOT NULL,
    "Additional_Product" bigint,
    "Product" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.additional_products OWNER TO postgres;

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

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


ALTER TABLE public.additional_products_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.additional_products_id_seq OWNED BY public.additional_products.id;


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

CREATE TABLE public.addressses (
    id bigint NOT NULL,
    "Address_Name" text,
    "Street" text,
    "Special_Mark" text,
    "Buliding" text,
    "Floor" text,
    "Flat" text,
    "Details" text,
    "Location" text,
    "Governrate" bigint,
    "City" bigint,
    "Place" bigint,
    "Customer" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Lat" text,
    "Lng" text
);


ALTER TABLE public.addressses OWNER TO postgres;

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

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


ALTER TABLE public.addressses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.addressses_id_seq OWNED BY public.addressses.id;

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

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


ALTER TABLE public.admins_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.admins_id_seq OWNED BY public.admins.id;


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

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


ALTER TABLE public.all_groups OWNER TO postgres;

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

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


ALTER TABLE public.all_groups_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.all_groups_id_seq OWNED BY public.all_groups.id;


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

CREATE TABLE public.allowences_emps (
    id bigint NOT NULL,
    "AmountAllow" text,
    "Allow" bigint,
    "Emp" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.allowences_emps OWNER TO postgres;

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

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


ALTER TABLE public.allowences_emps_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.allowences_emps_id_seq OWNED BY public.allowences_emps.id;


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

CREATE TABLE public.apps_change_prices (
    id bigint NOT NULL,
    "App" text,
    "Product" text,
    "Price_One" text,
    "Price_Two" text,
    "Price_Three" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Barcode" text
);


ALTER TABLE public.apps_change_prices OWNER TO postgres;

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

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


ALTER TABLE public.apps_change_prices_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.apps_change_prices_id_seq OWNED BY public.apps_change_prices.id;


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

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


ALTER TABLE public.area_pincode_a_p_id_seq OWNER TO postgres;

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

CREATE TABLE public.articles (
    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.articles OWNER TO postgres;

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

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


ALTER TABLE public.articles_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.articles_id_seq OWNED BY public.articles.id;


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

CREATE TABLE public.assembly_products (
    id bigint NOT NULL,
    "Qty" text NOT NULL,
    "Price" text NOT NULL,
    "Total" text NOT NULL,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "P_Code" text,
    "Unit" bigint,
    "Product" bigint,
    p_id bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.assembly_products OWNER TO postgres;

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

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


ALTER TABLE public.assembly_products_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.assembly_products_id_seq OWNED BY public.assembly_products.id;


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

CREATE TABLE public.assets (
    id bigint NOT NULL,
    "Code" text,
    "Name" text,
    "Asset_Type" text,
    "Depreciation_Method" text,
    "Purchases_Date" text,
    "Operation_Date" text,
    "Cost" text,
    "Previous_Depreciation" text,
    "Asset_Net" text,
    "Annual_Depreciation_Ratio" text,
    "Annual_Depreciation" text,
    "Life_Span" text,
    "Image" text,
    "Note" text,
    "Depreciation_Expenses" bigint,
    "Depreciation_Complex" bigint,
    "Main_Account" bigint,
    "Account" bigint,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Draw" text,
    "Coin" bigint,
    "Cost_Center" bigint,
    "Branch" bigint,
    "Sort_Asset" text,
    "Vendor" bigint,
    "Safe" bigint,
    "Ehlak" text,
    "Payment_Method" text,
    "M1" text,
    "M2" text,
    "M3" text,
    "M4" text,
    "M5" text,
    "M6" text,
    "M7" text,
    "M8" text,
    "M9" text,
    "M10" text,
    "M11" text,
    "M12" text,
    "NameEn" text,
    "Asset_Type_En" text,
    "Depreciation_Method_En" text,
    arr bigint,
    "Delete" text,
    "Sale" text,
    "Amount" text,
    "Client" text,
    "CurrentAssetPrice" text,
    "Last_Depreciation_Month" text
);


ALTER TABLE public.assets OWNER TO postgres;

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

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


ALTER TABLE public.assets_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.assets_arr_seq OWNED BY public.assets."Code";


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

CREATE TABLE public.assets_expenses (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Name" text NOT NULL,
    "Draw" text NOT NULL,
    "Amount" text NOT NULL,
    "Asset" bigint,
    "Safe" bigint,
    "Coin" bigint,
    "Cost_Center" bigint,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.assets_expenses OWNER TO postgres;

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

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


ALTER TABLE public.assets_expenses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.assets_expenses_id_seq OWNED BY public.assets_expenses.id;


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

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


ALTER TABLE public.assets_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.assets_id_seq OWNED BY public.assets.id;


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

CREATE TABLE public.attend_departure_import (
    id bigint NOT NULL,
    "In_Time" text,
    "Out_Time" text,
    "Date" text,
    "Month" text,
    "Note" text,
    "Attend" text,
    "Emp" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.attend_departure_import OWNER TO postgres;

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

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


ALTER TABLE public.attend_departure_import_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.attend_departure_import_id_seq OWNED BY public.attend_departure_import.id;


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

CREATE TABLE public.attendance_emps (
    id bigint NOT NULL,
    "In_Time" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Note" text,
    "Attend" bigint,
    "Emp" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.attendance_emps OWNER TO postgres;

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

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


ALTER TABLE public.attendance_emps_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.attendance_emps_id_seq OWNED BY public.attendance_emps.id;


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

CREATE TABLE public.attendances (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Note" text,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Status" text,
    arr bigint
);


ALTER TABLE public.attendances OWNER TO postgres;

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

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


ALTER TABLE public.attendances_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.attendances_arr_seq OWNED BY public.attendances."Code";


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

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


ALTER TABLE public.attendances_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.attendances_id_seq OWNED BY public.attendances.id;


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

CREATE TABLE public.attendence_policy_emps (
    id bigint NOT NULL,
    "Emp" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "From" integer,
    "To" integer,
    "Discount" numeric
);


ALTER TABLE public.attendence_policy_emps OWNER TO postgres;

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

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


ALTER TABLE public.attendence_policy_emps_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.attendence_policy_emps_id_seq OWNED BY public.attendence_policy_emps.id;


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

CREATE TABLE public.barcode_products (
    id bigint NOT NULL,
    "Name" text NOT NULL,
    "Code" text NOT NULL,
    "Qty" text NOT NULL,
    "Price" text NOT NULL,
    "Product" bigint,
    "V1" bigint,
    "V2" bigint,
    "Unit" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Group" text
);


ALTER TABLE public.barcode_products OWNER TO postgres;

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

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


ALTER TABLE public.barcode_products_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.barcode_products_id_seq OWNED BY public.barcode_products.id;


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

CREATE TABLE public.barcode_settings (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Name" text NOT NULL,
    "Type" text NOT NULL,
    "Direction" text NOT NULL,
    "Width" text NOT NULL,
    "Height" text NOT NULL,
    "Padding_L" text NOT NULL,
    "Padding_R" text NOT NULL,
    "Padding_T" text NOT NULL,
    "Padding_B" text NOT NULL,
    "Margin_L" text NOT NULL,
    "Margin_R" text NOT NULL,
    "Margin_T" text NOT NULL,
    "Margin_B" text NOT NULL,
    "Barcode_Width" text NOT NULL,
    "Barcode_Height" text NOT NULL,
    "Font_Size" text NOT NULL,
    "Line_Height" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Height_Logo" character varying,
    "Width_Logo" character varying,
    "NameEn" text,
    arr bigint
);


ALTER TABLE public.barcode_settings OWNER TO postgres;

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

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


ALTER TABLE public.barcode_settings_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.barcode_settings_arr_seq OWNED BY public.barcode_settings.arr;


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

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


ALTER TABLE public.barcode_settings_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.barcode_settings_id_seq OWNED BY public.barcode_settings.id;


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

CREATE TABLE public.barcode_shows (
    id bigint NOT NULL,
    "Company_Name" text,
    "Product_Name" text,
    "Product_Price" text,
    "Unit" text,
    "Coin" text,
    "Group" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Code" text,
    "Logo" text
);


ALTER TABLE public.barcode_shows OWNER TO postgres;

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

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


ALTER TABLE public.barcode_shows_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.barcode_shows_id_seq OWNED BY public.barcode_shows.id;


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

CREATE TABLE public.befroe_footers (
    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.befroe_footers OWNER TO postgres;

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

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


ALTER TABLE public.befroe_footers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.befroe_footers_id_seq OWNED BY public.befroe_footers.id;


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

CREATE TABLE public.beneftis_types (
    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.beneftis_types OWNER TO postgres;

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

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


ALTER TABLE public.beneftis_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.beneftis_types_id_seq OWNED BY public.beneftis_types.id;


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

CREATE TABLE public.bones_sales_petrols (
    id bigint NOT NULL,
    "Bone_Amount" text NOT NULL,
    "Bone" bigint,
    "SalesPetrol" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.bones_sales_petrols OWNER TO postgres;

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

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


ALTER TABLE public.bones_sales_petrols_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.bones_sales_petrols_id_seq OWNED BY public.bones_sales_petrols.id;


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

CREATE TABLE public.bones_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.bones_types OWNER TO postgres;

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

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


ALTER TABLE public.bones_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.bones_types_id_seq OWNED BY public.bones_types.id;


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

CREATE TABLE public.borrowas (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Amount" text NOT NULL,
    "Draw" text NOT NULL,
    "Note" text,
    "Safe" bigint NOT NULL,
    "Emp" bigint,
    "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,
    "Delete" text DEFAULT 0,
    "Refernce_Number" text
);


ALTER TABLE public.borrowas OWNER TO postgres;

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

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


ALTER TABLE public.borrowas_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.borrowas_arr_seq OWNED BY public.borrowas."Code";


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

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


ALTER TABLE public.borrowas_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.borrowas_id_seq OWNED BY public.borrowas.id;


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

CREATE TABLE public.branches (
    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,
    "Letter" text,
    "Code" text,
    "Location" text,
    "Budget" text,
    "Lat" text,
    "Lang" text,
    "Branch" text
);


ALTER TABLE public.branches OWNER TO postgres;

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

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


ALTER TABLE public.branches_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.branches_id_seq OWNED BY public.branches.id;


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

CREATE TABLE public.brands (
    id bigint NOT NULL,
    "Name" text NOT NULL,
    "Note" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Image" text,
    "Sales_Show" text,
    "Store_Show" text,
    "NameEn" text,
    "Sales_Precet" text DEFAULT 0
);


ALTER TABLE public.brands OWNER TO postgres;

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

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


ALTER TABLE public.brands_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.brands_id_seq OWNED BY public.brands.id;


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

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


ALTER TABLE public.campaigns OWNER TO postgres;

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

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


ALTER TABLE public.campaigns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.campaigns_id_seq OWNED BY public.campaigns.id;


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

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


ALTER TABLE public.capital_increases OWNER TO postgres;

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

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


ALTER TABLE public.capital_increases_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.capital_increases_id_seq OWNED BY public.capital_increases.id;


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

CREATE TABLE public.capitals (
    id bigint NOT NULL,
    "Authorized_Capital" text,
    "Source_Capital" text,
    "Shares_Number" text,
    "Nominal_Value_of_Shares" text,
    "Actual_Share_Value" text,
    "Actual_Capital" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Working_Capital" text,
    "New_Shares_Number" text,
    "Capital_Increase" text,
    "New_Source_Capital" text,
    "Total_Investment" text
);


ALTER TABLE public.capitals OWNER TO postgres;

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

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


ALTER TABLE public.capitals_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.capitals_id_seq OWNED BY public.capitals.id;


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

CREATE TABLE public.car_shippings (
    id bigint NOT NULL,
    "Name" text,
    "Max_Load" text,
    "Delegate" text,
    "Driver" text,
    "Car_Number" text,
    "Color" text,
    "Lisence_Expire_Date" text,
    "GPS_Num" text,
    "Car_Type" text,
    "Car_Statue" text,
    "Insurance" text,
    "Ownership" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Cost_Center" text,
    "Rent_Amount" text,
    "Deal_Type" text,
    "Deal_Amount" text,
    "Account" text,
    "AccountMerit" text,
    "Minimum" text
);


ALTER TABLE public.car_shippings OWNER TO postgres;

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

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


ALTER TABLE public.car_shippings_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.car_shippings_id_seq OWNED BY public.car_shippings.id;


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

CREATE TABLE public.cars_sales_petrols (
    id bigint NOT NULL,
    "Car_Amount" text NOT NULL,
    "Car" bigint,
    "SalesPetrol" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.cars_sales_petrols OWNER TO postgres;

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

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


ALTER TABLE public.cars_sales_petrols_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.cars_sales_petrols_id_seq OWNED BY public.cars_sales_petrols.id;


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

CREATE TABLE public.cart_stores (
    id bigint NOT NULL,
    "Name" text,
    "NameEn" text,
    "V_Name" text,
    "VV_Name" text,
    "P_Code" text,
    "AvQty" 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,
    "Product" text
);


ALTER TABLE public.cart_stores OWNER TO postgres;

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

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


ALTER TABLE public.cart_stores_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.cart_stores_id_seq OWNED BY public.cart_stores.id;


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

CREATE TABLE public.chat_issues (
    id bigint NOT NULL,
    "Name" text,
    "Date" text,
    "Time" text,
    "Desc" text,
    "Image" text,
    "Issue" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Type" text,
    "Appear" text
);


ALTER TABLE public.chat_issues OWNER TO postgres;

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

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


ALTER TABLE public.chat_issues_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.chat_issues_id_seq OWNED BY public.chat_issues.id;


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

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


ALTER TABLE public.checks_types OWNER TO postgres;

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

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


ALTER TABLE public.checks_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.checks_types_id_seq OWNED BY public.checks_types.id;


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

CREATE TABLE public.cities (
    id bigint NOT NULL,
    "Arabic_Name" text NOT NULL,
    "English_Name" text,
    "Gov" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Ship_Price" text,
    "Shipping_Company" text,
    "SearchCode" text,
    "ShippingCode" text
);


ALTER TABLE public.cities OWNER TO postgres;

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

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


ALTER TABLE public.cities_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.cities_id_seq OWNED BY public.cities.id;


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

CREATE TABLE public.client_account_statement_column_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,
    "Client" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "ShiftCode" text,
    "Executor" text
);


ALTER TABLE public.client_account_statement_column_sechdules OWNER TO postgres;

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

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


ALTER TABLE public.client_account_statement_column_sechdules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.client_account_statement_column_sechdules_id_seq OWNED BY public.client_account_statement_column_sechdules.id;


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

CREATE TABLE public.client_account_statement_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,
    "Client" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "ShiftCode" text,
    "Executor" text
);


ALTER TABLE public.client_account_statement_columns OWNER TO postgres;

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

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


ALTER TABLE public.client_account_statement_columns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.client_account_statement_columns_id_seq OWNED BY public.client_account_statement_columns.id;


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

CREATE TABLE public.client_filters (
    id bigint NOT NULL,
    "Product" text NOT NULL,
    "Code" text,
    "Name" text,
    "VName" text,
    "VVName" text,
    "V1" text,
    "V2" text,
    "Qty" text,
    "Price" text,
    "Total" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Client" text
);


ALTER TABLE public.client_filters OWNER TO postgres;

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

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


ALTER TABLE public.client_filters_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.client_filters_id_seq OWNED BY public.client_filters.id;


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

CREATE TABLE public.client_requests (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Client" text,
    "File" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.client_requests OWNER TO postgres;

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

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


ALTER TABLE public.client_requests_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.client_requests_arr_seq OWNED BY public.client_requests."Code";


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

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


ALTER TABLE public.client_requests_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.client_requests_id_seq OWNED BY public.client_requests.id;


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

CREATE TABLE public.client_sales_petrols (
    id bigint NOT NULL,
    "Customer_Amount" text NOT NULL,
    "Customer" bigint,
    "SalesPetrol" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.client_sales_petrols OWNER TO postgres;

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

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


ALTER TABLE public.client_sales_petrols_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.client_sales_petrols_id_seq OWNED BY public.client_sales_petrols.id;


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

CREATE TABLE public.client_statuses (
    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.client_statuses OWNER TO postgres;

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

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


ALTER TABLE public.client_statuses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.client_statuses_id_seq OWNED BY public.client_statuses.id;


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

CREATE TABLE public.clients_statements_column_sechdules (
    id bigint NOT NULL,
    "Account_Code" text,
    "Account_Name" text,
    "Debiator_Before" text,
    "Creditor_Before" text,
    "Total_Debitor" text,
    "Total_Creditor" text,
    "Debitor_Balance" text,
    "Creditor_Balance" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.clients_statements_column_sechdules OWNER TO postgres;

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

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


ALTER TABLE public.clients_statements_column_sechdules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.clients_statements_column_sechdules_id_seq OWNED BY public.clients_statements_column_sechdules.id;


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

CREATE TABLE public.clients_statements_columns (
    id bigint NOT NULL,
    "Account_Code" text,
    "Account_Name" text,
    "Debiator_Before" text,
    "Creditor_Before" text,
    "Total_Debitor" text,
    "Total_Creditor" text,
    "Debitor_Balance" text,
    "Creditor_Balance" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.clients_statements_columns OWNER TO postgres;

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

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


ALTER TABLE public.clients_statements_columns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.clients_statements_columns_id_seq OWNED BY public.clients_statements_columns.id;


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

CREATE TABLE public.coins (
    id bigint NOT NULL,
    "Arabic_Name" text NOT NULL,
    "English_Name" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Draw" text,
    "Symbol" text,
    "Code" text,
    "Image" text
);


ALTER TABLE public.coins OWNER TO postgres;

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

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


ALTER TABLE public.coins_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.coins_id_seq OWNED BY public.coins.id;


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

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


ALTER TABLE public.comments OWNER TO postgres;

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

CREATE TABLE public.comments_clients (
    id bigint NOT NULL,
    "Comment" text,
    "Responsible" bigint,
    "Customer" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "CommentEn" text,
    "Code" text,
    "Date" text,
    "Rate" text,
    "Visit_Cost" text,
    "Note" text,
    "Time" text,
    "Type" text,
    lat text,
    lng text,
    "Voice" text
);


ALTER TABLE public.comments_clients OWNER TO postgres;

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

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


ALTER TABLE public.comments_clients_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.comments_clients_id_seq OWNED BY public.comments_clients.id;


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

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


ALTER TABLE public.comments_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.comments_id_seq OWNED BY public.comments.id;


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

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


ALTER TABLE public.company_cars OWNER TO postgres;

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

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


ALTER TABLE public.company_cars_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.company_cars_id_seq OWNED BY public.company_cars.id;

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

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


ALTER TABLE public.company_data_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.company_data_id_seq OWNED BY public.company_data.id;


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

CREATE TABLE public.compare_prices_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,
    "SalePrice" text,
    "ProductPrice" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.compare_prices_columns OWNER TO postgres;

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

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


ALTER TABLE public.compare_prices_columns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.compare_prices_columns_id_seq OWNED BY public.compare_prices_columns.id;


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

CREATE TABLE public.compare_prices_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,
    "SalePrice" text,
    "ProductPrice" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.compare_prices_columns_sechdules OWNER TO postgres;

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

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


ALTER TABLE public.compare_prices_columns_sechdules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.compare_prices_columns_sechdules_id_seq OWNED BY public.compare_prices_columns_sechdules.id;


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

CREATE TABLE public.compare_prices_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.compare_prices_filter_twos OWNER TO postgres;

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

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


ALTER TABLE public.compare_prices_filter_twos_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.compare_prices_filter_twos_id_seq OWNED BY public.compare_prices_filter_twos.id;


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

CREATE TABLE public.compare_prices_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.compare_prices_filters OWNER TO postgres;

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

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


ALTER TABLE public.compare_prices_filters_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.compare_prices_filters_id_seq OWNED BY public.compare_prices_filters.id;


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

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


ALTER TABLE public.compares OWNER TO postgres;

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

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


ALTER TABLE public.compares_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.compares_id_seq OWNED BY public.compares.id;


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

CREATE TABLE public.competitors (
    id bigint NOT NULL,
    "Facebook" character varying(191),
    "Twitter" character varying(191),
    "Instagram" character varying(191),
    "Name" character varying(191),
    "Country" text,
    "Whatsapp" character varying(191),
    "Addtional_Link" character varying(191),
    "Phone" character varying(191),
    "Pinterest" character varying(191),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "NameEn" text,
    "Website" text
);


ALTER TABLE public.competitors OWNER TO postgres;

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

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


ALTER TABLE public.competitors_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.competitors_id_seq OWNED BY public.competitors.id;


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

CREATE TABLE public.consist_maintainces (
    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_Tax" text,
    "Total" text,
    "Exp_Date" text,
    "Store" text,
    "Product" text,
    "V1" text,
    "V2" text,
    "Unit" text,
    "Maintaince" text,
    "TDiscount" text,
    "Group" text,
    "Brand" text,
    "Code" text,
    "Date" text,
    "Note" text,
    "Serial_Num" text,
    "Total_Price" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_Cost" text,
    "Total_Bf_Taxes" text,
    "Total_Taxes" text,
    "Draw" text,
    "Company" text,
    "Device_Type" text,
    "Device_Case" text,
    "Coin" text,
    "Cost_Center" text,
    "Account" text,
    "User" text,
    "Status" text,
    "Pattern_Image" text,
    "Time" text,
    "Payment_Method" text,
    "Password" text,
    "Pay" text,
    "Eng_Note" text,
    "Reason" text,
    "Report_Client" text,
    "Work" text,
    "StoreMain" text,
    "Eng" text,
    "Recipient" text,
    "Branch" text,
    "RefuseReason" text,
    "NoteRecived" text,
    "Returned" text,
    "CustomerGroup" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.consist_maintainces OWNER TO postgres;

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

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


ALTER TABLE public.consist_maintainces_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.consist_maintainces_id_seq OWNED BY public.consist_maintainces.id;


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

CREATE TABLE public.consists (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Darw" text NOT NULL,
    "Products_Number" text NOT NULL,
    "Total_Qty" text NOT NULL,
    "Total_Price" text NOT NULL,
    "Account" bigint NOT NULL,
    "Store" bigint,
    "Coin" bigint,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Time" text,
    "Branch" text,
    arr bigint,
    "Delete" text DEFAULT 0
);


ALTER TABLE public.consists OWNER TO postgres;

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

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


ALTER TABLE public.consists_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.consists_arr_seq OWNED BY public.consists.arr;


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

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


ALTER TABLE public.consists_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.consists_id_seq OWNED BY public.consists.id;


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

CREATE TABLE public.contact_u_s (
    id bigint NOT NULL,
    "Map" text,
    "Arabic_Title" text,
    "English_Title" text,
    "Arabic_Desc" text,
    "English_Desc" text,
    "Opening_Hours" text,
    "Phone1" text,
    "Phone2" text,
    "Phone_Header" text,
    "Email" text,
    "Arabic_Address" text,
    "English_Address" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.contact_u_s OWNER TO postgres;

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

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


ALTER TABLE public.contact_u_s_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.contact_u_s_id_seq OWNED BY public.contact_u_s.id;


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

CREATE TABLE public.contract_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.contract_statuses OWNER TO postgres;

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

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


ALTER TABLE public.contract_statuses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.contract_statuses_id_seq OWNED BY public.contract_statuses.id;


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

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


ALTER TABLE public.contractors_real_projects OWNER TO postgres;

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

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


ALTER TABLE public.contractors_real_projects_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.contractors_real_projects_id_seq OWNED BY public.contractors_real_projects.id;


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

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


ALTER TABLE public.cost_centers OWNER TO postgres;

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

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


ALTER TABLE public.cost_centers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.cost_centers_id_seq OWNED BY public.cost_centers.id;


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

CREATE TABLE public.counters_types (
    id bigint NOT NULL,
    "Name" text,
    "Current_Read" text,
    "Store" bigint,
    "Product" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "NameEn" text
);


ALTER TABLE public.counters_types OWNER TO postgres;

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

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


ALTER TABLE public.counters_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.counters_types_id_seq OWNED BY public.counters_types.id;


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

CREATE TABLE public.countris (
    id bigint NOT NULL,
    "Arabic_Name" text NOT NULL,
    "English_Name" text NOT NULL,
    "Flag" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Safe" text,
    "Coin" text,
    "Store" text,
    "Code" text,
    "SearchCode" text
);


ALTER TABLE public.countris OWNER TO postgres;

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

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


ALTER TABLE public.countris_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.countris_id_seq OWNED BY public.countris.id;


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

CREATE TABLE public.coupon_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.coupon_codes OWNER TO postgres;

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

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


ALTER TABLE public.coupon_codes_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.coupon_codes_id_seq OWNED BY public.coupon_codes.id;


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

CREATE TABLE public.courses (
    id bigint NOT NULL,
    "Code" text,
    "Arabic_Name" text,
    "English_Name" text,
    "Arabic_Desc" text,
    "English_Desc" text,
    "Category" text,
    "Lec_Num" text,
    "Hours" text,
    "Subject" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Note" text
);


ALTER TABLE public.courses OWNER TO postgres;

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

CREATE TABLE public.courses_categories (
    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.courses_categories OWNER TO postgres;

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

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


ALTER TABLE public.courses_categories_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.courses_categories_id_seq OWNED BY public.courses_categories.id;


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

CREATE TABLE public.courses_halls (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Chairs_Num" text,
    "Wiifii" text,
    "Air_Condition" text,
    "Place" text,
    "Number" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.courses_halls OWNER TO postgres;

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

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


ALTER TABLE public.courses_halls_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.courses_halls_id_seq OWNED BY public.courses_halls.id;


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

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


ALTER TABLE public.courses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.courses_id_seq OWNED BY public.courses.id;


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

CREATE TABLE public.courses_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.courses_types OWNER TO postgres;

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

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


ALTER TABLE public.courses_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.courses_types_id_seq OWNED BY public.courses_types.id;


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

CREATE TABLE public.crm_default_data (
    id bigint NOT NULL,
    "Price_Level" text,
    "Governrate" bigint,
    "City" bigint,
    "Responsible" bigint,
    "Activity" bigint,
    "Campagin" bigint,
    "ClientStatus" bigint,
    "Platforms" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Client_Delegate" text DEFAULT 0,
    "Nationality" text,
    "ClientGroup" text
);


ALTER TABLE public.crm_default_data OWNER TO postgres;

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

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


ALTER TABLE public.crm_default_data_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.crm_default_data_id_seq OWNED BY public.crm_default_data.id;


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

CREATE TABLE public.custom_prints (
    id bigint NOT NULL,
    "Sales_Print_Type" text,
    "Sales_Bill_Code" text,
    "Sales_Date" text,
    "Sales_Coin" text,
    "Sales_Draw" text,
    "Sales_Payment_Method" text,
    "Sales_Status" text,
    "Sales_Executor" text,
    "Sales_Refernce_Number" text,
    "Sales_Safe" text,
    "Sales_Client" text,
    "Sales_Delegate" text,
    "Sales_Store" text,
    "Sales_User" text,
    "Sales_Cost_Center" text,
    "Sales_Notes" text,
    "Sales_Pro_Code" text,
    "Sales_Pro_Name" text,
    "Sales_Pro_Unit" text,
    "Sales_Pro_Qty" text,
    "Sales_Pro_Price" text,
    "Sales_Pro_Discount" text,
    "Sales_Pro_Total_Bf_Tax" text,
    "Sales_Pro_Total_Tax" text,
    "Sales_Pro_Total" text,
    "Sales_Pro_Store" text,
    "Sales_Pro_Desc" text,
    "Sales_Pro_Exp_Date" text,
    "Sales_Pro_Weight" text,
    "Sales_Pro_Patch_Number" text,
    "Sales_Product_Numbers" text,
    "Sales_Total_Qty" text,
    "Sales_Total_Discount" text,
    "Sales_Total_Bf_Taxes" text,
    "Sales_Total_Taxes" text,
    "Sales_Total_Price" text,
    "Sales_Paid" text,
    "Sales_Residual" text,
    "Sales_Taknet" text,
    "Sales_Credit" text,
    "Sales_Barcode" text,
    "Sales_Text" text,
    "Sales_Seal" text,
    "Purch_Print_Type" text,
    "Purch_Bill_Code" text,
    "Purch_Date" text,
    "Purch_Vendor_Bill_Date" text,
    "Purch_Coin" text,
    "Purch_Draw" text,
    "Purch_Payment_Method" text,
    "Purch_Status" text,
    "Purch_Refernce_Number" text,
    "Purch_Safe" text,
    "Purch_Vendor" text,
    "Purch_Delegate" text,
    "Purch_Store" text,
    "Purch_User" text,
    "Purch_Cost_Center" text,
    "Purch_Notes" text,
    "Purch_Pro_Code" text,
    "Purch_Pro_Name" text,
    "Purch_Pro_Unit" text,
    "Purch_Pro_Qty" text,
    "Purch_Pro_Price" text,
    "Purch_Pro_Discount" text,
    "Purch_Pro_Total_Bf_Tax" text,
    "Purch_Pro_Total_Tax" text,
    "Purch_Pro_Total" text,
    "Purch_Pro_Store" text,
    "Purch_Pro_Exp_Date" text,
    "Purch_Product_Numbers" text,
    "Purch_Total_Qty" text,
    "Purch_Total_Discount" text,
    "Purch_Total_Bf_Taxes" text,
    "Purch_Total_Taxes" text,
    "Purch_Total_Price" text,
    "Purch_Paid" text,
    "Purch_Residual" text,
    "Purch_Taknet" text,
    "Purch_Credit" text,
    "Purch_Barcode" text,
    "Purch_Text" text,
    "Purch_Seal" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Sales_Client_Phone" text,
    "Sales_Resdiual" text,
    "Sales_Total_Return" text,
    "Sales_Client_Address" text,
    "Sales_Pro_Total_Net" text,
    "Purch_Pro_Total_Net" text
);


ALTER TABLE public.custom_prints OWNER TO postgres;

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

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


ALTER TABLE public.custom_prints_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.custom_prints_id_seq OWNED BY public.custom_prints.id;


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

CREATE TABLE public.customer_comments_products (
    id bigint NOT NULL,
    "Product" bigint NOT NULL,
    "Comment" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.customer_comments_products OWNER TO postgres;

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

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


ALTER TABLE public.customer_comments_products_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customer_comments_products_id_seq OWNED BY public.customer_comments_products.id;


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

CREATE TABLE public.customer_follow_ups (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Client" text,
    "Subject" text,
    "Rate" text,
    "Emp" text,
    "Visit_Cost" text,
    "Note" text,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.customer_follow_ups OWNER TO postgres;

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

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


ALTER TABLE public.customer_follow_ups_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customer_follow_ups_arr_seq OWNED BY public.customer_follow_ups.arr;


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

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


ALTER TABLE public.customer_follow_ups_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customer_follow_ups_id_seq OWNED BY public.customer_follow_ups.id;

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

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


ALTER TABLE public.customers_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customers_arr_seq OWNED BY public.customers.arr;


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

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


ALTER TABLE public.customers_files OWNER TO postgres;

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

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


ALTER TABLE public.customers_files_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customers_files_id_seq OWNED BY public.customers_files.id;


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

CREATE TABLE public.customers_groups (
    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,
    "Discount" text
);


ALTER TABLE public.customers_groups OWNER TO postgres;

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

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


ALTER TABLE public.customers_groups_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customers_groups_id_seq OWNED BY public.customers_groups.id;


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

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


ALTER TABLE public.customers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customers_id_seq OWNED BY public.customers.id;


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

CREATE TABLE public.customers_rate_types (
    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.customers_rate_types OWNER TO postgres;

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

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


ALTER TABLE public.customers_rate_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customers_rate_types_id_seq OWNED BY public.customers_rate_types.id;


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

CREATE TABLE public.customers_tickets (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Problem" text NOT NULL,
    "Status" text NOT NULL,
    "Bill_Number" text,
    "Responsible" bigint,
    "Customer" bigint,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "ProblemEn" text,
    arr bigint,
    "TicketIssues" text,
    "Date" text
);


ALTER TABLE public.customers_tickets OWNER TO postgres;

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

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


ALTER TABLE public.customers_tickets_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customers_tickets_arr_seq OWNED BY public.customers_tickets.arr;


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

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


ALTER TABLE public.customers_tickets_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customers_tickets_id_seq OWNED BY public.customers_tickets.id;


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

CREATE TABLE public.deducations_types (
    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.deducations_types OWNER TO postgres;

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

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


ALTER TABLE public.deducations_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.deducations_types_id_seq OWNED BY public.deducations_types.id;


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

CREATE TABLE public.deductions (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Amount" text NOT NULL,
    "Draw" text NOT NULL,
    "Note" text,
    "Emp" bigint,
    "Coin" bigint NOT NULL,
    "Type" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.deductions OWNER TO postgres;

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

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


ALTER TABLE public.deductions_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.deductions_arr_seq OWNED BY public.deductions.arr;


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

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


ALTER TABLE public.deductions_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.deductions_id_seq OWNED BY public.deductions.id;

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

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


ALTER TABLE public.default_data_show_hides_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.default_data_show_hides_id_seq OWNED BY public.default_data_show_hides.id;


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

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


ALTER TABLE public.delivery_apps OWNER TO postgres;

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

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


ALTER TABLE public.delivery_apps_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.delivery_apps_id_seq OWNED BY public.delivery_apps.id;


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

CREATE TABLE public.depaarture_policy_emps (
    id bigint NOT NULL,
    "Emp" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "From" integer,
    "To" integer,
    "Discount" numeric
);


ALTER TABLE public.depaarture_policy_emps OWNER TO postgres;

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

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


ALTER TABLE public.depaarture_policy_emps_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.depaarture_policy_emps_id_seq OWNED BY public.depaarture_policy_emps.id;


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

CREATE TABLE public.departure_emps (
    id bigint NOT NULL,
    "In_Time" text NOT NULL,
    "Out_Time" text NOT NULL,
    "Hours_Number" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Note" text,
    "Departure" bigint,
    "Emp" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Disc_Late" text,
    "Disc_Early" text
);


ALTER TABLE public.departure_emps OWNER TO postgres;

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

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


ALTER TABLE public.departure_emps_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.departure_emps_id_seq OWNED BY public.departure_emps.id;


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

CREATE TABLE public.departures (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Note" text,
    "Attend" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.departures OWNER TO postgres;

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

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


ALTER TABLE public.departures_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.departures_arr_seq OWNED BY public.departures.arr;


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

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


ALTER TABLE public.departures_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.departures_id_seq OWNED BY public.departures.id;


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

CREATE TABLE public.desvice_cases (
    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.desvice_cases OWNER TO postgres;

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

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


ALTER TABLE public.desvice_cases_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.desvice_cases_id_seq OWNED BY public.desvice_cases.id;


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

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


ALTER TABLE public.device_descrips OWNER TO postgres;

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

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


ALTER TABLE public.device_descrips_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.device_descrips_id_seq OWNED BY public.device_descrips.id;


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

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


ALTER TABLE public.devices_typesies OWNER TO postgres;

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

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


ALTER TABLE public.devices_typesies_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.devices_typesies_id_seq OWNED BY public.devices_typesies.id;


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

CREATE TABLE public.disclaimers (
    id bigint NOT NULL,
    "Date" text,
    "File" text,
    "Emp" text,
    "Note" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.disclaimers OWNER TO postgres;

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

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


ALTER TABLE public.disclaimers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.disclaimers_id_seq OWNED BY public.disclaimers.id;


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

CREATE TABLE public.discounts_emps (
    id bigint NOT NULL,
    "AmountDiscount" text,
    "Discount" bigint,
    "Emp" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.discounts_emps OWNER TO postgres;

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

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


ALTER TABLE public.discounts_emps_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.discounts_emps_id_seq OWNED BY public.discounts_emps.id;


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

CREATE TABLE public.domains (
    id integer NOT NULL,
    domain character varying(255) NOT NULL,
    tenant_id character varying(191) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.domains OWNER TO postgres;

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

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


ALTER TABLE public.domains_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.domains_id_seq OWNED BY public.domains.id;


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

CREATE TABLE public.emp_covenants (
    id bigint NOT NULL,
    "Emp" text,
    "Date" text,
    "Name" text,
    "Price" text,
    "Reason" text,
    "Life_Expectancy" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.emp_covenants OWNER TO postgres;

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

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


ALTER TABLE public.emp_covenants_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_covenants_id_seq OWNED BY public.emp_covenants.id;


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

CREATE TABLE public.emp_excs (
    id bigint NOT NULL,
    "Name" text,
    "Account" text,
    "Emp_Type" text,
    "Salary" text,
    "Phone" text,
    "Job" text,
    "Department" text,
    "Store1" text,
    "Store2" text,
    "Store3" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.emp_excs OWNER TO postgres;

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

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


ALTER TABLE public.emp_excs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_excs_id_seq OWNED BY public.emp_excs.id;


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

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


ALTER TABLE public.emp_installment_details OWNER TO postgres;

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

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


ALTER TABLE public.emp_installment_details_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_installment_details_id_seq OWNED BY public.emp_installment_details.id;


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

CREATE TABLE public.emp_installments (
    id bigint NOT NULL,
    "Amount" text NOT NULL,
    "Years_Number" text NOT NULL,
    "First_Date" text NOT NULL,
    "Install" text NOT NULL,
    "Install_Numbers" text NOT NULL,
    "Status" text NOT NULL,
    "Emp" bigint,
    "Loan" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.emp_installments OWNER TO postgres;

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

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


ALTER TABLE public.emp_installments_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_installments_id_seq OWNED BY public.emp_installments.id;


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

CREATE TABLE public.emp_mails (
    id bigint NOT NULL,
    "Message" text,
    "Emp" text,
    "Status" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.emp_mails OWNER TO postgres;

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

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


ALTER TABLE public.emp_mails_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_mails_id_seq OWNED BY public.emp_mails.id;


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

CREATE TABLE public.emp_movements (
    id bigint NOT NULL,
    "Date" text,
    "Time" text,
    "Emp" text,
    "Status" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.emp_movements OWNER TO postgres;

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

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


ALTER TABLE public.emp_movements_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_movements_id_seq OWNED BY public.emp_movements.id;


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

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


ALTER TABLE public.emp_p_o_s_stores OWNER TO postgres;

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

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


ALTER TABLE public.emp_p_o_s_stores_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_p_o_s_stores_id_seq OWNED BY public.emp_p_o_s_stores.id;


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

CREATE TABLE public.emp_payment_accounts (
    id bigint NOT NULL,
    "Emp" text,
    "Account" text,
    "Account_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.emp_payment_accounts OWNER TO postgres;

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

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


ALTER TABLE public.emp_payment_accounts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_payment_accounts_id_seq OWNED BY public.emp_payment_accounts.id;


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

CREATE TABLE public.emp_ratios (
    id bigint NOT NULL,
    "Salary" text NOT NULL,
    "Type" text NOT NULL,
    "Emp" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Typee" text,
    "From" integer,
    "To" integer,
    "Rate" numeric(8,2)
);


ALTER TABLE public.emp_ratios OWNER TO postgres;

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

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


ALTER TABLE public.emp_ratios_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_ratios_id_seq OWNED BY public.emp_ratios.id;


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

CREATE TABLE public.emp_recipt_accounts (
    id bigint NOT NULL,
    "Emp" text,
    "Account" text,
    "Account_Name" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.emp_recipt_accounts OWNER TO postgres;

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

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


ALTER TABLE public.emp_recipt_accounts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_recipt_accounts_id_seq OWNED BY public.emp_recipt_accounts.id;


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

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


ALTER TABLE public.emp_safes OWNER TO postgres;

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

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


ALTER TABLE public.emp_safes_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emp_safes_id_seq OWNED BY public.emp_safes.id;


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

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


ALTER TABLE public.empassies OWNER TO postgres;

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

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


ALTER TABLE public.empassies_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.empassies_id_seq OWNED BY public.empassies.id;


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

CREATE TABLE public.empassy_reserve_dates (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Client" text,
    "Purpose" text,
    "Empassy" text,
    "Booking_Date" text,
    "Cost" text,
    "Pay" text,
    "Residual" text,
    "Safe" text,
    "Draw" text,
    "Coin" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.empassy_reserve_dates OWNER TO postgres;

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

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


ALTER TABLE public.empassy_reserve_dates_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.empassy_reserve_dates_id_seq OWNED BY public.empassy_reserve_dates.id;

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

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


ALTER TABLE public.employesses_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.employesses_arr_seq OWNED BY public.employesses.arr;


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

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


ALTER TABLE public.employesses_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.employesses_id_seq OWNED BY public.employesses.id;


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

CREATE TABLE public.employment_levels (
    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.employment_levels OWNER TO postgres;

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

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


ALTER TABLE public.employment_levels_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.employment_levels_id_seq OWNED BY public.employment_levels.id;


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

CREATE TABLE public.emps_producation_points (
    id bigint NOT NULL,
    "Month" text,
    "Point" text,
    "Emp" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Date" text
);


ALTER TABLE public.emps_producation_points OWNER TO postgres;

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

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


ALTER TABLE public.emps_producation_points_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emps_producation_points_id_seq OWNED BY public.emps_producation_points.id;


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

CREATE TABLE public.emps_producation_quantities (
    id bigint NOT NULL,
    "FromQ" text,
    "ToQ" text,
    "ValueQ" text,
    "Emp" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.emps_producation_quantities OWNER TO postgres;

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

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


ALTER TABLE public.emps_producation_quantities_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.emps_producation_quantities_id_seq OWNED BY public.emps_producation_quantities.id;


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

CREATE TABLE public.entitlements (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Amount" text NOT NULL,
    "Draw" text NOT NULL,
    "Note" text,
    "Emp" bigint,
    "Coin" bigint NOT NULL,
    "Type" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.entitlements OWNER TO postgres;

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

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


ALTER TABLE public.entitlements_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.entitlements_arr_seq OWNED BY public.entitlements.arr;


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

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


ALTER TABLE public.entitlements_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.entitlements_id_seq OWNED BY public.entitlements.id;


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

CREATE TABLE public.events (
    id bigint NOT NULL,
    "Start_Date" text,
    "End_Date" text,
    "Event_Ar_Name" text,
    "Event_En_Name" text,
    "Type" text,
    "Type_ID" text,
    "Type_Code" text,
    "Emp" text,
    "Client" text,
    "Product" text,
    "Customer" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.events OWNER TO postgres;

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

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


ALTER TABLE public.events_id_seq OWNER TO postgres;

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

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


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

CREATE TABLE public.examinations_types (
    id bigint NOT NULL,
    "Name" text NOT NULL,
    "Allow_From" text NOT NULL,
    "Allow_To" text NOT NULL,
    "Unit" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "NameEn" text
);


ALTER TABLE public.examinations_types OWNER TO postgres;

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

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


ALTER TABLE public.examinations_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.examinations_types_id_seq OWNED BY public.examinations_types.id;


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

CREATE TABLE public.exchange_commissions (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text,
    "Note" text,
    "Return_Maintaince" text,
    "Draw" text NOT NULL,
    "Amount" text NOT NULL,
    "Commision" text NOT NULL,
    "Pre_Sales" text NOT NULL,
    "Pre_Execu" text NOT NULL,
    "Safe" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "Emp" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Total_Exchange_Commision" text,
    "Collection" text,
    "Delete" text DEFAULT 0,
    "Ship" text
);


ALTER TABLE public.exchange_commissions OWNER TO postgres;

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

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


ALTER TABLE public.exchange_commissions_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.exchange_commissions_arr_seq OWNED BY public.exchange_commissions."Code";


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

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


ALTER TABLE public.exchange_commissions_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.exchange_commissions_id_seq OWNED BY public.exchange_commissions.id;


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

CREATE TABLE public.execute_job_order_models (
    id bigint NOT NULL,
    "Model" text,
    "Qty" text,
    "Total_Cost" text,
    "Outcome" text,
    "Execute" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.execute_job_order_models OWNER TO postgres;

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

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


ALTER TABLE public.execute_job_order_models_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.execute_job_order_models_id_seq OWNED BY public.execute_job_order_models.id;


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

CREATE TABLE public.execute_job_order_workmanships (
    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,
    "Product" text,
    "Unit" text,
    "Execute" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Total_Net" text
);


ALTER TABLE public.execute_job_order_workmanships OWNER TO postgres;

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

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


ALTER TABLE public.execute_job_order_workmanships_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.execute_job_order_workmanships_id_seq OWNED BY public.execute_job_order_workmanships.id;


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

CREATE TABLE public.execute_job_orders (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Note" text,
    "Client" text,
    "Executor" text,
    "Delegate" text,
    "RecivedDate" text,
    "Recipient" text,
    "Order" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Transfer" text,
    "Edit" text DEFAULT 0,
    "Delete" text DEFAULT 0,
    "Edit_New_Code" text DEFAULT 0,
    "Current_Credit" text,
    "Model" text,
    "Status" text DEFAULT 0
);


ALTER TABLE public.execute_job_orders OWNER TO postgres;

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

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


ALTER TABLE public.execute_job_orders_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.execute_job_orders_arr_seq OWNED BY public.execute_job_orders."Code";


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

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


ALTER TABLE public.execute_job_orders_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.execute_job_orders_id_seq OWNED BY public.execute_job_orders.id;


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

CREATE TABLE public.executing_receiving_secretariats (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Qty" text,
    "Total" text,
    "Model" text,
    "User" text,
    "Time" text,
    "Branch" text,
    "StoreIn" text,
    "StoreOut" text,
    "Client" text,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Total_Workmanship_Price" text
);


ALTER TABLE public.executing_receiving_secretariats OWNER TO postgres;

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

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


ALTER TABLE public.executing_receiving_secretariats_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.executing_receiving_secretariats_arr_seq OWNED BY public.executing_receiving_secretariats.arr;


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

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


ALTER TABLE public.executing_receiving_secretariats_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.executing_receiving_secretariats_id_seq OWNED BY public.executing_receiving_secretariats.id;


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

CREATE TABLE public.executing_receivings (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Qty" text NOT NULL,
    "Total" text NOT NULL,
    "Model" bigint NOT NULL,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Branch" text,
    "Time" text,
    "StoreIn" text,
    "StoreOut" text,
    "Sort" text,
    "Vendor" text,
    "Cost_Workmentship" text,
    "Total_Workmentship" text,
    arr bigint,
    "Height" text,
    "Width" text,
    "Number" text,
    "CostCenter" text
);


ALTER TABLE public.executing_receivings OWNER TO postgres;

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

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


ALTER TABLE public.executing_receivings_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.executing_receivings_arr_seq OWNED BY public.executing_receivings.arr;


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

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


ALTER TABLE public.executing_receivings_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.executing_receivings_id_seq OWNED BY public.executing_receivings.id;


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

CREATE TABLE public.executor_filters (
    id bigint NOT NULL,
    "Product" text NOT NULL,
    "Code" text,
    "Name" text,
    "VName" text,
    "VVName" text,
    "V1" text,
    "V2" text,
    "Qty" text,
    "Price" text,
    "Total" text,
    "Emp" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.executor_filters OWNER TO postgres;

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

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


ALTER TABLE public.executor_filters_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.executor_filters_id_seq OWNED BY public.executor_filters.id;


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

CREATE TABLE public.expenses_list_column_sechdules (
    id bigint NOT NULL,
    "Date" text,
    "Code_Type" text,
    "Statement" text,
    "Debitor" text,
    "Cost_Center" text,
    "Coin" text,
    "User" text,
    "Account" text,
    "Branch" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.expenses_list_column_sechdules OWNER TO postgres;

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

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


ALTER TABLE public.expenses_list_column_sechdules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.expenses_list_column_sechdules_id_seq OWNED BY public.expenses_list_column_sechdules.id;


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

CREATE TABLE public.expenses_list_columns (
    id bigint NOT NULL,
    "Date" text,
    "Code_Type" text,
    "Statement" text,
    "Debitor" text,
    "Cost_Center" text,
    "Coin" text,
    "User" text,
    "Account" text,
    "Branch" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.expenses_list_columns OWNER TO postgres;

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

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


ALTER TABLE public.expenses_list_columns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.expenses_list_columns_id_seq OWNED BY public.expenses_list_columns.id;


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

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


ALTER TABLE public.expenses_type_projects OWNER TO postgres;

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

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


ALTER TABLE public.expenses_type_projects_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.expenses_type_projects_id_seq OWNED BY public.expenses_type_projects.id;


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

CREATE TABLE public.expire_date_qties (
    id bigint NOT NULL,
    "Qty" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "P_Code" text,
    "PP_Code" text,
    "PPP_Code" text,
    "PPPP_Code" text,
    "V_Name" text,
    "VV_Name" text,
    "Store" text,
    "Unit" text,
    "Product" text,
    "V1" text,
    "V2" text,
    "Low_Unit" text,
    "Exp_Date" text,
    "Group" text,
    "Brand" text,
    "Branch" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Hold_Qty" text DEFAULT 0
);


ALTER TABLE public.expire_date_qties OWNER TO postgres;

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

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


ALTER TABLE public.expire_date_qties_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.expire_date_qties_id_seq OWNED BY public.expire_date_qties.id;


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

CREATE TABLE public.export_checks (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Note" text,
    "Check_Num" text,
    "Due_Date" text NOT NULL,
    "Amount" text NOT NULL,
    "Status" text DEFAULT '0'::text NOT NULL,
    "Reason" text,
    "Check_Type" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "Account" bigint NOT NULL,
    "Bank" bigint NOT NULL,
    "Pay_Account" bigint NOT NULL,
    "Bene_Account" bigint,
    "User" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "File" text,
    arr bigint,
    "Image" text,
    "Signture_Name" text,
    "Bank_Branch" text,
    "Edit" text,
    "Edit_New_Code" text,
    "Delete" text,
    "BankSafe_Account" text,
    "Transfer" text
);


ALTER TABLE public.export_checks OWNER TO postgres;

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

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


ALTER TABLE public.export_checks_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.export_checks_arr_seq OWNED BY public.export_checks."Code";


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

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


ALTER TABLE public.export_checks_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.export_checks_id_seq OWNED BY public.export_checks.id;


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

CREATE TABLE public.f_a_q_s (
    id bigint NOT NULL,
    "Arabic_Question" text NOT NULL,
    "English_Question" text NOT NULL,
    "Arabic_Answer" text NOT NULL,
    "English_Answer" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.f_a_q_s OWNER TO postgres;

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

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


ALTER TABLE public.f_a_q_s_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.f_a_q_s_id_seq OWNED BY public.f_a_q_s.id;


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

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


ALTER TABLE public.failed_jobs OWNER TO postgres;

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

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


ALTER TABLE public.failed_jobs_id_seq OWNER TO postgres;

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

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


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

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


ALTER TABLE public.faults_types OWNER TO postgres;

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

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


ALTER TABLE public.faults_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.faults_types_id_seq OWNED BY public.faults_types.id;


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

CREATE TABLE public.fifo_qties (
    id bigint NOT NULL,
    "Qty" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "P_Code" text,
    "PP_Code" text,
    "PPP_Code" text,
    "PPPP_Code" text,
    "V_Name" text,
    "VV_Name" text,
    "Cost_Price" text,
    "Store" text,
    "Unit" text,
    "Product" text,
    "V1" text,
    "V2" text,
    "Low_Unit" text,
    "Exp_Date" text,
    "SearchCode1" text,
    "SearchCode2" text,
    "Group" text,
    "Brand" text,
    "Branch" text,
    "Purchases_Date" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Original_Qty" text,
    "Hold_Qty" text DEFAULT 0
);


ALTER TABLE public.fifo_qties OWNER TO postgres;

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

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


ALTER TABLE public.fifo_qties_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.fifo_qties_id_seq OWNED BY public.fifo_qties.id;


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

CREATE TABLE public.firewall_ips (
    id integer NOT NULL,
    ip character varying(191) NOT NULL,
    log_id integer,
    blocked boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.firewall_ips OWNER TO postgres;

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

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


ALTER TABLE public.firewall_logs_id_seq OWNER TO postgres;

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

CREATE TABLE public.firewall_logs (
    id integer DEFAULT nextval('public.firewall_logs_id_seq'::regclass) NOT NULL,
    ip character varying(191) NOT NULL,
    level character varying(191) DEFAULT 'medium'::character varying NOT NULL,
    middleware character varying(191) NOT NULL,
    user_id integer,
    url text,
    referrer character varying(191),
    request text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone
);


ALTER TABLE public.firewall_logs OWNER TO postgres;

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

CREATE TABLE public.follow_lists (
    id bigint NOT NULL,
    "Emp" text,
    "Day" text,
    "Time" text,
    "Client" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.follow_lists OWNER TO postgres;

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

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


ALTER TABLE public.follow_lists_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.follow_lists_id_seq OWNED BY public.follow_lists.id;


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

CREATE TABLE public.general_dailies (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Type" text NOT NULL,
    "Debitor" text NOT NULL,
    "Creditor" text NOT NULL,
    "Statement" text,
    "Draw" text NOT NULL,
    "Debitor_Coin" text NOT NULL,
    "Creditor_Coin" text NOT NULL,
    "Account" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    userr bigint,
    "Code_Type" text,
    "Branch" text,
    "TypeEn" text,
    arr bigint
);


ALTER TABLE public.general_dailies OWNER TO postgres;

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

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


ALTER TABLE public.general_dailies_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.general_dailies_arr_seq OWNED BY public.general_dailies.arr;


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

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


ALTER TABLE public.general_dailies_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.general_dailies_id_seq OWNED BY public.general_dailies.id;


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

CREATE TABLE public.goods_product_projects (
    id bigint NOT NULL,
    "Goods" text,
    "Product" text,
    "P_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "Unit" text,
    "Qty" text,
    "AvQty" text,
    "Price" text,
    "Total" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.goods_product_projects OWNER TO postgres;

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

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


ALTER TABLE public.goods_product_projects_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.goods_product_projects_id_seq OWNED BY public.goods_product_projects.id;


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

CREATE TABLE public.goods_projects (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Store" text,
    "Cost_Center" text,
    "Responsible" text,
    "Safe" text,
    "Coin" text,
    "Draw" text,
    "Note" text,
    "Project" text,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Price" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.goods_projects OWNER TO postgres;

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

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


ALTER TABLE public.goods_projects_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.goods_projects_id_seq OWNED BY public.goods_projects.id;


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

CREATE TABLE public.governrates (
    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,
    "Country" text,
    "SearchCode" text
);


ALTER TABLE public.governrates OWNER TO postgres;

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

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


ALTER TABLE public.governrates_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.governrates_id_seq OWNED BY public.governrates.id;


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

CREATE TABLE public.group_filters (
    id bigint NOT NULL,
    "Product" text NOT NULL,
    "Code" text,
    "Name" text,
    "VName" text,
    "VVName" text,
    "V1" text,
    "V2" text,
    "Qty" text,
    "Price" text,
    "Total" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.group_filters OWNER TO postgres;

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

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


ALTER TABLE public.group_filters_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.group_filters_id_seq OWNED BY public.group_filters.id;


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

CREATE TABLE public.holidays (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Num_of_Days" text NOT NULL,
    "Start_Date" text NOT NULL,
    "Discount" text NOT NULL,
    "Status" 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.holidays OWNER TO postgres;

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

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


ALTER TABLE public.holidays_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.holidays_arr_seq OWNED BY public.holidays.arr;


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

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


ALTER TABLE public.holidays_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.holidays_id_seq OWNED BY public.holidays.id;


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

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


ALTER TABLE public.holidays_types OWNER TO postgres;

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

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


ALTER TABLE public.holidays_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.holidays_types_id_seq OWNED BY public.holidays_types.id;


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

CREATE TABLE public.home_e_com_designs (
    id bigint NOT NULL,
    "Slider_BG_Type" text,
    "Slider_BG_Image" text,
    "Slider_BG_Color" text,
    "Slider_Button_BG_Color" text,
    "Slider_Button_Txt_Color" text,
    "Slider_Button_Hover_BG_Color" text,
    "Slider_Button_Hover_Txt_Color" text,
    "Slider_Title_Txt_Color" text,
    "Slider_Desc_Txt_Color" text,
    "Ads_Top_Img_First_BG_Color" text,
    "Ads_Top_Img_First_Before_BG_Color" text,
    "Ads_Top_Img_Second_BG_Color" text,
    "Ads_Top_Img_Second_Before_BG_Color" text,
    "Ads_Top_Img_Button_BG_Color" text,
    "Ads_Top_Img_Button_Txt_Color" text,
    "Ads_Top_Img_Button_Hover_BG_Color" text,
    "Ads_Top_Img_Button_Hover_Txt_Color" text,
    "Support_Icons_BG_Color" text,
    "Support_Icons_Txt_Color" text,
    "Support_Icons_Color" text,
    "Ads_Bootom_Imgs_BG_Color" text,
    "Ads_Bootom_Imgs_Middle_BG_Color" text,
    "Ads_Bootom_Imgs_Button_BG_Color" text,
    "Ads_Bootom_Imgs_Button_Txt_Color" text,
    "Ads_Bootom_Imgs_Button_Hover_BG_Color" text,
    "Ads_Bootom_Imgs_Button_Hover_Txt_Color" text,
    "Partners_BG_Color" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.home_e_com_designs OWNER TO postgres;

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

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


ALTER TABLE public.home_e_com_designs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.home_e_com_designs_id_seq OWNED BY public.home_e_com_designs.id;


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

CREATE TABLE public.home_product_e_com_designs (
    id bigint NOT NULL,
    "Special_Offer_Title_BG_Color" text,
    "Special_Offer_Title_Txt_Color" text,
    "Special_Offer_Product_BG_Color" text,
    "Special_Offer_Product_Border_Color" text,
    "Special_Offer_Product_Txt_Color" text,
    "Special_Offer_Product_Price_Color" text,
    "Special_Offer_Product_Rate_Color" text,
    "Best_Sellers_Title_BG_Color" text,
    "Best_Sellers_Title_Txt_Color" text,
    "Best_Sellers_Category_Txt_Color" text,
    "Best_Sellers_Category_Active_Txt_Color" text,
    "Best_Sellers_Product_BG_Color" text,
    "Best_Sellers_Product_Group_BG_Color" text,
    "Best_Sellers_Product_Group_Txt_Color" text,
    "Best_Sellers_Product_Group_Hover_BG_Color" text,
    "Best_Sellers_Product_Group_Hover_Txt_Color" text,
    "Best_Sellers_Product_Icon_BG_Color" text,
    "Best_Sellers_Product_Icon_Txt_Color" text,
    "Best_Sellers_Product_Icon_Hover_BG_Color" text,
    "Best_Sellers_Product_Icon_Hover_Txt_Color" text,
    "Best_Sellers_Product_Txt_Color" text,
    "Best_Sellers_Product_Price_Color" text,
    "Best_Sellers_Product_Rate_Color" text,
    "New_Arrivals_Title_BG_Color" text,
    "New_Arrivals_Title_Txt_Color" text,
    "New_Arrivals_Product_BG_Color" text,
    "New_Arrivals_Product_Group_BG_Color" text,
    "New_Arrivals_Product_Group_Txt_Color" text,
    "New_Arrivals_Product_Group_Hover_BG_Color" text,
    "New_Arrivals_Product_Group_Hover_Txt_Color" text,
    "New_Arrivals_Product_Icon_BG_Color" text,
    "New_Arrivals_Product_Icon_Txt_Color" text,
    "New_Arrivals_Product_Icon_Hover_BG_Color" text,
    "New_Arrivals_Product_Icon_Hover_Txt_Color" text,
    "New_Arrivals_Product_Txt_Color" text,
    "New_Arrivals_Product_Price_Color" text,
    "New_Arrivals_Product_Hover_Price_Color" text,
    "New_Arrivals_Product_Rate_Color" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Special_Offer_Product_Txt_Hover_Color" text
);


ALTER TABLE public.home_product_e_com_designs OWNER TO postgres;

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

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


ALTER TABLE public.home_product_e_com_designs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.home_product_e_com_designs_id_seq OWNED BY public.home_product_e_com_designs.id;


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

CREATE TABLE public.import_expenses_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.import_expenses_types OWNER TO postgres;

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

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


ALTER TABLE public.import_expenses_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.import_expenses_types_id_seq OWNED BY public.import_expenses_types.id;


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

CREATE TABLE public.import_new_prods (
    id bigint NOT NULL,
    "Name" text NOT NULL,
    "Type" text NOT NULL,
    "Group" text NOT NULL,
    "Brand" text,
    "Unit" text NOT NULL,
    "Rate" text NOT NULL,
    "Barcode" text NOT NULL,
    "Price_1" text NOT NULL,
    "Price_2" text,
    "Price_3" text,
    "Def" text NOT NULL,
    "Num" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Code_Type" text,
    "World_Code" text,
    "Weight" text,
    "Search_Code" text
);


ALTER TABLE public.import_new_prods OWNER TO postgres;

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

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


ALTER TABLE public.import_new_prods_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.import_new_prods_id_seq OWNED BY public.import_new_prods.id;


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

CREATE TABLE public.import_new_prods_starts (
    id bigint NOT NULL,
    "Name" text,
    "Type" text,
    "Group" text,
    "Brand" text,
    "Unit" text,
    "Rate" text,
    "Barcode" text,
    "Price_1" text,
    "Price_2" text,
    "Price_3" text,
    "Def" text,
    "Num" text,
    "Store" text,
    "Qty" text,
    "CostPrice" text,
    "Total" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Code_Type" text,
    "World_Code" text,
    "Weight" text,
    "Search_Code" text
);


ALTER TABLE public.import_new_prods_starts OWNER TO postgres;

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

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


ALTER TABLE public.import_new_prods_starts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.import_new_prods_starts_id_seq OWNED BY public.import_new_prods_starts.id;


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

CREATE TABLE public.in_out_logs (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    in_time time(0) without time zone,
    out_time time(0) without time zone,
    time_calc double precision,
    date date,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.in_out_logs OWNER TO postgres;

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

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


ALTER TABLE public.in_out_logs_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.in_out_logs_id_seq OWNED BY public.in_out_logs.id;


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

CREATE TABLE public.incom_checks (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Note" text,
    "Check_Num" text NOT NULL,
    "Due_Date" text NOT NULL,
    "Amount" text NOT NULL,
    "Status" text DEFAULT '0'::text NOT NULL,
    "Reason" text,
    "Check_Type" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "Account" bigint NOT NULL,
    "Bank" bigint NOT NULL,
    "Arrest_Account" bigint NOT NULL,
    "Bene_Account" bigint,
    "User" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "File" text,
    arr bigint,
    "Image" text,
    "Signture_Name" text,
    "Bank_Branch" text,
    "Edit" text,
    "Edit_New_Code" text,
    "Delete" text,
    "BankSafe_Account" text,
    "Transfer" text
);


ALTER TABLE public.incom_checks OWNER TO postgres;

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

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


ALTER TABLE public.incom_checks_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.incom_checks_arr_seq OWNED BY public.incom_checks."Code";


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

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


ALTER TABLE public.incom_checks_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.incom_checks_id_seq OWNED BY public.incom_checks.id;


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

CREATE TABLE public.incom_manufacturing_models (
    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,
    "Cost" 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,
    "Depreciation" text NOT NULL,
    "Depreciation_Qty" text NOT NULL,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "Unit" bigint,
    "Model" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Precent" text
);


ALTER TABLE public.incom_manufacturing_models OWNER TO postgres;

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

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


ALTER TABLE public.incom_manufacturing_models_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.incom_manufacturing_models_id_seq OWNED BY public.incom_manufacturing_models.id;


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

CREATE TABLE public.incom_manufacturing_secretariat_models (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "Precent" text,
    "Qty" text,
    "Cost" text,
    "Discount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total" text,
    "Total_Tax" text,
    "Depreciation" text,
    "Depreciation_Qty" text,
    "Store" text,
    "Product" text,
    "Unit" text,
    "Model" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.incom_manufacturing_secretariat_models OWNER TO postgres;

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

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


ALTER TABLE public.incom_manufacturing_secretariat_models_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.incom_manufacturing_secretariat_models_id_seq OWNED BY public.incom_manufacturing_secretariat_models.id;


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

CREATE TABLE public.install_companies_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,
    "Client" text,
    "InstallCompany" text,
    "ContractNumber" text,
    "PayFees" text,
    "ServiceFee" text,
    "CompanyPrecent" 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
);


ALTER TABLE public.install_companies_sales_bills_columns OWNER TO postgres;

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

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


ALTER TABLE public.install_companies_sales_bills_columns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.install_companies_sales_bills_columns_id_seq OWNED BY public.install_companies_sales_bills_columns.id;


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

CREATE TABLE public.install_companies_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,
    "Client" text,
    "InstallCompany" text,
    "ContractNumber" text,
    "PayFees" text,
    "ServiceFee" text,
    "CompanyPrecent" 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
);


ALTER TABLE public.install_companies_sales_bills_columns_sechdules OWNER TO postgres;

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

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


ALTER TABLE public.install_companies_sales_bills_columns_sechdules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.install_companies_sales_bills_columns_sechdules_id_seq OWNED BY public.install_companies_sales_bills_columns_sechdules.id;


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

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


ALTER TABLE public.installment_companies OWNER TO postgres;

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

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


ALTER TABLE public.installment_companies_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.installment_companies_id_seq OWNED BY public.installment_companies.id;


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

CREATE TABLE public.installment_companies_ratios (
    id bigint NOT NULL,
    "From" text,
    "To" text,
    "Service_Fee" text,
    "Company_Precent" text,
    "Company" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.installment_companies_ratios OWNER TO postgres;

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

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


ALTER TABLE public.installment_companies_ratios_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.installment_companies_ratios_id_seq OWNED BY public.installment_companies_ratios.id;


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

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


ALTER TABLE public.installment_dates OWNER TO postgres;

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

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


ALTER TABLE public.installment_dates_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.installment_dates_id_seq OWNED BY public.installment_dates.id;


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

CREATE TABLE public.installments (
    id bigint NOT NULL,
    presenter text,
    annual_interest text,
    monthly_installment text,
    "Years_Number" text,
    total text,
    "installment_Num" text,
    "Date_First_installment" text,
    "Residual" text,
    "Status" text,
    "Client" bigint NOT NULL,
    "Sales" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.installments OWNER TO postgres;

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

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


ALTER TABLE public.installments_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.installments_id_seq OWNED BY public.installments.id;


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

CREATE TABLE public.insurance_companies (
    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.insurance_companies OWNER TO postgres;

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

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


ALTER TABLE public.insurance_companies_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.insurance_companies_id_seq OWNED BY public.insurance_companies.id;


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

CREATE TABLE public.insurance_papers (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Note" text,
    "Due_Date" text NOT NULL,
    "Amount" text NOT NULL,
    "Status" text DEFAULT '0'::text NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "Account" bigint NOT NULL,
    "Bank" bigint,
    arr bigint,
    "User" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "From" text,
    "To" text,
    "File" text,
    "FromEn" text,
    "ToEn" text,
    "Delete" text
);


ALTER TABLE public.insurance_papers OWNER TO postgres;

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

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


ALTER TABLE public.insurance_papers_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.insurance_papers_arr_seq OWNED BY public.insurance_papers."Code";


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

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


ALTER TABLE public.insurance_papers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.insurance_papers_id_seq OWNED BY public.insurance_papers.id;


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

CREATE TABLE public.interviews (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Time" text NOT NULL,
    "Status" text DEFAULT '0'::text NOT NULL,
    "Rate" text DEFAULT '0'::text NOT NULL,
    "Note" text,
    "Emp" bigint,
    "Client" bigint,
    "Type" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "StatusNote" text
);


ALTER TABLE public.interviews OWNER TO postgres;

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

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


ALTER TABLE public.interviews_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.interviews_arr_seq OWNED BY public.interviews.arr;


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

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


ALTER TABLE public.interviews_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.interviews_id_seq OWNED BY public.interviews.id;


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

CREATE TABLE public.interviews_types (
    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.interviews_types OWNER TO postgres;

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

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


ALTER TABLE public.interviews_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.interviews_types_id_seq OWNED BY public.interviews_types.id;


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

CREATE TABLE public.intros (
    id bigint NOT NULL,
    "Arabic_About" text,
    "English_About" text,
    "Phone_1" text,
    "Phone_2" text,
    "Phone_3" text,
    "Phone_4" text,
    "Arabic_Terms" text,
    "English_Terms" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Arabic_Privacy" text,
    "English_Privacy" text
);


ALTER TABLE public.intros OWNER TO postgres;

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

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


ALTER TABLE public.intros_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.intros_id_seq OWNED BY public.intros.id;


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

CREATE TABLE public.inventories (
    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,
    "Account_Excess" bigint NOT NULL,
    "Account_Dificit" bigint NOT NULL,
    "Store" bigint,
    "Coin" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Note" text,
    "Settle" character varying DEFAULT 0,
    "Edit" text DEFAULT 0,
    "Delete" text DEFAULT 0,
    "Edit_New_Code" text DEFAULT 0
);


ALTER TABLE public.inventories OWNER TO postgres;

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

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


ALTER TABLE public.inventories_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.inventories_arr_seq OWNED BY public.inventories.arr;


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

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


ALTER TABLE public.inventories_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.inventories_id_seq OWNED BY public.inventories.id;


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

CREATE TABLE public.investors (
    id bigint NOT NULL,
    "Date" text,
    "Name" text,
    "Investment_Value" text,
    "Safe" text,
    "Draw" text,
    "Coin" text,
    "Profit_Precent" text,
    "Investment_Period" text,
    "Liquidation_Time" text,
    "Status" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "End_Date" text,
    "Account" text,
    "Due_Account" text,
    "Expenses_Account" text
);


ALTER TABLE public.investors OWNER TO postgres;

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

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


ALTER TABLE public.investors_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.investors_id_seq OWNED BY public.investors.id;


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

CREATE TABLE public.issues (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Time" text,
    "Client" text,
    "Link" text,
    "Status" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.issues OWNER TO postgres;

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

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


ALTER TABLE public.issues_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.issues_id_seq OWNED BY public.issues.id;


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

CREATE TABLE public.items_groups (
    id bigint NOT NULL,
    "Code" text,
    "Name" text NOT NULL,
    "Type" text NOT NULL,
    "Parent" text NOT NULL,
    "Note" text,
    "Image" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Discount" text,
    "Store_Show" text,
    "Sales_Show" text,
    "NameEn" text,
    "Printer" text,
    "Arrange" bigint,
    "Sales_Precet" text DEFAULT 0
);


ALTER TABLE public.items_groups OWNER TO postgres;

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

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


ALTER TABLE public.items_groups_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.items_groups_id_seq OWNED BY public.items_groups.id;


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

CREATE TABLE public.itineraries (
    id bigint NOT NULL,
    "Emp" text,
    "Day" text,
    "Time" text,
    "Client" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.itineraries OWNER TO postgres;

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

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


ALTER TABLE public.itineraries_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.itineraries_id_seq OWNED BY public.itineraries.id;


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

CREATE TABLE public.itinerary_visits (
    id bigint NOT NULL,
    "Emp" text,
    "Date" text,
    "Day" text,
    "Time" text,
    "Status" text,
    "Note" text,
    "Client" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.itinerary_visits OWNER TO postgres;

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

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


ALTER TABLE public.itinerary_visits_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.itinerary_visits_id_seq OWNED BY public.itinerary_visits.id;


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

CREATE TABLE public.job_orders (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Draw" 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,
    "ShipStatus" text,
    "Client" text,
    "Executor" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Later_Due" text,
    "Later_Collection" text,
    "TaxBill" text,
    "TaxCode" text,
    "ProfitPrecent" text,
    "TaxOnTotal" text,
    "TaxOnTotalType" text,
    "ProfitTax" text,
    "Time" text,
    "Branch" text,
    "CustomerGroup" text,
    "Total_Cost" text,
    "DiscountTax" text,
    "RecivedDate" text,
    "Recipient" text,
    "RecivedVoucherCode" text,
    "TransferOrder" text,
    "ExecuteOrder" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Edit" text DEFAULT 0,
    "Delete" text DEFAULT 0,
    "Edit_New_Code" text DEFAULT 0,
    "Current_Credit" text,
    "Execute" text
);


ALTER TABLE public.job_orders OWNER TO postgres;

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

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


ALTER TABLE public.job_orders_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.job_orders_arr_seq OWNED BY public.job_orders."Code";


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

CREATE TABLE public.job_orders_executors (
    id bigint NOT NULL,
    "Product" text,
    "Executor" text,
    "Order" text,
    "Status" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.job_orders_executors OWNER TO postgres;

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

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


ALTER TABLE public.job_orders_executors_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.job_orders_executors_id_seq OWNED BY public.job_orders_executors.id;


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

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


ALTER TABLE public.job_orders_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.job_orders_id_seq OWNED BY public.job_orders.id;


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

CREATE TABLE public.jobs_types (
    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.jobs_types OWNER TO postgres;

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

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


ALTER TABLE public.jobs_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.jobs_types_id_seq OWNED BY public.jobs_types.id;


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

CREATE TABLE public.jouns (
    id bigint NOT NULL,
    "Draw" text,
    "Coin" text,
    "Cost_Center" text,
    "Note" text,
    "Debitor" text,
    "Creditor" text,
    "Account" text,
    "Statement" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.jouns OWNER TO postgres;

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

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


ALTER TABLE public.jouns_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.jouns_id_seq OWNED BY public.jouns.id;


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

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


ALTER TABLE public.journalizing_details OWNER TO postgres;

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

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


ALTER TABLE public.journalizing_details_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.journalizing_details_id_seq OWNED BY public.journalizing_details.id;


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

CREATE TABLE public.journalizings (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Total_Debaitor" character varying,
    "Total_Creditor" character varying,
    "Note" character varying,
    "Type" character varying,
    "Code_Type" text,
    "Branch" bigint,
    "Status" text,
    "TypeEn" text,
    arr bigint,
    "Edit" text,
    "Edit_New_Code" text,
    "Delete" text,
    "Transfer" text
);


ALTER TABLE public.journalizings OWNER TO postgres;

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

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


ALTER TABLE public.journalizings_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.journalizings_arr_seq OWNED BY public.journalizings.arr;


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

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


ALTER TABLE public.journalizings_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.journalizings_id_seq OWNED BY public.journalizings.id;


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

CREATE TABLE public.languages (
    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.languages OWNER TO postgres;

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

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


ALTER TABLE public.languages_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.languages_id_seq OWNED BY public.languages.id;


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

CREATE TABLE public.loan_types (
    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.loan_types OWNER TO postgres;

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

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


ALTER TABLE public.loan_types_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.loan_types_id_seq OWNED BY public.loan_types.id;


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

CREATE TABLE public.loans (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Amount" text NOT NULL,
    "Years_Number" text NOT NULL,
    "First_Date" text NOT NULL,
    "Install" text NOT NULL,
    "Install_Numbers" text NOT NULL,
    "Note" text,
    "Draw" text NOT NULL,
    "Safe" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "Emp" bigint,
    "Type" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Delete" text DEFAULT 0,
    "Refernce_Number" text
);


ALTER TABLE public.loans OWNER TO postgres;

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

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


ALTER TABLE public.loans_arr_seq OWNER TO postgres;

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

ALTER SEQUENCE public.loans_arr_seq OWNED BY public.loans."Code";


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

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


ALTER TABLE public.loans_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.loans_id_seq OWNED BY public.loans.id;


--
-- Name: login_sliders; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.login_sliders (
    id bigint NOT NULL,
    "Image" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.login_sliders OWNER TO postgres;

--
-- Name: login_sliders_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.login_sliders_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.login_sliders_id_seq OWNER TO postgres;

--
-- Name: login_sliders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.login_sliders_id_seq OWNED BY public.login_sliders.id;


--
-- Name: main_e_com_designs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.main_e_com_designs (
    id bigint NOT NULL,
    "Font_Type" text,
    "Pagination_BG_Color" text,
    "Pagination_Txt_Color" text,
    "Pagination_Active_BG_Color" text,
    "Pagination_Active_Txt_Color" text,
    "Body_BG_Type" text,
    "Body_BG_Image" text,
    "Body_BG_Color" text,
    "Sub_Page_BG_Color" text,
    "Breadcumb_BG_Color" text,
    "Breadcumb_Txt_Color" text,
    "Modal_BG_Color" text,
    "Modal_Txt_Color" text,
    "Modal_Button_BG_Color" text,
    "Modal_Button_Txt_Color" text,
    "Table_Header_BG_Color" text,
    "Table_Header_Txt_Color" text,
    "Table_Body_BG_Color" text,
    "Table_Body_Txt_Color" text,
    "Table_Button_BG_Color" text,
    "Table_Button_Txt_Color" text,
    "CopyRights_Txt_Color" text,
    "CopyRights_Klar_Txt_Color" text,
    "CopyRights_Klar_Hover_Txt_Color" text,
    "Preloader_BG_Color" text,
    "Preloader_Small_Circle_Color" text,
    "Preloader_Large_Circle_Color" text,
    "Footer_Title_Color" text,
    "Footer_Txt_Color" text,
    "Footer_Social_Color" text,
    "Footer_Social_Hover_BG_Color" text,
    "Footer_Social_Hover_Txt_Color" text,
    "Header_Top_BG_Color" text,
    "Header_Top_Txt_Color" text,
    "Header_Top_Txt_Hover_Color" text,
    "Header_Middle_BG_Color" text,
    "Header_Middle_Icon_Color" text,
    "Header_Middle_Icon_Hover_Color" text,
    "Header_SearchBar_BG_Color" text,
    "Header_SearchBar_Txt_Color" text,
    "Header_SearchBar_Icon_BG_Color" text,
    "Header_SearchBar_Icon_Txt_Color" text,
    "Header_SearchBar_Icon_Hover_BG_Color" text,
    "Header_SearchBar_Icon_Hover_Txt_Color" text,
    "Navbar_BG_Color" text,
    "Navbar_Txt_Color" text,
    "Navbar_Hover_BG_Color" text,
    "Navbar_Hover_Txt_Color" text,
    "Navbar_Category_BG_Color" text,
    "Navbar_Category_Txt_Color" text,
    "Navbar_Category_Box_BG_Color" text,
    "Navbar_Category_Box_Txt_Color" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Footer_Social_BG_Color" text,
    "Footer_Txt_Hover_Color" text
);


ALTER TABLE public.main_e_com_designs OWNER TO postgres;

--
-- Name: main_e_com_designs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.main_e_com_designs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.main_e_com_designs_id_seq OWNER TO postgres;

--
-- Name: main_e_com_designs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.main_e_com_designs_id_seq OWNED BY public.main_e_com_designs.id;


--
-- Name: maintainc_bills; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.maintainc_bills (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Product_Numbers" text NOT NULL,
    "Total_Qty" text NOT NULL,
    "Total_Price" text NOT NULL,
    "Note" text,
    "Serial_Num" text,
    "Draw" text NOT NULL,
    "Company" bigint,
    "Device_Type" bigint,
    "Device_Case" bigint,
    "Coin" bigint,
    "Cost_Center" bigint,
    "Account" bigint,
    "User" bigint,
    arr bigint,
    "Recipt" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Store" bigint,
    "Total_Price_Errors" text,
    "Totaal" text,
    "Safe" bigint
);


ALTER TABLE public.maintainc_bills OWNER TO postgres;

--
-- Name: maintainc_bills_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.maintainc_bills_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.maintainc_bills_arr_seq OWNER TO postgres;

--
-- Name: maintainc_bills_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.maintainc_bills_arr_seq OWNED BY public.maintainc_bills.arr;


--
-- Name: maintainc_bills_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.maintainc_bills_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.maintainc_bills_id_seq OWNER TO postgres;

--
-- Name: maintainc_bills_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.maintainc_bills_id_seq OWNED BY public.maintainc_bills.id;


--
-- Name: maintaince_colors; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.maintaince_colors (
    id bigint NOT NULL,
    "Refuse" text,
    "Reported_Client" text,
    "Refused_Client" text,
    "Edited" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.maintaince_colors OWNER TO postgres;

--
-- Name: maintaince_colors_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.maintaince_colors_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.maintaince_colors_id_seq OWNER TO postgres;

--
-- Name: maintaince_colors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.maintaince_colors_id_seq OWNED BY public.maintaince_colors.id;


--
-- Name: maintaince_default_data; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.maintaince_default_data (
    id bigint NOT NULL,
    "Company" text,
    "Device_Type" text,
    "Device_Case" text,
    "Coin" text,
    "Cost_Center" text,
    "Draw" text,
    "Client" text,
    "Sure" text,
    "Eng" text,
    "Recipient" text,
    "Store" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.maintaince_default_data OWNER TO postgres;

--
-- Name: maintaince_default_data_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.maintaince_default_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.maintaince_default_data_id_seq OWNER TO postgres;

--
-- Name: maintaince_default_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.maintaince_default_data_id_seq OWNED BY public.maintaince_default_data.id;


--
-- Name: manu_store_counts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.manu_store_counts (
    id bigint NOT NULL,
    "Store" text NOT NULL,
    "Total" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.manu_store_counts OWNER TO postgres;

--
-- Name: manu_store_counts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manu_store_counts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manu_store_counts_id_seq OWNER TO postgres;

--
-- Name: manu_store_counts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manu_store_counts_id_seq OWNED BY public.manu_store_counts.id;


--
-- Name: manufacture_companies; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.manufacture_companies (
    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.manufacture_companies OWNER TO postgres;

--
-- Name: manufacture_companies_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacture_companies_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacture_companies_id_seq OWNER TO postgres;

--
-- Name: manufacture_companies_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacture_companies_id_seq OWNED BY public.manufacture_companies.id;


--
-- Name: manufacturing_default_data; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.manufacturing_default_data (
    id bigint NOT NULL,
    "Coin" text,
    "Draw" text,
    "Hall" text,
    "Manu_Type" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Executing_Qty" text
);


ALTER TABLE public.manufacturing_default_data OWNER TO postgres;

--
-- Name: manufacturing_default_data_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_default_data_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_default_data_id_seq OWNER TO postgres;

--
-- Name: manufacturing_default_data_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_default_data_id_seq OWNED BY public.manufacturing_default_data.id;


--
-- Name: manufacturing_executions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.manufacturing_executions (
    id bigint NOT NULL,
    "Code" text,
    "NewCode" text,
    "Date" text,
    "Manu_Order_Code" text,
    "Manu_Order_Date" text,
    "Recived_Date" text,
    "Manu_Request_Code" text,
    "Outcome_Name" text,
    "Outcome_Code" text,
    "Outcome_Qty" text,
    "Except_Qty" text,
    "Outcome_Unit" text,
    "Outcome_Store" text,
    "Patch_Number" text,
    "Manu_Order_ID" bigint,
    "Production_Manager" bigint,
    "Quality_Manager" bigint,
    "Model" bigint,
    "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.manufacturing_executions OWNER TO postgres;

--
-- Name: manufacturing_executions_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_executions_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_executions_arr_seq OWNER TO postgres;

--
-- Name: manufacturing_executions_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_executions_arr_seq OWNED BY public.manufacturing_executions.arr;


--
-- Name: manufacturing_executions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_executions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_executions_id_seq OWNER TO postgres;

--
-- Name: manufacturing_executions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_executions_id_seq OWNED BY public.manufacturing_executions.id;


--
-- Name: manufacturing_halls; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.manufacturing_halls (
    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.manufacturing_halls OWNER TO postgres;

--
-- Name: manufacturing_halls_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_halls_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_halls_id_seq OWNER TO postgres;

--
-- Name: manufacturing_halls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_halls_id_seq OWNED BY public.manufacturing_halls.id;


--
-- Name: manufacturing_models; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.manufacturing_models (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Name" text NOT NULL,
    "Time" text NOT NULL,
    "Draw" text NOT NULL,
    "Note" text,
    "Product_Numbers" text NOT NULL,
    "Total_Discount" text NOT NULL,
    "Total_BF_Taxes" text NOT NULL,
    "Total_Taxes" text NOT NULL,
    "Total_Price" text NOT NULL,
    "Hall" bigint,
    "Coin" bigint,
    "Cost_Center" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Type" text DEFAULT 1,
    "NameEn" text,
    "Incom_Store" text,
    "Outcom_Store" text,
    "Workmanship_Price" text
);


ALTER TABLE public.manufacturing_models OWNER TO postgres;

--
-- Name: manufacturing_models_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_models_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_models_arr_seq OWNER TO postgres;

--
-- Name: manufacturing_models_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_models_arr_seq OWNED BY public.manufacturing_models."Code";


--
-- Name: manufacturing_models_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_models_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_models_id_seq OWNER TO postgres;

--
-- Name: manufacturing_models_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_models_id_seq OWNED BY public.manufacturing_models.id;


--
-- Name: manufacturing_orders; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.manufacturing_orders (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Model" text,
    "Name_Outcome" text,
    "Except_Qty" text,
    "Total_Required_Qty" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Status" text,
    "For_Client" text,
    "Client" bigint,
    "Client_Phone" text,
    "Client_Address" text,
    "Delegate" bigint,
    arr bigint,
    "Delegate_Phone" text,
    "Recived_Date" text,
    "Manufacture_Request_Code" bigint,
    "NewCode" text,
    "Recipient" text
);


ALTER TABLE public.manufacturing_orders OWNER TO postgres;

--
-- Name: manufacturing_orders_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_orders_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_orders_arr_seq OWNER TO postgres;

--
-- Name: manufacturing_orders_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_orders_arr_seq OWNED BY public.manufacturing_orders.arr;


--
-- Name: manufacturing_orders_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_orders_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_orders_id_seq OWNER TO postgres;

--
-- Name: manufacturing_orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_orders_id_seq OWNED BY public.manufacturing_orders.id;


--
-- Name: manufacturing_requests; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.manufacturing_requests (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Recived_Date" text,
    "Client_Phone" text,
    "Client_Address" text,
    "Client" bigint NOT NULL,
    "Delegate" bigint,
    "Delegate_Phone" text,
    "Payment_Method" text,
    "Later_Due" text,
    "Note" text,
    "Status" text,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Product_Numbers" text,
    "Total_Qty" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Pay" text,
    "Store" bigint
);


ALTER TABLE public.manufacturing_requests OWNER TO postgres;

--
-- Name: manufacturing_requests_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_requests_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_requests_arr_seq OWNER TO postgres;

--
-- Name: manufacturing_requests_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_requests_arr_seq OWNED BY public.manufacturing_requests.arr;


--
-- Name: manufacturing_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_requests_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_requests_id_seq OWNER TO postgres;

--
-- Name: manufacturing_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_requests_id_seq OWNED BY public.manufacturing_requests.id;


--
-- Name: manufacturing_secretariat_models; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.manufacturing_secretariat_models (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Name" text,
    "Time" text,
    "Draw" text,
    "Note" text,
    "Product_Numbers" text,
    "Total_Discount" text,
    "Total_BF_Taxes" text,
    "Total_Taxes" text,
    "Total_Price" text,
    "Hall" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Type" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "NameEn" text,
    arr bigint,
    "Incom_Store" text DEFAULT 0,
    "Outcom_Store" text DEFAULT 0
);


ALTER TABLE public.manufacturing_secretariat_models OWNER TO postgres;

--
-- Name: manufacturing_secretariat_models_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_secretariat_models_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_secretariat_models_arr_seq OWNER TO postgres;

--
-- Name: manufacturing_secretariat_models_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_secretariat_models_arr_seq OWNED BY public.manufacturing_secretariat_models.arr;


--
-- Name: manufacturing_secretariat_models_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.manufacturing_secretariat_models_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manufacturing_secretariat_models_id_seq OWNER TO postgres;

--
-- Name: manufacturing_secretariat_models_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.manufacturing_secretariat_models_id_seq OWNED BY public.manufacturing_secretariat_models.id;


--
-- Name: measuerments; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.measuerments (
    id bigint NOT NULL,
    "Name" text NOT NULL,
    "Note" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Code" text,
    "NameEn" text
);


ALTER TABLE public.measuerments OWNER TO postgres;

--
-- Name: measuerments_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.measuerments_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.measuerments_id_seq OWNER TO postgres;

--
-- Name: measuerments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.measuerments_id_seq OWNED BY public.measuerments.id;


--
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.migrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 2147483647
    CACHE 1;


ALTER TABLE public.migrations_id_seq OWNER TO postgres;

--
-- Name: migrations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.migrations (
    id integer DEFAULT nextval('public.migrations_id_seq'::regclass) NOT NULL,
    migration character varying(191),
    batch integer
);


ALTER TABLE public.migrations OWNER TO postgres;

--
-- Name: missions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.missions (
    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,
    "Status" text NOT NULL,
    "File" text,
    "Desc" text,
    "Task_Owner" bigint,
    "Observer" bigint,
    "Project" bigint,
    "User" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "NameEn" text
);


ALTER TABLE public.missions OWNER TO postgres;

--
-- Name: missions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.missions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.missions_id_seq OWNER TO postgres;

--
-- Name: missions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.missions_id_seq OWNED BY public.missions.id;


--
-- Name: model_has_permissions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.model_has_permissions (
    permission_id bigint NOT NULL,
    model_type character varying(191) NOT NULL,
    model_id bigint NOT NULL
);


ALTER TABLE public.model_has_permissions OWNER TO postgres;

--
-- Name: model_has_roles; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.model_has_roles (
    role_id bigint NOT NULL,
    model_type character varying(191) NOT NULL,
    model_id bigint NOT NULL
);


ALTER TABLE public.model_has_roles OWNER TO postgres;

--
-- Name: module_settings_nums; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.module_settings_nums (
    id bigint NOT NULL,
    "Branch_Select" text,
    "Branch_Num" text,
    "Store_Select" text,
    "Store_Num" text,
    "Users_Select" text,
    "Users_Num" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "System" text,
    "Expire_Date" text,
    "Type" text,
    "Price" text,
    "Edit_System" text,
    "Delete_System" text,
    "Fingerprint" text,
    "Fingerprint_IP" text,
    "Fingerprint_Name" text,
    "Fingerprint_Attendence" text
);


ALTER TABLE public.module_settings_nums OWNER TO postgres;

--
-- Name: module_settings_nums_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.module_settings_nums_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.module_settings_nums_id_seq OWNER TO postgres;

--
-- Name: module_settings_nums_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.module_settings_nums_id_seq OWNED BY public.module_settings_nums.id;


--
-- Name: modules; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.modules (
    id bigint NOT NULL,
    "Capital" text,
    "Accounts" text,
    "Stores" text,
    "CRM" text,
    "HR" text,
    "Manufacturing" text,
    "Maintenance" text,
    "Secretariat" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Petrol" text,
    "ECommerce" text,
    "Shipping" text DEFAULT 0,
    "Bill_Electronic" text,
    "Hotels" text,
    "Resturant" text,
    "Traning_Center" text,
    "Translate" text,
    "Real_States" text DEFAULT 0
);


ALTER TABLE public.modules OWNER TO postgres;

--
-- Name: modules_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.modules_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.modules_id_seq OWNER TO postgres;

--
-- Name: modules_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.modules_id_seq OWNED BY public.modules.id;


--
-- Name: more_products_halls; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.more_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.more_products_halls OWNER TO postgres;

--
-- Name: more_products_halls_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.more_products_halls_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.more_products_halls_id_seq OWNER TO postgres;

--
-- Name: more_products_halls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.more_products_halls_id_seq OWNED BY public.more_products_halls.id;


--
-- Name: most_sales_products_column_sechdules; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.most_sales_products_column_sechdules (
    id bigint NOT NULL,
    "Product_Code" text,
    "Product_Name" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Tax" text,
    "Total" text,
    "Store" text,
    "Date" text,
    "Unit" text,
    "Safe" text,
    "Branch" text,
    "Group" text,
    "Brand" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.most_sales_products_column_sechdules OWNER TO postgres;

--
-- Name: most_sales_products_column_sechdules_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.most_sales_products_column_sechdules_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.most_sales_products_column_sechdules_id_seq OWNER TO postgres;

--
-- Name: most_sales_products_column_sechdules_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.most_sales_products_column_sechdules_id_seq OWNED BY public.most_sales_products_column_sechdules.id;


--
-- Name: most_sales_products_columns; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.most_sales_products_columns (
    id bigint NOT NULL,
    "Product_Code" text,
    "Product_Name" text,
    "Qty" text,
    "Price" text,
    "Discount" text,
    "Tax" text,
    "Total" text,
    "Store" text,
    "Date" text,
    "Unit" text,
    "Safe" text,
    "Branch" text,
    "Group" text,
    "Brand" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.most_sales_products_columns OWNER TO postgres;

--
-- Name: most_sales_products_columns_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.most_sales_products_columns_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.most_sales_products_columns_id_seq OWNER TO postgres;

--
-- Name: most_sales_products_columns_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.most_sales_products_columns_id_seq OWNED BY public.most_sales_products_columns.id;


--
-- Name: msg_rqsts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.msg_rqsts (
    id bigint NOT NULL,
    "Name" text,
    "Email" text,
    "Phone" text,
    "Subject" text,
    "Msg" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.msg_rqsts OWNER TO postgres;

--
-- Name: msg_rqsts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.msg_rqsts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.msg_rqsts_id_seq OWNER TO postgres;

--
-- Name: msg_rqsts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.msg_rqsts_id_seq OWNED BY public.msg_rqsts.id;


--
-- Name: my_follow_lists; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.my_follow_lists (
    id bigint NOT NULL,
    "Date" text,
    "Emp" text,
    "Day" text,
    "Status" text,
    "Client" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.my_follow_lists OWNER TO postgres;

--
-- Name: my_follow_lists_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.my_follow_lists_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.my_follow_lists_id_seq OWNER TO postgres;

--
-- Name: my_follow_lists_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.my_follow_lists_id_seq OWNED BY public.my_follow_lists.id;


--
-- Name: new_shipping_categories; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.new_shipping_categories (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Code" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.new_shipping_categories OWNER TO postgres;

--
-- Name: new_shipping_categories_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.new_shipping_categories_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.new_shipping_categories_id_seq OWNER TO postgres;

--
-- Name: new_shipping_categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.new_shipping_categories_id_seq OWNED BY public.new_shipping_categories.id;


--
-- Name: new_shipping_rqst_types; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.new_shipping_rqst_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.new_shipping_rqst_types OWNER TO postgres;

--
-- Name: new_shipping_rqst_types_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.new_shipping_rqst_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.new_shipping_rqst_types_id_seq OWNER TO postgres;

--
-- Name: new_shipping_rqst_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.new_shipping_rqst_types_id_seq OWNED BY public.new_shipping_rqst_types.id;


--
-- Name: new_shipping_types; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.new_shipping_types (
    id bigint NOT NULL,
    "Arabic_Name" text,
    "English_Name" text,
    "Code" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.new_shipping_types OWNER TO postgres;

--
-- Name: new_shipping_types_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.new_shipping_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.new_shipping_types_id_seq OWNER TO postgres;

--
-- Name: new_shipping_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.new_shipping_types_id_seq OWNED BY public.new_shipping_types.id;


--
-- Name: notifications; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.notifications (
    id bigint NOT NULL,
    "Date" text,
    "Status" text,
    "Noti_Ar_Name" text,
    "Noti_En_Name" text,
    "Type" text,
    "Type_Code" text,
    "Emp" text,
    "Client" text,
    "Product" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Store" text,
    "Safe" text,
    "TypeEn" text
);


ALTER TABLE public.notifications OWNER TO postgres;

--
-- Name: notifications_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.notifications_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.notifications_id_seq OWNER TO postgres;

--
-- Name: notifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.notifications_id_seq OWNED BY public.notifications.id;


--
-- Name: opening_entries; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.opening_entries (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Total_Debaitor" text NOT NULL,
    "Total_Creditor" text NOT NULL,
    "Note" text,
    "Capital" text NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "SecAccount" bigint,
    "Status" text,
    "Edit" text,
    "Edit_New_Code" text,
    "Delete" text
);


ALTER TABLE public.opening_entries OWNER TO postgres;

--
-- Name: opening_entries_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.opening_entries_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.opening_entries_arr_seq OWNER TO postgres;

--
-- Name: opening_entries_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.opening_entries_arr_seq OWNED BY public.opening_entries.arr;


--
-- Name: opening_entries_details; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.opening_entries_details (
    id bigint NOT NULL,
    "Debitor" text NOT NULL,
    "Creditor" text NOT NULL,
    "Statement" text,
    "Account" bigint NOT NULL,
    "OP_ID" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.opening_entries_details OWNER TO postgres;

--
-- Name: opening_entries_details_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.opening_entries_details_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.opening_entries_details_id_seq OWNER TO postgres;

--
-- Name: opening_entries_details_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.opening_entries_details_id_seq OWNED BY public.opening_entries_details.id;


--
-- Name: opening_entries_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.opening_entries_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.opening_entries_id_seq OWNER TO postgres;

--
-- Name: opening_entries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.opening_entries_id_seq OWNED BY public.opening_entries.id;


--
-- Name: order_pays; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.order_pays (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Responsible" text,
    "Account" text,
    "Amount" text,
    "Note" text,
    "Status" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.order_pays OWNER TO postgres;

--
-- Name: order_pays_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.order_pays_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.order_pays_id_seq OWNER TO postgres;

--
-- Name: order_pays_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.order_pays_id_seq OWNED BY public.order_pays.id;


--
-- Name: outcom_manufacturing_models; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.outcom_manufacturing_models (
    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,
    "Store" bigint NOT NULL,
    "Product" bigint,
    "Unit" bigint,
    "Model" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Cost" text,
    "SmallQty" text,
    "SmallCode" text
);


ALTER TABLE public.outcom_manufacturing_models OWNER TO postgres;

--
-- Name: outcom_manufacturing_models_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.outcom_manufacturing_models_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.outcom_manufacturing_models_id_seq OWNER TO postgres;

--
-- Name: outcom_manufacturing_models_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.outcom_manufacturing_models_id_seq OWNED BY public.outcom_manufacturing_models.id;


--
-- Name: outcome_manufacturing_secretariat_models; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.outcome_manufacturing_secretariat_models (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "Qty" text,
    "SmallQty" text,
    "SmallCode" text,
    "Store" text,
    "Product" text,
    "Unit" text,
    "Model" text,
    "Cost" text,
    "Workmanship_Price" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.outcome_manufacturing_secretariat_models OWNER TO postgres;

--
-- Name: outcome_manufacturing_secretariat_models_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.outcome_manufacturing_secretariat_models_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.outcome_manufacturing_secretariat_models_id_seq OWNER TO postgres;

--
-- Name: outcome_manufacturing_secretariat_models_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.outcome_manufacturing_secretariat_models_id_seq OWNED BY public.outcome_manufacturing_secretariat_models.id;


--
-- Name: over_times; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.over_times (
    id bigint NOT NULL,
    "Arabic_Name" text NOT NULL,
    "English_Name" text,
    "Hour" text NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.over_times OWNER TO postgres;

--
-- Name: over_times_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.over_times_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.over_times_id_seq OWNER TO postgres;

--
-- Name: over_times_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.over_times_id_seq OWNED BY public.over_times.id;


--
-- Name: pack_prems; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.pack_prems (
    id bigint NOT NULL,
    package text,
    premission text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.pack_prems OWNER TO postgres;

--
-- Name: pack_prems_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.pack_prems_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pack_prems_id_seq OWNER TO postgres;

--
-- Name: pack_prems_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.pack_prems_id_seq OWNED BY public.pack_prems.id;


--
-- Name: packages; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.packages (
    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.packages OWNER TO postgres;

--
-- Name: packages_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.packages_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.packages_id_seq OWNER TO postgres;

--
-- Name: packages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.packages_id_seq OWNED BY public.packages.id;


--
-- Name: partners; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.partners (
    id bigint NOT NULL,
    "Name" text NOT NULL,
    "Shares_Number" text NOT NULL,
    "Nominal_Value_of_Shares" text,
    "Actual_Share_Value" text,
    "Profits_Precentage" text,
    "Profits" text,
    "Withdraw_Profits" text,
    "Remaining_Profits" text,
    "Account" bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Gary_Account" text,
    "Recent_Profit_Account" text,
    "Stage_Profit_Account" text,
    "First_Partner_Share" text,
    "Now_Partner_Share" text,
    "Capital_Increase_Rate" text,
    "Capital_Increase_Value" text,
    "Partnership_Ratio" text
);


ALTER TABLE public.partners OWNER TO postgres;

--
-- Name: partners_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.partners_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.partners_id_seq OWNER TO postgres;

--
-- Name: partners_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.partners_id_seq OWNED BY public.partners.id;


--
-- Name: password_resets; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.password_resets (
    email character varying(191) NOT NULL,
    token character varying(191) NOT NULL,
    created_at timestamp(0) without time zone
);


ALTER TABLE public.password_resets OWNER TO postgres;

--
-- Name: pay_profit_investors; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.pay_profit_investors (
    id bigint NOT NULL,
    "Date" text,
    "Profit" text,
    "Investor" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.pay_profit_investors OWNER TO postgres;

--
-- Name: pay_profit_investors_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.pay_profit_investors_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pay_profit_investors_id_seq OWNER TO postgres;

--
-- Name: pay_profit_investors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.pay_profit_investors_id_seq OWNED BY public.pay_profit_investors.id;


--
-- Name: pay_salaries; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.pay_salaries (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Month" text NOT NULL,
    "Salary" text NOT NULL,
    "Pre_Sales" text,
    "Pre_Execu" text,
    "Deduction" text NOT NULL,
    "Entitlement" text NOT NULL,
    "Borrow" text NOT NULL,
    "Overtime" text,
    "Attendence_Hours" text,
    "Attendence" text,
    "Loan" text,
    "Holidays" text,
    "Resduial_Salary" text,
    "Note" text,
    "Draw" text NOT NULL,
    "Safe" bigint NOT NULL,
    "Coin" bigint NOT NULL,
    "Cost_Center" bigint,
    "Emp" bigint,
    "User" bigint,
    arr bigint,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Attendence_Discount" text,
    "Holiday_Discount" text,
    "Settlements" text,
    "Later_Sales_Bill" text,
    "Allowances" text,
    "Discounts" text,
    "ProducationPoints" text,
    "DiscountLate" text,
    "DiscountDeparture" text,
    "Shipping_Precent" text,
    "Delete" text DEFAULT 0,
    "Refernce_Number" text
);


ALTER TABLE public.pay_salaries OWNER TO postgres;

--
-- Name: pay_salaries_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.pay_salaries_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pay_salaries_arr_seq OWNER TO postgres;

--
-- Name: pay_salaries_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.pay_salaries_arr_seq OWNED BY public.pay_salaries."Code";


--
-- Name: pay_salaries_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.pay_salaries_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pay_salaries_id_seq OWNER TO postgres;

--
-- Name: pay_salaries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.pay_salaries_id_seq OWNED BY public.pay_salaries.id;


--
-- Name: payment_voucher_details; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.payment_voucher_details (
    id bigint NOT NULL,
    "Debitor" text NOT NULL,
    "Statement" text,
    "Account" bigint NOT NULL,
    "PV_ID" bigint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Date" text,
    "Time" text,
    "Cost_Center" text,
    "Coin" text,
    "User" text,
    "Branch" text,
    "Safe" text,
    "Bill_Num" text,
    "Order_Number" text,
    "Tax" text
);


ALTER TABLE public.payment_voucher_details OWNER TO postgres;

--
-- Name: payment_voucher_details_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.payment_voucher_details_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.payment_voucher_details_id_seq OWNER TO postgres;

--
-- Name: payment_voucher_details_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.payment_voucher_details_id_seq OWNED BY public.payment_voucher_details.id;


--
-- Name: payment_vouchers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.payment_vouchers (
    id bigint NOT NULL,
    "Code" text NOT NULL,
    "Date" text NOT NULL,
    "Draw" text NOT NULL,
    "Total_Debaitor" 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,
    "Shift" text,
    "Store" text,
    "User" text,
    "Branch" text,
    "Status" text,
    "File" text,
    "Edit" text,
    "Edit_New_Code" text,
    "Delete" text,
    "Responsiple" text,
    "Project" text
);


ALTER TABLE public.payment_vouchers OWNER TO postgres;

--
-- Name: payment_vouchers_arr_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.payment_vouchers_arr_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.payment_vouchers_arr_seq OWNER TO postgres;

--
-- Name: payment_vouchers_arr_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.payment_vouchers_arr_seq OWNED BY public.payment_vouchers.arr;


--
-- Name: payment_vouchers_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.payment_vouchers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.payment_vouchers_id_seq OWNER TO postgres;

--
-- Name: payment_vouchers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.payment_vouchers_id_seq OWNED BY public.payment_vouchers.id;


--
-- Name: paymentss_products_real_projects; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.paymentss_products_real_projects (
    id bigint NOT NULL,
    "Product_Code" text,
    "P_Ar_Name" text,
    "P_En_Name" text,
    "AvQty" text,
    "Qty" text,
    "Price" text,
    "CostPrice" text,
    "Discount" text,
    "TDiscount" text,
    "Tax" text,
    "Total_Bf_Tax" text,
    "Total_Tax" text,
    "Total" text,
    "TotCostNew" text,
    "Total_Net" text,
    "Store" text,
    "Product" text,
    "Unit" text,
    "Payment" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    "Pro_Desc" text
);


ALTER TABLE public.paymentss_products_real_projects OWNER TO postgres;

--
-- Name: paymentss_products_real_projects_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.paymentss_products_real_projects_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.paymentss_products_real_projects_id_seq OWNER TO postgres;

--
-- Name: paymentss_products_real_projects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.paymentss_products_real_projects_id_seq OWNED BY public.paymentss_products_real_projects.id;


--
-- Name: paymentss_real_projects; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.paymentss_real_projects (
    id bigint NOT NULL,
    "Code" text,
    "Date" text,
    "Time" text,
    "Branch" text,
    "Draw" 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,
    "Total_Net" text,
    "DiscountBill" text,
    "Pay" text,
    "Safe" text,
    "Client" text,
    "Delegate" text,
    "Store" text,
    "Coin" text,
    "Cost_Center" text,
    "User" text,
    "Edit" text,
    "Delete" text,
    "Edit_New_Code" text,
    "Project" text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.paymentss_real_projects OWNER TO postgres;

--
-- Name: paymentss_real_projects_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.paymentss_real_projects_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.paymentss_real_projects_id_seq OWNER TO postgres;

--
-- Name: paymentss_real_projects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.paymentss_real_projects_id_seq OWNED BY public.paymentss_real_projects.id;


--
-- Name: permission_to_exchange_goods; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.permission_to_exchange_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,
    "To_Store" bigint,
    "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,
    "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_exchange_goods OWNER TO postgres;

--
-- 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: 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_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;


--
