Macromedia breeze-managing external breeze reports ユーザーズマニュアル
Database views and data relationships
13
EXT_TRANSACTION_DETAILS sample entries
Constraints
The EXT_TRANSACTION_DETAILS view excludes the following fields:
■
Correct or Incorrect, which can be determined by checking for a non-zero score
■
Date answered, which does not exist in the version 5.1 schema
EXT_TRANSACTIONS_VIEWS
This view manages data about the slides or pages viewed by users. The
EXT_TRANSACTIONS_VIEWS view uses the data listed in the following table:
EXT_TRANSACTIONS_VIEWS view uses the data listed in the following table:
Data is generated in this view whenever a user views content or a course.
EXT_TRANSACTIONS_VIEWS sample entries
TRANSACTION_ID QUESTION
RESPONSE SCORE
334
What is the RAM requirement?
1
10.0
340
What is the RAM requirement?
1
10.0
531
How many current users are there?
1
0.0
Column name
Data type
Description
TRANSACTION_ID
INT
Unique ID for this transaction (can be merged with
TRANSACTION_DETAILS to summarize by URL)
TRANSACTION_DETAILS to summarize by URL)
PAGE
NVARCHAR
The slide or page number that was viewed
DATE_VIEWED
DATETIME
The date this view occurred
TRANSACTION_ID PAGE
DATE_VIEWED
334
11
12/15/2004 11:17:38 PM
340
2
01/06/2004 12:17:38 PM
531
3
02/11/2004 08:17:38 AM