arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 08:27
- Joined
- May 7, 2009
- Messages
- 19,246
you "document" everything.
by everything is whatever you can cover and record.
prisoners table:
prisoner id (auto)
prisoner name
nationality
gender
date of birth
(other info)
camp table:
camp id (auto)
camp name
location
country
(other info)
transfer table:
prisoner id (long)
camp id (long)
transfer date and time
notes (reasons of transfer, who is making the transfer, etc)
by everything is whatever you can cover and record.
prisoners table:
prisoner id (auto)
prisoner name
nationality
gender
date of birth
(other info)
camp table:
camp id (auto)
camp name
location
country
(other info)
transfer table:
prisoner id (long)
camp id (long)
transfer date and time
notes (reasons of transfer, who is making the transfer, etc)