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: { [_ in never]: never }

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.brokers

brokers: object

Tables.brokers.Insert

Insert: object

Tables.brokers.Insert.company_address?

optional company_address: string | null

Tables.brokers.Insert.company_name?

optional company_name: string | null

Tables.brokers.Insert.first_name?

optional first_name: string | null

Tables.brokers.Insert.id?

optional id: number

Tables.brokers.Insert.last_name?

optional last_name: string | null

Tables.brokers.Insert.phone_number?

optional phone_number: string | null

Tables.brokers.Insert.user_id?

optional user_id: number | null

Tables.brokers.Relationships

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

Tables.brokers.Row

Row: object

Tables.brokers.Row.company_address

company_address: string | null

Tables.brokers.Row.company_name

company_name: string | null

Tables.brokers.Row.first_name

first_name: string | null

Tables.brokers.Row.id

id: number

Tables.brokers.Row.last_name

last_name: string | null

Tables.brokers.Row.phone_number

phone_number: string | null

Tables.brokers.Row.user_id

user_id: number | null

Tables.brokers.Update

Update: object

Tables.brokers.Update.company_address?

optional company_address: string | null

Tables.brokers.Update.company_name?

optional company_name: string | null

Tables.brokers.Update.first_name?

optional first_name: string | null

Tables.brokers.Update.id?

optional id: number

Tables.brokers.Update.last_name?

optional last_name: string | null

Tables.brokers.Update.phone_number?

optional phone_number: string | null

Tables.brokers.Update.user_id?

optional user_id: number | 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.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.favorites

favorites: object

Tables.favorites.Insert

Insert: object

Tables.favorites.Insert.id?

optional id: number

Tables.favorites.Insert.listing_id?

optional listing_id: number | null

Tables.favorites.Insert.user_id?

optional user_id: number | null

Tables.favorites.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.favorites.Row

Row: object

Tables.favorites.Row.id

id: number

Tables.favorites.Row.listing_id

listing_id: number | null

Tables.favorites.Row.user_id

user_id: number | null

Tables.favorites.Update

Update: object

Tables.favorites.Update.id?

optional id: number

Tables.favorites.Update.listing_id?

optional listing_id: number | null

Tables.favorites.Update.user_id?

optional user_id: number | 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.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.file_path?

optional file_path: 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.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.file_path

file_path: 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.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.file_path?

optional file_path: 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.tags?

optional tags: string | null

Tables.products.Update.updated_at?

optional updated_at: string | null

Tables.subscriptions

subscriptions: object

Tables.subscriptions.Insert

Insert: object

Tables.subscriptions.Insert.current_period_end?

optional current_period_end: 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?

optional stripe_customer_id: string | null

Tables.subscriptions.Insert.stripe_subscription_id?

optional stripe_subscription_id: string | null

Tables.subscriptions.Insert.subscription_status?

optional subscription_status: string | null

Tables.subscriptions.Relationships

Relationships: []

Tables.subscriptions.Row

Row: object

Tables.subscriptions.Row.current_period_end

current_period_end: 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 | null

Tables.subscriptions.Row.stripe_subscription_id

stripe_subscription_id: string | null

Tables.subscriptions.Row.subscription_status

subscription_status: string | null

Tables.subscriptions.Update

Update: object

Tables.subscriptions.Update.current_period_end?

optional current_period_end: 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 | null

Tables.subscriptions.Update.stripe_subscription_id?

optional stripe_subscription_id: string | null

Tables.subscriptions.Update.subscription_status?

optional subscription_status: string | 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.created_at?

optional created_at: 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.profile_image_path?

optional profile_image_path: string | null

Tables.users.Insert.role?

optional role: 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.created_at

created_at: 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.profile_image_path

profile_image_path: string | null

Tables.users.Row.role

role: 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.created_at?

optional created_at: 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.profile_image_path?

optional profile_image_path: string | null

Tables.users.Update.role?

optional role: 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