books
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| book_id (Primary) | int(11) | No | ||||
| title | varchar(1000) | No | ||||
| author | varchar(1000) | No | ||||
| publisher | varchar(1000) | No | ||||
| category_id | int(5) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | book_id | 10 | A | No |
book_categories
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(5) | No | ||||
| category | varchar(255) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 5 | A | No |
book_issue_log
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(16) | No | ||||
| book_id | int(11) | No | ||||
| student_id | int(11) | No | ||||
| issued_at | date | No | ||||
| return_time | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 10 | A | No |
student_details
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| reg_number | int(11) | No | ||||
| name | varchar(50) | No | ||||
| program | varchar(50) | No | ||||
| dob | date | No | ||||
| category | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 10 | A | No |