Code: Definicja regul pol obowiazkowych: Różnice pomiędzy wersjami

Z Motława
Linia 42: Linia 42:
 
''Tabela sys_fld_validator_po''
 
''Tabela sys_fld_validator_po''
 
{| class="prettytable" cellspacing=0 style="border: 1px solid #888888; border-collapse: collapse; padding: 5px;"   
 
{| class="prettytable" cellspacing=0 style="border: 1px solid #888888; border-collapse: collapse; padding: 5px;"   
−
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Field
+
! style="text-align:left; border: 1px solid #888888; background: #eeeeee;" | Field
−
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Type
+
! style="text-align:left; border: 1px solid #888888; background: #eeeeee;" | Type
−
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Null
+
! style="text-align:left; border: 1px solid #888888; background: #eeeeee;" | Null
−
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Key
+
! style="text-align:left; border: 1px solid #888888; background: #eeeeee;" | Key
−
! style="text-align:right; border: 1px solid #888888; background: #eeeeee;" | Default
+
! style="text-align:left; border: 1px solid #888888; background: #eeeeee;" | Default
−
 
+
! style="text-align:left; border: 1px solid #888888; background: #eeeeee;" |  Extra 
 
|-
 
|-
−
| style="border: 1px solid #888888; "| idn
+
| style="text-align:left; border: 1px solid #888888;" | idn
−
| style="border: 1px solid #888888; "| int(11)
+
| style="text-align:left; border: 1px solid #888888;" | int(11)
−
| style="border: 1px solid #888888; "| NO
+
| style="text-align:left; border: 1px solid #888888;" | NO
−
| style="border: 1px solid #888888; "| PRI
+
| style="text-align:left; border: 1px solid #888888;" | PRI
−
| style="border: 1px solid #888888; "| NULL
+
| style="text-align:left; border: 1px solid #888888;" | NULL
−
 
+
| style="text-align:left; border: 1px solid #888888;" |  auto_increment 
 
|-
 
|-
−
| style="border: 1px solid #888888; "| [[GUID]]
+
| style="text-align:left; border: 1px solid #888888;" | GUID
−
| style="border: 1px solid #888888; "| varchar(38)
+
| style="text-align:left; border: 1px solid #888888;" | varchar(38)
−
| style="border: 1px solid #888888; "| NO
+
| style="text-align:left; border: 1px solid #888888;" | NO
−
| style="border: 1px solid #888888; "| UNI
+
| style="text-align:left; border: 1px solid #888888;" | UNI
−
| style="border: 1px solid #888888; "|  
+
| style="text-align:left; border: 1px solid #888888;" | 
 +
| style="text-align:left; border: 1px solid #888888;" |  
 
|-
 
|-
−
| style="border: 1px solid #888888; "| GUIDNG
+
| style="text-align:left; border: 1px solid #888888;" | GUID_NG 
−
| style="border: 1px solid #888888; "| varchar(38)
+
| style="text-align:left; border: 1px solid #888888;" | varchar(38)
−
| style="border: 1px solid #888888; "| NO
+
| style="text-align:left; border: 1px solid #888888;" | NO
−
| style="border: 1px solid #888888; "| MUL
+
| style="text-align:left; border: 1px solid #888888;" | MUL
−
| style="border: 1px solid #888888; "|  
+
| style="text-align:left; border: 1px solid #888888;" | 
 +
| style="text-align:left; border: 1px solid #888888;" |  
 
|-
 
|-
−
| style="border: 1px solid #888888; "| fieldname
+
| style="text-align:left; border: 1px solid #888888;" | fieldname
−
| style="border: 1px solid #888888; "| varchar(38)
+
| style="text-align:left; border: 1px solid #888888;" | varchar(38)
−
| style="border: 1px solid #888888; "| NO
+
| style="text-align:left; border: 1px solid #888888;" | NO
−
| style="border: 1px solid #888888; "|  
+
| style="text-align:left; border: 1px solid #888888;" |  
−
| style="border: 1px solid #888888; "|  
+
| style="text-align:left; border: 1px solid #888888;" | 
 +
| style="text-align:left; border: 1px solid #888888;" |  
 
|-
 
|-
−
| style="border: 1px solid #888888; "| rule_operator
+
| style="text-align:left; border: 1px solid #888888;" | rule_order 
−
| style="border: 1px solid #888888; "| int(11)
+
| style="text-align:left; border: 1px solid #888888;" | int(11)
−
| style="border: 1px solid #888888; "| NO
+
| style="text-align:left; border: 1px solid #888888;" | NO
−
| style="border: 1px solid #888888; "|  
+
| style="text-align:left; border: 1px solid #888888;" |  
−
| style="border: 1px solid #888888; "|  
+
| style="text-align:left; border: 1px solid #888888;" | 0 
−
 
+
| style="text-align:left; border: 1px solid #888888;" | 
−
 
+
|-
 +
| style="text-align:left; border: 1px solid #888888;" |  admin 
 +
| 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;" | 
 +
| style="text-align:left; border: 1px solid #888888;" |  0 
 +
| style="text-align:left; border: 1px solid #888888;" | 
 +
|-
 +
| style="text-align:left; border: 1px solid #888888;" |  validation_rule_type 
 +
| style="text-align:left; border: 1px solid #888888;" |  varchar(20) 
 +
| style="text-align:left; border: 1px solid #888888;" |  YES 
 +
| style="text-align:left; border: 1px solid #888888;" | 
 +
| style="text-align:left; border: 1px solid #888888;" |  NULL 
 +
| style="text-align:left; border: 1px solid #888888;" | 
 +
|-
 +
| style="text-align:left; border: 1px solid #888888;" |  validation_rule 
 +
| style="text-align:left; border: 1px solid #888888;" |  varchar(200) 
 +
| style="text-align:left; border: 1px solid #888888;" |  YES 
 +
| style="text-align:left; border: 1px solid #888888;" | 
 +
| style="text-align:left; border: 1px solid #888888;" |  NULL 
 +
| style="text-align:left; border: 1px solid #888888;" | 
 +
|-
 +
| style="text-align:left; border: 1px solid #888888;" |  condition_ruleset_guid 
 +
| 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;" |  MUL 
 +
| style="text-align:left; border: 1px solid #888888;" | 
 +
| style="text-align:left; border: 1px solid #888888;" | 
 +
|-
 +
| style="text-align:left; border: 1px solid #888888;" |  message_if_not_valid 
 +
| style="text-align:left; border: 1px solid #888888;" |  text 
 +
| style="text-align:left; border: 1px solid #888888;" |  YES 
 +
| style="text-align:left; border: 1px solid #888888;" | 
 +
| style="text-align:left; border: 1px solid #888888;" |  NULL 
 +
| style="text-align:left; border: 1px solid #888888;" | 
 
|}
 
|}
−
 
−
| 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    |                |
 
−
+------------------------+--------------+------+-----+---------+----------------+
 

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
Źródło „https://wiki.int.com.pl/index.php?title=Code:_Definicja_regul_pol_obowiazkowych&oldid=2992”