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

Z Motława
Linia 41: Linia 41:
  
 
''Tabela sys_fld_validator_po''
 
''Tabela sys_fld_validator_po''
−
+------------------------+--------------+------+-----+---------+----------------+
+
{| class="prettytable" cellspacing=0 style="border: 1px solid #888888; border-collapse: collapse; padding: 5px;" 
−
| Field                 | Type         | Null | Key | Default | Extra          |
+
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Field
−
+------------------------+--------------+------+-----+---------+----------------+
+
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Type
−
| idn                   | int(11)     | NO   | PRI | NULL   | auto_increment |
+
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Null
−
| GUID                   | varchar(38) | NO   | UNI |         |               |
+
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Key
−
| GUID_NG                | varchar(38) | NO   | MUL |         |               |
+
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Default
 +
 
 +
|-
 +
| style="border: 1px solid #888888; "| idn
 +
| style="border: 1px solid #888888; "| int(11)
 +
| style="border: 1px solid #888888; "| NO
 +
| style="border: 1px solid #888888; "| PRI
 +
| style="border: 1px solid #888888; "| NULL
 +
 
 +
|-
 +
| style="border: 1px solid #888888; "| [[GUID]]
 +
| style="border: 1px solid #888888; "| varchar(38)
 +
| style="border: 1px solid #888888; "| NO
 +
| style="border: 1px solid #888888; "| UNI
 +
| style="border: 1px solid #888888; "|  
 +
|-
 +
| style="border: 1px solid #888888; "| GUIDNG
 +
| 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; "| fieldname
 +
| style="border: 1px solid #888888; "| varchar(38)
 +
| style="border: 1px solid #888888; "| NO
 +
| style="border: 1px solid #888888; "|
 +
| 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; "|
 +
 
 +
 
 +
|}
 +
 
 
| fieldname              | varchar(38)  | NO  |    |        |                |
 
| fieldname              | varchar(38)  | NO  |    |        |                |
 
| rule_order            | int(11)      | NO  |    | 0      |                |
 
| rule_order            | int(11)      | NO  |    | 0      |                |

Wersja z 10:11, 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
idn int(11) NO PRI NULL
GUID varchar(38) NO UNI
GUIDNG varchar(38) NO MUL
fieldname varchar(38) NO
rule_operator int(11) NO


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