Data Model

__RefactorLog Table

Table ID: 561437074; Created: November 16, 2021, 18:20:38
Name Type NULL Comment
◆OperationKey uniqueidentifier ☐

_Test Table

Table ID: 773577794; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TestId int ☐
Descrip nvarchar (2000) ☐
DecimalField decimal (38, 14) ☒
IntegerField int ☒
ImageField varchar (max) ☒
FileField varchar (max) ☒
BitField bit ☒
DateField date ☒
SmalldateTimeField smalldatetime ☒
DbComboField nvarchar (50) ☒
ComboField nvarchar (50) ☒
WhiteBoardField nvarchar (max) ☒
ColorField nvarchar (50) ☒
CoordinateField nvarchar (100) ☒
CronField nvarchar (250) ☒
CssField nvarchar (1000) ☒
CustomField nvarchar (100) ☒
EmailField nvarchar (100) ☒
CheckMultiField nvarchar (1000) ☒
FilePathField nvarchar (250) ☒
HtmlCodeField nvarchar (1000) ☒
HtmlEditField nvarchar (1000) ☒
ImageFileField nvarchar (250) ☒
JavaCodeField nvarchar (1000) ☒
MultiComboField nvarchar (1000) ☒
MultiLineField nvarchar (250) ☒
NullCheckField bit ☒
PasswordField nvarchar (50) ☒
PhoneField nvarchar (50) ☒
RadioField nvarchar (50) ☒
SqlCodeField nvarchar (1000) ☒
SwitchField bit ☒
TagListField nvarchar (1000) ☒
TimeField nvarchar (50) ☒
UploadB64Field nvarchar (max) ☒
UploadFile nvarchar (250) ☒
UrlField nvarchar (100) ☒
WeekField nvarchar (100) ☒
IdentField nvarchar (250) ☒
IdDoc int ☐ IDENTITY
InsertUpdate bit ☐ DEFAULT ((0))
Usuario nvarchar (50) ☒
FechaInsertUpdate datetime ☐ DEFAULT (getdate())

_Test_Conf Table

Table ID: 805577908; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TestId int ☐ ⇨ dbo._Test.TestId
Config nvarchar (50) ☒

ActionsLog Table

Table ID: 837578022; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Id int ☐ IDENTITY
UserId nvarchar (128) ☐
TypeId int ☐ ⇨ dbo.ActionsLog_Types.TypeId
ProcessName nvarchar (255) ☒
ActionMessage nvarchar (1000) ☒
ObjectName nvarchar (50) ☒
ObjectKey nvarchar (255) ☒
TimeStamp datetime ☐
UserName nvarchar (128) ☐
EndTimeStamp datetime ☒
Milliseconds int ☒ COMPUTED

ActionsLog_Details Table

Table ID: 869578136; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Id int ☐ IDENTITY
LogId int ☐ ⇨ dbo.ActionsLog.Id
PropertyName nvarchar (50) ☐
OldValue nvarchar (max) ☒
NewValue nvarchar (max) ☒

ActionsLog_Settings Table

Table ID: 901578250; Created: November 16, 2021, 18:20:31
Name Type NULL Comment
◆SettingsId int ☐
Descrip nvarchar (50) ☐

ActionsLog_Types Table

Table ID: 933578364; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId int ☐
Descrip nvarchar (50) ☐
Action nvarchar (50) ☒

AspNetFaculties Table

Table ID: 965578478; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆FacultyId nvarchar (128) ☐
Name nvarchar (256) ☐
Descrip nvarchar (500) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

AspNetProfiles Table

Table ID: 997578592; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ProfileName nvarchar (100) ☐
Descrip nvarchar (100) ☐
CultureId nvarchar (8) ☐ ⇨ dbo.Cultures.CultureId
WebInterfaceName nvarchar (100) ☐ ⇨ dbo.Interfaces.InterfaceName
MobileInterfaceName nvarchar (100) ☐ ⇨ dbo.Interfaces.InterfaceName
StartupPageName nvarchar (100) ☐ ⇨ dbo.Pages.PageName
MailAccountId nvarchar (100) ☒ ⇨ dbo.Mail_Accounts.MailAccountId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

AspNetRoles Table

Table ID: 1029578706; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆Id nvarchar (128) ☐
Name nvarchar (256) ☐
IsDesigner bit ☐ DEFAULT ((0))
IsAdmin bit ☐ DEFAULT ((0))
Hidden bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

AspNetUserClaims Table

Table ID: 1061578820; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Id int ☐ IDENTITY
UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
ClaimType nvarchar (max) ☒
ClaimValue nvarchar (max) ☒

AspNetUserLogins Table

Table ID: 1093578934; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
LoginProvider nvarchar (128) ☐
ProviderKey nvarchar (128) ☐
UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id

AspNetUserRoles Table

Table ID: 1109578991; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id

AspNetUsers Table

Table ID: 1141579105; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆Id nvarchar (128) ☐
RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
ProfileName nvarchar (100) ☐ DEFAULT (N'default')⇨ dbo.AspNetProfiles.ProfileName
Email nvarchar (256) ☐
EmailConfirmed bit ☐
PasswordHash nvarchar (max) ☒
SecurityStamp nvarchar (max) ☒
PhoneNumber nvarchar (50) ☒
PhoneNumberConfirmed bit ☐
TwoFactorEnabled bit ☐
LockoutEndDateUtc datetime ☒
LockoutEnabled bit ☐ DEFAULT ((1))
AccessFailedCount int ☐
UserName nvarchar (256) ☐
IPGroup nvarchar (50) ☒ ⇨ dbo.AspNetUsers_IPGroups.IPGroup
Reference nvarchar (50) ☒
SubReference nvarchar (50) ☒
Avatar nvarchar (max) ☒ DEFAULT ('~/img/Avatars/avatar_blank.png')
Name nvarchar (100) ☒
SurName nvarchar (100) ☒
NickName nvarchar (100) ☒
CultureId nvarchar (8) ☐ ⇨ dbo.Cultures.CultureId
MailAccountId nvarchar (100) ☒ ⇨ dbo.Mail_Accounts.MailAccountId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

AspNetUsers_Devices Table

Table ID: 1173579219; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
◆DeviceToken nvarchar (250) ☐
Platform nvarchar (50) ☐
RegisterDate smalldatetime ☐ DEFAULT (getdate())
LastRegisterDate smalldatetime ☐ DEFAULT (getdate())

AspNetUsers_Devices_Platforms Table

Table ID: 1205579333; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Platform nvarchar (50) ☐
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName

AspNetUsers_Faculties Table

Table ID: 1237579447; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

AspNetUsers_Integrations Table

Table ID: 1269579561; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Id nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
◆TokenType nvarchar (64) ☐ ⇨ dbo.AspNetUsers_TokenTypes.TokenType
Active bit ☒ DEFAULT ((0))

AspNetUsers_IPGroups Table

Table ID: 1301579675; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆IPGroup nvarchar (50) ☐

AspNetUsers_IPGroups_Detail Table

Table ID: 1333579789; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆IPGroup nvarchar (50) ☐ ⇨ dbo.AspNetUsers_IPGroups.IPGroup
◆IP nvarchar (50) ☐

AspNetUsers_Log Table

Table ID: 1365579903; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:32
Name Type NULL Comment
◆LogId int ☐ IDENTITY
Date smalldatetime ☐
UserId nvarchar (128) ☐
IP nvarchar (50) ☐
Browser nvarchar (256) ☒
Culture nvarchar (100) ☒
Time nvarchar (5) ☒ DEFAULT (left(CONVERT([varchar],getdate(),(108)),(5)))
Success bit ☐ DEFAULT ((1))

AspNetUsers_Settings Table

Table ID: 1397580017; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
SkinId int ☒
MobileSkinId varchar (50) ☒
DefaultPageSize int ☒
DefaultDropDownRows int ☒
MailAccount nvarchar (50) ☒
MailUser nvarchar (100) ☒
MailVisibleName nvarchar (100) ☒
POP3Host nvarchar (100) ☒
SMTPHost nvarchar (100) ☒
MaillPassowrd varchar (50) ☒
DeleteMailsOnServer bit ☐
SMTPPort int ☐ DEFAULT ((25))
POPPort int ☐ DEFAULT ((110))
UseSSL bit ☐
MailSignature nvarchar (1000) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

AspNetUsers_Tokens Table

Table ID: 1429580131; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TokenId nvarchar (100) ☐ DEFAULT (newid())
Id nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
TokenType nvarchar (64) ☐ ⇨ dbo.AspNetUsers_TokenTypes.TokenType
AccessToken nvarchar (max) ☐
RefreshToken nvarchar (max) ☒
RefreshData nvarchar (max) ☒
Scope nvarchar (max) ☒
ExpiryDate smalldatetime ☒
InsertedDate smalldatetime ☒
AppName nvarchar (256) ☒
CalendarId nvarchar (255) ☒

AspNetUsers_TokenTypes Table

Table ID: 1461580245; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TokenType nvarchar (64) ☐
Descrip nvarchar (max) ☐
IconName nvarchar (100) ☒ DEFAULT (N'noicon')
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

BlackList Table

Table ID: 1493580359; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆Id nvarchar (100) ☐ DEFAULT (newid())
Method nvarchar (255) ☐
Param nvarchar (255) ☐
ExcludeList nvarchar (max) ☒
ExcludeRegex nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Charts_Animations Table

Table ID: 1525580473; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Animation nvarchar (100) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Charts_Settings Table

Table ID: 1557580587; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ChartSettingName nvarchar (100) ☐
Descrip nvarchar (255) ☒
ShowLabels bit ☐ DEFAULT ((1))
Colors nvarchar (500) ☒
BorderColors nvarchar (500) ☒
ShowLegend bit ☐ DEFAULT ((1))
LegendPos nvarchar (20) ☒
ToolTipBackgroundColor nvarchar (10) ☒
ShowTitle bit ☐ DEFAULT ((1))
TitleFontStyle nvarchar (150) ☒
TitleFontSize int ☒
TitlePosition nvarchar (20) ☒
TitleFontColor nvarchar (20) ☒
Responsive bit ☐ DEFAULT ((1))
MinXAxes int ☒ DEFAULT ((0))
MinYAxes int ☒ DEFAULT ((0))
AnimationDuration int ☒ DEFAULT ((2000))
AnimationStyle nvarchar (100) ☒ ⇨ dbo.Charts_Animations.Animation
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Chatters Table

Table ID: 1589580701; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆MessageId uniqueidentifier ☐ DEFAULT (newid())
UserOwner nvarchar (128) ☒ ⇨ dbo.AspNetUsers.Id
Content nvarchar (max) ☐
InsertionDate datetime ☐ DEFAULT (getdate())
DestinationObjectName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
DestinationObjectId nvarchar (250) ☒
DestinationParentMessage uniqueidentifier ☒ ⇨ dbo.Chatters.MessageId
DestinationUser nvarchar (128) ☒ ⇨ dbo.AspNetUsers.Id
DestinationChatterGroup uniqueidentifier ☒ ⇨ dbo.Chatters_Groups.ChatterGroupId
LoginOwner nvarchar (128) ☒

Chatters_Config Table

Table ID: 1621580815; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐
◆ObjectPK nvarchar (50) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Chatters_Groups Table

Table ID: 1653580929; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ChatterGroupId uniqueidentifier ☐ DEFAULT (newid())
Name nvarchar (50) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Chatters_Groups_Users Table

Table ID: 1685581043; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ChatterGroupId uniqueidentifier ☐ ⇨ dbo.Chatters_Groups.ChatterGroupId
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Configuration_Actions_Types Table

Table ID: 1717581157; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ActionId smallint ☐
Description nvarchar (255) ☐

Configuration_Default_Actions Table

Table ID: 1749581271; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆DefaultActionId int ☐
TableName nvarchar (256) ☒
FieldName nvarchar (256) ☒
RowOriginId int ☒ ⇨ dbo.Origins.OriginId
ActionId smallint ☐ ⇨ dbo.Configuration_Actions_Types.ActionId

Configuration_Scripts Table

Table ID: 1781581385; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ScriptId nvarchar (256) ☐
ScriptText nvarchar (max) ☐

Configuration_Tables Table

Table ID: 1813581499; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆TableName nvarchar (256) ☐
CompareMode smallint ☐ ⇨ dbo.Configuration_Tables_CompareModes.Mode
CompareFilter nvarchar (max) ☒
Autoscripting bit ☐ DEFAULT ((1))

Configuration_Tables_CompareModes Table

Table ID: 1845581613; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆Mode smallint ☐
Description nvarchar (255) ☐

ContextVars Table

Table ID: 1877581727; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆VarName nvarchar (50) ☐
VarSQL nvarchar (max) ☐
Order int ☐ DEFAULT ((0))
ConnStringId nvarchar (100) ☐
OriginId int ☒ DEFAULT ([dbo].[funNet_GetOrigin]())

Countries Table

Table ID: 1909581841; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆IsoCode nvarchar (2) ☐
Iso3 nvarchar (3) ☐
Name nvarchar (50) ☐
IsoName nvarchar (50) ☐
Flag nvarchar (1009) ☐
Active bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Cultures Table

Table ID: 1941581955; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆CultureId nvarchar (8) ☐
CountryISO nvarchar (2) ☒ ⇨ dbo.Countries.IsoCode
Name nvarchar (100) ☐
Flag nvarchar (100) ☒
Active bit ☐ DEFAULT ((1))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

DbConnectionStrings Table

Table ID: 1973582069; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ConnStringId nvarchar (50) ☐
Descrip nvarchar (100) ☐
UpdateDataModel bit ☐ DEFAULT ((0))
DacpacName nvarchar (150) ☒
Active bit ☐ DEFAULT ((1))
Reserved bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

DbConnectionStrings_LinkedServers Table

Table ID: 2005582183; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆ConnStringId nvarchar (50) ☐
◆ChildConnStringId nvarchar (50) ☐
ServerName nvarchar (100) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

DbUpdateTypes Table

Table ID: 2037582297; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆UpdateTypeId nvarchar (10) ☐
Descrip nvarchar (50) ☐

Documents Table

Table ID: 2069582411; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆DocGuid uniqueidentifier ☐ DEFAULT (newid())
Name nvarchar (100) ☐
Description nvarchar (250) ☒
CategoryId nvarchar (50) ☐ DEFAULT (N'sysdoc-generic')⇨ dbo.Documents_Category.CategoryId
CreationDate smalldatetime ☐ DEFAULT (getdate())

Documents_Category Table

Table ID: 2101582525; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆CategoryId nvarchar (50) ☐
Category nvarchar (255) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Documents_Drive_Config Table

Table ID: 2133582639; Created: November 16, 2021, 18:20:31
Name Type NULL Comment
◆Account nvarchar (250) ☐
Code nvarchar (1000) ☐
RefreshToken nvarchar (1000) ☐
AccessToken nvarchar (1000) ☐
TokenType nvarchar (250) ☐
ExpiryDate datetime ☐
Active bit ☐
Default bit ☐
LastUse datetime ☐

Documents_Extensions Table

Table ID: 18099105; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆Origin nvarchar (50) ☐
Description nvarchar (100) ☐
IconName nvarchar (100) ☐ ⇨ dbo.Icons.IconName
Extension nvarchar (255) ☒

Documents_Objects Table

Table ID: 50099219; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆DocGuid uniqueidentifier ☐ ⇨ dbo.Documents.DocGuid
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆ObjectId nvarchar (250) ☐

Documents_Objects_Config Table

Table ID: 82099333; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆ObjectPK nvarchar (50) ☐
ERPObjectName nvarchar (250) ☒
TypeId nvarchar (50) ☐ DEFAULT ('flexygo')⇨ dbo.Documents_Objects_Config_Types.TypeId
Path nvarchar (500) ☐
DefaultCategoryId nvarchar (50) ☒
CategoryFilter nvarchar (max) ☒
DropboxFolderCreate bit ☐ DEFAULT ((0))
DropboxFolderLink bit ☐ DEFAULT ((0))
DropboxFileCreate bit ☐ DEFAULT ((0))
DropboxFileLink bit ☐ DEFAULT ((0))
DriveFolderCreate bit ☐ DEFAULT ((0))
DriveFolderLink bit ☐ DEFAULT ((0))
DriveFileCreate bit ☐ DEFAULT ((0))
DriveFileLink bit ☐ DEFAULT ((0))
DiskFolderCreate bit ☐ DEFAULT ((0))
DiskFolderLink bit ☐ DEFAULT ((0))
DiskFileCreate bit ☐ DEFAULT ((0))
DiskFileLink bit ☐ DEFAULT ((0))
ExtensionId nvarchar (100) ☒ DEFAULT (N'sysAll')⇨ dbo.Extensions.ExtensionId
OfflineFilter nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Documents_Objects_Config_Types Table

Table ID: 114099447; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId nvarchar (50) ☐
Descrip nvarchar (250) ☐
Active bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Documents_Versions Table

Table ID: 146099561; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆DocGuid uniqueidentifier ☐ ⇨ dbo.Documents.DocGuid
◆Revision int ☐
FilePath nvarchar (255) ☐
DownloadLink nvarchar (255) ☐
CloudID nvarchar (250) ☒
DocumentTypeName nvarchar (50) ☐ ⇨ dbo.Documents_Versions_Types.Type
InProgress bit ☐ DEFAULT ((0))
Origin nvarchar (50) ☐ ⇨ dbo.Documents_Extensions.Origin

Documents_Versions_Types Table

Table ID: 178099675; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆Type nvarchar (50) ☐
Description nvarchar (250) ☐

Error_Levels Table

Table ID: 210099789; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆Level int ☐
Descrip nvarchar (100) ☐

Error_Log Table

