Database Design | for general reference, in English

Creative Commons Attribution-ShareAlike License

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

All specifications for database designs and user experience (form tree map) are made available
by MegaOrg under the Creative Commons Attribution-ShareAlike License, 2025.

Survloop: Database Design Specs

subscription_changes
(chng_)

User Subscription Changes

Group: Users

Type: Data

8 Fields Total

3 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
subscription_changes Unique ID chng_id Number, Indexed, Primary Key
User ID# chng_user_id Users^(1,1)-(0,N)
Previous Subscription Level chng_lev_from User Subscription Levels^(0,1)-(0,N)
New Subscription Level chng_lev_to User Subscription Levels^(0,1)-(0,N)
Subscription Notes chng_notes
Previous Paid Through Date chng_paid_from
New Paid Through Date chng_paid_to
Previous Subscription Period chng_period_from
New Subscription Period chng_period_to

subscription_pay_redir
(paid_)

User Subscription Paid Redirects

Group: Users

Type: Data

7 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
subscription_pay_redir Unique ID paid_id Number, Indexed, Primary Key
User ID# paid_user_id Users^(0,N)-(0,N)
Subscription Level Slug (redirect parameter) paid_lev_slug
Chargebee Subscription ID (redirect parameter) paid_sub_id
Chargebee Invoice ID (redirect parameter) paid_invoice_id
Chargebee Redirect ID Parameter paid_param_id
Chargebee Payment State (redirect parameter) paid_state
Site Session ID# paid_sess_site_id Site Session^(1,1)-(0,N)

subscription_users
(sub_usr_)

User Subscriptions

Incoming: User Subscriptions^(0,N)-(1,1)

1 Table with Foreign Key

Group: Users

Type: Data

11 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
subscription_users Unique ID sub_usr_id Number, Indexed, Primary Key
User ID# sub_usr_user_id Users^(1,1)-(0,1)
Subscription Level ID# sub_usr_level_id User Subscriptions^(1,1)-(0,N)
Paid Through Date sub_usr_paid_through
Subscription Period 'M' for Monthly, or 'Y' for Yearly Values: M ; Y ( default value: M ) sub_usr_period
Subscribed Since sub_usr_subscribed_since
Overall User Activity Score ( default value: 0 ) sub_usr_activity
Last Login sub_usr_last_login
First Name sub_usr_first_name
Last Name sub_usr_last_name
Company sub_usr_company
Phone Number sub_usr_phone

subscription_payments
(pay_)

User Subscription Payments

Group: Users

Type: Data

6 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
subscription_payments Unique ID pay_id Number, Indexed, Primary Key
User ID# pay_user_id Users^(1,1)-(0,N)
Date of Payment pay_date
Payment Method pay_method
Payment Amount pay_amount
Invoice ID# pay_invoice_id
Payment Notes pay_notes

subscription_levels
(lev_)

User Subscription Levels

Tracks different subscription levels/categories for users.

Incoming: User Subscription Changes^(0,N)-(0,1), User Subscription Changes^(0,N)-(0,1)

2 Tables with Foreign Keys

Group: Users

Type: Data

12 Fields Total

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
subscription_levels Unique ID lev_id Number, Indexed, Primary Key
Subscription Level Name lev_name
Subscription Level Description lev_desc
Monthly User Cost ($) lev_cost_monthly
Yearly User Cost ($) lev_cost_yearly
Active Users Count ( default value: 0 ) lev_cnt_active_users
URL to Checkout with Monthly Subscription lev_url_checkout_monthly
URL to Checkout with Yearly Subscription lev_url_checkout_yearly
Subscription Level Slug lev_slug
Is Active/Public lev_is_active
Icon lev_icon
Color (hex) lev_color
Payment Thank You Message lev_paid_thanks

subscription_stats
(stat_)

User Subscription Stats

Track various metrics related to system subscribers.

Group: Users

Type: Data

8 Fields Total

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
subscription_stats Unique ID stat_id Number, Indexed, Primary Key
Date of Stats Snapshot stat_date
Active Monthly Subscribers stat_active_monthly_cnt
Active Yearly Subscribers stat_active_yearly_cnt
Inactive Monthly Subscribers stat_inactive_monthly_cnt
Inactive Yearly Subscribers stat_inactive_yearly_cnt
Active Monthly Payments stat_active_monthly_pay
Active Yearly Payments stat_active_yearly_pay
Subscription Level Breakdowns JSON data dump stat_level_breakdowns

users
()

Users

This represents the Laravel Users table, but will not actually be implemented by Survloop as part of the database installation.

22 Tables with Foreign Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
Users Unique ID id Number, Indexed, Primary Key
Username name Text
Email Address email Text

users_roles
(role_user_)

User Roles

Each record represents one linkage between a Laravel system User and a User Role as defined by it's unique ID in the Definitions table.

Group: Users

Type: Linking

2 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
users_roles Unique ID role_user_id Number, Indexed, Primary Key
User ID Indicates the unique User ID related to the User being granted permissions in this record. role_user_uid Users^(0,N)-(0,N)
Role ID Indicates the unique Definition ID related to a User Role being granted in this record. role_user_rid

emails
(email_)

Email Templates

Each record represents one Email Template which can be used throughout Survloop.

Incoming: Emailings^(0,N)-(1,1)

1 Table with Foreign Key

Group: Users

Type: Data

7 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
emails Unique ID email_id Number, Indexed, Primary Key
Tree ID Indicates the unique Tree ID related to the home Tree of this Email Template. email_tree Trees^(0,1)-(0,N)
Type Indicates the general type of Email Template being stored here. email_type
Template Name Indicates the name of this Email Template, as it will be referred to internally within the system. email_name
Default Subject Line Indicates the default subject line of emails sent out using this template. email_subject
Default Email Body Indicates the default main content of emails sent out using this template. email_body
Options Indicates any options necessary to accurately define the properties of this Email Template. ( default value: 1 ) email_opts
Total Emails Sent Indicates the total number of individual Emails sent using this Email Template. ( default value: 0 ) email_tot_sent

emailed
(emailed_)

Emailings

Each record represents one individual Email Template Mailing, including a copy of the auto-generated (then optionally customized) body of the sent email.

Group: Users

Type: Data

10 Fields Total

4 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
emailed Unique ID emailed_id Number, Indexed, Primary Key
Tree ID Indicates the unique Tree ID which sent this email. emailed_tree Trees^(0,1)-(0,N)
Core Record ID Indicates the unique Record ID of the core table of the Tree sending this email. emailed_rec_id
Email Template ID Indicates the unique Email Template ID which is being sent. emailed_email_id Email Templates^(1,1)-(0,N)
Recipient Email Address The email address this message is being sent to. emailed_to
Recipient User ID Indicates the unique User ID of the User this email is being sent to. emailed_to_user Users^(0,0)-(0,N)
Sender User ID Indicates the unique User ID of the User initiating this emailing. emailed_from_user Users^(0,1)-(0,N)
Subject Line Indicates the subject line of this specific email, even if it is different than the default, auto-generated version from the Email Template. emailed_subject
Email Body Indicates the body of this specific email, even if it is different than the default, auto-generated version from the Email Template. emailed_body
Options Indicates the options or flags stored with this emailing. ( default value: 1 ) emailed_opts
Attachment emailed_attach

tokens
(tok_)

Tokens

Each record one security token, of various types, which can be sent to a user to confirms some action or grant some access with greater security.

Group: Users

Type: Data

5 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
tokens Unique ID tok_id Number, Indexed, Primary Key
Token Type Indicates which type of Token has been created and stored here. Values: Confirm Email ; Sensitive ; MFA tok_type
User ID Indicates the unique User ID number whose token is logged in this row. tok_user_id Users^(0,1)-(0,N)
Tree ID Indicates the unique Tree ID number to which this token relates. tok_tree_id Trees^(0,1)-(0,N)
Submission Record ID Indicates the unique record ID number of the completed submission to which this Token relates. tok_core_id
Generated Token Indicates the randomly generated string which is stored as a Token for a User's specific interaction with the database. tok_tok_token

contact
(cont_)

Contact Form

Each record represents one complete submission of the default Contact Form.

Group: Users

Type: Data

9 Fields Total

3 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
contact Unique ID cont_id Number, Indexed, Primary Key
Contact Type Indicates which type of contact the site visitor is making with us. cont_type
Flag Indicates the current internal status of this Contact submission, important for organizing contact records which need attention by system administrators. Values: Unread ; Read ; Trash ( default value: Unread ) cont_flag
Email Address Indicates the email address of the site visitor who completed the Contact Form, important for responding to them. cont_email
Message Subject Line Indicates the subject line (or title) of the site visitor's Contact Form submission. This is important for more quickly identifying and classifying the nature of the request. cont_subject
Message Body Indicates the main body of the site visitor's Contact Form submission, providing all the rest of the details of their request. This also includes a dump of any other fields which may have been built into the Contact Form. cont_body
From User ID# cont_from_user_id Users^(0,1)-(0,N)
To User ID# cont_to_user_id Users^(0,1)-(0,N)
Core Table ID# cont_core_tbl Database Tables^(0,1)-(0,N)
Core Record ID# cont_rec_id

databases
(db_)

Databases

Each record represents one Database being designed in Survloop, a collection of Tables, Fields, Definitions, and Business Rules often owned by a User. Information stored here can define core system settings.

Incoming: Database Tables^{(0,N)-(11,11)}, Database Fields^{(0,N)-(11,11)}, Business Rules^{(0,N)-(11,11)}, Definitions^{(0,N)-(11,11)}, Trees^{(0,N)-(11,11)}, Conditions^{(0,N)-(11,11)}, Log Actions^{(0,N)-(11,11)}, Gallery Images^(0,N)-(1,1)

8 Tables with Foreign Keys

Group: Databases

Type: Data

8 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
databases Unique ID db_id Number, Indexed, Primary Key
Database Owner User ID Indicates the unique User ID number belonging to the owner of this Database. db_user Users^(0,11)-(0,N)
Database Prefix Indicates the short abbreviation which is used to start each Table Name within this Database. This is important for successfully creating and accessing all Database Tables. db_prefix
Database Name Indicates the main, casual, name of the Database in English. db_name
Database Description Indicates the short tagline which is used to describe this Database. This is generally related to Search Engine Optimization. db_desc
Database Mission Indicates the desired goals to be accomplished with this Database. This is important for reminding Users why they are using this system. db_mission
Database Options Indicates the multiple of various prime numbers which mark specific qualities of this Database. Notes: %3 Simple Field Specifications ( default value: 1 ) db_opts
Total Tables Indicates the cached total number of Tables which make up this Database. ( default value: 0 ) db_tables
Total Fields Indicates the cached total number of Fields which make up this Database. ( default value: 0 ) db_fields

tables
(tbl_)

Database Tables

Each record represents one Table in the Database, which is a collection of any number of Fields.

Incoming: Database Tables^(0,N)-(0,1), Database Fields^(0,N)-(0,11), Database Fields^(0,N)-(0,11), Trees^(0,N)-(0,11), Conditions^(0,N)-(0,N), Data Linkage Tables^{(0,N)-(11,11)}, Log Actions^{(0,N)-(11,11)}, Contact Form^(0,N)-(0,1)

8 Tables with Foreign Keys

Group: Databases

Type: Data

14 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
tables Unique ID tbl_id Number, Indexed, Primary Key
Table Database ID Indicates the unique Database ID number which this Table belongs to. tbl_database Databases^{(11,11)-(0,N)}
Table Prefix Indicates the short abbreviation which is used to start each Field Name within this Table. This is important for successfully creating and accessing all Table Fields. tbl_abbr
Table Name (in Database) Indicates the shorter Table Name without spaces or special characters which is used to technically identify this Table when accessing its records in the Database. During system use, the Database's Prefix will be added to the start of the Table Name in this record. tbl_name
Table Name (in English) Indicates the main, casual, name of the Database Table in English. tbl_eng
Table Description Indicates the full description of this Database Table. This should generally be a sentence or two describing what information is stored in a Table, why it is important, and perhaps why this information is being organized in the form of this Table. tbl_desc
Table Internal Notes Indicates the any important Notes related to this Database Table. This can be important for providing documentation or other internal comments about how or why this Table was designed in this way. tbl_notes
Table Type Indicates whether this Database Table stores Data, Subset data, data Linkages, or data Validation. This is important for internal organization and documentation of the Database Design. Values: Data ; Subset ; Linking ; Validation ( default value: Data ) tbl_type
Table Group Indicates which Group of Table this record belongs to. This can be important for visually organizing Tables, and works best if Tables in the same Table Group are all adjacent in the Table Order within the Database. tbl_group
Table Sorting Order Indicates the indexed order of this Table, relative to other Tables in the Database. This is only important for presenting the list of Tables to a Database Designer, and additional value can be added by using Table Groups. ( default value: 0 ) tbl_ord
Table Options Indicates the multiple of various prime numbers which mark specific qualities of this Table. Notes: %3 Table Has User-Defined Primary Key ( default value: 1 ) tbl_opts
Extension of Table Indicates whether or not this Database Table is an extension of another Table. This means it inherits all of the other Table's fields, plus whatever you add here. ( default value: 0 ) tbl_extend Database Tables^(0,1)-(0,N)
Total Fields Indicates the cached total number of Fields which make up this Table. ( default value: 0 ) tbl_num_fields
Total Foreign Keys Outgoing Indicates the cached total number of Foreign Fields in this Table which point to other Database Tables. ( default value: 0 ) tbl_num_foreign_keys
Total Foreign Keys Incoming Indicates the cached total number of Foreign Fields in other Tables which point to this Database Table. ( default value: 0 ) tbl_num_foreign_in

fields
(fld_)

Database Fields

Each record represents one data Field where specific information will be stored in the completed Database.

Incoming: Uploads^(0,N)-(0,1), Database Fields^(0,N)-(0,N), Conditions^(0,N)-(0,N), Log Actions^(0,N)-(0,11)

4 Tables with Foreign Keys

Group: Databases

Type: Data

39 Fields Total

