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

Z Motława
Linia 22: Linia 22:
 
| style="border: 1px solid #888888; "| NO
 
| style="border: 1px solid #888888; "| NO
 
| style="border: 1px solid #888888; "| UNI
 
| style="border: 1px solid #888888; "| UNI
 +
| style="border: 1px solid #888888; "|
 +
|-
 +
| style="border: 1px solid #888888; "| [[coreid]]
 +
| style="border: 1px solid #888888; "| varchar(38)
 +
| style="border: 1px solid #888888; "| NO
 +
| style="border: 1px solid #888888; "| MUL
 +
| style="border: 1px solid #888888; "|
 +
|-
 +
| style="border: 1px solid #888888; "| rule_operator
 +
| style="border: 1px solid #888888; "| int(11)
 +
| style="border: 1px solid #888888; "| NO
 +
| style="border: 1px solid #888888; "|
 
| style="border: 1px solid #888888; "|  
 
| style="border: 1px solid #888888; "|  
 +
  
 
|}
 
|}
−
 
−
 
−
+---------------+-------------+------+-----+---------+----------------+
 
−
| 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      |                |
 
−
+---------------+-------------+------+-----+---------+----------------+
 
  
  

Wersja z 10:02, 20 mar 2009

Algorytm walidacji pól

Tabela sys_fld_validator_ng

Field Type Null Key Default
idn int(11) NO PRI NULL
GUID varchar(38) NO UNI
coreid varchar(38) NO MUL
rule_operator int(11) NO



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=2985”