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