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.AUTHORSLIST [view] ------------------------------------------------------------------------ [lint, low] should have remarks should have remarks ID, FIRSTNAME, LASTNAME 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.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.PUBLISHERS [table] ------------------------------------------------------------------------ [lint, medium] no non-nullable data columns 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.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 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