TRIPsystem Kernel API 8.3
Loading...
Searching...
No Matches
integrity_rule Struct Reference

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
 

Detailed Description

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

Member Data Documentation

◆ key_field

char* integrity_rule::key_field

Field name in dependent database

◆ link_database

char* integrity_rule::link_database

Master database

◆ link_field

char* integrity_rule::link_field

Field in master database

◆ on_delete

int integrity_rule::on_delete

Behavior when master records are deleted

◆ on_update

int integrity_rule::on_update

Behavior when master records are updated

◆ type

int integrity_rule::type

0 for source of link, 1 for target of link


The documentation for this struct was generated from the following file: