Code: Definicja regul pol obowiazkowych: Różnice pomiędzy wersjami

Z Motława
Linia 4: Linia 4:
  
 
{| class="prettytable" cellspacing=0 style="border: 1px solid #888888; border-collapse: collapse; padding: 5px;"   
 
{| class="prettytable" cellspacing=0 style="border: 1px solid #888888; border-collapse: collapse; padding: 5px;"   
−
! style="text-align:right; border: 1px solid #888888;" | Field
+
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Field
−
! style="text-align:right; border: 1px solid #888888;" | Type
+
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Type
 
|-
 
|-
−
| style="border: 1px solid #888888; background: #eeeeee;"| idn
+
| style="border: 1px solid #888888; "| idn
−
| style="border: 1px solid #888888; background: #eeeeee;"| int(11)
+
| style="border: 1px solid #888888; "| int(11)
 
|-
 
|-
−
| style="border: 1px solid #888888; background: #eeeeee;"| [[GUID]]
+
| style="border: 1px solid #888888; "| [[GUID]]
−
| style="border: 1px solid #888888; background: #eeeeee;"| varchar(38)
+
| style="border: 1px solid #888888; "| varchar(38)
  
 
|}
 
|}

Wersja z 09:57, 20 mar 2009

Algorytm walidacji pól

Tabela sys_fld_validator_ng

Field Type
idn int(11)
GUID varchar(38)


+---------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+----------------+ | idn | int(11) | NO | PRI | NULL | auto_increment | | GUID | varchar(38) | NO | UNI | | | | coreid | varchar(38) | NO | MUL | | | | rule_operator | int(11) | NO | | 0 | | +---------------+-------------+------+-----+---------+----------------+


Tabela sys_fld_validator_po +------------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------------+--------------+------+-----+---------+----------------+ | idn | int(11) | NO | PRI | NULL | auto_increment | | GUID | varchar(38) | NO | UNI | | | | GUID_NG | varchar(38) | NO | MUL | | | | fieldname | varchar(38) | NO | | | | | rule_order | int(11) | NO | | 0 | | | admin | int(11) | NO | | 0 | | | validation_rule_type | varchar(20) | YES | | NULL | | | validation_rule | varchar(200) | YES | | NULL | | | condition_ruleset_guid | varchar(38) | NO | MUL | | | | message_if_not_valid | text | YES | | NULL | | +------------------------+--------------+------+-----+---------+----------------+

Źródło „https://wiki.int.com.pl/index.php?title=Code:_Definicja_regul_pol_obowiazkowych&oldid=2979”