--
--


-- Started on 2025-07-12 15:20:52

SET transaction_timeout = 0;

--
-- TOC entry 928 (class 1247 OID 16509)
-- Name: enum_active_status; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.enum_active_status AS ENUM (
    'S',
    'H'
);


ALTER TYPE public.enum_active_status OWNER TO postgres;

--
-- TOC entry 979 (class 1247 OID 16778)
-- Name: enum_media_type; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.enum_media_type AS ENUM (
    'I',
    'S',
    'P',
    'W',
    'SB',
    'MR',
    'V',
    'O',
    'WD'
);


ALTER TYPE public.enum_media_type OWNER TO postgres;

--
-- TOC entry 5126 (class 0 OID 0)
-- Dependencies: 979
-- Name: TYPE enum_media_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TYPE public.enum_media_type IS 'I=>property Image,
S=>sale Notice By Bank,
SB=>Sale notice by Borrower,
P=>Poster,
MR=> Marketing Reel,
V=>Video,
O=>Other Images,
WD=>WhatsApp Draft';


--
-- TOC entry 937 (class 1247 OID 16603)
-- Name: enum_menu_type; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.enum_menu_type AS ENUM (
    'F',
    'C'
);


ALTER TYPE public.enum_menu_type OWNER TO postgres;

--
-- TOC entry 973 (class 1247 OID 16736)
-- Name: enum_possession; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.enum_possession AS ENUM (
    'P',
    'S'
);


ALTER TYPE public.enum_possession OWNER TO postgres;

--
-- TOC entry 970 (class 1247 OID 16729)
-- Name: enum_property_status; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.enum_property_status AS ENUM (
    'A',
    'H',
    'S'
);


ALTER TYPE public.enum_property_status OWNER TO postgres;

--
-- TOC entry 931 (class 1247 OID 16514)
-- Name: enum_status; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.enum_status AS ENUM (
    '1',
    '0'
);


ALTER TYPE public.enum_status OWNER TO postgres;

--
-- TOC entry 940 (class 1247 OID 16608)
-- Name: enum_yes_no; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.enum_yes_no AS ENUM (
    'Y',
    'N'
);


ALTER TYPE public.enum_yes_no OWNER TO postgres;

--
-- TOC entry 922 (class 1247 OID 16474)
-- Name: gender; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.gender AS ENUM (
    'M',
    'F',
    'O'
);


ALTER TYPE public.gender OWNER TO postgres;



--
-- TOC entry 229 (class 1259 OID 16455)
-- Name: failed_jobs; Type: TABLE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.failed_jobs OWNER TO postgres;

--
-- TOC entry 228 (class 1259 OID 16454)
-- Name: failed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.failed_jobs_id_seq OWNER TO postgres;

--
-- TOC entry 5127 (class 0 OID 0)
-- Dependencies: 228
-- 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;


--
-- TOC entry 227 (class 1259 OID 16447)
-- Name: job_batches; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.job_batches (
    id character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    total_jobs integer NOT NULL,
    pending_jobs integer NOT NULL,
    failed_jobs integer NOT NULL,
    failed_job_ids text NOT NULL,
    options text,
    cancelled_at integer,
    created_at integer NOT NULL,
    finished_at integer
);


ALTER TABLE public.job_batches OWNER TO postgres;

--
-- TOC entry 226 (class 1259 OID 16438)
-- Name: jobs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.jobs (
    id bigint NOT NULL,
    queue character varying(255) NOT NULL,
    payload text NOT NULL,
    attempts smallint NOT NULL,
    reserved_at integer,
    available_at integer NOT NULL,
    created_at integer NOT NULL
);


ALTER TABLE public.jobs OWNER TO postgres;

--
-- TOC entry 225 (class 1259 OID 16437)
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.jobs_id_seq OWNER TO postgres;

--
-- TOC entry 5128 (class 0 OID 0)
-- Dependencies: 225
-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;


--
-- TOC entry 218 (class 1259 OID 16390)
-- Name: migrations; Type: TABLE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.migrations OWNER TO postgres;

--
-- TOC entry 217 (class 1259 OID 16389)
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.migrations_id_seq OWNER TO postgres;

--
-- TOC entry 5129 (class 0 OID 0)
-- Dependencies: 217
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

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

--
-- TOC entry 222 (class 1259 OID 16414)
-- Name: sessions; Type: TABLE; Schema: public; Owner: postgres
--

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


ALTER TABLE public.sessions OWNER TO postgres;

--
-- TOC entry 232 (class 1259 OID 16481)
-- Name: tbl_admin_admin_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_admin_admin_id_seq OWNER TO postgres;

--
-- TOC entry 5130 (class 0 OID 0)
-- Dependencies: 232
-- Name: tbl_admin_admin_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_admin_admin_id_seq OWNED BY public.tbl_admin.admin_id;


--
-- TOC entry 261 (class 1259 OID 16821)
-- Name: tbl_area_unit; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_area_unit (
    area_unit_id integer NOT NULL,
    unit_name character varying(100),
    unit_short_name character varying(20) NOT NULL,
    conversion_factor double precision DEFAULT 1.0,
    added_on bigint,
    updated_on bigint,
    added_by integer,
    updated_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL
);


ALTER TABLE public.tbl_area_unit OWNER TO postgres;

--
-- TOC entry 260 (class 1259 OID 16820)
-- Name: tbl_area_unit_area_unit_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_area_unit_area_unit_id_seq OWNER TO postgres;

--
-- TOC entry 5131 (class 0 OID 0)
-- Dependencies: 260
-- Name: tbl_area_unit_area_unit_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_area_unit_area_unit_id_seq OWNED BY public.tbl_area_unit.area_unit_id;


--
-- TOC entry 259 (class 1259 OID 16804)
-- Name: tbl_auction; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_auction (
    auction_id integer NOT NULL,
    auction_code character varying(255) NOT NULL,
    auction_title character varying(255),
    property_id integer,
    auction_date character varying(255),
    auction_amount character varying(255),
    emd_amount character varying(255),
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL
);


ALTER TABLE public.tbl_auction OWNER TO postgres;

--
-- TOC entry 258 (class 1259 OID 16803)
-- Name: tbl_auction_auction_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_auction_auction_id_seq OWNER TO postgres;

--
-- TOC entry 5132 (class 0 OID 0)
-- Dependencies: 258
-- Name: tbl_auction_auction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_auction_auction_id_seq OWNED BY public.tbl_auction.auction_id;


--
-- TOC entry 249 (class 1259 OID 16693)
-- Name: tbl_bank; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_bank (
    bank_id integer NOT NULL,
    bank_name character varying(150) NOT NULL,
    address text,
    logo character varying(255),
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL
);


ALTER TABLE public.tbl_bank OWNER TO postgres;

--
-- TOC entry 248 (class 1259 OID 16692)
-- Name: tbl_bank_bank_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_bank_bank_id_seq OWNER TO postgres;

--
-- TOC entry 5133 (class 0 OID 0)
-- Dependencies: 248
-- Name: tbl_bank_bank_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_bank_bank_id_seq OWNED BY public.tbl_bank.bank_id;


--
-- TOC entry 251 (class 1259 OID 16704)
-- Name: tbl_banker; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_banker (
    banker_id integer NOT NULL,
    bank_id integer NOT NULL,
    name character varying(150) NOT NULL,
    mobile_no character varying(20),
    email_id character varying(150),
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL,
    address text
);


ALTER TABLE public.tbl_banker OWNER TO postgres;

--
-- TOC entry 250 (class 1259 OID 16703)
-- Name: tbl_banker_banker_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_banker_banker_id_seq OWNER TO postgres;

--
-- TOC entry 5134 (class 0 OID 0)
-- Dependencies: 250
-- Name: tbl_banker_banker_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_banker_banker_id_seq OWNED BY public.tbl_banker.banker_id;


--
-- TOC entry 253 (class 1259 OID 16718)
-- Name: tbl_borrower; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_borrower (
    borrower_id integer NOT NULL,
    borrower_name character varying(150) NOT NULL,
    mobile_no character varying(20),
    email_id character varying(120),
    address text,
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL
);


