Columns

Columns

Table	Type	Column	Type	Size	Nulls	Auto	Default	Comments
vAvailableBaseObjects	View	ModifiedDate	datetime	16	√		null
AvailableService	Table	AvailableServiceSeq	int identity	4		√	null
Consumer	Table	Env_Shared_Secret	nvarchar	512			null
ServicePath	Table	PathRefID	uniqueidentifier	16			null
Consumer	Table	ConsumerSeq	int identity	4		√	null
Setting	Table	DefaultValue	varchar	1000	√		null
EventType	Table	EventType	varchar	100			null
ConsumerPermission	Table	ModifiedBy	varchar	100	√		null
ConsumerPermission	Table	ModifiedDate	datetime	16	√		null
ConsumerEnvironment	Table	InterfaceVersion	varchar	50			null
Capability	Table	Code	varchar	50			null
ConsumerPermission	Table	AvailableServiceSeq	int	4			null
EventLog	Table	EventLogSeq	int identity	4		√	null
ServicePath	Table	PathObjectType	varchar	100			null
BaseObject	Table	PK_2	varchar	255	√		null
EventLog	Table	EventSource	varchar	100	√		null
ConsumerPermission	Table	ConsumerPermissionSeq	int identity	4		√	null
Consumer	Table	RowVersion	int	4			((1))
Setting	Table	DataType	varchar	20			null
Setting	Table	Title	varchar	100	√		null
BaseObjectXref	Table	BaseObjectRefID	uniqueidentifier	16			null
EventType	Table	EventTypeSeq	int identity	4		√	null
Resource	Table	ResourceSeq	int identity	4		√	null
ConsumerEnvironment	Table	ContextSeq	int	4			null
ConsumerEnvironment	Table	ActiveFlag	bit	1			((1))
BaseObject	Table	ObjectVersion	varchar	50	√		null
Consumer	Table	Env_Application_Register_ID	int	4	√		null
Consumer	Table	Name	varchar	100			null
Capability	Table	Env_Right_Type	nvarchar	512			null
ServicePath	Table	ForRefID	uniqueidentifier	16			null
Setting	Table	ReadOnlyFlag	bit	1			null
ConsumerEnvironment	Table	Env_Provisioned_Zone_Id	bigint	8	√		null
BaseObject	Table	SchoolInfoSIF3RefID	uniqueidentifier	16	√		null
Context	Table	Description	varchar	1000			null
BaseObjectXref	Table	TableSchema	varchar	100			null
Setting	Table	Key	varchar	100			null
ConsumerEnvironment	Table	Env_Zone_ID	int	4			null
BaseObject	Table	ModifiedDate	datetime	16	√		null
Resource	Table	Code	varchar	50			null
Setting	Table	SettingSeq	int identity	4		√	null
Consumer	Table	ModifiedDate	datetime	16	√		null
BaseObject	Table	CreatedDate	datetime	16	√		(getdate())
EventConsumer	Table	LastRetrievalEventCount	int	4	√		null
EventLog	Table	ParentEventLogSeq	int	4	√		null
ConsumerPermission	Table	ConsumerEnvironmentSeq	int	4			null
vAvailableBaseObjects	View	RefID	uniqueidentifier	16			null
Capability	Table	CapabilitySeq	int identity	4		√	null
Setting	Table	Description	varchar	8000	√		null
vAvailableBaseObjects	View	PK_4	varchar	255	√		null
EventConsumer	Table	LastRetrievalEventSeq	int	4	√		null
AvailableService	Table	ContextSeq	int	4			null
ConsumerEnvironment	Table	Env_Environment_Id	uniqueidentifier	16	√		null
BaseObjectXref	Table	TableName	varchar	100			null
Setting	Table	LookupValues	varchar	1000	√		null
EventConsumer	Table	EventSubType	varchar	100	√		('')
EventConsumer	Table	EventConsumerSeq	int identity	4		√	null
EventLog	Table	EventType	varchar	100			null
BaseObjectXref	Table	TableValue	varchar	100			null
ConsumerEnvironment	Table	ModifiedBy	varchar	100	√		null
BaseObject	Table	PK_1	varchar	255			null
Consumer	Table	ModifiedBy	varchar	100	√		null
Capability	Table	Description	varchar	1000			null
vAvailableBaseObjects	View	PK_2	varchar	255	√		null
vAvailableBaseObjects	View	CreatedBy	varchar	100	√		null
Setting	Table	NodeTitle	varchar	100	√		null
Setting	Table	Value	varchar	1000	√		null
EventLog	Table	EventSubType	varchar	100	√		null
vAvailableBaseObjects	View	BaseObjectSeq	bigint identity	8			null
ConsumerEnvironment	Table	ConsumerSeq	int	4			null
Consumer	Table	Token	nvarchar	6000	√		null
BaseObjectXref	Table	BaseObjectXrefSeq	int identity	4		√	null
vAvailableBaseObjects	View	SchoolInfoSIF3RefID	uniqueidentifier	16	√		null
EventConsumer	Table	ActiveFlag	bit	1			null
BaseObject	Table	ModifiedBy	varchar	500	√		null
vAvailableBaseObjects	View	CreatedDate	datetime	16	√		null
EventType	Table	EventSubType	varchar	100	√		null
BaseObject	Table	RefID	uniqueidentifier	16			(newsequentialid())
vAvailableBaseObjects	View	ModifiedBy	varchar	500	√		null
ConsumerEnvironment	Table	RowVersion	int	4			((1))
EventType	Table	ActiveFlag	bit	1			null
BaseObject	Table	BaseObjectSeq	bigint identity	8		√	null
Setting	Table	CentrallyManagedFlag	bit	1			((0))
vAvailableBaseObjects	View	PK_3	varchar	255	√		null
ServicePath	Table	ForObjectPath	varchar	100			null
EventConsumer	Table	LastRetrievalDatetime	datetime	16	√		null
Context	Table	ContextSeq	int identity	4		√	null
Setting	Table	ModifiedBy	varchar	100	√		null
ConsumerEnvironment	Table	ModifiedDate	datetime	16	√		null
AvailableService	Table	ResourceSeq	int	4			null
AvailableService	Table	CapabilitySeq	int	4			null
ServicePath	Table	ServicePathSeq	int identity	4		√	null
BaseObject	Table	ObjectXML	xml	1073741823			null
EventLog	Table	EventResult	varchar	500	√		null
ConsumerPermission	Table	PermittedFlag	bit	1			((0))
vAvailableBaseObjects	View	ContextSeq	int	4	√		null
BaseObject	Table	ObjectType	varchar	100			null
Consumer	Table	ActiveFlag	bit	1			((1))
EventConsumer	Table	EventType	varchar	100			null
vAvailableBaseObjects	View	ObjectXML	xml	1073741823			null
Setting	Table	RowVersion	int	4			((1))
BaseObject	Table	PK_3	varchar	255	√		null
Resource	Table	Description	varchar	1000			null
BaseObject	Table	ContextSeq	int	4	√		null
ConsumerEnvironment	Table	ConsumerEnvironmentSeq	int identity	4		√	null
EventLog	Table	EventDatetime	datetime	16			(getdate())
vAvailableBaseObjects	View	ObjectType	varchar	100			null
vAvailableBaseObjects	View	ObjectVersion	varchar	50	√		null
ConsumerPermission	Table	Env_Service_Id	int	4	√		null
ConsumerPermission	Table	RowVersion	int	4			((1))
Setting	Table	ModifiedDate	datetime	16	√		null
EventConsumer	Table	Consumer	varchar	100			null
Context	Table	Env_Context_Id	nvarchar	256			null
vAvailableBaseObjects	View	PK_1	varchar	255			null
Setting	Table	ParentSettingSeq	int	4	√		((0))
EventLog	Table	Payload	varchar	2147483647	√		null
Resource	Table	Env_Service_Name	nvarchar	512			null
Consumer	Table	Env_Application_Key	nvarchar	512			null
BaseObject	Table	CreatedBy	varchar	100	√		null
BaseObject	Table	PK_4	varchar	255	√		null
BaseObjectXref	Table	TableKey	varchar	100			null