图书管理系统数据库设计

图书表 book:
bookid int key
userid int fkey
typeid int fkey
pressid int fkey
authorid int fkey
bookname varchar 20
booknum varchar 20

作者表 author:
authorid int key
authorname varchar 20

用户表 tbuser:
userid int key
username varchar 20
password varchar 20
nickname varchar 20

类型表 booktype:
typeid int key
typename varchar 20

出版社表 press:
pressid int key
pressname varchar 40