ALTER TABLE public.tbl_borrower OWNER TO postgres;

--
-- TOC entry 252 (class 1259 OID 16717)
-- Name: tbl_borrower_borrower_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_borrower_borrower_id_seq OWNER TO postgres;

--
-- TOC entry 5135 (class 0 OID 0)
-- Dependencies: 252
-- Name: tbl_borrower_borrower_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_borrower_borrower_id_seq OWNED BY public.tbl_borrower.borrower_id;


--
-- TOC entry 263 (class 1259 OID 24577)
-- Name: tbl_budget; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_budget (
    budget_id integer NOT NULL,
    budget_name character varying(255) NOT NULL,
    active_status character varying(1) DEFAULT 'S'::character varying,
    added_on double precision,
    updated_on double precision,
    status character varying(1) DEFAULT '1'::character varying,
    created_by character varying(25),
    updated_by character varying(25),
    start_limit numeric,
    to_limit numeric,
    CONSTRAINT tbl_budget_active_status_check CHECK (((active_status)::text = ANY ((ARRAY['S'::character varying, 'H'::character varying])::text[]))),
    CONSTRAINT tbl_budget_status_check CHECK (((status)::text = ANY ((ARRAY['1'::character varying, '0'::character varying])::text[])))
);


ALTER TABLE public.tbl_budget OWNER TO postgres;

--
-- TOC entry 262 (class 1259 OID 24576)
-- Name: tbl_budget_budget_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_budget_budget_id_seq OWNER TO postgres;

--
-- TOC entry 5136 (class 0 OID 0)
-- Dependencies: 262
-- Name: tbl_budget_budget_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_budget_budget_id_seq OWNED BY public.tbl_budget.budget_id;


--
-- TOC entry 241 (class 1259 OID 16637)
-- Name: tbl_city; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_city (
    city_id integer NOT NULL,
    state_id integer NOT NULL,
    city_name character varying(100),
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL,
    district_id bigint
);


ALTER TABLE public.tbl_city OWNER TO postgres;

--
-- TOC entry 240 (class 1259 OID 16636)
-- Name: tbl_city_city_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_city_city_id_seq OWNER TO postgres;

--
-- TOC entry 5137 (class 0 OID 0)
-- Dependencies: 240
-- Name: tbl_city_city_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_city_city_id_seq OWNED BY public.tbl_city.city_id;


--
-- TOC entry 243 (class 1259 OID 16651)
-- Name: tbl_district; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_district (
    district_id integer NOT NULL,
    district_name character varying(100),
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL,
    state_id bigint
);


ALTER TABLE public.tbl_district OWNER TO postgres;

--
-- TOC entry 242 (class 1259 OID 16650)
-- Name: tbl_district_district_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_district_district_id_seq OWNER TO postgres;

--
-- TOC entry 5138 (class 0 OID 0)
-- Dependencies: 242
-- Name: tbl_district_district_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_district_district_id_seq OWNED BY public.tbl_district.district_id;


--
-- TOC entry 245 (class 1259 OID 16660)
-- Name: tbl_location; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_location (
    location_id integer NOT NULL,
    state_id integer NOT NULL,
    district_id integer NOT NULL,
    city_id integer NOT NULL,
    location_name character varying(100),
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL
);


ALTER TABLE public.tbl_location OWNER TO postgres;

--
-- TOC entry 244 (class 1259 OID 16659)
-- Name: tbl_location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_location_location_id_seq OWNER TO postgres;

--
-- TOC entry 5139 (class 0 OID 0)
-- Dependencies: 244
-- Name: tbl_location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_location_location_id_seq OWNED BY public.tbl_location.location_id;


--
-- TOC entry 237 (class 1259 OID 16614)
-- Name: tbl_menu; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_menu (
    menu_id integer NOT NULL,
    parent_id integer,
    company_id character varying(100),
    menu character varying(100) NOT NULL,
    menu_alias character varying(100) NOT NULL,
    menu_icon character varying(50),
    menu_controller character varying(100),
    menu_action character varying(50),
    child_menus text,
    metatitle text,
    metakeyword text,
    metadescription text,
    menu_type public.enum_menu_type,
    sort_order integer,
    is_show public.enum_yes_no DEFAULT 'Y'::public.enum_yes_no,
    mapping_type public.enum_menu_type,
    mapping_item character varying(100),
    role_id character varying(100),
    is_mobile_category public.enum_yes_no,
    is_mobile_jewellery public.enum_yes_no,
    mobile_category_image character varying(100),
    mobile_jewellery_image character varying(100),
    mobile_category_description character varying(100),
    is_notification public.enum_yes_no DEFAULT 'N'::public.enum_yes_no,
    active_status public.enum_active_status,
    created_by integer,
    updated_by integer,
    added_on double precision,
    updated_on double precision,
    status public.enum_status NOT NULL
);


ALTER TABLE public.tbl_menu OWNER TO postgres;

--
-- TOC entry 236 (class 1259 OID 16613)
-- Name: tbl_menu_menu_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_menu_menu_id_seq OWNER TO postgres;

--
-- TOC entry 5140 (class 0 OID 0)
-- Dependencies: 236
-- Name: tbl_menu_menu_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_menu_menu_id_seq OWNED BY public.tbl_menu.menu_id;


--
-- TOC entry 255 (class 1259 OID 16742)
-- Name: tbl_property; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_property (
    property_id integer NOT NULL,
    property_name character varying(200) NOT NULL,
    address text,
    property_status public.enum_property_status,
    location_id integer,
    district_id integer,
    possession public.enum_possession,
    property_type_id integer,
    borrower_id integer,
    area character varying(100),
    bank_id integer,
    market_amount character varying(100),
    ai_amount character varying(100),
    save_amount character varying(100),
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL,
    banker_id integer,
    state_id integer,
    city_id integer,
    area_unit_id integer,
    save_percentage double precision
);


ALTER TABLE public.tbl_property OWNER TO postgres;

--
-- TOC entry 5141 (class 0 OID 0)
-- Dependencies: 255
-- Name: COLUMN tbl_property.state_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.tbl_property.state_id IS '
';


--
-- TOC entry 257 (class 1259 OID 16788)
-- Name: tbl_property_media; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_property_media (
    property_media_id integer NOT NULL,
    property_id integer,
    media_type public.enum_media_type NOT NULL,
    media character varying(255),
    media_url text,
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL
);


ALTER TABLE public.tbl_property_media OWNER TO postgres;

--
-- TOC entry 256 (class 1259 OID 16787)
-- Name: tbl_property_media_property_media_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_property_media_property_media_id_seq OWNER TO postgres;

--
-- TOC entry 5142 (class 0 OID 0)
-- Dependencies: 256
-- Name: tbl_property_media_property_media_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_property_media_property_media_id_seq OWNED BY public.tbl_property_media.property_media_id;


--
-- TOC entry 254 (class 1259 OID 16741)
-- Name: tbl_property_property_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_property_property_id_seq OWNER TO postgres;

--
-- TOC entry 5143 (class 0 OID 0)
-- Dependencies: 254
-- Name: tbl_property_property_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_property_property_id_seq OWNED BY public.tbl_property.property_id;


--
-- TOC entry 247 (class 1259 OID 16684)
-- Name: tbl_property_type; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_property_type (
    property_type_id integer NOT NULL,
    property_type_name character varying(100) NOT NULL,
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL,
    is_home public.enum_yes_no DEFAULT 'N'::public.enum_yes_no,
    image text,
    icon text
);


ALTER TABLE public.tbl_property_type OWNER TO postgres;

--
-- TOC entry 246 (class 1259 OID 16683)
-- Name: tbl_property_type_property_type_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_property_type_property_type_id_seq OWNER TO postgres;

--
-- TOC entry 5144 (class 0 OID 0)
-- Dependencies: 246
-- Name: tbl_property_type_property_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_property_type_property_type_id_seq OWNED BY public.tbl_property_type.property_type_id;


