| Table p_merge_field |
|
Description: Fields within a Mail Merge Form |
| PRIMARY KEY | ||
|
p_merge_form_name_c
varchar (16) NOT NULL | Name of Merge Form | p_merge_form |
|
p_merge_field_name_c
varchar (32) NOT NULL | Name of the field in the Word document which will be filled with the data | |
|
p_merge_field_position_i
integer default: 0 | Position to define order of merge fields | |
|
p_merge_type_c
varchar (32) | Type of this field. This defines the parameters which are required to generate the insert | |
|
p_merge_parameters_c
varchar (512) | List of parameters required to create the actual insert | |
|
s_date_created_d
date default: CURRENT_DATE | The date the record was created. | |
|
s_created_by_c
varchar (20) | User ID of who created this record. | s_user |
|
s_date_modified_d
date | The date the record was modified. | |
|
s_modified_by_c
varchar (20) | User ID of who last modified this record. | s_user |
|
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP | This identifies the current version of the record. | |
FOREIGN KEY p_merge_field_fk1: p_merge_form_name_c => p_merge_form p_merge_field_fkcr: s_created_by_c => s_user p_merge_field_fkmd: s_modified_by_c => s_user | ||