En este apartado encontrará tablas de datos para la gestión de seguridad de la aplicación.

Table Name: AppAuthReq

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppAuthReqId	nchar	508	NO	NO
AppAuthReqRedirURL	nvarchar	4096	NO	NO
AppAuthReqResponseType	nchar	10	NO	NO
AppAuthReqAuthorized	datetime	8	YES	NO
AppAuthReqRevoked	datetime	8	YES	NO
AppId	decimal	9	NO	NO
AppPrmGUID	nchar	80	NO	NO
AppAuthReqCreated	datetime	8	NO	NO
AppAuthReqUserAppPrmCode	nchar	160	YES	NO
AppAuthReqSesToken	nchar	240	YES	NO

Table Name: AppEnvironment

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppEnvId	decimal	9	NO	NO
AppEnvGUID	nchar	80	NO	NO
AppEnvSrvHost	nchar	240	NO	NO
AppEnvSrvPort	int	4	YES	NO
AppEnvSrvVirDir	nchar	240	YES	NO
AppEnvSrvHttps	bit	1	NO	NO
AppEnvSrvPgmPac	nchar	508	YES	NO
AppEnvSrvPgmExt	nchar	120	YES	NO
AppEnvOrder	int	4	NO	NO
AppEnvName	nchar	240	YES	NO
AppEnvCreDate	datetime	8	YES	NO
AppEnvCreUser	nvarchar	500	YES	NO
AppEnvUpdDate	datetime	8	YES	NO
AppEnvUpdUser	nvarchar	500	YES	NO

Table Name: AppEnvironmentLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppEnvId	decimal	9	NO	NO
AppEnvLngId	nchar	6	NO	NO
AppEnvNameLng	nchar	240	YES	NO
AppEnvDscLng	nchar	508	YES	NO

Table Name: Application

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppName	nchar	508	YES	NO
AppGUID	nchar	80	NO	NO
AppVer	nchar	120	NO	NO
AppComName	nchar	508	YES	NO
AppTypeId	decimal	9	YES	NO
AppParAppId	decimal	9	YES	NO
AppDsc	nchar	508	YES	NO
AppCopyright	nchar	508	YES	NO
AppOrder	int	4	NO	NO
AppRetMnuOptWithoutPrm	bit	1	NO	NO
AppCurEnvId	decimal	9	YES	NO
AppBaseAppId	decimal	9	YES	NO
AppCreDate	datetime	8	YES	NO
AppCreUser	nvarchar	500	YES	NO
AppUpdDate	datetime	8	YES	NO
AppUpdUser	nvarchar	500	YES	NO
AppIsBaseApplication	bit	1	NO	NO
AppCliId	nchar	80	YES	NO
AppCliSecret	nchar	240	YES	NO
AppCliUserGUID	nchar	80	YES	NO
AppCliImageURL	nvarchar	4096	YES	NO
AppCliSiteURL	nvarchar	4096	YES	NO
AppCliSiteDomain	nvarchar	4096	YES	NO
AppCliRevoked	datetime	8	YES	NO
AppType	smallint	2	NO	NO
AppCliEncKey	nchar	64	NO	NO
AppCliDefPrmGUID	nchar	80	YES	NO
AppAccessReqPrm	bit	1	NO	NO
AppCliAccessUniqueByUser	bit	1	NO	NO
AppCliAutoRegAnonymousUser	bit	1	NO	NO
AppCliLocalLoginURL	nvarchar	4096	YES	NO
AppCliAllowGetUserAdditionalDa	bit	1	YES	NO
AppCliAllowGetUserRoles	bit	1	YES	NO
AppCliAllowRemoteAuth	bit	1	YES	NO

Table Name: ApplicationLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppLngId	nchar	6	NO	NO
AppNameLng	nchar	508	NO	NO
AppDscLng	nchar	508	YES	NO

Table Name: ApplicationNum

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppNumId	nchar	60	NO	NO
AppNumLast	decimal	9	NO	NO
AppNumDate	datetime	8	NO	NO

Table Name: ApplicationProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppPropId	nchar	120	NO	NO
AppPropToken	nchar	80	NO	NO
AppPropValue	nvarchar	800	YES	NO

Table Name: AppMenu

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppMnuId	decimal	9	NO	NO
AppMnuGUID	nchar	80	NO	NO
AppMnuName	nchar	508	YES	NO
AppMnuSerOpt	decimal	9	NO	NO
AppMnuCreDate	datetime	8	NO	NO
AppMnuCreUser	nvarchar	500	NO	NO
AppMnuUpdDate	datetime	8	NO	NO
AppMnuUpdUser	nvarchar	500	NO	NO
AppMnuDsc	nchar	508	YES	NO
AppMnuToken	nchar	80	NO	NO

Table Name: AppMenuLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppMnuId	decimal	9	NO	NO
AppMnuLngId	nchar	6	NO	NO
AppMnuNameLng	nchar	508	YES	NO
AppMnuDscLng	nchar	508	YES	NO

Table Name: AppMenuOption

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppMnuId	decimal	9	NO	NO
AppMnuOptId	decimal	9	NO	NO
AppMnuOptGUID	nchar	80	NO	NO
AppMnuOptName	nchar	508	YES	NO
AppMnuOptDsc	nchar	508	YES	NO
AppMnuOptCreDate	datetime	8	YES	NO
AppMnuOptCreUser	nvarchar	500	YES	NO
AppMnuOptUpdDate	datetime	8	YES	NO
AppMnuOptUpdUser	nvarchar	500	YES	NO
AppMnuOptOrder	int	4	NO	NO
AppMnuOptType	nchar	2	NO	NO
AppMnuOptRelAppId	decimal	9	YES	NO
AppMnuOptRelPrmPar	nvarchar	4096	YES	NO
AppMnuOptRelMnuId	decimal	9	YES	NO
AppMnuOptRelPrmGUID	nchar	80	YES	NO
AppMnuOptResource	nvarchar	4096	YES	NO

Table Name: AppMenuOptionLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppMnuId	decimal	9	NO	NO
AppMnuOptId	decimal	9	NO	NO
AppMnuOptLngId	nchar	6	NO	NO
AppMnuOptNameLng	nchar	508	YES	NO
AppMnuOptDscLng	nchar	508	YES	NO

Table Name: AppMenuOptionProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppMnuId	decimal	9	NO	NO
AppMnuOptId	decimal	9	NO	NO
AppMnuOptPropId	nchar	120	NO	NO
AppMnuOptPropToken	nchar	80	NO	NO
AppMnuOptPropValue	nvarchar	800	YES	NO

Table Name: AppMenuProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppMnuId	decimal	9	NO	NO
AppMnuPropId	nchar	120	NO	NO
AppMnuPropToken	nchar	80	NO	NO
APPMnuPropValue	nvarchar	800	YES	NO

Table Name: AppPermission

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppPrmGUID	nchar	80	NO	NO
AppPrmName	nchar	508	NO	NO
AppPrmDsc	nchar	508	YES	NO
AppPrmPgmName	nchar	508	YES	NO
AppPrmDefType	nchar	2	NO	NO
AppPrmTokenTypeGUID	nchar	80	YES	NO
AppPrmCreDate	datetime	8	YES	NO
AppPrmCreUser	nvarchar	500	YES	NO
AppPrmUpdDate	datetime	8	YES	NO
AppPrmUpdUser	nvarchar	500	YES	NO
AppPrmCurEnvId	decimal	9	YES	NO
AppPrmPgmPar	nchar	508	YES	NO
AppPrmIsGXAuto	bit	1	NO	NO

Table Name: AppPermissionLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppPrmGUID	nchar	80	NO	NO
AppPrmLngId	nchar	6	NO	NO
AppPrmDscLng	nchar	508	NO	NO
AppPrmNameLng	nchar	508	NO	NO

Table Name: AppPermissionProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppPrmGUID	nchar	80	NO	NO
AppPrmPropId	nchar	120	NO	NO
AppPrmPropToken	nchar	80	NO	NO
AppPrmPropValue	nvarchar	800	NO	NO
AppPrmPropCreDate	datetime	8	YES	NO
AppPrmPropCreUser	nvarchar	500	YES	NO
AppPrmPropUpdDate	datetime	8	YES	NO
AppPrmPropUpdUser	nvarchar	500	YES	NO

Table Name: AppPrmMemPrm

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppPrmMemPrmParent	nchar	80	NO	NO
AppPrmMemPrmChild	nchar	80	NO	NO
AppPrmMemPrmCreDate	datetime	8	YES	NO
AppPrmMemPrmCreUser	nvarchar	500	YES	NO
AppPrmMemPrmUpdDate	datetime	8	YES	NO
AppPrmMemPrmUpdUser	nvarchar	500	YES	NO

Table Name: AppPrmTokenType

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppPrmTokenTypeGUID	nchar	80	NO	NO
AppPrmTokenTypeName	nchar	508	NO	NO
AppPrmTokenTypeDsc	nchar	508	YES	NO
AppPrmTokenTypeCreDate	datetime	8	YES	NO
AppPrmTokenTypeCreUser	nvarchar	500	YES	NO
AppPrmTokenTypeUpdDate	datetime	8	YES	NO
AppPrmTokenTypeUpdUser	nvarchar	500	YES	NO

Table Name: AppPrmTokenTypeEle

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppPrmTokenTypeGUID	nchar	80	NO	NO
AppPrmTokenEleName	nchar	120	NO	NO
AppPrmTokenEleDsc	nchar	508	NO	NO
AppPrmTokenEleWSHost	nchar	508	NO	NO
AppPrmTokenELWSName	nchar	508	NO	NO
AppPrmTokenEleOrder	int	4	NO	NO