--
-- TOC entry 235 (class 1259 OID 16570)
-- Name: tbl_role; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_role (
    role_id integer NOT NULL,
    role character varying(100),
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status,
    created_by integer,
    updated_by integer,
    added_on double precision,
    updated_on double precision,
    status public.enum_status DEFAULT '1'::public.enum_status
);


ALTER TABLE public.tbl_role OWNER TO postgres;

--
-- TOC entry 234 (class 1259 OID 16569)
-- Name: tbl_role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_role_role_id_seq OWNER TO postgres;

--
-- TOC entry 5145 (class 0 OID 0)
-- Dependencies: 234
-- Name: tbl_role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_role_role_id_seq OWNED BY public.tbl_role.role_id;


--
-- TOC entry 239 (class 1259 OID 16628)
-- Name: tbl_state; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_state (
    state_id integer NOT NULL,
    state_name character varying(100),
    added_on double precision,
    updated_on double precision,
    updated_by integer,
    added_by integer,
    active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL,
    status public.enum_status DEFAULT '1'::public.enum_status NOT NULL
);


ALTER TABLE public.tbl_state OWNER TO postgres;

--
-- TOC entry 238 (class 1259 OID 16627)
-- Name: tbl_state_state_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_state_state_id_seq OWNER TO postgres;

--
-- TOC entry 5146 (class 0 OID 0)
-- Dependencies: 238
-- Name: tbl_state_state_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_state_state_id_seq OWNED BY public.tbl_state.state_id;


--
-- TOC entry 231 (class 1259 OID 16467)
-- Name: tbl_test_user; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tbl_test_user (
    test_user_id integer NOT NULL,
    user_name character varying(100) NOT NULL,
    email_id character varying(100) NOT NULL,
    gender public.gender NOT NULL
);


ALTER TABLE public.tbl_test_user OWNER TO postgres;

--
-- TOC entry 230 (class 1259 OID 16466)
-- Name: tbl_test_user_test_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.tbl_test_user_test_user_id_seq OWNER TO postgres;

--
-- TOC entry 5147 (class 0 OID 0)
-- Dependencies: 230
-- Name: tbl_test_user_test_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.tbl_test_user_test_user_id_seq OWNED BY public.tbl_test_user.test_user_id;

--
-- TOC entry 219 (class 1259 OID 16396)
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.users_id_seq OWNER TO postgres;

--
-- TOC entry 5148 (class 0 OID 0)
-- Dependencies: 219
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- TOC entry 4788 (class 2604 OID 16458)
-- Name: failed_jobs id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 4787 (class 2604 OID 16441)
-- Name: jobs id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 4785 (class 2604 OID 16393)
-- Name: migrations id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 4835 (class 2604 OID 16824)
-- Name: tbl_area_unit area_unit_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_area_unit ALTER COLUMN area_unit_id SET DEFAULT nextval('public.tbl_area_unit_area_unit_id_seq'::regclass);


--
-- TOC entry 4832 (class 2604 OID 16807)
-- Name: tbl_auction auction_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_auction ALTER COLUMN auction_id SET DEFAULT nextval('public.tbl_auction_auction_id_seq'::regclass);


--
-- TOC entry 4817 (class 2604 OID 16696)
-- Name: tbl_bank bank_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_bank ALTER COLUMN bank_id SET DEFAULT nextval('public.tbl_bank_bank_id_seq'::regclass);


--
-- TOC entry 4820 (class 2604 OID 16707)
-- Name: tbl_banker banker_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_banker ALTER COLUMN banker_id SET DEFAULT nextval('public.tbl_banker_banker_id_seq'::regclass);


--
-- TOC entry 4823 (class 2604 OID 16721)
-- Name: tbl_borrower borrower_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_borrower ALTER COLUMN borrower_id SET DEFAULT nextval('public.tbl_borrower_borrower_id_seq'::regclass);


--
-- TOC entry 4839 (class 2604 OID 24580)
-- Name: tbl_budget budget_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_budget ALTER COLUMN budget_id SET DEFAULT nextval('public.tbl_budget_budget_id_seq'::regclass);


--
-- TOC entry 4804 (class 2604 OID 16640)
-- Name: tbl_city city_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_city ALTER COLUMN city_id SET DEFAULT nextval('public.tbl_city_city_id_seq'::regclass);


--
-- TOC entry 4807 (class 2604 OID 16654)
-- Name: tbl_district district_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_district ALTER COLUMN district_id SET DEFAULT nextval('public.tbl_district_district_id_seq'::regclass);


--
-- TOC entry 4810 (class 2604 OID 16663)
-- Name: tbl_location location_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_location ALTER COLUMN location_id SET DEFAULT nextval('public.tbl_location_location_id_seq'::regclass);


--
-- TOC entry 4798 (class 2604 OID 16617)
-- Name: tbl_menu menu_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_menu ALTER COLUMN menu_id SET DEFAULT nextval('public.tbl_menu_menu_id_seq'::regclass);


--
-- TOC entry 4826 (class 2604 OID 16745)
-- Name: tbl_property property_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property ALTER COLUMN property_id SET DEFAULT nextval('public.tbl_property_property_id_seq'::regclass);


--
-- TOC entry 4829 (class 2604 OID 16791)
-- Name: tbl_property_media property_media_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property_media ALTER COLUMN property_media_id SET DEFAULT nextval('public.tbl_property_media_property_media_id_seq'::regclass);


--
-- TOC entry 4813 (class 2604 OID 16687)
-- Name: tbl_property_type property_type_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property_type ALTER COLUMN property_type_id SET DEFAULT nextval('public.tbl_property_type_property_type_id_seq'::regclass);


--
-- TOC entry 4795 (class 2604 OID 16573)
-- Name: tbl_role role_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_role ALTER COLUMN role_id SET DEFAULT nextval('public.tbl_role_role_id_seq'::regclass);


--
-- TOC entry 4801 (class 2604 OID 16631)
-- Name: tbl_state state_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_state ALTER COLUMN state_id SET DEFAULT nextval('public.tbl_state_state_id_seq'::regclass);


--
-- TOC entry 4790 (class 2604 OID 16470)
-- Name: tbl_test_user test_user_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_test_user ALTER COLUMN test_user_id SET DEFAULT nextval('public.tbl_test_user_test_user_id_seq'::regclass);

--
-- TOC entry 5086 (class 0 OID 16455)
-- Dependencies: 229
-- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--

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


--
-- TOC entry 5084 (class 0 OID 16447)
-- Dependencies: 227
-- Data for Name: job_batches; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.job_batches (id, name, total_jobs, pending_jobs, failed_jobs, failed_job_ids, options, cancelled_at, created_at, finished_at) FROM stdin;
\.


--
-- TOC entry 5083 (class 0 OID 16438)
-- Dependencies: 226
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.jobs (id, queue, payload, attempts, reserved_at, available_at, created_at) FROM stdin;
\.


--
-- TOC entry 5075 (class 0 OID 16390)
-- Dependencies: 218
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.migrations (id, migration, batch) FROM stdin;
1	0001_01_01_000000_create_users_table	1
2	0001_01_01_000001_create_cache_table	1
3	0001_01_01_000002_create_jobs_table	1
\.


--
-- TOC entry 5079 (class 0 OID 16414)
-- Dependencies: 222
-- Data for Name: sessions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sessions (id, user_id, ip_address, user_agent, payload, last_activity) FROM stdin;
\.


--
-- TOC entry 5118 (class 0 OID 16821)
-- Dependencies: 261
-- Data for Name: tbl_area_unit; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_area_unit (area_unit_id, unit_name, unit_short_name, conversion_factor, added_on, updated_on, added_by, updated_by, active_status, status) FROM stdin;
1	Square Feet	sqft	1	1750829432	\N	1	\N	S	1
2	Square Meter	sqm	10.7639	1750829432	\N	1	\N	S	1
3	Square Yard	sqyd	9	1750829432	\N	1	\N	S	1
4	Acre	ac	43560	1750829432	\N	1	\N	S	1
5	Hectare	ha	107639	1750829432	\N	1	\N	S	1
6	Bigha	bigha	17424	1750829432	\N	1	\N	S	1
7	Katha	katha	1361.25	1750829432	\N	1	\N	S	1
8	Marla	marla	272.25	1750829432	\N	1	\N	S	1
9	Cents	cent	435.6	1750829432	\N	1	\N	S	1
10	Guntha	guntha	1089	1750829432	\N	1	\N	S	1
12	\N	Sq Ft	1	\N	\N	\N	\N	S	1
\.


