I thought that operator id was optional in the query interface: I see it is mandatory in the table, but only ConsumerID is listed as mandatory in the schema. If we want it mandatory I suggest we make it mandatory in both.