Home >
database > Online and complicated relations of database design
Online and complicated relations of database design
There is A demand, that is, A variety of categories of membership, to develop A use rules, there are three kinds of rules, A kind of from the date of rules, such as from April 7 to April 30, cannot use, one A week rules, such as cannot be used on Sunday on Saturday, and there's A time rules, from 9 a.m. to 12 points cannot be used, for example, all three of these rules can and and or relationship, such as class A card, he on April 7th to April 30 Saturday 9 PM cannot use, also can be in the April 7 to April 30 either Saturday or 9-12 PM in the day can't use, that is to say, three rules. A, B, C, you can A& & B& & C, can also be A | B | | | C, can also be A& & (B | | C), and so on and so on, the rules how to design the database table and relationship with the membership card, thank you