| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | bigint(20) unsigned | NO | PRI | auto_increment | |
| name | varchar(255) | YES | |||
| publisher | varchar(255) | YES | |||
| author | varchar(255) | YES | |||
| year | year(4) | YES | 2022 | ||
| isbn | bigint(20) | YES | |||
| created_at | timestamp | YES | |||
| updated_at | timestamp | YES | |||
| book_type | enum('Sofware','Science','Business') | YES | |||
| deleted_at | timestamp | YES |
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) unsigned | NO | PRI | auto_increment | |
| product_name | varchar(191) | NO | |||
| description | text | YES | |||
| amount | decimal(8,2) | YES | |||
| category | varchar(191) | YES | |||
| status | varchar(191) | YES | |||
| created_at | timestamp | YES | |||
| updated_at | timestamp | YES | |||
| image | varbinary(150) | YES |
