How do I manage tables in FeatureBase Cloud?
This page provides an overview of FeatureBase tables and links to guide you through creating, altering and dropping tables.
A table is a database object that stores data from external sources.
FeatureBase tables are similar to those in traditional relational databases:
- tables with columns
- columns with data types and constraints.
The first column is automatically created on all tables and serves as the primary key.
Table of contents
Before you begin
Data modeling
You can duplicate your existing RDBMS data structures within FeatureBase.
But to get the best results, users should perform a Data modeling process to:
- determine the specific data they wish to query
- take advantage of FeatureBase-specific data types and constraints
- run queries on the data to test if the structure meets expectations
By performing Data Modeling, customers may reduce their raw data footprint by up to 90% and thus make queries even faster.
Perform data modeling before creating tables to avoid issues.
Table primary key
The table ID column (_id) is used as the table primary key and must uniquely represent a record in your table.
| UI Type | SQL data type | Data source table unique key |
|---|---|---|
| Number | id | Positive integer |
| String | string | String key or a combination of columns used to create a unique key |
Column data types and constraints
The table ID column (_id) is used as the table primary key and must uniquely represent a record in your table.
| UI Type | SQL data type | Data source table unique key |
|---|---|---|
| Number | id | Positive integer |
| String | string | String key or a combination of columns used to create a unique key |
Naming standard
FeatureBase identifiers (including object names such as databases, tables and columns) start with a lower-case alphabetic character and can include:
- lower-case alphabetic characters
- numbers 0-9
-
dash
-and underscore_characters. -
table names can be up to 230 characters in length
- column names can be up to 64 characters in length
Managing tables in FeatureBase Cloud
Managing tables using the Cloud API
Joining tables
Tables that exist in the same database can be joined.