| id | int(11) |
|
|
|
| book_title | varchar(100) |
|
|
|
| book_no | varchar(50) |
|
|
|
| isbn_no | varchar(100) |
|
|
|
| subject | varchar(100) |
|
|
|
| rack_no | varchar(100) |
|
|
|
| publish | varchar(100) |
|
|
|
| author | varchar(100) |
|
|
|
| qty | int(11) |
|
|
|
| perunitcost | float(10,2) |
|
|
|
| postdate | date |
|
|
|
| description | text |
|
|
|
| available | varchar(10) |
|
|
yes
|
| is_active | varchar(255) |
|
|
no
|
| created_at | timestamp |
|
|
current_timestamp()
|
| updated_at | date |
|
|
|
