# Baza danych: ff8celab - FINN 8 SQL CELAB

Język: pl

Adnotacje techniczne:

Copyright (C) 2007 LTC Sp. z o.o. Wszelkie prawa zastrzeżone.

Copyright (C) 2007 FINN Sp. z o.o. Wszelkie prawa zastrzeżone.

## Spis pakietów

Lp | Nazwa pakietu | Tytuł / wersja | Typy | Menu | Tabele | Widoki | Funkcje
--- | --- | --- | --- | --- | --- | --- | ---
1 | common | Komponenty uniwersalne $Id: ff8-p-common.fdm 14346 2009-04-24 12:08:31Z rjaros $ | 47 | 16 | 7 | 0 | 74
2 | wzorce | Tabele wzorcowe autora $Id: ff8-p-wzorce.fdm 13672 2009-02-23 10:41:17Z egajowniczek $ | 0 | 0 | 5 | 0 | 3
3 | slow1 | Słowniki ogólnosystemowe 1 $Id: ff8-p-slow1.fdm 12613 2008-12-12 13:25:00Z rpaciorek $ | 0 | 0 | 16 | 0 | 0
4 | slow2 | Słowniki ogólnosystemowe 2 $Id: ff8-p-slow2.fdm 6140 2007-07-22 18:52:55Z psztoch $ | 0 | 0 | 6 | 0 | 0
5 | system | Tabele ogólnosystemowe $Id: ff8-p-system.fdm 14346 2009-04-24 12:08:31Z rjaros $ | 0 | 0 | 23 | 0 | 9
6 | mprac | Kartoteka personelu, osób współpracujących $Id: ff8-p-mprac.fdm 14346 2009-04-24 12:08:31Z rjaros $ | 0 | 0 | 16 | 0 | 12
7 | mknt | Kartoteka kontrahentów, adresów oraz pochodne $Id: ff8-p-mknt.fdm 14346 2009-04-24 12:08:31Z rjaros $ | 0 | 0 | 11 | 0 | 13
8 | mtowar | Kartoteka towarów i usług oraz pochodne $Id: ff8-p-mtowar.fdm 14361 2009-04-27 06:45:25Z afrymarkiewicz $ | 0 | 0 | 28 | 2 | 0
9 | grej | Struktura organizacyjna, rejestry $Id: ff8-p-grej.fdm 14346 2009-04-24 12:08:31Z rjaros $ | 1 | 0 | 16 | 2 | 62
10 | pfe | Platforma Formularzy Elektronicznych $Id: ff8-p-pfe.fdm 11266 2008-09-21 10:20:07Z psztoch $ | 0 | 0 | 2 | 0 | 2
11 | eod | Elektroniczny Obieg Dokumentów $Id: ff8-p-eod.fdm 14346 2009-04-24 12:08:31Z rjaros $ | 3 | 0 | 35 | 0 | 41
12 | eod_cs | Rozszerzenie EOD dla Klient/Serwer. $Id: ff8-p-eod_cs.fdm 7451 2007-10-23 09:10:32Z egajowniczek $ | 0 | 0 | 6 | 0 | 2
13 | galarm | Terminy, notatki $Id: ff8-p-galarm.fdm 14346 2009-04-24 12:08:31Z rjaros $ | 0 | 0 | 1 | 0 | 2
14 | lms | Learning Management System (LMS) $Id: ff8-p-lms.fdm 14346 2009-04-24 12:08:31Z rjaros $ | 0 | 0 | 22 | 0 | 2
15 | ltc | Wewnętrzne tabele autora $Id: ff8-p-ltc.fdm 7367 2007-10-15 13:49:58Z rpaciorek $ | 0 | 0 | 3 | 0 | 1
16 | mrap | Raporty definiowane $Id: ff8-p-mrap.fdm 14454 2009-05-04 23:53:02Z afrymarkiewicz $ | 1 | 0 | 5 | 0 | 0
17 | mmaj | Ewidencja składników majątkowych (ESM) $Id: ff8-p-mmaj.fdm 11447 2008-10-14 06:38:53Z mkrawetek $ | 0 | 0 | 4 | 0 | 3
18 | mroz | Rozrachunki, system płatności $Id: ff8-p-mroz.fdm 11887 2008-11-18 11:00:58Z rpaciorek $ | 1 | 0 | 13 | 0 | 22
19 | rach | Księgowość $Id: ff8-p-rach.fdm 7380 2007-10-17 09:40:46Z rpaciorek $ | 2 | 0 | 20 | 0 | 28
20 | wf | Workflow $Id: ff8-p-wf.fdm 14346 2009-04-24 12:08:31Z rjaros $ | 6 | 0 | 13 | 0 | 43
21 | plr | Język statystyczny plR $Id: ff8-p-plr.fdm 6140 2007-07-22 18:52:55Z psztoch $ | 0 | 0 | 0 | 0 | 6
22 | celab | System CELAB $Id: ff8-p-celab.fdm 15783 2009-09-21 20:30:41Z afrymarkiewicz $ | 0 | 0 | 46 | 0 | 37
23 | deprecated | Wycofane z użycia $Id: ff8-p-deprecated.fdm 7380 2007-10-17 09:40:46Z rpaciorek $ | 0 | 0 | 9 | 0 | 0
24 | celab-update | Komponenty aktualizacji $Id: ff8-d-celab.fdm 6987 2007-09-15 22:28:42Z rjaros $ | 0 | 0 | 0 | 0 | 1
|  | Baza danych $Id: ff8-d-celab.fdm 6987 2007-09-15 22:28:42Z rjaros $ | 61 | 16 | 307 | 4 | 363

