| 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  | ||