Table ID: 242099903; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆Id int ☐ IDENTITY
UserId nvarchar (128) ☒
ErrorLevel int ☐ ⇨ dbo.Error_Levels.Level
ErrorMessage nvarchar (max) ☒
ErrorStack nvarchar (max) ☒
ErrorCode nvarchar (50) ☒
ErrorSeverity int ☐ ⇨ dbo.Error_Severity.Severity
ObjectName nvarchar (50) ☒
ObjectKey nvarchar (500) ☒
ActionType int ☒ ⇨ dbo.ActionsLog_Types.TypeId
ProcessName nvarchar (255) ☒
ProcessParams nvarchar (max) ☒
MoreInfo nvarchar (max) ☒
ConnectionStringId nvarchar (50) ☒
UserName nvarchar (128) ☒
Browser nvarchar (50) ☒
BrowserVersion nvarchar (50) ☒
TimeStamp datetime ☐
Version nvarchar (50) ☒
Guid nvarchar (100) ☐ DEFAULT (newid())
IP nvarchar (50) ☒

Error_Severity Table

Table ID: 274100017; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆Severity int ☐
Descrip nchar (10) ☐

Events_Actions Table

Table ID: 306100131; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆EventAction nvarchar (50) ☐
Description nvarchar (255) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Events_Classes Table

Table ID: 338100245; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆EventClass nvarchar (50) ☐
Description nvarchar (255) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Events_Classes_Types Table

Table ID: 370100359; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆EventClass nvarchar (50) ☐ ⇨ dbo.Events_Classes.EventClass
◆EventType nvarchar (50) ☐ ⇨ dbo.Events_Types.EventType
Description nvarchar (255) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Events_Types Table

Table ID: 402100473; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆EventType nvarchar (50) ☐
Description nvarchar (255) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Exceptions Table

Table ID: 434100587; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆Id nvarchar (100) ☐ DEFAULT (newid())
Msg nvarchar (900) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Export_Formats Table

Table ID: 482100758; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆Format nvarchar (50) ☐
Description nvarchar (100) ☐
IconName nvarchar (100) ☐
MaxNumber int ☐ DEFAULT ((50000))
Active bit ☐ DEFAULT ((1))
Order int ☐ DEFAULT ((20))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Extensions Table

Table ID: 514100872; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ExtensionId nvarchar (100) ☐
Descrip nvarchar (500) ☐
Extensions nvarchar (500) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Flexygo_Connectors Table

Table ID: 546100986; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆AppName nvarchar (255) ☐
ExternalUrl nvarchar (255) ☐

Follow_Object_Users Table

Table ID: 578101100; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Object nvarchar (50) ☐ ⇨ dbo.Follow_Objects_Config.Object
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id

Follow_Objects_Child_Config Table

Table ID: 610101214; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Object nvarchar (50) ☐ ⇨ dbo.Follow_Objects_Config.Object
◆ChildObject nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Follow_Objects_Child_Users Table

Table ID: 642101328; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Object nvarchar (50) ☐
◆ChildObject nvarchar (50) ☐
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id

Follow_Objects_Config Table

Table ID: 674101442; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Object nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
Disable bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

GreyList Table

Table ID: 706101556; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆Id nvarchar (100) ☐ DEFAULT (newid())
Method nvarchar (255) ☐
Param nvarchar (255) ☐
ExcludeList nvarchar (max) ☒
ExcludeRegex nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Help Table

Table ID: 738101670; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆HelpId nvarchar (50) ☐ DEFAULT (newid())
Title nvarchar (150) ☐
HTMLText nvarchar (max) ☒
TargetId nvarchar (50) ☐ DEFAULT (N'current')⇨ dbo.Targets.TargetId
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName
ExternalUrl nvarchar (255) ☒
Order int ☒ DEFAULT ((0))
Category nvarchar (50) ☐
Tag nvarchar (200) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Help_Categories Table

Table ID: 770101784; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Category nvarchar (50) ☐
Descrip nvarchar (250) ☐
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Help_Cultures Table

Table ID: 802101898; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆HelpId nvarchar (50) ☐ ⇨ dbo.Help.HelpId
◆CultureId nvarchar (8) ☐ ⇨ dbo.Cultures.CultureId
HTMLText nvarchar (max) ☐

Help_SamplesJS Table

Table ID: 834102012; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆HelpJSId nvarchar (50) ☐ DEFAULT (newid())
Title nvarchar (150) ☐
HTMLCode nvarchar (max) ☒
JSCode nvarchar (max) ☒
CSSCode nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Icons Table

Table ID: 866102126; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆IconName nvarchar (100) ☐
Classification nvarchar (50) ☐
CSSClass nvarchar (100) ☒
ImagePath nvarchar (255) ☒
Category nvarchar (100) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Image_Compression_Types Table

Table ID: 898102240; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId smallint ☐
Descrip nvarchar (50) ☐

Interfaces Table

Table ID: 930102354; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆InterfaceName nvarchar (100) ☐
TypeId int ☐ ⇨ dbo.Interfaces_Types.TypeId
Descrip nvarchar (100) ☐
IsDefault bit ☐ DEFAULT ((0))
Logo nvarchar (255) ☒
SkinId nvarchar (50) ☐ ⇨ dbo.Skins.SkinId
Script nvarchar (max) ☒
Style nvarchar (1000) ☒
MainNavigateId uniqueidentifier ☒ ⇨ dbo.Navigation_Nodes.NodeId
NavigateId uniqueidentifier ☒ ⇨ dbo.Navigation_Nodes.NodeId
StartupPageName nvarchar (250) ☒
DefaultPageSize int ☐ DEFAULT ((50))
DefaultDropDownRows int ☐ DEFAULT ((20))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Interfaces_Types Table

Table ID: 962102468; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId int ☐
Descrip nvarchar (100) ☒

Interfaces_Types_JS Table

Table ID: 994102582; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆InterfaceTypeId uniqueidentifier ☐ DEFAULT (newid())
TypeId int ☐ ⇨ dbo.Interfaces_Types.TypeId
FilePath nvarchar (255) ☐
Description nvarchar (255) ☐
Order int ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Jobs Table

Table ID: 1026102696; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆JobName nvarchar (50) ☐
JobGroup nvarchar (50) ☐
Enabled bit ☐ DEFAULT ((0))
Descrip nvarchar (250) ☐
FirstExecutionDate datetime ☐
LastExecutionDate datetime ☒
TriggerExpression nvarchar (50) ☐ ⇨ dbo.Jobs_Triggers.TriggerExpression
ExecuteInmediatlyAfterMisfire bit ☐ DEFAULT ((0))
ObjectName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
ObjectWhere nvarchar (max) ☒
UserName nvarchar (256) ☐
ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
Params nvarchar (max) ☒
OriginId int ☒ DEFAULT ([dbo].[funNet_GetOrigin]())

Jobs_Log Table

Table ID: 1058102810; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ExecutionId nvarchar (50) ☐ DEFAULT (newid())
JobName nvarchar (50) ☐ ⇨ dbo.Jobs.JobName
JobStart datetime ☐ DEFAULT (getdate())
JobEnd datetime ☒
HasError bit ☐ DEFAULT ((0))
NotifiedError bit ☐ DEFAULT ((0))
Descrip nvarchar (max) ☐

Jobs_Qrtz_Blob_Triggers Table

Table ID: 1090102924; Created: November 16, 2021, 18:20:31
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐
◆Trigger_Name nvarchar (150) ☐
◆Trigger_Group nvarchar (150) ☐
Blob_Data image ☒

Jobs_Qrtz_Calendars Table

Table ID: 1122103038; Created: November 16, 2021, 18:20:31
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐
◆Calendar_Name nvarchar (200) ☐
Calendar image ☐

Jobs_Qrtz_Cron_Triggers Table

Table ID: 1154103152; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐ ⇨ dbo.Jobs_Qrtz_Triggers.Sched_Name
◆Trigger_Name nvarchar (150) ☐ ⇨ dbo.Jobs_Qrtz_Triggers.Trigger_Name
◆Trigger_Group nvarchar (150) ☐ ⇨ dbo.Jobs_Qrtz_Triggers.Trigger_Group
Cron_Expression nvarchar (120) ☐
Time_Zone_Id nvarchar (80) ☒

Jobs_Qrtz_Fired_Triggers Table

Table ID: 1186103266; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:31
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐
◆Entry_Id nvarchar (140) ☐
Trigger_Name nvarchar (150) ☐
Trigger_Group nvarchar (150) ☐
Instance_Name nvarchar (200) ☐
Fired_Time bigint ☐
Sched_Time bigint ☐
Priority int ☐
State nvarchar (16) ☐
Job_Name nvarchar (150) ☒
Job_Group nvarchar (150) ☒
Is_Nonconcurrent bit ☒
Requests_Recovery bit ☒

Jobs_Qrtz_Job_Details Table

Table ID: 1218103380; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐
◆Job_Name nvarchar (150) ☐
◆Job_Group nvarchar (150) ☐
Description nvarchar (250) ☒
Job_Class_Name nvarchar (250) ☐
Is_Durable bit ☐
Is_Nonconcurrent bit ☐
Is_Update_Data bit ☐
Requests_Recovery bit ☐
Job_Data image ☒

Jobs_Qrtz_Locks Table

Table ID: 1250103494; Created: November 16, 2021, 18:20:31
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐
◆Lock_Name nvarchar (40) ☐

Jobs_Qrtz_Paused_Trigger_Grps Table

Table ID: 1282103608; Created: November 16, 2021, 18:20:31
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐
◆Trigger_Group nvarchar (150) ☐

Jobs_Qrtz_Scheduler_State Table

Table ID: 1314103722; Created: November 16, 2021, 18:20:31
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐
◆Instance_Name nvarchar (200) ☐
Last_Checkin_Time bigint ☐
Checkin_Interval bigint ☐

Jobs_Qrtz_Simple_Triggers Table

Table ID: 1346103836; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐ ⇨ dbo.Jobs_Qrtz_Triggers.Sched_Name
◆Trigger_Name nvarchar (150) ☐ ⇨ dbo.Jobs_Qrtz_Triggers.Trigger_Name
◆Trigger_Group nvarchar (150) ☐ ⇨ dbo.Jobs_Qrtz_Triggers.Trigger_Group
Repeat_Count int ☐
Repeat_Interval bigint ☐
Times_Triggered int ☐

Jobs_Qrtz_Simprop_Triggers Table

Table ID: 1378103950; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐ ⇨ dbo.Jobs_Qrtz_Triggers.Sched_Name
◆Trigger_Name nvarchar (150) ☐ ⇨ dbo.Jobs_Qrtz_Triggers.Trigger_Name
◆Trigger_Group nvarchar (150) ☐ ⇨ dbo.Jobs_Qrtz_Triggers.Trigger_Group
Str_Prop_1 nvarchar (512) ☒
Str_Prop_2 nvarchar (512) ☒
Str_Prop_3 nvarchar (512) ☒
Int_Prop_1 int ☒
Int_Prop_2 int ☒
Long_Prop_1 bigint ☒
Long_Prop_2 bigint ☒
Dec_Prop_1 numeric (13, 4) ☒
Dec_Prop_2 numeric (13, 4) ☒
Bool_Prop_1 bit ☒
Bool_Prop_2 bit ☒
Time_Zone_Id nvarchar (80) ☒

Jobs_Qrtz_Triggers Table

Table ID: 1410104064; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Sched_Name nvarchar (120) ☐ ⇨ dbo.Jobs_Qrtz_Job_Details.Sched_Name
◆Trigger_Name nvarchar (150) ☐
◆Trigger_Group nvarchar (150) ☐
Job_Name nvarchar (150) ☐ ⇨ dbo.Jobs_Qrtz_Job_Details.Job_Name
Job_Group nvarchar (150) ☐ ⇨ dbo.Jobs_Qrtz_Job_Details.Job_Group
Description nvarchar (250) ☒
Next_Fire_Time bigint ☒
Prev_Fire_Time bigint ☒
Priority int ☒
Trigger_State nvarchar (16) ☐
Trigger_Type nvarchar (8) ☐
Start_Time bigint ☐
End_Time bigint ☒
Calendar_Name nvarchar (200) ☒
Misfire_Instr int ☒
Job_Data image ☒

Jobs_Triggers Table

Table ID: 1442104178; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TriggerExpression nvarchar (50) ☐
Descrip nvarchar (250) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Kanban_Boards Table

Table ID: 1474104292; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆BoardName nvarchar (50) ☐ DEFAULT (newid())
BoardGroup nvarchar (50) ☐
Title nvarchar (100) ☐
Descrip nvarchar (250) ☒
OwnerId nvarchar (128) ☐
BoardTypeName nvarchar (50) ☐ ⇨ dbo.Kanban_Boards_Types.BoardTypeName
ObjectName nvarchar (50) ☒
ObjectKey nvarchar (500) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Kanban_Boards_Columns Table

Table ID: 1506104406; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆BoardName nvarchar (50) ☐ ⇨ dbo.Kanban_Boards.BoardName
◆ColumnName nvarchar (50) ☐ DEFAULT (newid())
Descrip nvarchar (50) ☐
CssClass nvarchar (50) ☒
IconId nvarchar (100) ☒
Order int ☐ DEFAULT ((0))
Hidden bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Kanban_Boards_Types Table

Table ID: 1538104520; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆BoardTypeName nvarchar (50) ☐
Descrip nvarchar (250) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Kanban_Boards_Types_Columns Table

Table ID: 1570104634; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆BoardTypeName nvarchar (50) ☐ ⇨ dbo.Kanban_Boards_Types.BoardTypeName
◆ColumnName nvarchar (50) ☐
Descrip nvarchar (50) ☐
CssClass nvarchar (50) ☒
IconId nvarchar (100) ☒
Order int ☐ DEFAULT ((0))
Hidden bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Kanban_Cards Table

Table ID: 1602104748; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆CardId nvarchar (100) ☐ DEFAULT (newid())
BoardName nvarchar (50) ☐ ⇨ dbo.Kanban_Boards_Columns.BoardName
ColumnName nvarchar (50) ☐ ⇨ dbo.Kanban_Boards_Columns.ColumnName
Descrip nvarchar (max) ☒
OwnerId nvarchar (128) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Kanban_Order Table

Table ID: 1634104862; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆KanbanSettingsName nvarchar (50) ☐ ⇨ dbo.Kanban_Settings.KanbanSettingsName
◆BoardId nvarchar (250) ☐
JsonData nvarchar (max) ☐

Kanban_Settings Table

Table ID: 1666104976; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆KanbanSettingsName nvarchar (50) ☐ DEFAULT (newid())
BoardTitleTemplate nvarchar (max) ☐
BoardDescripTemplate nvarchar (max) ☒
BoardObjectName nvarchar (50) ☐
ColumnViewName nvarchar (255) ☐
ColumnDescripField nvarchar (100) ☐
ColumnIdField nvarchar (100) ☐
ColumnCssClassField nvarchar (100) ☒
ColumnIconIdField nvarchar (100) ☒
CardObjectName nvarchar (50) ☐
CardViewName nvarchar (255) ☐
CardIdField nvarchar (100) ☐
CardColumnIdField nvarchar (100) ☐
CardDescripField nvarchar (100) ☐
CardContentTemplate nvarchar (max) ☒
onChangeColumnProcess nvarchar (255) ☒
onCardClick nvarchar (50) ☒ DEFAULT ('edit')
EndBoxLastState nvarchar (100) ☒
EndBoxProcess nvarchar (255) ☒
EndBoxText nvarchar (255) ☒
EndBoxIconName nvarchar (100) ☒
EndBoxCssClass nvarchar (100) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Layouts Table

Table ID: 1698105090; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆LayoutName nvarchar (100) ☐
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName
LayoutDescrip nvarchar (255) ☐
LayoutTemplate nvarchar (max) ☐
ImagePath nvarchar (255) ☒
Offline bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

License Table

Table ID: 1730105204; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆RequestId nvarchar (50) ☐
◆LicenseId nvarchar (50) ☐
RequestData nvarchar (max) ☐
LicenseData nvarchar (max) ☐
LicenseCode nvarchar (50) ☒

LocalStorage Table

Table ID: 1762105318; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
◆InterfaceName nvarchar (100) ☐ ⇨ dbo.Interfaces.InterfaceName
◆Key nvarchar (100) ☐
Value nvarchar (max) ☒

Mail_Accounts Table

Table ID: 1794105432; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆MailAccountId nvarchar (100) ☐ DEFAULT (newid())
Account nvarchar (50) ☐
UserName nvarchar (100) ☐
VisibleName nvarchar (100) ☐
PopImapHost nvarchar (100) ☐
SMTPHost nvarchar (100) ☐
MailPassword varchar (50) ☐
SMTPPort int ☐
PopImapPort int ☐
UseSSL bit ☐ DEFAULT ((1))
UseTLS bit ☐ DEFAULT ((0))

MailChimp_Campaigns Table

Table ID: 1826105546; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆Id nvarchar (55) ☐
WebId int ☒
Type int ☐
CreateTime datetime ☒
Status nvarchar (255) ☒
EmailsSent int ☒
SendTime datetime ☒
ContentType nvarchar (255) ☒
SubjectLine nvarchar (255) ☒
PreviewText nvarchar (255) ☒
Title nvarchar (255) ☐
FromName nvarchar (255) ☒
ReplyTo nvarchar (255) ☒
FolderId nvarchar (255) ☒
TemplateId int ☒
PlainText nvarchar (max) ☒
Html nvarchar (max) ☒
ListId nvarchar (55) ☒
Segmented bit ☒ DEFAULT ((0))
Synchronized bit ☒ DEFAULT ((0))

MailChimp_Campaigns_Contacts Table

Table ID: 1858105660; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆CampaignId nvarchar (55) ☐ ⇨ dbo.MailChimp_Campaigns.Id
◆EmailAddress nvarchar (255) ☐

