U E D R , A S I H C RSS

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

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

----
나를만든책장관리시스템
Valid XHTML 1.0! Valid CSS! powered by MoniWiki
last modified 2021-02-07 05:28:52
Processing time 0.0190 sec