Products

The product object represents the goods and services being offered by the business. The product is stored in the source and is used for pricing, packaging and provisioning.

Diagram

../_images/products_erd.svg

Table description

Column name

Data type

Description

id

BIGINT

An identifier for looking up or referencing this specific object.

org_id

INTEGER

An identifier referencing the organization related to this object.

env_id

INTEGER

An identifier referencing the environment related to this object.

branch_id

INTEGER

An identifier referencing the branch related to this object.

created_at

TIMESTAMP

A timestamp for when this row was first created.

name

VARCHAR

A string that respresents what this object is called.

ptype

VARCHAR

A string that defines the type of product ("FIXED", "EVENT", etc).

event_name

VARCHAR

A string that is matched on $.properties.name, on each event, to help filter usage.

filters

JSON

A JSON blob that contains different constraints based on event fields.

agg_property

VARCHAR

A string that is a key within $.properties. This property will be aggregated to determine usage.

archived_at

TIMESTAMP

A timestamp for when this object was archived.

version

INTEGER

An incrementing integer which denotes the most up to date object associated with an ID.