WIKIBOOKS

Tables (4)

author

  • 논리이름 (물리이름) — 데이터타입
  • author_id — INT
  • author_name — VARCHAR
  • birthday — DATE
  • image — VARCHAR
  • school — VARCHAR
  • start — VARCHAR
  • project — TEXT
  • email — TEXT

books

  • 논리이름 (물리이름) — 데이터타입
  • kind — VARCHAR
  • book_id — INT
  • book_name — VARCHAR
  • publisher — VARCHAR
  • year — VARCHAR
  • summary — VARCHAR
  • picture — VARCHAR
  • author_id — INT

comment

  • 논리이름 (물리이름) — 데이터타입
  • 댓글 번호 (cno) — INT
  • 작품번호 (bno) — INT
  • contents — TEXT
  • writer — VARCHAR
  • 작성날짜 (reg_date) — DATE

user

  • 논리이름 (물리이름) — 데이터타입
  • user_id — VARCHAR
  • user_name — VARCHAR
  • user_pw — VARCHAR
  • email — VARCHAR
  • birth — DATE
  • picture — VARCHAR