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