Code: Definicja regul pol obowiazkowych
Z Motława
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 | | +------------------------+--------------+------+-----+---------+----------------+
