Skip to main content Link Menu Expand (external link) Document Search Copy Copied

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

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: view tables

View list in Databases
Click Databases > database name > Tables.

Step 2: create table

  1. Click Create table.
  2. Select the destination database.
  3. Enter a table name and an optional description.

Step 3: choose the 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
  1. Select the ID type.
  2. Click Create.

Next step

Further information