Appendix: VMart Example Database Schema, Tables, and Scripts
The Appendix provides detailed information about the VMart example database’s schema, tables, and scripts.
The VMart example database contains three different schemas:
public
store
online_sales
The term “schema” has several related meanings in Vertica:
- In SQL statements, a schema refers to named namespace for a logical schema.
- Logical schema refers to a set of tables and constraints.
- Physical schema refers to a set of projections.
Each schema contains tables that are created and loaded during database installation. See the schema maps for a list of tables and their contents:
The VMart database installs with sample scripts that contain SQL commands that represent queries that might be used in a real business. The sample scripts are available in the Sample Scripts section of this Appendix. Once you’re comfortable running the example queries, you might want to write your own.