--
-- TOC entry 5116 (class 0 OID 16804)
-- Dependencies: 259
-- Data for Name: tbl_auction; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_auction (auction_id, auction_code, auction_title, property_id, auction_date, auction_amount, emd_amount, added_on, updated_on, updated_by, added_by, active_status, status) FROM stdin;
1	ASDF	Auction on 21st nov	1	2025-06-25	12345	2323	1750840131	1750840473	1	1	S	1
9	100347	Flat in Vile Parle West	10	01-01-1970	2406300	2666666	1750853611	1750853611	1	\N	S	1
10	100366	Flat in Bandra West	11	30-11-5249	5250000	18000000	1750853788	1750853788	1	\N	S	1
11	100367	Flat in Kalyan Mumbai\n	12	01-01-1970	134000	2666666	1750853790	1750853790	1	\N	S	1
12	100368	Flat in Sion	13	01-01-1970	880000	7342196	1750853791	1750853791	1	\N	S	1
13	1003471	Flat in Vile Parle West	14	1970-01-01	2406300	2666666	1750854154	1750854154	1	\N	S	1
14	1003661	Flat in Bandra West	15	5249-11-30	5250000	18000000	1750854156	1750854156	1	\N	S	1
15	1003671	Flat in Kalyan Mumbai\n	16	1970-01-01	134000	2666666	1750854157	1750854157	1	\N	S	1
16	1003681	Flat in Sion	17	1970-01-01	880000	7342196	1750854159	1750854159	1	\N	S	1
17	1003472	Flat in Vile Parle West	18	2025-07-10	24063000	2406300	1750854653	1750854653	1	\N	S	1
18	1003662	Flat in Bandra West	19	2025-07-15	52500000	5250000	1750854909	1750854909	1	\N	S	1
19	1003672	Flat in Kalyan Mumbai\n	20	2025-07-25	1340000	134000	1750854914	1750854914	1	\N	S	1
20	1003682	Flat in Sion	21	2025-08-25	8800000	880000	1750854917	1750854917	1	\N	S	1
21	1003477	Flat in Vile Parle West	22	2025-07-10	24063000	2406300	1750856258	1750856258	1	\N	S	1
22	1003478	Flat in Vile Parle West	23	2025-07-10	24063000	2406300	1750859070	1750859070	1	\N	S	1
23	250710101	Plant & Machinery in Bangalore, Mysore	24	2025-07-10	100000	10000	1752128884	1752146573	1	1	S	1
24	250712102	Plant & Machinery in Mumbai	25	2025-07-12	1200000	120000.00	1752297546	1752298505	1	1	S	1
\.


--
-- TOC entry 5106 (class 0 OID 16693)
-- Dependencies: 249
-- Data for Name: tbl_bank; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_bank (bank_id, bank_name, address, logo, added_on, updated_on, updated_by, added_by, active_status, status) FROM stdin;
7	samata sahakari bank	\N	\N	\N	\N	\N	\N	S	1
8	Aditya Bira Finance	\N	\N	\N	\N	\N	\N	S	1
9	city cooperative bank	\N	\N	\N	\N	\N	\N	S	1
2	HDFC Bank	Navrangpura, Ahmedabad	1752062520_686e5a3854368.png	1750749600.47874	1752062520	1	1	S	1
1	State Bank of India	Fort Branch, Mumbai	1752062566_686e5a667d120.png	1750749600.47874	1752062566	1	1	S	1
3	ICICI Bank	MG Road, Bangalore	1752065948_686e679ceba05.png	1750749600.47874	1752065948	1	1	S	1
10	BANK OF BARODA	Mumbai	1752154183_686fc047eec0c.png	1752154183	1752154183	1	1	S	1
11	TJSB Bank	Mumbai	1752154300_686fc0bcaa6ee.jpg	1752154300	1752154300	1	1	S	1
12	Union Bank of India	Mumbai	1752154448_686fc150a7a2d.png	1752154448	1752154448	1	1	S	1
13	Indian Bank	Mumbai	1752154574_686fc1ce06489.png	1752154574	1752154574	1	1	S	1
\.


--
-- TOC entry 5108 (class 0 OID 16704)
-- Dependencies: 251
-- Data for Name: tbl_banker; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_banker (banker_id, bank_id, name, mobile_no, email_id, added_on, updated_on, updated_by, added_by, active_status, status, address) FROM stdin;
1	1	Rajesh Mehta	9876543210	rajesh.mehta@sbi.co.in	1750749618.486184	1750749618.486184	1	1	S	1	\N
2	2	Priya Shah	9123456780	priya.shah@hdfc.com	1750749618.486184	1750749618.486184	1	1	S	1	\N
3	3	Arjun Rao	9988776655	arjun.rao@icici.com	1750749618.486184	1750749618.486184	1	1	S	1	\N
8	7	Ashish Chawan	9920271068	santacruz@samatabank.com	\N	\N	\N	\N	S	1	\N
9	8	Abhishek	9833698778		\N	\N	\N	\N	S	1	\N
10	3	Amit	7304915594		\N	\N	\N	\N	S	1	\N
11	9	Prabhat	022-35220879		\N	\N	\N	\N	S	1	\N
12	13	Ashish	5879658452	pr@gmaoim	1752155334	1752155334	1	1	S	1	test address by pr
13	13	Milan	2546588547	mld@gmail.com	1752155566	1752155566	1	1	S	1	mumbai
\.


--
-- TOC entry 5110 (class 0 OID 16718)
-- Dependencies: 253
-- Data for Name: tbl_borrower; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_borrower (borrower_id, borrower_name, mobile_no, email_id, address, added_on, updated_on, updated_by, added_by, active_status, status) FROM stdin;
1	Anil Kapoor	9001112233	anilkappor@gmail.com	Andheri East, Mumbai	1750749657.20242	1750749657.20242	1	1	S	1
2	Sneha Desai	8800445599	sdesai@gmail.com	Satellite, Ahmedabad	1750749657.20242	1750749657.20242	1	1	S	1
3	Vikram Reddy	9988998877	vReddy@gmail.com	JP Nagar, Bangalore	1750749657.20242	1750749657.20242	1	1	S	1
8	 M/s Kunal Builders & Developers	\N	\N	\N	\N	\N	\N	\N	S	1
9	ADITYA BIRLA CAPITAL LIMITED	\N	\N	\N	\N	\N	\N	\N	S	1
10	Mrs. Sneha Ganesh\nMarathe 	\N	\N	\N	\N	\N	\N	\N	S	1
11	M/s.Padmavati\nEnterprises	\N	\N	\N	\N	\N	\N	\N	S	1
12	M/s.Aska\nEnterprises	\N	\N	\N	\N	\N	\N	\N	S	1
13	Ashish vishwakarma	9004200401	ashish@gmail.com	Mumbai	1752150162	1752150162	1	1	S	1
14	Rohan Kadam	8798789548	rohank@gmail.com	mumbai	1752150547	1752150547	1	1	S	1
15	Akash	9896986984	akash@gmail.com	pune	1752150675	1752150675	1	1	S	1
16	Raj Dighe	8789546231	raj@gmail.com	kalyan	1752150715	1752150715	1	1	S	1
\.


--
-- TOC entry 5120 (class 0 OID 24577)
-- Dependencies: 263
-- Data for Name: tbl_budget; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_budget (budget_id, budget_name, active_status, added_on, updated_on, status, created_by, updated_by, start_limit, to_limit) FROM stdin;
1	10 - 50 Lakh	S	\N	\N	1	\N	\N	1000000	5000000
2	50 Lakh - 1 Cr	S	\N	\N	1	\N	\N	5000000	10000000
3	1 Cr - 3 Cr	S	\N	\N	1	\N	\N	10000000	30000000
4	5 Cr+	S	\N	\N	1	\N	\N	30000000	\N
\.


