Database Tables

Refer to the Oracle Retail Xstore Office Database Dictionary Guide for a complete list of the Oracle Retail Xstore Office database tables.

Table B-3 cfg_landscape

Column	Valid Values	Description
organization_id	int (PK)	Store's organization identifier.
landscape_id	int (PK)	A unique identifier for a landscape.
description	string	A description of the store landscape that is assigned by the user.
comments	string	A comment field for more details.

Table B-4 cfg_landscape_group

Column	Valid Values	Description
organization_id	int(PK)	Store's organization identifier
landscape_id	int(PK)	The unique ID of the landscape that this register range belongs to.
profile_group_id	string(PK)	The profile group ID that this range is assigned to.
profile_group_order	int	Designates the sort order of the groups (profile_group_id) within this landscape. The order affects how the config path is later generated

Table B-5 cfg_landscape_range

Column	Valid Values	Description
organization_id	int (PK)	Store's organization identifier.
landscape_id	int (PK)	The unique ID of the landscape that this register range belongs to.
profile_group_id	string (PK)	The profile group ID that this range is assigned to.
range_seq	int (PK)	The sequence number of the range for the landscape.
profile_element_id	string	The profile element ID that this range is assigned to.
range_start	int	The start of the register range.
range_end	int	The end of the register range (if only one register is in the range, then this will be the same as range_start).

Table B-6 cfg_personality

Column	Valid Values	Description
organization_id	int	Store's organization identifier.
personality_id	int	A unique identifier for a store's personality.
description	string	A description of the personality that is assigned by the user.
comments	string	A comment field for more details.

Table B-7 cfg_personality_element

Column	Valid Values	Description
organization_id	int	Store's organization identifier.
personality_id	int	The unique ID of the personality that this personality profile belongs to.
element_id	varchar(60)	The profile element ID with which this personality is associated.
group_id	varchar(60)	The profile group ID with which this personality is associated.
sort_order	int	The order of elements in the list that will be followed when generating the new configuration path for the store that is assigned to this personality.

Table B-8 cfg_store_personality

Column	Valid Values	Description
organization_id	int	Store's organization identifier.
personality_id	int	The unique ID of the personality that this personality profile belongs to.
landscape_id	int (PK)	The unique ID of the landscape that this register range belongs to.

Table B-9 cfg_personality_base_feature

Column	Valid Values	Description
organization_id (PK)	int	Store's organization identifier.
personality_id (PK)	int	A unique identifier for a store's personality. An alphanumeric field used to enter the short name of the personality.
feature_id (PK)	varchar (200)	A unique identifier for a feature.
sort_order	int	Sort order when displaying code values.