Pohledy - UNI_SEZNAM_VW
	Tabulky - ENUM_LIST - IFC_PROPERTY

select
    10*E.ID+case E.Type when 'DataType' then 7 when 'EnumDataType' then 8 when 'SimpleDataType' then 9 else 0 end Raddr, -- 7 ~ T ... data type 8 ~ E ... enum 9 ~ U ... unit
    'E' Tp,
    'P' Parent_Tp,
    E.ID,
    P.ID Parent_ID,
    'IPSZ' Visible,
    null ClassType,
    --
    7 ObjLvl,
    'Hodnota' ObjType,
    --
    coalesce(E.Name_CZ,E.Name) Name,
    coalesce(E.Definition_CZ,E.Definition) Def,
    case when length(coalesce(E.Definition_CZ,E.Definition))>50 then rtrim(substr(coalesce(E.Definition_CZ,E.Definition),1,47))||'...' else coalesce(E.Definition_CZ,E.Definition) end Def50,
    case when length(coalesce(E.Definition_CZ,E.Definition))>100 then rtrim(substr(coalesce(E.Definition_CZ,E.Definition),1,97))||'...' else coalesce(E.Definition_CZ,E.Definition) end Def100,
    -- class
    null IfcIdent,
  --null Repres,
  --null IfcRepres,
  --null Prec,
  --null PrecV,
  --null Precision,
    -- property
    null DataUnit,
    null DataTypeSpec,
    null DataType,
    null IfcType,
  --null EnumValues,
    null Link_URL
  from
    IFC_Property P,
    ENUM_List E
  where P.Visible is not null
    and P.is_Enum='Y'
    and E.Type='EnumDataType'
    and E.SubType=P.DataType