Database DataStore Tables

Table	t_Connections
	Column Name	Type	Length
primary key	ConnectionID	Number	n/a
	ConnectionString	Text	255
	DatabasePassword	Text	255
	DatabaseServer	Text	255
	DatabaseUserName	Text	255
	UseConnectionString	Yes	2
	UseTrustedConnection	Yes	2

Table	t_Databases
	Column Name	Type	Length
primary key	DatabaseID	Number	n/a
	DatabaseName	Text	255
	fk_ConnectionID	Number	n/a
	fk_ProjectID	Number	n/a

Table	t_FullTextCatalogsTableColumns
	Column Name	Type	Length
	fk_ColumnID	Number	n/a
	fk_TableID	Number	n/a

Table	t_FullTextCatalogsTables
	Column Name	Type	Length
	FullTextCatalogTableIndexName	Text	255
	fk_FullTextCatalogID	Number	n/a
	fk_TableID	Number	n/a

Table	t_FullTextCatalogs
	Column Name	Type	Length
primary key	FullTextCatalogID	Number	n/a
	FullTextCatalogName	Text	255
	FullTextCatalogNumberOfTables	Number	n/a
	fk_DatabaseID	Number	n/a
	fk_ParseID	Number	n/a

Table	t_JobSchedules
	Column Name	Type	Length
	JobScheduleCreateDate	Date	n/a
	JobScheduleDescription	Memo	n/a
	JobScheduleEndDate	Date	n/a
	JobScheduleEndTime	Text	10
	JobScheduleFrequencyInterval	Text	255
	JobScheduleFrequencyType	Text	255
primary key	JobScheduleID	Number	n/a
	JobScheduleIsEnabled	Yes	2
	JobScheduleName	Text	255
	JobScheduleStartDate	Date	n/a
	JobScheduleStartTime	Text	10
	fk_JobID	Number	n/a

Table	t_JobSteps
	Column Name	Type	Length
	JobStepCommand	Memo	n/a
primary key	JobStepID	Number	n/a
	JobStepName	Text	255
	JobStepOnFailActionID	Number	n/a
	JobStepOnFailAction	Text	50
	JobStepOnFailSQLID	Number	n/a
	JobStepOnSuccessActionID	Number	n/a
	JobStepOnSuccessAction	Text	50
	JobStepOnSuccessSQLID	Number	n/a
	JobStepRetryAttempts	Number	n/a
	JobStepRetryInterval	Number	n/a
	JobStepSQLID	Number	n/a
	JobStepSubsystem	Text	40
	fk_JobID	Number	n/a

Table	t_Jobs
	Column Name	Type	Length
	JobCategory	Text	255
	JobCreateDate	Date	n/a
	JobDescription	Memo	n/a
primary key	JobID	Number	n/a
	JobIsEnabled	Yes	2
	JobModifiedDate	Date	n/a
	JobName	Text	255
	JobOwner	Text	255
	JobStartStepID	Number	n/a
	fk_ConnectionID	Number	n/a
	fk_ParseID	Number	n/a

Table	t_Packages
	Column Name	Type	Length
	PackageCreateDate	Date	n/a
	PackageDescription	Memo	n/a
primary key	PackageID	Number	n/a
	PackageName	Text	255
	PackageOwner	Text	255
	PackageSize	Number	n/a
	fk_ConnectionID	Number	n/a
	fk_ParseID	Number	n/a

Table	t_Parses
	Column Name	Type	Length
	ParseDate	Date	n/a
primary key	ParseID	Number	n/a
	fk_ProjectID	Number	n/a

Table	t_Projects
	Column Name	Type	Length
	AddRobotsNoIndexToOutput	Yes	2
	ColourCodeSource	Yes	2
	DocumentDTSPackages	Yes	2
	DocumentJobs	Yes	2
	DocumentRelationships	Yes	2
	DocumentStoredProcedures	Yes	2
	DocumentTableColumnDescriptions	Yes	2
	DocumentTables	Yes	2
	DocumentTriggers	Yes	2
	DocumentViews	Yes	2
	HTMLHelpFoldersOrBooks	Text	10
	HTMLHelpOutput	Yes	2
	HTMLOutput	Yes	2
primary key	ProjectID	Number	n/a
	ProjectName	Text	255
	RTFOutput	Yes	2
	ReportCSS	Text	50
	ReportFolder	Text	255
	ReportTableBodyBGColour	Text	50
	ReportTableBodyFGColour	Text	50
	ReportTableHeaderBGColour	Text	50
	ReportTableHeaderFGColour	Text	50
	TextOutput	Yes	2

Table	t_StoredProcedureColumns
	Column Name	Type	Length
primary key	StoredProcedureColumnID	Number	n/a
	StoredProcedureColumnLength	Number	n/a
	StoredProcedureColumnName	Text	255
	StoredProcedureColumnTypeName	Text	255
	fk_StoredProcedureID	Number	n/a

Table	t_StoredProcedures
	Column Name	Type	Length
primary key	StoredProcedureID	Number	n/a
	StoredProcedureName	Text	255
	StoredProcedureText	Memo	n/a
	fk_DatabaseID	Number	n/a
	fk_ParseID	Number	n/a

Table	t_TableColumns
	Column Name	Type	Length
	ColumnDescription	Memo	n/a
primary key	ColumnID	Number	n/a
	ColumnName	Text	255
	IsIdentity	Yes	2
	IsNullable	Yes	2
	IsPrimaryKey	Yes	2
	Length	Number	n/a
	PrimaryKeySequence	Number	n/a
	TypeName	Text	255
	fk_TableID	Number	n/a

Table	t_TableIndexColumns
	Column Name	Type	Length
primary key	TableIndexColumnID	Number	n/a
	fk_ColumnID	Number	n/a
	fk_IndexID	Number	n/a

Table	t_TableIndexes
	Column Name	Type	Length
	IndexDescription	Memo	n/a
primary key	IndexID	Number	n/a
	IndexName	Text	255
	fk_TableID	Number	n/a

Table	t_TableRelationships
	Column Name	Type	Length
	ForeignKeyName	Text	255
	PrimaryKeyName	Text	255
primary key	TableRelationshipID	Number	n/a
	fk_ForeignKeyColumnID	Number	n/a
	fk_PrimaryKeyColumnID	Number	n/a

Table	t_Tables
	Column Name	Type	Length
	PrimaryKeyName	Text	255
primary key	TableID	Number	n/a
	TableName	Text	255
	fk_DatabaseID	Number	n/a
	fk_ParseID	Number	n/a

Table	t_Triggers
	Column Name	Type	Length
	IsAfter	Yes	2
	IsDelete	Yes	2
	IsInsert	Yes	2
	IsInsteadOf	Yes	2
	IsUpdate	Yes	2
primary key	TriggerID	Number	n/a
	TriggerName	Text	255
	TriggerText	Memo	n/a
	fk_TableID	Number	n/a

Table	t_ViewColumns
	Column Name	Type	Length
primary key	ColumnID	Number	n/a
	ColumnName	Text	255
	IsNullable	Yes	2
	IsPrimaryKey	Yes	2
	Length	Number	n/a
	TypeName	Text	255
	fk_ViewID	Number	n/a

Table	t_Views
	Column Name	Type	Length
primary key	ViewID	Number	n/a
	ViewName	Text	255
	ViewText	Memo	n/a
	fk_DatabaseID	Number	n/a
	fk_ParseID	Number	n/a