Table Schema ¶
| bm_tblBook | ||
| bID | unsigned int | ID, PK |
| bTitle | varchar(255) | |
| bAuthor | varchar(255) | |
| bPublisher | varchar(255) | |
| bISBN | varchar(255) | |
| bImage | varchar(255) | |
| bm_tblContribution | ||
| cID | unsigned int | ID, PK |
| cContributor | int(11) | FK references bm_tblMember(mID) on delete no action on update cascade |
| cBook | unsigned int | FK references bm_tblBook(bID) on delete no action on update cascade |
| cComment | text | |
| cDate | date | |
| bm_tblRental | ||
| rID | unsigned int | ID, PK |
| rUser | int(11) | FK refereneces bm_tblMember(mID) on delete no action on update cascade |
| rBook | unsigned int | FK refereneces bm_tblBook(bID) on delete no action on update cascade |
| rDelay | tinyint | FK refereneces bm_tblDelay(dID) |
| rApplication | tinyint | FK refereneces bm_tblApplication(aID) |
| bm_tblMember | ||
| mID | int(11) | PK, FK references zb_member_list(member_srl) on delete no action on update cascade |
| mAdmin | tinyint | FK refereneces bm_tblAdmin(adID) |
| bm_tblDelay | ||
| dID | tinyint | PK |
| dName | varchar | not null |
| bm_tblApplication | ||
| aID | tinyint | PK |
| aName | varchar | not null |
| bm_tblAdmin | ||
| adID | tinyint | PK |
| adName | varchar | not null |
나를만든책장관리시스템
