SchemaCrawler Output

Lints

Database [database]

		[lint, medium]
	column with same name but different data types	FIRSTNAME [VARCHAR, PUBLIC.BOOKS.NAME_TYPE]
	column with same name but different data types	LASTNAME [VARCHAR, PUBLIC.BOOKS.NAME_TYPE]
	column with same name but different data types	ID [BIGINT, INTEGER]
	column with same name but different data types	DATA [CLOB, PUBLIC.BOOKS.VALID_STRING]
	column with same name but different data types	STATE [CHARACTER, VARCHAR]
	column with same name but different data types	UPDATE [CLOB, VARCHAR]
	cycles in table relationships	PUBLIC.FOR_LINT.PUBLICATIONS, PUBLIC.FOR_LINT.WRITERS

PUBLIC.BOOKS.AUTHORS [table]

		[lint, medium]
	incrementing columns	PUBLIC.BOOKS.AUTHORS.ADDRESS1, PUBLIC.BOOKS.AUTHORS.ADDRESS2
		[lint, low]
	should have remarks	ID, FIRSTNAME, LASTNAME, ADDRESS1, ADDRESS2, CITY, STATE, POSTALCODE, COUNTRY

PUBLIC.BOOKS.BOOKAUTHORS [table]

		[lint, high]
	redundant index	PUBLIC.BOOKS.BOOKAUTHORS.SYS_FK_10120
	no primary key
	primary key may not be a surrogate
		[lint, low]
	should have remarks	BOOKID, AUTHORID, SOMEDATA

PUBLIC.BOOKS.BOOKS [table]

		[lint, high]
	redundant index	PUBLIC.BOOKS.BOOKS.FK_PREVIOUSEDITION
	redundant index	PUBLIC.BOOKS.BOOKS.U_PREVIOUSEDITION
		[lint, medium]
	unique index with nullable columns	PUBLIC.BOOKS.BOOKS.U_PREVIOUSEDITION
		[lint, low]
	should have remarks	PREVIOUSEDITIONID

PUBLIC.BOOKS."Celebrities" [table]

		[lint, medium]
	no non-nullable data columns
	spaces in name, or reserved word
	spaces in name, or reserved word	Id
		[lint, low]
	should have remarks
	should have remarks	Id, NAME

PUBLIC.BOOKS."Celebrity Updates" [table]

		[lint, high]
	redundant index	PUBLIC.BOOKS."Celebrity Updates".SYS_FK_10130
	redundant index	PUBLIC.BOOKS."Celebrity Updates"."PK Celebrity Updates"
		[lint, medium]
	no non-nullable data columns
	spaces in name, or reserved word
	spaces in name, or reserved word	Celebrity Id
	spaces in name, or reserved word	UPDATE
		[lint, low]
	should have remarks
	should have remarks	Celebrity Id, UPDATE

PUBLIC.BOOKS.ΒΙΒΛΊΑ [table]

		[lint, high]
	foreign key data type different from primary key	PUBLIC.BOOKS.ΒΙΒΛΊΑ.FK_ΒΙΒΛΊΑ_PUBLISHERS
		[lint, low]
	empty table
	should have remarks
	should have remarks	ΜΟΝΑΔΙΚΌΣ, ΤΊΤΛΟΣ, ΠΕΡΙΓΡΑΦΉ, ΕΚΔΌΤΗΣ

PUBLIC.FOR_LINT."Global Counts" [table]

		[lint, high]
	no primary key
	primary key may not be a surrogate
		[lint, medium]
	no non-nullable data columns
	no indexes
	spaces in name, or reserved word
	spaces in name, or reserved word	Global Count
	single column
		[lint, low]
	empty table
	should have remarks
	should have remarks	Global Count

PUBLIC.FOR_LINT.PUBLICATIONS [table]

		[lint, medium]
	spaces in name, or reserved word	UPDATE
		[lint, low]
	empty table
	should have remarks
	should have remarks	ID, DESCRIPTION, WRITERID, PUBLICATIONDATE, PRICE, UPDATE, PRESS_RELEASE
	too many binary objects	PUBLIC.FOR_LINT.PUBLICATIONS."UPDATE", PUBLIC.FOR_LINT.PUBLICATIONS.PRESS_RELEASE