## Replikacje

### Algorytm replikacji

Lp | Poziom | Tabela | Zapętlone relacje
--- | --- | --- | ---
1 | 1 | dummy |
2 | 1 | pbcatcol |
3 | 1 | pbcatedt |
4 | 1 | pbcatfmt |
5 | 1 | pbcattbl |
6 | 1 | pbcatvld |
7 | 1 | stemp |
8 | 1 | samenu1 |
9 | 1 | saslow1 |
10 | 1 | sdb1_option |
11 | 1 | sdb1_zabezp |
12 | 1 | supr1 |
13 | 1 | mbank1 |
14 | 1 | mcena1 |
15 | 1 | mdfisk1 |
16 | 1 | mslow1 |
17 | 1 | mslow2 |
18 | 1 | sdniw1 |
19 | 1 | sgus |
20 | 1 | skraje |
21 | 1 | spoczta1 |
22 | 1 | steryt_k |
23 | 1 | steryt_rm |
24 | 1 | steryt_g |
25 | 1 | steryt_ul |
26 | 1 | steryt_p |
27 | 1 | mwaluta1 |
28 | 1 | mwaluta2 |
29 | 1 | sekd0 |
30 | 1 | sekd1 |
31 | 1 | svat1 |
32 | 1 | clok1 |
33 | 1 | cimport1 |
34 | 1 | mlog1 |
35 | 1 | mlog2 |
36 | 1 | mlog3 |
37 | 1 | sapp1_option |
38 | 1 | sapp1_pref |
39 | 1 | sapp1_pref2 |
40 | 1 | sdf1 |
41 | 1 | sdost2 |
42 | 1 | sdpar1 |
43 | 1 | shist1 |
44 | 1 | skosz1 |
45 | 1 | slic1 |
46 | 1 | susr1_user |
47 | 1 | szakr1 |
48 | 1 | mecp_rej |
49 | 1 | mecp_rodz |
50 | 1 | mprac_klas1 |
51 | 1 | mprac_klas2 |
52 | 1 | mprac_klas3 |
53 | 1 | mknt_klas1 |
54 | 1 | mknt_klas2 |
55 | 1 | mknt_klas3 |
56 | 1 | mekp1 |
57 | 1 | mklas1 |
58 | 1 | mklas2 |
59 | 1 | mklas3 |
60 | 1 | mmultityp |
61 | 1 | mzest_klas1 |
62 | 1 | mzest_klas2 |
63 | 1 | mzest_klas3 |
64 | 1 | grep1 |
65 | 1 | grep2 |
66 | 1 | grwa1 |
67 | 1 | grwa2 |
68 | 1 | graport1 |
69 | 1 | mtyp1 |
70 | 1 | sdadr1 |
71 | 1 | sdadr_klas3 |
72 | 1 | pformr1 |
73 | 1 | bklas1 |
74 | 1 | gproc2_temp |
75 | 1 | gproc3_temp |
76 | 1 | gprocrodz |
77 | 1 | gtyp1 |
78 | 1 | srap1 |
79 | 1 | srap_klas2 |
80 | 1 | egrupy |
81 | 1 | ekurs1grupy |
82 | 1 | modset1 |
83 | 1 | mpodp1 |
84 | 1 | mpodp2 |
85 | 1 | rokres1 |
86 | 1 | rzad1 |
87 | 1 | wfdproc1 |
88 | 1 | cinfo1 |
89 | 1 | ckosz1 |
90 | 1 | craport1 |
91 | 1 | cstado1 |
92 | 1 | cteren1 |
93 | 1 | cteren2 |
94 | 1 | cwymag1 |
95 | 1 | msymbol1 |
96 | 1 | mikom_klas3 |
97 | 2 | steryt_m |
98 | 2 | mwaluta3 |
99 | 2 | shist2 |
100 | 2 | susr1_klas |
101 | 2 | susr1_option |
102 | 2 | susr1_pref |
103 | 2 | susr1_password |
104 | 2 | susr1_cert |
105 | 2 | susr1_zabezp |
106 | 2 | mprac1 |
107 | 2 | mekp2 |
108 | 2 | mekp3 |
109 | 2 | mmulti2 |
110 | 2 | mmulti3 |
111 | 2 | mzest1 |
112 | 2 | mzest_multi3 |
113 | 2 | grep3 |
114 | 2 | sdadr3 |
115 | 2 | srap2 |
116 | 2 | srap4 |
117 | 2 | modset2 |
118 | 2 | rksieg1 |
119 | 2 | rokres2 |
120 | 2 | rplan1 |
121 | 2 | wfdproc2 |
122 | 2 | cslow1 |
123 | 2 | cteren3 |
124 | 2 | msymbol2 |
125 | 3 | steryt_mul |
126 | 3 | mecp1 |
127 | 3 | mecp2 |
128 | 3 | mecp3 |
129 | 3 | mprac2 |
130 | 3 | mprac3 |
131 | 3 | mprac4 |
132 | 3 | mprac5 |
133 | 3 | mprac6 |
134 | 3 | mknt1 |
135 | 3 | mmagazyn1 |
136 | 3 | mzest2 |
137 | 3 | mzest3 |
138 | 3 | mzest5 |
139 | 3 | mzest6 |
140 | 3 | grej1 |
141 | 3 | gproc1 |
142 | 3 | elog1 |
143 | 3 | kkurs1 |
144 | 3 | eulubione |
145 | 3 | mdefekt1 |
146 | 3 | rksieg2 |
147 | 3 | wfdproc3 |
148 | 3 | wfiproc2 |
149 | 3 | cpole1 |
150 | 3 | cslow2 |
151 | 3 | cteren4 |
152 | 3 | msymbol3 |
153 | 3 | msymbol4 |
154 | 3 | msymbol5 |
155 | 3 | mikom1 |
156 | 4 | mecp4 |
157 | 4 | mknt2 |
158 | 4 | mknt3 |
159 | 4 | mknt4 |
160 | 4 | mknt5 |
161 | 4 | mknt6 |
162 | 4 | mknt7 |
163 | 4 | mknt8 |
164 | 4 | mtowar1 |
165 | 4 | gkom2 |
166 | 4 | grej1_p |
167 | 4 | grej3 |
168 | 4 | grej6 |
169 | 4 | gtemplate1 |
170 | 4 | pformd1 |
171 | 4 | garch1 |
172 | 4 | gpoczta1 |
173 | 4 | gproc2 |
174 | 4 | gproc3 |
175 | 4 | gproc4 |
176 | 4 | gsprawa1 |
177 | 4 | srap1_grej1 |
178 | 4 | eklasa1 |
179 | 4 | ekurs1 |
180 | 4 | kklasa1 |
181 | 4 | kkurs4 |
182 | 4 | kkurs5 |
183 | 4 | mdefekt2 |
184 | 4 | mlic1 |
185 | 4 | mrap1 |
186 | 4 | mmaj1 |
187 | 4 | mprzel1 |
188 | 4 | rgrupa1 |
189 | 4 | rplan3 |
190 | 4 | rrap1 |
191 | 4 | rwzor1 |
192 | 4 | rzpk1 |
193 | 4 | wfdproc4 |
194 | 4 | wfdproc5 |
195 | 4 | wfiproc3 |
196 | 4 | wfiproc7 |
197 | 4 | ckierunek1 |
198 | 4 | cmetoda1 |
199 | 4 | cprobka2 |
200 | 4 | cslow3 |
201 | 4 | ctemplate1 |
202 | 4 | cteren5 |
203 | 4 | mikom2 |
204 | 4 | mikom3 |
205 | 5 | mecp5 |
206 | 5 | mtowar2 |
207 | 5 | mtowar3 |
208 | 5 | mtowar4 |
209 | 5 | mtowar5 |
210 | 5 | mtowar6 |
211 | 5 | mtowar8 |
212 | 5 | mzest4 |
213 | 5 | garch2 |
214 | 5 | gkon1 |
215 | 5 | gpeup1 |
216 | 5 | gsprawa1_grej1_p |
217 | 5 | gsprawa2 |
218 | 5 | gsprawa4 |
219 | 5 | gsprawa6 |
220 | 5 | eklasa2 |
221 | 5 | ekurs4 |
222 | 5 | ekurs5 |
223 | 5 | elekcja1 |
224 | 5 | kklasa2 |
225 | 5 | kkurs6 |
226 | 5 | klekcja1 |
227 | 5 | mrap2 |
228 | 5 | mrap3 |
229 | 5 | mmajhist1 |
230 | 5 | mmajkont1 |
231 | 5 | mmajodp1 |
232 | 5 | rdok1 |
233 | 5 | rgrupa2 |
234 | 5 | rrap2 |
235 | 5 | rwzor2 |
236 | 5 | rzpk2 |
237 | 5 | wfdproc6 |
238 | 5 | wfdproc7 |
239 | 5 | wfiproc4 |
240 | 5 | ckarta1 |
241 | 5 | ckierunek2 |
242 | 5 | cmetoda1_p |
243 | 5 | cmetoda2 |
244 | 5 | cmetoda3 |
245 | 5 | cplan1 |
246 | 5 | cteren6 |
247 | 5 | ctowar1 |
248 | 6 | mtowar7 |
249 | 6 | garch3 |
250 | 6 | garch4 |
251 | 6 | gkon1_grej1_p |
252 | 6 | gkon2 |
253 | 6 | gkon4 |
254 | 6 | gkon5 |
255 | 6 | grej2 |
256 | 6 | gsprawa5 |
257 | 6 | ekurs6 |
258 | 6 | elekcja2 |
259 | 6 | elekcja3 |
260 | 6 | klekcja2 |
261 | 6 | klekcja3 |
262 | 6 | mrap5 |
263 | 6 | rwzor3 |
264 | 6 | ctowar2 |
265 | 7 | gpoczta2 |
266 | 7 | gpoplata1 |
267 | 7 | grej2_grej1_p |
268 | 7 | grej4 |
269 | 7 | grej5 |
270 | 7 | grej7 |
271 | 7 | gsprawa3 |
272 | 7 | gkon3 |
273 | 7 | galarm1 |
274 | 7 | mrap4 |
275 | 7 | mkbz1 |
276 | 7 | mzam1 |
277 | 7 | rplan2 |
278 | 7 | wfiproc5 |
279 | 7 | wfiproc8 |
280 | 7 | cpozyw1 |
281 | 7 | cpozyw1kontr1 |
282 | 8 | gpoczta3 |
283 | 8 | gharm1 |
284 | 8 | mroz1 |
285 | 8 | mvat1 |
286 | 8 | mzam2 |
287 | 8 | mzam3 |
288 | 8 | czlec1 |
289 | 9 | mvat2 |
290 | 9 | rdok2 |
291 | 9 | cgrupa1 |
292 | 9 | cokladka1 |
293 | 9 | czlec1_cpole1 |
294 | 9 | czlec2 |
295 | 10 | rdok3 |
296 | 10 | cgrupa2 |
297 | 10 | cgrupa3 |
298 | 10 | cgrupa4 |
299 | 10 | cgrupa5 |
300 | 10 | cprobka1 |
301 | 10 | cspraw1 |
302 | 11 | cbad1 |
303 | 11 | cokladka2 |
304 | 11 | cprobka1_cpole1 |
305 | 12 | cbad1_cmetoda1 |
306 | 12 | cbad2 |
307 | 12 | cspraw2 |
| 13 | Rozpisano wszystkie relacje

### Pola (relacje) do opóźnionej replikacji

Lp | Pakiet | Tabela pierwotna | Kolumna pierwotna | Nazwa klucza | Tabela obca | Kolumna obca
--- | --- | --- | --- | --- | --- | ---
1 | grej | grej1 | fakt_sym | grej1_fakt_sym_fkey | grej1 | dok_sym
2 | grej | grej1 | rodzic | grej1_rodzic_fkey | grej1 | grej1_id
3 | grej | grep2 | aktwer_id | grep2_aktwer_id_fkey | grep3 | grep3_id
4 | grej | grep3 | rodzic_id | grep3_rodzic_id_fkey | grep3 | grep3_id
5 | pfe | pformd1 | rodzic_id | pformd1_rodzic_id_fkey | pformd1 | pformd1_id
6 | eod | grej2 | spr_nr | grej2_spr_nr_fkey | gsprawa1 | spr_nr
7 | eod | gsprawa1 | umowa_nr | gsprawa1_umowa_nr_fkey | grej2 | dok_nr
8 | eod | gsprawa1 | spr_nad_id | gsprawa1_spr_nad_id_fkey | gsprawa1 | gsprawa1_id
9 | mroz | mroz1 | rozlicz_id | mroz1_rozlicz_id_fkey | mroz1 | mroz1_id
10 | mroz | mzam3 | dostawa | mzam3_dostawa_fkey | mzam3 | mzam3_id
11 | wf | wfiproc2 | start_id | wfiproc2_start_id_fkey | wfiproc2 | wfiproc2_id
12 | wf | wfiproc2 | podp_id | wfiproc2_podp_id_fkey | wfiproc2 | wfiproc2_id
13 | celab | ckierunek1 | kierunek_cbd | ckierunek1_kierunek_cbd_fkey | ckierunek1 | ckierunek1_id

Dokument wygenerowany 2009-09-28 04:34:11