I need to create a model like a sql table on alfresco

Question

I need to create a model for cities that contains only the fields id, city name, like a sql table but without creating a file that is not inheriting any Alfresco model (content, folder, etc). I can do that? or it is obligatory to inherit from the Alfresco models

Answer 1

By seeing the definition of sys:base (root object) :

<type name="sys:base">
  <title>Base</title>
  <mandatory-aspects>
    <aspect>sys:referenceable</aspect>
    <aspect>sys:localized</aspect>
  </mandatory-aspects>
</type>

I would say that it should be possible to create a type without inheriting from something.

But the best shot would be to do the try.

You can inherit from sys:base anyway.

Answer 2

You could use a datalist like this to achieve that.

<description>Cities Data List Content model</description>
<version>1.0</version>

<imports>
    <!-- Import Alfresco Dictionary Definitions -->
    <import uri="http://www.alfresco.org/model/dictionary/1.0" prefix="d"/>
    <!-- Import Alfresco Content Domain Model Definitions -->
    <import uri="http://www.alfresco.org/model/content/1.0" prefix="cm"/>
    <!-- Import Alfresco Data List Model Definitions -->
    <import uri="http://www.alfresco.org/model/datalist/1.0"   prefix="dl" />
</imports>


<namespaces>
    <namespace uri="<<Your uri>>" prefix="cities"/>
</namespaces>

<types>
    <!--
        Data List Item Type for the custom cities list
        -->
    <type name="cities:cityListItem">
        <title>Cities List Item</title>
        <parent>dl:dataListItem</parent>
        <properties>
            <property name="cities:cityName">
                <type>d:text</type>
                <mandatory>true</mandatory>
            </property>
            <property name="cities:cityID">
                <type>d:int</type>
                <mandatory>true</mandatory>
            </property>
            <property name="cities:cityDescription">
                <type>d:text</type>
            </property>

        </properties>

    </type>
</types>

You can later add more customization related to this datalist as you can see in here: https://docs.alfresco.com/5.1/references/dev-extension-points-data-lists.html

Answer 3

I'd suggest using AttributeService.

http://docs.alfresco.com/5.2/references/dev-services-attribute.html