Hello,

in my current project (approx 120 datatables) I use integers,
generated through triggers and generators as primary indizes in every
table. My questions :

1.) Are there any arguments for or against to use one generator for
all tables, or should I use several generators? Or maybe one generator
for every table?

Interbase data definition guide says 2.147.483.647 possible positive
integers values, that should be enough for my amount of data, and
INT64 gives me a number I can not even pronounce...

2.) I have read something about the concept of meaningless primary
indizes, but in master-detail relation of two tables, I use primary
index of master table for defining master-detail relation. Do I break
this concept with this? Do I have to add another data-column to define
master-detail relation?


Any suggestions, or comments on this?

Regards - Ulrich