1.修改book表结构
book(Number,booksortid,title,addressid,reader_number...)
2。建立主键(关键字)
book(Number)
reader(Reaeder_number)
User(Id)
booksort(ID)
address(id)
3.建立关系
在book(Number,booksortid,title,addressid,reader_number...)中
booksortid以booksort(ID)为外键
addressid以address(id)为外键
reader_number以reader(Reaeder_number)为外键
在lent(Number,reader_number)中
Number以book(Number)为外键
reader_number以reader(Reaeder_number)为外键
4。其他规则和索引根据实际设计再做设计
book(Number,booksortid,title,addressid,reader_number...)
2。建立主键(关键字)
book(Number)
reader(Reaeder_number)
User(Id)
booksort(ID)
address(id)
3.建立关系
在book(Number,booksortid,title,addressid,reader_number...)中
booksortid以booksort(ID)为外键
addressid以address(id)为外键
reader_number以reader(Reaeder_number)为外键
在lent(Number,reader_number)中
Number以book(Number)为外键
reader_number以reader(Reaeder_number)为外键
4。其他规则和索引根据实际设计再做设计
这些都建立在客户需求的基础之上,如果没有具体需求,项目非常容易失败!!
或是[email protected]
QQ:7357976