Books, 14 (ver3.6.1)
Only Used by Lyman to store book related information.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Author | 3.6.1 | Varchar(60) | Author of the book. Only used in Lyman. |
BarCodeNumber | 3.6.1 | Varchar(20) | School assigned bar code on book. Only used in Lyman. |
CallNumber | 3.6.1 | Varchar(25) | Call number of the book. Only used in Lyman. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ISBN | 3.6.1 | Varchar(40) | The ISBN number for the book. Only used in Lyman. |
Illustrator | 3.6.1 | Varchar(50) | The illustrator of the book. Only used in Lyman. |
Pages | 3.6.1 | Number(10,0) | How many pages the book has. Only used in Lyman. |
Price | 3.6.1 | Float | How much the book cost new. Only used in Lyman. |
Publisher | 3.6.1 | Varchar(60) | The publisher of the book. Only used in Lyman. |
SubjectHeading | 3.6.1 | Varchar(80) | What subject this book addresses. Only used in Lyman. |
Title | 3.6.1 | Varchar(80) | Title of the book. Only used in Lyman. |