I am working on the database that will have 5+ tables.
These tables will be accessed for data entry, data modification, data searching and so on. Also these tables will be accessed by more than one users at a time.
The data is of very cruical nature.
I am wondering that what table type I shall be using for my database. I am using PHPMyAdmin. I have these choices:
HEAP (which is not for such database)
Thanks in advance
The second thing that bugs me is that: Is it possible if two users are entering/modifying data at the same time in the same table, they can mess up with the data? I am using SESSIONS that consists of username, IP and time in millisecond.