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