4 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
fields Unique ID fld_id Number, Indexed, Primary Key
Field Database ID Indicates the unique Database ID number which this Field belongs to. This is important to track for generic fields which are not related to a specific Database Table. fld_database Databases^{(11,11)-(0,N)}
Field Table ID Indicates the unique Table ID number which this Field belongs to. Notes: The parent table where this field is used. Only Generic fields have no table assigned. (Hernandez p.279) fld_table Database Tables^(0,11)-(0,N)
Field Sorting Order in Table Indicates the indexed order of this Field, relative to other Fields within their Database Table. This is only important for presenting the list of Fields to a Database Designer. ( default value: 0 ) fld_ord
Field Specification Type Indicates whether this Database Field specification is Unique Field to this Table's instance, or is a Replica Field of a Generic Field shared by multiple Tables, or is itself a Generic Field. This can be important for documenting which Fields might need to maintain parallel changes in their specifications. Notes: Unique - any kind of field that will appear only once within the entire database or a primary key; Generic - a field that serves as a template for other fields within the database; Replica - a field that you base on a given generic field or a foreign key; (Hernandez p.279) Values: Unique ; Generic ; Replica ( default value: Unique ) fld_spec_type
Field Spec Generic Source If this record specification type indicates that it stores a Replica Field, then this information represents the unique Field ID of related the Generic Field. Notes: If this field is a Replica, the Specification Source is set to the Generic field which it mimics. To turn this field into a Replica, select a Generic field from the dropdown and click the Load link. To save a copy of this field as a Generic for future reuse, click the Save As Generic link. (Hernandez p.281) ( default value: -3 ) fld_spec_source Database Fields^(0,N)-(0,N)
Field Name (in Database) Indicates the shorter Field Name without spaces or special characters which is used to technically identify this Field when accessing its stored values in the Database. During system use, the Table's Prefix will be added to the start of the Field Name in this record. Notes: Absolute minimal words that uniquely identifies this field, following database requirements (like probably no spaces). The table abbreviation name will be tacked on to the beginning. (Hernandez p.277) fld_name
Field Name (in English) Indicates the main, casual, name of the Database Field in English. Notes: This label is an alternate name by which you can identify the field within an end-user application interface. Something readable. (Hernandez p.279) fld_eng
Field Alias(es) Indicates any other names this specific Field might be known as. Notes: A name (or set of names) that you use for the field in very rare circumstances. This must be used if there are two occurrences of this field in the same table. (Hernandez p.281) fld_alias
Field Description Indicates the full description of this Database Field. This should generally be a sentence or two describing what information is stored in this Field, and why it is important. Notes: A complete interpretation of the field. Write a clear and succinct statement that accurately identifies the field and clearly states its purpose within the table. Avoid technical jargon, acronyms, abbreviations, and implementation-specific information. (Hernandez p.283) fld_desc
Field Internal Notes Indicates the any important Notes related to this Database Field. This can be important for providing documentation or other internal comments about how or why this Field was designed in this way, or where a list of potentially stored values came from. Notes: Extra space for internal notes, often reserved for implementation-specific information, or planning in progress. fld_notes
Foreign Key Table ID If this Field is a Foreign Key pointing to another Database Table, then this is where that unique Table ID is stored. This is important for tracking data linkages through the Database Design. ( default value: -3 ) fld_foreign_table Database Tables^(0,11)-(0,N)
Degree of Participation: Outgoing Min If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the minimum number of this Table's records which can be related to a single record of the Foreign Table. This is important for documenting and enforcing logical limitations designed with the Database. ( default value: 1 ) fld_foreign_min
Degree of Participation: Outgoing Max If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the maximum number of this Table's records which can be related to a single record of the Foreign Table. This is important for documenting and enforcing logical limitations designed with the Database. ( default value: 1 ) fld_foreign_max
Degree of Participation: Incoming Min If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the minimum number of a Foreign Table's records which can be related to a single record of this Table. This is important for documenting and enforcing logical limitations designed with the Database. ( default value: 1 ) fld_foreign2_min
Degree of Participation: Incoming Max If this Field record defines a Foreign Key, then this helps indicate its degree of participation, the maximum number of a Foreign Table's records which can be related to a single record of this Table. This is important for documenting and enforcing logical limitations designed with the Database. ( default value: 1 ) fld_foreign2_max
Field Values Storing information here indicates that this Database Field can only be set to a specified range of values, separated by semi-colons. (* This field needs to be replaced by a helper table which stores each value as its own record, or perhaps preferably using the Definitions table. ) Notes:* Specifies every possible valid value for a field. You can optionally select a pre-definined value set which is common among various fields. (Hernandez p.294) fld_values
Default Value Indicates the default value for this specific Field, when a new Table record is first created. Notes: A value that a user can into a field when a more appropriate value is not yet available, nulls not allowed. Use a default value ONLY if it is meaningful. (Hernandez p.294) fld_default
Is Indexed Indicates whether or not this Field is to be indexed by the Database for faster searching of this specific field. This is important for ideal Database creation. Notes: When this project is finished, will this field be searched or sorted very very often? A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. (NOT Hernandez approved planning.) Values: 0 ; 1 ( default value: 0 ) fld_is_index
MySQL Data Type Indicates which basic MySQL type of data will be stored with this Database Field. This is important for determining how to export the database or otherwise install it to MySQL-based environments. Notes: MySQL implementation-specific field type, needed for one-click database structure export. (NOT Hernandez approved planning.) ( default value: VARCHAR ) fld_type
Basic Data Type Indicates the most basic nature of the data being stored by this Field, whether . Notes: The most basic nature of the data that this field stores (not implementation-specific). (Hernandez p.286) Values: Alphanumeric ; Numeric ; DateTime ( default value: Alphanumeric ) fld_data_type
Data Length Indicates the total number of characters or digits that a user can enter for any stored value in this Database Field. This is important for ideal Database creation. Notes: The total number of characters or digits that a user can enter for any given value of this field. If otherwise unimportant, this can be set to the maximum length for the best implementation-specific data type. (Hernandez p.289) fld_data_length
Data Decimal Places If this Field's basic data type is numeric, then this denotes the number of digits to the right of the decimal point in real numbers which can be stored in this Database Field. Notes: If this field is Numeric, this denotes the number of digits to the right of the decimal point in a real number (eg. MySQL DOUBLE). (Hernandez p.289) ( default value: 0 ) fld_data_decimals
Character Support Indicates the type of characters that a user can enter as a value for this Database Field. (* Multiple character types are currently stored as comma separated strings, but this should probably be some cleaner method. ) Notes:* The type of characters that a user can enter as a value for this field. Setting and enforcing this helps you ensure that the user cannot introduce meaningless data into the field, enhancing field-level integrity. Letters include foreign language letters. (Hernandez p.289) Values: Letters ; Numbers ; Keyboard ; Special ( default value: ,Letters,Numbers,Keyboard,Special, ) fld_char_support
Input Mask Specifies the manner in which a user should enter data into this field. eg. YYYY-MM-DD Notes: Specifies the manner in which a user should enter data into this field. eg. YYYY-MM-DD (Hernandez p.290) fld_input_mask
Display Format Indicates the appearance of this Database Field's value when it is displayed on a screen or printed within a document. Notes: The appearance of this field's value when it is displayed on a screen or printed within a document. (Hernandez p.291) fld_display_format
Key Type Indicates whether or not this Field is some kind of Key in its parent Database Table, including Foreign Keys, Primary Keys, or Alternate Keys. By default, all Survloop Tables will automatically generate a Unique, Primary Key if no such Field is specified by the Database Designer. (* Multiple key types are currently stored as comma separated strings, but this should probably be some cleaner method. ) Notes:* Designates this field's role within a table. (Hernandez p.292) Values: Non ; Foreign ; Primary ; Alternate ( default value: ,Non, ) fld_key_type
Key Structure If this Database Field is a Primary Key, then this indicates whether it is acting as a simple (single-field) primary key or as part of a composite (multi-field) primary key. Notes: Denotes whether this field designated as a primary key is acting as a simple (single-field) primary key or as part of a composite (multi-field) primary key. (Hernandez p.292) Values: Simple ; Composite fld_key_struct
Edit Rule Indicates whether or not a Field's data can or must be store at the Table record's creation, and whether or not it can it be edited by Users later. Notes: Enter Now - user must enter a value when creating a new table record; Enter Later - user has the option of entering value when creating table record; Edits Allowed - user can edit the value at any time; Edits Not Allowed - after entering a value, user cannot edit it at any time; (Hernandez p.295) Values: NowAllowed ; LateAllow ; NowNot ; LateNot ; NotDeterm ( default value: LateAllow ) fld_edit_rule
Has Unique Value Indicates whether this Database Field's values are unique across all Table records. Notes: Indicates whether this field's values are unique (always for primary keys, rarely for everything else). (Hernandez p.292) Values: 0 ; 1 ( default value: 0 ) fld_unique
Has NULL Support Indicates whether or not this Database Field accepts NULL values to be stored, which should represent missing or unknown information. Notes: Whether this field accepts null values (not allowed for primary keys). Null values should represent missing or unknown values. (Hernandez p.293) Values: 0 ; 1 ( default value: 1 ) fld_null_support
Values Entered By Indicates whether a User or the System enter information into this Database Field. Notes: The source of this field's value. Either a user will enter values into the field manually or a database application program will enter them automatically. (Hernandez p.293) Values: User ; System ( default value: User ) fld_values_entered_by
Is Required Indicates whether or not a User is required to enter a value for this Database Field. Notes: Whether a user is required to enter a value for this field. No for most non-primary-key fields. (Hernandez p.294) Values: 0 ; 1 ( default value: 0 ) fld_required
Compare Same Field Value Indicates the types of comparisons can be applied to a given field value when retrieving information from the same Field in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed. Notes: The types of comparisons a user/system can apply to a given field value when retrieving information from the field. (Hernandez p.296) ( default value: 1 ) fld_compare_same
Compare Other Field Value Indicates the types of comparisons can be applied to a given field value when retrieving information from the other Fields in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed. Notes: The types of comparisons a user/system can apply to a given field value when retrieving information from the field. (Hernandez p.296) ( default value: 1 ) fld_compare_other
Compare Other Values Indicates the types of comparisons can be applied to a given field value when retrieving information from the other values generally. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed. Notes: The types of comparisons a user/system can apply to a given field value when retrieving information from the field. (Hernandez p.296) ( default value: 1 ) fld_compare_value
Operate with Same Field Value Indicates the types of operations which can be applied to a given Field value with the same Field in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed. Notes: Specifies the types of operations that a user can perform on the values. (Hernandez p.298) ( default value: 1 ) fld_operate_same
Operate with Other Field Value Indicates the types of operations which can be applied to a given Field value with the other Fields in other Table records. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed. Notes: Specifies the types of operations that a user can perform on the values. (Hernandez p.298) ( default value: 1 ) fld_operate_other
Operate with Other Value Indicates the types of operations which can be applied to a given Field value with the other values generally. Currently stored as the multiple of various prime numbers which represent the specific comparisons allowed. Notes: Specifies the types of operations that a user can perform on the values. (Hernandez p.298) ( default value: 1 ) fld_operate_value
Field Options Indicates the multiple of various prime numbers which mark other specific qualities of this Field. Notes: %3 Field Is Auto-Managed by Survloop; \| %1 XML Public Data; %7 XML Private Data; %11 XML Sensitive Data; %13 XML Internal Use Data; ( default value: 1 ) fld_opts

definitions
(def_)

Definitions

Includes lists of possible ranges of values for various data Fields throughout the database, and other system settings. This is important for providing dynamic storage for key system terminology which may infrequently change.

Incoming: Uploads^(0,N)-(1,1), Session Emojis^(0,N)-(1,1)

2 Tables with Foreign Keys

Group: Databases

Type: Data

7 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
definitions Unique ID def_id Number, Indexed, Primary Key
Definition Database ID Indicates the unique Database ID number which this Definition belongs to. def_database Databases^{(11,11)-(0,N)}
Set This is a label for a set of system information which may need to be periodically changed by a system Administrator without the technical assistance of a programmer. Important for categorizing these dynamically stored system definitions. Notes: Potential for multiple languages in the future? Values: Survloop Definition Types (Definitions) ( default value: Value Ranges ) def_set
Subset This is a label for a subset of system information which may need to be periodically changed by a system Administrator without the technical assistance of a programmer. Important for categorizing these dynamically stored system Definitions. def_subset
Sorting Order in Subset Indicates the indexed order of this Definition, relative to other Definitions within their Set and Subset of categorization. This is particularly important for providing order to the range of potential response values presented to Users. ( default value: 0 ) def_order
Is Active Indicates whether or not this Database Definition is currently active in the system. This is important for disabling Definitions from the system without deleting them, either temporarily or permanently. Values: 0 ; 1 ( default value: 1 ) def_is_active
Value The dynamically stored text or value which Administrators can manage with a programmer. In the case of Value Ranges, this value is what a User will see, but the unique Definition ID will be stored as the User's response. def_value
Description The optional descriptive notes providing a deeper explanation of this specific Definition. For Value Ranges, this could also provide references and sources regarding the decision to include this Definition. Important for internal documentation and possibly User education. def_description

bus_rules
(rule_)

Business Rules

Each record represents one Business Rule which specifies certain requirements to be maintained in the Database. Implementing the Rules defined here is important for maintaining data integrity.

Group: Databases

Type: Data

