Code: Definicja regul pol obowiazkowych: Różnice pomiędzy wersjami
Linia 20: | Linia 20: | ||
| style="border: 1px solid #888888; "| [[GUID]] | | style="border: 1px solid #888888; "| [[GUID]] | ||
| style="border: 1px solid #888888; "| varchar(38) | | style="border: 1px solid #888888; "| varchar(38) | ||
+ | | style="border: 1px solid #888888; "| NO | ||
+ | | style="border: 1px solid #888888; "| UNI | ||
+ | | style="border: 1px solid #888888; "| | ||
|} | |} |
Wersja z 10:00, 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 |
+---------------+-------------+------+-----+---------+----------------+
| 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 | |
+------------------------+--------------+------+-----+---------+----------------+