Database Structure

Basic concepts

• Tables for user registration/logging - prefix usr
• Tables for draft records not fully committed - prefix draft
• Tables for audit/ history - prefix sys
• Tables for storing referential information - prefix ref
• Table for storing committed records prefix rec