SchemaSpy Analysis of library - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Mon Aug 16 17:34 MDT 2010 |
| ||||||
|
library contains 36 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default |
---|---|---|---|---|---|---|
address | address1 | varchar | 50 | |||
address | address2 | varchar | 50 | √ | null | |
address | addressId | int | 10 | √ | ||
address | city | varchar | 30 | |||
address | state | char | 2 | |||
address | zip | varchar | 10 | |||
author | authorId | int | 10 | √ | ||
author | firstName | varchar | 32 | |||
author | lastName | varchar | 32 | |||
author | middleName | varchar | 32 | √ | null | |
book | isbn | bigint | 19 | 0 | ||
book | publisherId | int | 10 | √ | ||
book | title | varchar | 128 | |||
book_author | authorId | int | 10 | 0 | ||
book_author | isbn | bigint | 19 | 0 | ||
book_location | branchId | int | 10 | |||
book_location | isbn | bigint | 19 | 0 | ||
book_location | numCopies | int | 10 | |||
borrowed_book | borrowDate | date | 10 | |||
borrowed_book | branchId | int | 10 | |||
borrowed_book | cardNo | int | 10 | |||
borrowed_book | dueDate | date | 10 | |||
borrowed_book | isbn | bigint | 19 | 0 | ||
borrower | address | int | 10 | √ | null | |
borrower | cardNo | int | 10 | √ | ||
borrower | firstName | varchar | 32 | |||
borrower | lastName | varchar | 32 | |||
borrower | middleName | varchar | 32 | √ | null | |
borrower | phone | varchar | 16 | √ | null | |
library_branch | address | int | 10 | |||
library_branch | branchId | int | 10 | √ | ||
library_branch | name | varchar | 64 | |||
publisher | address | int | 10 | √ | null | |
publisher | name | varchar | 64 | |||
publisher | phone | varchar | 16 | √ | null | |
publisher | publisherId | int | 10 | √ |