MailChimp_CampaignsInfo Table

Table ID: 1890105774; Created: November 16, 2021, 18:20:31
Name Type NULL Comment
◆Id nvarchar (55) ☐
EmailsSent int ☒
AbuseReports int ☒
Unsubscribed int ☒
OpensTotal int ☒
UniqueOpens int ☒
OpenRate decimal (5, 4) ☒
LastOpen datetime ☒
ClicksTotal int ☒
UniqueClicks int ☒
ClickRate decimal (5, 4) ☒
LastClick datetime ☒
RecipientLikes int ☒
UniqueLikes int ☒
FacebookLikes int ☒

MailChimp_CampaignsInfo_Clicks Table

Table ID: 1922105888; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆CampaignId nvarchar (55) ☐ ⇨ dbo.MailChimp_Campaigns.Id
◆UrlId nvarchar (55) ☐
Url nvarchar (550) ☐
◆EmailAddress nvarchar (255) ☐
Clicks int ☒

MailChimp_CampaignsInfo_Opens Table

Table ID: 1954106002; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆CampaignId nvarchar (55) ☐ ⇨ dbo.MailChimp_Campaigns.Id
◆EmailAddress nvarchar (255) ☐
OpensCount int ☒
FirstOpen datetime ☒
LastOpen datetime ☒

MailChimp_Contacts Table

Table ID: 1986106116; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆EmailAddress nvarchar (255) ☐
ObjectName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
ObjectId nvarchar (255) ☒
Fname nvarchar (255) ☐
LName nvarchar (255) ☒
Addr1 nvarchar (255) ☒
Addr2 nvarchar (255) ☒
City nvarchar (255) ☒
State nvarchar (255) ☒
Zip nvarchar (50) ☒
Country nvarchar (255) ☒
Status nvarchar (50) ☒
Language nvarchar (50) ☒
Vip bit ☒
IsUpload bit ☒ DEFAULT ((0))

MailChimp_Lists Table

Table ID: 2018106230; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆Id nvarchar (55) ☐
WebId int ☐
Name nvarchar (255) ☐
Company nvarchar (255) ☐
Address1 nvarchar (255) ☐
Address2 nvarchar (255) ☒
City nvarchar (255) ☐
State nvarchar (255) ☐
Zip nvarchar (50) ☐
Country nvarchar (255) ☐
Phone nvarchar (255) ☒
PermissionReminder nvarchar (max) ☐
DefaultCampaignFromName nvarchar (255) ☐
DefaultCampaignFromEmail nvarchar (255) ☐
DefaultCampaignSubject nvarchar (255) ☒
DefaultCampaignLanguage nvarchar (255) ☒
EmailTypeOption bit ☐
Visibility nvarchar (50) ☒
DateCreated datetime ☒
MemberCount int ☒
CampaignCount int ☒
Synchronized bit ☒ DEFAULT ((0))

MailChimp_Lists_Contacts Table

Table ID: 2050106344; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ListId nvarchar (55) ☐ ⇨ dbo.MailChimp_Lists.Id
◆EmailAddress nvarchar (255) ☐

MailChimp_Objects_Contacts Table

Table ID: 2082106458; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆RegId uniqueidentifier ☐ DEFAULT (newid())
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
ObjectId nvarchar (255) ☐
ViewName nvarchar (255) ☒
EmailAddress nvarchar (255) ☐
Fname nvarchar (255) ☒
LName nvarchar (255) ☒
Addr1 nvarchar (255) ☒
Addr2 nvarchar (250) ☒
City nvarchar (255) ☒
State nvarchar (255) ☒
Zip nvarchar (50) ☒
Country nvarchar (255) ☒
Status nvarchar (50) ☒
Language nvarchar (50) ☒
Vip bit ☒

MailChimp_Settings Table

Table ID: 2114106572; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆SettingName nvarchar (255) ☐
Descrip nvarchar (255) ☐
Value nvarchar (255) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

MailChimp_Templates Table

Table ID: 2146106686; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:32
Name Type NULL Comment
◆Id int ☐
Type nvarchar (255) ☒
Name nvarchar (255) ☐
Html nvarchar (max) ☒
DragAndDrop bit ☒
Responsive bit ☒
Category nvarchar (255) ☒
DateCreated datetime ☒
CreatedBy nvarchar (255) ☒
Active bit ☒
FolderId nvarchar (255) ☒
Thumbnail nvarchar (255) ☒
ShareUrl nvarchar (255) ☒
Synchronized bit ☒ DEFAULT ((0))

Mails Table

Table ID: 30623152; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆MessageId nvarchar (250) ☐
HeaderMessageId nvarchar (250) ☒
Uid bigint ☒ DEFAULT ((0))
MailDate smalldatetime ☐
Subject nvarchar (max) ☒
BodyHtml nvarchar (max) ☒
BodyText nvarchar (max) ☒
BodyRtf nvarchar (max) ☒
InReplyTo nvarchar (250) ☒
PartialId nvarchar (250) ☒
Importance nvarchar (150) ☒
MimeVersion nvarchar (150) ☒
RcptTo nvarchar (150) ☒
ReturnPath nvarchar (150) ☒
MailAccountId nvarchar (100) ☒ ⇨ dbo.Mail_Accounts.MailAccountId
FolderId nvarchar (50) ☐ ⇨ dbo.Mails_Folders.FolderId
IsForward bit ☐ DEFAULT ((0))
IsReply bit ☐ DEFAULT ((0))
IsPartial bit ☐ DEFAULT ((0))
IsEncrypted bit ☐ DEFAULT ((0))
IsSigned bit ☐ DEFAULT ((0))
IsLinked bit ☐ DEFAULT ((0))
HasAttachments bit ☐ DEFAULT ((0))
FromAddress nvarchar (500) ☐
FromName nvarchar (500) ☒
MailTo nvarchar (max) ☒
MailCC nvarchar (max) ☒
Seen bit ☒ DEFAULT ((0))
Sincronizado bit ☐ DEFAULT ((0))
Deleted bit ☐ DEFAULT ((0))

Mails_Attachments Table

Table ID: 62623266; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆MessageId nvarchar (250) ☐ ⇨ dbo.Mails.MessageId
◆AttachmentId nvarchar (200) ☐
FileName nvarchar (250) ☒
ContentType nvarchar (50) ☒
FilePath nvarchar (250) ☒
Size int ☒
IsEmbebed bit ☒

Mails_Contacts Table

Table ID: 94623380; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆MessageId nvarchar (250) ☐ ⇨ dbo.Mails.MessageId
◆TypeId nvarchar (50) ☐ ⇨ dbo.Mails_Contacts_Types.TypeId
◆MailAddress nvarchar (500) ☐
Name nvarchar (500) ☒

Mails_Contacts_Types Table

Table ID: 126623494; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆TypeId nvarchar (50) ☐
Descrip nvarchar (500) ☐

Mails_Folders Table

Table ID: 158623608; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆FolderId nvarchar (50) ☐
Descrip nvarchar (500) ☐
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
Generic bit ☐ DEFAULT ((0))
IsInbox bit ☐ DEFAULT ((0))
IsSent bit ☐ DEFAULT ((0))
IsOutbox bit ☐ DEFAULT ((0))
CanSelect bit ☐ DEFAULT ((0))
Parent nvarchar (50) ☒ ⇨ dbo.Mails_Folders.FolderId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Mails_Folders_Accounts Table

Table ID: 190623722; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆MailAccountId nvarchar (100) ☐ ⇨ dbo.Mail_Accounts.MailAccountId
◆FolderId nvarchar (50) ☐ ⇨ dbo.Mails_Folders.FolderId
Sync bit ☐ DEFAULT ((0))
SyncError nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Mails_Objects Table

Table ID: 222623836; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆MessageId nvarchar (250) ☐ ⇨ dbo.Mails.MessageId
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆ObjectId nvarchar (250) ☐
FolderId nvarchar (50) ☒ DEFAULT ('inbox')⇨ dbo.Mails_Folders.FolderId

Mails_Objects_Config Table

Table ID: 254623950; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
KeyProperty nvarchar (150) ☐
EmailField nvarchar (1000) ☒
DomainFilter bit ☐ DEFAULT ((0))
Path nvarchar (500) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Mails_Outbox Table

Table ID: 286624064; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆Id nvarchar (100) ☐ DEFAULT (newid())
FromName nvarchar (100) ☒
FromEmail nvarchar (250) ☐
To nvarchar (max) ☒
CC nvarchar (max) ☒
Subject nvarchar (500) ☐
Body nvarchar (max) ☐
UserId nvarchar (128) ☒
SentDate smalldatetime ☒
SendDate smalldatetime ☒
Status int ☐ DEFAULT ((0))⇨ dbo.Mails_Status.Status
ErrorMsg nvarchar (max) ☒
NotifiedError bit ☐ DEFAULT ((0))
ReplyTo nvarchar (max) ☒
ObjectName nvarchar (50) ☒
ObjectWhere nvarchar (1000) ☒
LinkToId nvarchar (100) ☒

Mails_Outbox_Attachments Table

Table ID: 318624178; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆AttId nvarchar (100) ☐ DEFAULT (newid())
MailId nvarchar (100) ☐ ⇨ dbo.Mails_Outbox.Id
Path nvarchar (500) ☐
FileName nvarchar (500) ☒

Mails_Status Table

Table ID: 350624292; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆Status int ☐
Descrip nvarchar (50) ☒

Mails_Templates Table

Table ID: 382624406; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆Name nvarchar (100) ☐
Body nvarchar (max) ☐
Subject nvarchar (500) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Master_Tables Table

Table ID: 414624520; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TableName nvarchar (250) ☐
Descrip nvarchar (255) ☒
GroupName nvarchar (100) ☐ DEFAULT ('sys-generic')⇨ dbo.Master_Tables_Groups.GroupName
CollectionName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName
Order int ☐ DEFAULT ((0))
ConnStringId nvarchar (50) ☐ ⇨ dbo.DbConnectionStrings.ConnStringId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Master_Tables_Groups Table

Table ID: 446624634; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆GroupName nvarchar (100) ☐
Descrip nvarchar (200) ☐
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName
Order int ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Master_Tables_Properties Table

Table ID: 478624748; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆TableName nvarchar (250) ☐ ⇨ dbo.Master_Tables.TableName
◆FieldName nvarchar (100) ☐
SqlSentence nvarchar (max) ☐
ConnStringId nvarchar (50) ☐ DEFAULT ((0))⇨ dbo.DbConnectionStrings.ConnStringId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Menus Table

Table ID: 510624862; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆MenuId nvarchar (50) ☐ DEFAULT (newid())
Descrip nvarchar (50) ☐
ParentId nvarchar (50) ☒ ⇨ dbo.Menus.MenuId
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Modules Table

Table ID: 542624976; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ModuleName nvarchar (100) ☐
TypeId nvarchar (50) ☐ ⇨ dbo.Modules_Types.TypeId
ClassId nvarchar (50) ☐ ⇨ dbo.Modules_Classification.ClassId
ObjectName nvarchar (50) ☒
ObjectFilter nvarchar (1000) ☒
Descrip nvarchar (250) ☐
Title nvarchar (250) ☐
ContainerId nvarchar (50) ☐ ⇨ dbo.Modules_Containers.ContainerId
CollapsibleButton bit ☐ DEFAULT ((1))
FullscreenButton bit ☐ DEFAULT ((1))
RefreshButton bit ☐ DEFAULT ((1))
SearchButton bit ☐ DEFAULT ((0))
SQlSentence nvarchar (max) ☒
Header nvarchar (max) ☒
HTMLText nvarchar (max) ☒
Footer nvarchar (max) ☒
Empty nvarchar (max) ☒
CssText nvarchar (max) ☒
ScriptText nvarchar (max) ☒
ChartTypeId nvarchar (50) ☒ ⇨ dbo.Modules_ChartsGauges_Types.ChartTypeId
ChartSettingName nvarchar (100) ☒ ⇨ dbo.Charts_Settings.ChartSettingName
Series nvarchar (500) ☒
Labels nvarchar (500) ☒
Value nvarchar (500) ☒
Params nvarchar (255) ☒
JsonOptions nvarchar (500) ☒
Path nvarchar (255) ☒
TransFormFilePath nvarchar (255) ☒
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName
PagerId nvarchar (50) ☒ ⇨ dbo.Modules_Pager_Types.PagerId
PageSize int ☒
ConnStringID nvarchar (50) ☒ ⇨ dbo.DbConnectionStrings.ConnStringId
ToolbarName nvarchar (50) ☒ ⇨ dbo.ToolBars.ToolbarName
GridbarName nvarchar (50) ☒ ⇨ dbo.ToolBars.ToolbarName
TemplateId nvarchar (50) ☒ ⇨ dbo.Objects_Templates.TemplateId
HeaderClass nvarchar (50) ☒
ModuleClass nvarchar (50) ☒
JSAfterLoad nvarchar (500) ☒
Searcher bit ☐ DEFAULT ((0))
ShowWhenNew bit ☒ DEFAULT ((0))
ManualInit bit ☐ DEFAULT ((0))
SchedulerName nvarchar (20) ☒
TimelineSettingName nvarchar (50) ☒ ⇨ dbo.Timelines_Settings.TimelineSettingName
KanbanSettingsName nvarchar (50) ☒ ⇨ dbo.Kanban_Settings.KanbanSettingsName
ChartBackground nvarchar (255) ☒
ChartBorder nvarchar (255) ☒
Reserved bit ☐ DEFAULT ((0))
Cache int ☐ DEFAULT ((0))
Offline bit ☐ DEFAULT ((0))
PresetName nvarchar (50) ☒
MixedChartTypes nvarchar (255) ☒
MixedChartLabels nvarchar (255) ☒
ChartLineBorderDash bit ☐ DEFAULT ((0))
ChartLineFill bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Modules_ChartsGauges_Types Table

Table ID: 574625090; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ChartTypeId nvarchar (50) ☐
Descrip nvarchar (100) ☐
ImageUrl nvarchar (255) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Modules_Classification Table

Table ID: 606625204; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ClassId nvarchar (50) ☐
Descrip nvarchar (255) ☒
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Modules_Containers Table

Table ID: 638625318; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ContainerId nvarchar (50) ☐
Descrip nvarchar (255) ☐
TemplateHtml varchar (max) ☐
CssClass nvarchar (50) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Modules_Events Table

Table ID: 670625432; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ModuleEventId nvarchar (50) ☐ DEFAULT (newid())
ModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
ModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
EventClass nvarchar (50) ☐ ⇨ dbo.Events_Classes_Types.EventClass
EventType nvarchar (50) ☐ ⇨ dbo.Events_Classes_Types.EventType
EventAction nvarchar (50) ☐ ⇨ dbo.Events_Actions.EventAction
ProcessName nvarchar (255) ☒ ⇨ dbo.Processes.ProcessName
ObjectFilter nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
ObjectFilter nvarchar (50) ☒ ⇨ dbo.Objects_Properties.ObjectName
PropertyFilter nvarchar (50) ☒ ⇨ dbo.Objects_Properties.PropertyName
ProcessFilter nvarchar (255) ☒
ModuleFilter nvarchar (100) ☒
PageFilter nvarchar (100) ☒ ⇨ dbo.Pages.PageName
MethodFilter nvarchar (255) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Modules_Pager_Types Table

Table ID: 702625546; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆PagerId nvarchar (50) ☐
Descrip nvarchar (100) ☐
NumButtons int ☐
Template nvarchar (1000) ☐
Position nvarchar (50) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Modules_Types Table

Table ID: 734625660; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId nvarchar (50) ☐
Descrip nvarchar (255) ☐
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName
SettingsTable nvarchar (255) ☒
WebComponent nvarchar (50) ☐
UseCollection bit ☐
Reserved bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Navigation_Nodes Table

Table ID: 766625774; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆NodeId uniqueidentifier ☐ DEFAULT (newid())
ParentNodeId uniqueidentifier ☒ ⇨ dbo.Navigation_Nodes.NodeId
Order int ☐ DEFAULT ((0))
Title nvarchar (255) ☐
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName
Descrip nvarchar (100) ☐
TypeId nvarchar (50) ☐ ⇨ dbo.Navigation_Nodes_Types.TypeId
Params nvarchar (255) ☒
Url nvarchar (255) ☒
TargetId nvarchar (50) ☐ DEFAULT (N'current')⇨ dbo.Targets.TargetId
ProcessName nvarchar (255) ☒ ⇨ dbo.Processes.ProcessName
PageTypeId nvarchar (50) ☒ ⇨ dbo.Pages_Types.TypeId
PageName nvarchar (100) ☒ ⇨ dbo.Pages.PageName
ReportName nvarchar (100) ☒ ⇨ dbo.Reports.ReportName
HelpId nvarchar (50) ☒ ⇨ dbo.Help.HelpId
ReportWhere nvarchar (1000) ☒
ObjectName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
ObjectWhere nvarchar (1000) ☒
Defaults varchar (2000) ☒
SQLSentence nvarchar (max) ☒
SQLConStringId nvarchar (50) ☒ ⇨ dbo.DbConnectionStrings.ConnStringId
WebComponent nvarchar (1000) ☒
TableName nvarchar (250) ☒
BadgeClass nvarchar (100) ☒
BadgeSQL nvarchar (max) ☒
BadgeConStringId nvarchar (50) ☒ ⇨ dbo.DbConnectionStrings.ConnStringId
BadgeRefresh int ☐ DEFAULT ((0))
Enabled bit ☐ DEFAULT ((1))
cssClass nvarchar (250) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Navigation_Nodes_Types Table

Table ID: 798625888; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId nvarchar (50) ☐
Descrip nvarchar (100) ☒
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

News Table