Table Name: AppPrmTokenTypeLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppId	decimal	9	NO	NO
AppPrmTokenTypeGUID	nchar	80	NO	NO
AppPrmTokenTypeLngId	nchar	6	NO	NO
AppPrmTokenTypeNameLng	nchar	508	NO	NO
AppPrmTokenTypeDscLng	nchar	508	YES	NO

Table Name: AppRole

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppRoleAppId	decimal	9	NO	NO
AppRoleRoleId	decimal	9	NO	NO
AppRoleCreDate	datetime	8	YES	NO
AppRoleCreUser	nvarchar	500	YES	NO
AppRoleUpdDate	datetime	8	YES	NO
AppRoleUpdUser	nvarchar	500	YES	NO
AppRoleTokenTypeGUID	nchar	80	YES	NO

Table Name: AppRoleRest

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppRoleAppId	decimal	9	NO	NO
AppRoleRoleId	decimal	9	NO	NO
AppRoleRestToken	nchar	80	NO	NO

Table Name: AppType

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppTypeId	decimal	9	NO	NO
AppTypeGUID	nchar	80	NO	NO
AppTypeName	nchar	508	NO	NO
AppTypeDsc	nchar	508	NO	NO
AppTypeCreDate	datetime	8	YES	NO
AppTypeCreUser	nvarchar	500	YES	NO
AppTypeUpdDate	datetime	8	YES	NO
AppTypeUpdUser	nvarchar	500	YES	NO

Table Name: AppTypeAction

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppTypeId	decimal	9	NO	NO
AppTypeActId	decimal	9	NO	NO
AppTypeActGUID	nchar	80	NO	NO
AppTypeActName	nchar	508	NO	NO
AppTypeActDsc	nchar	508	YES	NO
AppTypeActCreDate	datetime	8	YES	NO
AppTypeActCreUser	nvarchar	500	YES	NO
AppTypeActUpdDate	datetime	8	YES	NO
AppTypeActUpdUser	nvarchar	500	YES	NO

Table Name: AppTypePermission

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppTypeId	decimal	9	NO	NO
AppTypePrmId	decimal	9	NO	NO
AppTypePrmGUID	nchar	80	NO	NO
AppTypeResId	decimal	9	NO	NO
AppTypeActId	decimal	9	NO	NO
AppTypePrmIsParent	bit	1	NO	NO
AppTypePrmCreDate	datetime	8	YES	NO
AppTypePrmCreUser	varchar	500	YES	NO
AppTypePrmUpdDate	datetime	8	YES	NO
AppTypePrmUpdUser	varchar	500	YES	NO

Table Name: AppTypePrmMemPrm

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppTypeId	decimal	9	NO	NO
AppTypePrmMemPrmParId	decimal	9	NO	NO
AppTypePrmMemPrmChiId	decimal	9	NO	NO
AppTypePrmMemPrmCreDate	datetime	8	YES	NO
AppTypePrmMemPrmCreUser	nvarchar	500	YES	NO
AppTypePrmMemPrmUpdDate	datetime	8	YES	NO
AppTypePrmMemPrmUpdUser	nvarchar	500	YES	NO

Table Name: AppTypeResource

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AppTypeId	decimal	9	NO	NO
AppTypeResId	decimal	9	NO	NO
AppTypeResGUID	nchar	8	NO	NO
AppTypeResName	nchar	508	NO	NO
AppTypeResDsc	nchar	508	YES	NO
AppTypeResCreDate	datetime	8	YES	NO
AppTypeResCreUser	nvarchar	500	YES	NO
AppTypeResUpdDate	datetime	8	YES	NO
AppTypeResUpdUser	nvarchar	500	YES	NO

Table Name: Auditory

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AudId	int	4	NO	NO
AuSesRepId	int	4	NO	NO
AudSesToken	nchar	240	NO	NO
AudDate	datetime	8	NO	NO
AudActId	decimal	9	NO	NO
AudPgmName	nchar	508	NO	NO
AudActKey1	decimal	9	YES	NO
AudActKey2	decimal	9	YES	NO
AudActKey3	decimal	9	YES	NO
AudActKey4	decimal	9	YES	NO
AudActPreDet	nvarchar	4096	YES	NO
AudActCurDet	nvarchar	4096	YES	NO
AudActionKeyGUID1	nchar	80	YES	NO
AudActionKeyGUID2	nchar	80	YES	NO
AudActionKeyChar1	nchar	508	YES	NO

Table Name: AuditoryAction

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
AudActId	decimal	9	NO	NO
AudActDsc	nchar	508	NO	NO

Table Name: AuditoryActionLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
AudActId	decimal	9	NO	NO
AudActLngId	nchar	6	NO	NO
AudActDscLng	nchar	508	NO	NO

Table Name: AuthenticationType

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AutTypeName	nchar	120	NO	NO
AutTypeType	nchar	60	NO	NO
AutTypeFunc	nchar	60	NO	NO
AutTypeIsEna	bit	1	NO	NO
AutTypeDsc	nchar	240	YES	NO
AutTypeCreDate	datetime	8	NO	NO
AutTypeCreUser	nvarchar	500	NO	NO
AutTypeUpdDate	datetime	8	NO	NO
AutTypeUpdUser	nvarchar	500	NO	NO

