bankbook
Tables (7)
Board
- Key (id) — INT(11) — Primary key — NOT NULL
- Field (title) — VARCHAR(20)
- Field (body) — VARCHAR(1000)
- Field (date) — VARCHAR(20)
- Key (id2(writer)) — INT(11) — Foreign key → User.Key — NOT NULL
BookList
- Key (id) — INT(11) — Primary key — NOT NULL
- Field (title) — VARCHAR(20)
- Field (author) — VARCHAR(20)
- Field (cheonggu) — VARCHAR(20)
- Field (publisher) — VARCHAR(20)
Comment
- Key (id) — INT(11) — Primary key — NOT NULL
- Field (body) — VARCHAR(200)
- Field (date) — VARCHAR(20)
- Field (Board) — VARCHAR(20)
- Key (id2(writer)) — INT(11) — Foreign key → User.Key — NOT NULL
Community_by_book
- Key (id) — INT(11) — Primary key — NOT NULL
- Field (title) — VARCHAR(20)
- Field (body) — VARCHAR(20)
- Field (period) — VARCHAR(20)
- Field (status) — VARCHAR(20)
- Key (id2(leader)) — INT(11) — Foreign key → User.Key — NOT NULL
- Key (id3(book_name)) — INT(11) — Foreign key → BookList.Key — NOT NULL
- Key (id4) — INT(11) — Foreign key → User.Key — NOT NULL
Community_by_list (Untitled)
- Key (id) — INT(11) — Primary key — NOT NULL
- Field (title) — VARCHAR(20)
- Field (body) — VARCHAR(20)
- Field (period) — VARCHAR(20)
- Field (status) — VARCHAR(20)
- Key (id2(leader)) — INT(11) — Foreign key → User.Key — NOT NULL
- Key (id3(participant)) — INT(11) — Foreign key → User.Key — NOT NULL
User
- Key (id) — INT(11) — Primary key — NOT NULL
- Field (user_id) — VARCHAR(20)
- Field (password) — CHAR(20)
- Field (name) — VARCHAR(30)
- Field (gender) — VARCHAR(10)
- Field (age) — INT(3)
- Field (region) — VARCHAR(20)
- Field (email) — VARCHAR(30)
- Field (Custom_Book) — VARCHAR(20)
User_booklist
- Key (id) — INT(11) — Primary key — NOT NULL
- Field (title) — VARCHAR(20)
- Field (body) — VARCHAR(20)
- Field (star) — INT(1)
- Key (id2(user)) — INT(11) — Foreign key → User.Key — NOT NULL
- Key (id3(bookname)) — INT(11) — Foreign key → BookList.Key — NOT NULL