Skip to main content

Database Schema

The Database Schema can be described as a set of base tables connected via primary and foreign keys that connect Case data. Each table contains a unique ID column, and a CaseID column that acts as a foreign key with the' SF_Cases' table. It is by this structure that data is able to be stored in tables separated by object template, yet still retain Case relative data.

ClosedEXAMPLE: A demo database’s schema of tables, referential constraints, and key column usageFigure 1159: Example Schema