PUBLIC.FOR_LINT.PUBLICATIONWRITERS [table]

		[lint, high]
	primary key may not be a surrogate
		[lint, low]
	empty table
	should have remarks
	should have remarks	PUBLICATIONID, WRITERID

PUBLIC.FOR_LINT.SELFREFERENCE [table]

		[lint, critical]
	foreign key self-references primary key	PUBLIC.FOR_LINT.SELFREFERENCE.FK_SELFREFERENCE
		[lint, high]
	redundant index	PUBLIC.FOR_LINT.SELFREFERENCE.FK_SELFREFERENCE
	redundant index	PUBLIC.FOR_LINT.SELFREFERENCE.PK_SELFREFERENCE
		[lint, low]
	empty table
	should have remarks
	should have remarks	ID, TITLE

PUBLIC.FOR_LINT.WRITERS [table]

		[lint, high]
	foreign key data type different from primary key	PUBLIC.FOR_LINT.WRITERS.FK_WRITERS_PUBLICATION
	redundant index	PUBLIC.FOR_LINT.WRITERS.IDX_A1_WRITERS
		[lint, medium]
	unique index with nullable columns	PUBLIC.FOR_LINT.WRITERS.IDX_U_WRITERS
	column where NULL may be intended	PUBLIC.FOR_LINT.WRITERS.ADDRESS2
	column where NULL may be intended	PUBLIC.FOR_LINT.WRITERS.COUNTRY
	incrementing columns	PUBLIC.FOR_LINT.WRITERS.ADDRESS1, PUBLIC.FOR_LINT.WRITERS.ADDRESS2
	incrementing columns	PUBLIC.FOR_LINT.WRITERS.PHONE1, PUBLIC.FOR_LINT.WRITERS.PHONE2
	incrementing columns	PUBLIC.FOR_LINT.WRITERS.FAX, PUBLIC.FOR_LINT.WRITERS.FAX3
	incrementing columns	PUBLIC.FOR_LINT.WRITERS.EMAIL1, PUBLIC.FOR_LINT.WRITERS.EMAIL2
	incrementing columns	PUBLIC.FOR_LINT.WRITERS.HOMEEMAIL11, PUBLIC.FOR_LINT.WRITERS.HOMEEMAIL12
	incrementing columns are not consecutive	PUBLIC.FOR_LINT.WRITERS.FAX, PUBLIC.FOR_LINT.WRITERS.FAX3
	incrementing columns don't have the same data-type	PUBLIC.FOR_LINT.WRITERS.PHONE1, PUBLIC.FOR_LINT.WRITERS.PHONE2
	incrementing columns don't have the same data-type	PUBLIC.FOR_LINT.WRITERS.FAX, PUBLIC.FOR_LINT.WRITERS.FAX3
	incrementing columns don't have the same data-type	PUBLIC.FOR_LINT.WRITERS.EMAIL1, PUBLIC.FOR_LINT.WRITERS.EMAIL2
		[lint, low]
	empty table
	should have remarks
	should have remarks	ID, FIRSTNAME, LASTNAME, ADDRESS1, ADDRESS2, CITY, STATE, POSTALCODE, COUNTRY, PHONE1, PHONE2, EMAIL1, EMAIL2, FAX, FAX3, HOMEEMAIL11, HOMEEMAIL12, PUBLICATION_ID

PUBLIC."PUBLISHER SALES".REGIONS [table]

		[lint, high]
	primary key may not be a surrogate
		[lint, low]
	should have remarks
	should have remarks	CITY, STATE, POSTALCODE, COUNTRY
	primary key not first

PUBLIC."PUBLISHER SALES".SALES [table]

		[lint, high]
	no primary key
	primary key may not be a surrogate
		[lint, low]
	should have remarks
	should have remarks	POSTALCODE, COUNTRY, BOOKID, COUPON_ID, PERIODENDDATE, TOTALAMOUNT, SALESDATAID

PUBLIC."PUBLISHER SALES".SALESDATA [table]

		[lint, high]
	no primary key
	primary key may not be a surrogate
		[lint, medium]
	unique index with nullable columns	PUBLIC."PUBLISHER SALES".SALESDATA.UQ_CUSTOMERS
	no non-nullable data columns
		[lint, low]
	empty table
	should have remarks
	should have remarks	SALESDATAID, YEARLYAMOUNT