Tables' Structure
Table name Listing
Column Name Data Type Length
LS_Number char 8
LS_MBNumber int 4
LS_MBName varchar 50
LS_SecondMB varchar 50
LS_Broker varchar 50
LS_Phone varchar 20
LS_Price numeric 9
LS_StreetNum varchar 10
LS_StreetName varchar 50
LS_StreetDir varchar 50
LS_StreetAbbr varchar 6
LS_Town varchar 20
LS_Province varchar 20
LS_District char 10
LS_AptNumber char 5
LS_Expiry datetime 8
LS_Update datetime 8
LS_Status char 1
LS_DTS datetime 8
Table name OpenHouse
Column Name Data Type Length
OH_Number int 4
OH_LSNumber char 8
OH_MBNumber int 4
OH_MBName varchar 50
OH_SecondMB varchar 50
OH_Broker varchar 50
OH_Phone varchar 20
OH_Email varchar 50
OH_Price numeric 9
OH_StreetNum varchar 10
OH_StreetName varchar 50
OH_StreetDir varchar 50
OH_StreetAbbr varchar 6
OH_Town varchar 20
OH_Province varchar 20
OH_District char 10
OH_AptNumber char 5
OH_Expiry datetime 8
OH_Update datetime 8
OH_Date datetime 8
OH_StartTime char 10
OH_EndTime char 10
OH_Status char 1
OH_DTS datetime 8
Table Name MBProfile
Column Name Data Type Length
MB_MemberID int 4
MB_CompanyID int 4
MB_BrokerCode char 4
MB_BranchCode char 2
MB_CompanyName varchar 100
MB_Manager char 1
MB_Active char 1
MB_Type char 2
MB_Qualifier char 2
MB_Gender char 1
MB_FirstName varchar 30
MB_LastName varchar 30
MB_MiddleName varchar 15
MB_TradeName varchar 100
MB_TorontoMLSName varchar 100
MB_Designation varchar 100
MB_BirthDate datetime 8
MB_LastFirst varchar 100
MB_RegistrationNum varchar 10
datetime
MB_RegistrationStartDate 8
datetime
MB_RegistrationEndDate 8
datetime
MB_TREBRegistrationDate 8
MB_Beneficiary varchar 200
MB_BeneficiaryRel varchar 100
MB_PACMember char 1
MB_PACJoinDate datetime 8
MB_ISPUser char 1
MB_ISPCharge char 1
MB_CreaID varchar 7
MB_BillToHome char 1
MB_Drop varchar 5
MB_Commercial char 1
MB_ProfStandards char 1
MB_Insurance char 1
MB_RenAds char 1
MB_MLSBoard char 1
MB_Year25Club char 1
MB_Year25JoinDate datetime 8
MB_Year50Club char 1
MB_Year50JoinDate datetime 8
MB_Deceased char 1
MB_Status char 1
MB_PAddress1 varchar 50
MB_PAddress2 varchar 30
MB_PCity varchar 30
MB_PProvince varchar 12
MB_PPostalCode char 6
MB_PCountry varchar 20
MB_PAddressDesc varchar 50
MB_SAddress1 varchar 50
MB_SAddress2 varchar 30
MB_SCity varchar 30
MB_SProvince varchar 12
MB_SPostalCode char 6
MB_SCountry varchar 20
MB_SAddressDesc varchar 50
MB_Mail char 1
MB_PPhone varchar 24
MB_PPhoneDesc varchar 50
MB_SPhone varchar 24
MB_SPhoneDesc varchar 50
MB_Fax varchar 24
MB_FaxDesc varchar 50
MB_PEmail varchar 50
MB_PEmailDesc varchar 50
MB_SEmail varchar 50
MB_SEmailDesc varchar 50
MB_Website varchar 50
MB_UserID varchar 16
MB_UserPassword varchar 16
MB_TREBEmail varchar 30
MB_DTStamp datetime 8
MB_Comptroller char 1
MB_BillCompany char 1
CO_Address varchar 100
Database: mmp
Precious Scale Nullable
no
10 0 no
yes
yes
yes
yes
12 2 yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
no
Precious Scale Nullable
no
no
10 0 no
yes
yes
yes
yes
yes
12 2 yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
no
Precious Scale Nullable
10 0 no
10 0 no
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
yes
IP:172.58.128.26
Descriptions
MLS#
Member number
Member name
Second Salespersion
broker name
Broker phone
Listing price
Street number
Street name
Street direction
Street Abbreviation
Minicipality
Province
District
Apartment number
Expiry date
Last update date
A available; U unavailable
Time stamp
Descriptions
Number
MLS#
Member number
Member name
Second Salespersion
broker name
Broker phone
Member Email address
Listing price
Street number
Street name
Street direction
Street Abbreviation
Minicipality
Province
District
Apartment number
Expiry date
Last update date
Open house date
Start time
End time
A available; U unavailable
Time stamp
Listing Column Name
LS_Number
LS_MBNumber
LS_MBName
LS_SecondMB
LS_Broker
LS_Phone
LS_Price
LS_StreetNum
LS_StreetName
LS_StreetDir
LS_StreetAbbr
LS_Town
LS_Province
LS_District
LS_AptNumber
LS_Expiry
LS_Update
LS_Status
LS_APPT
LS_DTS
MLS Name
ml_num
agent_id
list_agent
co_list
rltr
bph_num
lp_dol
st_num
st
st_dir
st_sfx
town
country
zn
apt_num
xd
lud
status