web

---

web / lib/database.types / Database

Type Alias: Database

Database = object

Defined in: lib/database.types.ts:3

Properties

__InternalSupabase

__InternalSupabase: object

Defined in: lib/database.types.ts:6

PostgrestVersion

PostgrestVersion: "13.0.5"

---

public

public: object

Defined in: lib/database.types.ts:9

CompositeTypes

CompositeTypes: { [_ in never]: never }

Enums

Enums: { [_ in never]: never }

Functions

Functions: object

Functions.get_listings_with_saved_status

get_listings_with_saved_status: object

Functions.get_listings_with_saved_status.Args

Args: object

Functions.get_listings_with_saved_status.Args.auth_user

auth_user: string

Functions.get_listings_with_saved_status.Returns

Returns: object[]

Functions.get_listings_with_saved_status.SetofOptions

SetofOptions: object

Functions.get_listings_with_saved_status.SetofOptions.from

from: "*"

Functions.get_listings_with_saved_status.SetofOptions.isOneToOne

isOneToOne: false

Functions.get_listings_with_saved_status.SetofOptions.isSetofReturn

isSetofReturn: true

Functions.get_listings_with_saved_status.SetofOptions.to

to: "listings_with_address"

Tables

Tables: object

Tables.addresses

addresses: object

Tables.addresses.Insert

Insert: object

Tables.addresses.Insert.address_line?

optional address_line: string | null

Tables.addresses.Insert.city?

optional city: string | null

Tables.addresses.Insert.country?

optional country: string | null

Tables.addresses.Insert.id?

optional id: number

Tables.addresses.Insert.latitude?

optional latitude: number | null

Tables.addresses.Insert.longitude?

optional longitude: number | null

Tables.addresses.Insert.postal_code?

optional postal_code: string | null

Tables.addresses.Insert.state?

optional state: string | null

Tables.addresses.Relationships

Relationships: []

Tables.addresses.Row

Row: object

Tables.addresses.Row.address_line

address_line: string | null

Tables.addresses.Row.city

city: string | null

Tables.addresses.Row.country

country: string | null

Tables.addresses.Row.id

id: number

Tables.addresses.Row.latitude

latitude: number | null

Tables.addresses.Row.longitude

longitude: number | null

Tables.addresses.Row.postal_code

postal_code: string | null

Tables.addresses.Row.state

state: string | null

Tables.addresses.Update

Update: object

Tables.addresses.Update.address_line?

optional address_line: string | null

Tables.addresses.Update.city?

optional city: string | null

Tables.addresses.Update.country?

optional country: string | null

Tables.addresses.Update.id?

optional id: number

Tables.addresses.Update.latitude?

optional latitude: number | null

Tables.addresses.Update.longitude?

optional longitude: number | null

Tables.addresses.Update.postal_code?

optional postal_code: string | null

Tables.addresses.Update.state?

optional state: string | null

Tables.businesses

businesses: object

Tables.businesses.Insert

Insert: object

Tables.businesses.Insert.address_id?

optional address_id: number | null

Tables.businesses.Insert.business_hours?

optional business_hours: string | null

Tables.businesses.Insert.confidential_sale?

optional confidential_sale: boolean | null

Tables.businesses.Insert.customer_type?

optional customer_type: string | null

Tables.businesses.Insert.description?

optional description: string | null

Tables.businesses.Insert.ebitda?

optional ebitda: number | null

Tables.businesses.Insert.gross_margin?

optional gross_margin: number | null

Tables.businesses.Insert.gross_per_year?

optional gross_per_year: number | null

Tables.businesses.Insert.id?

optional id: number

Tables.businesses.Insert.lease_status?

optional lease_status: string | null

Tables.businesses.Insert.lease_term_remaining?

optional lease_term_remaining: string | null

Tables.businesses.Insert.market?

optional market: string | null

Tables.businesses.Insert.monthly_recurring_revenue?

optional monthly_recurring_revenue: number | null

Tables.businesses.Insert.name?

optional name: string | null

Tables.businesses.Insert.number_of_employees?

optional number_of_employees: number | null

Tables.businesses.Insert.ownership_type?

optional ownership_type: string | null

Tables.businesses.Insert.physical_location?

optional physical_location: string | null

Tables.businesses.Insert.profit_per_year?

optional profit_per_year: number | null

Tables.businesses.Insert.reason_for_sale?

optional reason_for_sale: string | null

Tables.businesses.Insert.revenue_per_year?

optional revenue_per_year: number | null

Tables.businesses.Insert.type_of_sale?

optional type_of_sale: string | null

Tables.businesses.Insert.website?

optional website: string | null

Tables.businesses.Insert.will_stay_post_sale?

optional will_stay_post_sale: boolean | null

Tables.businesses.Insert.years_in_business?

optional years_in_business: number | null

Tables.businesses.Relationships

