en:public:developer:import_export_database:xml_structure
Differences
This shows you the differences between two versions of the page.
|
en:public:developer:import_export_database:xml_structure [2012/12/27 14:25] alex |
en:public:developer:import_export_database:xml_structure [2013/01/13 20:28] (current) admin |
||
|---|---|---|---|
| Line 12: | Line 12: | ||
| | Last_alteration_date | Last_modification_date, last_change_date| TIMESTAMP | YES | 'NOW' | The date when the ad was altered. | | | Last_alteration_date | Last_modification_date, last_change_date| TIMESTAMP | YES | 'NOW' | The date when the ad was altered. | | ||
| | Last_alteration_by | Last_modifier, Last_change_made_by, Last_modification_made_by| BIGINT | | | The ID of last person who altered the ad. | | | Last_alteration_by | Last_modifier, Last_change_made_by, Last_modification_made_by| BIGINT | | | The ID of last person who altered the ad. | | ||
| - | | Transaction | | SMALLINT | YES | | The varieties of ad (Vente, Location de Vacances, Viager). | | + | | Transaction | Transaction_type | SMALLINT | YES | | The varieties of ad (Vente, Location de Vacances, Viager). | |
| | Category | | SMALLINT | YES | | The groups of the real estate : Residential, Commercial, Vacation Rentals. | | | Category | | SMALLINT | YES | | The groups of the real estate : Residential, Commercial, Vacation Rentals. | | ||
| | Type | | SMALLINT | YES | | The subdivision of the real estate : Apartment, House, Land, Parking space etc. | | | Type | | SMALLINT | YES | | The subdivision of the real estate : Apartment, House, Land, Parking space etc. | | ||
| Line 72: | Line 72: | ||
| | ID_geo_place | | Integer | YES | | A place in the world. | | | ID_geo_place | | Integer | YES | | A place in the world. | | ||
| | Address | | VARCHAR(750) | | | The address of the real estate’s location. | | | Address | | VARCHAR(750) | | | The address of the real estate’s location. | | ||
| - | | District | | VARCHAR(150) | | | The district, where the real estate is located. | | + | | District | | VARCHAR(150) | | | The district //of city//, where the real estate is located. | |
| | Zip_code | | VARCHAR(10) | | | A postal codes used by the United States Postal Service. | | | Zip_code | | VARCHAR(10) | | | A postal codes used by the United States Postal Service. | | ||
| | City | | VARCHAR(150) | | | The city, where the real estate is located. | | | City | | VARCHAR(150) | | | The city, where the real estate is located. | | ||
en/public/developer/import_export_database/xml_structure.1356603921.txt.gz · Last modified: 2012/12/27 14:25 by alex
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
