Macromedia breeze-managing external breeze reports ユーザーズマニュアル

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.