Table s_volume_partner_group_partner |
Description: Assign Partners to a Group for use in Default Volumes |
PRIMARY KEY | ||
s_group_name_c
varchar (60) NOT NULL | Group Name this default volume applies to | s_volume_partner_group |
p_partner_key_n
bigint NOT NULL | Partner key (one partner can be in several groups) | p_partner |
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 s_volume_partner_group_partner_fkcr: s_created_by_c => s_user s_volume_partner_group_partner_fkmd: s_modified_by_c => s_user s_volume_partner_group_ptn_fk1: s_group_name_c => s_volume_partner_group s_volume_partner_group_ptn_fk2: p_partner_key_n => p_partner |