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