--
-- TOC entry 5098 (class 0 OID 16637)
-- Dependencies: 241
-- Data for Name: tbl_city; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_city (city_id, state_id, city_name, added_on, updated_on, updated_by, added_by, active_status, status, district_id) FROM stdin;
8	1	thane	\N	1752123741	1	\N	S	1	9
3	3	Bangalore	1750749510.870653	1752123754	1	1	S	1	3
2	2	Ahmedabad	1750749510.870653	1752123761	1	1	S	1	2
1	1	Mumbai	1750749510.870653	1752123770	1	1	S	1	7
7	1	Iumbai	\N	1752123859	1	\N	S	0	7
\.


--
-- TOC entry 5100 (class 0 OID 16651)
-- Dependencies: 243
-- Data for Name: tbl_district; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_district (district_id, district_name, added_on, updated_on, updated_by, added_by, active_status, status, state_id) FROM stdin;
9	Thane	\N	1752123335	1	\N	S	1	1
8	Mumbai Suburban	\N	1752123343	1	\N	S	1	1
7	Mumbai	\N	1752123349	1	\N	S	1	1
2	Surat	1750749399.681301	1752123358	1	1	S	1	2
1	Pune	1750749399.681301	1752123364	1	1	S	1	1
3	Mysore	1750749399.681301	1752123383	1	1	S	1	3
\.


--
-- TOC entry 5102 (class 0 OID 16660)
-- Dependencies: 245
-- Data for Name: tbl_location; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_location (location_id, state_id, district_id, city_id, location_name, added_on, updated_on, updated_by, added_by, active_status, status) FROM stdin;
1	1	1	1	Shivaji Nagar	1750749532.253671	1750749532.253671	1	1	S	1
2	2	2	2	Satellite	1750749532.253671	1750749532.253671	1	1	S	1
3	3	3	3	Jayanagar	1750749532.253671	1750749532.253671	1	1	S	1
8	1	7	7	vile parle	\N	\N	\N	\N	S	1
9	1	8	1	Mumbai	\N	\N	\N	\N	S	1
10	1	9	8	kalyan	\N	\N	\N	\N	S	1
11	1	7	7	chunabhatti	\N	\N	\N	\N	S	1
\.


--
-- TOC entry 5094 (class 0 OID 16614)
-- Dependencies: 237
-- Data for Name: tbl_menu; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_menu (menu_id, parent_id, company_id, menu, menu_alias, menu_icon, menu_controller, menu_action, child_menus, metatitle, metakeyword, metadescription, menu_type, sort_order, is_show, mapping_type, mapping_item, role_id, is_mobile_category, is_mobile_jewellery, mobile_category_image, mobile_jewellery_image, mobile_category_description, is_notification, active_status, created_by, updated_by, added_on, updated_on, status) FROM stdin;
1	0		Dashboard	Dashboard		admin	index				""" """	C	1	Y	F		1,2	\N	\N				N	S	1	1	1591874215	1591874215	1
2	0	\N	Masters	Masters	\N	\N	\N	\N	\N	\N	\N	C	2	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
3	2	\N	State	State	\N	state	list	\N	\N	\N	\N	C	1	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
4	0	\N	Property	Property	\N	\N	\N	\N	\N	\N	\N	C	3	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
7	2	\N	Location	Location	\N	location	list	\N	\N	\N	\N	C	4	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
8	2	\N	District	District	\N	district	list	\N	\N	\N	\N	C	3	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
9	2	\N	City	City	\N	city	list	\N	\N	\N	\N	C	2	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
10	2	\N	Borrower	Borrower	\N	borrower	list	\N	\N	\N	\N	C	8	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
11	2	\N	Banker	Banker	\N	banker	list	\N	\N	\N	\N	C	7	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
12	2	\N	Bank	Bank	\N	bank	list	\N	\N	\N	\N	C	6	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
15	4	\N	Property	Property	\N	property	list	\N	\N	\N	\N	C	1	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
13	2	\N	Property Type	Property Type	\N	propertyType	list	\N	\N	\N	\N	C	5	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
14	2	\N	Area Unit	Area Unit	\N	areaUnit	list	\N	\N	\N	\N	C	9	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
16	0	\N	Auctions	Auctions	\N	\N	\N	\N	\N	\N	\N	C	1	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
18	0	\N	Update	Update	\N	\N	\N	\N	\N	\N	\N	C	1	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
20	0	\N	Marketing	Marketing	\N	\N	\N	\N	\N	\N	\N	C	1	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
22	0	\N	Investor	Investor	\N	\N	\N	\N	\N	\N	\N	C	1	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
17	16	\N	View Auction	View Auction	\N	auctions	list	\N	\N	\N	\N	C	1	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
21	20	\N	View Marketing	View Marketing	\N	marketing	list	\N	\N	\N	\N	C	1	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
23	22	\N	View Investor	View Investor	\N	investor	list	\N	\N	\N	\N	C	1	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
19	18	\N	View Update	View Update	\N	update	list	\N	\N	\N	\N	C	1	Y	\N	\N	1,2	\N	\N	\N	\N	\N	N	S	\N	\N	\N	\N	1
\.


