Table p_partner_attribute_category
Description:
Holds categories that categorise Partner Attributes Types, thus allowing logical grouping of the latter (e.g. to have all Partner Attributes Types that are to do with phone numbers in one category).
PRIMARY KEY
p_category_code_c
varchar (60) NOT NULL
Code for Partner Attribute Category. Use plural words/phrases (e.g. 'Phone Numbers' and not 'Phone Number')

p_category_desc_c
varchar (200) NOT NULL
Description for Partner Attribute Category.
p_index_i
integer default: 0 NOT NULL
Allows for manual ordering of Partner Attribute Categories by the user (e.g. list Partner Attribute Types for 'phone numbers' first, then list all for 'mobile numbers').
p_partner_contact_category_l
boolean NOT NULL
Flag to indicate whether Partner Attribute Types that are linked to this Partner Attribute Category are 'Partner Contact Detail' Attributes or not.
p_system_category_l
boolean default: '0' NOT NULL
Flag to indicate whether this Partner Attribute Category is one that is internally used by OpenPetra. Records that have this Flag set will be hidden from the user altogether (and so will p_partner_attribute records that are linked to such a Category through a p_partner_attribute_type!!!).
p_deletable_l
boolean default: '0' NOT NULL
Flag to indicate whether this Partner Attribute Category is deletable by a user or not. Should be set to be true for records where p_system_category_l is true.
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_category_fkcr: s_created_by_c => s_user
p_partner_attribute_category_fkmd: s_modified_by_c => s_user


REFERENCED BY
p_partner_attribute_type