This shows you the differences between two versions of the page.
en:public:developer:import_export_database:xml_structure [2012/12/27 14:21] igor |
en:public:developer:import_export_database:xml_structure [2013/01/13 20:28] (current) admin |
||
---|---|---|---|
Line 9: | Line 9: | ||
| ID_agent | | BIGINT | | | The internal identifier of the agent. | | | ID_agent | | BIGINT | | | The internal identifier of the agent. | | ||
| ID_notary | | BIGINT | | | The internal identifier of the notary. | | | ID_notary | | BIGINT | | | The internal identifier of the notary. | | ||
- | | Creation_date | | TIMESTAMP | YES | 'NOW' | The date of the installation. | | + | | Creation_date | | TIMESTAMP | YES | 'NOW' | The date when the ad was created. | |
| 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. | |