*This feature is still in Beta and will be available for all Pipefy users soon.

All the information that we store inside Pipes and Databases are available inside a set of tables and columns, here we will describe each one of them and how they relate with each other.

Tables and Columns

cards

Main attributes of pipe cards and database records, to get all information on cards, it's necessary to read from card_assignees, card_labels, card_phase_history and values.

Column

Type

Description

attachment_count

bigint

comment_count

bigint

created_at

timestamp without time zone

current_phase_uuid

character varying

default_to_email

character varying

deleted_at

timestamp without time zone

due_date

timestamp without time zone

email_inbox_address

character varying

finished_at

timestamp without time zone

id

bigint

index

character varying

public_form_submitter_email

character varying

repository_uuid

character varying

started_at

timestamp without time zone

subtitle

character varying

title

character varying

updated_at

timestamp without time zone

card_assignees

Stores each assignee of cards, use the cards and users tables to get more information about the assignees.

Column

Type

Description

card_uuid

character varying

created_at

timestamp without time zone

deleted_at

timestamp without time zone

updated_at

timestamp without time zone

user_uuid

character varying

card_labels

Stores each label added to cards and records, use the cards and labels tables to get more information about the assignment of the label.

Stores each assignee of cards, use the cards and users tables to get more information about the assignees.

Column

Type

Description

card_uuid

character varying

created_at

timestamp without time zone

deleted_at

timestamp without time zone

updated_at

timestamp without time zone

label_uuid

character varying

card_phase_history

Stores each movement of a card through the phases, it stores when the card entered and left each phase and multiple records for the same phase when the card passed multiple times through the same phase.

fields

Custom fields of Pipes and Databases, can be used to filter the values by the field identifier.

labels

Labels of Pipes and Databases main attributes.

Column

Type

Description

color

character varying

created_at

timestamp without time zone

deleted_at

timestamp without time zone

name

character varying

updated_at

timestamp without time zone

uuid

character varying

phases

Phases of Pipes and Databases, Databases always include a set of 2 phases

repositories

Main attributes of Pipes and Databases which we refer to as a repository

users

Users inside the company, it can be used to filter by card assignees when used with card_assignees

Column

Type

Description

created_at

timestamp without time zone

deleted_at

timestamp without time zone

email

character varying

name

character varying

updated_at

timestamp without time zone

uuid

character varying

values

It stores the value of custom fields for each card or record. Relation with card and fields.

Column

Type

Description

card_uuid

character varying

created_at

timestamp without time zone

deleted_at

timestamp without time zone

field_uuid

character varying

updated_at

timestamp without time zone

uuid

character varying

value

character varying

Did this answer your question?