--
-- PostgreSQL database dump
--

-- Dumped from database version 16.2 (Ubuntu 16.2-1.pgdg23.10+1)
-- Dumped by pg_dump version 16.2 (Ubuntu 16.2-1.pgdg23.10+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: project_scores; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.project_scores (
    id bigint NOT NULL,
    project_id integer NOT NULL,
    location double precision DEFAULT 0 NOT NULL,
    micromarket integer DEFAULT 0 NOT NULL,
    lifestyle integer DEFAULT 0 NOT NULL,
    project_size integer DEFAULT 0 NOT NULL,
    number_of_floors integer DEFAULT 0 NOT NULL,
    density_factor integer DEFAULT 0 NOT NULL,
    amenity double precision DEFAULT 0 NOT NULL,
    community integer DEFAULT 0 NOT NULL,
    brand integer DEFAULT 0 NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    total_score double precision DEFAULT 0
);


ALTER TABLE public.project_scores OWNER TO postgres;

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

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


ALTER SEQUENCE public.project_score_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.project_score_id_seq OWNED BY public.project_scores.id;


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

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


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

COPY public.project_scores (id, project_id, location, micromarket, lifestyle, project_size, number_of_floors, density_factor, amenity, community, brand, created_at, updated_at, total_score) FROM stdin;
26	38745	57.143	86	18	10	35	10	7	30	0	\N	\N	32.943
27	39960	57.143	89	54	10	20	95	7	100	0	\N	\N	47.643
28	8655	57.143	93	49	60	60	95	14	45	0	\N	\N	46.043
29	41120	57.143	96	20	10	100	10	14	10	0	\N	\N	34.743
30	39880	57.143	100	49	60	80	95	17	35	0	\N	\N	46.743
8	26003	57.143	21	13	10	35	18	7	10	0	\N	\N	24.443
9	38848	57.143	25	30	10	35	90	14	10	0	\N	\N	31.643
14	39824	57.143	43	10	10	20	10	7	10	0	\N	\N	25.443
15	40847	57.143	46	18	10	35	10	7	30	0	\N	\N	28.943
16	39895	57.143	50	28	10	35	90	7	10	0	\N	\N	33.343
17	14452	57.143	54	37	10	20	90	7	45	0	\N	\N	37.343
18	25143	57.143	57	35	10	20	95	7	35	0	\N	\N	36.843
19	41113	57.143	61	39	10	20	100	7	45	0	\N	\N	38.843
20	40350	57.143	64	18	10	35	10	7	30	0	\N	\N	30.743
22	41295	57.143	71	46	60	100	10	24.5	70	0	\N	\N	42.643
23	40993	57.143	75	27	10	80	18	14	35	0	\N	\N	35.443
3	39321	57.143	4	39	10	60	90	35	10	0	\N	\N	33.143
6	13069	57.143	14	26	10	35	10	35	30	0	\N	\N	28.943
7	20888	57.143	18	42	60	35	90	14	35	0	\N	\N	35.743
5	16215	57.143	11	40	30	35	100	14	30	0	\N	\N	34.243
33	40737	71.429	100	34	30	35	10	14	70	0	\N	\N	45.029
32	8955	71.429	67	26	30	35	10	24.5	35	0	\N	\N	38.529
31	41634	71.429	33	27	10	20	95	7	10	0	\N	\N	35.529
35	39407	85.714	50	32	10	20	58	24.5	35	0	\N	\N	43.514
36	39685	85.714	75	37	10	35	95	35	10	0	\N	\N	48.014
37	39901	85.714	100	40	10	20	95	14	45	0	\N	\N	51.714
34	38891	85.714	25	45	10	20	100	14	60	0	\N	\N	46.214
42	29873	100	33	43	10	20	95	24.5	45	0	\N	\N	50.5
43	22782	100	40	43	10	20	95	35	35	0	\N	\N	51.2
44	32718	100	47	31	10	20	90	24.5	10	0	\N	\N	47.1
45	39899	100	53	45	10	20	90	35	45	0	\N	\N	53.3
46	42155	100	60	43	10	20	95	24.5	45	0	\N	\N	53.2
47	41733	100	67	29	10	20	58	14	35	0	\N	\N	48.3
50	31519	100	87	47	10	20	95	14	70	0	\N	\N	57.5
51	41736	100	93	43	10	20	95	24.5	45	0	\N	\N	56.5
52	40723	100	100	39	10	20	90	14	45	0	\N	\N	55.6
38	10035	100	7	39	10	20	90	14	45	0	\N	\N	46.3
48	24179	100	73	43	10	20	100	35	30	0	\N	\N	54.5
39	42365	100	13	42	10	20	90	24.5	45	0	\N	\N	48.1
40	42412	100	20	41	10	20	100	24.5	35	0	\N	\N	48.4
54	33475	14.286	15	43	10	35	100	17	45	0	\N	\N	22.986
55	40069	14.286	23	36	10	20	95	17	30	0	\N	\N	20.986
56	42603	14.286	31	36	30	80	58	35	10	0	\N	\N	21.786
57	42657	14.286	38	22	10	35	10	7	45	0	\N	\N	16.886
58	42702	14.286	46	39	10	35	95	7	45	0	\N	\N	24.486
59	40612	14.286	54	52	30	60	100	7	70	0	\N	\N	30.486
60	23267	14.286	62	19	10	20	18	7	35	0	\N	\N	18.086
61	40426	14.286	69	36	10	20	95	17	30	0	\N	\N	25.586
63	39753	14.286	85	25	10	60	10	7	45	0	\N	\N	22.786
64	42785	14.286	92	38	30	20	95	35	10	0	\N	\N	28.686
65	40436	14.286	100	27	10	35	10	7	60	0	\N	\N	25.086
74	2177	28.571	47	40	30	35	95	14	35	0	\N	\N	29.271
75	41655	28.571	53	35	10	20	95	14	30	0	\N	\N	27.871
76	40802	28.571	58	35	10	80	10	35	45	0	\N	\N	28.371
80	42031	28.571	79	28	10	20	90	14	10	0	\N	\N	27.671
81	38480	28.571	84	51	30	35	100	35	45	0	\N	\N	37.371
82	3205	28.571	89	47	10	20	95	52.5	30	0	\N	\N	36.271
83	40377	28.571	95	34	10	20	10	52.5	45	0	\N	\N	31.671
84	16008	28.571	100	35	10	20	90	35	10	0	\N	\N	32.571
67	20871	28.571	11	48	10	20	100	24.5	60	0	\N	\N	28.871
68	1281	28.571	16	50	30	35	95	35	45	0	\N	\N	30.171
69	26215	28.571	21	49	60	35	90	35	35	0	\N	\N	30.271
70	14952	28.571	26	47	10	20	100	35	45	0	\N	\N	29.971
71	38969	28.571	32	52	80	35	100	24.5	45	0	\N	\N	32.571
72	16708	28.571	37	58	30	60	100	52.5	45	0	\N	\N	35.471
73	40411	28.571	42	22	10	35	18	35	10	0	\N	\N	21.571
78	40869	28.571	68	38	10	20	95	24.5	30	0	\N	\N	30.571
79	34318	28.571	74	36	10	20	18	52.5	45	0	\N	\N	30.371
13	40249	57.143	39	32	30	35	34	17	45	0	\N	\N	33.843
24	40676	57.143	79	21	10	35	58	7	10	0	\N	\N	33.443
25	41346	57.143	82	25	30	20	10	14	45	0	\N	\N	35.343
2	11230	42.857	100	43	10	80	10	63	45	0	\N	\N	40.057
1	8378	42.857	50	20	10	20	58	7	10	0	\N	\N	25.857
12	40374	57.143	36	18	10	35	10	7	30	0	\N	\N	27.943
10	38362	57.143	29	37	60	20	58	14	45	0	\N	\N	34.843
21	40666	57.143	68	31	60	100	10	7	35	0	\N	\N	36.343
4	26319	57.143	7	44	60	20	100	7	45	0	\N	\N	35.443
11	18953	57.143	32	41	10	35	10	14	100	0	\N	\N	36.743
41	40804	100	27	44	10	20	58	52.5	45	0	\N	\N	50.3
49	1021	100	80	44	10	20	58	52.5	45	0	\N	\N	55.6
53	42794	14.286	8	28	10	35	90	7	10	0	\N	\N	16.286
62	39993	14.286	77	48	10	20	95	7	80	0	\N	\N	31.186
77	42898	28.571	63	33	10	20	100	24.5	10	0	\N	\N	28.071
66	43042	28.571	5	23	10	20	10	14	45	0	\N	\N	18.271
\.


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

SELECT pg_catalog.setval('public.project_score_id_seq', 84, true);


--
-- Name: project_scores project_score_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_scores
    ADD CONSTRAINT project_score_pkey PRIMARY KEY (id);


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

CREATE INDEX fki_project_score_project_id_foreign_key ON public.project_scores USING btree (project_id);


--
-- Name: project_scores project_score_project_id_foreign_key; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_scores
    ADD CONSTRAINT project_score_project_id_foreign_key FOREIGN KEY (project_id) REFERENCES public.projects(id) NOT VALID;


--
-- PostgreSQL database dump complete
--

