Code: Definicja regul pol obowiazkowych: Różnice pomiędzy wersjami
| Linia 6: | Linia 6: | ||
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Field | ! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Field | ||
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Type | ! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Type | ||
| + | ! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Null | ||
| + | ! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Key | ||
| + | ! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Default | ||
| + | |||
|- | |- | ||
| 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; "| PRI | ||
| + | | style="border: 1px solid #888888; "| NULL | ||
| + | |||
|- | |- | ||
| style="border: 1px solid #888888; "| [[GUID]] | | style="border: 1px solid #888888; "| [[GUID]] | ||
Wersja z 09:59, 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) |
+---------------+-------------+------+-----+---------+----------------+
| 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 | |
+------------------------+--------------+------+-----+---------+----------------+
