MACROMEDIA BREEZE-MANAGING EXTERNAL BREEZE REPORTS, Руководство пользователя

Страница: 9 / 18

9
2
CHAPTER 2
Using Breeze
Reporting Views
This chapter describes each of the database schema views used in Macromedia Breeze 5.1. The
external views allow you to develop custom reports that are based on user activity within
Macromedia Breeze.
This chapter describes the following:
■
Column name data type
■
Length of data contained in each column
■
Primary keys used to map relationships
Reporting data is accessible using an SQL-compliant tool.
Database schema views used in reporting
Breeze supports external reporting through a set of integrated database views. You use SQL
queries to develop customized reports.
The following database views are supported in Breeze 5.1:
■
EXT_TRANSACTIONS
■
EXT_TRANSACTION_DETAILS
■
EXT_TRANSACTION_VIEWS
■
EXT_USERS
■
EXT_USER_FIELDS
■
EXT_USER_ GROUPS
■
EXT_OBJECTS
NO
T
E
Database reporting views are intended for read-only access and usage.