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