图书管理数据库表结构及表中数据

图书管理数据库1.简书目表（Jsm）表结构字段名类型长度是否为主键是否允许为空默认值中文含义JsmIDvarchar11YesNOTNULL简书目标识ISBNvarchar13NOTNULLISBN号BookNamevarchar32NULL图书名Authorvarchar16NULL无作者CopyintNOTNULL副本数PricemoneyNULL0价格Publishervarchar64NULL无出版社表中数据2.总书目表（Zsm）表结构3.读者表（Dz）表结构字段名字段类型长度是否为主键是否允许为空默认值中文含义DzIDintYesNOTNULL读者编号DzNameVarchar16NOTNULL读者姓名SexBitNULL0读者性别BirthdayDatetimeNOTNULL出生日期DeptIDintNOTNULL部门标识TypeIDintNOTNULL类型编号SFZVarchar16NULL身份证Addressvarchar32NULL联系地址4.读者类型表（DZType）5.部门表（Department）6.借书证表（JSZ）表中数据JszIDDzIDBzDataJszStateS00010112002-09-010S00010332002-09-010S00010442002-09-010S00020152002-09-010S00020372002-09-011S00030182002-09-010S00030292002-09-010S000401102002-09-010T000101111990-09-010T000102121990-09-010T000201131980-09-011T000302151990-09-0107.流通表（LT）8.超期表（CQ）