javadatabaseoracle-databasespring-booterd

Difference between ID and TrackNumber in Post System Database

I am working on a Post System Database as a Project.

I encountered an interesting question regarding Package Entity.

Here is the Entity Picture

I would like to ask whether I need to have ID and TrackNumber as separate Unique Identifiers or should I better just leave a TrackNumber and refer to it as a main ID of a Package?

If you would like to ask for any clarifications, please do not hesitate to do so.

Solution

  • You can use as many keys as it needed including TrackNumber. But the primary key is ID of course. It will help you to use the "Package Entity" in relationship with other tables.