The problem of query for database table-CodePudding

My design for a database table that

reference

Want to query the situation is: the address of the client will submit a ibeacon table (this value in the table is the only) and individual user id in the table, I will, according to the address first find its ibeacon_id ibeacon, and then according to the ibeacon_id found in ibeacon_in_group table one or several group_id, then according to with group_id marketing information in the table to find the corresponding information, then trouble, because there is a push to find marketing information rules, namely the marketing information should conform to the user's identity, the specific rules are gender, age, social hierarchy and push largest number should be appropriate,
Only 50 points can be given

CodePudding user response:

By the way, the marketing information push and some internal rules
What gender to push information, 0 means anyone, said 1 male, 2 female
People push information in social class, any class, 0 means...

CodePudding user response:

To study the PL/SQL