Table Name: AuthenticationTypeLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AutTypeName	nchar	120	NO	NO
AutTypeLngId	nchar	6	NO	NO
AutTypeNameLng	nchar	508	YES	NO
AutTypeDscLng	nchar	508	YES	NO

Table Name: AuthenticationTypeProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
AutTypeName	nchar	120	NO	NO
AutTypePropId	nchar	120	NO	NO
AutTypePropToken	nchar	80	NO	NO
AutTypePropValue	nvarchar	800	YES	NO

Table Name: Browser

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
BrwId	smallint	2	NO	NO
BrwDsc	nchar	120	YES	NO
BrwVer	nchar	120	YES	NO

Table Name: Country

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
CountryId	nchar	18	NO	NO
CountryName	nchar	240	NO	NO
Country_iso_3	nchar	6	NO	NO
CountryCreDate	datetime	8	YES	NO
CountryCreUser	nvarchar	500	YES	NO
CountryUpdDate	datetime	8	YES	NO
CountryUpdUser	nvarchar	500	YES	NO

Table Name: CountryLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
CountryId	nchar	18	NO	NO
CountryLngId	nchar	6	NO	NO
CountryNameLng	nchar	240	NO	NO

Table Name: OauthGrantUserApp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
OGUserAppCode	nchar	240	NO	NO
AppId	decimal	9	NO	NO
UserGUID	nchar	80	NO	NO
OGUserAppSesToken	nchar	240	YES	NO
OGUserAppRefreshToken	nchar	80	YES	NO
OGUserAppGrantDate	datetime	8	YES	NO
OGUserAppRevokedDate	datetime	8	YES	NO
OGUserAppCreDate	datetime	8	YES	NO
OGUserAppCreUsesr	nvarchar	500	YES	NO
OGUserAppUpdDate	datetime	8	YES	NO
OGUserAppUpdUser	nvarchar	500	YES	NO
AppPrmGUID	nchar	80	NO	NO
OGUserAppExpire	datetime	8	YES	NO
OGUserAppStatus	nchar	2	NO	NO

Table Name: OperatingSystem

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
OpeSysId	smallint	2	NO	NO
OpeSysDsc	nchar	120	NO	NO
OpeSysVer	nchar	120	NO	NO
OpeSysCreDate	datetime	8	YES	NO
OpeSysCreUser	nvarchar	500	YES	NO
OpeSysUpdDate	datetime	8	YES	NO
OpeSysUpdUser	nvarchar	500	YES	NO

Table Name: Repository

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RepVer	nchar	120	NO	NO
RepUpg	nchar	120	NO	NO
RepDefAutTypeName	nchar	120	YES	NO
RepUserActType	nchar	2	NO	NO
RepUserActTimeOut	smallint	2	NO	NO
RepDefSecPolId	int	4	YES	NO
RepGenAud	nchar	40	NO	NO
RepUserRemMeTimeOut	smallint	2	NO	NO
RepGenSesSta	nchar	40	NO	NO
RepUserChrMinLog	smallint	2	NO	NO
RepGUID	nchar	80	NO	NO
RepCanRegUser	bit	1	NO	NO
RepUserRemMeType	nchar	12	NO	NO
RepGiveAnoSes	bit	1	NO	NO
RepAnoUserGUID	nchar	80	YES	NO
RepDefRoleId	decimal	9	YES	NO
RepCreDate	datetime	8	NO	NO
RepCreUser	nvarchar	500	NO	NO
RepUpdDate	datetime	8	NO	NO
RepUpdUser	nvarchar	500	NO	NO
RepNameSpace	nchar	120	NO	NO
RepUserRecPwdKeyTimeOut	smallint	2	NO	NO
RepUserReqPwd	bit	1	NO	NO
RepUserReqEmail	bit	1	NO	NO
RepUserReqFirstName	bit	1	NO	NO
RepUserReqLastName	bit	1	NO	NO
RepUserReqBir	bit	1	NO	NO
RepUserReqGen	bit	1	NO	NO
RepUserReqPhone	bit	1	NO	NO
RepUserReqAddress	bit	1	NO	NO
RepUserReqCity	bit	1	NO	NO
RepUserReqState	bit	1	NO	NO
RepUserReqCountry	bit	1	NO	NO
RepUserReqPostCode	bit	1	NO	NO
RepUserReqLng	bit	1	NO	NO
RepUserReqTimeZone	bit	1	NO	NO
RepUserReqPhoto	bit	1	NO	NO
RepUserAttLogLockUser	smallint	2	NO	NO
RepUserAttLogLockSession	smallint	2	NO	NO
RepDsc	nchar	508	YES	NO
RepUserEmailSecAdm	nchar	508	YES	NO
RepUserTimeToUnblock	smallint	2	NO	NO
RepName	nchar	120	NO	NO
RepUserEmailUnique	bit	1	NO	NO
RepAllowOauthAccess	bit	1	NO	NO
RepUserIdentification	nchar	12	NO	NO
RepKeepSesOnlyOrilP	bit	1	NO	NO
RepUserSessionCacheTimeout	smallint	2	NO	NO
RepAnoUsrSDRoleId	decimal	9	YES	NO

