Scribd
Upload
19 views2 pages

Users

The document describes database tables that store user, folder, report, filter, session, and activity information. The users table stores user attributes. The folder_report_map table maps folders to reports. The filters table stores report filters. The sessions table stores session data. The activity table logs user activity and the activity_master table stores activity types.

Uploaded by

lojexen410
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
19 views2 pages

Users

The document describes database tables that store user, folder, report, filter, session, and activity information. The users table stores user attributes. The folder_report_map table maps folders to reports. The filters table stores report filters. The sessions table stores session data. The activity table logs user activity and the activity_master table stores activity types.

Uploaded by

lojexen410
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

users

folder_report_map
user_id varchar 1
* frm_id integer folders
user_name varchar * 1 folder_id
folder_id integer integer
role varchar * report_id integer folder_name varchar
created_at timestamp

is_active boolean
sessions
dd_ticket_no varchar
filters session_id integer 1

* filter_id integer * user_id varchar

user_rights report_id integer start_time timestamp

user_id varchar *
column_name varchar end_time timestamp

frm_id integer 1
is_mandatory boolean ip_address varchar

is_active boolean reports

modified_date timestamp report_id integer 1

report_name varchar activity

sqltext varchar activity_id integer

session_id integer *
is_active boolean

* endpoint_id * report_id integer


endpoint integer
* type_id integer
endpoint_id integer 1 dynamic_header varchar

modified_date timestamp
hostname varchar
activity_master
request_params varchar
port integer 1
type_id integer
username varchar
type_name varchar
password varchar

dbname varchar

engine varchar
users
folder_report_map
user_id varchar 1
* frm_id integer folders
user_name varchar * 1 folder_id
folder_id integer integer
role varchar * report_id integer folder_name varchar
created_at timestamp

is_active boolean
sessions
dd_ticket_no varchar
filters session_id integer 1

* filter_id integer * user_id varchar

user_rights report_id integer start_time timestamp

user_id varchar *
column_name varchar end_time timestamp

frm_id integer 1
is_mandatory boolean ip_address varchar

is_active boolean reports

modified_date timestamp report_id integer 1

report_name varchar activity

sqltext varchar activity_id integer

session_id integer *
is_active boolean

* endpoint_id * report_id integer


endpoint integer
* type_id integer
endpoint_id integer 1 dynamic_header varchar

modified_date timestamp
hostname varchar
activity_master
request_params varchar
port integer 1
type_id integer
username varchar
type_name varchar
password varchar

dbname varchar

engine varchar

You might also like