Table ID: 830626002; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆NewsId uniqueidentifier ☐ DEFAULT (newid())
Title nvarchar (255) ☐
TypeId nvarchar (100) ☐ ⇨ dbo.News_Types.NewsTypeId
ImagePath nvarchar (255) ☒
Descrip nvarchar (max) ☒
UrlLink nvarchar (255) ☒
PublicationDate smalldatetime ☐
EndDate smalldatetime ☒
UserId nvarchar (128) ☒
PublicArticle bit ☐
Publish bit ☐
Alert bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

News_ReadBy Table

Table ID: 862626116; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆NewsId uniqueidentifier ☐ ⇨ dbo.News.NewsId
◆UserId nvarchar (128) ☐

News_Types Table

Table ID: 894626230; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆NewsTypeId nvarchar (100) ☐
Descrip nvarchar (255) ☒
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Notices Table

Table ID: 926626344; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆NoticeId nvarchar (100) ☐ DEFAULT (newid())
Title nvarchar (500) ☐
Message nvarchar (1000) ☐
AfterClickEvent nvarchar (max) ☒
ReminderTime smalldatetime ☐
ExpiryTime smalldatetime ☐
MethodName nvarchar (15) ☐ ⇨ dbo.Notices_Methods.MethodName
CausesSync bit ☐ DEFAULT ((0))
AllUsers bit ☐ DEFAULT ((0))
AllUsersIsSent bit ☐ DEFAULT ((0))
Error bit ☐ DEFAULT ((0))
ErrorMsg varchar (max) ☒
CSSClass nvarchar (125) ☒
InsertDate datetime ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())
TypeId nvarchar (50) ☐ DEFAULT (N'text')
Params nvarchar (255) ☒
Url nvarchar (255) ☒
TargetId nvarchar (50) ☐ DEFAULT (N'current')
ProcessName nvarchar (255) ☒
PageTypeId nvarchar (50) ☒
PageName nvarchar (100) ☒
ReportName nvarchar (100) ☒
HelpId nvarchar (50) ☒
ReportWhere nvarchar (1000) ☒
ObjectName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
ObjectWhere nvarchar (1000) ☒
SQLSentence nvarchar (max) ☒
SQLConStringId nvarchar (50) ☒
WebComponent nvarchar (1000) ☒
TableName nvarchar (250) ☒

Notices_Methods Table

Table ID: 958626458; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆MethodName nvarchar (15) ☐
Descrip nvarchar (15) ☐
IconName nvarchar (100) ☐ ⇨ dbo.Icons.IconName

Notices_Sentences Table

Table ID: 990626572; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆SentenceId nvarchar (100) ☐ DEFAULT (newid())
Decrip nvarchar (250) ☒
MailSentence nvarchar (max) ☒
NoticeSentence nvarchar (max) ☒
NoticeAllUsers bit ☐ DEFAULT ((0))
NoticeUsersSentence nvarchar (max) ☒
UpdateNoticeSentence nvarchar (max) ☒
UpdateMailSentence nvarchar (max) ☒
ConnStringId nvarchar (50) ☐ ⇨ dbo.DbConnectionStrings.ConnStringId
JobName nvarchar (50) ☒ ⇨ dbo.Jobs.JobName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Notices_Users Table

Table ID: 1022626686; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Id nvarchar (100) ☐ DEFAULT (newid())
NoticeId nvarchar (100) ☐ ⇨ dbo.Notices.NoticeId
UserId nvarchar (128) ☒ ⇨ dbo.AspNetUsers.Id
CurrentReference nvarchar (50) ☒
IsSent bit ☐ DEFAULT ((0))
IsRead bit ☐ DEFAULT ((0))
Error bit ☐ DEFAULT ((0))
ErrorMsg varchar (max) ☒

Objects Table

Table ID: 1054626800; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐
Iscollection bit ☐
ObjectChildName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
TableName nvarchar (255) ☐
WhereSentence nvarchar (1000) ☒
ConfigDB bit ☐
OrderBy varchar (100) ☒
Descrip nvarchar (255) ☐
IconName nvarchar (100) ☐ ⇨ dbo.Icons.IconName
UniqueIdentifierField nvarchar (50) ☒
ShowDefaultMenu bit ☐ DEFAULT ((0))
DefaultPageSize int ☐ DEFAULT ((200))
ParsedDescrip nvarchar (255) ☐
Auditable int ☐ DEFAULT ((0))
Active bit ☐
CanInsert bit ☐ DEFAULT ((1))
CanUpdate bit ☐ DEFAULT ((1))
CanDelete bit ☐ DEFAULT ((1))
CanView bit ☐ DEFAULT ((1))
CanPrint bit ☐ DEFAULT ((1))
InsertType nvarchar (10) ☐ DEFAULT ('standard')⇨ dbo.DbUpdateTypes.UpdateTypeId
UpdateType nvarchar (10) ☐ DEFAULT ('standard')
DeleteType nvarchar (10) ☐ DEFAULT ('standard')⇨ dbo.DbUpdateTypes.UpdateTypeId
InsertProcessName nvarchar (255) ☒
UpdateProcessName nvarchar (255) ☒
DeleteProcessName nvarchar (255) ☒
LoadProcessName nvarchar (255) ☒
InsertTriggerEvent bit ☐ DEFAULT ((0))
UpdateTriggerEvent bit ☐ DEFAULT ((0))
DeleteTriggerEvent bit ☐ DEFAULT ((0))
HelpId nvarchar (50) ☒ ⇨ dbo.Help.HelpId
OverrideObjectName nvarchar (50) ☒
OverrideObjectWhere nvarchar (1000) ☒
NavigateNodeId uniqueidentifier ☒ ⇨ dbo.Navigation_Nodes.NodeId
Clonable bit ☐ DEFAULT ((1))
ViewKeys nvarchar (100) ☒
IgnoreDBRequired bit ☐ DEFAULT ((0))
ConnStringID nvarchar (50) ☐ ⇨ dbo.DbConnectionStrings.ConnStringId
TransactionOn bit ☐ DEFAULT ((1))
InsertFlowText nvarchar (500) ☒
UpdateFlowText nvarchar (500) ☒
DeleteFlowText nvarchar (500) ☒
Offline bit ☐ DEFAULT ((0))
BeforeUpdate nvarchar (255) ☒
BeforeInsert nvarchar (255) ☒
BeforeDelete nvarchar (255) ☒
AfterUpdate nvarchar (255) ☒
AfterInsert nvarchar (255) ☒
AfterDelete nvarchar (255) ☒
Reserved bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Additional_Tables Table

Table ID: 1086626914; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆TableName nvarchar (255) ☐
KeyMap nvarchar (255) ☒
Descrip nvarchar (255) ☐
InsertType nvarchar (10) ☐ DEFAULT ('nothing')⇨ dbo.DbUpdateTypes.UpdateTypeId
UpdateType nvarchar (10) ☐ DEFAULT ('nothing')⇨ dbo.DbUpdateTypes.UpdateTypeId
DeleteType nvarchar (10) ☐ DEFAULT ('nothing')⇨ dbo.DbUpdateTypes.UpdateTypeId
InsertProcessName nvarchar (255) ☒
UpdateProcessName nvarchar (255) ☒
DeleteProcessName nvarchar (255) ☒
ConnStringId nvarchar (50) ☐ ⇨ dbo.DbConnectionStrings.ConnStringId
Offline bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Images Table

Table ID: 1118627028; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ImageId uniqueidentifier ☐ DEFAULT (newid())
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
ObjectId nvarchar (170) ☐
Name nvarchar (255) ☐
Descrip nvarchar (255) ☒
ImageClassId nvarchar (50) ☐ DEFAULT (N'sysimg-generic')⇨ dbo.Objects_Images_Classification.ImageClassId
MainImage bit ☐ DEFAULT ((0))
OrderNumber int ☐ DEFAULT ((0))
Path nvarchar (300) ☐
CreationDate smalldatetime ☒ DEFAULT (getdate())

Objects_Images_Classification Table

Table ID: 1150627142; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ImageClassId nvarchar (50) ☐
Descrip nvarchar (150) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Images_Recognition Table

Table ID: 1182627256; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:32
Name Type NULL Comment
◆ImageId uniqueidentifier ☐ DEFAULT (newid())
ObjectName nvarchar (50) ☐
ObjectId nvarchar (170) ☐
Name nvarchar (255) ☐
OrderNumber int ☐ DEFAULT ((0))
Path nvarchar (300) ☐
FaceEncodings nvarchar (max) ☒
LastError nvarchar (max) ☒

Objects_Images_Recognition_Settings Table

Table ID: 1214627370; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐
◆KeyProperty nvarchar (150) ☐
RootPath nvarchar (250) ☐
Models nvarchar (250) ☐
ExtensionId nvarchar (100) ☒ DEFAULT (N'sysImages')⇨ dbo.Extensions.ExtensionId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Images_Settings Table

Table ID: 1246627484; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆KeyProperty nvarchar (150) ☐
RootPath nvarchar (250) ☐
TypeId nvarchar (50) ☐ DEFAULT ('flexygo')⇨ dbo.Documents_Objects_Config_Types.TypeId
ERPObjectName nvarchar (250) ☒
DefaultCategoryId nvarchar (50) ☒
ExtensionId nvarchar (100) ☒ DEFAULT (N'sysImages')⇨ dbo.Extensions.ExtensionId
OfflineFilter nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Interfaces Table

Table ID: 1278627598; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆InterfaceName nvarchar (100) ☐ ⇨ dbo.Interfaces.InterfaceName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Objects Table

Table ID: 1310627712; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆ChildCollection nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
ObjectRelation nvarchar (255) ☐
ObjectDefaults nvarchar (255) ☒
ShowInMenu bit ☐ DEFAULT ((1))
ShowInAnalysis bit ☐ DEFAULT ((1))
OneToOneRelation bit ☐ DEFAULT ((0))
Order int ☐ DEFAULT ((0))
RemoveOnDelete bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Presets Table

Table ID: 1342627826; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆PresetName nvarchar (50) ☐
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
Title nvarchar (250) ☐
Filter nvarchar (max) ☐
IconName nvarchar (100) ☐ ⇨ dbo.Icons.IconName
IconClass nvarchar (100) ☒
TitleClass nvarchar (100) ☒
Order int ☐ DEFAULT ((0))
Offline bit ☐ DEFAULT ((0))
Originid int ☒ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Processes Table

Table ID: 1374627940; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
MenuId nvarchar (50) ☐ ⇨ dbo.Menus.MenuId
Order int ☐ DEFAULT ((0))
Active bit ☐ DEFAULT ((1))
SQLEnabled nvarchar (max) ☒
SQLEnabledDescrip nvarchar (255) ☒
EnabledProperty nvarchar (50) ☒
EnabledValues nvarchar (max) ☒
DisabledValues nvarchar (max) ☒
BagOnly bit ☐ DEFAULT ((0))
ClearSelectionBag bit ☐ DEFAULT ((1))
Offline bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Processes_Interfaces Table

Table ID: 1406628054; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
◆InterfaceName nvarchar (100) ☐ ⇨ dbo.Interfaces.InterfaceName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Properties Table

Table ID: 1438628168; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆PropertyName nvarchar (50) ☐
Label varchar (250) ☐
PositionY smallint ☐ DEFAULT ((0))
PositionX smallint ☐ DEFAULT ((0))
Width smallint ☐ DEFAULT ((1))
Height smallint ☐ DEFAULT ((1))
Hide bit ☐ DEFAULT ((0))
ClientReadOnly bit ☐ DEFAULT ((0))
FormDisplay bit ☐ DEFAULT ((1))
TypeId nvarchar (50) ☐ ⇨ dbo.Objects_Properties_Types.TypeId
Locked bit ☐ DEFAULT ((0))
CustomPropName nvarchar (50) ☒ ⇨ dbo.Objects_Properties_Templates.CustomPropName
Mask nvarchar (250) ☒
SQlSentence nvarchar (max) ☒
SQLEditSentence nvarchar (max) ☒
SQLFilter nvarchar (1000) ☒
SQLValueField nvarchar (100) ☒
SQLDisplayField nvarchar (500) ☒
SQLObjectName nvarchar (50) ☒
SQLViewName nvarchar (255) ☒
SQLOfflineSentence nvarchar (max) ☒
SQLOfflineOrderBy nvarchar (max) ☒
WhereSentence nvarchar (1000) ☒
DefaultValue nvarchar (250) ☒
PersistDefaultValue bit ☐ DEFAULT ((0))
IgnoreDBDefaultValue bit ☐ DEFAULT ((0))
DetachedFromDB bit ☐ DEFAULT ((0))
SearchFunction nvarchar (250) ☒
SearchCollection nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
SearchWhere nvarchar (500) ☒
SearchReturnFields nvarchar (250) ☒
SecurityObject nvarchar (50) ☒
AllowNew nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
AllowNewFunction nvarchar (250) ☒
AllowNewReturnFields nvarchar (250) ☒
AllowNewDefaults nvarchar (500) ☒
ObjNameLink nvarchar (50) ☒
ObjWhereLink nvarchar (1000) ☒
TargetIdLink nvarchar (50) ☒ DEFAULT ('popup')
Style nvarchar (100) ☒
CSSClass nvarchar (100) ☒
LabelStyle nvarchar (100) ☒
LabelCSSClass nvarchar (100) ☒
DecimalPlaces int ☒
RootPath nvarchar (255) ☒
FormatString nvarchar (100) ☒
DirectTemplate nvarchar (max) ☒
Tag varchar (500) ☒
HelpId nvarchar (50) ☒ ⇨ dbo.Help.HelpId
ConnStringId nvarchar (50) ☒ ⇨ dbo.DbConnectionStrings.ConnStringId
IsRequired bit ☐ DEFAULT ((0))
IsRequiredMessage nvarchar (255) ☒
minValue nvarchar (50) ☒
minValueMessage nvarchar (255) ☒
maxValue nvarchar (50) ☒
maxValueMessage nvarchar (255) ☒
RegExp nvarchar (500) ☒
RegExpText nvarchar (50) ☒
SQLValidator nvarchar (500) ☒
ValidatorMessage nvarchar (255) ☒
OnChangeJsFunction nvarchar (500) ☒
OnChangeProcessName nvarchar (255) ☒
PlaceHolder nvarchar (100) ☒
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
ToolbarName nvarchar (50) ☒ ⇨ dbo.ToolBars.ToolbarName
Separator nvarchar (1) ☒ DEFAULT (N'|')
AutoIncrement bit ☐ DEFAULT ((0))
AutoIncrementFunction nvarchar (1000) ☒
CascadeDependencies bit ☒ DEFAULT ((0))
RootPathType nvarchar (25) ☒ DEFAULT (N'RelativePath')⇨ dbo.Root_Path_Types.TypeId
PageSize int ☒
ImageCompressionType smallint ☒ ⇨ dbo.Image_Compression_Types.TypeId
ImageMaxWidth smallint ☒
ImageMaxHeight smallint ☒
Offline bit ☐ DEFAULT ((0))
ExtensionId nvarchar (100) ☒ DEFAULT (N'sysAll')⇨ dbo.Extensions.ExtensionId
Autoselect bit ☒ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Properties_Dependencies Table

Table ID: 1470628282; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.ObjectName
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.ObjectName
◆PropertyName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.PropertyName
◆DependingPropertyName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.PropertyName
Order int ☐ DEFAULT ((0))
Active bit ☐ DEFAULT ((1))
Descrip nvarchar (255) ☒
SQLValue nvarchar (max) ☒
SQLComboSentence nvarchar (max) ☒
SQLComboFilter nvarchar (max) ☒
SQLEnabled nvarchar (max) ☒
EnabledValues nvarchar (max) ☒
DisabledValues nvarchar (max) ☒
SQLVisible nvarchar (max) ☒
VisibleValues nvarchar (max) ☒
HiddenValues nvarchar (max) ☒
SQLClass nvarchar (max) ☒
SQLRequired nvarchar (max) ☒
RequiredValues nvarchar (max) ☒
NotRequiredValues nvarchar (max) ☒
PropertyValue nvarchar (max) ☒
CusPropName nvarchar (max) ☒
SQLCustomProperty nvarchar (max) ☒
ConnStringId nvarchar (255) ☒
Offline bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Properties_Templates Table