--
-- TOC entry 5112 (class 0 OID 16742)
-- Dependencies: 255
-- Data for Name: tbl_property; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_property (property_id, property_name, address, property_status, location_id, district_id, possession, property_type_id, borrower_id, area, bank_id, market_amount, ai_amount, save_amount, added_on, updated_on, updated_by, added_by, active_status, status, banker_id, state_id, city_id, area_unit_id, save_percentage) FROM stdin;
21	Flat in Sion	Flat No.303 Third Floor Wing 'A' "Bawa Tower A wing" Co-Op Hsg Soc.Ltdsituated at Plot C City Survey No. 405 Survey (part) No.292 Hissa No. of village Kurla- 3Near Jogani Industrial Estate Bhakti Dham Mandir Road. Narayan Nagar V.N. Purav Marg Sion Chunabhtti Mumbai- 400022. (Carpet Area 510 sqft)	A	11	7	P	4	12	510	9	7342196	734219.6	73421.96	1750854917	1750854917	1	\N	S	1	11	1	7	12	1
20	Flat in Kalyan Mumbai\n	Flat No 101 1st Floor A Wing Building Named As Nirmal Lifestyal Victory A Co Oprative Socitey In Project Named Lifestyle City Kalyan Sr No 94/7 94/8 94/10 94/9/1 94/9/2 At Village Vadavali Ambivali Tal Kalyan Thane 421102. Admeasuring An Area of Admeasuring 411 Sq Ft Sq Ft (carpet)= 493.20 Sq Ft Built Up le. 45.83 Sq Mtr	A	10	9	P	4	10	493.2	3	2666666	266666.6	26666.66	1750854914	1750854914	1	\N	S	1	10	1	8	12	1
11	Flat in Bandra West	Flat No 4A & 4B on 4th Foor Narang Manor 15th Road Bandra (W) Mumbai-400050	H	9	8	P	4	9	1414	8	1800000	180000		1750853788	1750853788	1	\N	S	1	9	1	1	12	0
19	Flat in Bandra West	Flat No 4A & 4B on 4th Foor Narang Manor 15th Road Bandra (W) Mumbai-400050	H	9	8	P	4	9	1414	8	18000000	1800000	180000	1750854909	1750854909	1	\N	S	1	9	1	1	12	1
16	Flat in Kalyan Mumbai\n	Flat No 101 1st Floor A Wing Building Named As Nirmal Lifestyal Victory A Co Oprative Socitey In Project Named Lifestyle City Kalyan Sr No 94/7 94/8 94/10 94/9/1 94/9/2 At Village Vadavali Ambivali Tal Kalyan Thane 421102. Admeasuring An Area of Admeasuring 411 Sq Ft Sq Ft (carpet)= 493.20 Sq Ft Built Up le. 45.83 Sq Mtr	A	10	9	P	4	10	493.2	3	266666.6	26666.66		1750854157	1750854157	1	\N	S	1	10	1	8	12	0
15	Flat in Bandra West	Flat No 4A & 4B on 4th Foor Narang Manor 15th Road Bandra (W) Mumbai-400050	H	9	8	P	4	9	1414	8	1800000	180000		1750854156	1750854156	1	\N	S	1	9	1	1	12	0
14	Flat in Vile Parle West	Flat no. 102 ,1st foor ,Akshar residency, JVPD Scheme, 10th road HSBC Bank Vile parle (west), Mumbai 400049	A	8	7	P	4	8	1332	7	266666.6	26666.66		1750854154	1750854154	1	\N	S	1	8	1	7	12	0
13	Flat in Sion	Flat No.303 Third Floor Wing 'A' "Bawa Tower A wing" Co-Op Hsg Soc.Ltdsituated at Plot C City Survey No. 405 Survey (part) No.292 Hissa No. of village Kurla- 3Near Jogani Industrial Estate Bhakti Dham Mandir Road. Narayan Nagar V.N. Purav Marg Sion Chunabhtti Mumbai- 400022. (Carpet Area 510 sqft)	A	11	7	P	4	11	510	9	734219.6	73421.96		1750853791	1750853791	1	\N	S	1	11	1	7	12	0
12	Flat in Kalyan Mumbai\n	Flat No 101 1st Floor A Wing Building Named As Nirmal Lifestyal Victory A Co Oprative Socitey In Project Named Lifestyle City Kalyan Sr No 94/7 94/8 94/10 94/9/1 94/9/2 At Village Vadavali Ambivali Tal Kalyan Thane 421102. Admeasuring An Area of Admeasuring 411 Sq Ft Sq Ft (carpet)= 493.20 Sq Ft Built Up le. 45.83 Sq Mtr	A	10	9	P	4	10	493.2	3	266666.6	26666.66		1750853790	1750853790	1	\N	S	1	10	1	8	12	0
10	Residential in Mumbai	Flat no. 102 ,1st foor ,Akshar residency, JVPD Scheme, 10th road HSBC Bank Vile parle (west), Mumbai 400049	A	\N	7	P	4	8	1332	7	266666.6	26666.66		1750853611	1752154686	1	\N	S	1	8	1	1	12	0
1	Visava Property	mumbai, ashish	H	1	1	P	1	1	1234	3	1234	2323	1234	1750769229	1750835319	1	1	S	1	3	1	1	1	100
25	Plant & Machinery in Mumbai	mulund	A	\N	7	P	5	16	2400	2	4500000	\N	3300000.00	1752297509	1752298144	1	1	S	1	2	1	1	12	73.33
24	Plant & Machinery in Bangalore, Mysore	thane	A	\N	3	P	5	1	1187.5	7	100000	10000	100000	1752128482	1752146573	1	1	S	1	8	3	3	1	100
18	Flat in Vile Parle West	Flat no. 102 ,1st foor ,Akshar residency, JVPD Scheme, 10th road HSBC Bank Vile parle (west), Mumbai 400049	A	8	7	P	4	8	1332	7	2666666	266666.6	26666.66	1750854653	1750854653	1	\N	S	1	8	1	7	12	1
17	Flat in Sion	Flat No.303 Third Floor Wing 'A' "Bawa Tower A wing" Co-Op Hsg Soc.Ltdsituated at Plot C City Survey No. 405 Survey (part) No.292 Hissa No. of village Kurla- 3Near Jogani Industrial Estate Bhakti Dham Mandir Road. Narayan Nagar V.N. Purav Marg Sion Chunabhtti Mumbai- 400022. (Carpet Area 510 sqft)	A	11	7	P	4	12	510	9	734219.6	73421.96		1750854159	1750854159	1	\N	S	1	11	1	7	12	0
23	Flat in Vile Parle West	Flat no. 102 ,1st foor ,Akshar residency, JVPD Scheme, 10th road HSBC Bank Vile parle (west), Mumbai 400049	A	8	7	P	4	8	1332	7	2666666	266666.6	26666.66	1750859070	1750859070	1	\N	S	1	8	1	7	12	1
22	Flat in Vile Parle West	Flat no. 102 ,1st foor ,Akshar residency, JVPD Scheme, 10th road HSBC Bank Vile parle (west), Mumbai 400049	A	8	7	P	4	8	1332	7	2666666	266666.6	26666.66	1750856258	1750856258	1	\N	S	1	8	1	7	12	1
\.


