Database > Validator

Validator

Validators

Name	Class
NamePatternPrimaryKeyConstraint	org.dbtoolbox.validator.NamePatternElementMDValidator
NamePatternForeignKeyConstraint	org.dbtoolbox.validator.NamePatternElementMDValidator
NamePatternJoinTable	org.dbtoolbox.validator.NamePatternElementMDValidator
ColumnCountForeignKeyConstraint	org.dbtoolbox.validator.ColumnCountElementMDValidator
PrimaryKeyTable	org.dbtoolbox.validator.PrimaryKeyTableMDValidator
NameLengthTable	org.dbtoolbox.validator.NameLengthElementMDValidator
IndexPrimaryKey	org.dbtoolbox.validator.IndexPrimaryKeyMDValidator
ReferencesPrimaryKeyForeignKey	org.dbtoolbox.validator.ReferencesPrimaryKeyForeignKeyMDValidator
IsolatedTable	org.dbtoolbox.validator.IsolatedTableMDValidator
ForbiddenNameColumn	org.dbtoolbox.validator.ForbiddenNameElementMDValidator

Messages

Type	Name	Validator	Message
Table	CATALOGS	PrimaryKeyTable	Table has no primary key
Table	CATALOGS	IsolatedTable	Table doesn't have any relation with any other table.
Table	COLLATIONS	PrimaryKeyTable	Table has no primary key
Table	COLLATIONS	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	NAME	ForbiddenNameColumn	Name 'NAME' forbidden
Table	COLUMNS	PrimaryKeyTable	Table has no primary key
Table	COLUMNS	IsolatedTable	Table doesn't have any relation with any other table.
Table	COLUMN_PRIVILEGES	PrimaryKeyTable	Table has no primary key
Table	COLUMN_PRIVILEGES	IsolatedTable	Table doesn't have any relation with any other table.
Table	CONSTANTS	PrimaryKeyTable	Table has no primary key
Table	CONSTANTS	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	CONSTRAINTS	PrimaryKeyTable	Table has no primary key
Table	CONSTRAINTS	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	CROSS_REFERENCES	PrimaryKeyTable	Table has no primary key
Table	CROSS_REFERENCES	IsolatedTable	Table doesn't have any relation with any other table.
Table	DOMAINS	PrimaryKeyTable	Table has no primary key
Table	DOMAINS	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	FUNCTION_ALIASES	PrimaryKeyTable	Table has no primary key
Table	FUNCTION_ALIASES	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	FUNCTION_COLUMNS	PrimaryKeyTable	Table has no primary key
Table	FUNCTION_COLUMNS	IsolatedTable	Table doesn't have any relation with any other table.
Table	HELP	PrimaryKeyTable	Table has no primary key
Table	HELP	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	INDEXES	PrimaryKeyTable	Table has no primary key
Table	INDEXES	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	IN_DOUBT	PrimaryKeyTable	Table has no primary key
Table	IN_DOUBT	IsolatedTable	Table doesn't have any relation with any other table.
Table	LOCKS	PrimaryKeyTable	Table has no primary key
Table	LOCKS	IsolatedTable	Table doesn't have any relation with any other table.
Table	RIGHTS	PrimaryKeyTable	Table has no primary key
Table	RIGHTS	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	ROLES	PrimaryKeyTable	Table has no primary key
Table	ROLES	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	NAME	ForbiddenNameColumn	Name 'NAME' forbidden
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	SCHEMATA	PrimaryKeyTable	Table has no primary key
Table	SCHEMATA	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	SEQUENCES	PrimaryKeyTable	Table has no primary key
Table	SEQUENCES	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	SESSIONS	PrimaryKeyTable	Table has no primary key
Table	SESSIONS	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	SESSION_STATE	PrimaryKeyTable	Table has no primary key
Table	SESSION_STATE	IsolatedTable	Table doesn't have any relation with any other table.
Table	SETTINGS	PrimaryKeyTable	Table has no primary key
Table	SETTINGS	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	NAME	ForbiddenNameColumn	Name 'NAME' forbidden
Table	TABLES	PrimaryKeyTable	Table has no primary key
Table	TABLES	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	TABLE_PRIVILEGES	PrimaryKeyTable	Table has no primary key
Table	TABLE_PRIVILEGES	IsolatedTable	Table doesn't have any relation with any other table.
Table	TABLE_TYPES	PrimaryKeyTable	Table has no primary key
Table	TABLE_TYPES	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	TYPE	ForbiddenNameColumn	Name 'TYPE' forbidden
Table	TRIGGERS	PrimaryKeyTable	Table has no primary key
Table	TRIGGERS	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	TYPE_INFO	PrimaryKeyTable	Table has no primary key
Table	TYPE_INFO	IsolatedTable	Table doesn't have any relation with any other table.
Table	USERS	PrimaryKeyTable	Table has no primary key
Table	USERS	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	NAME	ForbiddenNameColumn	Name 'NAME' forbidden
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	VIEWS	PrimaryKeyTable	Table has no primary key
Table	VIEWS	IsolatedTable	Table doesn't have any relation with any other table.
TabularColumn	ID	ForbiddenNameColumn	Name 'ID' forbidden
Table	JOINTABLE	NamePatternJoinTable	Name doesn't match pattern \w+_J
PrimaryKeyConstraint	TABLE5_FK1	NamePatternPrimaryKeyConstraint	Name doesn't match pattern \w+_PK
TabularColumn	NAME	ForbiddenNameColumn	Name 'NAME' forbidden
PrimaryKeyConstraint	JOINTABLE_FK1	NamePatternPrimaryKeyConstraint	Name doesn't match pattern \w+_PK
TabularColumn	NAME	ForbiddenNameColumn	Name 'NAME' forbidden
ForeignKeyConstraint	TABLE2_FK	NamePatternForeignKeyConstraint	Name doesn't match pattern \w+_FK[0-9]
TabularColumn	NAME	ForbiddenNameColumn	Name 'NAME' forbidden
PrimaryKeyConstraint	JOINTABLE_FK2	NamePatternPrimaryKeyConstraint	Name doesn't match pattern \w+_PK
TabularColumn	NAME	ForbiddenNameColumn	Name 'NAME' forbidden
ForeignKeyConstraint	TABLE5_FK1	ColumnCountForeignKeyConstraint	ForeignKeyConstraint expected at most 1 columns, was 2