######################################################################################################################################
#                                                       DBPTK - Validation Report                                                    #
######################################################################################################################################
DBPTK Version: DBPTK Developer (version 2.11.0)
SIARD Version: 2.1
The specification to the SIARD can be found at: https://dilcis.eu/content-types/siard
Additional checks specification can be found at: https://github.com/keeps/db-preservation-toolkit/wiki/Validation
Date: 2024-05-24T22:11:10.151+02:00
SIARD file: C:\Users\Burns\dbptk\testdb.siard


4.1 - Construction of the SIARD archive file
	G_4.1-1: [OK]
	G_4.1-2: [OK]
	G_4.1-3: [OK]
	G_4.1-4: [OK]
	G_4.1-5: [OK]
Construction of the SIARD archive file [PASSED]

4.2 - Structure of the SIARD archive file
	P_4.2-1: [OK]
	P_4.2-2: [OK]
	P_4.2-3: [OK]
	P_4.2-4: [OK]
	P_4.2-5: [OK]
	P_4.2-6: [OK]
Structure of the SIARD archive file [PASSED]

4.3 - Correspondence between metadata and table data
	P_4.3-1: [OK]
	P_4.3-2: [OK]
	P_4.3-3: [OK]
	P_4.3-4: [SKIPPED] - No distinct type found
	P_4.3-5: [SKIPPED] - No Array type found
	P_4.3-6: [SKIPPED] - No UDT type found
	P_4.3-7: [OK]
	P_4.3-8: [OK]
	P_4.3-9: [OK]
	P_4.3-10: [OK]
	A_P_4.3-10: [OK]
Correspondence between metadata and table data [PASSED]

5.0 - Requirements for metadata
	M_5.0-1: [OK]
Requirements for metadata [PASSED]

5.1 - Database level metadata
	M_5.1-1-1: [OK]
	A_M_5.1-1-1: [OK]
	M_5.1-1-2: [OK]
	A_M_5.1-1-3: [OK]
	A_M_5.1-1-4: [OK]
	A_M_5.1-1-5: [OK]
	M_5.1-1-6: [OK]
	A_M_5.1-1-7: [OK]
	M_5.1-1-10: [OK]
	A_M_5.1-1-10: [OK]
	M_5.1-1-16: [OK]
	M_5.1-1-17: [OK]
Database level metadata [PASSED]

5.2 - Schema level metadata
	M_5.2-1-1: [OK]
	A_M_5.2-1-1: [OK]
	M_5.2-1-2: [OK]
	A_M_5.2-1-2: [OK]
	A_M_5.2-1-4: [WARNING] - The description element does not exist - metadata.xml schema:dbo
	A_M_5.2-1-4: [WARNING] - The description element does not exist - metadata.xml schema:other
	A_M_5.2-1-4: [OK]
Schema level metadata [PASSED]

5.3 - Type level metadata
	M_5.3-1: [SKIPPED] - Database has no types
Type level metadata [PASSED]

5.4 - Attribute level metadata
	M_5.4-1: [SKIPPED] - Database has no attributes
Attribute level metadata [PASSED]

5.5 - Table level metadata
	M_5.5-1-1: [OK]
	A_M_5.5-1-1: [OK]
	M_5.5-1-2: [OK]
	A_M_5.5-1-3: [WARNING] - The description element does not exist - metadata.xml schema:dbo/table:testtable
	A_M_5.5-1-3: [WARNING] - The description element does not exist - metadata.xml schema:other/table:testtable
	A_M_5.5-1-3: [OK]
	M_5.5-1-4: [OK]
	M_5.5-1-10: [OK]
Table level metadata [PASSED]

5.6 - Column level metadata
	M_5.6-1-1: [OK]
	A_M_5.6-1-2: [OK]
	M_5.6-1-3: [OK]
	[NOTICE] - Different data types used [int]- 
	A_M_5.6-1-12: [WARNING] - The description element does not exist - metadata.xml schema:dbo/table:testtable/column:id
	A_M_5.6-1-12: [WARNING] - The description element does not exist - metadata.xml schema:other/table:testtable/column:otherid
	A_M_5.6-1-12: [OK]
Column level metadata [PASSED]

5.7 - Field level metadata
	M_5.7-1: [SKIPPED] - Database has no fields
Field level metadata [PASSED]

5.8 - Primary Key level metadata
	M_5.8-1-1: [OK]
	A_M_5.8-1-1: [OK]
	A_M_5.8-1-2: [ERROR] : Primary key column reference id not found on dbo.testtable
	M_5.8-1-2: [OK]
	A_M_5.8-1-3: [WARNING] - The description element does not exist - metadata.xml schema:dbo/table:testtable/candidateKey:PK__testtabl__3213E83FF6EFCAD0
	A_M_5.8-1-3: [WARNING] - The description element does not exist - metadata.xml schema:other/table:testtable/candidateKey:PK__testtabl__2C5AA82BDB945886
	A_M_5.8-1-3: [OK]
