--
-- PostgreSQL database dump
--

-- Dumped from database version 14.11 (Ubuntu 14.11-0ubuntu0.22.04.1)
-- Dumped by pg_dump version 14.11 (Ubuntu 14.11-0ubuntu0.22.04.1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_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;

SET default_tablespace = '';

SET default_table_access_method = heap;

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

CREATE TABLE public.specifications (
    id bigint NOT NULL,
    name character varying(100),
    availability character varying(100),
    description text,
    specification_type character varying(50),
    icon character varying(50),
    object_id character varying(50),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.specifications OWNER TO postgres;

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

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


ALTER TABLE public.specifications_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.specifications_id_seq OWNED BY public.specifications.id;


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

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


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

COPY public.specifications (id, name, availability, description, specification_type, icon, object_id, created_at, updated_at) FROM stdin;
1	elevator	standard	Branded Elevators	other		6584450a43709ac7e665dfa0	2023-12-21 14:00:30	2023-12-21 14:00:30
2	fire_protection_system	standard	Fire fighting system	security		6584450a43709ac7e665dfc0	2023-12-21 14:00:30	2023-12-21 14:00:30
3	\N	standard	Double glazed glass in windows	windows		6584451443709ac7e665e3c1	2023-12-21 14:00:35	2023-12-21 14:00:35
4	kitchen_platform	standard	Granite Kitchen Platform	kitchen	304081	6584451b43709ac7e665eaaa	2023-12-21 14:00:40	2023-12-21 14:00:40
5	kitchen_sink	standard	Stainless Steel Sink	kitchen	304082	6584451b43709ac7e665eaac	2023-12-21 14:00:40	2023-12-21 14:00:40
6	living_and_dining_flooring	standard	Vitrified Flooring	flooring	304083	6584451b43709ac7e665eaae	2023-12-21 14:00:40	2023-12-21 14:00:40
7	master_bedroom_flooring	standard	Vitrified Flooring	flooring	304084	6584451b43709ac7e665eab0	2023-12-21 14:00:40	2023-12-21 14:00:40
8	other_bedrooms_flooring	standard	Vitrified Flooring	flooring	304085	6584451b43709ac7e665eab2	2023-12-21 14:00:40	2023-12-21 14:00:40
9	kitchen_flooring	standard	Vitrified Flooring	flooring	304086	6584451b43709ac7e665eab4	2023-12-21 14:00:40	2023-12-21 14:00:40
10	bathrooms_flooring	standard	Anti-Skid Vitrified Flooring	flooring	304087	6584451b43709ac7e665eab6	2023-12-21 14:00:40	2023-12-21 14:00:40
11	balcony_flooring	standard	Anti-Skid Vitrified Flooring	flooring	304088	6584451b43709ac7e665eab8	2023-12-21 14:00:40	2023-12-21 14:00:40
12	electrical_wiring	standard	Concealed Copper Wiring	electrical_specs	304089	6584451b43709ac7e665eaba	2023-12-21 14:00:40	2023-12-21 14:00:40
13	electrical_switches	standard	Modular Switches	electrical_specs	304090	6584451b43709ac7e665eabc	2023-12-21 14:00:40	2023-12-21 14:00:40
14	electrical_points	standard	Provision for broadband connection	electrical_specs	304578	6584451b43709ac7e665eabe	2023-12-21 14:00:40	2023-12-21 14:00:40
15	bathroom_cp_fittings	standard	Premium Quality C.P. Fittings	bathroom_specs	304092	6584451b43709ac7e665eac0	2023-12-21 14:00:40	2023-12-21 14:00:40
16	bathroom_sanitory_ware	standard	Premium Quality Sanitary Wares	bathroom_specs	304093	6584451c43709ac7e665eb9e	2023-12-21 14:00:41	2023-12-21 14:00:41
17	rcc_structure	standard	Earthquake Resistant RCC Framed Structure	RCC	304094	6584451c43709ac7e665eba0	2023-12-21 14:00:41	2023-12-21 14:00:41
18	window_type	standard	Aluminum Sliding Windows	windows	304095	6584451c43709ac7e665eba2	2023-12-21 14:00:41	2023-12-21 14:00:41
19	modular_kitchen	standard	Modular kitchen	kitchen	304062	6584451c43709ac7e665eba7	2023-12-21 14:00:41	2023-12-21 14:00:41
20	kitchen_walls	standard	Ceramic / Glazed tiles above kitchen platform	interior	304074	6584451c43709ac7e665eba9	2023-12-21 14:00:41	2023-12-21 14:00:41
21	water_purifier	standard	Water purifier	kitchen	304066	6584451c43709ac7e665ebab	2023-12-21 14:00:41	2023-12-21 14:00:41
22	exhaust_fan	standard	Exhaust hood / chimney and gas hob	kitchen	304064	6584451c43709ac7e665ebad	2023-12-21 14:00:41	2023-12-21 14:00:41
23	video_door_phone	standard	Video door phone	security	304042	6584451c43709ac7e665ebb5	2023-12-21 14:00:42	2023-12-21 14:00:42
24	intercom	standard	Intercom security	security	304043	6584451c43709ac7e665ebb7	2023-12-21 14:00:42	2023-12-21 14:00:42
25	tv_cable_connection	standard	Provision for T.V.	electrical_specs	304577	6584451c43709ac7e665ebbb	2023-12-21 14:00:42	2023-12-21 14:00:42
26	telephone_connection	standard	Point for telephone in living & all bedrooms	electrical_specs	304070	6584451c43709ac7e665ebbd	2023-12-21 14:00:42	2023-12-21 14:00:42
27	ac_connection	standard	Provision for A/C in Bedrooms	electrical_specs	303866	6584451c43709ac7e665ebbf	2023-12-21 14:00:42	2023-12-21 14:00:42
28	bathroom_walls	standard	Designer dado tiles in toilets	interior	304047	6584451c43709ac7e665ebc3	2023-12-21 14:00:42	2023-12-21 14:00:42
29	interior_wall_paint	standard	Superior quality paint	paints	304053	6584451c43709ac7e665ebc5	2023-12-21 14:00:42	2023-12-21 14:00:42
30	exterior_wall_paint	standard	High quality Paint	paints	304055	6584451c43709ac7e665ebc7	2023-12-21 14:00:42	2023-12-21 14:00:42
31	sewage_treatment_plant	standard	Sewage Treatment Plant	other	303887	6584451c43709ac7e665ebcb	2023-12-21 14:00:42	2023-12-21 14:00:42
32	solar_water_heater	standard	Solar water heating system	other	304044	6584451c43709ac7e665ebcd	2023-12-21 14:00:42	2023-12-21 14:00:42
33	dg_power_backup	standard	Power back up for common utilities	other	304072	6584451c43709ac7e665ebcf	2023-12-21 14:00:42	2023-12-21 14:00:42
34	balcony_railings	standard	M.S. Railings	exterior	303156	6584451d43709ac7e665ec59	2023-12-21 14:00:42	2023-12-21 14:00:42
35	main_door	standard	Flush door with decorative laminate finish	doors	304054	6584451d43709ac7e665ec5d	2023-12-21 14:00:42	2023-12-21 14:00:42
36	internal_doors	standard	Moulded flush door panel with skin door / laminated	doors	304056	6584451d43709ac7e665ec5f	2023-12-21 14:00:42	2023-12-21 14:00:42
37	door_fittings	standard	Designer Door fittings & locks	doors	304057	6584451d43709ac7e665ec61	2023-12-21 14:00:42	2023-12-21 14:00:42
38	balcony_doors	standard	M. S. French Doors for Terraces	doors	303881	6584451d43709ac7e665ec63	2023-12-21 14:00:42	2023-12-21 14:00:42
39	mosquito_mesh	standard	Mosquito net & safety grill	windows	304059	6584451d43709ac7e665ec66	2023-12-21 14:00:42	2023-12-21 14:00:42
40	window_sill	standard	Granite window sill	windows	304060	6584451d43709ac7e665ec68	2023-12-21 14:00:42	2023-12-21 14:00:42
41	door_grill	standard	Wooden / Ply Door Frame	doors	287937	6584451d43709ac7e665ed2f	2023-12-21 14:00:43	2023-12-21 14:00:43
42	geyser	standard	Provision for water Heater in washrooms	bathroom_specs	303871	6584451e43709ac7e665ed40	2023-12-21 14:00:43	2023-12-21 14:00:43
43	gas_supply	standard	Piped gas supply	kitchen	304065	6584451e43709ac7e665eead	2023-12-21 14:00:45	2023-12-21 14:00:45
44	door_lock	standard	Night latch	doors	303771	6584451e43709ac7e665eedd	2023-12-21 14:00:44	2023-12-21 14:00:44
45	wash_basin_counter	standard	One wash basin at appropriate place with glazed ceramic tiles	bathroom_specs	303765	6584451f43709ac7e665f1b2	2023-12-21 14:00:50	2023-12-21 14:00:50
46	water_heater	standard	Provision for geyser	kitchen	267605	6584452043709ac7e665f547	2023-12-21 14:00:55	2023-12-21 14:00:55
47	automation_console	standard	Wi-fi enabled (living and bedroom)	automation	297704	6584452043709ac7e665f57b	2023-12-21 14:00:55	2023-12-21 14:00:55
48	bathroom_ewc_toilet_type	standard	Designer Commode With Flush Tank	bathroom_specs	303868	6584452243709ac7e665fe4a	2023-12-21 14:01:01	2023-12-21 14:01:01
49	ac	standard	Internal & External 6 thick high-quality ACC Blocks	interior	194426	65844ec443709ac7e668850c	2023-12-21 14:41:59	2023-12-21 14:41:59
\.


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

SELECT pg_catalog.setval('public.specifications_id_seq', 49, true);


--
-- Name: specifications specifications_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.specifications
    ADD CONSTRAINT specifications_pkey PRIMARY KEY (id);


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

CREATE INDEX specifications_availability_index ON public.specifications USING btree (availability);


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

CREATE INDEX specifications_specification_type_index ON public.specifications USING btree (specification_type);


--
-- PostgreSQL database dump complete
--

