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