[Vince]

The primary key mustn't have any meaning. It is merely there to identify the row in the table. In the house structure (probably the enum) you must create a variable that will hold this id. If you want to create a new house you do a normal insert. Then you use cache_insert_id() to assign the newly created id to said variable.