Pom11: Porovnání verzí

Z Prirucky
Řádek 1: Řádek 1:
<small>
* select * from workfl_master;
* select * from workfl_faze;
* select * from workfl_stavy;
* select * from workfl_hl;
* select * from workfl_body;
* select * from workfl_proc;
* select * from prtl_porizovak;
* select * from workfl_sluz_cesty;
</small>
{|border="1" cellpadding="3" cellspacing="0"
{|border="1" cellpadding="3" cellspacing="0"
|+ <small> workfl_master </small>
|+ <small> workfl_master </small>
Řádek 50: Řádek 62:
|-
|-
|..||80||1||2014-08-27||2014-08-28||...
|..||80||1||2014-08-27||2014-08-28||...
|}
{|border="1" cellpadding="3" cellspacing="0"
|+ <small> workfl_proc </small>
|-
|'''id'''
|'''id_poz'''
|'''poradi'''
|'''stav'''
|'''sys_stav'''
|'''faze'''
|'''resitel'''
|'''duvod'''
|'''adresat'''
|'''datum'''
|'''cas'''
|'''zapsal'''
|'''...'''
|-
|123||80||1||novy||n||1||1||||||||||||...
|-
|127||80||2||schvaleny||o||2||1||||||||||||...
|}
|}

Verze z 8. 9. 2014, 10:01

  • select * from workfl_master;
  • select * from workfl_faze;
  • select * from workfl_stavy;
  • select * from workfl_hl;
  • select * from workfl_body;
  • select * from workfl_proc;
  • select * from prtl_porizovak;
  • select * from workfl_sluz_cesty;


workfl_master
id typ ...
2 dovol ...
workfl_stavy
id_master faze stav syst_stav ...
2 1 novy n ...
2 2 schvaleny o ...
2 2 zamitnuty s ...
workfl_hl
id_poz os_cislo typ id_master ...
80 11 dovol 2 ...
workfl_body
id id_poz verze datum_od datum_do ...
.. 80 1 2014-08-27 2014-08-28 ...
workfl_proc
id id_poz poradi stav sys_stav faze resitel duvod adresat datum cas zapsal ...
123 80 1 novy n 1 1 ...
127 80 2 schvaleny o 2 1 ...
Citováno z „http://prirucky.ksprogram.cz/index.php?title=Pom11&oldid=19542“