Reports database structure

<< Click here to display Table of Contents >> Navigation: Install, Configure and Administer GN4 > Configuring GN4 > Configuring Reports:

Reports database structure

Build 1501 on 14/Nov/2017 This topic last edited on: 21/Mar/2016, at 18:52

No contents entries on this page

Contents

The structure of the reports database is defined in the workflow configuration file.

The wf_GN4Report.xml workflow generates the following database tables (all the fields are nullable):

ReportTitleTable: the list of gn4:title

Id	int	unique
Name	nvarchar(80)
Description	nvarchar(500)
CreationDate	datetime
ModifiedDate	datetime

ReportFolderTable: the list of gn4:folder

Id	int	unique
Name	nvarchar(80)
Description	nvarchar(500)
ParentId	int	gn4:folder/gn4:folderParent	ReportFolderTable.Id
CreationDate	datetime
ModifiedDate	datetime

ReportSecurityTable: the list of gn4:user and gn4:group

Id	int	unique
Name	nvarchar(80)
FullName	nvarchar(200)
Description	nvarchar(500)
CreationDate	datetime
ModifiedDate	datetime

ReportGroupXUserTable: the cross-reference between gn4:group and gn4:user

GroupId	int	unique	ReportSecurityTable.Id
UserId	int	unique	ReportSecurityTable.Id

The wf_GN4ReportEdition.xml workflow (called by wf_GN4Report.xml) generates the following database tables:

ReportEditionTable: the list of gn4:edition

Id	int	unique
Name	nvarchar(80)
Description	nvarchar(500)
CreatorId	int	gn4:edition/gn4:creatorRef	ReportSecurityTable.Id
CreationDate	datetime
ModifiedDate	datetime
EditionNumberName	nvarchar(80)
TitleId	int	gn4:edition/gn4:titleRef	ReportTitleTable.Id
Date	datetime
Pages	int

ReportPageTable: the list of gn4:page

Id	int	unique
Name	nvarchar(80)
Description	nvarchar(500)
Number	smallint
ZoneName	nvarchar(80)
SectionName	nvarchar(80)
EditionId	int	gn4:page/gn4:editionRef	ReportEditionTable.Id
LeftColor	smallint
RightColor	smallint
PageWidth	int
PageHeight	int
ColW	int
InterCol	int
ModH	int
LeftM	int
RightM	int
TopM	int
BottomM	int
InterMod	int
TwoSides	smallint
CreatorId	int	gn4:page/gn4:creatorRef	ReportSecurityTable.Id
CreationDate	datetime
ModifiedDate	datetime
LeftSpot	int
RightSpot	int
Deadline	datetime

ReportLayerTable: the list of gn4:pageLayer

Id	int	unique
Name	nvarchar(80)
Description	nvarchar(500)
CreationDate	datetime
ModifiedDate	datetime
LayerTypeName	nvarchar(80)
RegionName	nvarchar(80)

ReportPageXLayerTable: the cross-reference between gn4:page and gn4:pageLayer

PageId	int	unique	ReportPageTable.Id
LayerId	int	unique	ReportLayerTable.Id

ReportArticleTable: the list of gn4:article

Id	int	unique
Name	nvarchar(80)
FolderId	int	gn4:article/gn4:folderRef	ReportFolderTable.Id
CreatorId	int	gn4:article/gn4:creatorRef	ReportSecurityTable.Id
CreationDate	datetime
ModifiedDate	datetime
Deadline	datetime

ReportTxtTable: the list of gn4:txt

Id	int	unique
Name	nvarchar(80)
CategoryNames	nvarchar(500)
FolderId	int	gn4:txt/gn4:folderRef	ReportFolderTable.Id
TypeName	nvarchar(80)
AuthorId	int	gn4:txt/gn4:authorRef	ReportSecurityTable.Id
ArticleId	int		ReportArticleTable.Id
ArticleOrder	int
NParas	int
NLines	int
NWords	int
NChars	int
CreatorId	int	gn4:article/gn4:creatorRef	ReportSecurityTable.Id
CreationDate	datetime
ModifiedDate	datetime
Deadline	datetime

ReportImgTable: the list of gn4:img

Id	int	unique
Name	nvarchar(80)
Description	nvarchar(500)
CategoryNames	nvarchar(500)
FolderId	int	gn4:img/gn4:folderRef	ReportFolderTable.Id
TypeName	nvarchar(32)
AuthorId	int	gn4:img/gn4:authorRef	ReportSecurityTable.Id
ColorUsage	nvarchar(32)
Width	int
Height	int
IPTCCaption	nvarchar(500)
IPTCUrgency	nvarchar(32)
IPTCAuthor	nvarchar(255)
IPTCCity	nvarchar(32)
IPTCState	nvarchar(32)
IPTCCountry	nvarchar(64)
IPTCCredit	nvarchar(32)
IPTCSource	nvarchar(32)
CreationDate	datetime
ModifiedDate	datetime
Deadline	datetime

ReportElementXTable: the cross-reference between gn4:pageLayer and gn4:linkObject (gn4:img and gn4:txt)

ItemId	int	unique	ReportTxtTable.Id or ReportImgTable.Id
ClassName	nvarchar(80)
LayerId	int	unique	ReportLayerTable.Id
LayerTypeName	nvarchar(80)
PageId	int		ReportPageTable.Id
EditionId	int		ReportEditionTable.Id
FolderId	int		ReportFolderTable.Id
RegionName	nvarchar(80)
ZoneName	nvarchar(80)
SectionName	nvarchar(80)
AuthorName	nvarchar(80)
TextH	int
OverH	int
TextOverN	int
OverfullLines	int
NNoFitParas	int
Surface	float
CreationDate	datetime
ModifiedDate	datetime

ReportPageFootprintTable: the audit data of gn4:page

PageId	int	unique	ReportPageTable.Id
ActionName	nvarchar(80)	unique
UserId	int	unique	ReportSecurityTable.Id
Time	datetime	unique
InfoId	int
InfoName	nvarchar(80)

ReportPageLayerFootprintTable: the audit data of gn4:pageLayer

PageId	int	unique	ReportPageTable.Id
LayerId	int	unique	ReportLayerTable.Id
ActionName	nvarchar(80)	unique
UserId	int	unique	ReportSecurityTable.Id
Time	datetime	unique
InfoId	int
InfoName	nvarchar(80)

ReportArticleFootprintTable: the audit data of gn4:article

ArticleId	int	unique	ReportArticleTable.Id
ActionName	nvarchar(80)	unique
UserId	int	unique	ReportSecurityTable.Id
Time	datetime	unique
InfoId	int
InfoName	nvarchar(80)

ReportArticleTxtFootprintTable: the audit data of gn4:txt

ArticleId	int	unique	ReportArticleTable.Id
TxtId	int	unique	ReportTxtTable.Id
ActionName	nvarchar(80)	unique
UserId	int	unique	ReportSecurityTable.Id
Time	datetime	unique
InfoId	int
InfoName	nvarchar(80)