--
-- TOC entry 5114 (class 0 OID 16788)
-- Dependencies: 257
-- Data for Name: tbl_property_media; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_property_media (property_media_id, property_id, media_type, media, media_url, added_on, updated_on, updated_by, added_by, active_status, status) FROM stdin;
4	1	S	iBQPTKKXog.xlsx		1750837253	1750837253	1	1	S	1
17	10	S	X9ygndwpWr.png	/storage/property_media/X9ygndwpWr.png	1750853612	1750853612	1	\N	S	1
18	11	I	fsKcpDBBij.png	/storage/property_media/fsKcpDBBij.png	1750853789	1750853789	1	\N	S	1
19	11	S	6JKjQ1m3I0.png	/storage/property_media/6JKjQ1m3I0.png	1750853790	1750853790	1	\N	S	1
20	12	I	xTX7uX3td1.png	/storage/property_media/xTX7uX3td1.png	1750853790	1750853790	1	\N	S	1
21	12	S	omnHUueGZh.png	/storage/property_media/omnHUueGZh.png	1750853791	1750853791	1	\N	S	1
22	13	I	Dry2Vtu48W.png	/storage/property_media/Dry2Vtu48W.png	1750853792	1750853792	1	\N	S	1
23	13	S	a6dnoWdPYc.png	/storage/property_media/a6dnoWdPYc.png	1750853792	1750853792	1	\N	S	1
24	14	I	IYpINTnLuv.png	/storage/property_media/IYpINTnLuv.png	1750854155	1750854155	1	\N	S	1
25	14	S	Acss3yy1g8.png	/storage/property_media/Acss3yy1g8.png	1750854156	1750854156	1	\N	S	1
26	15	I	JdJVuyIJCq.png	/storage/property_media/JdJVuyIJCq.png	1750854157	1750854157	1	\N	S	1
27	15	S	A4Hhht0JfG.png	/storage/property_media/A4Hhht0JfG.png	1750854157	1750854157	1	\N	S	1
28	16	I	U1tf2hiYPx.png	/storage/property_media/U1tf2hiYPx.png	1750854158	1750854158	1	\N	S	1
29	16	S	nJdEyF1IRf.png	/storage/property_media/nJdEyF1IRf.png	1750854159	1750854159	1	\N	S	1
30	17	I	oX95QXUNyU.png	/storage/property_media/oX95QXUNyU.png	1750854160	1750854160	1	\N	S	1
31	17	S	2mkVyWsChc.png	/storage/property_media/2mkVyWsChc.png	1750854162	1750854162	1	\N	S	1
32	18	I	AnysBdwTbZ.png	/storage/property_media/AnysBdwTbZ.png	1750854655	1750854655	1	\N	S	1
33	19	I	HWHUUU3slE.png	/storage/property_media/HWHUUU3slE.png	1750854911	\N	\N	\N	S	1
34	19	P	ycDSUGdk4n.png	/storage/property_media/ycDSUGdk4n.png	1750854912	\N	\N	\N	S	1
35	19	W	HfQa9bkVGT.png	/storage/property_media/HfQa9bkVGT.png	1750854914	\N	\N	\N	S	1
36	20	I	SoIoIgiqVT.png	/storage/property_media/SoIoIgiqVT.png	1750854914	\N	\N	\N	S	1
37	20	S	UGzB0AHs7a.pdf	/storage/property_media/UGzB0AHs7a.pdf	1750854916	\N	\N	\N	S	1
38	20	P	brW2kGQso4.png	/storage/property_media/brW2kGQso4.png	1750854916	\N	\N	\N	S	1
39	20	W	14gHcqrzy4.png	/storage/property_media/14gHcqrzy4.png	1750854917	\N	\N	\N	S	1
40	21	I	RaQvDExki6.png	/storage/property_media/RaQvDExki6.png	1750854918	\N	\N	\N	S	1
41	21	S	CrPNn5PbkD.pdf	/storage/property_media/CrPNn5PbkD.pdf	1750854919	\N	\N	\N	S	1
42	21	P	I5PBH5n9mv.png	/storage/property_media/I5PBH5n9mv.png	1750854920	\N	\N	\N	S	1
43	21	W	9XzaSOOG2U.png	/storage/property_media/9XzaSOOG2U.png	1750854920	\N	\N	\N	S	1
44	22	I	ZFyHRaSqWG.png	https://res.cloudinary.com/daqlatcsr/image/upload/v1748859488/p-12_banker_255_start_49_rvraff.png	1750856258	\N	\N	\N	S	1
45	22	P	38aUDqCjoq.png	https://res.cloudinary.com/daqlatcsr/image/upload/v1749206640/187_hlzrf7.png	1750856259	\N	\N	\N	S	1
46	22	W	nyS2gAhGAk.png	https://res.cloudinary.com/dernbabcv/image/upload/v1749809104/Auction_Property_Flat_in_Vile_Parle_West_Bank_Offer_%EF%B8%8F_24_063_000_Location_%EF%B8%8F_Flat_no._102_1st_foor_Akshar_residency_JVPD_Scheme_10th_road_HSBC_Bank_Vile_parle_west_Mumbai_400049_ldq5rs.png	1750856260	\N	\N	\N	S	1
47	23	I	DJignAc93e.png	https://res.cloudinary.com/daqlatcsr/image/upload/v1748859488/p-12_banker_255_start_49_rvraff.png	1750859070	\N	\N	\N	S	1
48	23	P	S4uArDAaJF.png	https://res.cloudinary.com/daqlatcsr/image/upload/v1749206640/187_hlzrf7.png	1750859071	\N	\N	\N	S	1
49	23	W	RDlABhsXEG.png	https://res.cloudinary.com/dernbabcv/image/upload/v1749809104/Auction_Property_Flat_in_Vile_Parle_West_Bank_Offer_%EF%B8%8F_24_063_000_Location_%EF%B8%8F_Flat_no._102_1st_foor_Akshar_residency_JVPD_Scheme_10th_road_HSBC_Bank_Vile_parle_west_Mumbai_400049_ldq5rs.png	1750859071	\N	\N	\N	S	1
50	1	I	1Zv76HlWpy.jpg		1751972017	1751972017	1	1	S	1
63	24	S	LYHCO139UtcMbUKQQ8Ze.jpg		1752140895	1752140895	1	1	S	1
64	24	SB	iWevil1nftUWJwJyQdW2.jpg		1752140895	1752140895	1	1	S	1
65	24	P	GkNVPGkFsnfHZJ4LnLcK.jpg		1752140895	1752140895	1	1	S	1
69	24	MR	f8r8Rf2OYb60sA4RVCKi.mp4		1752143315	1752143315	1	1	S	1
70	10	SB	KibR9EYiHp5M1uCNOS6e.jpg		1752154738	1752154738	1	1	S	1
71	10	P	Hqfj4yS3nEzFpkIbM46M.jpg		1752154738	1752154738	1	1	S	1
72	10	MR	HKdXqJv0oe2eHq9a4dSS.mp4		1752154738	1752154738	1	1	S	1
73	24	O	🏡 Auctionwale : Plant & Machinery In Bangalore\r\n🏦 Bank Offer: 100000\r\n📍 Address: thane\r\n📐 Area: 1187.5\r\n📞 Contact: \r\n🗓️ Auction: 2025-07-10		1752160365	1752160365	1	1	S	1
16	10	I	DmFKnWn7n6DxNtgXzdXx.jpg		1752298780	1752298780	1	1	S	1
74	24	O	🏡 Auctionwale : Plant & Machinery In Bangalore\r\n🏦 Bank Offer: 100000\r\n📍 Address: thane\r\n📐 Area: 1187.5\r\n📞 Contact: \r\n🗓️ Auction: 2025-07-10		1752160380	1752160380	1	1	S	1
68	24	I	LjBgzMJMj7UqiLslY48u.jpg		1752160394	1752160394	1	1	S	1
75	24	O	🏡 Auctionwale : Plant & Machinery In Bangalore\r\n🏦 Bank Offer: 100000\r\n📍 Address: thane\r\n📐 Area: 1187.5\r\n📞 Contact: \r\n🗓️ Auction: 2025-07-10		1752160394	1752160394	1	1	S	1
76	25	I	u4K6xHmtLTDZcE0uQfFR.jpg		1752297524	1752297524	1	1	S	1
77	25	WD	🏡 Auctionwale : Plant & Machinery In Mumbai\r\n🏦 Bank Offer: \r\n📍 Address: mulund\r\n📐 Area: 2400\r\n📞 Contact: \r\n🗓️ Auction: 		1752297524	1752297524	1	1	S	1
78	10	WD	🏡 Auctionwale : Residential In Mumbai\r\n🏦 Bank Offer: 2406300\r\n📍 Address: Flat no. 102 ,1st foor ,Akshar residency, JVPD Scheme, 10th road HSBC Bank Vile parle (west), Mumbai 400049\r\n📐 Area: 1332\r\n📞 Contact: \r\n🗓️ Auction: 01-01-1970		1752298780	1752298780	1	1	S	1
\.


--
-- TOC entry 5104 (class 0 OID 16684)
-- Dependencies: 247
-- Data for Name: tbl_property_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_property_type (property_type_id, property_type_name, added_on, updated_on, updated_by, added_by, active_status, status, is_home, image, icon) FROM stdin;
5	Plant & Machinery	1751978805	1752063949	1	1	S	1	N	1752063949_686e5fcdf1f8c.png	\N
7	P&M	1751981669	1751981669	1	1	S	0	N	\N	\N
8	Vehicle	1751981677	1752066099	1	1	S	1	Y	1752066099_686e6833bc77f.jpg	
6	Land	1751981626	1752063966	1	1	S	1	Y	1752063966_686e5fde0cd82.jpg	\N
4	Residential	\N	1752063924	1	\N	S	1	Y	1752063924_686e5fb4578a5.png	\N
2	Commercial	1750749557.39863	1752063902	1	1	S	1	Y	1752063902_686e5f9e7fc02.png	
3	Industrial	1750749557.39863	1752063887	1	1	S	1	Y	1752063887_686e5f8f09b78.png	\N
1	Agriculture	1750749557.39863	1752068719	1	1	S	1	Y	1752063913_686e5fa920fb5.png	1752068719_686e726fcd9a3.png
\.


--
-- TOC entry 5092 (class 0 OID 16570)
-- Dependencies: 235
-- Data for Name: tbl_role; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_role (role_id, role, active_status, created_by, updated_by, added_on, updated_on, status) FROM stdin;
1	Superadmin	S	1	1	\N	\N	1
2	Admin	S	1	1	\N	\N	1
\.


--
-- TOC entry 5096 (class 0 OID 16628)
-- Dependencies: 239
-- Data for Name: tbl_state; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_state (state_id, state_name, added_on, updated_on, updated_by, added_by, active_status, status) FROM stdin;
1	Maharashtra	1750749338.520532	1750749338.520532	1	1	S	1
2	Gujarat	1750749338.520532	1750749338.520532	1	1	S	1
3	Karnataka	1750749338.520532	1750749338.520532	1	1	S	1
\.


--
-- TOC entry 5088 (class 0 OID 16467)
-- Dependencies: 231
-- Data for Name: tbl_test_user; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tbl_test_user (test_user_id, user_name, email_id, gender) FROM stdin;
1	ashish chawan	ashishchawan88@gmail.com	M
3	akshay	ak@fhhf.com	M
\.



--
-- TOC entry 4866 (class 2606 OID 16463)
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 4868 (class 2606 OID 16465)
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 4864 (class 2606 OID 16453)
-- Name: job_batches job_batches_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.job_batches
    ADD CONSTRAINT job_batches_pkey PRIMARY KEY (id);