12 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
bus_rules Unique ID rule_id Number, Indexed, Primary Key
Rule Database ID Indicates the unique Database ID number which this Business Rule belongs to. rule_database Databases^{(11,11)-(0,N)}
Rule Statement Indicates the text of the business rule itself, clear, succinct, and convey the required constraints in simple English. Notes: The text of the business rule itself, clear, succinct, and convey the required constraints. (Hernandez p.409) rule_statement
Rule Constraint Indicates how the constraint specifically applies to the Database Tables and Fields, intended for a more technical audience. Notes: A brief explanation of how the constraint applies to the tables and fields. (Hernandez p.409) rule_constraint
Rule Tables Indicates a comma-separated list of unique Table IDs which this Rule will affect. (* This should be moved to a different data structure. ) Notes:* Designate the name of the field(s) and table(s) the rule will affect. (Hernandez p.410) ( default value: , ) rule_tables
Rule Fields Indicates a comma-separated list of unique Table IDs which this Rule will affect. (* This should be moved to a different data structure. ) Notes:* Designate the name of the field(s) and table(s) the rule will affect. (Hernandez p.410) ( default value: , ) rule_fields
Is Implemented In Application Indicates whether or not this Business Rule can be directly implemented within the logical design of the database (Database-Oriented). Application-Oriented Rules will have to be implemented with custom coding, outside the scope of Survloop's automation. Notes: Database-Oriented: impose constraints that you can establish within the logical design of the database; Application-Oriented: impose constraints that you cannot establish within the logical design of the database. (Hernandez p.397) Values: 0 ; 1 ( default value: 1 ) rule_is_app_orient
Is Relationship-Specific Indicates whether or not this Business Rule provides additional specifications to a Database Field in isolation, or to a Relationship multiple Fields or Tables. Notes: Field-Specific and Relationship-Specific rules can be established in field specifications, but more details may be provided here if needed. (Hernandez p.399) Values: 0 ; 1 ( default value: 1 ) rule_is_relation
Test Rule On Indicates when the imposed Rule should be tested, whether upon inserting a new Table record, deleting a record, or updating a Field's value. Notes: The constraint imposed should be tested when you attempt to perform: Inserting a record into the table or an entry into a field, Deleting a record from the table or a value within a field, or Updating a field's value. (Hernandez p.408) Values: Insert ; Update ; Delete ( default value: Insert ) rule_test_on
Physical Elements Affected Indicates the multiple of various prime numbers which represent physical data specifications related to this Rule, including Data Type, Length, Decimal Places, Character Support, Input Mask, and Display Format. Notes: %2 Data Type, %3 Length, %5 Decimal Places, %7 Character Support, %11 Input Mask, %13 Display Format ( default value: 1 ) rule_phys
Logical Elements Affected Indicates the multiple of various prime numbers which represent logical data specifications related to this Rule, including Key Type, Key Structure, Uniqueness, Null Support, Values Entered By, Required Value, Default Value, Range of Values, Comparisons Allowed, Operations Allowed, and Edit Rule. Notes: %2 Key Type, %3 Key Structure, %5 Uniqueness, %7 Null Support, %11 Values Entered By, %13 Required Value, %17 Default Value, %19 Range of Values, %23 Comparisons Allowed, %29 Operations Allowed, %31 Edit Rule ( default value: 1 ) rule_logic
Relationship Characteristics Affected Indicates the multiple of various prime numbers which represent data relation specifications related to this Rule, including Deletion Rule, Type of Participation, Degree of Participation. Notes: %2 Deletion Rule, %3 Type of Participation, %5 Degree of Participation ( default value: 1 ) rule_rel
Action Taken Indicates what actions have been taken, or need to be taken, to implement and enforce this Business Rule. Notes: Indicate the modifications made to field specifications, etc, as clearly as possible. (Hernandez p.) rule_action

errors
(err_)

Errors

Group: Infrastructure

Type: Data

5 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
errors Unique ID err_id Number, Indexed, Primary Key
User ID# err_user_id Users^(0,1)-(0,N)
Error Description err_desc
Error Stack Track err_trace
Resolved Values: 0 ; 1 ( default value: 0 ) err_resolved
Date & Time Logged err_date

tree
(tree_)

Trees

Each Tree represents one collection of Nodes which one specific survey process, page of content, navigation menu, etc. Nodes are connected to each other to form a branching Tree which define all the details.

Incoming: Uploads^(0,N)-(1,1), Tree Nodes^{(0,N)-(11,11)}, Data Loops^{(0,N)-(11,11)}, Data Subset Tables^{(0,N)-(11,11)}, Data Helper Tables^{(0,N)-(11,11)}, Data Linkage Tables^{(0,N)-(11,11)}, User Session^{(0,N)-(11,11)}, Searchable Record Dump^(0,1)-(0,1), Session Emojis^(0,N)-(1,1), Tokens^(0,N)-(0,1), Emailings^(0,N)-(0,1), Email Templates^(0,N)-(0,1), Caches^(0,N)-(0,N)

13 Tables with Foreign Keys

Group: Trees

Type: Data

11 Fields Total

6 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
tree Unique ID tree_id Number, Indexed, Primary Key
Primary Database ID Indicates the unique Database ID number which this User Experience primarily belongs to. tree_database Databases^{(11,11)-(0,N)}
Tree Owner User ID Indicates the unique User ID number belonging to the owner of this User Experience or Tree. tree_user Users^(0,11)-(0,N)
Tree Type Indicates whether this Tree (collection of Nodes) indeed maps out a User Experience, or if it provides a map of the Database Design for the creating XML documents automatically-generated by Survloop. Values: Primary Public ; Primary Public XML ( default value: Primary Public ) tree_type
Tree Name Indicates the most succinct and clear name internally used to refer to this specific Tree. tree_name
Tree Description Documents a longer description of the purpose, use, and importance of this specific Tree. tree_desc
Tree URL Indicates the URL for the starting page of this Tree. tree_slug
Root Node ID Indicates the unique Experience Node ID of the first, Root Node of this entire User Experience. All other Nodes within this Tree are descendants of the Root Node. tree_root Tree Nodes^{(11,11)-(0,11)}
First Page Node ID Stores a cache of the unique Experience Node ID of this Tree's first Node which is a Page. This helps to quickly identify the URL of the first Page the user will experience. tree_first_page Tree Nodes^{(11,11)-(0,11)}
Last Page Node ID Stores a cache of the unique Experience Node ID of this Tree's last Node which is a Page. This helps to quickly identify the URL of the final Page the user will experience. tree_last_page Tree Nodes^{(11,11)-(0,11)}
Tree Core Data Table Indicates the unique Table ID which acts as the backbone for all data collected throughout this entire Tree. tree_core_table Database Tables^(0,11)-(0,N)
Tree Options Indicates the multiple of various prime numbers which mark specific other qualities of this Node. Notes: %3 Admin-Only; %5 Tree That Is One Big Survloop; %7 Area Home Page (for Public, Admin, or Volun); %11 Record Edits Not Allowed (except by Admins); %13 Report for Survey (linked and shares core table); %17 Volunteers Access (& Admin); %19 Contact Form (Auto Page); %23 Page Is Skinny; %29 Page Not [Yet] Simple Enough To Be Cached; %31 Search Bar Results Page (for Public, Admin, or Volun); %37 Survey Navigation Menu Bottom; %41 Partners Member Access; %43 Staff Access; %47 Uses Public ID#; %53 Has Page Form; %59 Survey Navigation Menu Top; %61 Survey Progress Line ( default value: 1 ) tree_opts

nodes
(node_)

Tree Nodes

Each record represents one Node in the branching Tree, defining the critical details of each survey, page, etc. Each Node could represent the start of a new branch of the Tree, a new question asked of a User, or a new page which will ask multiple questions.

Incoming: Trees^{(0,11)-(11,11)}, Trees^{(0,11)-(11,11)}, Trees^{(0,11)-(11,11)}, Tree Nodes^(0,N)-(0,N), Node Responses^{(0,N)-(11,11)}, Data Loops^{(0,N)-(11,11)}, User Session^{(0,N)-(11,11)}, User Session^(0,N)-(0,11), User Session^(0,N)-(0,11), Node Saves^{(0,N)-(11,11)}, Page Saves^{(0,N)-(11,11)}, Design Tweaks^{(11,11)-(11,11)}, Gallery Images^(0,N)-(0,1)

13 Tables with Foreign Keys

Group: Trees

Type: Data

