en:public:developer:import_export_database:xml_structure
This is an old revision of the document!
Property
| 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_local | VARCHAR(120) | Partner Internal identifier | |||
| ID_import | VARCHAR(50) | ||||
| ID_broker | INTEGER | ||||
| ID_agent | BIGINT | ||||
| ID_notary | BIGINT | The ID of the notary | |||
| Creation_date | TIMESTAMP | YES | 'NOW' | ||
| Last_alteration_date | TIMESTAMP | YES | 'NOW' | ||
| Last_alteration_by | BIGINT | ||||
| Transaction | SMALLINT | YES | |||
| Category | SMALLINT | YES | |||
| Type | SMALLINT | YES | |||
| Subtype | SMALLINT | ||||
| Classification | SMALLINT | ||||
| Admin_status | SMALLINT | YES | 2 (Pending) | ||
| Moderate_status | SMALLINT | YES | 1 (Available) | ||
| Duplicate_status | SMALLINT | YES | 1 (Available) | ||
| User_status | SMALLINT | YES | 2 (Pending) | ||
| Status | SMALLINT | YES | |||
| Agreement_to_sell_date | DATE | ||||
| Closing_date | DATE | ||||
| Listing_contract_type | SMALLINT | ||||
| Listing_contract_number | VARCHAR(10) | ||||
| Listing_contract_begin_date | DATE | ||||
| Listing_contract_end_date | DATE | ||||
| Listing_contract_renewal_type | SMALLINT | ||||
| Availability_date | DATE | ||||
| Budget_promotion | Advertising_budget | NUMERIC(18,5) | |||
| Salesman_price | NUMERIC(18,5) | ||||
| Salesman_price_max | NUMERIC(18,5) | ||||
| Original_total_sale_price | NUMERIC(18,5) | ||||
| Total_sale_price_last_mod_date | DATE | 'NOW' | |||
| Total_sale_price | NUMERIC(18,5) | ||||
| Total_sale_price_max | NUMERIC(18,5) | ||||
| Lease_price | NUMERIC(18,5) | ||||
| Lease_end_date | DATE | ||||
| ID_tenant | BIGINT | ||||
| tenant_monthly_rent_price | NUMERIC(18,5) | ||||
| Monthly_charge | NUMERIC(18,5) | ||||
| Monthly_charge_max | NUMERIC(18,5) | ||||
| Monthly_rent_price | NUMERIC(18,5) | ||||
| Monthly_rent_price_max | NUMERIC(18,5) | ||||
| Annual_charge_by_sqm | NUMERIC(18,5) | ||||
| Annual_charge_by_sqm_max | NUMERIC(18,5) | ||||
| Annual_rent_price_by_sqm | NUMERIC(18,5) | ||||
| Annual_rent_price_by_sqm_max | NUMERIC(18,5) | ||||
| Week_rent_price_min | NUMERIC(18,5) | ||||
| Week_rent_price_max | NUMERIC(18,5) | ||||
| Monthly_pension | NUMERIC(18,5) | ||||
| Deposit | NUMERIC(18,5) | ||||
| Land_tax | NUMERIC(18,5) | ||||
| Estimated_price | NUMERIC(18,5) | ||||
| Hide_prices | NUMERIC(1,0) | ||||
| Transaction_fee_owner | NUMERIC(18,5) | ||||
| Transaction_fee_buyer | NUMERIC(18,5) | ||||
| Inspection_fee_owner | NUMERIC(18,5) | ||||
| Inspection_fee_buyer | NUMERIC(18,5) | ||||
| Document_drafting_fee_owner | NUMERIC(18,5) | ||||
| Document_drafting_fee_buyer | NUMERIC(18,5) | ||||
| Transaction_fee_rate_owner | NUMERIC(9,6) | ||||
| Transaction_fee_rate_buyer | NUMERIC(9,6) | ||||
| Transaction_fee_base_rate | SMALLINT | ||||
| Fee_vat_rate | NUMERIC(4,2) | 0 | |||
| Listing_type | SMALLINT | ||||
| Listing_expiration_date | DATE | ||||
| Listing_weight | INTEGER | 0 | |||
| Listing_weight_extra | SMALLINT | 0 | |||
| ID_geo_place | Integer | YES | |||
| Address | VARCHAR(750) | ||||
| District | VARCHAR(150) | ||||
| Zip_code | VARCHAR(10) | ||||
| City | VARCHAR(150) | ||||
| Province | VARCHAR(150) | ||||
| Country | VARCHAR(2) | ||||
| Longitude | NUMERIC(11,8) | ||||
| Latitude | NUMERIC(10,8) | ||||
| Map_zoom | SMALLINT | 15 | |||
| Map_type | SMALLINT | 1 | |||
| Occupied | NUMERIC(1,0) | ||||
| Equity_release_woman_age | SMALLINT | ||||
| Equity_release_man_age | SMALLINT | ||||
| People_capacity | SMALLINT | ||||
| Floor_area_ratio | NUMERIC(4,2) | ||||
| Floor_area_min | NUMERIC(18,6) | ||||
| Floor_area | NUMERIC(18,6) | ||||
| Floor_area_carrez_law | NUMERIC(18,6) | ||||
| Lot_size_min | NUMERIC(18,6) | ||||
| Lot_size | NUMERIC(18,6) | ||||
| Rooms_min | SMALLINT | ||||
| Rooms | SMALLINT | ||||
| Bedrooms_min | SMALLINT | ||||
| Bedrooms | SMALLINT | ||||
| Offices | SMALLINT | ||||
| Shower_rooms | SMALLINT | ||||
| Bathrooms | SMALLINT | ||||
| Water_closets | SMALLINT | ||||
| Levels | SMALLINT | ||||
| Double_beds | SMALLINT | ||||
| Simple_beds | SMALLINT | ||||
| Child_beds | SMALLINT | ||||
| Parkings | SMALLINT | ||||
| Garages | SMALLINT | ||||
| Floor | SMALLINT | ||||
| Construction_year | SMALLINT | ||||
| Condition | SMALLINT | ||||
| Heating_type | SMALLINT | ||||
| Heating_combustible | SMALLINT | ||||
| Turnover | NUMERIC(18,5) | ||||
| Net_income | NUMERIC(18,5) | ||||
| Real_estate_annual_rent_price | NUMERIC(18,5) | ||||
| Real_estate_sale_price | NUMERIC(18,5) | ||||
| Energy_consumption | VARCHAR(7) | ||||
| Greenhouse_gas_emissions | VARCHAR(7) | ||||
| Image_name_1 | VARCHAR(40) | ||||
| Image_name_2 | VARCHAR(40) | ||||
| Image_name_3 | VARCHAR(40) | ||||
| Image_name_4 | VARCHAR(40) | ||||
| Currency_code | VARCHAR(3) | YES | 'EUR' |
en/public/developer/import_export_database/xml_structure.1354609697.txt.gz · Last modified: 2012/12/04 12:28 by elmira
Translations of this page:
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