Table Name: RepositoryConnAdd

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RepConName	nchar	240	NO	NO
RepConSrvCon	nchar	120	NO	NO

Table Name: RepositoryConnection

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RepConName	nchar	240	NO	NO
RepConUser	nchar	200	NO	NO
RepConPwd	nchar	508	NO	NO
RepConLng	nchar	6	NO	NO
RepConType	nchar	60	NO	NO
RepConKey	nchar	64	NO	NO
RepConChaExpire	int	4	NO	NO
RepConSrvSpecify	bit	1	NO	NO
RepConChaSrv	nchar	120	YES	NO
RepConChaDate	datetime	8	YES	NO
RepConCha	nchar	508	YES	NO
RepConCreDate	datetime	8	NO	NO
RepConCreUser	nvarchar	500	NO	NO
RepConUpdDate	datetime	8	NO	NO
RepConUpdUser	nvarchar	500	NO	NO

Table Name: RepositoryCountry

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
CountryId	nchar	18	NO	NO
RepCountryCreDate	datetime	8	YES	NO
RepCountryCreUser	nvarchar	500	YES	NO
RepCountryUpdDate	datetime	8	YES	NO
RepCountryUpdUser	nvarchar	500	YES	NO

Table Name: RepositoryLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RepLngId	nchar	6	NO	NO
RepNameLng	nchar	508	YES	NO
RepDscLng	nchar	508	YES	NO

Table Name: RepositoryNum

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RepNumId	nchar	60	NO	NO
RepNumLast	decimal	9	NO	NO
RepNumDate	datetime	8	NO	NO

Table Name: RepositoryProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RepPropId	nchar	120	NO	NO
RepPropToken	nchar	80	NO	NO
RepPropVal	nvarchar	800	YES	NO

Table Name: RepQuestionUser

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
QstUserId	int	4	NO	NO
QstUserName	nchar	508	YES	NO
QstUserDsc	nchar	508	YES	NO
QstUserCreDate	datetime	8	NO	NO
QstUserCreUser	nvarchar	500	NO	NO
QstUserUpdDate	datetime	8	NO	NO
QstUserUpdUser	nvarchar	500	NO	NO
QstUserGUID	nchar	80	NO	NO

Table Name: RepQuestionUserLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
QstUserId	int	4	NO	NO
QstUserLngId	nchar	6	NO	NO
QstUserNameLng	nchar	508	YES	NO
QstUserDscLng	nchar	508	YES	NO

Table Name: Role

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RoleId	decimal	9	NO	NO
RoleExtId	nvarchar	200	YES	NO
RoleSecPolId	int	4	YES	NO
RoleGUID	nchar	80	NO	NO
RoleName	nchar	508	YES	NO
RoleDsc	nchar	508	YES	NO
RoleCreDate	datetime	8	YES	NO
RoleCreUser	nvarchar	500	YES	NO
RoleUpdDate	datetime	8	YES	NO
RoleUpdUser	nvarchar	500	YES	NO

Table Name: RoleAppPrm

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RoleId	decimal	9	NO	NO
AppId	decimal	9	NO	NO
AppPrmGUID	nchar	80	NO	NO
RoleAppPrmToken	nchar	508	NO	NO
RoleAppPrmType	nchar	2	NO	NO
RoleAppPrmTypRoleAppPrmInh	bit	1	NO	NO
RoleAppPrmCreDate	datetime	8	YES	NO
RoleAppPrmCreUser	nvarchar	500	YES	NO
RoleAppPrmUpdDate	datetime	8	YES	NO
RoleAppPrmUpdUser	nvarchar	500	YES	NO
AppPrmName	nchar	508	NO	NO

Table Name: RoleAppPrmProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RoleId	decimal	9	NO	NO
AppId	decimal	9	NO	NO
AppPrmGUID	nchar	80	NO	NO
RoleAppPrmToken	nchar	508	NO	NO
RoleAppPrmPropId	nchar	120	NO	NO
RoleAppPrmPropToken	nchar	80	NO	NO
RoleAppPrmPropValue	nvarchar	800	NO	NO
RoleAppPrmPropCreDate	datetime	8	NO	NO
RoleAppPrmPropCreUser	nvarchar	500	NO	NO
RoleAppPrmPropUpdDate	datetime	8	NO	NO
RoleAppPrmPropUpdUser	nvarchar	500	NO	NO

Table Name: RoleAppTypePrm

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RoleId	decimal	9	NO	NO
AppTypeId	decimal	9	NO	NO
AppTypePrmId	decimal	9	NO	NO
RoleAppTypePrmType	nchar	2	NO	NO
RoleAppTypePrmInh	bit	1	NO	NO
RoleAppTypePrmAllItems	bit	1	NO	NO
RoleAppTypePrmCreDate	datetime	8	YES	NO
RoleAppTypePrmCreUser	nvarchar	500	YES	NO
RoleAppTypePrmUpdDate	datetime	8	YES	NO
RoleAppTypePrmUpdUser	nvarchar	500	YES	NO