Table ID: 1502628396; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆CustomPropName nvarchar (50) ☐
Descrip nvarchar (100) ☒
TypeId nvarchar (50) ☐ DEFAULT ('dbcombo')⇨ dbo.Objects_Properties_Types.TypeId
Mask nvarchar (250) ☒
SQlSentence nvarchar (max) ☒
SQLEditSentence nvarchar (max) ☒
SQLFilter nvarchar (1000) ☒
SQLValueField nvarchar (100) ☒
SQLDisplayField nvarchar (500) ☒
SQLObjectName nvarchar (50) ☒
SQLViewName nvarchar (255) ☒
SQLOfflineSentence nvarchar (max) ☒
SQLOfflineOrderBy nvarchar (max) ☒
WhereSentence nvarchar (1000) ☒
Label varchar (250) ☐
Width smallint ☐ DEFAULT ((1))
Height smallint ☐ DEFAULT ((1))
DefaultValue nvarchar (250) ☒
PersistDefaultValue bit ☐ DEFAULT ((0))
IgnoreDBDefaultValue bit ☐ DEFAULT ((0))
DetachedFromDB bit ☐ DEFAULT ((0))
SearchFunction nvarchar (250) ☒
SearchCollection nvarchar (50) ☒
SearchWhere nvarchar (500) ☒
SearchReturnFields nvarchar (250) ☒
SecurityObject nvarchar (50) ☒
AllowNew nvarchar (50) ☒
AllowNewFunction nvarchar (250) ☒
AllowNewReturnFields nvarchar (250) ☒
AllowNewDefaults nvarchar (500) ☒
ObjNameLink nvarchar (50) ☒
ObjWhereLink nvarchar (1000) ☒
TargetIdLink nvarchar (50) ☒ DEFAULT ('popup')
Style nvarchar (100) ☒
CSSClass nvarchar (100) ☒
LabelStyle nvarchar (100) ☒
LabelCSSClass nvarchar (100) ☒
DecimalPlaces int ☒
RootPath nvarchar (255) ☒
FormatString nvarchar (100) ☒
DirectTemplate nvarchar (max) ☒
Tag varchar (50) ☒
HelpId nvarchar (50) ☒ ⇨ dbo.Help.HelpId
ConnStringId nvarchar (50) ☒ ⇨ dbo.DbConnectionStrings.ConnStringId
IsRequired bit ☐ DEFAULT ((0))
IsRequiredMessage nvarchar (255) ☒
minValue nvarchar (50) ☒
minValueMessage nvarchar (255) ☒
maxValue nvarchar (50) ☒
maxValueMessage nvarchar (255) ☒
RegExp nvarchar (500) ☒
RegExpText nvarchar (50) ☒
SQLValidator nvarchar (500) ☒
ValidatorMessage nvarchar (255) ☒
OnChangeJsFunction nvarchar (500) ☒
OnChangeProcessName nvarchar (255) ☒
PlaceHolder nvarchar (100) ☒
IconName nvarchar (100) ☒
Separator nvarchar (1) ☒ DEFAULT (N'|')
PageSize int ☒
ImageCompressionType smallint ☒ ⇨ dbo.Image_Compression_Types.TypeId
ImageMaxWidth smallint ☒
ImageMaxHeight smallint ☒
Offline bit ☐ DEFAULT ((0))
ExtensionId nvarchar (100) ☒ DEFAULT (N'sysAll')⇨ dbo.Extensions.ExtensionId
Autoselect bit ☒ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Properties_Types Table

Table ID: 1534628510; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId nvarchar (50) ☐
Descrip nvarchar (255) ☐
WebComponent nvarchar (50) ☐
OfflineWebComponent nvarchar (50) ☒
DefaultSize int ☐
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())
SearchTypes nvarchar (500) ☐ DEFAULT (N'text')
DefaultSearchType nvarchar (50) ☐ DEFAULT (N'text')
ShowInObjects bit ☐ DEFAULT ((1))
ShowInProcesses bit ☐ DEFAULT ((1))
ShowInReports bit ☐ DEFAULT ((1))

Objects_Reports Table

Table ID: 1566628624; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ReportName nvarchar (100) ☐ ⇨ dbo.Reports.ReportName
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
SQLEnabled nvarchar (max) ☒
SQLEnabledDescrip nvarchar (255) ☒
EnabledProperty nvarchar (50) ☒
EnabledValues nvarchar (max) ☒
DisabledValues nvarchar (max) ☒
Active bit ☐ DEFAULT ((1))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Search Table

Table ID: 1598628738; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆SearchId uniqueidentifier ☐ DEFAULT (newid())
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
Name nvarchar (100) ☐
Generic bit ☐ DEFAULT ((0))
IsDefault bit ☐ DEFAULT ((0))
Type nvarchar (20) ☐ ⇨ dbo.Objects_Search_Types.Type
Order int ☐ DEFAULT ((0))
UserId nvarchar (128) ☒ ⇨ dbo.AspNetUsers.Id
SQLSentence nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Search_Properties Table

Table ID: 1630628852; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆SearchId uniqueidentifier ☐ ⇨ dbo.Objects_Search.SearchId
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.ObjectName
◆PropertyName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.PropertyName
ObjectPath nvarchar (500) ☐
Size int ☐ DEFAULT ((2))
Order int ☐ DEFAULT ((0))
Label nvarchar (250) ☐
PropertySearchType nvarchar (20) ☐ ⇨ dbo.Objects_Search_Properties_Types.PropertySearchType
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Search_Properties_Types Table

Table ID: 1662628966; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆PropertySearchType nvarchar (20) ☐
Descrip nvarchar (255) ☐
WebComponent nvarchar (50) ☐
DefaultSize int ☐
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Search_Types Table

Table ID: 1694629080; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Type nvarchar (20) ☐

Objects_Search_Users_Settings Table

Table ID: 1726629194; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆SearchId uniqueidentifier ☐ ⇨ dbo.Objects_Search.SearchId
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
Enabled bit ☐
Order int ☐ DEFAULT ((0))

Objects_Search_Users_Values Table

Table ID: 1758629308; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆Id int ☐
SearchId uniqueidentifier ☐ ⇨ dbo.Objects_Search.SearchId
Name nvarchar (250) ☐
UserId nvarchar (128) ☐
Values nvarchar (max) ☐
Generic bit ☐ DEFAULT ((0))

Objects_Selection Table

Table ID: 1790629422; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆Id int ☐ IDENTITY
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
Descrip nvarchar (255) ☐
UniquePropertyName nvarchar (50) ☐
Active bit ☐
UserId nvarchar (128) ☐

Objects_Selection_Items Table

Table ID: 1822629536; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆Id int ☐ ⇨ dbo.Objects_Selection.Id
◆ItemId nvarchar (255) ☐

Objects_Templates Table

Table ID: 1854629650; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆TemplateId nvarchar (50) ☐
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Views.ObjectName
TypeId nvarchar (50) ☐ ⇨ dbo.Objects_Templates_Types.TypeId
Descrip nvarchar (500) ☐
Body nvarchar (max) ☐
ViewName nvarchar (255) ☒ ⇨ dbo.Objects_Views.ViewName
WhereSentence nvarchar (1000) ☒
Header nvarchar (max) ☒
Footer nvarchar (max) ☒
Empty nvarchar (max) ☒
ModuleClass nvarchar (100) ☒
IsDefault bit ☐ DEFAULT ((0))
Offline bit ☐ DEFAULT ((0))
UserDefinedGroups bit ☐ DEFAULT ((0))
Active bit ☐ DEFAULT ((1))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Templates_Groups Table

Table ID: 1886629764; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆TemplateId nvarchar (50) ☐ ⇨ dbo.Objects_Templates.TemplateId
◆GroupField nvarchar (50) ☐
Order int ☐ DEFAULT ((0))
OrderType nvarchar (4) ☐ DEFAULT ('ASC')
Header nvarchar (max) ☒
Footer nvarchar (max) ☒
Offline bit ☐ DEFAULT ((0))
Label varchar (250) ☒
UserDefault bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Templates_Samples Table

Table ID: 1918629878; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆SampleId nvarchar (150) ☐
TypeId nvarchar (50) ☐ ⇨ dbo.Objects_Templates_Types.TypeId
Descrip nvarchar (500) ☐
Body nvarchar (max) ☐
Header nvarchar (max) ☒
Footer nvarchar (max) ☒
Empty nvarchar (max) ☒
Img nvarchar (250) ☐
Offline bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Templates_Types Table

Table ID: 1950629992; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆TypeId nvarchar (50) ☐
Descrip nvarchar (100) ☐
Body nvarchar (max) ☐
Header varchar (max) ☒
Footer varchar (max) ☒
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Views Table

Table ID: 1982630106; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆ViewName nvarchar (255) ☐
Descrip nvarchar (255) ☐
ConnStringId nvarchar (50) ☐ ⇨ dbo.DbConnectionStrings.ConnStringId
SQLSentence nvarchar (max) ☐
NoFilter bit ☐ DEFAULT ((0))
ShowAsGrid bit ☐ DEFAULT ((0))
Active bit ☐ DEFAULT ((1))
System bit ☐ DEFAULT ((0))
IsDefault bit ☐ DEFAULT ((0))
OrderBy nvarchar (max) ☒
Offline bit ☐ DEFAULT ((0))
PrimaryKeys nvarchar (max) ☒
IndexFields nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Views_Properties Table

Table ID: 2014630220; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Views.ObjectName
◆ViewName nvarchar (255) ☐ ⇨ dbo.Objects_Views.ViewName
◆ObjectPropertyName nvarchar (50) ☐
◆PropertyName nvarchar (50) ☐
ObjectPath nvarchar (500) ☐
Order int ☐ DEFAULT ((0))
Label nvarchar (250) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Objects_Workflows_Areas Table

Table ID: 2046630334; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆WorkflowAreaId nvarchar (50) ☐ ⇨ dbo.Workflows_Areas.WorkflowAreaId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Offline_Apps Table

Table ID: 2078630448; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆AppName nvarchar (50) ☐
Title nvarchar (50) ☐
Descrip nvarchar (max) ☒
IconName nvarchar (100) ☐ ⇨ dbo.Icons.IconName
APKUrl nvarchar (600) ☒
APKWebService nvarchar (600) ☒
SyncDataProcessName nvarchar (255) ☒
Active bit ☐ DEFAULT ((1))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Offline_Files Table

Table ID: 2110630562; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆FileName nvarchar (150) ☐
AppName nvarchar (50) ☐ ⇨ dbo.Offline_Apps.AppName
FilePath nvarchar (500) ☐
FileDate smalldatetime ☐
Enabled bit ☐ DEFAULT ((1))
OriginID int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Offline_Menus Table

Table ID: 2142630676; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆MenuId uniqueidentifier ☐ DEFAULT (newid())
AppName nvarchar (50) ☒ ⇨ dbo.Offline_Apps.AppName
ParentMenuId uniqueidentifier ☒
Order int ☐
Title nvarchar (255) ☐
IconName nvarchar (100) ☒
Descrip nvarchar (255) ☒
TypeId nvarchar (50) ☐
Url nvarchar (255) ☒
ProcessName nvarchar (255) ☒
PageTypeId nvarchar (50) ☒
PageName nvarchar (100) ☒
ObjectName nvarchar (50) ☒
ObjectWhere nvarchar (1000) ☒
Enabled bit ☐ DEFAULT ((1))
cssClass nvarchar (255) ☒
OriginID int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Offline_Menus_Types Table

Table ID: 27147142; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆TypeId nvarchar (50) ☐
Descrip nvarchar (100) ☒
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Offline_Objects Table

Table ID: 59147256; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆AppName nvarchar (50) ☐ ⇨ dbo.Offline_Apps.AppName
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
BufferSize int ☐ DEFAULT ((500))
UpdateRelatedPrimaryKeys bit ☐ DEFAULT ((1))
SyncImmediately bit ☐ DEFAULT ((0))
SendData bit ☐ DEFAULT ((1))
GetData bit ☐ DEFAULT ((1))
TableName nvarchar (255) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Offline_Pages Table

Table ID: 91147370; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆AppName nvarchar (50) ☐ ⇨ dbo.Offline_Apps.AppName
◆PageName nvarchar (50) ☐
ObjectName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
TypeId nvarchar (50) ☐
Title nvarchar (150) ☐
Body nvarchar (max) ☐
Header nvarchar (max) ☒
Footer nvarchar (max) ☒
Empty nvarchar (max) ☒
SQLSentence nvarchar (max) ☒
SQLAdditionalWhere nvarchar (max) ☒
SQLOrderBy nvarchar (max) ☒
SQLSearchFilter nvarchar (max) ☒
IsDefault bit ☐ DEFAULT ((0))
ShowSearchBar bit ☐ DEFAULT ((0))
JSAfterLoad nvarchar (500) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Offline_Pages_Groups Table

Table ID: 123147484; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆AppName nvarchar (50) ☐ ⇨ dbo.Offline_Pages.AppName
◆PageName nvarchar (50) ☐ ⇨ dbo.Offline_Pages.PageName
◆GroupField nvarchar (50) ☐
Order int ☐ DEFAULT ((0))
OrderType nvarchar (4) ☐ DEFAULT ('ASC')
Header nvarchar (max) ☒
Footer nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Offline_Scripts Table

Table ID: 155147598; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆AppName nvarchar (50) ☐ ⇨ dbo.Offline_Apps.AppName
◆Name nvarchar (50) ☐
JSScript nvarchar (max) ☐
Enabled bit ☐ DEFAULT ((1))
Order int ☐ DEFAULT ((0))
LastChange datetime ☐ DEFAULT (getdate())
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Offline_Styles Table

Table ID: 187147712; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆AppName nvarchar (50) ☐ ⇨ dbo.Offline_Apps.AppName
◆Name nvarchar (50) ☐
CSSCode nvarchar (max) ☐
Enabled bit ☐ DEFAULT ((1))
Order int ☐ DEFAULT ((0))
LastChange datetime ☐ DEFAULT (getdate())
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Offline_Sync Table

Table ID: 219147826; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆SyncId nvarchar (100) ☐ DEFAULT (newid())
AppName nvarchar (50) ☐ ⇨ dbo.Offline_Apps.AppName
SyncDate smalldatetime ☐ DEFAULT (getdate())
Username nvarchar (150) ☐
Finished bit ☐ DEFAULT ((0))
FinishDate smalldatetime ☒
Error bit ☐ DEFAULT ((0))
ErrorDesc nvarchar (max) ☒

Offline_Sync_Tables Table

Table ID: 251147940; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆SyncId nvarchar (100) ☐ DEFAULT (newid())⇨ dbo.Offline_Sync.SyncId
◆TableName nvarchar (250) ☐
◆PageNumber int ☐
JsonValue nvarchar (max) ☐

Origins Table

Table ID: 283148054; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆OriginId int ☐
Descrip nvarchar (50) ☐
Active bit ☐

Pages Table

Table ID: 315148168; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆PageName nvarchar (100) ☐ DEFAULT (newid())
TypeId nvarchar (50) ☒ ⇨ dbo.Pages_Types.TypeId
ObjectName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
InterfaceName nvarchar (100) ☒ ⇨ dbo.Interfaces.InterfaceName
LayoutName nvarchar (100) ☐ DEFAULT (N'default')⇨ dbo.Layouts.LayoutName
Name nvarchar (255) ☐
IconName nvarchar (100) ☒ DEFAULT (N'noicon')⇨ dbo.Icons.IconName
Descrip nvarchar (100) ☐
UrlRewrite nvarchar (255) ☒
Script nvarchar (max) ☒
ScriptActive bit ☐ DEFAULT ((0))
Style nvarchar (1000) ☒
RefreshInterval int ☒ DEFAULT ((0))
Sytem bit ☐ DEFAULT ((0))
Generic bit ☒ DEFAULT ((0))
BodyCssClass nvarchar (200) ☒
Offline bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Pages_Modules Table

Table ID: 347148282; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆PageName nvarchar (100) ☐ ⇨ dbo.Pages.PageName
◆ModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
LayoutPositionId nvarchar (50) ☐
RelationWhere nvarchar (1000) ☒
Order int ☒ DEFAULT ((0))
SQlEnabled nvarchar (max) ☒
SQLEnabledDescrip nvarchar (250) ☒
Title nvarchar (250) ☒
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
HeaderClass nvarchar (50) ☒
ModuleClass nvarchar (50) ☒
ConnStringID nvarchar (50) ☒ ⇨ dbo.DbConnectionStrings.ConnStringId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Pages_Modules_Tabs Table

Table ID: 379148396; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆TabModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
◆ModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
Order int ☒ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Pages_Types Table

Table ID: 411148510; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId nvarchar (50) ☐
Descrip nvarchar (100) ☐
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Plugins Table

Table ID: 443148624; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆PluginId uniqueidentifier ☐ DEFAULT (newid())
Path nvarchar (500) ☐
Descrip nvarchar (100) ☐
Order int ☐ DEFAULT ((100))
typeId int ☐ DEFAULT ((0))⇨ dbo.Plugins_Types.TypeId
Bundle bit ☐ DEFAULT ((1))
Enabled bit ☐ DEFAULT ((1))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Plugins_Types Table

Table ID: 475148738; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆TypeId int ☐
Descrip nvarchar (100) ☐

Processes Table

Table ID: 507148852; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ProcessName nvarchar (255) ☐
TypeId int ☐ ⇨ dbo.Processes_Types.TypeId
ClassId nvarchar (50) ☐ ⇨ dbo.Processes_Classification.ClassId
ConfirmText varchar (200) ☒
ProcessDescrip nvarchar (500) ☒
ParamsDescrip nvarchar (500) ☒
ReturnDescrip nvarchar (500) ☒
JSforParams varchar (500) ☒
File varchar (255) ☒
Class varchar (255) ☒
Method varchar (50) ☒
StoredName varchar (255) ☒
Code varchar (max) ☒
ExternalUrl varchar (255) ☒
PageTypeId nvarchar (50) ☒ ⇨ dbo.Pages_Types.TypeId
PageName nvarchar (100) ☒ ⇨ dbo.Pages.PageName
ReportName nvarchar (100) ☒ ⇨ dbo.Reports.ReportName
HelpId uniqueidentifier ☒
ReportWhere nvarchar (1000) ☒
ObjectName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
ObjectWhere nvarchar (1000) ☒
Defaults varchar (2000) ☒
TimeOut int ☐ DEFAULT ((0))
ConnStringId nvarchar (255) ☒
TargetId nvarchar (50) ☐ DEFAULT (N'current')⇨ dbo.Targets.TargetId
ProcessFlowText nvarchar (500) ☒
Auditable bit ☐ DEFAULT ((1))
Refresh bit ☐ DEFAULT ((1))
IsTransacted bit ☐ DEFAULT ((0))
AdminOnly bit ☐ DEFAULT ((0))
ConfirmOkText bit ☐ DEFAULT ((1))
CloseDialogOnOk bit ☐ DEFAULT ((0))
RunButtonText nvarchar (100) ☒
LoadProcessName nvarchar (255) ☒ ⇨ dbo.Processes.ProcessName
GipeParams bit ☐ DEFAULT ((0))
Summary nvarchar (max) ☒
ReturnTableNames nvarchar (max) ☒
Reserved bit ☐ DEFAULT ((0))
Offline bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Processes_Classification Table

