LogoLogo
Release notesDocs homeFabricateTonic.ai
  • Tonic Fabricate User Guide
  • Fabricate workflow
  • Tutorial videos
  • Fabricate account
    • Getting started with Fabricate
    • Fabricate license plans
    • Managing your Fabricate account and profile
    • Managing users in your account
  • Databases
    • Supported database types
    • Creating and managing databases
  • Backing up and restoring the database definition
  • Configuring database variables
  • Exporting data from a database
  • Tables and columns
    • Managing database tables
      • Configuring table settings
      • Adding a table to a database
      • Removing a table from a database
      • Attaching static data to a table
      • Regenerating table data
  • Managing table columns
    • Adding and removing columns
    • Configuring a column
    • Generator reference
      • Calculated or related values
      • Unstructured Data
      • Data type and specific values
      • Names and other identifying information
      • Telephone numbers and email addresses
      • Geographic locations
      • Air travel
      • Natural science
      • Networks and files
      • Banking and finance
      • Dates and times
      • Vehicles
      • Companies and products
      • Healthcare and health insurance
      • Languages
      • Movies
      • Education
    • Fabricate custom SQLite functions
  • Views
    • Creating and managing views
    • Views reference
  • Workspaces
    • About workspaces
  • Creating and managing workspaces
  • Database mock API
    • About mock APIs
    • Defining a mock API
    • Creating and querying database snapshots
  • Mock API reference
  • Fabricate API and CLI
    • Managing Fabricate API keys
    • Daily limits on generated data
    • Using the Fabricate API
      • Authentication for the API
      • Data model
        • Database attributes
        • Entity (table) attributes
        • Constraint attributes
        • Column attributes
          • General column configuration
          • Calculated or related values
          • Unstructured Data
          • Data type and specific values
          • Names and other identifying information
          • Telephone numbers and email addresses
          • Geographic locations
          • Air travel
          • Natural science
          • Networks and files
          • Banking and finance
          • Dates and times
          • Vehicles
          • Companies and products
          • Healthcare and health insurance
          • Languages
          • Movies
          • Education
      • Managing databases from the API
      • Generating data from the API
    • Using the Fabricate CLI
      • Setting up CLI access
      • Using the CLI to load data
  • Self-hosted Fabricate
    • Fabricate architecture
    • Setting up the Fabricate components
    • Limiting login attempts
    • Starting a Fabricate instance
    • Upgrading a Fabricate instance
Powered by GitBook
On this page
Export as PDF
  1. Fabricate API and CLI
  2. Using the Fabricate API
  3. Data model

Database attributes

Each database object can contain the following attributes:

{
  "id": uuid,
  "name": "my_store",
  "created_at": datetime,
  "updated_at": datetime,
  "last_generated": datetime,
  "data_url": string,
  "platform": string,
  "variables": {
    "<variable_name>": string
  },
  "entities": entity[]
  "workspace": {
    "id": uuid,
    "name": string
  }
}

id

The UUID of the database

name

The name of the database

created_at

The date and time the database was created.

updated_at

The date and time the database was last updated.

last_generated

The date and time the data was last generated.

data_url

After data is generated, download it from this URL.

platform

The type of the target database.

variables

The default variable values assigned to the database.

entities

workspace

The workspace that the database belongs to. Determined by the workspace name in the request path. You do not provide this when you create or update a database.

Last updated 5 days ago

List of entities and their attributes. For the list of entity attributes, go to .

Entity (table) attributes