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 UPDATE [CLOB, VARCHAR]
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]
cycles in table relationships PUBLICATIONS, WRITERS

 

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

 

PUBLIC.BOOKS.AUTHORSLIST [view]
[lint, low]
should have remarks
should have remarks ID, FIRSTNAME, LASTNAME

 

PUBLIC.BOOKS.BOOKAUTHORS [table]
[lint, high]
redundant index SYS_IDX_SYS_FK_10128_10132
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 SYS_IDX_FK_PREVIOUSEDITION_10123
redundant index SYS_IDX_U_PREVIOUSEDITION_10125
[lint, medium]
unique index with nullable columns SYS_IDX_U_PREVIOUSEDITION_10125
[lint, low]
should have remarks PREVIOUSEDITIONID

 

PUBLIC.BOOKS.COUPONS [table]
[lint, medium]
no non-nullable data columns
[lint, low]
should have remarks
should have remarks ID, DATA, COUPONS, BOOKS

 

PUBLIC.BOOKS.CUSTOMERDATA [table]
[lint, medium]
no non-nullable data columns
[lint, low]
empty table
should have remarks
should have remarks ID, DATA

 

PUBLIC.BOOKS.CUSTOMERS [table]
[lint, low]
empty table
should have remarks
should have remarks ID, FIRSTNAME, LASTNAME, AGE

 

PUBLIC.BOOKS."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
spaces in name, or reserved word UPDATE
[lint, low]
should have remarks
should have remarks Global Count, UPDATE

 

PUBLIC.BOOKS.PUBLISHERS [table]
[lint, medium]
no non-nullable data columns

 

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

 

PUBLIC.FOR_LINT.EXTRA_PK [table]
[lint, low]
empty table
should have remarks WRITERID, PUBLICATIONID, ID
primary key not first

 

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 UPDATE, 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 FK_SELFREFERENCE
[lint, high]
redundant index SYS_IDX_FK_SELFREFERENCE_10211
redundant index SYS_IDX_PK_SELFREFERENCE_10208
[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 FK_WRITERS_PUBLICATION
redundant index IDX_A1_WRITERS
[lint, medium]
unique index with nullable columns IDX_U_WRITERS
column where NULL may be intended ADDRESS2
column where NULL may be intended COUNTRY
incrementing columns ADDRESS1, ADDRESS2
incrementing columns PHONE1, PHONE2
incrementing columns FAX, FAX3
incrementing columns EMAIL1, EMAIL2
incrementing columns HOMEEMAIL11, HOMEEMAIL12
incrementing columns are not consecutive FAX, FAX3
incrementing columns don't have the same data-type PHONE1, PHONE2
incrementing columns don't have the same data-type FAX, FAX3
incrementing columns don't have the same data-type EMAIL1, 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, 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 SYS_IDX_UQ_CUSTOMERS_10234
no non-nullable data columns
[lint, low]
empty table
should have remarks
should have remarks SALESDATAID, YEARLYAMOUNT