pj

Tables (12)

books

  • bnum (pk) — varchar15 — Primary key — NOT NULL
  • bname (Field) — varchar30
  • bpublisher (Field2) — varchar30
  • bqnt (Field3) — int
  • bincomedate (Field4) — int
  • bprice (Field5) — int
  • brentcycle (Field6) — int
  • genre (Field7) — varchar20

comment (Untitled2)

  • nickname (pk) — varchar20 — Foreign key → user.id — NOT NULL
  • bname (pk2) — varchar15 — Foreign key → books.bnum — NOT NULL
  • ccontent (Field2) — varchar50

community (Untitled3)

  • num (Key) — Primary key — NOT NULL
  • nickname (pk) — varchar20 — Foreign key → user.id — NOT NULL
  • subject (Field) — text
  • date (Field2) — int
  • content (Field3) — text
  • views (Field4) — int

favoritebook (Untitled5)

  • nickname (pk) — varchar20 — Foreign key → user.id — NOT NULL
  • bname (pk2) — varchar15 — Foreign key → books.bnum — NOT NULL
  • enddate (pk3) — int — Foreign key → rental.bnum — NOT NULL

jail (Untitled4)

  • id (pk) — varchar20 — Foreign key → user.id — NOT NULL
  • from (Field) — int
  • end (Field2) — int
  • reason (Field3) — varchar20

new books (CopyOfCopyOfbooks)

  • bnum (pk2) — varchar15 — Foreign key → books.bnum — NOT NULL
  • bname (Field) — varchar30
  • bpublisher (Field2) — varchar30
  • bincomedate (Field4) — int

notice (CopyOfUntitled3)

  • num (Key) — Primary key — NOT NULL
  • id (pk) — varchar20 — Foreign key → user.id — NOT NULL
  • subject (Field) — text
  • date (Field2) — int
  • content (Field3) — text

qna (CopyOfCopyOfUntitled3)

  • num (Key) — Primary key — NOT NULL
  • id (pk) — varchar20 — Foreign key → user.id — NOT NULL
  • subject (Field) — text
  • date (Field2) — int
  • content (Field3) — text

rank of books (CopyOfbooks)

  • bnum (pk2) — varchar15 — Foreign key → books.bnum — NOT NULL
  • bname (Field) — varchar30
  • bpublisher (Field2) — varchar30
  • bincomedate (Field4) — int
  • brentcycle (Field6) — int

rank of community (CopyOfUntitled32)

  • num (Key) — int — Primary key — NOT NULL
  • nickname (pk2) — varchar20 — Foreign key → community.nickname — NOT NULL
  • subject (Field) — text
  • date (Field2) — int
  • content (Field3) — text
  • views (Field4) — int

rental (Untitled)

  • id (pk2) — varchar20 — Foreign key → user.id — NOT NULL
  • bnum (pk) — varchar15 — Foreign key → books.bnum — NOT NULL
  • startdate (Field) — int
  • enddate (Field2) — int
  • qnt (Field3) — int

user

  • id (pk) — varchar20 — Primary key — NOT NULL
  • pw (Field) — int
  • name (Field2) — varchar10
  • nickname (Field3) — varchar20
  • birth (Field4) — int
  • phone (Field5) — varchar20
  • address (Field6) — varchar50
  • joindate (Field7) — int
  • interest (Field8) — varchar30
  • email (Field9) — varchar50