| name | value |
|---|---|
| name | tblProperties |
| created | 3/19/2009 10:57:41 PM |
| modified | 3/19/2009 10:57:41 PM |
| linked table from | ;DATABASE=\\spring\msaccess\imagepath.mdb |
| row count | -1 |
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|---|---|---|---|---|---|---|---|
| lngPropertyID | long | 4 | yes | yes | ||||
| lngPropertTypeID | long | 4 | 0 | yes | ||||
| strPropertyNumber | text | 50 | yes | |||||
| strAddressStreet | text | 50 | yes | |||||
| strAddressTownVillage | text | 50 | yes | |||||
| strAddressPostalCode | text | 10 | yes | |||||
| strAddressCounty | text | 50 | yes | |||||
| memProperyPhotoLink | memo | 0 | yes | path to the image | ||||
| blnFreeHold | boolean | 1 | yes | |||||
| blnLeaseHold | boolean | 1 | yes | |||||
| curPropertyAskingPrice | currency | 8 | 0 | yes | market price | |||
| memPropertyNotes | memo | 0 | yes |
| name | description | column | comment |
|---|---|---|---|
| {828C9929-F95D-4FD5-9B1B-CE6B42B13F06} | non-clustered, non-unique index on tblProperties | lngPropertTypeID | |
| lngagentID | non-clustered, non-unique index on tblProperties | lngPropertyID | |
| lngAgentID1 | non-clustered, non-unique index on tblProperties | lngPropertTypeID | |
| PrimaryKey | non-clustered, unique primary key on tblProperties | lngPropertyID | |
| strAddressPostalCode | non-clustered, non-unique index on tblProperties | strAddressPostalCode |
| lngPropertyID | lngPropertTypeID | strPropertyNumber | strAddressStreet | strAddressTownVillage | strAddressPostalCode | strAddressCounty | memProperyPhotoLink | blnFreeHold | blnLeaseHold | curPropertyAskingPrice | memPropertyNotes |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 4 | 121 | Any Road | Anytown | AB10 1CD | NULL | NULL | True | False | 200000 | Situated on one of the most sort after locations in town, this conservation area offers easy access ... |
| 3 | 9 | 101 | Long Lane | Long Town | LN11 1NN | Longton | NULL | False | True | 100000 | NULL |