skills.rest
chuangkevin
chuangkevinCOMMUNITY
Explore all skills by this author →
GitHub

houseprice-business-member

Identify active 2B business members by phone or ID and map permissions.

Updated Mar 16, 2026
Search Tags:#api#sql#brand#permission#member#business-member#realtor
One-click install
npx skills add https://github.com/chuangkevin/project-bridge --skill houseprice-business-member
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: houseprice-business-member
Source: https://github.com/chuangkevin/project-bridge/tree/main/skill/houseprice/business/houseprice-business-member
Command: npx skills add https://github.com/chuangkevin/project-bridge --skill houseprice-business-member

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Provides a clear, repeatable way to determine whether a given phone or member ID corresponds to an active 2B business member and exposes the relationships between Member, BusinessMember, Brand, Store, and permissions so developers and operators can make correct authorization and data-linking decisions.

Core Features & Use Cases

  • Clear 2B identification: Rules and SQL/API patterns to detect active business members by phone or UUID and differentiate 2B vs 2C accounts.
  • Permission and role mapping: Explanation of the Permissions bitmask, default Agent behavior, and Store vs Agent differences for authorization checks.
  • Brand and store relationships: Guidance on linking BusinessMember to Brand and optional store metadata, including queries and notes about brand tables and EffectYn filtering.
  • Operational scripts: A PowerShell query script to call Member service endpoints for ByPhone and ById lookups for diagnostics and integrations.

Quick Start

Query the member by phone or id using the provided script or the documented SQL to confirm BM.IsActive = 1 and interpret the Permissions bitmask to determine Agent or Store status.

Frequently Asked Questions about houseprice-business-member

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I check if a phone number or member ID corresponds to an active business member on the HousePrice platform?▼

To check if a phone number or member ID is an active business member, query the member using the provided PowerShell script or documented SQL patterns, then confirm the BusinessMember IsActive field equals 1 to validate the 2B account status.

How does the permissions bitmask map to Agent and Store roles for a realtor account?▼

The permissions bitmask is interpreted to differentiate Agent and Store roles by decoding specific bit flags, where default Agent behavior applies unless Store-level flags are set, enabling correct authorization checks for business member operations.

How do I link a BusinessMember to their associated brand and store data via SQL?▼

Link a BusinessMember to brand and store data by executing the documented SQL lookups that join member, brand, and store tables, ensuring you filter records using the EffectYn flag to return only active relationship mappings.

Can I use PowerShell to query the Member service API for backend diagnostics?▼

Yes, you can use the provided PowerShell query script to call Member service endpoints for ByPhone and ById lookups, which is designed for backend API calls and administrative diagnostics when debugging member or permission features.

What SQL patterns are needed to differentiate 2B versus 2C accounts during member validation?▼

Differentiating 2B versus 2C accounts requires specific SQL patterns that query the Member and BusinessMember tables, checking the BusinessMember record existence and the IsActive status to determine if the account has business-level permissions.

Related Skills

Explore More Software Engineering Skills→
Lobbi-DocsLobbi-Docs
18

member-management

Manage member records and lifecycle transitions with tenant-scoped data access.

Official
Intermediate
abhijeetkakade1234abhijeetkakade1234
1

frontend-validation-bypass

Detect frontend-only validation and permission-check vulnerabilities in web applications.

Community
Advanced
interflownexinterflownex
2

spanner-data

Explore Google Spanner schemas and execute DML and DQL queries.

Community
Intermediate
Orvanta-CloudOrvanta-Cloud

write-script-mysql

Create, preview, and execute MySQL query scripts programmatically.

Official
Basic