Table Name: RoleAppTypePrmProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RoleId	decimal	9	NO	NO
AppTypeId	decimal	9	NO	NO
AppTypePrmId	decimal	9	NO	NO
RoleAppTypePrmPropId	nchar	120	NO	NO
RoleAppTypePrmPropValue	nvarchar	800	NO	NO
RoleAppTypePrmPropCreDate	datetime	8	NO	NO
RoleAppTypePrmPropCreuser	nvarchar	500	NO	NO
RoleAppTypePrmPropUpdDate	datetime	8	NO	NO
RoleAppTypePrmPropUpdUser	nvarchar	500	NO	NO

Table Name: RoleLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RoleId	decimal	9	NO	NO
RoleLngId	nchar	6	NO	NO
RoleNameLng	nchar	508	YES	NO
RoleDscLng	nchar	508	YES	NO

Table Name: RoleMemRole

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RoleMemRoleParent	decimal	9	NO	NO
RoleMemRoleChild	decimal	9	NO	NO
RoleMemRoleCreDate	datetime	8	YES	NO
RoleMemRoleCreuser	nvarchar	500	YES	NO
RoleMemRoleUpdDate	datetime	8	YES	NO
RoleMemRoleUpdUser	nvarchar	500	YES	NO

Table Name: RoleProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
RoleId	decimal	9	NO	NO
RolePropId	nchar	120	NO	NO
RolePropToken	nchar	80	NO	NO
RolePropValue	nvarchar	800	YES	NO

Table Name: SecurityPolicy

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
SecPolId	int	4	NO	NO
SecPolPerChgPwd	smallint	2	NO	NO
SecPolSesTimeOut	smallint	2	NO	NO
SecPolMinLenPwd	smallint	2	NO	NO
SecPolAmoCharNumericPwd	smallint	2	NO	NO
SecPolAmoHisPwd	smallint	2	NO	NO
SecPolName	nchar	508	YES	NO
SecPolGUID	nchar	80	NO	NO
SecPolCreDate	datetime	8	YES	NO
SecPolCreUser	nvarchar	500	YES	NO
SecPolUpdDate	datetime	8	YES	NO
SecPolUpdUser	nvarchar	500	YES	NO
SecPolDsc	nchar	508	YES	NO
SecPolOauthTokenExpire	int	4	NO	NO
SecPolAmoCharUpperCasePwd	smallint	2	NO	NO
SecPolAmoCharspecialPwd	smallint	2	NO	NO
SecPolOauthGrantExpire	int	4	NO	NO
SecPolActSesPerUser	smallint	2	NO	NO
SecPolOauthTokenMaxRenew	smallint	2	NO	NO
SecPolFrecMinChangePwd	smallint	2	NO	NO

Table Name: SecurityPolicyLng

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
SecPolId	int	4	NO	NO
SecPolLngId	nchar	6	NO	NO
SecPolNameLng	nchar	508	NO	NO
SecPolDscLng	nchar	508	YES	NO

Table Name: SecurityPolicyProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
SecPolId	int	4	NO	NO
SecPolPropId	nchar	120	NO	NO
SecPolPropToken	nchar	80	NO	NO
SecPolPropValue	nvarchar	800	NO	NO

Table Name: Session

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
SesToken	nchar	240	NO	NO
SesDate	datetime	8	NO	NO
SesSts	nchar	2	NO	NO
SesType	smallint	2	NO	NO
SesURL	nvarchar	4096	NO	NO
SesPAdd	nchar	120	NO	NO
SesSysId	smallint	2	YES	NO
SesLastAcc	datetime	8	NO	NO
SesTimeOut	smallint	2	NO	NO
SesLogAtt	int	4	NO	NO
SesLogDate	datetime	8	NO	NO
SesSharedData	nvarchar	-1	NO	NO
SesEndDate	datetime	8	NO	NO
SesReload	bit	1	NO	NO
BrwId	smallint	2	YES	NO
SesLastURL	nvarchar	4096	NO	NO
SesLogin	nvarchar	500	NO	NO
SesExtToken	nchar	240	NO	NO
UserGUID	nchar	80	YES	NO
SesAppTokenExp	datetime	8	YES	NO
SesRefreshToken	nchar	80	YES	NO
SesAppId	decimal	9	YES	NO
SesDevideId	nchar	80	YES	NO
SesExtToken2	nvarchar	2048	YES	NO
SesAutTypeName	nchar	120	YES	NO
SesOauthTokenMaxRenew	smallint	2	YES	NO
SesOauthTokenExpires	int	4	YES	NO
SesOauthScope	nvarchar	4096	YES	NO
SesExtToken3	nvarchar	-1	YES	NO
SesExtTokenExpires	datetime	8	YES	NO
SesExtTokenRefresh	nvarchar	4000	YES	NO
SesJson	nvarchar	-1	YES	NO