Relationships: [{ columns: ["address_id"]; foreignKeyName: "businesses_address_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "addresses"; }, { columns: ["address_id"]; foreignKeyName: "businesses_address_id_fkey"; isOneToOne: false; referencedColumns: ["address_id"]; referencedRelation: "listings_with_address"; }]

Tables.businesses.Row

Row: object

Tables.businesses.Row.address_id

address_id: number | null

Tables.businesses.Row.business_hours

business_hours: string | null

Tables.businesses.Row.confidential_sale

confidential_sale: boolean | null

Tables.businesses.Row.customer_type

customer_type: string | null

Tables.businesses.Row.description

description: string | null

Tables.businesses.Row.ebitda

ebitda: number | null

Tables.businesses.Row.gross_margin

gross_margin: number | null

Tables.businesses.Row.gross_per_year

gross_per_year: number | null

Tables.businesses.Row.id

id: number

Tables.businesses.Row.lease_status

lease_status: string | null

Tables.businesses.Row.lease_term_remaining

lease_term_remaining: string | null

Tables.businesses.Row.market

market: string | null

Tables.businesses.Row.monthly_recurring_revenue

monthly_recurring_revenue: number | null

Tables.businesses.Row.name

name: string | null

Tables.businesses.Row.number_of_employees

number_of_employees: number | null

Tables.businesses.Row.ownership_type

ownership_type: string | null

Tables.businesses.Row.physical_location

physical_location: string | null

Tables.businesses.Row.profit_per_year

profit_per_year: number | null

Tables.businesses.Row.reason_for_sale

reason_for_sale: string | null

Tables.businesses.Row.revenue_per_year

revenue_per_year: number | null

Tables.businesses.Row.type_of_sale

type_of_sale: string | null

Tables.businesses.Row.website

website: string | null

Tables.businesses.Row.will_stay_post_sale

will_stay_post_sale: boolean | null

Tables.businesses.Row.years_in_business

years_in_business: number | null

Tables.businesses.Update

Update: object

Tables.businesses.Update.address_id?

optional address_id: number | null

Tables.businesses.Update.business_hours?

optional business_hours: string | null

Tables.businesses.Update.confidential_sale?

optional confidential_sale: boolean | null

Tables.businesses.Update.customer_type?

optional customer_type: string | null

Tables.businesses.Update.description?

optional description: string | null

Tables.businesses.Update.ebitda?

optional ebitda: number | null

Tables.businesses.Update.gross_margin?

optional gross_margin: number | null

Tables.businesses.Update.gross_per_year?

optional gross_per_year: number | null

Tables.businesses.Update.id?

optional id: number

Tables.businesses.Update.lease_status?

optional lease_status: string | null

Tables.businesses.Update.lease_term_remaining?

optional lease_term_remaining: string | null

Tables.businesses.Update.market?

optional market: string | null

Tables.businesses.Update.monthly_recurring_revenue?

optional monthly_recurring_revenue: number | null

Tables.businesses.Update.name?

optional name: string | null

Tables.businesses.Update.number_of_employees?

optional number_of_employees: number | null

Tables.businesses.Update.ownership_type?

optional ownership_type: string | null

Tables.businesses.Update.physical_location?

optional physical_location: string | null

Tables.businesses.Update.profit_per_year?

optional profit_per_year: number | null

Tables.businesses.Update.reason_for_sale?

optional reason_for_sale: string | null

Tables.businesses.Update.revenue_per_year?

optional revenue_per_year: number | null

Tables.businesses.Update.type_of_sale?

optional type_of_sale: string | null

Tables.businesses.Update.website?

optional website: string | null

Tables.businesses.Update.will_stay_post_sale?

optional will_stay_post_sale: boolean | null

Tables.businesses.Update.years_in_business?

optional years_in_business: number | null

Tables.buyers

buyers: object

Tables.buyers.Insert

Insert: object

Tables.buyers.Insert.buyer_type?

optional buyer_type: string | null

Tables.buyers.Insert.created_at?

optional created_at: string

Tables.buyers.Insert.id?

optional id: number

Tables.buyers.Insert.interested_locations?

optional interested_locations: string[] | null

Tables.buyers.Insert.interested_markets?

optional interested_markets: string[] | null

Tables.buyers.Insert.investment_range?

optional investment_range: number[] | null

Tables.buyers.Insert.ownership?

optional ownership: string | null

Tables.buyers.Insert.reason_for_buying?

optional reason_for_buying: string | null

Tables.buyers.Insert.revenue_range?

optional revenue_range: number[] | null

Tables.buyers.Insert.risk_tolerance?

optional risk_tolerance: string | null

Tables.buyers.Insert.timeline?

optional timeline: string | null

Tables.buyers.Insert.user_id?

optional user_id: number | null

Tables.buyers.Relationships

Relationships: [{ columns: ["user_id"]; foreignKeyName: "buyers_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }]

Tables.buyers.Row

Row: object

Tables.buyers.Row.buyer_type

buyer_type: string | null

Tables.buyers.Row.created_at

created_at: string

Tables.buyers.Row.id

id: number

Tables.buyers.Row.interested_locations

interested_locations: string[] | null

Tables.buyers.Row.interested_markets

interested_markets: string[] | null

Tables.buyers.Row.investment_range

investment_range: number[] | null

Tables.buyers.Row.ownership

ownership: string | null

Tables.buyers.Row.reason_for_buying

reason_for_buying: string | null

Tables.buyers.Row.revenue_range

revenue_range: number[] | null

Tables.buyers.Row.risk_tolerance

risk_tolerance: string | null

Tables.buyers.Row.timeline

timeline: string | null

Tables.buyers.Row.user_id

user_id: number | null

Tables.buyers.Update

Update: object

Tables.buyers.Update.buyer_type?

optional buyer_type: string | null

Tables.buyers.Update.created_at?

optional created_at: string

Tables.buyers.Update.id?

optional id: number

Tables.buyers.Update.interested_locations?

optional interested_locations: string[] | null

Tables.buyers.Update.interested_markets?

optional interested_markets: string[] | null

Tables.buyers.Update.investment_range?

optional investment_range: number[] | null

Tables.buyers.Update.ownership?

optional ownership: string | null

Tables.buyers.Update.reason_for_buying?

optional reason_for_buying: string | null

Tables.buyers.Update.revenue_range?

optional revenue_range: number[] | null

Tables.buyers.Update.risk_tolerance?

optional risk_tolerance: string | null

Tables.buyers.Update.timeline?

optional timeline: string | null

Tables.buyers.Update.user_id?

optional user_id: number | null

Tables.documents

documents: object

Tables.documents.Insert

Insert: object

Tables.documents.Insert.business_id?

optional business_id: number | null

Tables.documents.Insert.document_name?

optional document_name: string | null

Tables.documents.Insert.document_type?

optional document_type: string | null

Tables.documents.Insert.file_path?

optional file_path: string | null

Tables.documents.Insert.id?

optional id: number

Tables.documents.Insert.uploaded_at?

optional uploaded_at: string | null

Tables.documents.Relationships

Relationships: [{ columns: ["business_id"]; foreignKeyName: "documents_business_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "businesses"; }, { columns: ["business_id"]; foreignKeyName: "documents_business_id_fkey"; isOneToOne: false; referencedColumns: ["business_id"]; referencedRelation: "listings_with_address"; }]

Tables.documents.Row

Row: object

Tables.documents.Row.business_id

business_id: number | null

Tables.documents.Row.document_name

document_name: string | null

Tables.documents.Row.document_type

document_type: string | null

Tables.documents.Row.file_path

file_path: string | null

Tables.documents.Row.id

id: number

Tables.documents.Row.uploaded_at

uploaded_at: string | null

Tables.documents.Update

Update: object

Tables.documents.Update.business_id?

optional business_id: number | null

Tables.documents.Update.document_name?

optional document_name: string | null

Tables.documents.Update.document_type?

optional document_type: string | null

Tables.documents.Update.file_path?

optional file_path: string | null

Tables.documents.Update.id?

optional id: number

Tables.documents.Update.uploaded_at?

optional uploaded_at: string | null

Tables.listing_images

listing_images: object

Tables.listing_images.Insert

Insert: object

Tables.listing_images.Insert.id?

optional id: number

Tables.listing_images.Insert.image_path?

optional image_path: string | null

Tables.listing_images.Insert.listing_id?

optional listing_id: number | null

Tables.listing_images.Relationships

Relationships: [{ columns: ["listing_id"]; foreignKeyName: "listing_images_listing_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "listings"; }, { columns: ["listing_id"]; foreignKeyName: "listing_images_listing_id_fkey"; isOneToOne: false; referencedColumns: ["listing_id"]; referencedRelation: "listings_with_address"; }]

Tables.listing_images.Row

Row: object

Tables.listing_images.Row.id

id: number

Tables.listing_images.Row.image_path

image_path: string | null

Tables.listing_images.Row.listing_id

listing_id: number | null

Tables.listing_images.Update

Update: object

Tables.listing_images.Update.id?

optional id: number

Tables.listing_images.Update.image_path?

optional image_path: string | null

Tables.listing_images.Update.listing_id?

optional listing_id: number | null

Tables.listings

listings: object

Tables.listings.Insert

Insert: object

Tables.listings.Insert.asking_price?

optional asking_price: number | null

Tables.listings.Insert.business_id?

optional business_id: number | null

Tables.listings.Insert.contact_company?

optional contact_company: string | null

Tables.listings.Insert.contact_email?

optional contact_email: string | null

Tables.listings.Insert.contact_method?

optional contact_method: string | null

Tables.listings.Insert.contact_name?

optional contact_name: string | null

Tables.listings.Insert.contact_phone?

optional contact_phone: string | null

Tables.listings.Insert.contact_role?

optional contact_role: string | null

Tables.listings.Insert.date_established?

optional date_established: string | null

Tables.listings.Insert.id?

optional id: number

Tables.listings.Insert.is_public?

optional is_public: boolean | null

Tables.listings.Insert.listed_at?

optional listed_at: string | null

Tables.listings.Insert.preferred_contact?

optional preferred_contact: string | null

Tables.listings.Insert.status?

optional status: string | null

Tables.listings.Insert.user_id?

optional user_id: number | null

Tables.listings.Insert.valuation_multiple?

optional valuation_multiple: number | null

Tables.listings.Insert.views?

optional views: number | null

Tables.listings.Relationships

Relationships: [{ columns: ["business_id"]; foreignKeyName: "listings_business_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "businesses"; }, { columns: ["business_id"]; foreignKeyName: "listings_business_id_fkey"; isOneToOne: false; referencedColumns: ["business_id"]; referencedRelation: "listings_with_address"; }, { columns: ["user_id"]; foreignKeyName: "listings_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }]

Tables.listings.Row

Row: object

Tables.listings.Row.asking_price

asking_price: number | null

Tables.listings.Row.business_id

business_id: number | null

Tables.listings.Row.contact_company

contact_company: string | null

Tables.listings.Row.contact_email

contact_email: string | null

Tables.listings.Row.contact_method

contact_method: string | null

Tables.listings.Row.contact_name

contact_name: string | null

Tables.listings.Row.contact_phone

contact_phone: string | null

Tables.listings.Row.contact_role

contact_role: string | null

Tables.listings.Row.date_established

date_established: string | null

Tables.listings.Row.id

id: number

Tables.listings.Row.is_public

is_public: boolean | null

Tables.listings.Row.listed_at

listed_at: string | null

Tables.listings.Row.preferred_contact

preferred_contact: string | null

Tables.listings.Row.status

status: string | null

Tables.listings.Row.user_id

user_id: number | null

Tables.listings.Row.valuation_multiple

valuation_multiple: number | null

Tables.listings.Row.views

views: number | null

Tables.listings.Update

Update: object

Tables.listings.Update.asking_price?

optional asking_price: number | null

Tables.listings.Update.business_id?

optional business_id: number | null

Tables.listings.Update.contact_company?

optional contact_company: string | null

Tables.listings.Update.contact_email?

optional contact_email: string | null

Tables.listings.Update.contact_method?

optional contact_method: string | null

Tables.listings.Update.contact_name?

optional contact_name: string | null

Tables.listings.Update.contact_phone?

optional contact_phone: string | null

Tables.listings.Update.contact_role?

optional contact_role: string | null

Tables.listings.Update.date_established?

optional date_established: string | null

Tables.listings.Update.id?

optional id: number

Tables.listings.Update.is_public?

optional is_public: boolean | null

Tables.listings.Update.listed_at?

optional listed_at: string | null

Tables.listings.Update.preferred_contact?

optional preferred_contact: string | null

Tables.listings.Update.status?

optional status: string | null

Tables.listings.Update.user_id?

optional user_id: number | null

Tables.listings.Update.valuation_multiple?

optional valuation_multiple: number | null

Tables.listings.Update.views?

optional views: number | null

Tables.organization_codes

organization_codes: object

Tables.organization_codes.Insert

Insert: object

Tables.organization_codes.Insert.code?

optional code: string | null

Tables.organization_codes.Insert.created_at?

optional created_at: string

Tables.organization_codes.Insert.expires_at?

optional expires_at: string

Tables.organization_codes.Insert.id?

optional id: number

Tables.organization_codes.Insert.invited_email?

optional invited_email: string | null

Tables.organization_codes.Insert.inviter_user_id?

optional inviter_user_id: number | null

Tables.organization_codes.Insert.org_id?

optional org_id: number | null

Tables.organization_codes.Relationships

Relationships: [{ columns: ["inviter_user_id"]; foreignKeyName: "organization_codes_inviter_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }, { columns: ["org_id"]; foreignKeyName: "organization_codes_org_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "organizations"; }]

Tables.organization_codes.Row

Row: object

Tables.organization_codes.Row.code

code: string | null

Tables.organization_codes.Row.created_at

created_at: string

Tables.organization_codes.Row.expires_at

expires_at: string

Tables.organization_codes.Row.id

id: number

Tables.organization_codes.Row.invited_email

invited_email: string | null

Tables.organization_codes.Row.inviter_user_id

inviter_user_id: number | null

Tables.organization_codes.Row.org_id

org_id: number | null

Tables.organization_codes.Update

Update: object

Tables.organization_codes.Update.code?

optional code: string | null

Tables.organization_codes.Update.created_at?

optional created_at: string

Tables.organization_codes.Update.expires_at?

optional expires_at: string

Tables.organization_codes.Update.id?

optional id: number

Tables.organization_codes.Update.invited_email?

optional invited_email: string | null

Tables.organization_codes.Update.inviter_user_id?

optional inviter_user_id: number | null

Tables.organization_codes.Update.org_id?

optional org_id: number | null

Tables.organization_members

organization_members: object

Tables.organization_members.Insert

Insert: object

Tables.organization_members.Insert.can_invite?

optional can_invite: boolean | null

Tables.organization_members.Insert.created_at?

optional created_at: string

Tables.organization_members.Insert.id?

optional id: number

Tables.organization_members.Insert.joined_at?

optional joined_at: string | null

Tables.organization_members.Insert.org_id?

optional org_id: number | null

Tables.organization_members.Insert.role?

optional role: string | null

Tables.organization_members.Insert.user_id?

optional user_id: number | null

Tables.organization_members.Relationships

Relationships: [{ columns: ["org_id"]; foreignKeyName: "organization_members_org_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "organizations"; }, { columns: ["user_id"]; foreignKeyName: "organization_members_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }]

Tables.organization_members.Row

Row: object

Tables.organization_members.Row.can_invite

can_invite: boolean | null

Tables.organization_members.Row.created_at

created_at: string

Tables.organization_members.Row.id

id: number

Tables.organization_members.Row.joined_at

joined_at: string | null

Tables.organization_members.Row.org_id

org_id: number | null

Tables.organization_members.Row.role

role: string | null

Tables.organization_members.Row.user_id

user_id: number | null

Tables.organization_members.Update

Update: object

Tables.organization_members.Update.can_invite?

optional can_invite: boolean | null

Tables.organization_members.Update.created_at?

optional created_at: string

Tables.organization_members.Update.id?

optional id: number

Tables.organization_members.Update.joined_at?

optional joined_at: string | null

Tables.organization_members.Update.org_id?

optional org_id: number | null

Tables.organization_members.Update.role?

optional role: string | null

Tables.organization_members.Update.user_id?

optional user_id: number | null

Tables.organizations

organizations: object

Tables.organizations.Insert

Insert: object

Tables.organizations.Insert.average_deal_size?

optional average_deal_size: number[] | null

Tables.organizations.Insert.contact_email?

optional contact_email: string | null

Tables.organizations.Insert.created_at?

optional created_at: string

Tables.organizations.Insert.description?

optional description: string | null

Tables.organizations.Insert.geographic_areas?

optional geographic_areas: string[] | null

Tables.organizations.Insert.id?

optional id: number

Tables.organizations.Insert.industries?

optional industries: string[] | null

Tables.organizations.Insert.licenses_certs?

optional licenses_certs: string[] | null

Tables.organizations.Insert.master_user_id?

optional master_user_id: number | null

Tables.organizations.Insert.naics_code?

optional naics_code: string | null

Tables.organizations.Insert.name?

optional name: string | null

Tables.organizations.Insert.phone_number?

optional phone_number: number | null

Tables.organizations.Insert.seats?

optional seats: number | null

Tables.organizations.Insert.url?

optional url: string | null

Tables.organizations.Insert.years_of_experience?

optional years_of_experience: number | null

Tables.organizations.Relationships

Relationships: [{ columns: ["master_user_id"]; foreignKeyName: "organizations_master_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }]

Tables.organizations.Row

Row: object

Tables.organizations.Row.average_deal_size

average_deal_size: number[] | null

Tables.organizations.Row.contact_email

contact_email: string | null

Tables.organizations.Row.created_at

created_at: string

Tables.organizations.Row.description

description: string | null

Tables.organizations.Row.geographic_areas

geographic_areas: string[] | null

Tables.organizations.Row.id

id: number

Tables.organizations.Row.industries

industries: string[] | null

Tables.organizations.Row.licenses_certs

licenses_certs: string[] | null

Tables.organizations.Row.master_user_id

master_user_id: number | null

Tables.organizations.Row.naics_code

naics_code: string | null

Tables.organizations.Row.name

name: string | null

Tables.organizations.Row.phone_number

phone_number: number | null

Tables.organizations.Row.seats

seats: number | null

Tables.organizations.Row.url

url: string | null

Tables.organizations.Row.years_of_experience

years_of_experience: number | null

Tables.organizations.Update

Update: object

Tables.organizations.Update.average_deal_size?

optional average_deal_size: number[] | null

Tables.organizations.Update.contact_email?

optional contact_email: string | null

Tables.organizations.Update.created_at?

optional created_at: string

Tables.organizations.Update.description?

optional description: string | null

Tables.organizations.Update.geographic_areas?

optional geographic_areas: string[] | null

Tables.organizations.Update.id?

optional id: number

Tables.organizations.Update.industries?

optional industries: string[] | null

Tables.organizations.Update.licenses_certs?

optional licenses_certs: string[] | null

Tables.organizations.Update.master_user_id?

optional master_user_id: number | null

Tables.organizations.Update.naics_code?

optional naics_code: string | null

Tables.organizations.Update.name?

optional name: string | null

Tables.organizations.Update.phone_number?

optional phone_number: number | null

Tables.organizations.Update.seats?

optional seats: number | null

Tables.organizations.Update.url?

optional url: string | null

Tables.organizations.Update.years_of_experience?

optional years_of_experience: number | null

Tables.product_purchases

product_purchases: object

Tables.product_purchases.Insert

Insert: object

Tables.product_purchases.Insert.amount_paid?

optional amount_paid: number | null

Tables.product_purchases.Insert.currency?

optional currency: string | null

Tables.product_purchases.Insert.id?

optional id: number

Tables.product_purchases.Insert.payment_status?

optional payment_status: string | null

Tables.product_purchases.Insert.product_id?

optional product_id: number | null

Tables.product_purchases.Insert.purchased_at?

optional purchased_at: string | null

Tables.product_purchases.Insert.stripe_session_id?

optional stripe_session_id: string | null

Tables.product_purchases.Insert.user_id?

optional user_id: number | null

Tables.product_purchases.Relationships

Relationships: [{ columns: ["product_id"]; foreignKeyName: "product_purchases_product_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "products"; }, { columns: ["user_id"]; foreignKeyName: "product_purchases_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }]

Tables.product_purchases.Row

Row: object

Tables.product_purchases.Row.amount_paid

amount_paid: number | null

Tables.product_purchases.Row.currency

currency: string | null

Tables.product_purchases.Row.id

id: number

Tables.product_purchases.Row.payment_status

payment_status: string | null

Tables.product_purchases.Row.product_id

product_id: number | null

Tables.product_purchases.Row.purchased_at

purchased_at: string | null

Tables.product_purchases.Row.stripe_session_id

stripe_session_id: string | null

Tables.product_purchases.Row.user_id

user_id: number | null

Tables.product_purchases.Update

Update: object

Tables.product_purchases.Update.amount_paid?

optional amount_paid: number | null

Tables.product_purchases.Update.currency?

optional currency: string | null

Tables.product_purchases.Update.id?

optional id: number

Tables.product_purchases.Update.payment_status?

optional payment_status: string | null

Tables.product_purchases.Update.product_id?

optional product_id: number | null

Tables.product_purchases.Update.purchased_at?

optional purchased_at: string | null

Tables.product_purchases.Update.stripe_session_id?

optional stripe_session_id: string | null

Tables.product_purchases.Update.user_id?

optional user_id: number | null

Tables.products

products: object

Tables.products.Insert

Insert: object

Tables.products.Insert.category

category: string

Tables.products.Insert.created_at?

optional created_at: string | null

Tables.products.Insert.description?

optional description: string | null

Tables.products.Insert.id?

optional id: number

Tables.products.Insert.locked?

optional locked: boolean | null

Tables.products.Insert.name

name: string

Tables.products.Insert.popular?

optional popular: boolean | null

Tables.products.Insert.preview_available?

optional preview_available: boolean | null

Tables.products.Insert.price

price: number

Tables.products.Insert.stripe_price_id?

optional stripe_price_id: string | null

Tables.products.Insert.tags?

optional tags: string | null

Tables.products.Insert.updated_at?

optional updated_at: string | null

Tables.products.Relationships

Relationships: []

Tables.products.Row

Row: object

Tables.products.Row.category

category: string

Tables.products.Row.created_at

created_at: string | null

Tables.products.Row.description

description: string | null

Tables.products.Row.id

id: number

Tables.products.Row.locked

locked: boolean | null

Tables.products.Row.name

name: string

Tables.products.Row.popular

popular: boolean | null

Tables.products.Row.preview_available

preview_available: boolean | null

Tables.products.Row.price

price: number

Tables.products.Row.stripe_price_id

stripe_price_id: string | null

Tables.products.Row.tags

tags: string | null

Tables.products.Row.updated_at

updated_at: string | null

Tables.products.Update

Update: object

Tables.products.Update.category?

optional category: string

Tables.products.Update.created_at?

optional created_at: string | null

Tables.products.Update.description?

optional description: string | null

Tables.products.Update.id?

optional id: number

Tables.products.Update.locked?

optional locked: boolean | null

Tables.products.Update.name?

optional name: string

Tables.products.Update.popular?

optional popular: boolean | null

Tables.products.Update.preview_available?

optional preview_available: boolean | null

Tables.products.Update.price?

optional price: number

Tables.products.Update.stripe_price_id?

optional stripe_price_id: string | null

Tables.products.Update.tags?

optional tags: string | null

Tables.products.Update.updated_at?

optional updated_at: string | null

Tables.saved

saved: object

Tables.saved.Insert

Insert: object

Tables.saved.Insert.id?

optional id: number

Tables.saved.Insert.listing_id?

optional listing_id: number | null

Tables.saved.Insert.user_id?

optional user_id: number | null

Tables.saved.Relationships

Relationships: [{ columns: ["listing_id"]; foreignKeyName: "favorites_listing_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "listings"; }, { columns: ["listing_id"]; foreignKeyName: "favorites_listing_id_fkey"; isOneToOne: false; referencedColumns: ["listing_id"]; referencedRelation: "listings_with_address"; }, { columns: ["user_id"]; foreignKeyName: "favorites_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }]

Tables.saved.Row

Row: object

Tables.saved.Row.id

id: number

Tables.saved.Row.listing_id

listing_id: number | null

Tables.saved.Row.user_id

user_id: number | null

Tables.saved.Update

Update: object

Tables.saved.Update.id?

optional id: number

Tables.saved.Update.listing_id?

optional listing_id: number | null

Tables.saved.Update.user_id?

optional user_id: number | null

Tables.sellers

sellers: object

Tables.sellers.Insert

Insert: object

Tables.sellers.Insert.business_count?

optional business_count: number | null

Tables.sellers.Insert.business_role?

optional business_role: string | null

Tables.sellers.Insert.created_at?

optional created_at: string

Tables.sellers.Insert.has_sold_before?

optional has_sold_before: boolean | null

Tables.sellers.Insert.id?

optional id: number

Tables.sellers.Insert.user_id?

optional user_id: number | null

Tables.sellers.Insert.years_owned?

optional years_owned: number | null

Tables.sellers.Relationships

Relationships: [{ columns: ["user_id"]; foreignKeyName: "sellers_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }]

Tables.sellers.Row

Row: object

Tables.sellers.Row.business_count

business_count: number | null

Tables.sellers.Row.business_role

business_role: string | null

Tables.sellers.Row.created_at

created_at: string

Tables.sellers.Row.has_sold_before

has_sold_before: boolean | null

Tables.sellers.Row.id

id: number

Tables.sellers.Row.user_id

user_id: number | null

Tables.sellers.Row.years_owned

years_owned: number | null

Tables.sellers.Update

Update: object

Tables.sellers.Update.business_count?

optional business_count: number | null

Tables.sellers.Update.business_role?

optional business_role: string | null

Tables.sellers.Update.created_at?

optional created_at: string

Tables.sellers.Update.has_sold_before?

optional has_sold_before: boolean | null

Tables.sellers.Update.id?

optional id: number

Tables.sellers.Update.user_id?

optional user_id: number | null

Tables.sellers.Update.years_owned?

optional years_owned: number | null

Tables.subscription_plans

subscription_plans: object

Tables.subscription_plans.Insert

Insert: object

Tables.subscription_plans.Insert.active?

optional active: boolean | null

Tables.subscription_plans.Insert.created_at?

optional created_at: string

Tables.subscription_plans.Insert.description?

optional description: string | null

Tables.subscription_plans.Insert.displayed_features?

optional displayed_features: Json | null

Tables.subscription_plans.Insert.features?

optional features: Json | null

Tables.subscription_plans.Insert.id

id: string

Tables.subscription_plans.Insert.most_popular?

optional most_popular: boolean | null

Tables.subscription_plans.Insert.name?

optional name: string | null

Tables.subscription_plans.Insert.price?

optional price: number | null

Tables.subscription_plans.Insert.stripe_price_id

stripe_price_id: string

Tables.subscription_plans.Insert.tier?

optional tier: number | null

Tables.subscription_plans.Insert.updated_at?

optional updated_at: string | null

Tables.subscription_plans.Relationships

Relationships: []

Tables.subscription_plans.Row

Row: object

Tables.subscription_plans.Row.active

active: boolean | null

Tables.subscription_plans.Row.created_at

created_at: string

Tables.subscription_plans.Row.description

description: string | null

Tables.subscription_plans.Row.displayed_features

displayed_features: Json | null

Tables.subscription_plans.Row.features

features: Json | null

Tables.subscription_plans.Row.id

id: string

Tables.subscription_plans.Row.most_popular

most_popular: boolean | null

Tables.subscription_plans.Row.name

name: string | null

Tables.subscription_plans.Row.price

price: number | null

Tables.subscription_plans.Row.stripe_price_id

stripe_price_id: string

Tables.subscription_plans.Row.tier

tier: number | null

Tables.subscription_plans.Row.updated_at

updated_at: string | null

Tables.subscription_plans.Update

Update: object

Tables.subscription_plans.Update.active?

optional active: boolean | null

Tables.subscription_plans.Update.created_at?

optional created_at: string

Tables.subscription_plans.Update.description?

optional description: string | null

Tables.subscription_plans.Update.displayed_features?

optional displayed_features: Json | null

Tables.subscription_plans.Update.features?

optional features: Json | null

Tables.subscription_plans.Update.id?

optional id: string

Tables.subscription_plans.Update.most_popular?

optional most_popular: boolean | null

Tables.subscription_plans.Update.name?

optional name: string | null

Tables.subscription_plans.Update.price?

optional price: number | null

Tables.subscription_plans.Update.stripe_price_id?

optional stripe_price_id: string

Tables.subscription_plans.Update.tier?

optional tier: number | null

Tables.subscription_plans.Update.updated_at?

optional updated_at: string | null

Tables.subscriptions

subscriptions: object

Tables.subscriptions.Insert

Insert: object

Tables.subscriptions.Insert.cancel_at_period_end?

optional cancel_at_period_end: boolean | null

Tables.subscriptions.Insert.created_at?

optional created_at: string | null

Tables.subscriptions.Insert.current_period_end?

optional current_period_end: string | null

Tables.subscriptions.Insert.current_period_start?

optional current_period_start: string | null

Tables.subscriptions.Insert.id?

optional id: number

Tables.subscriptions.Insert.plan_id?

optional plan_id: string | null

Tables.subscriptions.Insert.stripe_customer_id

stripe_customer_id: string

Tables.subscriptions.Insert.stripe_subscription_id?

optional stripe_subscription_id: string | null

Tables.subscriptions.Insert.subscription_status?

optional subscription_status: string | null

Tables.subscriptions.Insert.updated_at?

optional updated_at: string | null

Tables.subscriptions.Insert.user_id?

optional user_id: number | null

Tables.subscriptions.Relationships

Relationships: [{ columns: ["user_id"]; foreignKeyName: "subscriptions_user_id_fkey"; isOneToOne: true; referencedColumns: ["id"]; referencedRelation: "users"; }]

Tables.subscriptions.Row

Row: object

Tables.subscriptions.Row.cancel_at_period_end

cancel_at_period_end: boolean | null

Tables.subscriptions.Row.created_at

created_at: string | null

Tables.subscriptions.Row.current_period_end

current_period_end: string | null

Tables.subscriptions.Row.current_period_start

current_period_start: string | null

Tables.subscriptions.Row.id

id: number

Tables.subscriptions.Row.plan_id

plan_id: string | null

Tables.subscriptions.Row.stripe_customer_id

stripe_customer_id: string

Tables.subscriptions.Row.stripe_subscription_id

stripe_subscription_id: string | null

Tables.subscriptions.Row.subscription_status

subscription_status: string | null

Tables.subscriptions.Row.updated_at

updated_at: string | null

Tables.subscriptions.Row.user_id

user_id: number | null

Tables.subscriptions.Update

Update: object

Tables.subscriptions.Update.cancel_at_period_end?

optional cancel_at_period_end: boolean | null

Tables.subscriptions.Update.created_at?

optional created_at: string | null

Tables.subscriptions.Update.current_period_end?

optional current_period_end: string | null

Tables.subscriptions.Update.current_period_start?

optional current_period_start: string | null

Tables.subscriptions.Update.id?

optional id: number

Tables.subscriptions.Update.plan_id?

optional plan_id: string | null

Tables.subscriptions.Update.stripe_customer_id?

optional stripe_customer_id: string

Tables.subscriptions.Update.stripe_subscription_id?

optional stripe_subscription_id: string | null

Tables.subscriptions.Update.subscription_status?

optional subscription_status: string | null

Tables.subscriptions.Update.updated_at?

optional updated_at: string | null

Tables.subscriptions.Update.user_id?

optional user_id: number | null

Tables.transactions

transactions: object

Tables.transactions.Insert

Insert: object

Tables.transactions.Insert.buyer_user_id?

optional buyer_user_id: number | null

Tables.transactions.Insert.id?

optional id: number

Tables.transactions.Insert.listing_id?

optional listing_id: number | null

Tables.transactions.Insert.price?

optional price: number | null

Tables.transactions.Insert.seller_user_id?

optional seller_user_id: number | null

Tables.transactions.Insert.sold_at?

optional sold_at: string | null

Tables.transactions.Relationships

Relationships: [{ columns: ["buyer_user_id"]; foreignKeyName: "transactions_buyer_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }, { columns: ["listing_id"]; foreignKeyName: "transactions_listing_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "listings"; }, { columns: ["listing_id"]; foreignKeyName: "transactions_listing_id_fkey"; isOneToOne: false; referencedColumns: ["listing_id"]; referencedRelation: "listings_with_address"; }, { columns: ["seller_user_id"]; foreignKeyName: "transactions_seller_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }]

Tables.transactions.Row

Row: object

Tables.transactions.Row.buyer_user_id

buyer_user_id: number | null

Tables.transactions.Row.id

id: number

Tables.transactions.Row.listing_id

listing_id: number | null

Tables.transactions.Row.price

price: number | null

Tables.transactions.Row.seller_user_id

seller_user_id: number | null

Tables.transactions.Row.sold_at

sold_at: string | null

Tables.transactions.Update

Update: object

Tables.transactions.Update.buyer_user_id?

optional buyer_user_id: number | null

Tables.transactions.Update.id?

optional id: number

Tables.transactions.Update.listing_id?

optional listing_id: number | null

Tables.transactions.Update.price?

optional price: number | null

Tables.transactions.Update.seller_user_id?

optional seller_user_id: number | null

Tables.transactions.Update.sold_at?

optional sold_at: string | null

Tables.users

users: object

Tables.users.Insert

Insert: object

Tables.users.Insert.auth_user_id?

optional auth_user_id: string | null

Tables.users.Insert.contact_email?

optional contact_email: string | null

Tables.users.Insert.created_at?

optional created_at: string | null

Tables.users.Insert.description?

optional description: string | null

Tables.users.Insert.email?

optional email: string | null

Tables.users.Insert.first_name?

optional first_name: string | null

Tables.users.Insert.id?

optional id: number

Tables.users.Insert.last_name?

optional last_name: string | null

Tables.users.Insert.onboarded?

optional onboarded: boolean | null

Tables.users.Insert.phone_number?

optional phone_number: string | null

Tables.users.Insert.profile_image_path?

optional profile_image_path: string | null

Tables.users.Insert.role?

optional role: string | null

Tables.users.Insert.stripe_customer_id?

optional stripe_customer_id: string | null

Tables.users.Insert.subscription_id?

optional subscription_id: number | null

Tables.users.Relationships

Relationships: [{ columns: ["subscription_id"]; foreignKeyName: "users_subscription_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "subscriptions"; }]

Tables.users.Row

Row: object

Tables.users.Row.auth_user_id

auth_user_id: string | null

Tables.users.Row.contact_email

contact_email: string | null

Tables.users.Row.created_at

created_at: string | null

Tables.users.Row.description

description: string | null

Tables.users.Row.email

email: string | null

Tables.users.Row.first_name

first_name: string | null

Tables.users.Row.id

id: number

Tables.users.Row.last_name

last_name: string | null

Tables.users.Row.onboarded

onboarded: boolean | null

Tables.users.Row.phone_number

phone_number: string | null

Tables.users.Row.profile_image_path

profile_image_path: string | null

Tables.users.Row.role

role: string | null

Tables.users.Row.stripe_customer_id

stripe_customer_id: string | null

Tables.users.Row.subscription_id

subscription_id: number | null

Tables.users.Update

Update: object

Tables.users.Update.auth_user_id?

optional auth_user_id: string | null

Tables.users.Update.contact_email?

optional contact_email: string | null

Tables.users.Update.created_at?

optional created_at: string | null

Tables.users.Update.description?

optional description: string | null

Tables.users.Update.email?

optional email: string | null

Tables.users.Update.first_name?

optional first_name: string | null

Tables.users.Update.id?

optional id: number

Tables.users.Update.last_name?

optional last_name: string | null

Tables.users.Update.onboarded?

optional onboarded: boolean | null

Tables.users.Update.phone_number?

optional phone_number: string | null

Tables.users.Update.profile_image_path?

optional profile_image_path: string | null

Tables.users.Update.role?

optional role: string | null

Tables.users.Update.stripe_customer_id?

optional stripe_customer_id: string | null

Tables.users.Update.subscription_id?

optional subscription_id: number | null

Views

Views: object

Views.listings_with_address

listings_with_address: object

Views.listings_with_address.Relationships

Relationships: [{ columns: ["listing_business_id"]; foreignKeyName: "listings_business_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "businesses"; }, { columns: ["listing_business_id"]; foreignKeyName: "listings_business_id_fkey"; isOneToOne: false; referencedColumns: ["business_id"]; referencedRelation: "listings_with_address"; }, { columns: ["user_id"]; foreignKeyName: "listings_user_id_fkey"; isOneToOne: false; referencedColumns: ["id"]; referencedRelation: "users"; }]

Views.listings_with_address.Row

Row: object

Views.listings_with_address.Row.address_id

address_id: number | null

Views.listings_with_address.Row.address_line

address_line: string | null

Views.listings_with_address.Row.asking_price

asking_price: number | null

Views.listings_with_address.Row.business_hours

business_hours: string | null

Views.listings_with_address.Row.business_id

business_id: number | null

Views.listings_with_address.Row.business_name

business_name: string | null

Views.listings_with_address.Row.city

city: string | null

Views.listings_with_address.Row.confidential_sale

confidential_sale: boolean | null

Views.listings_with_address.Row.contact_company

contact_company: string | null

Views.listings_with_address.Row.contact_email

contact_email: string | null

Views.listings_with_address.Row.contact_method

contact_method: string | null

Views.listings_with_address.Row.contact_name

contact_name: string | null

Views.listings_with_address.Row.contact_phone

contact_phone: string | null

Views.listings_with_address.Row.contact_role

contact_role: string | null

Views.listings_with_address.Row.country

country: string | null

Views.listings_with_address.Row.customer_type

customer_type: string | null

Views.listings_with_address.Row.date_established

date_established: string | null

Views.listings_with_address.Row.description

description: string | null

Views.listings_with_address.Row.ebitda

ebitda: number | null

Views.listings_with_address.Row.gross_margin

gross_margin: number | null

Views.listings_with_address.Row.gross_per_year

gross_per_year: number | null

Views.listings_with_address.Row.is_public

is_public: boolean | null

Views.listings_with_address.Row.latitude

latitude: number | null

Views.listings_with_address.Row.lease_status

lease_status: string | null

Views.listings_with_address.Row.lease_term_remaining

lease_term_remaining: string | null

Views.listings_with_address.Row.listed_at

listed_at: string | null

Views.listings_with_address.Row.listing_business_id

listing_business_id: number | null

Views.listings_with_address.Row.listing_id

listing_id: number | null

Views.listings_with_address.Row.longitude

longitude: number | null

Views.listings_with_address.Row.market

market: string | null

Views.listings_with_address.Row.monthly_recurring_revenue

monthly_recurring_revenue: number | null

Views.listings_with_address.Row.number_of_employees

number_of_employees: number | null

Views.listings_with_address.Row.ownership_type

ownership_type: string | null

Views.listings_with_address.Row.physical_location

physical_location: string | null

Views.listings_with_address.Row.postal_code

postal_code: string | null

Views.listings_with_address.Row.preferred_contact

preferred_contact: string | null

Views.listings_with_address.Row.profit_per_year

profit_per_year: number | null

Views.listings_with_address.Row.reason_for_sale

reason_for_sale: string | null

Views.listings_with_address.Row.revenue_per_year

revenue_per_year: number | null

Views.listings_with_address.Row.state

state: string | null

Views.listings_with_address.Row.status

status: string | null

Views.listings_with_address.Row.type_of_sale

type_of_sale: string | null

Views.listings_with_address.Row.user_id

user_id: number | null

Views.listings_with_address.Row.valuation_multiple

valuation_multiple: number | null

Views.listings_with_address.Row.views

views: number | null

Views.listings_with_address.Row.website

website: string | null

Views.listings_with_address.Row.will_stay_post_sale

will_stay_post_sale: boolean | null

Views.listings_with_address.Row.years_in_business

years_in_business: number | null