0: Aviso

search_index
1. priority
2. advertise_id
3. advertise_name
4. type_product
5. template_name
6. info_line
7. logo
8. guia
9. status
10. contract_id
11. co_warn
12. has_more_info
13. more_info_type
14. has_free_call
15. has_address
16. has_phone
17. has_email
18. has_benefit
19. has_video
20. has_url
21. url
22. has_contact
23. has_catalog
24. has_more_activity
25. search_count
26. sest_id
27. create (Date)
28. latitude
29. longitude
search_positions
1. priority
2. position
search_what
1. sewt_id
  1. int(9)
2. sewt_what_a_id
  1. varchar(9)
3. sewt_what_a_desc
  1. varchar(128)
4. sety_a_id
  1. int(9)
5. sewt_a_priority
  1. int(9)
6. sewt_a_root
  1. char(1)
7. sewt_what_b_id
  1. varchar(9)
8. sewt_what_b_desc
  1. varchar(128)
9. sety_b_id
  1. int(9)
10. sewt_b_priority
  1. int(9)
11. sewt_b_root
  1. char(1)
12. sewt_is_main
  1. char(1)
13. sewt_create
  1. datetime
14. sein_id
  1. int(9)
search_where
1. sewr_id | int(9)
2. sewr_priority | int(9)
3. sewr_latitude | varchar(32)
4. sewr_longitude | varchar(32)
5. sewr_state_id | varchar(9)
6. sewr_state_desc | varchar(128)
7. sewr_city_id | varchar(9)
8. sewr_city_desc | varchar(129)
9. sewr_street_name | varchar(128)
10. sewr_street_number | varchar(7)
11. sewr_floor | varchar(16)
12. sewr_zipcode | varchar(16)
13. sewr_access | varchar(1024)
14. sewr_departament | varchar(64)
15. sewr_has_map | char(1)
16. sewr_point_x | varchar(32)
17. sewr_point_y | varchar(32)
18. sewr_map_img | varchar(64)
19. sewr_has_more_address | char(1)
20. sewr_is_visible | char(1)
21. sein_id | int(9)
relaciones_wt
1. pk_id | int(9)
2. rubro_id | bigint(20)
3. rubro_des | varchar(256)
4. familia_id | bigint(20)
5. familia_des | varchar(256)
6. id | bigint(20)
7. des | varchar(256)
8. tipo | varchar(256)
Search_contact
1. sect_id | bigint(20)
2. sect_area_code | varchar(255)
3. sect_complement | varchar(255)
4. sect_country_code | varchar(255)
5. sect_email | varchar(255)
6. sect_freecall_alias | varchar(255)
7. sect_freecall_order | int(11)
8. sect_has_freecall | bit(1)
9. sect_name | varchar(255)
10. sect_nickname | varchar(255)
11. sect_number | varchar(255)
12. sect_priority | int(11)
13. sewr_id | bigint(20)
14. sect_type | varchar(255)
15. sect_use | varchar(255)
search_what_type
1. id
2. desc
search_object_type
1. desc
search_object_relation
30: File
1. 31: Reference (String)
2. 32: MimeType (String)
3. 33: Id (String)
search_coverage
1. secv_id | int(9)
2. secv_mark_id | int(9)
3. secv_mark_desc | varchar(64)
4. secv_assisted | char(1)
5. secv_priority | int(9)
6. coty_id | int(9)
7. scmt_id | int(9)
8. sein_id | int(9)
Marcas : 4
Keywords : 2
Other advertise Names : 10
Activities(Rubros) : 1
search_coverage_type
1. coty_id
  1. int(9)
2. coty_desc
  1. varchar(64)
5: Telephone
15: URL (String)
34: Microsite
1. 30: Logo (File)
2. 35: Home
  1. 38: Description (String)
  2. 36: Title (String)
  3. 37: ButtonTitle (String)
  4. 39: News
    1. 40: Title (String)
    2. 41: Description (String)
  5. 30: Image (File)
3. 46: InstitutionalCorporate
  1. 47: Customer
    1. 30: Image (File)
    2. 43: TitleText (String)
    3. 44: ButtonTitle (String)
    4. 45: TitleDescription (String)
  2. 48: Staff
    1. 30: Image (File)
    2. 43: TitleText (String)
    3. 44: ButtonTitle (String)
    4. 45: TitleDescription (String)
  3. 90: TimeService
    1. 91: Note (String)
    2. 92: ButtonDescription (String)
    3. 93: List<Day>
      1. 94: Id (String)
      2. 95: Name (String)
      3. 96: List<Hour>
      4. 97: Since (String)
      5. 98: Until (String)
4. 152: PriceList
  1. 30: PriceListFile (File)
49: LinkPath (String)
50: Address
1. 1: List<Contact>
  1. 2: ContactName (String)
  2. 3: Uso (String) [Departamento o area]
  3. 4: Email (String)
  4. 5: Telephone
    1. 6: Type (String)
    2. 7: CountryCode (String)
    3. 8: PhoneAreaCode (String)
    4. 9: Number (String)
    5. 10: PhoneComplement (String)
    6. 11: Priority (int)
    7. 12: HasFreeCall (boolean)
    8. 13: FreeCallAlias (String)
    9. 14: FreeExcecCallOrder (int)
    10. 158: MobileCode (String)
  5. 153: Nickname (String)
2. 30: Image (File)
3. 51: ProvinceCode (String)
4. 52: ProvinceName (String)
5. 53: LocalityCode (String)
6. 54: LocalityName (String)
7. 55: StreetName (String)
8. 56: StreetNumber (String)
9. 57: Floor (String)
10. 58: ZipCode (String)
11. 59: Department (String)
12. 60: Access (String)
13. 62: Latitude (double)
14. 61: MapType (String)
15. 63: Longitude (double)
16. 64: AddressPositionX (double)
17. 65: AddressPositionY (double)
18. 66: Priority (int)
19. 67: IsVisible (boolean)
20. 103: AddressLabel (String)
21. 155: MapView (String)
68: Catalog
1. 70: List<Category>
  1. 71: Name
  2. 72: List<Product>
    1. 30: Image (File)
    2. 73: Name (String)
    3. 74: Brand (String)
    4. 75: Currency (String)
    5. 76: Price (double)
    6. 77: ProductDesc (String)
80: PaymentForms
1. 30: priceListFile (File)
2. 81: ButtonDescription (String)
3. [85, 86, 87, 88]: List<PaymentType>
  1. 83: Id (String)
  2. 84: Description (String)
4. 89: OtherPaymentType (String)
99: MainEmail
1. 100: MainEmailAddress (String)
2. 101: MainEmailUse (String)
102: MicrositeTemplate (String)
104: ProductLabels
1. 105: List<Label> (List<String>)
143: ThesaurusBrands
1. 144: List<ThesaurusBrand>
  1. 145: Id (String)
  2. 146: Description (String)
  3. 147: Status (String)
154: Cajon (no se referencia)
1. 30: Logo (File)
156: BrandsLabel
1. 157: List<BrandLabelItem> (List<String>)
90 : Time
1. 93 : Day
  1. 95 : Day desc
  2. 96 : Horario
    1. 97 : Hora Inicio
    2. 98 : Hora Fin
21 : Oferta (Beneficios)
1. 22 : titulo oferta
2. 23 : url mas info
3. 24 : Fecha inicio oferta
4. 25 : fecha fin oferta
Información de producto