{"id":2198,"date":"2019-07-29T13:22:52","date_gmt":"2019-07-29T11:22:52","guid":{"rendered":"http:\/\/jakisproblem.pl\/?p=2198"},"modified":"2019-07-29T13:22:52","modified_gmt":"2019-07-29T11:22:52","slug":"slowniki-w-bazie-danych","status":"publish","type":"post","link":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/2019\/07\/29\/slowniki-w-bazie-danych\/","title":{"rendered":"S\u0142owniki w bazie danych"},"content":{"rendered":"\n

Tabela S\u0142owniki<\/p>\n\n\n\nCREATE TABLE [dbo].[slowniki](\n\t[id_slownika] [int] IDENTITY(1,1) NOT NULL,\n\t[nazwa] [nvarchar](50) NULL,\n\t[tabela] [nvarchar](50) NULL,\n CONSTRAINT [PK_slowniki] PRIMARY KEY CLUSTERED \n(\n\t[id_slownika] ASC\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\n) ON [PRIMARY]\n\nGO\n\n\n\n
id_slownika<\/td>Nazwa<\/td>Tabela<\/td><\/tr>
1<\/td>NN<\/td>NULL<\/td><\/tr>
2<\/td>NN<\/td>NULL<\/td><\/tr>
3<\/td>Ocena szczeg\u00f3\u0142owej lokalizacji budynku<\/td>budynek<\/td><\/tr>
4<\/td>Ocena po\u0142o\u017cenia mieszkania w budynku<\/td>lokal<\/td><\/tr>
5<\/td>NN<\/td>NULL<\/td><\/tr>
6<\/td>NN<\/td>NULL<\/td><\/tr>
7<\/td>NN<\/td>NULL<\/td><\/tr>
8<\/td>NN<\/td>NULL<\/td><\/tr>
9<\/td>Stan budynku<\/td>budynek<\/td><\/tr>
10<\/td>Technologia budowy<\/td>budynek<\/td><\/tr>
11<\/td>Standard wyko\u0144czenia<\/td>inwestycja, lokal(domy, RP)<\/td><\/tr>
12<\/td>Standard wyko\u0144czenia<\/td>lokal, lokal (domy, RW)<\/td><\/tr>
13<\/td>waluta<\/td>czynsznk, budyneknk_transakcja, budyneknk_wycena<\/td><\/tr><\/tbody><\/table>\n\n\n\n

Tabela S\u0142ownik <\/p>\n\n\n\nCREATE TABLE [dbo].[slownik](\n\t[id_klucz] [int] IDENTITY(1,1) NOT NULL,\n\t[id_slownika] [int] NOT NULL,\n\t[nr_pozycji] [tinyint] NOT NULL,\n\t[tekst] [varchar](64) NOT NULL,\n CONSTRAINT [PK_slownik] PRIMARY KEY CLUSTERED \n(\n\t[id_klucz] ASC\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\n) ON [PRIMARY]\n\nGO\n\n\n\n
id_klucz<\/td>id_slownika<\/td>nr_pozycji<\/td>tekst<\/td><\/tr>
1<\/td>1<\/td>1<\/td>bezpo\u015bredni<\/td><\/tr>
2<\/td>1<\/td>2<\/td>bezpo\u015bredni naro\u017cny<\/td><\/tr>
3<\/td>1<\/td>3<\/td>po\u015bredni z drogi dojazdowej<\/td><\/tr>
4<\/td>2<\/td>1<\/td>niekorzystny<\/td><\/tr>
5<\/td>2<\/td>2<\/td>przeci\u0119tny<\/td><\/tr>
6<\/td>2<\/td>3<\/td>korzystny<\/td><\/tr>
7<\/td>3<\/td>1<\/td>ma\u0142o korzystna<\/td><\/tr>
8<\/td>3<\/td>2<\/td>przeci\u0119tna<\/td><\/tr>
9<\/td>3<\/td>3<\/td>korzystna<\/td><\/tr>
11<\/td>4<\/td>1<\/td>ma\u0142o korzystne<\/td><\/tr>
12<\/td>4<\/td>2<\/td>przeci\u0119tne<\/td><\/tr>
13<\/td>4<\/td>3<\/td>korzystne<\/td><\/tr>
14<\/td>5<\/td>1<\/td>autobus<\/td><\/tr>
15<\/td>5<\/td>2<\/td>tramwaj<\/td><\/tr>
16<\/td>5<\/td>3<\/td>PKP<\/td><\/tr>
17<\/td>5<\/td>4<\/td>PKS<\/td><\/tr>
18<\/td>5<\/td>5<\/td>inne<\/td><\/tr>
19<\/td>6<\/td>1<\/td>do\u015b\u0107 niska<\/td><\/tr>
21<\/td>6<\/td>2<\/td>przeci\u0119tna<\/td><\/tr>
22<\/td>6<\/td>3<\/td>do\u015b\u0107 wysoka<\/td><\/tr>
23<\/td>6<\/td>4<\/td>wysoka<\/td><\/tr>
24<\/td>6<\/td>5<\/td>bardzo wysoka<\/td><\/tr>
25<\/td>7<\/td>1<\/td>centralna<\/td><\/tr>
26<\/td>7<\/td>2<\/td>\u015br\u00f3dmiejska<\/td><\/tr>
27<\/td>7<\/td>3<\/td>po\u015brednia<\/td><\/tr>
28<\/td>7<\/td>4<\/td>peryferyjna<\/td><\/tr>
29<\/td>8<\/td>1<\/td>sprzeda\u017c<\/td><\/tr>
30<\/td>8<\/td>2<\/td>najem<\/td><\/tr>
31<\/td>9<\/td>1<\/td>po generalnym remoncie<\/td><\/tr>
32<\/td>9<\/td>2<\/td>po wymianie instalacji w budynku<\/td><\/tr>
33<\/td>9<\/td>3<\/td>do generalnego remontu<\/td><\/tr>
34<\/td>10<\/td>1<\/td>tradycyjna<\/td><\/tr>
35<\/td>10<\/td>2<\/td>tradycyjna udoskonalona<\/td><\/tr>
36<\/td>10<\/td>3<\/td>monolityczna<\/td><\/tr>
37<\/td>10<\/td>5<\/td>drewniana<\/td><\/tr>
40<\/td>11<\/td>1<\/td>podstawowy<\/td><\/tr>
41<\/td>11<\/td>2<\/td>pod klucz<\/td><\/tr>
44<\/td>14<\/td>1<\/td>ciemna<\/td><\/tr>
45<\/td>14<\/td>2<\/td>widna<\/td><\/tr>
46<\/td>15<\/td>1<\/td>sprzedany<\/td><\/tr>
47<\/td>15<\/td>2<\/td>w ofercie sprzeda\u017cy<\/td><\/tr>
49<\/td>15<\/td>3<\/td>wynaj\u0119ty<\/td><\/tr>
51<\/td>15<\/td>4<\/td>do wynajecia<\/td><\/tr>
52<\/td>14<\/td>3<\/td>aneks po\u0142\u0105czony z salonem<\/td><\/tr>
54<\/td>16<\/td>1<\/td>w\u0142asno\u015b\u0107<\/td><\/tr>
56<\/td>16<\/td>2<\/td>sp\u00f3\u0142dzielcze w\u0142asno\u015bciowe prawo do lokalu<\/td><\/tr>
57<\/td>10<\/td>4<\/td>prefabrykowana<\/td><\/tr>
58<\/td>8<\/td>3<\/td>sprzeda\u017c i najem<\/td><\/tr>
59<\/td>17<\/td>1<\/td>sprzeda\u017c<\/td><\/tr>
60<\/td>17<\/td>2<\/td>najem<\/td><\/tr>
61<\/td>17<\/td>3<\/td>podnajem<\/td><\/tr>
64<\/td>12<\/td>1<\/td>wysoki<\/td><\/tr>
65<\/td>12<\/td>2<\/td>przeci\u0119tny<\/td><\/tr>
66<\/td>12<\/td>3<\/td>niski<\/td><\/tr>
67<\/td>18<\/td>1<\/td>PLN<\/td><\/tr>
68<\/td>18<\/td>2<\/td>EUR<\/td><\/tr>
69<\/td>18<\/td>3<\/td>USD<\/td><\/tr>
70<\/td>19<\/td>1<\/td>z\u0142a<\/td><\/tr>
71<\/td>19<\/td>2<\/td>przeci\u0119tna<\/td><\/tr>
72<\/td>19<\/td>3<\/td>dobra<\/td><\/tr>
73<\/td>12<\/td>4<\/td>stan surowy<\/td><\/tr>
74<\/td>9<\/td>4<\/td>po modernizacji<\/td><\/tr>
75<\/td>9<\/td>5<\/td>bez modernizacji<\/td><\/tr>
76<\/td>15<\/td>5<\/td>niekontynuowany<\/td><\/tr>
81<\/td>20<\/td>1<\/td>MPZP<\/td><\/tr>
82<\/td>20<\/td>2<\/td>studium<\/td><\/tr>
83<\/td>20<\/td>3<\/td>warunki zabudowy<\/td><\/tr>
84<\/td>21<\/td>4<\/td>funkcja mieszkaniowa i towarzysz\u0105ce<\/td><\/tr>
85<\/td>21<\/td>2<\/td>budownictwo jednorodzinne<\/td><\/tr>
86<\/td>21<\/td>3<\/td>budownictwo jedno-wielorodzinne<\/td><\/tr>
87<\/td>22<\/td>1<\/td>w\u0142asno\u015b\u0107<\/td><\/tr>
88<\/td>22<\/td>2<\/td>u\u017cytkowanie wieczyste<\/td><\/tr>
89<\/td>23<\/td>1<\/td>regularny<\/td><\/tr>
90<\/td>23<\/td>2<\/td>nieregularny<\/td><\/tr>
91<\/td>23<\/td>3<\/td>wyd\u0142u\u017cony<\/td><\/tr>
92<\/td>23<\/td>4<\/td>mocno wyd\u0142u\u017cony<\/td><\/tr>
93<\/td>24<\/td>1<\/td>u\u017cytkowa<\/td><\/tr>
94<\/td>24<\/td>2<\/td>ca\u0142kowita<\/td><\/tr>
95<\/td>24<\/td>3<\/td>zabudowy<\/td><\/tr>
96<\/td>24<\/td>4<\/td>mieszkalna<\/td><\/tr>
97<\/td>25<\/td>1<\/td>bli\u017aniacza<\/td><\/tr>
98<\/td>25<\/td>2<\/td>szeregowa<\/td><\/tr>
99<\/td>26<\/td>1<\/td>tak, w dzia\u0142ce<\/td><\/tr>
100<\/td>26<\/td>2<\/td>tak, w drodze<\/td><\/tr>
101<\/td>26<\/td>3<\/td>nie<\/td><\/tr>
102<\/td>27<\/td>1<\/td>utwardzona<\/td><\/tr>
103<\/td>27<\/td>2<\/td>nieutwardzona<\/td><\/tr>
104<\/td>27<\/td>3<\/td>s\u0142u\u017cebno\u015b\u0107<\/td><\/tr>
105<\/td>25<\/td>3<\/td>wolnostoj\u0105ca<\/td><\/tr>
107<\/td>28<\/td>1<\/td>bli\u017aniacza<\/td><\/tr>
108<\/td>28<\/td>2<\/td>szeregowa<\/td><\/tr>
109<\/td>28<\/td>3<\/td>wolnostoj\u0105ca<\/td><\/tr>
110<\/td>28<\/td>4<\/td>wielorodzinna niska<\/td><\/tr>
111<\/td>28<\/td>5<\/td>wielorodzinna wysoka<\/td><\/tr>
112<\/td>29<\/td>1<\/td>w\u0142asno\u015b\u0107<\/td><\/tr>
113<\/td>29<\/td>2<\/td>prawo do budynku jednorodz. w SM<\/td><\/tr>
114<\/td>30<\/td>1<\/td>w\u0142asno\u015b\u0107<\/td><\/tr>
115<\/td>30<\/td>2<\/td>u\u017cytkowanie wieczyste<\/td><\/tr>
116<\/td>10<\/td>6<\/td>szkielet stalowy<\/td><\/tr>
117<\/td>21<\/td>5<\/td>budownictwo wielorodzinne<\/td><\/tr>
118<\/td>11<\/td>3<\/td>surowy zamkni\u0119ty<\/td><\/tr>
119<\/td>31<\/td>1<\/td>A<\/td><\/tr>
120<\/td>31<\/td>2<\/td>B<\/td><\/tr>
123<\/td>31<\/td>3<\/td>C<\/td><\/tr>
125<\/td>33<\/td>1<\/td>(usuni\u0119te)<\/td><\/tr>
127<\/td>33<\/td>2<\/td>stan<\/td><\/tr>
128<\/td>33<\/td>3<\/td>oferta<\/td><\/tr>
130<\/td>34<\/td>1<\/td>nowoczesna galeria<\/td><\/tr>
131<\/td>34<\/td>2<\/td>centrum handlowe<\/td><\/tr>
132<\/td>34<\/td>3<\/td>outlet<\/td><\/tr>
133<\/td>34<\/td>4<\/td>retail park<\/td><\/tr>
135<\/td>34<\/td>5<\/td>lokal us\u0142ugowo-handlowy<\/td><\/tr>
136<\/td>21<\/td>6<\/td>komercyjne<\/td><\/tr>
137<\/td>16<\/td>3<\/td>przyrzeczenie sprzeda\u017cy<\/td><\/tr>
164<\/td>35<\/td>1<\/td>Darowizna<\/td><\/tr>
165<\/td>35<\/td>2<\/td>Inne<\/td><\/tr>
166<\/td>35<\/td>3<\/td>Oferta<\/td><\/tr>
167<\/td>35<\/td>4<\/td>Operat szacunkowy<\/td><\/tr>
168<\/td>35<\/td>5<\/td>Przedwst\u0119pna umowa sprzeda\u017cy rynek pierwotny<\/td><\/tr>
169<\/td>35<\/td>6<\/td>Przedwst\u0119pna umowa sprzeda\u017cy rynek wt\u00f3rny<\/td><\/tr>
170<\/td>35<\/td>7<\/td>Przetarg<\/td><\/tr>
171<\/td>35<\/td>8<\/td>Sprzeda\u017c przez komornika<\/td><\/tr>
172<\/td>35<\/td>9<\/td>Sprzeda\u017c przez syndyka<\/td><\/tr>
173<\/td>35<\/td>10<\/td>Umowa sprzeda\u017cy rynek pierwotny<\/td><\/tr>
174<\/td>35<\/td>11<\/td>Umowa sprzeda\u017cy rynek wt\u00f3rny<\/td><\/tr>
175<\/td>35<\/td>12<\/td>Warto\u015b\u0107 ubezpieczeniowa<\/td><\/tr>
176<\/td>35<\/td>13<\/td>Wycena zabezpieczenia bankowego<\/td><\/tr>
177<\/td>36<\/td>1<\/td>Brak informacji<\/td><\/tr>
178<\/td>36<\/td>2<\/td>Centralna<\/td><\/tr>
179<\/td>36<\/td>3<\/td>Peryferyjna<\/td><\/tr>
180<\/td>36<\/td>4<\/td>Po\u015brednia<\/td><\/tr>
181<\/td>36<\/td>5<\/td>\u015ar\u00f3dmiejska<\/td><\/tr>
182<\/td>35<\/td>14<\/td>Aport do sp\u00f3\u0142ki<\/td><\/tr>
183<\/td>13<\/td>1<\/td>PLN<\/td><\/tr>
184<\/td>13<\/td>2<\/td>EUR<\/td><\/tr>
185<\/td>13<\/td>3<\/td>USD<\/td><\/tr><\/tbody><\/table>\n","protected":false},"excerpt":{"rendered":"

Tabela S\u0142owniki CREATE TABLE [dbo].[slowniki]( [id_slownika] [int] IDENTITY(1,1) NOT NULL, [nazwa] [nvarchar](50) NULL, [tabela] [nvarchar](50) NULL, CONSTRAINT [PK_slowniki] PRIMARY KEY CLUSTERED ( [id_slownika] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO id_slownika Nazwa Tabela 1 NN NULL 2 NN NULL…<\/p>\n

Read more →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2198","post","type-post","status-publish","format-standard","hentry","category-bez-kategorii"],"_links":{"self":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/posts\/2198","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/comments?post=2198"}],"version-history":[{"count":4,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/posts\/2198\/revisions"}],"predecessor-version":[{"id":2202,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/posts\/2198\/revisions\/2202"}],"wp:attachment":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/media?parent=2198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/categories?post=2198"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/tags?post=2198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}