Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
book_id | int(11) | Yes | NULL | |||
name | varchar(100) | Yes | NULL | |||
author_name | varchar(10) | Yes | NULL | |||
publisher_name | varchar(100) | Yes | NULL | |||
version | varchar(10) | Yes | NULL | |||
no_of_copies | int(11) | Yes | NULL |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
id | int(11) | Yes | NULL | |||
name | varchar(100) | Yes | NULL | |||
reg_no | varchar(10) | Yes | NULL | |||
mobile | char(10) | Yes | NULL |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
varchar(36) | Yes | NULL | ||||
COL 2 | varchar(10) | Yes | NULL | |||
name | varchar(70) | Yes | NULL | |||
COL 4 | varchar(10) | Yes | NULL | |||
date | varchar(34) | Yes | NULL |
Column | Type | Null | Default | Links to | Comments | MIME |
---|---|---|---|---|---|---|
id | int(11) | Yes | NULL | |||
book_id | int(11) | Yes | NULL | |||
student_id | int(11) | Yes | NULL | |||
issued_date | date | Yes | NULL | |||
return_date | date | Yes | NULL |