25-08-26, 09:22 PM
Topnlab.ru is the official website of the Russian IT ecosystem TOPNLAB, which was specifically created to automate and manage real estate businesses.
Table: p_user
Rows: 73,572
Data:
Table: p_mailbox
Rows: 22,697
Data:
Table: p_lead
Rows: 169,858
Data:
Table: p_client
Rows: 985,000
Data:
To place an order, message me at Session: 05dbce3e2d0cf889b1ee337352eb97932e0dfc5a30768199d0ef8676297b762330
Telegram: @scrp_1337
Escrow +
![[Image: image.png]](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fi.ibb.co%2Fb5J7P0L0%2Fimage.png)
![[Image: image.png]](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fi.ibb.co%2FhJMJWnPf%2Fimage.png)
![[Image: image.png]](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fi.ibb.co%2FbgFTYz2X%2Fimage.png)
Table: p_user
Rows: 73,572
Data:
- email
- new_email
- password hash
- subdomain
Table: p_mailbox
Rows: 22,697
Data:
- id
- user_id
- inner_id
- master_id
- vendor_id
- Vendor name or code (duplicates vendor_id, but in a human-readable format).
- Mailbox email address.
- Login
- Mailbox activity status
- Mailbox access password (it is insecure to store it in plaintext).
- Signature automatically added to emails sent from this mailbox.
Table: p_lead
Rows: 169,858
Data:
- id
- city_id — ID of the city where the property is located.
- user_id — ID of the user who created the record or is responsible for it.
- inner_id — Internal identifier (possibly used to link internal processes or legacy systems).
- place_id — Place ID; may refer to a specific geolocation or part of a city.
- agency_id — ID of the real estate agency associated with the property.
- client_id — ID of the client associated with the property (owner, tenant, etc.).
- county_id — ID of the county or municipality.
- master_id — Link to the primary entity (e.g., a parent record, related group, etc.).
- object_id — Internal identifier of the real estate property (may duplicate id or be used in another context).
- region_id — ID of the region (oblast, krai, etc.).
- source_id — ID of the information source (e.g., website, agent, manual entry).
- street_id — ID of the street where the property is located.
- district_id — ID of the district within the city.
- external_id — External identifier, used when importing data from external systems.
- clone_object_id — ID of the original property when data was cloned (can be used to track duplicates or versions).
- fio — Client's or contact person's full name.
- note — Notes and additional comments.
- email — Client's or contact's email address.
- house — House/building number.
- rooms — Number of rooms in the property.
- corpus — Building/block number (if the building consists of multiple sections).
- floors — Total number of floors in the building.
- litera — Building letter designation (an additional building identifier commonly used in CIS countries).
- floor — Floor on which the property is located.
- created — Date and/or time when the record was created.
- metr — Property area in square meters.
Table: p_client
Rows: 985,000
Data:
- email — primary email
- email2 — secondary email
- phone — primary phone number
- phone2_int — secondary phone number (international format)
- fullname — full name
- user_id — user ID (manager/agent)
- contact_id — contact ID
- partner_id — partner ID
- master_id — master/lead manager ID
- objectid / objectids — real estate property ID (one or multiple)
- initialobjectid — original property ID
- inner_id — internal ID
- externalid / externalname — ID/name from an external system
- importforeignid / import_source — data import ID and source
- city_name — city
- county_name — county
- district_name — district
- region_name — region
- metro — metro/subway
- place_name — locality
- street / streetid / streetname — street (+ ID)
- house / houseid / housename — building/house (+ ID)
- location — coordinates/location
- comissionmy / comissionmy_type — my commission and its type (% or fixed amount)
- pricefrom / priceto — price range (from/to)
- ipoteka — mortgage (yes/no/terms)
- comment — general comment
- contract — contract
- note — note
- lastreallynote — latest actual note
- visible_notes — visible notes
- wall_material — wall material (brick, panel, etc.)
- contract_date — contract date
- date_date — date
- datefrom / datetill — period (from/to)
- last_call — date of the last call
- lastreallynote_date — date of the latest actual note
- lastvisiblenote_date — date of the latest visible note
- note_date — note date
- source_added — date added
- updated — date updated
To place an order, message me at Session: 05dbce3e2d0cf889b1ee337352eb97932e0dfc5a30768199d0ef8676297b762330
Telegram: @scrp_1337
Escrow +
![[Image: image.png]](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fi.ibb.co%2Fb5J7P0L0%2Fimage.png)
![[Image: image.png]](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fi.ibb.co%2FhJMJWnPf%2Fimage.png)
![[Image: image.png]](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fi.ibb.co%2FbgFTYz2X%2Fimage.png)
