Table p_partner_attribute_type |
Description: Holds various Partner Attribute Types. |
PRIMARY KEY | ||
p_attribute_type_c
varchar (60) NOT NULL | Attribute Type. This can be anything really: Phone Number, Mobile Number, Email Address, etc (not limited to Partner Contact Details, though). Use singular words/phrases (e.g. 'Phone Number' and not 'Phone Numbers'). | |
p_category_code_c
varchar (60) NOT NULL | Category of the Partner Attribute Type. | p_partner_attribute_category |
p_description_c
varchar (100) NOT NULL | Description of what this Partner Attribute Type is all about. | |
p_index_i
integer default: 0 NOT NULL | Allows for manual ordering of Partner Attribute Types by the user (e.g. to list all Partner Attributes that have a Partner Attribute Type of 'phone number' *grouped together* first, then list all that have a Partner Attribute Type of 'assistant phone number' *grouped together*). | |
p_attribute_type_value_kind_c
varchar (80) NOT NULL | Describes the kind (type) of Value that the Partner Attributes that are linked to this Partner Attribute Type are. Valid values for Contact Detail Attributes: 'CONTACTDETAIL_GENERAL', 'CONTACTDETAIL_HYPERLINK', 'CONTACTDETAIL_HYPERLINK_WITHVALUE', 'CONTACTDETAIL_EMAILADDRESS', 'CONTACTDETAIL_SKYPEID'. | |
p_hyperlink_format_c
varchar (120) | For use with p_attribute_type_value_kind_c 'CONTACTDETAIL_HYPERLINK_WITHVALUE' only. Specifies how to 'construct' a hyperlink where the Value of a Partner Attribute is part of the URL. | |
p_special_label_c
varchar (100) | Label that should be displayed/printed instead of p_code_c if a Partner Attribute's 'specialised' Flag is set. | |
p_unassignable_l
boolean default: '0' NOT NULL | Can this Partner Attribute Type be assigned? | |
p_unassignable_date_d
date | This is the date where the record was set to unassignable. | |
p_deletable_l
boolean default: '0' NOT NULL | Flag to indicate whether this Partner Attribute Type is deletable by a user or not. | |
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_partner_attribute_type_fk1: p_category_code_c => p_partner_attribute_category p_partner_attribute_type_fkcr: s_created_by_c => s_user p_partner_attribute_type_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY p_partner_attribute | ||