나를만든책장관리시스템/DBSchema

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

---

나를만든책장관리시스템