Table ID: 539148966; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆ClassId nvarchar (50) ☐
Descrip nvarchar (255) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Processes_Objects Table

Table ID: 571149080; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
Offline bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Processes_Params Table

Table ID: 603149194; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
◆ParamName nvarchar (50) ☐
Hide bit ☐ DEFAULT ((0))
ParamTypeId nvarchar (50) ☐ ⇨ dbo.Processes_Params_Types.ParamTypeId
TableName nvarchar (250) ☒
ObjectName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
DefaultValue nvarchar (250) ☒
Label varchar (250) ☐
IOTypeId nvarchar (5) ☒ ⇨ dbo.Processes_Params_TypeIO.IOTypeId
PositionX smallint ☐ DEFAULT ((0))
PositionY smallint ☐ DEFAULT ((0))
Width smallint ☐ DEFAULT ((1))
Height smallint ☐ DEFAULT ((1))
TypeId nvarchar (50) ☐ ⇨ dbo.Objects_Properties_Types.TypeId
Locked bit ☐ DEFAULT ((0))
CustomPropName nvarchar (50) ☒
Mask nvarchar (250) ☒
SQlSentence nvarchar (max) ☒
SQLFilter nvarchar (1000) ☒
SQLValueField nvarchar (100) ☒
SQLDisplayField nvarchar (500) ☒
SQLObjectName nvarchar (50) ☒
SQLViewName nvarchar (255) ☒
SQLOfflineSentence nvarchar (max) ☒
SQLOfflineOrderBy nvarchar (max) ☒
WhereSentence nvarchar (1000) ☒
DetachedFromProcess bit ☐ DEFAULT ((0))
SearchFunction nvarchar (250) ☒
SearchCollection nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
SearchWhere nvarchar (500) ☒
SearchReturnFields nvarchar (250) ☒
SecurityObject nvarchar (50) ☒
AllowNew nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
AllowNewFunction nvarchar (250) ☒
AllowNewReturnFields nvarchar (250) ☒
AllowNewDefaults nvarchar (500) ☒
ObjNameLink nvarchar (50) ☒
ObjWhereLink nvarchar (1000) ☒
TargetIdLink nvarchar (50) ☒ DEFAULT ((0))
Style nvarchar (100) ☒
CSSClass nvarchar (100) ☒
LabelStyle nvarchar (100) ☒
LabelCSSClass nvarchar (100) ☒
DecimalPlaces int ☒
RootPath nvarchar (255) ☒
FormatString nvarchar (100) ☒
DirectTemplate nvarchar (500) ☒
Tag varchar (500) ☒
HelpId nvarchar (50) ☒ ⇨ dbo.Help.HelpId
ConnStringId nvarchar (50) ☒ ⇨ dbo.DbConnectionStrings.ConnStringId
IsRequired bit ☐ DEFAULT ((0))
IsRequiredMessage nvarchar (255) ☒
minValue nvarchar (50) ☒
minValueMessage nvarchar (255) ☒
maxValue nvarchar (50) ☒
maxValueMessage nvarchar (255) ☒
RegExp nvarchar (500) ☒
RegExpText nvarchar (50) ☒
SQLValidator nvarchar (500) ☒
ValidatorMessage nvarchar (255) ☒
OnChangeJsFunction nvarchar (500) ☒
OnChangeProcessName nvarchar (255) ☒
PlaceHolder nvarchar (100) ☒
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
ToolbarName nvarchar (50) ☒ ⇨ dbo.ToolBars.ToolbarName
Separator nvarchar (1) ☒ DEFAULT (N'|')
CascadeDependencies bit ☒ DEFAULT ((0))
RootPathType nvarchar (25) ☒ DEFAULT (N'RelativePath')⇨ dbo.Root_Path_Types.TypeId
ImageCompressionType smallint ☒ ⇨ dbo.Image_Compression_Types.TypeId
ImageMaxWidth smallint ☒
ImageMaxHeight smallint ☒
Offline bit ☐ DEFAULT ((0))
ExtensionId nvarchar (100) ☒ DEFAULT (N'sysAll')⇨ dbo.Extensions.ExtensionId
Autoselect bit ☒ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Processes_Params_Dependencies Table

Table ID: 635149308; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ProcessName nvarchar (255) ☐ ⇨ dbo.Processes_Params.ProcessName
◆ParamName nvarchar (50) ☐ ⇨ dbo.Processes_Params.ParamName
◆DependingParamName nvarchar (50) ☐
Order int ☐
Active bit ☐
Descrip nvarchar (255) ☒
SQLValue nvarchar (max) ☒
SQLComboSentence nvarchar (max) ☒
SQLComboFilter nvarchar (max) ☒
SQLEnabled nvarchar (max) ☒
EnabledValues nvarchar (max) ☒
DisabledValues nvarchar (max) ☒
SQLVisible nvarchar (max) ☒
VisibleValues nvarchar (max) ☒
HiddenValues nvarchar (max) ☒
SQLClass nvarchar (max) ☒
SQLRequired nvarchar (max) ☒
RequiredValues nvarchar (max) ☒
NotRequiredValues nvarchar (max) ☒
PropertyValue nvarchar (max) ☒
CusPropName nvarchar (max) ☒
SQLCustomProperty nvarchar (max) ☒
ConnStringId nvarchar (50) ☒ ⇨ dbo.DbConnectionStrings.ConnStringId
Offline bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Processes_Params_TypeIO Table

Table ID: 667149422; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆IOTypeId nvarchar (5) ☐
Descrip nvarchar (50) ☐

Processes_Params_Types Table

Table ID: 699149536; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ParamTypeId nvarchar (50) ☐
Descrip nvarchar (100) ☐
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Processes_Processes Table

Table ID: 731149650; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Guid uniqueidentifier ☐ DEFAULT (newid())
WorkflowName nvarchar (255) ☐
ParentProcessName nvarchar (255) ☒ ⇨ dbo.Processes.ProcessName
ParentObjectName nvarchar (50) ☒
ParentEventName nvarchar (50) ☒
ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
Order int ☐ DEFAULT ((0))
ExecuteCondition nvarchar (max) ☒
ContinueAfterFail bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Processes_Processes_Params Table

Table ID: 763149764; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Guid uniqueidentifier ☐ ⇨ dbo.Processes_Processes.Guid
◆InputProcessName nvarchar (255) ☐ ⇨ dbo.Processes_Params.ProcessName
◆InputParamName nvarchar (50) ☐ ⇨ dbo.Processes_Params.ParamName
OutputProcessName nvarchar (255) ☐ ⇨ dbo.Processes_Params.ProcessName
OutputParamName nvarchar (50) ☐ ⇨ dbo.Processes_Params.ParamName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Processes_Types Table

Table ID: 795149878; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId int ☐
Descrip nvarchar (100) ☐
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
Active bit ☐ DEFAULT ((1))

Processes_Workflows_Areas Table

Table ID: 827149992; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
◆WorkflowAreaId nvarchar (50) ☐ ⇨ dbo.Workflows_Areas.WorkflowAreaId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Redsys_Logs Table

Table ID: 859150106; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TransactionId nvarchar (100) ☐
StatusId nvarchar (50) ☐ ⇨ dbo.Redsys_Logs_Status.StatusId
CreatedDate smalldatetime ☐
ObjectToken nvarchar (max) ☐
Response nvarchar (max) ☒
ErrorMsg nvarchar (max) ☒
UserName nvarchar (256) ☐

Redsys_Logs_Status Table

Table ID: 891150220; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆StatusId nvarchar (50) ☐
Descrip nvarchar (255) ☐

RedSys_Settings Table

Table ID: 923150334; Created: November 16, 2021, 18:20:31
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐
ProcessName nvarchar (255) ☐
AmountField nvarchar (50) ☒
SuccessMessage nvarchar (255) ☒
ErrorMessage nvarchar (255) ☒
OnlySuccess bit ☒

RegEx Table

Table ID: 955150448; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆RegExId nvarchar (100) ☐
RegEx nvarchar (500) ☐
Descrip nvarchar (255) ☐
ValidItems nvarchar (500) ☒
UnvalidItems nvarchar (500) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Reports Table

Table ID: 987150562; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ReportName nvarchar (100) ☐
ReportDescrip nvarchar (255) ☐
TypeId nvarchar (20) ☐ DEFAULT ('crystal')⇨ dbo.Reports_Types.TypeId
ReportPath nvarchar (255) ☒
AdditionalWhere nvarchar (1000) ☒
NoFilter bit ☐ DEFAULT ((0))
Order int ☐ DEFAULT ((0))
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
PDF bit ☒ DEFAULT ((1))
Word bit ☒ DEFAULT ((0))
Excel bit ☒ DEFAULT ((0))
ParamsTargetId nvarchar (50) ☒ ⇨ dbo.Targets.TargetId
LoadProcessName nvarchar (255) ☒ ⇨ dbo.Processes.ProcessName
ReportMode nvarchar (10) ☐ DEFAULT ('pdf')⇨ dbo.Reports_Modes.ReportModeId
FilterSentence nvarchar (500) ☒
RoleSentence nvarchar (500) ☒
ObjectName nvarchar (50) ☒
TemplateId nvarchar (50) ☒
FilterReportReplacingSentence bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Reports_Modes Table

Table ID: 1019150676; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ReportModeId nvarchar (10) ☐
Descrip nvarchar (50) ☐
IconName nvarchar (100) ☐ ⇨ dbo.Icons.IconName

Reports_Params Table

Table ID: 1051150790; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ReportName nvarchar (100) ☐ ⇨ dbo.Reports.ReportName
◆ParamName nvarchar (50) ☐
Label varchar (250) ☐
PositionX smallint ☐ DEFAULT ((0))
PositionY smallint ☐ DEFAULT ((0))
Width smallint ☐ DEFAULT ((1))
Height smallint ☐ DEFAULT ((1))
Hide bit ☐
TypeId nvarchar (50) ☐ ⇨ dbo.Objects_Properties_Types.TypeId
Locked bit ☐ DEFAULT ((0))
CustomPropName nvarchar (50) ☒
Mask nvarchar (250) ☒
SQlSentence nvarchar (max) ☒
SQLFilter nvarchar (1000) ☒
SQLValueField nvarchar (100) ☒
SQLDisplayField nvarchar (500) ☒
SQLObjectName nvarchar (50) ☒
SQLViewName nvarchar (255) ☒
SQLOfflineSentence nvarchar (max) ☒
SQLOfflineOrderBy nvarchar (max) ☒
WhereSentence nvarchar (1000) ☒
DefaultValue nvarchar (250) ☒
DetachedFromProcess bit ☐ DEFAULT ((0))
SearchFunction nvarchar (250) ☒
SearchCollection nvarchar (50) ☒
SearchWhere nvarchar (500) ☒
SearchReturnFields nvarchar (250) ☒
SecurityObject nvarchar (50) ☒
AllowNew nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
AllowNewFunction nvarchar (250) ☒
AllowNewReturnFields nvarchar (250) ☒
AllowNewDefaults nvarchar (500) ☒
ObjNameLink nvarchar (50) ☒
ObjWhereLink nvarchar (1000) ☒
TargetIdLink nvarchar (50) ☒ DEFAULT ((0))
Style nvarchar (100) ☒
CSSClass nvarchar (100) ☒
LabelStyle nvarchar (100) ☒
LabelCSSClass nvarchar (100) ☒
DecimalPlaces int ☒
RootPath nvarchar (255) ☒
FormatString nvarchar (100) ☒
DirectTemplate nvarchar (500) ☒
Tag varchar (50) ☒
HelpId nvarchar (50) ☒ ⇨ dbo.Help.HelpId
ConnStringId nvarchar (50) ☒ ⇨ dbo.DbConnectionStrings.ConnStringId
IsRequired bit ☐ DEFAULT ((0))
IsRequiredMessage nvarchar (255) ☒
minValue nvarchar (50) ☒
minValueMessage nvarchar (255) ☒
maxValue nvarchar (50) ☒
maxValueMessage nvarchar (255) ☒
RegExp nvarchar (500) ☒
RegExpText nvarchar (50) ☒
SQLValidator nvarchar (500) ☒
ValidatorMessage nvarchar (255) ☒
OnChangeJsFunction nvarchar (500) ☒
OnChangeProcessName nvarchar (255) ☒
PlaceHolder nvarchar (100) ☒
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
ToolbarName nvarchar (50) ☒ ⇨ dbo.ToolBars.ToolbarName
Separator nvarchar (1) ☒ DEFAULT (N'|')
CascadeDependencies bit ☒ DEFAULT ((0))
RootPathType nvarchar (25) ☒ DEFAULT (N'RelativePath')⇨ dbo.Root_Path_Types.TypeId
ImageCompressionType smallint ☒ ⇨ dbo.Image_Compression_Types.TypeId
ImageMaxWidth smallint ☒
ImageMaxHeight smallint ☒
ExtensionId nvarchar (100) ☒ DEFAULT (N'sysAll')⇨ dbo.Extensions.ExtensionId
Autoselect bit ☒ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Reports_Params_Dependencies Table

Table ID: 1083150904; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ReportName nvarchar (100) ☐ ⇨ dbo.Reports_Params.ReportName
◆ParamName nvarchar (50) ☐ ⇨ dbo.Reports_Params.ParamName
◆DependingParamName nvarchar (50) ☐
order int ☐
Active bit ☐
Descrip nvarchar (255) ☒
SQLValue nvarchar (max) ☒
SQLComboSentence nvarchar (max) ☒
SQLComboFilter nvarchar (max) ☒
SQLEnabled nvarchar (max) ☒
EnabledValues nvarchar (max) ☒
DisabledValues nvarchar (max) ☒
SQLVisible nvarchar (max) ☒
VisibleValues nvarchar (max) ☒
HiddenValues nvarchar (max) ☒
SQLClass nvarchar (max) ☒
SQLRequired nvarchar (max) ☒
RequiredValues nvarchar (max) ☒
NotRequiredValues nvarchar (max) ☒
PropertyValue nvarchar (max) ☒
CusPropName nvarchar (max) ☒
SQLCustomProperty nvarchar (max) ☒
ConnStringId nvarchar (50) ☒ ⇨ dbo.DbConnectionStrings.ConnStringId
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Reports_Types Table

Table ID: 1115151018; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId nvarchar (20) ☐
Descrip varchar (50) ☐
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
Active bit ☐ DEFAULT ((1))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Root_Path_Types Table

Table ID: 1147151132; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TypeId nvarchar (25) ☐
Description nvarchar (50) ☐
Active bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Scheduler Table

Table ID: 1179151246; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆SchedulerName nvarchar (20) ☐
ActiveMode nvarchar (20) ☐
MonthView bit ☐
AgendaWeekView bit ☐
AgendaDayView bit ☐
ListWeekView bit ☐
SQLValueField nvarchar (100) ☒
SQLDisplayField nvarchar (500) ☒
SQLFilterField nvarchar (500) ☒
DirectTemplate nvarchar (500) ☒
ObjectName nvarchar (50) ☒
ViewName nvarchar (255) ☒
MinTime nvarchar (5) ☒
MaxTime nvarchar (5) ☒
OnClickEvent bit ☒
AllDaySlot bit ☒
SlotDuration nvarchar (5) ☒
TokenDefault nvarchar (100) ☒
EventPageTypeId nvarchar (50) ☒
EventTargetId nvarchar (50) ☒
HolidaysObjectName nvarchar (255) ☒
HolidaysViewName nvarchar (255) ☒
DateHolidayField nvarchar (255) ☒
EventLimit bit ☒ DEFAULT ((1))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Scheduler_Objects Table

Table ID: 1211151360; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆SchedulerName nvarchar (20) ☐ ⇨ dbo.Scheduler.SchedulerName
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Views.ObjectName
ViewName nvarchar (255) ☐ ⇨ dbo.Objects_Views.ViewName
StartDateField nvarchar (50) ☐
EndDateField nvarchar (50) ☐
StartTimeField nvarchar (50) ☒
EndTimeField nvarchar (50) ☒
DurationField nvarchar (50) ☒
ColorField nvarchar (50) ☐
DescripTemplate nvarchar (max) ☐
UserIdField nvarchar (255) ☒
TextColorField nvarchar (50) ☐
AllDayField nvarchar (50) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Scheduler_Views Table

Table ID: 1243151474; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆ViewId nvarchar (20) ☐
Descrip nvarchar (50) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Scripts_Jobs Table

Table ID: 1275151588; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ScriptId nvarchar (100) ☐ DEFAULT (newid())
Descrip nvarchar (250) ☐
Notes nvarchar (max) ☒
CreationDate smalldatetime ☐
State nvarchar (50) ☐ ⇨ dbo.Scripts_Jobs_States.State
Script nvarchar (max) ☐
ConnStringId nvarchar (50) ☐ ⇨ dbo.DbConnectionStrings.ConnStringId
ExecuteOrder smallint ☐ DEFAULT ((0))
StartDate smalldatetime ☒
EndDate smalldatetime ☒
ErrorMessage nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Scripts_Jobs_States Table

Table ID: 1307151702; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆State nvarchar (50) ☐
Descrip nvarchar (50) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_IP_Lockout Table

Table ID: 1339151816; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:20:33
Name Type NULL Comment
◆Id int ☐ IDENTITY
IP nvarchar (50) ☐
LockoutDate datetime ☐ DEFAULT (getdate())
LockoutEndDate datetime ☒
Reason nvarchar (1000) ☒

Security_Master_Tables_Roles Table

Table ID: 1371151930; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TableName nvarchar (250) ☐ ⇨ dbo.Master_Tables.TableName
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
CanView bit ☐
CanUpdate bit ☐ DEFAULT ((0))
CanDelete bit ☐ DEFAULT ((0))
CanInsert bit ☐ DEFAULT ((0))
CanPrint bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Master_Tables_Users Table

