图书管理数据库简书目表(Jsm)表结构字段名类型长度是否为主键是否允许为空默认值中文含义JsmIDvarchar11YesNOTNULL简书目标识ISBNvarchar13NOTNULLISBN号BookNamevarchar32NULL图书名Authorvarchar16NULL无作者CopyintNOTNULL副本数PricemoneyNULL0价格Publishervarchar64NULL无出版社表中数据总书目表(Zsm)表结构读者表(Dz)表结构字段名字段类型长度是否为主键是否允许为空默认值中文含义DzIDintYesNOTNULL读者编号DzNameVarchar16NOTNULL读者姓名SexBitNULL0读者性别BirthdayDatetimeNOTNULL出生日期DeptIDintNOTNULL部门标识TypeIDintNOTNULL类型编号SFZVarchar16NULL身份证Addressvarchar32NULL联系地址读者类型表(DZType)部门表(Department)借书证表(JSZ)表中数据JszIDDzIDBzDataJszStateS0001011-09-010S0001033-09-010S0001044-09-010S0002015-09-010S0002037-09-011S0003018-09-010S0003029-09-010S00040110-09-010T000101111990-09-010T000102121990-09-010T000201131980-09-011T000302151990-09-010流通表(LT)超期表(CQ)
图书管理数据库表结构及表中数据 来自淘豆网m.daumloan.com转载请标明出处.