17 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
nodes Unique ID node_id Number, Indexed, Primary Key
Node Tree ID Indicates the unique Tree ID number which this Tree Node belongs to. node_tree Trees^{(11,11)-(0,N)}
Parent Node ID Indicates the unique Experience Node ID of this Node's parent Node. This linkage is the thread which connect all Nodes as branches of the entire Experience Tree. ( default value: -3 ) node_parent_id Tree Nodes^(0,N)-(0,N)
Sibling Node Sorting Order Indicates the indexed order of this Experience Node, relative to sibling Nodes which share the same Parent Node. This is how the branches of the entire Experience Tree stay sorted. ( default value: 0 ) node_parent_order
Node Type Indicates whether this Experience Node represents either a branch (for navigation), a specific question to the User, a collection of questions as one page, a loop of many pages, or a specific manipulation of previously stored data. Question Nodes include Instructions, Radio, Checkbox, Drop Down, Text, Long Text, Text:Number, Email, Password, Date, Date Picker, Date Time, Time, Gender, Gender Not Sure, Feet Inches, U.S. States, Hidden Field, Spambot Honey Pot, Uploads, and Other/Custom. Nodes which are part of Trees which map XML output are of a separate XML Type. Values: Page ; Branch Title ; Loop Root ; Data Manip: New ; Data Manip: Update ; Data Manip: Wrap ; Instructions ; Radio ; Checkbox ; Drop Down ; Text ; Long Text ; Text:Number ; Email ; Password ; Date ; Date Picker ; Date Time ; Time ; Gender ; Gender Not Sure ; Feet Inches ; U.S. States ; Hidden Field ; Spambot Honey Pot ; Uploads ; Other/Custom ; XML node_type
Node Question/Prompt To User Indicates the language used to prompt a User Response. For special Node Types like branches, pages, and loop roots, this field stores a title or name. For XML Nodes, this fields stores the name of the Database Table included in the mapped. node_prompt_text
Node Side-Notes To User Indicates the language used to prompt a User Response. For special Node Types like branches, pages, and loop roots, this field stores the Node's URL slug. For XML Nodes, this fields stores the unique Table ID of the Database Table included in the mapped. node_prompt_notes
Extra HTML After Node Response Stores any extra HTML, CSS, or Javascript which a Database Designer wants to appear directly after the User's opportunity to Respond to a Node's Prompt. node_prompt_after
Internal Notes Stores any internal notes which Experience Designers want to share. node_internal_notes
User Response Set Indicates the range of options the User will be provided for Node which ask some kind of multiple-choice question. This includes "Definition::{DefSubset}", "LoopItems::{LoopName}", or "[Set:{TableName};;HideIf:1]", but most Question Nodes have Response Options stored in the Node Responses table. node_response_set
Default Response Value Indicates if any of the Response options should be pre-selected when this Node loads for the User. node_default
Node Data Branch Indicates the name of the Database Table as a point of reference for this Node's data interactions, and all of its descendants. Notes: Yes, this should be changed to a Foreign Key to the Table ID. node_data_branch
Node Data Field Indicates the Database Table and Field where the User's Response will actually be stored. Notes: Yes, this should be changed to a Foreign Key to the Field ID. node_data_store
Response Text Suggest Indicates an optional setting to suggest a response or instruction within this Node's open-ended form field. node_text_suggest
Response Character Limit Indicates the maximum number of characters a User may enter in Response to this Node's prompt. ( default value: 0 ) node_char_limit
Node Likes For some systems, this indicates how many Users responded to this Node with "a like". ( default value: 0 ) node_likes
Node Dislikes For some systems, this indicates how many Users responded to this Node with "a dislike". ( default value: 0 ) node_dislikes
Node Options Indicates the multiple of various prime numbers which mark specific other qualities of this Node. Notes: For XML Nodes... %5 Include members with parent, without table wrap; %7 Min 1 Record; %11 Max 1 Record; \| For Other Nodes... %2 Customize Layout; %13 'Required' Displayed On Separate Line; %29 Exit Page; %31 Show Word Count; %37 Wrap In Jumbotron Style; %41 Echo Response Edits To Div; %43 Toggle Child Nodes On Click; %47 Limit Word Count; %53 Dropdown Tagger; %59 Hide Progress Bar; %61 Responses In Columns; %67 Skinny Content Width; %71 Content Block Background; %73 Leave Existing Rows' Records; %79 After Response Selected, Hide Other Options; %83 Show After Pressing Info Button; %89 Wrap in Card Element; %97 Defer Loading of Node Contents ( default value: 1 ) node_opts

node_responses
(node_res_)

Node Responses

Each record represents one Response presented to the User when prompted by a specific Node.

Group: Trees

Type: Subset

6 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
node_responses Unique ID node_res_id Number, Indexed, Primary Key
Response Node ID Indicates the unique Experience Node ID number which this Node Response belongs to. node_res_node Tree Nodes^{(11,11)-(0,N)}
Response Sorting Order Indicates the indexed order of this Node Response, relative to other Response options for this Experience Node. ( default value: 0 ) node_res_ord
Response Description Describes this Node Response option clearly in English for the User. node_res_eng
Response Stored Value Indicates how a User selection of this Node Response option should be stored in the Database. node_res_value
Show Child Node If Selected Indicates whether or not child Nodes should be revealed to the User upon selecting this specific Node Response option. ( default value: 0 ) node_res_show_kids
Response Is Mutually Exclusive Indicates whether or not this response option is mutually exclusive with all the other responses to this question (Node). ( default value: 0 ) node_res_mut_ex

conditions
(cond_)

Conditions

Each record represents one specific Condition used to filter Database submissions. These are important for determining which Nodes to include during a User's Experience, and which finished submissions to include in public queries.

Incoming: Condition Values^{(0,N)-(11,11)}, Condition Nodes^(0,N)-(0,N)

2 Tables with Foreign Keys

Group: Trees

Type: Data

9 Fields Total

