Code: Definicja regul pol obowiazkowych: Różnice pomiędzy wersjami
Z Motława
| Linia 11: | Linia 11: | ||
|- | |- | ||
| − | | style="border: 1px solid #888888; "| idn | + | | style="border: 1px solid #888888; "| [[idn]] |
| style="border: 1px solid #888888; "| int(11) | | style="border: 1px solid #888888; "| int(11) | ||
| style="border: 1px solid #888888; "| NO | | style="border: 1px solid #888888; "| NO | ||
| Linia 49: | Linia 49: | ||
! style="text-align:left; border: 1px solid #888888; background: #eeeeee;" | Extra | ! style="text-align:left; border: 1px solid #888888; background: #eeeeee;" | Extra | ||
|- | |- | ||
| − | | style="text-align:left; border: 1px solid #888888;" | idn | + | | style="text-align:left; border: 1px solid #888888;" | [[idn]] |
| style="text-align:left; border: 1px solid #888888;" | int(11) | | style="text-align:left; border: 1px solid #888888;" | int(11) | ||
| style="text-align:left; border: 1px solid #888888;" | NO | | style="text-align:left; border: 1px solid #888888;" | NO | ||
| Linia 56: | Linia 56: | ||
| style="text-align:left; border: 1px solid #888888;" | auto_increment | | style="text-align:left; border: 1px solid #888888;" | auto_increment | ||
|- | |- | ||
| − | | style="text-align:left; border: 1px solid #888888;" | GUID | + | | style="text-align:left; border: 1px solid #888888;" | [[GUID]] |
| style="text-align:left; border: 1px solid #888888;" | varchar(38) | | style="text-align:left; border: 1px solid #888888;" | varchar(38) | ||
| style="text-align:left; border: 1px solid #888888;" | NO | | style="text-align:left; border: 1px solid #888888;" | NO | ||
Wersja z 10:31, 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 |