Table ID: 1403152044; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TableName nvarchar (250) ☐ ⇨ dbo.Master_Tables.TableName
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
CanView bit ☐
CanUpdate bit ☐ DEFAULT ((0))
CanDelete bit ☐ DEFAULT ((0))
CanInsert bit ☐ DEFAULT ((0))
CanPrint bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Modules_Faculties Table

Table ID: 1435152158; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
CanView bit ☐
ViewFilter nvarchar (2048) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Modules_Roles Table

Table ID: 1467152272; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
CanView bit ☐
ViewFilter nvarchar (2048) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Modules_Users Table

Table ID: 1499152386; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
CanView bit ☐
ViewFilter nvarchar (2048) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Navigation_Nodes_Faculties Table

Table ID: 1531152500; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆NodeId uniqueidentifier ☐ ⇨ dbo.Navigation_Nodes.NodeId
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Navigation_Nodes_Roles Table

Table ID: 1563152614; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆NodeId uniqueidentifier ☐ ⇨ dbo.Navigation_Nodes.NodeId
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Navigation_Nodes_Users Table

Table ID: 1595152728; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆NodeId uniqueidentifier ☐ ⇨ dbo.Navigation_Nodes.NodeId
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
CanView bit ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Faculties Table

Table ID: 1627152842; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
CanView bit ☐ DEFAULT ((0))
ViewFilter nvarchar (2048) ☒
CanViewCollection bit ☐ DEFAULT ((0))
ViewFilterCollection nvarchar (2048) ☒
CanInsert bit ☐ DEFAULT ((0))
InsertFilter nvarchar (2048) ☒
CanEdit bit ☐ DEFAULT ((0))
EditFilter nvarchar (2048) ☒
CanDelete bit ☐ DEFAULT ((0))
DeleteFilter nvarchar (2048) ☒
CanPrint bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Processes_Faculties Table

Table ID: 1659152956; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
CanView bit ☐
ViewFilter nvarchar (2048) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Processes_Roles Table

Table ID: 1691153070; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
CanView bit ☐
ViewFilter nvarchar (2048) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Processes_Users Table

Table ID: 1723153184; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
CanView bit ☐
ViewFilter nvarchar (2048) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Properties_Faculties Table

Table ID: 1755153298; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.ObjectName
◆PropertyName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.PropertyName
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
CanView bit ☐
CanEdit bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Properties_Roles Table

Table ID: 1787153412; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.ObjectName
◆PropertyName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.PropertyName
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
CanView bit ☐
CanEdit bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Properties_Users Table

Table ID: 1819153526; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.ObjectName
◆PropertyName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.PropertyName
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
CanView bit ☐
CanEdit bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Roles Table

Table ID: 1851153640; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
CanView bit ☐ DEFAULT ((0))
ViewFilter nvarchar (2048) ☒
CanViewCollection bit ☐ DEFAULT ((0))
ViewFilterCollection nvarchar (2048) ☒
CanInsert bit ☐ DEFAULT ((0))
InsertFilter nvarchar (2048) ☒
CanEdit bit ☐ DEFAULT ((0))
EditFilter nvarchar (2048) ☒
CanDelete bit ☐ DEFAULT ((0))
DeleteFilter nvarchar (2048) ☒
CanPrint bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Templates_Faculties Table

Table ID: 1883153754; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆TemplateId nvarchar (50) ☐ ⇨ dbo.Objects_Templates.TemplateId
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Templates_Roles Table

Table ID: 1915153868; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆TemplateId nvarchar (50) ☐ ⇨ dbo.Objects_Templates.TemplateId
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Templates_Users Table

Table ID: 1947153982; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆TemplateId nvarchar (50) ☐ ⇨ dbo.Objects_Templates.TemplateId
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Objects_Users Table

Table ID: 1979154096; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
CanView bit ☐ DEFAULT ((0))
ViewFilter nvarchar (2048) ☒
CanViewCollection bit ☐ DEFAULT ((0))
ViewFilterCollection nvarchar (2048) ☒
CanInsert bit ☐ DEFAULT ((0))
InsertFilter nvarchar (2048) ☒
CanEdit bit ☐ DEFAULT ((0))
EditFilter nvarchar (2048) ☒
CanDelete bit ☐ DEFAULT ((0))
DeleteFilter nvarchar (2048) ☒
CanPrint bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Offline_Menus_Faculties Table

Table ID: 2011154210; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆MenuId uniqueidentifier ☐ ⇨ dbo.Offline_Menus.MenuId
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Offline_Menus_Roles Table

Table ID: 2043154324; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆MenuId uniqueidentifier ☐ ⇨ dbo.Offline_Menus.MenuId
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Offline_Menus_Users Table

Table ID: 2075154438; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆MenuId uniqueidentifier ☐ ⇨ dbo.Offline_Menus.MenuId
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Pages_Faculties Table

Table ID: 2107154552; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆PageName nvarchar (100) ☐ ⇨ dbo.Pages.PageName
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
Canview bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Pages_Modules_Faculties Table

Table ID: 2139154666; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆PageName nvarchar (100) ☐ ⇨ dbo.Pages.PageName
◆ModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Pages_Modules_Roles Table

Table ID: 23671132; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆PageName nvarchar (100) ☐ ⇨ dbo.Pages.PageName
◆ModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Pages_Modules_Users Table

Table ID: 55671246; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆PageName nvarchar (100) ☐ ⇨ dbo.Pages.PageName
◆ModuleName nvarchar (100) ☐ ⇨ dbo.Modules.ModuleName
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
CanView bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Pages_Roles Table

Table ID: 87671360; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆PageName nvarchar (100) ☐ ⇨ dbo.Pages.PageName
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
Canview bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Pages_Users Table

Table ID: 119671474; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆PageName nvarchar (100) ☐ ⇨ dbo.Pages.PageName
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
Canview bit ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Reports_Faculties Table

Table ID: 151671588; Created: November 16, 2021, 18:20:31; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆ReportName nvarchar (100) ☐ ⇨ dbo.Reports.ReportName
◆FacultyId nvarchar (128) ☐ ⇨ dbo.AspNetFaculties.FacultyId
CanPrint bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Reports_Roles Table

Table ID: 183671702; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆ReportName nvarchar (100) ☐ ⇨ dbo.Reports.ReportName
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
CanPrint bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Security_Reports_Users Table

Table ID: 215671816; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆ReportName nvarchar (100) ☐ ⇨ dbo.Reports.ReportName
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
CanPrint bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Settings Table

Table ID: 247671930; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆SettingName nvarchar (150) ☐
SettingValue nvarchar (max) ☒
IconName nvarchar (100) ☐ ⇨ dbo.Icons.IconName
Description nvarchar (1000) ☐
SettingCustomProperty nvarchar (50) ☒
Active bit ☐ DEFAULT ((1))
GroupName nvarchar (20) ☒ ⇨ dbo.Settings_Groups.GroupName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Settings_Groups Table

Table ID: 279672044; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆GroupName nvarchar (20) ☐ DEFAULT (newid())
Descrip nvarchar (250) ☐
IconName nvarchar (100) ☐ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Settings_Values Table

Table ID: 311672158; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆SettingName nvarchar (150) ☐
◆SettingValue nvarchar (1000) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Skins Table

Table ID: 343672272; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆SkinId nvarchar (50) ☐
Descrip nvarchar (100) ☐
Css nvarchar (max) ☒
Script nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Skins_Css Table

Table ID: 375672386; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆CssId nvarchar (150) ☐ DEFAULT (newid())
◆SkinId nvarchar (50) ☐ ⇨ dbo.Skins.SkinId
CssPath nvarchar (500) ☐
Descrip nvarchar (100) ☐
InBundle bit ☐ DEFAULT ((1))
Order int ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())
Enabled bit ☐ DEFAULT ((1))

Skins_Variables Table

Table ID: 407672500; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:23
Name Type NULL Comment
◆SkinId nvarchar (50) ☐ ⇨ dbo.Skins.SkinId
◆VarName nvarchar (50) ☐
Descrip nvarchar (50) ☒
VarValue nvarchar (100) ☐
VarType nvarchar (50) ☐
VarGroup nvarchar (50) ☒
VarOrder int ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Targets Table

Table ID: 439672614; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TargetId nvarchar (50) ☐
Descrip nvarchar (100) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Tests Table

Table ID: 471672728; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆TestId nvarchar (100) ☐ DEFAULT (newid())
Title nvarchar (100) ☐
Path nvarchar (500) ☐
ExcludeCategories nvarchar (500) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Timeline_Layouts Table

Table ID: 503672842; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆LayoutName nvarchar (25) ☐
Order int ☐

Timeline_Ranges Table

Table ID: 535672956; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆RangeName nvarchar (25) ☐
Order int ☐

Timelines_Settings Table

Table ID: 567673070; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆TimelineSettingName nvarchar (50) ☐
TimelineSettingDescrip nvarchar (100) ☐
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Views.ObjectName
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.ObjectName
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.ObjectName
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.ObjectName
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Views.ObjectName
ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Properties.ObjectName
Advanced bit ☐ DEFAULT ((0))
Editable bit ☐ DEFAULT ((0))
WithGroups bit ☐ DEFAULT ((0))
ShowItemsWithoutGroup bit ☐ DEFAULT ((0))
TitleItemsWithoutGroup nvarchar (25) ☒
LayoutName nvarchar (25) ☒ DEFAULT ('Left')⇨ dbo.Timeline_Layouts.LayoutName
DefaultRangeName nvarchar (25) ☐ DEFAULT ('Week')⇨ dbo.Timeline_Ranges.RangeName
ShowControls bit ☐ DEFAULT ((1))
OnInsertOpenNewWithDefaults bit ☐ DEFAULT ((1))
PropertyDescrip nvarchar (50) ☒ ⇨ dbo.Objects_Properties.PropertyName
PropertyStartDate nvarchar (50) ☒ ⇨ dbo.Objects_Properties.PropertyName
PropertyEndDate nvarchar (50) ☒ ⇨ dbo.Objects_Properties.PropertyName
PropertyGroup nvarchar (50) ☒ ⇨ dbo.Objects_Properties.PropertyName
GroupViewName nvarchar (255) ☒ ⇨ dbo.Objects_Views.ViewName
GroupIdField nvarchar (100) ☒
GroupDescripField nvarchar (100) ☒
GroupClassNameField nvarchar (100) ☒
GroupStyleField nvarchar (100) ☒
GroupContentTemplate nvarchar (max) ☒
ItemViewName nvarchar (255) ☒ ⇨ dbo.Objects_Views.ViewName
ItemDescripField nvarchar (100) ☒
ItemStartDateField nvarchar (100) ☒
ItemEndDateField nvarchar (100) ☒
ItemGroupField nvarchar (100) ☒
ItemEditableField nvarchar (100) ☒
ItemClassNameField nvarchar (100) ☒
ItemStyleField nvarchar (100) ☒
ItemTypeField nvarchar (100) ☒
ItemContentTemplate nvarchar (max) ☒
ItemVisibleFrameTemplate nvarchar (max) ☒
OnMovingFunction nvarchar (max) ☒
OnDropObjectOnItemFunction nvarchar (max) ☒
OnDeleteFunction nvarchar (max) ☒
CustomOptions nvarchar (max) ☒
DefaultTime int ☐ DEFAULT ((60))
EventPageTypeId nvarchar (50) ☐ DEFAULT ('edit')
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

ToolBars Table

Table ID: 599673184; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ToolbarName nvarchar (50) ☐
Descrip nvarchar (150) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

ToolBars_Buttons Table

Table ID: 631673298; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ButtonId nvarchar (100) ☐ DEFAULT (newid())
ToolbarName nvarchar (50) ☐ ⇨ dbo.ToolBars.ToolbarName
ParentButtonId nvarchar (100) ☒ ⇨ dbo.ToolBars_Buttons.ButtonId
Order int ☐ DEFAULT ((0))
TypeId nvarchar (50) ☐ ⇨ dbo.ToolBars_Buttons_Types.ButtonType
PositionId nvarchar (50) ☐ ⇨ dbo.ToolBars_Buttons_Positions.PositionId
Text nvarchar (150) ☐
Tooltip nvarchar (150) ☒
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
HideText bit ☐ DEFAULT ((0))
CssClass nvarchar (255) ☒
SQlSentence nvarchar (max) ☒
ProcessName nvarchar (255) ☒
TargetId varchar (50) ☐ DEFAULT ('current')
ReportName nvarchar (100) ☒ ⇨ dbo.Reports.ReportName
HelpId nvarchar (50) ☒ ⇨ dbo.Help.HelpId
Disabled bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

ToolBars_Buttons_Positions Table

Table ID: 663673412; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆PositionId nvarchar (50) ☐

ToolBars_Buttons_Types Table

Table ID: 695673526; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ButtonType nvarchar (50) ☐
Descrip nvarchar (250) ☐

Translate Table

Table ID: 727673640; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆CultureId nvarchar (8) ☐ ⇨ dbo.Cultures.CultureId
◆Original nvarchar (255) ☐
Text nvarchar (255) ☐
◆Area nvarchar (100) ☐ ⇨ dbo.Translate_Areas.Area
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Translate_Areas Table

Table ID: 759673754; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Area nvarchar (100) ☐
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Versions Table

Table ID: 791673868; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆VersionNumber nvarchar (50) ☐
InstallDate datetime ☐
IsUpdate bit ☐ DEFAULT ((0))
OriginDatabase nvarchar (255) ☒
UpdateLog nvarchar (max) ☒

Versions_Differences Table

Table ID: 823673982; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆DifferenceId nvarchar (50) ☐ DEFAULT (newid())
VersionNumber nvarchar (50) ☐ ⇨ dbo.Versions.VersionNumber
TableName nvarchar (256) ☐
FieldName nvarchar (256) ☐
RowKey nvarchar (1000) ☐
SystemValue nvarchar (max) ☒
UserValue nvarchar (max) ☒
CurrentValue nvarchar (max) ☒
ManualValue nvarchar (max) ☒
RowOriginId int ☐ ⇨ dbo.Origins.OriginId
Action smallint ☐ ⇨ dbo.Configuration_Actions_Types.ActionId
Applied bit ☐ DEFAULT ((0))
Revised bit ☐ DEFAULT ((0))

Versions_Scripts Table

Table ID: 855674096; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ScriptId nvarchar (256) ☐ ⇨ dbo.Configuration_Scripts.ScriptId
VersionNumber nvarchar (50) ☐ ⇨ dbo.Versions.VersionNumber
ExecutedDate datetime ☐
Result bit ☐
ExecuteLog nvarchar (max) ☒

Videos Table

Table ID: 887674210; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆VideoName nvarchar (100) ☐
Title nvarchar (250) ☐
Descrip nvarchar (max) ☐
Url nvarchar (250) ☐
Classification nvarchar (50) ☐ ⇨ dbo.Videos_Classification.Classification
Category nvarchar (50) ☐ ⇨ dbo.Videos_Categories.Category
Image nvarchar (250) ☐
Author nvarchar (100) ☒
Duration int ☒
Order int ☐ DEFAULT ((0))
IsNew bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Videos_Categories Table

Table ID: 919674324; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Category nvarchar (50) ☐
Descrip nvarchar (250) ☐
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Videos_Classification Table

Table ID: 951674438; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Classification nvarchar (50) ☐
Title nvarchar (250) ☒
Descrip nvarchar (max) ☐
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

WebAPI_Apps Table

Table ID: 983674552; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:20:33
Name Type NULL Comment
◆AppName nvarchar (255) ☐
Descrip nvarchar (255) ☐
Icon nvarchar (500) ☐
ReturnTokenUrl nvarchar (500) ☐
ClientSecret nvarchar (500) ☒
isAuthorized bit ☐ DEFAULT ((1))

WebAPI_Objects Table

Table ID: 1015674666; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects.ObjectName
CanView bit ☐ DEFAULT ((0))
CanViewCollection bit ☐ DEFAULT ((0))
CanInsert bit ☐ DEFAULT ((0))
CanEdit bit ☐ DEFAULT ((0))
CanDelete bit ☐ DEFAULT ((0))
CanPrint bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

WebAPI_Processes Table

Table ID: 1047674780; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ProcessName nvarchar (255) ☐ ⇨ dbo.Processes.ProcessName
CanView bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

WebAPI_Roles Table

Table ID: 1079674894; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆RoleId nvarchar (128) ☐ ⇨ dbo.AspNetRoles.Id
isAuthorized bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

WebAPI_Users Table

Table ID: 1111675008; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆UserId nvarchar (128) ☐ ⇨ dbo.AspNetUsers.Id
isAuthorized bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

WebAPI_Views Table

Table ID: 1143675122; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ObjectName nvarchar (50) ☐ ⇨ dbo.Objects_Views.ObjectName
◆ViewName nvarchar (255) ☐ ⇨ dbo.Objects_Views.ViewName
CanView bit ☐ DEFAULT ((0))
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

WebHooks Table

Table ID: 1175675236; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:20:35
Name Type NULL Comment
◆WebHookID nvarchar (255) ☐
Origin nvarchar (255) ☐
ProcessName nvarchar (255) ☐
RequiresAuthorization bit ☐ DEFAULT ((0))
OriginId int ☒ DEFAULT ([dbo].[funNet_GetOrigin]())

Workflows Table

Table ID: 1207675350; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆WorkflowId nvarchar (255) ☐ DEFAULT (newid())
◆Version smallint ☐
ModuleId nvarchar (50) ☒ ⇨ dbo.Workflows_Modules.WorkflowModuleId
AreaId nvarchar (50) ☒ ⇨ dbo.Workflows_Areas.WorkflowAreaId
Descrip nvarchar (255) ☐
WorkflowData nvarchar (max) ☐
Active bit ☐
OriginId int ☒ DEFAULT ([dbo].[funNet_GetOrigin]())

