Start a new topic
Discussions xDM xDM - Model and Application Design
Answered

Attributes built-in data types in the repository

Hello,


Built-in data types for attributes are present as foreign key in the mta_attribute repository table (r_type) but absent from the mta_type table.


Is there another table to lookup these values?


Thank you in advance for your support


Kind Regards


Olivier



Best Answer

Hi Olivier,


They are hard-coded in the core product localization.

Please find the current corresponding values:

  • dfebbb0e-68a2-4d77-8975-a3297327deac: Binary Data
  • 59c7c2e5-eb4c-43c8-a05c-387068204ff7: Boolean
  • fa963117-443e-4a9a-a2a3-73ae1c7d17d4: Timestamp
  • de671443-9434-4fa4-afdf-ae3e4b3a20b2: Date
  • a6934a93-4578-4efa-bd6f-c4bca87b66f9: Unlimited Text
  • fc23292f-5d70-4034-a036-4f793797ff90: String
  • 1ee2a456-c81d-48b5-8f03-5ae3eecdc451: UUID
  • 2723f319-ee11-4d0d-8c03-0f9d9c2b4f7e: Decimal
  • 2651ea73-ce56-4754-9f55-7eccc02ccb92: Long Integer
  • af1d41f3-b76c-4bb9-85bb-81d730622f25: Integer
  • c0f966b7-b83d-48f4-b5f6-dc2ee971f152: Short Integer
  • de35a802-d9f9-4a6c-a614-41dc5eff6a42: Byte Integer
I hope this helps.
Best regards,
Stéphanie.

2 CommentsSorted by Oldest First
Answer

Hi Olivier,


They are hard-coded in the core product localization.

Please find the current corresponding values:

  • dfebbb0e-68a2-4d77-8975-a3297327deac: Binary Data
  • 59c7c2e5-eb4c-43c8-a05c-387068204ff7: Boolean
  • fa963117-443e-4a9a-a2a3-73ae1c7d17d4: Timestamp
  • de671443-9434-4fa4-afdf-ae3e4b3a20b2: Date
  • a6934a93-4578-4efa-bd6f-c4bca87b66f9: Unlimited Text
  • fc23292f-5d70-4034-a036-4f793797ff90: String
  • 1ee2a456-c81d-48b5-8f03-5ae3eecdc451: UUID
  • 2723f319-ee11-4d0d-8c03-0f9d9c2b4f7e: Decimal
  • 2651ea73-ce56-4754-9f55-7eccc02ccb92: Long Integer
  • af1d41f3-b76c-4bb9-85bb-81d730622f25: Integer
  • c0f966b7-b83d-48f4-b5f6-dc2ee971f152: Short Integer
  • de35a802-d9f9-4a6c-a614-41dc5eff6a42: Byte Integer
I hope this helps.
Best regards,
Stéphanie.

1 person likes this

Thank you Stéphanie

Login to post a comment
More topics in xDM - Model and Application Design
See all 178 topics
Help Desk Software by Freshdesk