英文:
Data types in attributes table in SQLite database from Model Derivative
问题
The values in column data_type of the _objects_attr table from the SQLite model properties database returned by the Model Derivative's {urn}/manifest endpoint have the following meanings:
20: This corresponds to a data type representing a string.11: This represents a data type indicating a boolean value.1: This indicates a data type for integer values.2: This signifies a data type for floating-point or decimal numbers.
Here's the link to the _objects_attr table for reference.
英文:
Is there any documentation what the values in column data_type of _objects_attr table from the SQLite model properties database returned by the Model Derivative's {urn}/manifest endpoint mean?
As you see below the values in the data_type column are 20, 11, 1, 2:
_objects_attr table
I tried to find out from the SQLite model properties database what data type a particular attribute is but could not find any meaningful answer.
答案1
得分: 0
请查看 https://stackoverflow.com/questions/46619701/how-to-get-property-types/46621679#46621679。
另外，您能分享一下您使用 Sqlite Property 数据库的用例吗？如果不方便公开分享，请考虑将其发送至 aps (DOT) help (AT) autodesk (DOT) com，我们的支持渠道。
枚举属性类型 {
/* 数值类型 */
未知 = 0,
布尔,
整数,
双精度,
/* 特殊类型 */
BLOB = 10,
DbKey，/* 代表对数据库中另一个对象的链接，使用数据库内部 ID */
/* 字符串类型 */
字符串 = 20,
本地化字符串,
日期时间，/* ISO 8601 日期 */
地理位置，/* LatLonHeight - ISO6709 附件 H 字符串，例如："+27.5916+086.5640+8850/" 代表珠穆朗玛峰 */
位置 /* "x y z w" 以空格分隔的字符串，表示具有 2、3 或 4 个元素的矢量*/
};
英文:
Please check https://stackoverflow.com/questions/46619701/how-to-get-property-types/46621679#46621679 instead.
BTW, could you share your use case for using the Sqlite Property DB with us? If it's not publicly sharable, please consider sending that to aps (DOT) help (AT) autodesk (DOT) com, our support channel.
enum AttributeType {
/* Numeric types */
Unknown = 0,
Boolean,
Integer,
Double,
/* Special types */
BLOB = 10,
DbKey, /* reprensets a link to another object in the database, using database internal ID */
/* String types */
String = 20,
LocalizableString,
DateTime, /* ISO 8601 date */
GeoLocation, /* LatLonHeight - ISO6709 Annex H string, e.g: "+27.5916+086.5640+8850/" for Mount Everest */
Position /* "x y z w" space separated string representing vector with 2,3 or 4 elements*/
};
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论