This shows you the differences between two versions of the page.
en:public:developer:import_export_database:xml_structure [2012/12/17 13:48] daria |
en:public:developer:import_export_database:xml_structure [2013/01/13 20:28] (current) admin |
||
---|---|---|---|
Line 4: | Line 4: | ||
^ Field Name ^ Suggested field name ^ Type ^ Mandatory ^ Default ^ Description ^ | ^ Field Name ^ Suggested field name ^ Type ^ Mandatory ^ Default ^ Description ^ | ||
| ID | | BIGINT | YES | | Arkadia internal identifier. Use this field only when importing Arkadia ads to your site. | | | ID | | BIGINT | YES | | Arkadia internal identifier. Use this field only when importing Arkadia ads to your site. | | ||
- | | ID_local | | VARCHAR(120) | | | Partner Internal identifier | | + | | ID_local | | VARCHAR(120) | YES | | Partner Internal identifier | |
| ID_import | | VARCHAR(50) | | | The internal identifier of the property. | | | ID_import | | VARCHAR(50) | | | The internal identifier of the property. | | ||
| ID_broker | | INTEGER | | | The internal identifier of the broker. | | | ID_broker | | INTEGER | | | The internal identifier of the broker. | | ||
| 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 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 29: | Line 29: | ||
| Listing_contract_end_date | Ad contract_end_date, Listing_contract_ termination _date | DATE | | | The expiration date of the ad contract. | | | Listing_contract_end_date | Ad contract_end_date, Listing_contract_ termination _date | DATE | | | The expiration date of the ad contract. | | ||
| Listing_contract_renewal_type | Ad_contract_renewal_type | SMALLINT | | | The type of the ad contract’s renewal. | | | Listing_contract_renewal_type | Ad_contract_renewal_type | SMALLINT | | | The type of the ad contract’s renewal. | | ||
- | | Availability_date | Availability_period | DATE | | | The available date for the lease of a real estate. | | + | | Availability_date | Availability_period <html><br><small style="color: #c00000">(from Igor: date is better, period means there's some begin-end.)</small></html> | DATE | | | The available date for the lease of a real estate. | |
| Budget_promotion | Advertising_budget, Promotional _budget| NUMERIC(18,5) | | | The budget that the agency is ready to spend to advertise the property. | | | Budget_promotion | Advertising_budget, Promotional _budget| NUMERIC(18,5) | | | The budget that the agency is ready to spend to advertise the property. | | ||
| Salesman_price | Salesman’s_price | NUMERIC(18,5) | | | The price of a salesman. | | | Salesman_price | Salesman’s_price | NUMERIC(18,5) | | | The price of a salesman. | | ||
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. | |