match

Tables (9)

sm_fee_payment_link

  • id — UUID
  • country — TEXT — NOT NULL
  • price_range_min — BIGINT — NOT NULL
  • price_range_max — BIGINT — NOT NULL
  • fee_amount — BIGINT — NOT NULL
  • payment_link_url — TEXT — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ

sm_host_settlement_account

  • id — UUID
  • host_id — UUID — Foreign key → sm_profiles.id — NOT NULL
  • bank_name — TEXT — NOT NULL
  • account_number — TEXT — NOT NULL
  • account_holder — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

sm_profiles

  • id — UUID
  • role — TEXT — NOT NULL
  • email — TEXT — NOT NULL
  • name — TEXT
  • country — TEXT
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

sm_quote

  • id — UUID
  • quote_request_space_id — UUID — Foreign key → sm_quote_request_space.id — NOT NULL
  • total_price — BIGINT — NOT NULL
  • deposit_price — BIGINT
  • details — TEXT
  • price_includes — JSONB
  • payment_method — TEXT
  • payment_url — TEXT
  • status — TEXT
  • sent_at — TIMESTAMPTZ
  • expired_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

sm_quote_request

  • id — UUID
  • admin_id — UUID — Foreign key → sm_profiles.id
  • guest_name — TEXT — NOT NULL
  • guest_email — TEXT — NOT NULL
  • guest_phone — TEXT
  • usage_date — DATE — NOT NULL
  • start_time — TIME
  • end_time — TIME
  • people_count — INTEGER
  • budget — BIGINT
  • requirements — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

sm_quote_request_space

  • id — UUID
  • quote_request_id — UUID — Foreign key → sm_quote_request.id — NOT NULL
  • space_id — UUID — Foreign key → sm_space.id — NOT NULL
  • status — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

sm_reservation

  • id — UUID
  • quote_id — UUID — Foreign key → sm_quote.id — NOT NULL
  • status — TEXT
  • guest_info — JSONB
  • schedule — JSONB
  • payment_info — JSONB
  • confirmed_at — TIMESTAMPTZ
  • completed_at — TIMESTAMPTZ
  • cancelled_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

sm_settlement

  • id — UUID
  • reservation_id — UUID — Foreign key → sm_reservation.id — NOT NULL
  • amount — BIGINT — NOT NULL
  • platform_fee — BIGINT — NOT NULL
  • payout_amount — BIGINT — NOT NULL
  • scheduled_at — TIMESTAMPTZ — NOT NULL
  • paid_at — TIMESTAMPTZ
  • status — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

sm_space

  • id — UUID
  • host_id — UUID — Foreign key → sm_profiles.id
  • name — TEXT — NOT NULL
  • location — TEXT — NOT NULL
  • capacity_min — INTEGER
  • capacity_max — INTEGER
  • type — TEXT
  • area — DECIMAL
  • price_per_hour — BIGINT
  • currency — TEXT
  • images — TEXT
  • description — TEXT
  • facilities — JSONB
  • is_masked — BOOLEAN
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