Primary Key level metadata [FAILED]

5.9 - Foreign Key level metadata
	M_5.9-1: [SKIPPED] - Database has no foreign keys
Foreign Key level metadata [PASSED]

5.10 - Reference level metadata
	5.10: [SKIPPED] - Database has no foreign keys and references
Reference level metadata [PASSED]

5.11 - Candidate Key level metadata
	M_5.11-1-1: [OK]
	A_M_5.11-1-1: [OK]
	A_M_5.11-1-2: [ERROR] : Candidate key column reference id not found on dbo.testtable
	M_5.11-1-2: [OK]
	A_M_5.11-1-3: [WARNING] - The description element does not exist - metadata.xml schema:dbo/table:testtable/candidateKey:PK__testtabl__3213E83FF6EFCAD0
	A_M_5.11-1-3: [WARNING] - The description element does not exist - metadata.xml schema:other/table:testtable/candidateKey:PK__testtabl__2C5AA82BDB945886
	A_M_5.11-1-3: [OK]
Candidate Key level metadata [FAILED]

5.12 - Check constraint level metadata
	M_5.12-1: [SKIPPED] - Database has no check constraint
Check constraint level metadata [PASSED]

5.13 - Trigger level metadata
	M_5.13-1: [SKIPPED] - Database has no triggers
Trigger level metadata [PASSED]

5.14 - View level metadata
	M_5.14-1: [SKIPPED] - Database has no view
View level metadata [PASSED]

5.15 - Routine level metadata
	M_5.15-1: [SKIPPED] - Database has no routine
Routine level metadata [PASSED]

5.16 - Parameter level metadata
	M_5.16-1: [SKIPPED] - Database has no parameters
Parameter level metadata [PASSED]

5.17 - User level metadata
	M_5.17-1-1: [OK]
	A_M_5.17-1-1: [OK]
	A_M_5.17-1-2: [OK]
User level metadata [PASSED]

5.18 - Role level metadata
	M_5.18-1-1: [OK]
	A_M_5.18-1-1: [OK]
	M_5.18-1-2: [OK]
	A_M_5.18-1-2: [OK]
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:db_accessadmin
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:db_backupoperator
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:db_datareader
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:db_datawriter
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:db_ddladmin
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:db_denydatareader
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:db_denydatawriter
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:db_owner
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:db_securityadmin
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:dbo
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:guest
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:INFORMATION_SCHEMA
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:public
	A_M_5.18-1-3: [WARNING] - The description element does not exist - metadata.xml role:sys
	A_M_5.18-1-3: [OK]
Role level metadata [PASSED]

5.19 - Privilege level metadata
	M_5.19-1-1: [OK]
	A_M_5.19-1-1: [OK]
	A_M_5.19-1-2: [OK]
	M_5.19-1-3: [OK]
	A_M_5.19-1-3: [OK]
	M_5.19-1-4: [OK]
	A_M_5.19-1-4: [OK]
	A_M_5.19-1-5: [OK]
	A_M_5.19-1-6: [WARNING] - The description element does not exist - metadata.xml privilege:DELETE
	A_M_5.19-1-6: [WARNING] - The description element does not exist - metadata.xml privilege:INSERT
	A_M_5.19-1-6: [WARNING] - The description element does not exist - metadata.xml privilege:REFERENCES
	A_M_5.19-1-6: [WARNING] - The description element does not exist - metadata.xml privilege:SELECT
	A_M_5.19-1-6: [WARNING] - The description element does not exist - metadata.xml privilege:UPDATE
	A_M_5.19-1-6: [WARNING] - The description element does not exist - metadata.xml privilege:DELETE
	A_M_5.19-1-6: [WARNING] - The description element does not exist - metadata.xml privilege:INSERT
	A_M_5.19-1-6: [WARNING] - The description element does not exist - metadata.xml privilege:REFERENCES
	A_M_5.19-1-6: [WARNING] - The description element does not exist - metadata.xml privilege:SELECT
	A_M_5.19-1-6: [WARNING] - The description element does not exist - metadata.xml privilege:UPDATE
	A_M_5.19-1-6: [OK]
Privilege level metadata [PASSED]

	T_6.0-2: [OK]
T_6.0 - Requirements for table data
	T_6.0-1: [OK]
	A_T_6.0-1-1: [OK]
	A_T_6.0-1-2: [OK]
Requirements for table data [PASSED]

T_6.1 - Table schema definition
	T_6.1-1: [OK]
	T_6.1-2: [OK]
	T_6.1-3: [OK]
	T_6.1-4: [OK]
Table schema definition [PASSED]

T_6.3 - Date and timestamp data cells
	T_6.3-1: [OK]
Date and timestamp data cells [PASSED]

T_6.4 - Table data
	T_6.4-1: [OK]
	T_6.4-2: [OK]
	T_6.4-4: [SKIPPED] - Optional
	T_6.4-5: [OK]
Table data [PASSED]