# Database

## Features <a href="#features" id="features"></a>

#### Tables <a href="#table-view" id="table-view"></a>

Tables are crucial components of a database. Tables, in the context of databases, are objects that store information in relational databases. A database consists of one or more tables, which can be designed in a relational manner. Tables are created based on columns, with each column having a designated name and data type. Data is stored in these columns based on the specified data types, and each set of data is referred to as a row.

#### Relationships <a href="#relationships" id="relationships"></a>

Designing a database model involves a process, as well as analyzing data. The understanding of these relationships may seem straightforward and not overly complicated, but it is still crucial in both the theory and practice of databases.

#### Query Editor

SQL editor assists the user in writing and executing queries in SQL. There is a result window where the execution results can be viewed. This panel allows the user to interact with tables and data using SQL syntax.

#### Additional features <a href="#additional-features" id="additional-features"></a>

* Every project is a full Postgres database, with `postgres` level access.
* Appizap manages your database backups.
* Import data directly from a CSV or excel spreadsheet.