Workflows_Areas Table

Table ID: 1239675464; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:25
Name Type NULL Comment
◆WorkflowAreaId nvarchar (50) ☐ DEFAULT (newid())
Descrip nvarchar (500) ☐
ParentAreaId nvarchar (50) ☒ ⇨ dbo.Workflows_Areas.WorkflowAreaId
Observations nvarchar (4000) ☒
IconName nvarchar (100) ☒ ⇨ dbo.Icons.IconName
AreaData nvarchar (max) ☒
OriginId int ☒ DEFAULT ([dbo].[funNet_GetOrigin]())

Workflows_Executions Table

Table ID: 1271675578; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ExecutionId bigint ☐
ParentExecutionId bigint ☐
MasterExecutionId bigint ☐
WorkflowId nvarchar (255) ☐ ⇨ dbo.Workflows.WorkflowId
WorkflowVersion smallint ☐ ⇨ dbo.Workflows.Version
Start datetime ☒
Finish datetime ☒
ResultId smallint ☒ ⇨ dbo.Workflows_Results.ResultId
StatusId smallint ☒ ⇨ dbo.Workflows_Status.StatusId
ErrorMessage nvarchar (max) ☒
WarningMessage nvarchar (max) ☒
ExecutionData nvarchar (max) ☒
UserId nvarchar (128) ☒

Workflows_Executions_Nodes Table

Table ID: 1303675692; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆Id bigint ☐
ExecutionId bigint ☐ ⇨ dbo.Workflows_Executions.ExecutionId
NodeId nvarchar (50) ☐
ThreadId int ☐
Start datetime ☒
ProcessTime time ☒
Finish datetime ☒
ResultId smallint ☒ ⇨ dbo.Workflows_Results.ResultId
StatusId smallint ☒ ⇨ dbo.Workflows_Status.StatusId
ErrorMessage nvarchar (max) ☒
WarningMessage nvarchar (max) ☒
ExecutionData nvarchar (max) ☒

Workflows_Modules Table

Table ID: 1335675806; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆WorkflowModuleId nvarchar (50) ☐ DEFAULT (newid())
Descrip nvarchar (500) ☐
OriginId int ☒ DEFAULT ([dbo].[funNet_GetOrigin]())

Workflows_Nodes Table

Table ID: 1367675920; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆NodeId uniqueidentifier ☐ DEFAULT (newid())
WorkflowName nvarchar (255) ☐ ⇨ dbo.Workflows.WorkflowId
Version smallint ☐ ⇨ dbo.Workflows.Version
NodeType smallint ☐ ⇨ dbo.Workflows_Nodes_Types.WorkflowNodeTypeId
GraphId int ☐
ProcessName nvarchar (255) ☒ ⇨ dbo.Processes.ProcessName
ObjectName nvarchar (50) ☒ ⇨ dbo.Objects.ObjectName
EventName nvarchar (50) ☒
ExecuteCondition nvarchar (max) ☒
ContinueAfterFail bit ☐
InitialNode bit ☐
NodeLabel nvarchar (1000) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Workflows_Nodes_Types Table

Table ID: 1399676034; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆WorkflowNodeTypeId smallint ☐
Descrip nvarchar (50) ☐

Workflows_Relations Table

Table ID: 1431676148; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆RelationId uniqueidentifier ☐ DEFAULT (newid())
WorkflowName nvarchar (255) ☐ ⇨ dbo.Workflows.WorkflowId
Version smallint ☐ ⇨ dbo.Workflows.Version
GraphId int ☐
ParentGuid uniqueidentifier ☐
ChildGuid uniqueidentifier ☐
ParentValue nvarchar (255) ☒
ExecuteCondition nvarchar (max) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Workflows_Relations_Parameters Table

Table ID: 1463676262; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ParameterRelationId uniqueidentifier ☐ DEFAULT (newid())
RelationId uniqueidentifier ☐ ⇨ dbo.Workflows_Relations.RelationId
ChildParamName nvarchar (50) ☐
ParentType nvarchar (50) ☐ ⇨ dbo.Workflows_Relations_Types.RelationType
ParentNode nvarchar (255) ☒
ParentParamName nvarchar (50) ☒
DefaultValue nvarchar (1000) ☒
OriginId int ☐ DEFAULT ([dbo].[funNet_GetOrigin]())

Workflows_Relations_Types Table

Table ID: 1495676376; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆RelationType nvarchar (50) ☐
Descrip nvarchar (255) ☐

Workflows_Results Table

Table ID: 1527676490; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆ResultId smallint ☐
Description nvarchar (100) ☐

Workflows_Status Table

Table ID: 1559676604; Created: November 16, 2021, 18:20:32; Modified: November 16, 2021, 18:21:24
Name Type NULL Comment
◆StatusId smallint ☐
Description nvarchar (100) ☐

zVersion_AspNetFaculties Table

Table ID: 593437188; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
FacultyId nvarchar (128) ☐
Name nvarchar (256) ☐
Descrip nvarchar (500) ☒
OriginId int ☐

zVersion_AspNetProfiles Table

Table ID: 609437245; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
ProfileName nvarchar (100) ☐
Descrip nvarchar (100) ☐
CultureId nvarchar (8) ☐
WebInterfaceName nvarchar (100) ☐
MobileInterfaceName nvarchar (100) ☐
StartupPageName nvarchar (100) ☐
MailAccountId nvarchar (100) ☒
OriginId int ☐

zVersion_AspNetRoles Table

Table ID: 625437302; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
Id nvarchar (128) ☐
Name nvarchar (256) ☐
IsDesigner bit ☐
IsAdmin bit ☐
Hidden bit ☐
OriginId int ☐

zVersion_AspNetUsers Table

Table ID: 641437359; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
Id nvarchar (128) ☐
RoleId nvarchar (128) ☐
ProfileName nvarchar (100) ☐
Email nvarchar (256) ☐
EmailConfirmed bit ☐
PasswordHash nvarchar (max) ☒
SecurityStamp nvarchar (max) ☒
PhoneNumber nvarchar (50) ☒
PhoneNumberConfirmed bit ☐
TwoFactorEnabled bit ☐
LockoutEndDateUtc datetime ☒
LockoutEnabled bit ☐
AccessFailedCount int ☐
UserName nvarchar (256) ☐
IPGroup nvarchar (50) ☒
Reference nvarchar (50) ☒
SubReference nvarchar (50) ☒
Avatar nvarchar (max) ☒
Name nvarchar (100) ☒
SurName nvarchar (100) ☒
NickName nvarchar (100) ☒
CultureId nvarchar (8) ☐
MailAccountId nvarchar (100) ☒
OriginId int ☐

zVersion_AspNetUsers_Faculties Table

Table ID: 657437416; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
UserId nvarchar (128) ☐
FacultyId nvarchar (128) ☐
OriginId int ☐

zVersion_AspNetUsers_Settings Table

Table ID: 673437473; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
UserId nvarchar (128) ☐
SkinId int ☒
MobileSkinId varchar (50) ☒
DefaultPageSize int ☒
DefaultDropDownRows int ☒
MailAccount nvarchar (50) ☒
MailUser nvarchar (100) ☒
MailVisibleName nvarchar (100) ☒
POP3Host nvarchar (100) ☒
SMTPHost nvarchar (100) ☒
MaillPassowrd varchar (50) ☒
DeleteMailsOnServer bit ☐
SMTPPort int ☐
POPPort int ☐
UseSSL bit ☐
MailSignature nvarchar (1000) ☒
OriginId int ☐

zVersion_AspNetUsers_TokenTypes Table

Table ID: 689437530; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
TokenType nvarchar (64) ☐
Descrip nvarchar (max) ☐
IconName nvarchar (100) ☒
OriginId int ☐

zVersion_Blacklist Table

Table ID: 705437587; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
Id nvarchar (100) ☐
Method nvarchar (255) ☐
Param nvarchar (255) ☐
ExcludeList nvarchar (max) ☒
ExcludeRegex nvarchar (max) ☒
OriginId int ☐

zVersion_Charts_Animations Table

Table ID: 721437644; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
Animation nvarchar (100) ☐
OriginId int ☐

zVersion_Charts_Settings Table

Table ID: 737437701; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
ChartSettingName nvarchar (100) ☐
Descrip nvarchar (255) ☒
ShowLabels bit ☐
Colors nvarchar (500) ☒
BorderColors nvarchar (500) ☒
ShowLegend bit ☐
LegendPos nvarchar (20) ☒
ToolTipBackgroundColor nvarchar (10) ☒
ShowTitle bit ☐
TitleFontStyle nvarchar (150) ☒
TitleFontSize int ☒
TitlePosition nvarchar (20) ☒
TitleFontColor nvarchar (20) ☒
Responsive bit ☐
MinXAxes int ☒
MinYAxes int ☒
AnimationDuration int ☒
AnimationStyle nvarchar (100) ☒
OriginId int ☐

zVersion_Chatters_Config Table

Table ID: 753437758; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
ObjectName nvarchar (50) ☐
ObjectPK nvarchar (50) ☐
OriginId int ☐

zVersion_Chatters_Groups Table

Table ID: 769437815; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
ChatterGroupId uniqueidentifier ☐
Name nvarchar (50) ☐
OriginId int ☐

zVersion_Chatters_Groups_Users Table

Table ID: 785437872; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
ChatterGroupId uniqueidentifier ☐
UserId nvarchar (128) ☐
OriginId int ☐

zVersion_ContextVars Table

Table ID: 801437929; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
VarName nvarchar (50) ☐
VarSQL nvarchar (max) ☐
Order int ☐
ConnStringId nvarchar (100) ☐
OriginId int ☒

zVersion_Countries Table

Table ID: 817437986; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
IsoCode nvarchar (2) ☐
Iso3 nvarchar (3) ☐
Name nvarchar (50) ☐
IsoName nvarchar (50) ☐
Flag nvarchar (1009) ☐
Active bit ☐
OriginId int ☐

zVersion_Cultures Table

Table ID: 833438043; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
CultureId nvarchar (8) ☐
CountryISO nvarchar (2) ☒
Name nvarchar (100) ☐
Flag nvarchar (100) ☒
Active bit ☐
OriginId int ☐

zVersion_DbConnectionStrings Table

Table ID: 849438100; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
ConnStringId nvarchar (50) ☐
Descrip nvarchar (100) ☐
UpdateDataModel bit ☐
DacpacName nvarchar (150) ☒
Active bit ☐
Reserved bit ☐
OriginId int ☐

zVersion_DbConnectionStrings_LinkedServers Table

Table ID: 865438157; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
ConnStringId nvarchar (50) ☐
ChildConnStringId nvarchar (50) ☐
ServerName nvarchar (100) ☐
OriginId int ☐

zVersion_Documents_Category Table

Table ID: 881438214; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
CategoryId nvarchar (50) ☐
Category nvarchar (255) ☒
OriginId int ☐

zVersion_Documents_Objects_Config Table

Table ID: 897438271; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
ObjectName nvarchar (50) ☐
ObjectPK nvarchar (50) ☐
ERPObjectName nvarchar (250) ☒
TypeId nvarchar (50) ☐
Path nvarchar (500) ☐
DefaultCategoryId nvarchar (50) ☒
CategoryFilter nvarchar (max) ☒
DropboxFolderCreate bit ☐
DropboxFolderLink bit ☐
DropboxFileCreate bit ☐
DropboxFileLink bit ☐
DriveFolderCreate bit ☐
DriveFolderLink bit ☐
DriveFileCreate bit ☐
DriveFileLink bit ☐
DiskFolderCreate bit ☐
DiskFolderLink bit ☐
DiskFileCreate bit ☐
DiskFileLink bit ☐
ExtensionId nvarchar (100) ☒
OfflineFilter nvarchar (max) ☒
OriginId int ☐

zVersion_Documents_Objects_Config_Types Table

Table ID: 913438328; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
TypeId nvarchar (50) ☐
Descrip nvarchar (250) ☐
Active bit ☐
OriginId int ☐

zVersion_Events_Actions Table

Table ID: 929438385; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
EventAction nvarchar (50) ☐
Description nvarchar (255) ☐
OriginId int ☐

zVersion_Events_Classes Table

Table ID: 945438442; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
EventClass nvarchar (50) ☐
Description nvarchar (255) ☐
OriginId int ☐

zVersion_Events_Classes_Types Table

Table ID: 961438499; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
EventClass nvarchar (50) ☐
EventType nvarchar (50) ☐
Description nvarchar (255) ☐
OriginId int ☐

zVersion_Events_Types Table

Table ID: 977438556; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
EventType nvarchar (50) ☐
Description nvarchar (255) ☐
OriginId int ☐

zVersion_Exceptions Table

Table ID: 993438613; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
Id nvarchar (100) ☐
Msg nvarchar (900) ☐
OriginId int ☐

zVersion_Export_Formats Table

Table ID: 1009438670; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
Format nvarchar (50) ☐
Description nvarchar (100) ☐
IconName nvarchar (100) ☐
MaxNumber int ☐
Active bit ☐
Order int ☐
OriginId int ☐

zVersion_Extensions Table

Table ID: 1025438727; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
ExtensionId nvarchar (100) ☐
Descrip nvarchar (500) ☐
Extensions nvarchar (500) ☐
OriginId int ☐

zVersion_Follow_Objects_Child_Config Table

Table ID: 1041438784; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
Object nvarchar (50) ☐
ChildObject nvarchar (50) ☐
OriginId int ☐

zVersion_Follow_Objects_Config Table

Table ID: 1057438841; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
Object nvarchar (50) ☐
Disable bit ☐
OriginId int ☐

zVersion_GreyList Table

Table ID: 1073438898; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
Id nvarchar (100) ☐
Method nvarchar (255) ☐
Param nvarchar (255) ☐
ExcludeList nvarchar (max) ☒
ExcludeRegex nvarchar (max) ☒
OriginId int ☐

zVersion_Help Table

Table ID: 1089438955; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
HelpId nvarchar (50) ☐
Title nvarchar (150) ☐
HTMLText nvarchar (max) ☒
TargetId nvarchar (50) ☐
IconName nvarchar (100) ☒
ExternalUrl nvarchar (255) ☒
Order int ☒
Category nvarchar (50) ☐
Tag nvarchar (200) ☒
OriginId int ☐

zVersion_Help_Categories Table

Table ID: 1105439012; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
Category nvarchar (50) ☐
Descrip nvarchar (250) ☐
IconName nvarchar (100) ☒
OriginId int ☐

zVersion_Help_SamplesJS Table

Table ID: 1121439069; Created: November 16, 2021, 18:21:26
Name Type NULL Comment
HelpJSId nvarchar (50) ☐
Title nvarchar (150) ☐
HTMLCode nvarchar (max) ☒
JSCode nvarchar (max) ☒
CSSCode nvarchar (max) ☒
OriginId int ☐

zVersion_Icons Table

Table ID: 1137439126; Created: November 16, 2021, 18:21:27
Name Type NULL Comment
IconName nvarchar (100) ☐
Classification nvarchar (50) ☐
CSSClass nvarchar (100) ☒
ImagePath nvarchar (255) ☒
Category nvarchar (100) ☒
OriginId int ☐

zVersion_Interfaces Table

Table ID: 1153439183; Created: November 16, 2021, 18:21:27
Name Type NULL Comment
InterfaceName nvarchar (100) ☐
TypeId int ☐
Descrip nvarchar (100) ☐
IsDefault bit ☐
Logo nvarchar (255) ☒
SkinId nvarchar (50) ☐
Script nvarchar (max) ☒
Style nvarchar (1000) ☒
MainNavigateId uniqueidentifier ☒
NavigateId uniqueidentifier ☒
StartupPageName nvarchar (250) ☒
DefaultPageSize int ☐
DefaultDropDownRows int ☐
OriginId int ☐

zVersion_Interfaces_Types_JS Table

Table ID: 1169439240; Created: November 16, 2021, 18:21:27
Name Type NULL Comment
InterfaceTypeId uniqueidentifier ☐
TypeId int ☐
FilePath nvarchar (255) ☐
Description nvarchar (255) ☐
Order int ☐
OriginId int ☐

zVersion_Jobs Table

Table ID: 1185439297; Created: November 16, 2021, 18:21:27
Name Type NULL Comment
JobName nvarchar (50) ☐
JobGroup nvarchar (50) ☐
Enabled bit ☐
Descrip nvarchar (250) ☐
FirstExecutionDate datetime ☐
LastExecutionDate datetime ☒
TriggerExpression nvarchar (50) ☐
ExecuteInmediatlyAfterMisfire bit ☐
ObjectName nvarchar (50) ☒
ObjectWhere nvarchar (max) ☒
UserName nvarchar (256) ☐
ProcessName nvarchar (255) ☐
Params nvarchar (max) ☒
OriginId int ☒

zVersion_Jobs_Triggers Table

Table ID: 1201439354; Created: November 16, 2021, 18:21:27
Name Type NULL Comment
TriggerExpression nvarchar (50) ☐
Descrip nvarchar (250) ☐
OriginId int ☐

zVersion_Kanban_Boards Table

Table ID: 1217439411; Created: November 16, 2021, 18:21:27
Name Type NULL Comment
BoardName nvarchar (50) ☐
BoardGroup nvarchar (50) ☐
Title nvarchar (100) ☐
Descrip nvarchar (250) ☒
OwnerId nvarchar (128) ☐
BoardTypeName nvarchar (50) ☐
ObjectName nvarchar (50) ☒
ObjectKey nvarchar (500) ☒
OriginId int ☐

zVersion_Kanban_Boards_Columns Table

Table ID: 1233439468; Created: November 16, 2021, 18:21:27
Name Type NULL Comment
BoardName nvarchar (50) ☐
ColumnName nvarchar (50) ☐