intake

-1 rows


Description

Table containing intake numbers and their respective open and closing dates

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
application.intake_id application_intake_id_fkey R
intake_users.intake_id intake_users_intake_id_fkey R

Unique ID for each intake number
open_timestamp timestamptz 35,6 null

Open date and time for an intake number
close_timestamp timestamptz 35,6 null

Close date and time for an intake number
ccbc_intake_number int4 10 null

Unique intake number for a set of CCBC IDs
application_number_seq_name varchar 1000 √ null

The name of the sequence used to generate CCBC ids. It is added via a trigger
created_by int4 10 √ null
ccbc_user.id intake_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 intake_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 intake_archived_by_fkey R

archived by user id
archived_at timestamptz 35,6 √ null

archived at timestamp
counter_id int4 10 √ null
gapless_counter.id intake_counter_id_fkey R

The counter_id used by the gapless_counter to generate a gapless intake id
description text 2147483647 √ null

A description of the intake
hidden bool 1 √ false

A column to denote whether the intake is visible to the public
hidden_code uuid 2147483647 √ null

A column that stores the code used to access the hidden intake. Only used on intakes that are hidden
rolling_intake bool 1 √ false

A column to denote whether the intake is a rolling intake

Indexes

Constraint Name Type Sort Column(s)
intake_pkey Primary key Asc id
ccbc_public_intake_archived_by_foreign_key Performance Asc archived_by
ccbc_public_intake_created_by_foreign_key Performance Asc created_by
ccbc_public_intake_updated_by_foreign_key Performance Asc updated_by
intake_application_number_seq_name_key Must be unique Asc application_number_seq_name
intake_ccbc_intake_number_key Must be unique Asc ccbc_intake_number

Relationships

Close relationships within degrees of separation