No older revisions available
No older revisions available
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 |
----
나를만든책장관리시스템
