Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

I have a junction table for locks_keys that has an issue with a long primary key column with keys that can open multiple locks

Topic Labels: Base design
324 0
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a question for a base design to track locks and keys. I have a table for locks, a table for keys and a junction table for locks_keys. In the junction table, the locks column can have many locks that can be opened by a single key. I have a composite primary field concatenated with the lock and key values as the primary key. Issue is that the primary key is really long on some records where 1 key can open 5 locks.
Would creating a surrogate locks_keys_autonumber primary field work in place of using the natural keys?

0 Replies 0