15-Jun-04 (Created: 15-Jun-04) | More in 'Development'

AKC data model

Users

user_id t
first_name t
middle_name t
last_name
password
email
active (Y/N)
master_page_template_item_id N

Folders

folder_id an
folder_name
parent_folder_id n
public (Y/N)
owner_user_id 

Reports

report_id n
report_short_name m
report_long_name m
report_description m
public (yes/no)
url m
update_url m
field_values t
where_clause t
report_type_id n
report_content_id n
owner_user_id t
created_by t
created_on t
last_updated_by
last_updated_on

sql-statements

id an
statement_id n
statement m
database_name t

report-types

report_type_id an
report_type_name
report_type_table_name
report_type_column_name

notes

Deprecated

topics

Deprecated