imported>Unknown at 05:28, 7 February 2021

2021-02-07T05:28:52Z

New page

= Table Schema =
{| class="wikitable"
|-
|
|
| '''bm_tblBook'''
|-
| bID
| unsigned int
| ID, PK
|-
| bTitle
| varchar(255)
|-
| bAuthor
| varchar(255)
|-
| bPublisher
| varchar(255)
|-
| bISBN
| varchar(255)
|-
| bImage
| varchar(255)
|}

{| class="wikitable"
|-
|
|
| '''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
|}

{| class="wikitable"
|-
|
|
| '''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)
|}

{| class="wikitable"
|-
|
|
| '''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)
|}

{| class="wikitable"
|-
|
|
| '''bm_tblDelay'''
|-
| dID
| tinyint
| PK
|-
| dName
| varchar
| not null
|}

{| class="wikitable"
|-
|
|
| '''bm_tblApplication'''
|-
| aID
| tinyint
| PK
|-
| aName
| varchar
| not null
|}

{| class="wikitable"
|-
|
|
| '''bm_tblAdmin'''
|-
| adID
| tinyint
| PK
|-
| adName
| varchar
| not null
|}

----
[[나를만든책장관리시스템]]

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

imported>Unknown at 05:28, 7 February 2021