Quick question: What exactly is the purpose of the "STATE_NO" column in the TR_STATE table?
Thanks, Tessiturians.
No time for trivia today, unfortunately...
That plus the country is the primary key.
Actually, I believe ID + COUNTRY is the primary key, which makes a column like STATE_NO over on the end there seem rather superfluous.
Me am still curious...
For you interested in the curious, the state_no column is there because tables that are maintained in System Tables must have a numeric key column. And even though this is not the database primary key, it operates as the PK as far as System Tables is concerned.
Ah, thank you both. Now I think I understand.