TRIPsystem Kernel API 8.3
|
Database integrity rule definition for a field. More...
#include <tripapi_types.h>
Public Attributes | |
char * | key_field |
char * | link_database |
char * | link_field |
int | on_delete |
int | on_update |
int | type |
Database integrity rule definition for a field.
The on_delete
and on_update
values can have the following values:
Symbol | Value | Description |
---|---|---|
INTEGRITY_RESTRICT | 1 | Prohibit the action as long as there are dependent records |
INTEGRITY_CASCADE | 2 | For on_update , update also the dependent record. For on_delete , delete also dependent record. |
INTEGRITY_NOACTION | 3 | Allow the operation to proceed |
INTEGRITY_SETNULL | 4 | Set the dependent record's field to NULL |
INTEGRITY_SETDEFAULT | 5 | Set the dependent record's field to its defaut value |
char* integrity_rule::key_field |
Field name in dependent database
char* integrity_rule::link_database |
Master database
char* integrity_rule::link_field |
Field in master database
int integrity_rule::on_delete |
Behavior when master records are deleted
int integrity_rule::on_update |
Behavior when master records are updated
int integrity_rule::type |
0 for source of link, 1 for target of link