The first step in creating a web application is to create its tables. Tables can be created in the Tables area of your App or imported. Tables hold your data. Data can be submitted into them through web forms or imported from external files. Tables can also be exported.
Views are created from one or more tables. When one table is used, the View can be used to filter the data of the table and/or include a subset of its base table. For example if you have a table of all your global customers, a View can be created from that table to only display customers from a certain specific country.
When multiple tables are used to create a View not only data can be filtered and a subset of fields selected, you can also create a join between them, such as between Customers from one table and their Orders from another and show them all is a View.
Read the following articles to learn more:
- Creating and Modifying Tables
- Data Types
- Lookup Tables
- Managing Data
- Importing Data
- Exporting Data
- Database Relationships
- Scheduled Import and Export (DataHub)
- Table and Database Design Best Practices