Represents the data type supported by CUBRID (see the "Data Types Supported by CUBRID" table in _db_attribute).
Attribute Name |
Data Type |
Description |
---|---|---|
type_id |
INTEGER |
Data type identifier. Corresponds to the "Value" column in the "Data Types Supported by CUBRID" table. |
type_name |
VARCHAR(9) |
Data type name. Corresponds to the "Meaning" column in the "Data Types Supported by CUBRID" table. |
The following example shows how to retrieve attributes and type names of the ‘event’ class.
SELECT a.attr_name, t.type_name
FROM _db_attribute a join _db_data_type t ON a.data_type = t.type_id
WHERE class_of.class_name = 'event'
ORDER BY a.def_order;
attr_name type_name
============================================
'code' 'INTEGER'
'sports' 'STRING'
'name' 'STRING'
'gender' 'CHAR'
'players' 'INTEGER'