Table Name: SessionHistory

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
SesHisToken	nchar	240	NO	NO
SesHisLogin	nvarchar	500	NO	NO
SesHisDate	datetime	8	NO	NO
SesHisSts	nchar	2	NO	NO
SesHisType	smallint	2	NO	NO
SesHisURL	nvarchar	4096	NO	NO
SesHisIPAdd	nchar	120	NO	NO
BrwId	smallint	2	YES	NO
OpeSysId	smallint	2	YES	NO
SesHisLastAcc	datetime	8	NO	NO
SesHisLastURL	nvarchar	4096	NO	NO
SesHisTimeOut	smallint	2	NO	NO
SesHisExtToken	nchar	240	NO	NO
SesHisLogAtt	int	4	NO	NO
SesHisLogDate	datetime	8	NO	NO
SesHisSharedData	nvarchar	-1	NO	NO
SesHisEndDate	datetime	8	NO	NO
UserGUID	nchar	80	NO	NO
SesHisExtToken2	nvarchar	2048	YES	NO
SesHisAppId	decimal	9	YES	NO
SesHisRefreshToken	nchar	80	YES	NO
SesHisDevideId	nchar	80	YES	NO
SesHisAppTokenExp	datetime	8	YES	NO
SesHisOauthTokenMaxRenew	smallint	2	YES	NO
SesHisOauthtokenExpires	int	4	YES	NO
SesHisOauthScope	nvarchar	4096	YES	NO
SesHisExtToken3	nvarchar	-1	YES	NO
SesHisExtTokenExpires	datetime	8	YES	NO
SesHisExtTokenRefresh	nvarchar	4000	YES	NO
SesHisAutTypeName	char	120	YES	NO
SesHisJson	nvarchar	-1	YES	NO

Table Name: SessionHistoryLog

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
SesHisToken	nchar	240	NO	NO
SesHisLogGuid	nchar	80	NO	NO
SesHisLogDateTime	datetime	8	NO	NO
SesHisLogType	nchar	60	NO	NO
SesHisLogDetail	nvarchar	-1	YES	NO

Table Name: SessionHistoryLogAtt

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
SesHisToken	nchar	240	NO	NO
SesHisAttUserLog	nvarchar	500	NO	NO
SesHisAttQtyLog	smallint	2	NO	NO

Table Name: SessionLog

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
SesToken	nchar	240	NO	NO
SesLogGuid	nchar	80	NO	NO
SesLogDateTime	datetime	8	NO	NO
SesLogType	nchar	60	NO	NO
SesLogDetail	nvarchar	-1	YES	NO

Table Name: SessionLogAtt

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
SesToken	nchar	240	NO	NO
SesAttUserLog	nvarchar	500	NO	NO
SesAttQtyLog	smallint	2	NO	NO

Table Name: SysPar

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description
SysParId	nchar	60	NO	NO
SysParVal	nchar	508	NO	NO

Table Name: User

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
UserNameSpace	nchar	120	NO	NO
UserAutTypeName	nchar	120	NO	NO
UserName	nvarchar	200	NO	NO
UserEMail	nvarchar	200	NO	NO
UserExtId	nvarchar	200	YES	NO
UserPwd	nchar	508	NO	NO
UserFirstName	nchar	120	YES	NO
UserLastName	nchar	120	YES	NO
UserBirthday	datetime	8	YES	NO
UserGender	nchar	2	NO	NO
UserPhone	nchar	508	YES	NO
UserAdress	nchar	508	YES	NO
UserAdress2	nchar	508	YES	NO
UserCity	nchar	508	YES	NO
UserState	nchar	508	YES	NO
CountryId	nchar	18	YES	NO
UserPostCode	nchar	120	YES	NO
UserLng	nchar	6	YES	NO
UserTimeZone	nchar	120	YES	NO
UserPhoto	varbinary	-1	YES	NO
UserPhoto_GXI	varchar	2048	YES	NO
UserNotRcvInf	bit	1	NO	NO
UserIsBlk	bit	1	NO	NO
UserBlkLastDate	datetime	8	YES	NO
UserIsAct	bit	1	NO	NO
UserActKey	nchar	508	YES	NO
UserActDate	datetime	8	YES	NO
UserNotChgPwd	bit	1	NO	NO
UserChgPwdNexLog	bit	1	NO	NO
UserPwdNevExp	bit	1	NO	NO
UserRecPwdKey	nchar	508	YES	NO
UserRecPwdKeyExp	datetime	8	YES	NO
UserDateLastChgPwd	datetime	8	YES	NO
UserIsDlt	bit	1	NO	NO
UserDateLastAuth	datetime	8	YES	NO
UserCreDate	datetime	8	YES	NO
UserCreUser	nvarchar	500	YES	NO
UserUpdDate	datetime	8	YES	NO
UserUpdUser	nvarchar	500	YES	NO
UserURLImage	nvarchar	4096	YES	NO
UserURLProf	nvarchar	4096	YES	NO
UserDataReqComplete	bit	1	NO	NO
UserDataReqCompleteKey	nchar	508	YES	NO
UserIsDevice	bit	1	NO	NO
UserPwdEncryption	nchar	6	YES	NO