--
-- TOC entry 4861 (class 2606 OID 16445)
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);


--
-- TOC entry 4845 (class 2606 OID 16395)
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);


--
-- TOC entry 4854 (class 2606 OID 16420)
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 4914 (class 2606 OID 16829)
-- Name: tbl_area_unit tbl_area_unit_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_area_unit
    ADD CONSTRAINT tbl_area_unit_pkey PRIMARY KEY (area_unit_id);


--
-- TOC entry 4912 (class 2606 OID 16813)
-- Name: tbl_auction tbl_auction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_auction
    ADD CONSTRAINT tbl_auction_pkey PRIMARY KEY (auction_id);


--
-- TOC entry 4902 (class 2606 OID 16702)
-- Name: tbl_bank tbl_bank_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_bank
    ADD CONSTRAINT tbl_bank_pkey PRIMARY KEY (bank_id);


--
-- TOC entry 4904 (class 2606 OID 16711)
-- Name: tbl_banker tbl_banker_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_banker
    ADD CONSTRAINT tbl_banker_pkey PRIMARY KEY (banker_id);


--
-- TOC entry 4906 (class 2606 OID 16727)
-- Name: tbl_borrower tbl_borrower_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_borrower
    ADD CONSTRAINT tbl_borrower_pkey PRIMARY KEY (borrower_id);


--
-- TOC entry 4916 (class 2606 OID 24586)
-- Name: tbl_budget tbl_budget_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_budget
    ADD CONSTRAINT tbl_budget_pkey PRIMARY KEY (budget_id);


--
-- TOC entry 4894 (class 2606 OID 16644)
-- Name: tbl_city tbl_city_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_city
    ADD CONSTRAINT tbl_city_pkey PRIMARY KEY (city_id);


--
-- TOC entry 4896 (class 2606 OID 16658)
-- Name: tbl_district tbl_district_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_district
    ADD CONSTRAINT tbl_district_pkey PRIMARY KEY (district_id);


--
-- TOC entry 4898 (class 2606 OID 16667)
-- Name: tbl_location tbl_location_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_location
    ADD CONSTRAINT tbl_location_pkey PRIMARY KEY (location_id);


--
-- TOC entry 4890 (class 2606 OID 16623)
-- Name: tbl_menu tbl_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_menu
    ADD CONSTRAINT tbl_menu_pkey PRIMARY KEY (menu_id);


--
-- TOC entry 4910 (class 2606 OID 16797)
-- Name: tbl_property_media tbl_property_media_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property_media
    ADD CONSTRAINT tbl_property_media_pkey PRIMARY KEY (property_media_id);


--
-- TOC entry 4908 (class 2606 OID 16751)
-- Name: tbl_property tbl_property_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property
    ADD CONSTRAINT tbl_property_pkey PRIMARY KEY (property_id);


--
-- TOC entry 4900 (class 2606 OID 16691)
-- Name: tbl_property_type tbl_property_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property_type
    ADD CONSTRAINT tbl_property_type_pkey PRIMARY KEY (property_type_id);


--
-- TOC entry 4886 (class 2606 OID 16577)
-- Name: tbl_role tbl_role_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_role
    ADD CONSTRAINT tbl_role_pkey PRIMARY KEY (role_id);


--
-- TOC entry 4892 (class 2606 OID 16635)
-- Name: tbl_state tbl_state_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_state
    ADD CONSTRAINT tbl_state_pkey PRIMARY KEY (state_id);


--
-- TOC entry 4870 (class 2606 OID 16472)
-- Name: tbl_test_user tbl_test_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_test_user
    ADD CONSTRAINT tbl_test_user_pkey PRIMARY KEY (test_user_id);


--
-- TOC entry 4887 (class 1259 OID 16625)
-- Name: idx_mapping_type; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_mapping_type ON public.tbl_menu USING btree (mapping_type);


--
-- TOC entry 4888 (class 1259 OID 16624)
-- Name: idx_parent_menu; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_parent_menu ON public.tbl_menu USING btree (parent_id, menu_type, is_show, role_id);


--
-- TOC entry 4884 (class 1259 OID 16578)
-- Name: idx_role; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_role ON public.tbl_role USING btree (role);


--
-- TOC entry 4862 (class 1259 OID 16446)
-- Name: jobs_queue_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue);


--
-- TOC entry 4852 (class 1259 OID 16422)
-- Name: sessions_last_activity_index; Type: INDEX; Schema: public; Owner: postgres
--

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


--
-- TOC entry 4855 (class 1259 OID 16421)
-- Name: sessions_user_id_index; Type: INDEX; Schema: public; Owner: postgres
--

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


--
-- TOC entry 4918 (class 2606 OID 16678)
-- Name: tbl_location fk_city; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_location
    ADD CONSTRAINT fk_city FOREIGN KEY (city_id) REFERENCES public.tbl_city(city_id) ON DELETE CASCADE;


--
-- TOC entry 4919 (class 2606 OID 16673)
-- Name: tbl_location fk_district; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_location
    ADD CONSTRAINT fk_district FOREIGN KEY (district_id) REFERENCES public.tbl_district(district_id) ON DELETE CASCADE;


--
-- TOC entry 4920 (class 2606 OID 16668)
-- Name: tbl_location fk_state; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_location
    ADD CONSTRAINT fk_state FOREIGN KEY (state_id) REFERENCES public.tbl_state(state_id) ON DELETE CASCADE;


--
-- TOC entry 4928 (class 2606 OID 16814)
-- Name: tbl_auction tbl_auction_property_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_auction
    ADD CONSTRAINT tbl_auction_property_id_fkey FOREIGN KEY (property_id) REFERENCES public.tbl_property(property_id) ON DELETE CASCADE;


--
-- TOC entry 4921 (class 2606 OID 16712)
-- Name: tbl_banker tbl_banker_bank_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_banker
    ADD CONSTRAINT tbl_banker_bank_id_fkey FOREIGN KEY (bank_id) REFERENCES public.tbl_bank(bank_id) ON DELETE CASCADE;


--
-- TOC entry 4917 (class 2606 OID 16645)
-- Name: tbl_city tbl_city_state_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_city
    ADD CONSTRAINT tbl_city_state_id_fkey FOREIGN KEY (state_id) REFERENCES public.tbl_state(state_id) ON DELETE CASCADE;


--
-- TOC entry 4922 (class 2606 OID 16772)
-- Name: tbl_property tbl_property_bank_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property
    ADD CONSTRAINT tbl_property_bank_id_fkey FOREIGN KEY (bank_id) REFERENCES public.tbl_bank(bank_id);


--
-- TOC entry 4923 (class 2606 OID 16767)
-- Name: tbl_property tbl_property_borrower_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property
    ADD CONSTRAINT tbl_property_borrower_id_fkey FOREIGN KEY (borrower_id) REFERENCES public.tbl_borrower(borrower_id);


--
-- TOC entry 4924 (class 2606 OID 16757)
-- Name: tbl_property tbl_property_district_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property
    ADD CONSTRAINT tbl_property_district_id_fkey FOREIGN KEY (district_id) REFERENCES public.tbl_district(district_id);


--
-- TOC entry 4925 (class 2606 OID 16752)
-- Name: tbl_property tbl_property_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property
    ADD CONSTRAINT tbl_property_location_id_fkey FOREIGN KEY (location_id) REFERENCES public.tbl_location(location_id);


--
-- TOC entry 4927 (class 2606 OID 16798)
-- Name: tbl_property_media tbl_property_media_property_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property_media
    ADD CONSTRAINT tbl_property_media_property_id_fkey FOREIGN KEY (property_id) REFERENCES public.tbl_property(property_id) ON DELETE CASCADE;


--
-- TOC entry 4926 (class 2606 OID 16762)
-- Name: tbl_property tbl_property_property_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tbl_property
    ADD CONSTRAINT tbl_property_property_type_id_fkey FOREIGN KEY (property_type_id) REFERENCES public.tbl_property_type(property_type_id);


-- Completed on 2025-07-12 15:20:53

--
--

