How do I create a table in FeatureBase Cloud?
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
- Set up a FeatureBase Cloud account
- Learn how to create a database
- Learn how to manage tables
- Click Databases > database name > Tables to view tables.
Naming standards
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
Step 1: create table
- Click Create table.
- Select the destination database.
- Enter a table name and an optional description.
Step 2: choose the primary key
The _id column in each table represents the primary key and supports two data types:
| Data type | Description | Example | Advantage | Disadvantage |
|---|---|---|---|---|
ID data type | One or more contiguous blocks of positive integers | 7,8,9,10,11,12,...20,21,22,23,... | Faster queries | Warning: performance and storage are adversely affected if values are non-contiguous |
String data type | String literal values can be supplied in any order if used as primary key | “a23”, “s93kk”, “h82k”, “2023-02-10”,… | Automatically mapped to blocks of contiguous integers | Higher storage and performance costs |
Select Number to choose the ID data type
Step 3: Create the table
- Click Create.