deal_rooms


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
action_items.room_id action_items_room_id_fkey R
bookings.room_id bookings_room_id_fkey R
card_comments.room_id card_comments_room_id_fkey R
concerns.room_id concerns_room_id_fkey R
deal_documents.room_id deal_documents_room_id_fkey R
deal_downloads.room_id deal_downloads_room_id_fkey R
deal_events.room_id deal_events_room_id_fkey R
deal_payments.room_id deal_payments_room_id_fkey R
deal_refunds.room_id deal_refunds_room_id_fkey R
finding_adjudications.room_id finding_adjudications_room_id_fkey C
meeting_notes.room_id meeting_notes_room_id_fkey R
resources.room_id resources_room_id_fkey R
room_documents.room_id room_documents_room_id_fkey C
wp_credentials.room_id wp_credentials_room_id_fkey R
domain text 2147483647 √ null
title text 2147483647 null
client_name text 2147483647 null
client_email text 2147483647 √ null
seller_name text 2147483647 ''::text
status text 2147483647 'draft'::text
welcome_message text 2147483647 √ null
visit_count int4 10 0
last_visited_at timestamptz 35,6 √ null
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()
slug text 2147483647 null
cms_type text 2147483647 √ null
cms_profile jsonb 2147483647 √ null
price_cents int4 10 0
stripe_price_id text 2147483647 √ null
customer_id text 2147483647 √ null
deal_customers.id deal_rooms_customer_id_fkey R
access_code text 2147483647 √ null
biz_profile_id int4 10 √ null
canvas_annotations.id Implied Constraint R
executive_summary jsonb 2147483647 √ null
bizhub_business_id int8 19 √ null
template text 2147483647 √ null
template_slots jsonb 2147483647 √ null
created_by text 2147483647 √ null
deleted_at timestamptz 35,6 √ null
droom_obj_key text 2147483647 √ null
first_name text 2147483647 √ null
audit_url text 2147483647 √ null
deliverables _text 2147483647 '{audit}'::text[]
is_demo bool 1 false
list_price_cents int4 10 49900
last_name text 2147483647 √ null
business_name text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
deal_rooms_pkey Primary key Asc id
idx_rooms_bizhub_biz Performance Asc bizhub_business_id
idx_rooms_customer Performance Asc customer_id
idx_rooms_domain Performance Asc domain
idx_rooms_slug Must be unique Asc slug

Relationships

Close relationships within degrees of separation