scheduled_purchase

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
scheduled_purchase_id int4 10 null
scheduled_purchase_event.scheduled_purchase_id scheduled_purchase_event_scheduled_purchase_id_fkey R
ticket_sales.scheduled_purchase_id ticket_sales_scheduled_purchase_id_fkey R
scheduled_purchase_timestamp timestamptz 35,6 now()
customer_id int4 10 null
customer.customer_id scheduled_purchase_customer_id_fkey R
scheduled_purchase_encoded_id text 2147483647 √ null
scheduled_purchase_date timestamptz 35,6 null
ticket_data json 2147483647 √ null
administrator_id int4 10 √ null
administrator.administrator_id scheduled_purchase_administrator_id_fkey R
dim_organisation_id int4 10 √ null
dim_organisation.dim_organisation_id scheduled_purchase_dim_organisation_id_fkey R
dim_channel_id int4 10 √ null
dim_channel.dim_channel_id scheduled_purchase_dim_channel_id_fkey R
amount numeric 131089 null
extra_fields json 2147483647 √ null
dim_scheduled_purchase_type_id int4 10 √ null
dim_scheduled_purchase_type.dim_scheduled_purchase_type_id scheduled_purchase_dim_scheduled_purchase_type_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
scheduled_purchase_pkey Primary key Asc scheduled_purchase_id
idx_scheduled_purchase_date Performance Asc scheduled_purchase_date
idx_scheduled_purchase_type_id Performance Asc dim_scheduled_purchase_type_id

Relationships

Close relationships within degrees of separation