Synergetic_AUVIC_CDA_PROD1.media Database

TABLES 27

COLUMNS 677

Constraints 10

Database Properties

Database Type: Microsoft SQL Server - 13.00.4001

Tables

Table / View	Children	Parents	Columns	Rows	Type
CommunityCorrespondence	0	0	17	-1	Table
CommunityCorrespondenceAttachments	0	0	6	-1	Table
CommunityCorrespondenceRecipients	0	0	8	-1	Table
DebtorStatementsDocuments	1	1	12	-1	Table
DebtorStatementsDocumentsPreviewLog	0	0	6	-1	Table
DocumentReferences	0	1	2	-1	Table
DocumentReferencesArchive	0	0	2	-1	Table
NotificationCorrespondence	1	0	21	-1	Table
NotificationCorrespondenceRecipients	1	1	11	-1	Table
NotificationCorrespondenceRecipientsReply	0	1	9	-1	Table
ObjectTaskActivityAttachments	0	0	4	-1	Table
OnlineImportAttachments	0	0	7	-1	Table
OnlineTemporaryAttachments	0	0	6	-1	Table
PayrollEmployeeDocuments	0	0	4	-1	Table
Photos	0	0	8	-1	Table
pvCommunity	0	0	141	0	View
pvCommunityCorrespondence	0	0	20	0	View
pvDocumentClassificationsUser	0	0	12	0	View
pvDocumentReferences	0	0	6	0	View
pvFileSemesters	0	0	18	0	View
pvFutureStudentNames	0	0	21	0	View
pvluDocumentClassification	0	0	14	0	View
pvNotificationCorrespondence	0	0	7	0	View
pvNotificationCorrespondenceRecipients	0	0	23	0	View
pvObjectTaskActivities	0	0	16	0	View
pvrefCommunityCorrespondenceTypes	0	0	2	0	View
pvStudentContacts	0	0	14	0	View
pvStudentNames	0	0	34	0	View
StudentReportsArchive	2	1	10	-1	Table
StudentReportsArchiveLink	0	1	7	-1	Table
SynDatabaseLocal	0	0	7	-1	Table
SystemEmail	2	0	56	-1	Table
SystemEmailAttachment	0	1	8	-1	Table
SystemEmailRecipient	0	1	7	-1	Table
tDocumentReferences	0	1	7	-1	Table
tDocumentReferencesArchive	0	0	7	-1	Table
tDocuments	3	1	16	-1	Table
tDocumentsArchive	0	0	16	-1	Table
vDocuments	0	0	25	0	View
vDocumentsWithoutDocumentField	0	0	25	0	View
vLoginName	0	0	5	0	View
vStudentReportsArchiveLatest	0	0	18	0	View
wkCommunityCorrespondenceAttachments	0	0	5	-1	Table
wkCommunityCorrespondenceSentDBMail	0	0	7	-1	Table