Macromedia breeze-managing external breeze reports User Manual

Database views and data relationships

EXT_USER_FIELDS

This view lists custom fields that can be used for each user. The EXT_USERS_FIELDS view
uses data listed in the following table:

Data is generated in this view whenever a user does any of the following:

■

Creates, updates, or deletes a group

■

Changes group membership attributes

EXT_USER_FIELDS

sample entries

EXT_USER_GROUPS

This view lists data about groups and associated group members. The
EXT_USER_GROUPS view uses the data listed in the following table:

Data is generated in this view whenever a user does any of the following:

■

Creates, updates or deletes a group

■

Changes group membership

Column name

Data type

Description

NVARCHAR

Unique user identifier.

NAME

NVARCHAR

Field name such as telephone number.

VALUE

NVARCHAR

Field value such as 415.555.1212.

NAME

VALUE

brice@adobe.com

{admins}

617-555-1212

ccarr@adobe.com

{authors}

415-555-1212

lblue@adobe.com

{course-admins} 408-555-1212

Column name

Data type Description

NVARCHAR

Name of user.

NAME

NVARCHAR

Name of group.