cbc_project

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

int4

10

√

null

Unique ID for the row

json_data

jsonb

2147483647

'{}'::jsonb

The data imported from the excel for that cbc project

sharepoint_timestamp

timestamptz

35,6

√

null

The timestamp of the last time the data was updated from sharepoint

created_by

int4

10

√

null

ccbc_user.id

cbc_project_created_by_fkey

R

created by user id

created_at

timestamptz

35,6

now()

created at timestamp

updated_by

int4

10

√

null

ccbc_user.id

cbc_project_updated_by_fkey

R

updated by user id

updated_at

timestamptz

35,6

now()

updated at timestamp

archived_by

int4

10

√

null

ccbc_user.id

cbc_project_archived_by_fkey

R

archived by user id

archived_at

timestamptz

35,6

√

null

archived at timestamp

Showing 1 to 9 of 9 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
cbc_project_pkey	Primary key	Asc	id
ccbc_public_cbc_project_archived_by_foreign_key	Performance	Asc	archived_by
ccbc_public_cbc_project_created_by_foreign_key	Performance	Asc	created_by
ccbc_public_cbc_project_updated_by_foreign_key	Performance	Asc	updated_by

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation