MiniProject

Tables (6)

Members2 (books)

  • Key (idx) — default user_seq.nextval — Primary key — NOT NULL
  • Field (userid) — unique
  • Field (userpw) — not null
  • Field (useremail) — not null
  • Field (username) — not null
  • Field2 (grade) — default 'user'

Untitled (review, rent)

  • Key (idx) — default book_seq.nextval — Primary key — NOT NULL
  • Key (useridx) — Foreign key → Members2.Key — NOT NULL
  • Field (bookname) — not null
  • Field (writer) — not null
  • Field (bookphoto)
  • Field (plot) — not null
  • Field (status) — default 1
  • Field (content) — not null

Untitled (review)

  • Key (idx) — default review_seq.nextval — Primary key — NOT NULL
  • Key (bookidx) — Foreign key → Untitled.Key — NOT NULL
  • Key (useridx) — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — not null
  • Field (content) — not null
  • Field (fileName)
  • Field (writeDate) — default sysdate
  • Field (ipaddr) — not null
  • Field (userAgent) — not null

Untitled (Rent)

  • Key (idx) — default rent_seq.nextval — Primary key — NOT NULL
  • Key (bookidx) — Foreign key → Untitled.Key — NOT NULL
  • Key (useridx) — Foreign key → Untitled.Key — NOT NULL
  • Field

board (Untitled)

    review (Untitled2)