Database Design: Multiple identifying relationships between two entities -


i have 2 entities user, , message.

to avoid surrogate primary key message should weak entity depending on user, having 2 references of same (primary key) attribute user - email, partial key supposed unix_timestamp.

is fine approach? there other alternative?


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

Kivy: Swiping (Carousel & ScreenManager) -