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 | + | ! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Field |
− | + | ! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Type | |
− | | idn | + | ! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Null |
− | | GUID | + | ! 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; "| 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 | | +------------------------+--------------+------+-----+---------+----------------+