-- -- PostgreSQL database dump -- -- Dumped from database version 17.5 -- Dumped by pg_dump version 17.5 -- Started on 2025-07-12 15:20:52 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- 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; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- TOC entry 223 (class 1259 OID 16423) -- Name: cache; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.cache ( key character varying(255) NOT NULL, value text NOT NULL, expiration integer NOT NULL ); ALTER TABLE public.cache OWNER TO postgres; -- -- TOC entry 224 (class 1259 OID 16430) -- Name: cache_locks; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.cache_locks ( key character varying(255) NOT NULL, owner character varying(255) NOT NULL, expiration integer NOT NULL ); ALTER TABLE public.cache_locks 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 221 (class 1259 OID 16407) -- Name: password_reset_tokens; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.password_reset_tokens ( email character varying(255) NOT NULL, token character varying(255) NOT NULL, created_at timestamp(0) without time zone ); ALTER TABLE public.password_reset_tokens OWNER TO postgres; -- -- 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 233 (class 1259 OID 16482) -- Name: tbl_admin; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.tbl_admin ( admin_id integer NOT NULL, tbl_prefix character varying(50), sector character varying(200), business_type character varying(100), first_name character varying(255), last_name character varying(255), abbreviation character varying(20), role_id integer, hierarchy_id integer, hierarchy_value_id integer, parent_id integer, email_id character varying(255), std_code character varying(20), mob_no character varying(255), admin_status character varying(1) DEFAULT 'A'::character varying, job_status_id integer, username character varying(255), password character varying(255), landmark character varying(255), state_id character varying(100), pin_code character varying(255), profile_pic character varying(100), device_token text, last_login character varying(255), active_status public.enum_active_status DEFAULT 'S'::public.enum_active_status NOT NULL, created_by integer, updated_by integer, added_on numeric, updated_on numeric, status public.enum_status DEFAULT '1'::public.enum_status NOT NULL ); ALTER TABLE public.tbl_admin 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 220 (class 1259 OID 16397) -- Name: users; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.users ( id bigint NOT NULL, name character varying(255) NOT NULL, email character varying(255) NOT NULL, email_verified_at timestamp(0) without time zone, password character varying(255) NOT NULL, remember_token character varying(100), created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.users OWNER TO postgres; -- -- 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 4791 (class 2604 OID 16485) -- Name: tbl_admin admin_id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tbl_admin ALTER COLUMN admin_id SET DEFAULT nextval('public.tbl_admin_admin_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 4786 (class 2604 OID 16400) -- Name: users id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass); -- -- TOC entry 5080 (class 0 OID 16423) -- Dependencies: 223 -- Data for Name: cache; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.cache (key, value, expiration) FROM stdin; \. -- -- TOC entry 5081 (class 0 OID 16430) -- Dependencies: 224 -- Data for Name: cache_locks; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.cache_locks (key, owner, expiration) FROM stdin; \. -- -- 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 5078 (class 0 OID 16407) -- Dependencies: 221 -- Data for Name: password_reset_tokens; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.password_reset_tokens (email, token, created_at) FROM stdin; \. -- -- 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 5090 (class 0 OID 16482) -- Dependencies: 233 -- Data for Name: tbl_admin; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.tbl_admin (admin_id, tbl_prefix, sector, business_type, first_name, last_name, abbreviation, role_id, hierarchy_id, hierarchy_value_id, parent_id, email_id, std_code, mob_no, admin_status, job_status_id, username, password, landmark, state_id, pin_code, profile_pic, device_token, last_login, active_status, created_by, updated_by, added_on, updated_on, status) FROM stdin; 1 \N \N \N Auctionwale \N \N 1 0 0 0 info@auctionwale.com \N 9999999999 A 0 AW00001 833d42772c3fd3f382d1646ecfeea1c8 \N \N \N \N \N 12-07-2025 05:17:32 AM S 0 0 0 0 1 \. -- -- 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 5077 (class 0 OID 16397) -- Dependencies: 220 -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.users (id, name, email, email_verified_at, password, remember_token, created_at, updated_at) FROM stdin; \. -- -- TOC entry 5149 (class 0 OID 0) -- Dependencies: 228 -- Name: failed_jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.failed_jobs_id_seq', 1, false); -- -- TOC entry 5150 (class 0 OID 0) -- Dependencies: 225 -- Name: jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.jobs_id_seq', 1, false); -- -- TOC entry 5151 (class 0 OID 0) -- Dependencies: 217 -- Name: migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.migrations_id_seq', 3, true); -- -- TOC entry 5152 (class 0 OID 0) -- Dependencies: 232 -- Name: tbl_admin_admin_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_admin_admin_id_seq', 2, true); -- -- TOC entry 5153 (class 0 OID 0) -- Dependencies: 260 -- Name: tbl_area_unit_area_unit_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_area_unit_area_unit_id_seq', 12, true); -- -- TOC entry 5154 (class 0 OID 0) -- Dependencies: 258 -- Name: tbl_auction_auction_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_auction_auction_id_seq', 24, true); -- -- TOC entry 5155 (class 0 OID 0) -- Dependencies: 248 -- Name: tbl_bank_bank_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_bank_bank_id_seq', 13, true); -- -- TOC entry 5156 (class 0 OID 0) -- Dependencies: 250 -- Name: tbl_banker_banker_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_banker_banker_id_seq', 13, true); -- -- TOC entry 5157 (class 0 OID 0) -- Dependencies: 252 -- Name: tbl_borrower_borrower_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_borrower_borrower_id_seq', 16, true); -- -- TOC entry 5158 (class 0 OID 0) -- Dependencies: 262 -- Name: tbl_budget_budget_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_budget_budget_id_seq', 4, true); -- -- TOC entry 5159 (class 0 OID 0) -- Dependencies: 240 -- Name: tbl_city_city_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_city_city_id_seq', 8, true); -- -- TOC entry 5160 (class 0 OID 0) -- Dependencies: 242 -- Name: tbl_district_district_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_district_district_id_seq', 9, true); -- -- TOC entry 5161 (class 0 OID 0) -- Dependencies: 244 -- Name: tbl_location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_location_location_id_seq', 11, true); -- -- TOC entry 5162 (class 0 OID 0) -- Dependencies: 236 -- Name: tbl_menu_menu_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_menu_menu_id_seq', 15, true); -- -- TOC entry 5163 (class 0 OID 0) -- Dependencies: 256 -- Name: tbl_property_media_property_media_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_property_media_property_media_id_seq', 78, true); -- -- TOC entry 5164 (class 0 OID 0) -- Dependencies: 254 -- Name: tbl_property_property_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_property_property_id_seq', 25, true); -- -- TOC entry 5165 (class 0 OID 0) -- Dependencies: 246 -- Name: tbl_property_type_property_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_property_type_property_type_id_seq', 8, true); -- -- TOC entry 5166 (class 0 OID 0) -- Dependencies: 234 -- Name: tbl_role_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_role_role_id_seq', 2, true); -- -- TOC entry 5167 (class 0 OID 0) -- Dependencies: 238 -- Name: tbl_state_state_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_state_state_id_seq', 3, true); -- -- TOC entry 5168 (class 0 OID 0) -- Dependencies: 230 -- Name: tbl_test_user_test_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.tbl_test_user_test_user_id_seq', 3, true); -- -- TOC entry 5169 (class 0 OID 0) -- Dependencies: 219 -- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.users_id_seq', 1, false); -- -- TOC entry 4859 (class 2606 OID 16436) -- Name: cache_locks cache_locks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.cache_locks ADD CONSTRAINT cache_locks_pkey PRIMARY KEY (key); -- -- TOC entry 4857 (class 2606 OID 16429) -- Name: cache cache_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.cache ADD CONSTRAINT cache_pkey PRIMARY KEY (key); -- -- 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 4851 (class 2606 OID 16413) -- Name: password_reset_tokens password_reset_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.password_reset_tokens ADD CONSTRAINT password_reset_tokens_pkey PRIMARY KEY (email); -- -- 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 4883 (class 2606 OID 16494) -- Name: tbl_admin tbl_admin_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tbl_admin ADD CONSTRAINT tbl_admin_pkey PRIMARY KEY (admin_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 4847 (class 2606 OID 16406) -- Name: users users_email_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_email_unique UNIQUE (email); -- -- TOC entry 4849 (class 2606 OID 16404) -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_pkey PRIMARY KEY (id); -- -- TOC entry 4871 (class 1259 OID 16519) -- Name: idx_active_status; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_active_status ON public.tbl_admin USING btree (active_status); -- -- TOC entry 4872 (class 1259 OID 16505) -- Name: idx_added_on; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_added_on ON public.tbl_admin USING btree (added_on); -- -- TOC entry 4873 (class 1259 OID 16500) -- Name: idx_created_by; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_created_by ON public.tbl_admin USING btree (created_by); -- -- TOC entry 4874 (class 1259 OID 16496) -- Name: idx_hierarchy_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_hierarchy_id ON public.tbl_admin USING btree (hierarchy_id); -- -- TOC entry 4875 (class 1259 OID 16497) -- Name: idx_hierarchy_value_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_hierarchy_value_id ON public.tbl_admin USING btree (hierarchy_value_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 4876 (class 1259 OID 16498) -- Name: idx_parent_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_parent_id ON public.tbl_admin USING btree (parent_id); -- -- 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 4877 (class 1259 OID 16495) -- Name: idx_role_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_role_id ON public.tbl_admin USING btree (role_id); -- -- TOC entry 4878 (class 1259 OID 16504) -- Name: idx_state_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_state_id ON public.tbl_admin USING btree (state_id); -- -- TOC entry 4879 (class 1259 OID 16539) -- Name: idx_status; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_status ON public.tbl_admin USING btree (status); -- -- TOC entry 4880 (class 1259 OID 16501) -- Name: idx_updated_by; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_updated_by ON public.tbl_admin USING btree (updated_by); -- -- TOC entry 4881 (class 1259 OID 16506) -- Name: idx_updated_on; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_updated_on ON public.tbl_admin USING btree (updated_on); -- -- 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 -- -- PostgreSQL database dump complete --