4 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
conditions Unique ID cond_id Number, Indexed, Primary Key
Condition Database ID Indicates the unique Database ID number which this Condition can be applied to. cond_database Databases^{(11,11)-(0,N)}
Condition Tag/Name Indicates the short name, like a hashtag on social media, which is used both internally and publicly to easily identify this Condition/Filter. cond_tag
Condition Description Describes this Condition/Filter in English, as accurately and succinctly as possible, for both internal and public use. cond_desc
Condition Operator Indicates what type of testing to do as part of applying this Data Condition. This includes checking for User Responses within a specified range of values ( "{" ), outside a specified range of values ( "}" ), checking the number of records a Database Table has ( "EXISTS>" ), or "CUSTOM". ( default value: { ) cond_operator
Condition Operator Details Indicates qualifying details to further specify this operator's requirements for this Condition. For "EXISTS>" Conditions, this stores the maximum number of Table records which can exist while passing this Condition as FALSE. cond_oper_deet
Database Field ID Indicates the unique Field ID number for the data being tested in this Database Condition. cond_field Database Fields^(0,N)-(0,N)
Database Table ID Indicates the unique Table ID number for the data being tested in this Database Condition. cond_table Database Tables^(0,N)-(0,N)
Data Loop ID Indicates the unique Data Loop ID number for the data being tested in this Database Condition. cond_loop Data Loops^(0,N)-(0,N)
Condition Options Indicates the multiple of various prime numbers which mark any other specific qualities of this Condition. Notes: %2 For Public Use In Filter Defaults; %3 Is Linked With Article(s); ( default value: 1 ) cond_opts

conditions_vals
(cond_val_)

Condition Values

Each record represents one Value to be compared with a User's Response when testing a specific Condition. This is important for comparing among a range of values.

Group: Trees

Type: Subset

2 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
conditions_vals Unique ID cond_val_id Number, Indexed, Primary Key
Value Condition ID Indicates the unique Condition ID number which this Value option relates to. cond_val_cond_id Conditions^{(11,11)-(0,N)}
Value Description Indicates the actual User Response Value, which would be stored in the Database, associated with the Condition related to this record. cond_val_value

conditions_nodes
(cond_node_)

Condition Nodes

Each record represents a linkage between one Node or one Data Loop within this Experience.

Incoming: Condition Nodes^(0,N)-(0,N)

1 Table with Foreign Key

Group: Trees

Type: Linking

3 Fields Total

3 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
conditions_nodes Unique ID cond_node_id Number, Indexed, Primary Key
Condition ID Indicates the unique Condition ID number of the Condition being applied to an Experience Node or a Data Loop. cond_node_cond_id Conditions^(0,N)-(0,N)
Experience Node ID Indicates the unique Experience Node ID number which this Condition has been applied to. cond_node_node_id Condition Nodes^(0,N)-(0,N)
Data Loop ID Indicates the unique Data Loop ID number which this Condition has been applied to. cond_node_loop_id Data Loops^(0,N)-(0,N)

conditions_articles
(article_)

Condition Articles

Each record represents one Article which provides more information regarding Experience submissions which meet a Condition's requirements. This is important for provident automated, educational information to Users and the public.

Incoming: Condition Articles^(0,N)-(0,N)

1 Table with Foreign Key

Group: Trees

Type: Subset

3 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
conditions_articles Unique ID article_id Number, Indexed, Primary Key
Article Condition ID Indicates the unique Condition ID number of the Condition being associated with complementary information. article_cond_id Condition Articles^(0,N)-(0,N)
Article URL Indicates the URL of an Article which provides more information for Users with completed submissions meeting this related Condition/Filter. article_url
Article Title Indicates an appropriate title for an Article which provides more information for Users with completed submissions meeting this related Condition/Filter. article_title

data_loop
(data_loop_)

Data Loops

Each record represents one Data Loop's full details. This is important for automating data relations for related Experiences.

Incoming: Conditions^(0,N)-(0,N), Condition Nodes^(0,N)-(0,N)

2 Tables with Foreign Keys

Group: Trees

Type: Data

12 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
data_loop Unique ID data_loop_id Number, Indexed, Primary Key
Data Loop Experience ID Indicates the unique Experience ID number of the User Experience for which this Data Loop is required. data_loop_tree Trees^{(11,11)-(0,N)}
Root Node ID Indicates the unique Node ID number of this Data Loop's Root Node. All of the descendants of this Data Loop's Root will be repeated until the User wants to continue past it, or Loop's constraints are exceeded. data_loop_root Tree Nodes^{(11,11)-(0,N)}
Plural Name For Items In Loop Indicates the way to describe multiple Items in this Data Loop (eg. "Witnesses"). This is also the primary name for this Data Loop, so its value should be unique within each Database. data_loop_plural
Singular Name For Items In Loop Indicates the way to describe multiple Items in this Data Loop (eg. "Witness"). data_loop_singular
Data Loop Core Table Indicates the name of the Database Table whose records will either be looped through, or created during this Data Loop. Notes: Yes, this should be changed to a Foreign Key to the Table ID. data_loop_table
Data Sort Field Indicates the full Database Field name ( "{TableAbbr}{FldName}" ) to be used for sorting Table records as Data Loop Items. Notes: Yes, this should be changed to a Foreign Key to the Field ID. data_loop_sort_fld
Loop Completed Field Indicates the full Database Table and Field address ( "{TableName}:{TableAbbr}{FldName}" ) to be checked signifying that the User has successfully completed the Data Loop for a given Item. Notes: Yes, this should be changed to a Foreign Key to the Field ID. data_loop_done_fld
Maximum Loop Items Indicates how many Data Loop Items/Records the User is allowed add. ( default value: 0 ) data_loop_max_limit
Warn Item Maximum Indicates how many Data Loop Items/Records will trigger a warning to the User that they are approaching the maximum limit. ( default value: 0 ) data_loop_warn_limit
Minimum Loop Items Indicates how many Data Loop Items/Records the User must add. ( default value: 0 ) data_loop_min_limit
Is Step-Loop Indicates whether or not this Data Loop operates as a Step-Loop, meaning Table records are added to the Database before this Data Loops steps the User through adding information for one preexisting Loop Item at a time. Otherwise, Data Loops behave so that Users to can add Loop Items until the specified limits are reached. Values: 0 ; 1 ( default value: 0 ) data_loop_is_step
Data Auto-Generates If this is not a Step-Loop, this indicates whether or not this Data Loop should automatically create new Database Table records (and child data structures) when a User clicks to add another Loop Item. Values: 0 ; 1 ( default value: 1 ) data_loop_auto_gen

data_subsets
(data_sub_)

Data Subset Tables

Each record represents one linkage between one Database Table and a Subset Table which pulls in one related secondary record of detailed information. This is important for automating data relations for related Experiences.

Group: Trees

Type: Linking

6 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
data_subsets Unique ID data_sub_id Number, Indexed, Primary Key
Data Link Experience ID Indicates the unique Experience ID number of the User Experience for which this Data Subset is required. data_sub_tree Trees^{(11,11)-(0,N)}
Primary Table Indicates the name of the primary Database Table in this Data Subset relationship, included in this User Experience. This Table is upstream of the secondary Table when loading User Data. Notes: Yes, this should be changed to a Foreign Key to the Table ID. data_sub_tbl
Primary Table Linking Field When appropriate, this indicates the full name ( "{TableAbbr}{FldName}" ) of the primary Table's Field to find related secondary Table records in the User's Data. This Field must be a Foreign Key pointing to the secondary Table. Notes: Yes, this should be changed to a Foreign Key to the Field ID. data_sub_tbl_lnk
Secondary Table Indicates the name of the secondary Database Table in this Data Subset relationship, included in this User Experience. This Table is downstream of the primary Table when loading User Data. Notes: Yes, this should be changed to a Foreign Key to the Table ID. data_sub_sub_tbl
Secondary Table Linking Field When appropriate, this indicates the full name ( "{TableAbbr}{FldName}" ) of the secondary Table's Field to find related secondary Table records in the User's Data. This Field must be a Foreign Key pointing to the primary Table. Notes: Yes, this should be changed to a Foreign Key to the Field ID. data_sub_sub_lnk
Secondary Records Auto-Generated Indicates whether or not this Data Subset should enforce the auto-creation of secondary Table records, whenever the related primary Table record exists. Values: 0 ; 1 ( default value: 0 ) data_sub_auto_gen

data_helpers
(data_help_)

Data Helper Tables

Each record represents one linkage between one Database Table and a Helper Table which can store multiple checkbox responses or relate many secondary records to the primary. This is important for automating data relations for related Experiences.

Group: Trees

Type: Linking

5 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
data_helpers Unique ID data_help_id Number, Indexed, Primary Key
Data Link Experience ID Indicates the unique Experience ID number of the User Experience for which this Data Helper is required. data_help_tree Trees^{(11,11)-(0,N)}
Primary Table Indicates the name of the primary Database Table in this Data Helper relationship, included in this User Experience. This Table is upstream of the secondary Table when loading User Data. Notes: Yes, this should be changed to a Foreign Key to the Table ID. data_help_parent_table
Secondary Table Indicates the name of the primary Database Table in this Data Helper relationship, included in this User Experience. This Table is downstream of the primary Table when loading User Data. Notes: Yes, this should be changed to a Foreign Key to the Table ID. data_help_table
Secondary Foreign Key Indicates the full name ( "{TableAbbr}{FldName}" ) of the secondary Table's Field to find related secondary Table records in the User's Data. This Field must be a Foreign Key pointing to the secondary Table. Notes: Yes, this should be changed to a Foreign Key to the Field ID. data_help_key_field
Secondary Storage Field When appropriate, this indicates the full name ( "{TableAbbr}{FldName}" ) of the secondary Table's Field which stores multiple checkbox Response Values from the User and associates them with the primary Database Table. Notes: Yes, this should be changed to a Foreign Key to the Field ID. data_help_value_field

data_links
(data_link_)

Data Linkage Tables

Each record represents one linkage between one Database Table and a second Table which don't require a hierarchical relationship. This is important for automating data relations for related Experiences.

Group: Trees

Type: Linking

2 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
data_links Unique ID data_link_id Number, Indexed, Primary Key
Data Link Experience ID Indicates the unique Experience ID number of the User Experience for which this Data Link is required. data_link_tree Trees^{(11,11)-(0,N)}
Database Linkage Table Indicates the unique Table ID number for the many-to-many linkage table to be included when a User's Data is loaded for this User Experience. data_link_table Database Tables^{(11,11)-(0,N)}

images
(img_)

Gallery Images

Each record represents one item in the Media Galleries managed by Survloop.

Group: Trees

Type: Data

13 Fields Total

3 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
images Unique ID img_id Number, Indexed, Primary Key
Database ID Indicates the unique Database ID number which owns this media item. img_database_id Databases^(1,1)-(0,N)
User ID Indicates the unique User ID number who uploaded or owns this media item. img_user_id Users^(0,1)-(0,N)
Original Filename Indicates the original filename, as it was uploaded. img_file_orig
Stored Filename Indicates the filename as it was actually stored here on the server. img_file_loc
Full File Location Indicates the full path where this media file is actually stored here on the server (relative to the system app's root). img_full_filename
Media Title Indicates the title of this uploaded media, or a concise description of it. This is important as a label used internally throughout the system. img_title
Media Credit (Legal) Indicates any attribution required or appropriate to be shared alongside this media item. img_credit
Media Credit URL (Legal) Indicates an optional URL link for any attribution required or appropriate to be shared alongside this media item. img_credit_url
Node ID Indicates the unique Node ID number used to upload this media item. img_node_id Tree Nodes^(0,1)-(0,N)
Media Type Indicates which allowed type of media upload this record tracks. Values: jpg ; png ; gif img_type
Media File Size Indicates this media file's size in bytes here on the server. img_file_size
Media Width Indicates the default width of this media item. img_width
Media Height Indicates the default height of this media item. img_height

uploads
(up_)

Uploads

Each record stores details about a file uploaded by a user, especially with any survey process.

Group: Trees

Type: Data

13 Fields Total

3 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
uploads Unique ID up_id Number, Indexed, Primary Key
Tree ID Indicates the unique Tree ID number which this Upload belongs to. This is important to track the journey to this upload. up_tree_id Trees^(1,1)-(0,N)
Tree Node ID Indicates the unique Node ID number (within the Tree) from which this file was uploaded. This is potentially important for tracking exactly when the user uploaded this. up_node_id
Core Record ID Indicates the unique ID number associated the Core Record for whichever Tree this Upload belongs to. This is important to track the journey to this upload. up_core_id
Upload Type Indicates the type of upload as defined by the unique Definition ID number from the Definitions set 'Value Ranges' and subset 'Upload Types'. up_type Definitions^(1,1)-(0,N)
Privacy Setting Indicates whether or not the user wants this uploaded file to be publicly published or for administrators' eyes only. up_privacy
Title of File Indicates a brief name by which this file can be referenced in English. up_title
Description of File Provides a longer description for this uploaded file, if needed. up_desc
Filename as Uploaded Indicates the original filename for this upload when it got to the server. up_upload_file
Filename as Stored Indicates the new filename for this upload as it is stored on the server. up_stored_file
Video Link URL Indicates the URL of a video being "uploaded". So far, only YouTube is supported for automatically embeded previews. up_video_link
Video Duration Indicates the duration of the video in seconds. up_video_duration
Link Field ID Indicates the unique Database Field ID which this uploaded file is related to. up_link_fld_id Database Fields^(0,1)-(0,N)
Link Record ID Indicates the unique Record ID from the Database Table owning the associated Field, if applicable. up_link_rec_id

search_rec_dump
(sch_rec_dmp_)

Searchable Record Dump

Each record stores a cache of all data from a specific complex record, including English translations for Definition IDs, etc. This is very useful for running text searches across all Experience submissions.

Group: Trees

Type: Validation

4 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
search_rec_dump Unique ID sch_rec_dmp_id Number, Indexed, Primary Key
Tree ID Indicates the unique Tree ID number which this record belongs to. sch_rec_dmp_tree_id Trees^(0,1)-(0,1)
Submission Record ID Indicates the unique record ID number whose data is being cached here. sch_rec_dmp_rec_id
Full Record Dump Stores a cache of all raw data from a specific submission record, including English translations for Definition IDs, etc. sch_rec_dmp_dump
Permissions Indicates this data cache's permissions. sch_rec_dmp_perms

design_tweaks
(twk_)

Design Tweaks

Represents one modification to the existing database and user experience designs in Survloop. Information stored here is important for tracking history of changes and success of A/B testing in the user experience. This is the Core Data Table of Survloop's naked installation.

Incoming: User Session^{(0,N)-(11,11)}

1 Table with Foreign Key

Group: Session Records

Type: Data

7 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
design_tweaks Unique ID twk_id Number, Indexed, Primary Key
User ID Indicates the unique User ID number of the User owning the data stored in this record for this Experience. twk_user_id Users^{(11,11)-(11,11)}
Experience Node Progress Indicates the unique Node ID number of the last Experience Node loaded during this User's Experience. twk_submission_progress Tree Nodes^{(11,11)-(11,11)}
A/B Testing Version Stores a complex string reflecting all A/B Testing variations in effect at the time of this User's Experience of this Node. twk_version_ab
IP Address ^{^} Encrypted IP address of the current user. twk_ip_addy
Tree Version Number ^{^} Stores the current version number of this User Experience, important for tracking bugs. twk_tree_version
Unique String For Record ^{^} This unique string is for cases when including the record ID number is not appropriate. twk_unique_str
Using Mobile Device ^{^} Indicates whether or not the current user is interacting via a mobile deviced. twk_is_mobile
User ID ^{^} Indicates the unique User ID number of the User owning the data stored in this record for this Experience. twk_user_id
Experience Node Progress ^{^} Indicates the unique Node ID number of the last Experience Node loaded during this User's Experience. twk_submission_progress
Tree Version Number ^{^} Stores the current version number of this User Experience, important for tracking bugs. twk_tree_version
A/B Testing Version ^{^} Stores a complex string reflecting all A/B Testing variations in effect at the time of this User's Experience of this Node. twk_version_ab
Unique String For Record ^{^} This unique string is for cases when including the record ID number is not appropriate. twk_unique_str
IP Address ^{^} Encrypted IP address of the current user. twk_ip_addy
Using Mobile Device ^{^} Indicates whether or not the current user is interacting via a mobile deviced. twk_is_mobile

sess
(sess_)

User Session

Each record represents one User's Session while going through an Experience. This is important for saving a User's progress if they have to complete an Experience over the course of multiple browser sessions.

Incoming: Session Loops^{(0,N)-(11,11)}, Node Saves^{(0,N)-(11,11)}, Page Saves^{(0,N)-(11,11)}

3 Tables with Foreign Keys

Group: Session Records

Type: Data

10 Fields Total

6 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
sess Unique ID sess_id Number, Indexed, Primary Key
Session User ID Indicates the unique User ID for the Database User logged in and using this Session record. sess_user_id Users^{(11,11)-(0,N)}
Session Experience ID Indicates the unique Experience ID number of the User Experience which this Session record is tracking. sess_tree Trees^{(11,11)-(0,N)}
User's Core Table Record ID Indicates the unique Table ID number for the User's record in this Experience's Core Data Table. This is important for saving update's in the User's progress. sess_core_id Design Tweaks^{(11,11)-(0,N)}
Is Active Indicates whether or not this session is currently active, or editable. This allows us to avoid permanently deleting these records valuable for audits. Values: 0 ; 1 sess_is_active
Session Current Node ID Indicates the unique Node ID number of the last Experience Node this User loaded. sess_curr_node Tree Nodes^{(11,11)-(0,N)}
Just Left Loop Root ID When appropriate, this Session data stores the unique Root Node ID for a Data Loop which has just been exited by the User. sess_loop_root_just_left Tree Nodes^(0,11)-(0,N)
Jump From Node ID When appropriate, this Session data stores the unique Node ID for an Experience Node the User has just used custom navigation to jump away from. sess_after_jump_to Tree Nodes^(0,11)-(0,N)
Using Mobile Device Indicates whether or not the User is currently using a mobile device (1 if yes). Values: 0 ; 1 sess_is_mobile
Session Browser Indicates the web browser used during this Session. sess_browser
IP Address Encrypted IP address of the current user. sess_ip

sess_loops
(sess_loop_)

Session Loops

Each record represents one User's current Data Loop Item which they are editing, as related to their current Session. This is important for saving a User's progress if they have to complete an Experience over the course of multiple browser sessions.

Group: Session Records

Type: Subset

3 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
sess_loops Unique ID sess_loop_id Number, Indexed, Primary Key
User Session ID Indicates the unique Session ID for the User Session whose Data Loop progress is stored in this record. sess_loop_sess_id User Session^{(11,11)-(0,N)}
Data Loop Name Indicates the name of the Data Loop with User progress to store in this record. Notes: Yes, this should be changed to a Foreign Key to the Data Loop ID. sess_loop_name
Data Loop Item ID Indicates the unique ID number of the Data Loop Item which the User was last working on. sess_loop_item_id

node_saves_page
(page_save_)

Page Saves

Each record represents one timestamp of a User's submission of a specific Page Node during a specific Session. This is important for quickly checking or reviewing the progress of Users through an Experience.

Group: Session Records

Type: Data

3 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
node_saves_page Unique ID page_save_id Number, Indexed, Primary Key
User Session ID Indicates the unique Session ID for the User Session whose Page Node progress is stored in this record. page_save_session User Session^{(11,11)-(0,N)}
Page Node ID Indicates the unique Node ID for the Experience Page Node this Session has loaded. page_save_node Tree Nodes^{(11,11)-(0,N)}
Data Loop Item ID Indicates the unique ID number of the Data Loop Item which the User was working on for this Page Node. page_save_loop_item_id

node_saves
(node_save_)

Node Saves

Each record represents one User's Response to a specific Node during a specific Session. Among other quality control, this is important for comparing the efficacy of various A/B testing in the user experience.

Group: Session Records

Type: Data

6 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
node_saves Unique ID node_save_id Number, Indexed, Primary Key
User Session ID Indicates the unique Session ID for the User Session whose Node response is stored in this record. node_save_session User Session^{(11,11)-(0,N)}
Data Loop Item ID Indicates the unique ID number of the Data Loop Item which the User was working on for this Node Response. node_save_loop_item_id
Save Node ID Indicates the unique Node ID for the Experience Node whose User response is stored in this record. node_save_node Tree Nodes^{(11,11)-(0,N)}
A/B Testing Version Stores a complex string reflecting all A/B Testing variations in effect at the time of this User's Experience of this Node. node_save_version_ab
Storage Data Field Indicates the full Database Table and Field address ( "{TableName}:{TableAbbr}{FldName}" ) where this Node has decided to store the User's Response. Notes: Yes, this should be changed to a Foreign Key to the Field ID. node_save_tbl_fld
User Response Indicates the stored User's Response Value, or a dump of related information. node_save_new_val

sess_emojis
(sess_emo_)

Session Emojis

Each record stores one tag of one submission, by one user. This enables users to interact and provide feedback on completed Experience submissions, and to prevent users from tagging more than once.

Group: Session Records

Type: Linking

4 Fields Total

3 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
sess_emojis Unique ID sess_emo_id Number, Indexed, Primary Key
User ID Indicates the unique User ID number whose interactions are being logged here. Important for ensuring that one User cannot tag someone's completed submission more than once. sess_emo_user_id Users^(0,1)-(0,N)
Tree ID Indicates the unique Tree ID number that the record being tagged belongs to. Vital for knowing which table the record ID refers to. sess_emo_tree_id Trees^(1,1)-(0,N)
Submission Record ID Indicates the unique record ID number which is being tagged with this row. sess_emo_rec_id
Tag Definition ID Indicates the unique Definition ID number belonging to the specific tag or interaction being logged in this row. sess_emo_def_id Definitions^(1,1)-(0,N)

sess_site
(site_sess_)

Site Session

Each record represents one User's Site Session while browsing through the whole website, not just surveys. This is important for identifying any problems in the website use flow.

Incoming: Session Page Loads^(0,N)-(1,1), Campaign Clicks^(0,N)-(1,1), Discussion Comments^(0,N)-(1,1), User Subscription Paid Redirects^(0,N)-(1,1)

4 Tables with Foreign Keys

Group: Session Records

Type: Data

5 Fields Total

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
sess_site Unique ID site_sess_id Number, Indexed, Primary Key
IP Address ^{^} Encrypted IP address of the current user. site_sess_ip_addy
Session User ID Indicates the unique User ID for the Database User logged in and using this Site Session record. site_sess_user_id
Using Mobile Device Indicates whether or not the User is currently using a mobile device (1 if yes). Values: 0 ; 1 site_sess_is_mobile
Session Browser Indicates the web browser used during this Session. site_sess_browser
Zoom Preference Indicates the User's current preference of visual zoom of the page. site_sess_zoom_pref

campaigns
(camp_)

Campaigns

Each record stores information about a specific promotional campaign.

Group: Session Records

Type: Data

1 Fields Total

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
campaigns Unique ID camp_id Number, Indexed, Primary Key
Campaign Name Indicates the best name for this marketing campaign, used to track referrals. camp_name

campaign_clicks
(camp_clk_)

Campaign Clicks

Each record represents a click through to the site from a promotional campaign.

Group: Session Records

Type: Data

3 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
campaign_clicks Unique ID camp_clk_id Number, Indexed, Primary Key
Campaign ID Indicates the unique Campaign ID number of this referral. camp_clk_campaign_id Site Session^(1,1)-(0,N)
Click From URL Indicates the URL where this site visitor came from to arrive at the site. camp_clk_from_url
Click To URL Indicates the URL on this site which this visitor is loading. camp_clk_to_url

sess_page
(sess_page_)

Session Page Loads

Each record represents one page load, or server-side redirect, as related to their current Session. This is important for saving a User's path through the entire website.

Group: Session Records

Type: Data

2 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
sess_page Unique ID sess_page_id Number, Indexed, Primary Key
Session ID Indicates the unique Session ID for the User Session who loaded this page. sess_page_sess_id Site Session^(1,1)-(0,N)
URL Loaded Indicates the URL which is currently being loaded, or redirected through on the server-side. sess_page_url

threads
(thrd_)

Discussion Threads

Each row stores a bit of information about one Discussion Thread, which acts as the primary anchor for a branching tree of Discussion Comments.

Incoming: Discussion Comments^(0,N)-(1,1)

1 Table with Foreign Key

Group: Community

Type: Data

3 Fields Total

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
threads Unique ID thrd_id Number, Indexed, Primary Key
Discussion Name/Title Indicates the name or title for this Discussion Thread or comment spot. thrd_name
Total Discussion Comments Indicates the total number of Discussion Comments added to this Discussion. Important for knowing which Discussions have the most activity overall. thrd_discuss_total
Last Discussion Comment Indicates the date and time of the last comment added to this Discussion. Important for knowing which Discussions have the most recent activity. thrd_discuss_last

thread_comments
(thrd_cmt_)

Discussion Comments

Each row represents a Comment added somewhere within a Discussion Thread.

Incoming: Discussion Comments^(0,N)-(0,1), Discussion Comments^(0,N)-(0,1), Discussion Thread Followers^(0,N)-(1,1), Discussion Comment Likes^(0,N)-(1,1)

4 Tables with Foreign Keys

Group: Community

Type: Data

8 Fields Total

5 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
thread_comments Unique ID thrd_cmt_id Number, Indexed, Primary Key
Discussion Thread ID Indicates the unique Discussion Thread ID to which this Comment belongs. thrd_cmt_thread_id Discussion Threads^(1,1)-(0,N)
User ID Indicates the unique User ID who published this Comment. thrd_cmt_user_id Users^(1,1)-(0,N)
User Session ID Indicates the unique User Session ID to which this Comment belongs. thrd_cmt_sess_id Site Session^(1,1)-(0,N)
Reply To Comment ID Indicates the other unique Comment ID to which this Comment replies. ( default value: 0 ) thrd_cmt_reply_to Discussion Comments^(0,1)-(0,N)
Reply Root Comment ID Indicates the other unique Comment ID which is the Root Comment of this reply. ( default value: 0 ) thrd_cmt_reply_root Discussion Comments^(0,1)-(0,N)
Depth Within Thread Indicates how many sub-threads deep this comment lies, for convenient lookup. ( default value: 0 ) thrd_cmt_depth
Total Likes Indicates the total number of Likes this Comment has received. ( default value: 0 ) thrd_cmt_tot_likes
Total Dislikes Indicates the total number of Dislikes this Comment has received. ( default value: 0 ) thrd_cmt_tot_dislikes

thread_likes
(thrd_lik_)

Discussion Comment Likes

Each row represents one User voting up or down one specific Comment.

Group: Community

Type: Subset

3 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
thread_likes Unique ID thrd_lik_id Number, Indexed, Primary Key
Discussion Thread Comment ID Indicates the unique Discussion Thread Comment ID which this User wants to Like or Dislike. thrd_lik_comment_id Discussion Comments^(1,1)-(0,N)
User ID Indicates the unique User ID who wants to Like or Dislike this Comment. thrd_lik_user_id Users^(1,1)-(0,N)
Like/Dislike Indicates whether this User Likes or Dislikes this specific Comment. ( default value: 0 ) thrd_lik_like

thread_follows
(thrd_flw_)

Discussion Thread Followers

Each row represents one User who wishes to be alerted to updates of one Discussion Thread.

Group: Community

Type: Linking

3 Fields Total

2 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
thread_follows Unique ID thrd_flw_id Number, Indexed, Primary Key
Discussion Thread Comment ID Indicates the unique Discussion Thread Comment ID which this User wants to follow. thrd_flw_comment_id Discussion Comments^(1,1)-(0,N)
User ID Indicates the unique User ID who wants to follow this Comment and any of its sub-threads. thrd_flw_user_id Users^(1,1)-(0,N)
Type of Discussion Following Indicates what level of following the User wants for this Comment Thread. ( default value: 1 ) thrd_flw_follow_type

users_activity
(user_act_)

User Activity

Each record represents one log entry of a User's Activity, important for tracking system usage.

Group: Logs

Type: Validation

3 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
users_activity Unique ID user_act_id Number, Indexed, Primary Key
User ID Indicates the unique User ID related to the User whose actions are being logged in this record. user_act_user Users^{(11,11)-(0,N)}
Current URL Indicates the URL of the system page where the User is taking the logged action. user_act_curr_page
Action Value Indicates any other value or dump of values which may need to be logged alongside the URL for adequate documentation. user_act_val

log_actions
(log_)

Log Actions

Each record represents one detailed Log entry of an Administrator's database design changes, important for keeping a history for undoing mistakes.

Group: Logs

Type: Validation

7 Fields Total

4 Outgoing Keys

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
log_actions Unique ID log_id Number, Indexed, Primary Key
User ID Indicates the unique User ID related to the User whose actions are being logged in this record. log_user Users^{(11,11)-(0,N)}
Log Database ID Indicates the unique Database ID number which this Logged Action was taken on. log_database Databases^{(11,11)-(0,N)}
Log Table ID Indicates the unique Table ID number which this Logged Action was taken on. log_table Database Tables^{(11,11)-(0,N)}
Log Field ID Indicates the unique Field ID number which this Logged Action was taken on. log_field Database Fields^(0,11)-(0,N)
Type Of Action Indicates what type of Action on the Database Design is being Logged. Values: New ; Edit log_action
Old Name Indicates the old name of this Database Table or Field, to maintain a history of such important changes. log_old_name
New Name Indicates the new name of this Database Table or Field, to maintain a history of such important changes. log_new_name

zips
(zip_)

Zip Codes

Each record represents one United States zip code to map it to state and counties.

Group: Lookups

Type: Linking

7 Fields Total

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
zips Unique ID zip_id Number, Indexed, Primary Key
Zip Code Indicates the zip code (postal code) being mapped in this record. zip_zip
Latitude Indicates the Zip Code's latitude is a geographic coordinate that specifies the north–south position of a point on the Earth's surface. zip_lat
Longitude Indicates the Zip Code's longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface. zip_long
City Indicates the city where this Zip Code is located. zip_city
State Indicates the state where this Zip Code is located. zip_state
County Indicates the county where this Zip Code is located. zip_county
Country Indicates the country where this Zip Code is located. zip_country

addy_geo
(ady_geo_)

Address Geolocate

Each record represents one Address (all in one line) to map it to its latitude and longitude coordinates. This is important to reducing the number of geocoding requests sent to third parties.

Group: Lookups

Type: Data

3 Fields Total

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
addy_geo Unique ID ady_geo_id Number, Indexed, Primary Key
Full Address Indicates the full address, in one line, which is being linked with latitude and longitude coordinates. ady_geo_address
Latitude Indicates the Address's latitude is a geographic coordinate that specifies the north–south position of a point on the Earth's surface. ady_geo_lat
Longitude Indicates the Address's longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface. ady_geo_long

caches
(cach_)

Caches

Each record represents one cache of content, whether HTML, JS, or CSS.

Group: Optimization

Type: Data

7 Fields Total

1 Outgoing Key

Field Name (in English), Description, Notes, Value Options Field Name (in Database), Data Type, Key Info
caches Unique ID cach_id Number, Indexed, Primary Key
Cache Type Indicates which type of cache record this is. cach_type
Tree ID Indicates the unique Tree ID number which generated this cache. cach_tree_id Trees^(0,N)-(0,N)
Core Record ID Indicates the unique Core Record ID number which generated this cache. cach_rec_id
Cache Key String Indicates the unique key string used to locate this cached content. cach_key
Cache Content Value Indicates the actual value of the cached content. cach_value
Cache Content CSS Indicates CSS needed for the cached content. cach_css
Cache Content JS Indicates JS needed for the cached content. cach_js