May 31, 2013 09:12 PM|johnjohn123123|LINK
I have the following tables.
Available_Ip_Address (IP_Address_ID (Primary Key ), description, status ).
Virtual_Machine (VM_ID (Primary Key ), description, IP_Address (foreign key ) )
The scenario is as follow:-
we maintain all the available IP address of a single table.
we maintain the virtual machine info in another table , but specific IP address can be assigned to a single VM at any time.
So is my approach considered a valid design, or i should look for adding a timestamp field on the IP_address field so if the status of the IP address was changed since it was last queried then the record will have new timestamp and a exception will be raised
on the application level.