Customers

The customer object represents the buyer of goods and services. The customer is stored in the source and is used directly or indirectly by all business modeling activity.

Diagram

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.
durable_id	VARCHAR	An identifier for looking up or referencing this specific object. It will not change over time.
ingest_aliases	VARCHAR[]
created_at	TIMESTAMP	A timestamp for when this row was first created.
effective_at	TIMESTAMP	A timestamp that represents the beginning of the objects active period. This timestamp is inclusive.
ineffective_at	TIMESTAMP	A timestamp that represents the completion of the objects active period. This timestamp is exclusive.
name	VARCHAR	A string that respresents what this object is called.
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.