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