Table Name: UserAppPrm

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
UserGUID	nchar	80	NO	NO
AppId	decimal	9	NO	NO
AppPrmGUID	nchar	80	NO	NO
UserAppPrmToken	nchar	508	NO	NO
UserAppPrmType	nchar	2	NO	NO
UserAppPrmInh	bit	1	NO	NO
UserAppPrmCreDate	datetime	8	YES	NO
UserAppPrmCreUser	nvarchar	500	YES	NO
UserAppPrmUpdDate	datetime	8	YES	NO
UserAppPrmUpdUser	nvarchar	500	YES	NO

Table Name: UserAppPrmProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
RepId	int	4	NO	NO
UserGUID	nchar	80	NO	NO
AppId	decimal	9	NO	NO
AppPrmGUID	nchar	80	NO	NO
UserAppPrmToken	nchar	508	NO	NO
UserAppPrmPropId	nchar	120	NO	NO
UserAppPrmPropToken	nchar	80	NO	NO
UserAppPrmPropValue	nvarchar	800	YES	NO
UserAppPrmPropCreDate	datetime	8	YES	NO
UserAppPrmPropCreuser	nvarchar	500	YES	NO
UserAppPrmPropUpdDate	datetime	8	YES	NO
UserAppPrmPropUpdUser	nvarchar	500	YES	NO

Table Name: UserAtt

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
UserAttId	nchar	120	NO	NO
UserAttIsMV	bit	1	NO	NO
UserAttVal	nvarchar	800	YES	NO
UserAttToken	nchar	80	YES	NO

Table Name: UserAttMultiValue

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
UserAttId	nchar	120	NO	NO
UserAttMVId	nchar	120	NO	NO
UserAttMVVal	nvarchar	800	YES	NO

Table Name: UserHisPwd

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
UserHisPwdDate	datetime	8	NO	NO
UserHisPwdPwd	nchar	508	NO	NO

Table Name: UserMemAppRole

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
RepId	int	4	NO	NO
UserMemAppRoleAppId	decimal	9	NO	NO
UserMemAppRoleRoleId	decimal	9	NO	NO
UserMemAppRoleCreDate	datetime	8	YES	NO
UserMemAppRoleCreUser	nvarchar	500	YES	NO
UserMemAppRoleUpdDate	datetime	8	YES	NO
UserMemAppRoleUpdUser	nvarchar	500	YES	NO

Table Name: UserMemAppRoleProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
RepId	int	4	NO	NO
UserMemAppRoleAppId	decimal	9	NO	NO
UserMemAppRoleRoleId	decimal	9	NO	NO
UserMemAppRolePropId	nchar	120	NO	NO
UserMemAppRolePropToken	nchar	80	NO	NO
UserMemAppRolePropValue	nvarchar	800	NO	NO

Table Name: UserMemAppRoleRest

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
RepId	int	4	NO	NO
UserMemAppRoleAppId	decimal	9	NO	NO
UserMemAppRoleRoleId	decimal	9	NO	NO
UserMemAppRoleRestToken	nchar	80	NO	NO

Table Name: UserMemRole

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
RepId	int	4	NO	NO
UserMemRoleRoleId	decimal	9	NO	NO
UserMemRoleCreDate	datetime	8	YES	NO
UserMemRoleCreUser	nvarchar	500	YES	NO
UserMemRoleUpdDate	datetime	8	YES	NO
UsermemRoleUpdUser	nvarchar	500	YES	NO

Table Name: UserMemRoleProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
RepId	int	4	NO	NO
UserMemRoleRoleId	decimal	9	NO	NO
UserMemRolePropId	nchar	120	NO	NO
UserMemRolePropToken	nchar	80	NO	NO
UserMemRolePropValue	nvarchar	800	NO	NO

Table Name: UserRepository

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
RepId	int	4	NO	NO
UserRepSecPolId	int	4	YES	NO
UserRepMainRoleId	decimal	9	YES	NO
UserRepCreDate	datetime	8	YES	NO
UserRepCreUser	nvarchar	500	YES	NO
UserRepUpdDate	datetime	8	YES	NO
UserRepUpdUser	nvarchar	500	YES	NO
UserRepRecPwdAns	nchar	508	YES	NO
UserRepQstUserId	int	4	YES	NO

Table Name: UserRepositoryProp

SchemaName: gam

ColumnName	DataType	MaxLength	IsNull	IsIdentity	Description

ColumnName	DataType	MaxLength	IsNull	IsIdentity
UserGUID	nchar	80	NO	NO
RepId	int	4	NO	NO
UserRepPropId	nchar	120	NO	NO
UserRepPropToken	nchar	80	NO	NO
UserRepPropValue	nvarchar	800	YES	NO