<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<DatabaseModel VersionId="2.3">
    <Name>GAW-EUROCAE</Name>
    <Description></Description>
    <DatabaseEngine>
        <Name>postgresql</Name>
        <Version>9.x</Version>
    </DatabaseEngine>
    <Counters>
        <Counter>
            <Name>table</Name>
            <Value>30</Value>
            <Prefix>t</Prefix>
        </Counter>
        <Counter>
            <Name>column</Name>
            <Value>227</Value>
            <Prefix>c</Prefix>
        </Counter>
        <Counter>
            <Name>index</Name>
            <Value>1</Value>
            <Prefix>i</Prefix>
        </Counter>
        <Counter>
            <Name>reference</Name>
            <Value>63</Value>
            <Prefix>r</Prefix>
        </Counter>
        <Counter>
            <Name>table_check</Name>
            <Value>0</Value>
            <Prefix>tc</Prefix>
        </Counter>
        <Counter>
            <Name>alternate_key</Name>
            <Value>0</Value>
            <Prefix>a</Prefix>
        </Counter>
        <Counter>
            <Name>sequence</Name>
            <Value>0</Value>
            <Prefix>s</Prefix>
        </Counter>
        <Counter>
            <Name>note</Name>
            <Value>0</Value>
            <Prefix>n</Prefix>
        </Counter>
        <Counter>
            <Name>view</Name>
            <Value>0</Value>
            <Prefix>v</Prefix>
        </Counter>
        <Counter>
            <Name>view_column</Name>
            <Value>0</Value>
            <Prefix>vc</Prefix>
        </Counter>
        <Counter>
            <Name>area</Name>
            <Value>7</Value>
            <Prefix>ar</Prefix>
        </Counter>
        <Counter>
            <Name>text</Name>
            <Value>0</Value>
            <Prefix>tx</Prefix>
        </Counter>
        <Counter>
            <Name>tableDisplay</Name>
            <Value>30</Value>
            <Prefix>td</Prefix>
        </Counter>
        <Counter>
            <Name>viewDisplay</Name>
            <Value>0</Value>
            <Prefix>vd</Prefix>
        </Counter>
        <Counter>
            <Name>referenceDisplay</Name>
            <Value>63</Value>
            <Prefix>rd</Prefix>
        </Counter>
    </Counters>
    <AdditionalSQLBeforeCreate></AdditionalSQLBeforeCreate>
    <AdditionalSQLAfterCreate></AdditionalSQLAfterCreate>
    <AdditionalSQLBeforeDrop></AdditionalSQLBeforeDrop>
    <AdditionalSQLAfterDrop></AdditionalSQLAfterDrop>
    <Tables>
        <Table Id="t1">
            <Name>uas_zone_version</Name>
            <Description>Eurocae Name: UASZoneVersion</Description>
            <Columns>
                <Column Id="c23">
                    <Name>uas_zone_id</Name>
                    <Type>uuid</Type>
                    <Description>Included in Eurocae in an abstrac entity called UASZone (UASZoneVersion Superclass). Eurocae name identifier (CodeZoneIdentifierType)</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c24">
                    <Name>country_id</Name>
                    <Type>int</Type>
                    <Description>Included in Eurocae in an abstrac entity called UASZone (UASZoneVersion Superclass). Eurocae name country. (CodeCountryISOType)</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c1">
                    <Name>name</Name>
                    <Type>varchar(100)</Type>
                    <Description>A free text name by which the zone may be known by the public or by the UAS community</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c124">
                    <Name>code_zone_type_type_code</Name>
                    <Type>int</Type>
                    <Description>An indication whether the Zone is provided with its common definition or with a customised definition, for a particular user. Eurocae name type</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c106">
                    <Name>code_restriction_type_restriction_code</Name>
                    <Type>int</Type>
                    <Description>An indication if flying in the zone is permitted, conditional or forbidden. Eurocae name restriction</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c107">
                    <Name>condition_expression_type_restriction_code</Name>
                    <Type>int</Type>
                    <Description>An indication of the conditions under which the zone can be used. Eurocae name restrictionConditions</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c177">
                    <Name>region</Name>
                    <Type>int</Type>
                    <Description>A Region inside the State that has the authority to declare the zone. Eurocae name: region

Note - identified with a digit between 0-65535 (16 bit), corresponding to a list of regions pre-defined for each State.
</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c6">
                    <Name>data_capture_prohibition</Name>
                    <Type>boolean</Type>
                    <Description>An indication if data capturing (such as aerial photography, etc.) is prohibited when flying in the zone. Eurocae name dataCaptureProhibition</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c109">
                    <Name>code_zone_reason_code_zone_reason</Name>
                    <Type>int</Type>
                    <Description>A coded indication for the reason that led to the establishment of the zone. Eurocao name reason. 

Note: Data Type codeZoneReasonType.</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c108">
                    <Name>code_uspace_class_type_u_space_code</Name>
                    <Type>int</Type>
                    <Description>A code that identifies the category or class of the zone applying a "USpace concept". Eurocae name uSpaceClase from codeList CodeUSpaceClassType.

Note: Two (draft) classifications exist, one from Eurocontrol and one from CORUS. Therefore, two instances of this attribute are expected, one from each sub-list. This might be later replaced with separate attributes and separate lists of values.
</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c9">
                    <Name>message</Name>
                    <Type>varchar(60)</Type>
                    <Description>A message to be displayed to the user of the zone. Eurocae name message. Type TextShortType with a maximum lenght of 60 characters.</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c191">
                    <Name>metadata_metada_id</Name>
                    <Type>uuid</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c102">
                    <Name>time_period_time_period_id</Name>
                    <Type>uuid</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c226">
                    <Name>authority_authority_oid</Name>
                    <Type>uuid</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c105">
                    <Name>airspace_volume_vol_id</Name>
                    <Type>uuid</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c23</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter></AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t2">
            <Name>airspace_volume</Name>
            <Description>(EUROCAE) The definition of the airspace volume comprised by the Zone, in the form of a cylinder with a horizontal projection and vertical limits.</Description>
            <Columns>
                <Column Id="c20">
                    <Name>vol_id</Name>
                    <Type>uuid</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c15">
                    <Name>lower_limit</Name>
                    <Type>int</Type>
                    <Description>The lowest level included in the Zone (in metres). If not specified, it means that the zone starts from surface (ground)</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c16">
                    <Name>lower_vertical_reference</Name>
                    <Type>int</Type>
                    <Description>The vertical reference system used for expressing the lower limit</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c17">
                    <Name>upper_limit</Name>
                    <Type>int</Type>
                    <Description>The highest level included in the Zone (in metres). If not specified, it means that the zone extends to any possible level (unlimited).</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c116">
                    <Name>upper_vertical_reference</Name>
                    <Type>int</Type>
                    <Description>The vertical reference system used for expressing the upper limit</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c19">
                    <Name>geom_origin</Name>
                    <Type>uuid</Type>
                    <Description>The Id of the primitive feature of the geom_buffer </Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c136">
                    <Name>geom_buffer</Name>
                    <Type>geometry(LINESTRING,4326)</Type>
                    <Description>The shape of the area in a projection at the surface of the Earth considered as the WGS-84 ellipsoid.</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c227">
                    <Name>layers_layer_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c20</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter></AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t3">
            <Name>time_period</Name>
            <Description>(EUROCAE) Defines the applicability dates and times of the zone, including its eventual usage permissions/restrictions.</Description>
            <Columns>
                <Column Id="c25">
                    <Name>time_period_id</Name>
                    <Type>uuid</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c26">
                    <Name>uas_zone_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c27">
                    <Name>permanent</Name>
                    <Type>boolean</Type>
                    <Description>An indication that the area is permanent</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c28">
                    <Name>start_date_time</Name>
                    <Type>date</Type>
                    <Description>The date and time when the area starts to exist.</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c29">
                    <Name>end_date_time</Name>
                    <Type>date</Type>
                    <Description>The date and time when the area ceases to exist.</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c25</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter></AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t4">
            <Name>daily_period</Name>
            <Description>(EUROCAE) Specifies a daily applicability schedule of the zone and its eventual permissions/restrictions, within the time when the area exists according to the TimePeriod information</Description>
            <Columns>
                <Column Id="c32">
                    <Name>daily_period_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c36">
                    <Name>time_period_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c34">
                    <Name>start_time</Name>
                    <Type>time</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c35">
                    <Name>end_time</Name>
                    <Type>time</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c111">
                    <Name>code_week_day_day_number</Name>
                    <Type>int</Type>
                    <Description>The day of the week</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c110">
                    <Name>time_period_time_period_id</Name>
                    <Type>uuid</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c32</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter></AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t5">
            <Name>code_zone_type</Name>
            <Description>Eurocae CodeList. Eurocae name CodeZoneType. This table is not implicited defined in Eurocae Data Model since is just a code List.

read only table 

Acording to Eurocae:
INSERT INTO code_zone_type (type_code, name, description)
VALUES
   (1,'COMMON', 'The Zone is provided with its default definition') ,
   (2,'CUSTOMIZED', 'The Zone is provided with a customised definition, for a particular operator') ;</Description>
            <Columns>
                <Column Id="c43">
                    <Name>type_code</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c44">
                    <Name>name</Name>
                    <Type>varchar(50)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c140">
                    <Name>description</Name>
                    <Type>varchar(550)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c43</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter>INSERT INTO code_zone_type (type_code, name, description)
VALUES
   (1,'COMMON', 'The Zone is provided with its default definition') ,
   (2,'CUSTOMIZED', 'The Zone is provided with a customised definition, for a particular operator') ;</AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t6">
            <Name>code_restriction_type</Name>
            <Description>Eurocae CodeList. Eurocae name CodeRestrictionType. This table is not implicited defined in Eurocae Data Model since is just a code List.

read only table 


Acording to Eurocae:
INSERT INTO code_restriction_type (restriction_code, name)
VALUES
   (1,'PROHIBITED') ,
   (2,'REQ_AUTHORISATION') ,
   (3,'CONDITIONAL') ,
   (4,'NO_RESTRICTION') ;
</Description>
            <Columns>
                <Column Id="c47">
                    <Name>restriction_code</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c48">
                    <Name>name</Name>
                    <Type>varchar(50)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c47</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter>INSERT INTO code_restriction_type (restriction_code, name)
VALUES
   (1,'PROHIBITED') ,
   (2,'REQ_AUTHORISATION') ,
   (3,'CONDITIONAL') ,
   (4,'NO_RESTRICTION') ;</AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t7">
            <Name>condition_expression_type</Name>
            <Description>(EUROCAE) A coded expression that provides information about what is authorised / forbidden in a zone that has conditional access</Description>
            <Columns>
                <Column Id="c49">
                    <Name>restriction_code</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c50">
                    <Name>name</Name>
                    <Type>varchar(50)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c141">
                    <Name>description</Name>
                    <Type>varchar(2000)</Type>
                    <Description>For Example: · The UAS is Authorized XOR Forbidden (exclusive choice) to fly in this zone at this time if (Characteristic1  CHARTYPE1 is equal to CHARVAL1 ) AND Characteristic2 CHARTYPE 2 is equal to VALUE 2 AND … AND End IF
       OR if (…..) 
</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c49</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter></AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t8">
            <Name>code_uspace_class_type</Name>
            <Description>Eurocae CodeList CodeUSpaceClassType 

Acording to Eurocae:
INSERT INTO code_uspace_class_type (u_space_code, name, description)
VALUES
   (1,'NDZ', 'No Drone Zone') ,
   (2,'LDZ', 'Limited Drone Zone') ,
   (3,'EDZu', 'Exclusive Drone Zone (unplanned)') ,
   (4,'EDZp', 'Exclusive Drone Zone (planned)') , 
   (5,'EDZm', 'Exclusive Drone Zone for passenger carrying operations') ,
   (6,'X', 'Class X (according to the CORUS conops)') ,
   (7,'Y', 'Class Y (according to the CORUS conops)') ,
   (8,'Z', 'Class Z (according to the CORUS conops)');</Description>
            <Columns>
                <Column Id="c60">
                    <Name>u_space_code</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c52">
                    <Name>name</Name>
                    <Type>varchar(50)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c53">
                    <Name>description</Name>
                    <Type>varchar(250)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c60</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter>INSERT INTO code_uspace_class_type (u_space_code, name, description)
VALUES
   (1,'NDZ', 'No Drone Zone') ,
   (2,'LDZ', 'Limited Drone Zone') ,
   (3,'EDZu', 'Exclusive Drone Zone (unplanned)') ,
   (4,'EDZp', 'Exclusive Drone Zone (planned)') , 
   (5,'EDZm', 'Exclusive Drone Zone for passenger carrying operations') ,
   (6,'X', 'Class X (according to the CORUS conops)') ,
   (7,'Y', 'Class Y (according to the CORUS conops)') ,
   (8,'Z', 'Class Z (according to the CORUS conops)');</AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t9">
            <Name>code_week_day</Name>
            <Description>Acording to Eurocae:
INSERT INTO code_week_day (day_number, day_name)
VALUES
   (1, 'Sunday') ,
   (2, 'Monday'),
   (3, 'Tuesday') ,
   (4, 'Wednesday') ,
   (5, 'Thursday') ,
   (6, 'Fryday') ,
   (7, 'Saturday') ;</Description>
            <Columns>
                <Column Id="c62">
                    <Name>day_number</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c63">
                    <Name>day_name</Name>
                    <Type>varchar(15)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c62</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter></AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t10">
            <Name>code_vertical_reference</Name>
            <Description>Acording to Eurocae:INSERT INTO code_vertical_reference (vertical_reference_code, name, description)
VALUES
   (1,'AGL', 'Height above ground/surface level') ,
   (2,'AMSL', 'Altitude above Mean Sea Level') ,
   (3,'WGS84', 'Altitude above the reference WGS-84 Ellipsoid') ;</Description>
            <Columns>
                <Column Id="c65">
                    <Name>vertical_reference_code</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c66">
                    <Name>name</Name>
                    <Type>varchar(50)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c65</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter>INSERT INTO code_vertical_reference (vertical_reference_code, name, description)
VALUES
   (1,'AGL', 'Height above ground/surface level') ,
   (2,'AMSL', 'Altitude above Mean Sea Level') ,
   (3,'WGS84', 'Altitude above the reference WGS-84 Ellipsoid') ;</AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t11">
            <Name>code_zone_reason</Name>
            <Description>Eurocae CodeList name CodeZoneReasonType

Acording to Eurocae:
INSERT INTO code_zone_reason (code_zone_reason, name, description)
VALUES
   (1,'Air Trafic', 'Due to the presence of air traffic') ,
   (2,'Sensitive', 'Due to the presence of a sensitive site, in the vicinity of which the presence of drones could be considered a potential threat') ,
   (3,'Privacy', 'Due to the presence of a site for which the presence of drones could rise privacy concerns'),
   (4,'Population', 'Due to the presence of a significantly populated area') ,
   (5,'Nature', 'Due to the presence of a wildelife/nature sanctuary or another area with sensitive nature/fauna') ,
   (6,'Noise', 'Due to noise abatement regulations') ,
   (7,'Foreign Territory', 'Indicates a "fake" Zone that is created automatically and which corresponds to the territory of a neighboring country. This zone is "restricted" by default and it is just an indication that the database is missing the information about the neighboring country') ,
   (8,'Other', 'Due to another reason, which may be specified in the format "OTHER:..specific reason..." (maximum 30 characters)');
</Description>
            <Columns>
                <Column Id="c70">
                    <Name>code_zone_reason</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c71">
                    <Name>name</Name>
                    <Type>varchar(50)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c139">
                    <Name>description</Name>
                    <Type>varchar(550)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c70</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter>INSERT INTO code_zone_reason (code_zone_reason, name, description)
VALUES
   (1,'Air Trafic', 'Due to the presence of air traffic') ,
   (2,'Sensitive', 'Due to the presence of a sensitive site, in the vicinity of which the presence of drones could be considered a potential threat') ,
   (3,'Privacy', 'Due to the presence of a site for which the presence of drones could rise privacy concerns'),
   (4,'Population', 'Due to the presence of a significantly populated area') ,
   (5,'Nature', 'Due to the presence of a wildelife/nature sanctuary or another area with sensitive nature/fauna') ,
   (6,'Noise', 'Due to noise abatement regulations') ,
   (7,'Foreign Territory', 'Indicates a "fake" Zone that is created automatically and which corresponds to the territory of a neighboring country. This zone is "restricted" by default and it is just an indication that the database is missing the information about the neighboring country') ,
   (8,'Other', 'Due to another reason, which may be specified in the format "OTHER:..specific reason..." (maximum 30 characters)');</AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t12">
            <Name>layers</Name>
            <Description></Description>
            <Columns>
                <Column Id="c72">
                    <Name>layer_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c73">
                    <Name>name</Name>
                    <Type>varchar(50)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c154">
                    <Name>name_code</Name>
                    <Type>varchar(50)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c74">
                    <Name>description</Name>
                    <Type>varchar(2000)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c155">
                    <Name>border_rgb_color</Name>
                    <Type>varchar(20)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c156">
                    <Name>background_rgb_color</Name>
                    <Type>varchar(20)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c157">
                    <Name>border_width</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c158">
                    <Name>transparency</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c114">
                    <Name>geometry_codification_geometry_type</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c72</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter></AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t13">
            <Name>geometry_codification</Name>
            <Description>Taken from https://postgis.net/docs/using_postgis_dbmanagement.html#Create_Spatial_Table
For UTM use only 1,2 or 3

INSERT INTO geometry_codification (geometry_id, name)
VALUES
   (1,'POINT') , (2,'LINESTRING') ,(3,'POLYGON') ,(4,'MULTIPOINT') ,(5,'MULTILINESTRING') ,
(6,'MULTIPOLYGON') ,(7,'GEOMETRYCOLLECTION ') ,(8,'POINTM') ,(9,'LINESTRINGM') ,(10,'POLYGONM') ,(11,'MULTIPOINTM') ,(12,'MULTILINESTRINGM') ,(13,'MULTIPOLYGONM') ,(14,'GEOMETRYCOLLECTIONM') ,(15,'GEOMETRY') ;
</Description>
            <Columns>
                <Column Id="c78">
                    <Name>geometry_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c79">
                    <Name>name</Name>
                    <Type>varchar(50)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c78</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter>INSERT INTO geometry_codification (geometry_id, name)
VALUES
   (1,'POINT') , (2,'LINESTRING') ,(3,'POLYGON') ,(4,'MULTIPOINT') ,(5,'MULTILINESTRING') ,
   (6,'MULTIPOLYGON') ,(7,'GEOMETRYCOLLECTION ') ,(8,'POINTM') ,(9,'LINESTRINGM') ,
   (10,'POLYGONM') ,(11,'MULTIPOINTM') ,(12,'MULTILINESTRINGM') ,(13,'MULTIPOLYGONM') ,
   (14,'GEOMETRYCOLLECTIONM') ,(15,'GEOMETRY') ;</AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t16">
            <Name>volume_limitation</Name>
            <Description>Volume limitation</Description>
            <Columns>
                <Column Id="c89">
                    <Name>limitation_id</Name>
                    <Type>uuid</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c150">
                    <Name>limitation_value</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c151">
                    <Name>volume_limitation_definitions_limitation_definition_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c152">
                    <Name>uas_zone_version_uas_zone_id</Name>
                    <Type>uuid</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c89</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter></AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t17">
            <Name>flight_warnings</Name>
            <Description>INSERT INTO flight_warnings (warning_id,name_code, name, description)
VALUES
   (1,'eu_war_all_01', 'It is forbidden to fly above 120m', 'Valid for all the operations') ,
   (2,'eu_war_all_02', 'It is forbidden to operate the UA while operating a moving vehicle', 'Valid for all the operations') ,
   (3,'eu_war_all_03', 'It is forbidden to operate more than one UA at a time', 'Valid for all the operations') ,
   (4,'eu_war_all_04', 'The dissemination of people and private places images requires authorisation of the involved people/owners', 'Valid for all the operations') ,
   (5,'eu_war_all_05', 'Remember to check the weather conditions prior the operation planning', 'Valid for all the operations') ,
   (6,'eu_war_all_06', 'It is forbidden to Fly during the night', 'Valid for all the operations') ,
   (21,'eu_war_open_01', 'It is forbidden to fly above assemblies of people', 'Valid for Open operations') ,
   (22,'eu_war_open_02', 'It is forbidden to fly UA with MTOM&gt;25kg', 'Valid for Open operations') ,
   (23,'eu_war_open_03', 'It is forbidden any autonomous operation', 'Valid for Open operations') ,
   (24,'eu_war_open_04', 'It is forbidden to carry dangerous goods and drop any material', 'Valid for Open operations') ,
   (25,'eu_war_open_05', 'It is forbidden any operation in BVLOS without an UA observer or flying in follow-me mode', 'Valid for Open operations') ,
   (26,'eu_war_open_06', 'The minimum age for remote pilot without supervision is 16 years old unless operating an UAS class C0 classified as toy in A1 subcategory', 'Valid for Open operations') ,
    (41,'eu_war_esp_01', 'The minimum age for remote pilot without supervision is 16 years old', 'Valid for Specific operations') ,
    (42,'eu_war_esp_02', 'The competent authority may require the certification of the UAS t adequately mitigate the risk of the operation', 'Valid for Specific operations') ,
   (43,'eu_war_esp_03', 'An operational authorisation issued by competent authority with a risk assessment attached is needed, unless it applies any of the following: PDRA, LUC, declaration STS or club/association authorisation', 'Valid for Specific operations') ,
   (61,'eu_war_cert_01', 'Certified operations require manual authorisation', 'Valid for Certified operations') ,
   (62,'eu_war_cert_02', 'The UA operated in this area must be registered and airworthiness certified pursuant Commission Regulations (EU) No 748/2012, (EU) No 2015/640 and (EU) No 1321/2014', 'Valid for Certified operations') ;</Description>
            <Columns>
                <Column Id="c117">
                    <Name>warning_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c118">
                    <Name>name_code</Name>
                    <Type>varchar(5)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c119">
                    <Name>name</Name>
                    <Type>varchar(200)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c120">
                    <Name>description</Name>
                    <Type>varchar(2000)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c117</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter>INSERT INTO flight_warnings (warning_id,name_code, name, description)
VALUES
   (1,'eu_war_all_01', 'It is forbidden to fly above 120m', 'Valid for all the operations') ,
   (2,'eu_war_all_02', 'It is forbidden to operate the UA while operating a moving vehicle', 'Valid for all the operations') ,
   (3,'eu_war_all_03', 'It is forbidden to operate more than one UA at a time', 'Valid for all the operations') ,
   (4,'eu_war_all_04', 'The dissemination of people and private places images requires authorisation of the involved people/owners', 'Valid for all the operations') ,
   (5,'eu_war_all_05', 'Remember to check the weather conditions prior the operation planning', 'Valid for all the operations') ,
   (6,'eu_war_all_06', 'It is forbidden to Fly during the night', 'Valid for all the operations') ,
   (21,'eu_war_open_01', 'It is forbidden to fly above assemblies of people', 'Valid for Open operations') ,
   (22,'eu_war_open_02', 'It is forbidden to fly UA with MTOM&gt;25kg', 'Valid for Open operations') ,
   (23,'eu_war_open_03', 'It is forbidden any autonomous operation', 'Valid for Open operations') ,
   (24,'eu_war_open_04', 'It is forbidden to carry dangerous goods and drop any material', 'Valid for Open operations') ,
   (25,'eu_war_open_05', 'It is forbidden any operation in BVLOS without an UA observer or flying in follow-me mode', 'Valid for Open operations') ,
   (26,'eu_war_open_06', 'The minimum age for remote pilot without supervision is 16 years old unless operating an UAS class C0 classified as toy in A1 subcategory', 'Valid for Open operations') ,
    (41,'eu_war_esp_01', 'The minimum age for remote pilot without supervision is 16 years old', 'Valid for Specific operations') ,
    (42,'eu_war_esp_02', 'The competent authority may require the certification of the UAS t adequately mitigate the risk of the operation', 'Valid for Specific operations') ,
   (43,'eu_war_esp_03', 'An operational authorisation issued by competent authority with a risk assessment attached is needed, unless it applies any of the following: PDRA, LUC, declaration STS or club/association authorisation', 'Valid for Specific operations') ,
   (61,'eu_war_cert_01', 'Certified operations require manual authorisation', 'Valid for Certified operations') ,
   (62,'eu_war_cert_02', 'The UA operated in this area must be registered and airworthiness certified pursuant Commission Regulations (EU) No 748/2012, (EU) No 2015/640 and (EU) No 1321/2014', 'Valid for Certified operations') ;</AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t18">
            <Name>warnings_and_limitations</Name>
            <Description>many to many relationship

INSERT INTO warnings_ans_limitations wl_id,flight_warnings_id_warning, volume_limitation_definitions_limitation_definition_id)
VALUES
   (1,6,1) ,(1,6,2) ,(1,6,3) ,(1,6,4) ,(1,6,5) ,(1,6,6) ,  -- warning for all (open) 
   (1,7,1) ,(1,7,2) ,(1,7,3) ,(1,7,4) ,(1,7,5) ,(1,7,6) ,  -- warning for all (specific)
   (1,8,1) ,(1,8,2) ,(1,8,3) ,(1,8,4) ,(1,8,5) ,(1,8,6) ,  -- warning for all (certified)
   (1,6,21) ,(1,6,22) ,(1,6,23) ,(1,6,24) ,(1,6,25) ,(1,6,26) ,  -- warning just for open 
   (1,7,41) ,(1,7,42) ,(1,7,43) ,  -- warning just for specific 
   (1,8,61) ,(1,8,62);  -- warning just for certified </Description>
            <Columns>
                <Column Id="c121">
                    <Name>wl_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c123">
                    <Name>flight_warnings_id_warning</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c153">
                    <Name>volume_limitation_definitions_limitation_definition_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c121</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter>INSERT INTO warnings_ans_limitations (wl_id,flight_warnings_id_warning, volume_limitation_definitions_limitation_definition_id)
VALUES
   (1,6,1) ,(2,6,2) ,(3,6,3) ,(4,6,4) ,(5,6,5) ,(6,6,6) ,  -- warning for all (open) 
   (7,7,1) ,(8,7,2) ,(9,7,3) ,(10,7,4) ,(11,7,5) ,(12,7,6) ,  -- warning for all (specific)
   (13,8,1) ,(14,8,2) ,(15,8,3) ,(16,8,4) ,(17,8,5) ,(18,8,6) ,  -- warning for all (certified)
   (19,6,21) ,(20,6,22) ,(21,6,23) ,(22,6,24) ,(23,6,25) ,(24,6,26) ,  -- warning just for open 
   (25,7,41) ,(26,7,42) ,(27,7,43) ,  -- warning just for specific 
   (28,8,61) ,(29,8,62);  -- warning just for certified </AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t21">
            <Name>volume_limitation_definitions</Name>
            <Description>Limitattions definitions

INSERT INTO limitation_definitions (limitation_definition_id,name_code, name, description,volume_limitation_types_limitation_type_id )
VALUES
   (1,'cert_type_0', 'Certification Type 0' 'European Drone Certification Type 0,1') ,
   (2,'cert_type_1', 'Certification Type 1' 'European Drone Certification Type 1,1') ,
   (3,'cert_type_2', 'Certification Type 2' 'European Drone Certification Type 2,1') ,
   (4,'cert_type_3', 'Certification Type 3' 'European Drone Certification Type 3,1') ,
   (5,'cert_type_4', 'Certification Type 4' 'European Drone Certification Type 4,1') ,
   (6,'opt_type_open', 'Operation_type Open' 'European operation type Open,1') ,
   (7,'opt_type_specific', 'Operation_type Specific' 'European operation type Specific,1') ,
   (8,'opt_type_certified', 'Operation_type Certified' 'European operation type Certified,1') ,
   (50,'laanc', 'LAANC Type' 'Low Altitude Authorization and Notification Capability,2') ;</Description>
            <Columns>
                <Column Id="c142">
                    <Name>limitation_definition_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c143">
                    <Name>name_code</Name>
                    <Type>varchar(50)</Type>
                    <Description>name without spaces, punctuation and symbol characters. Prererible in  snake_case notation</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c144">
                    <Name>name</Name>
                    <Type>varchar(50)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c145">
                    <Name>description</Name>
                    <Type>varchar(2000)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c148">
                    <Name>volume_limitation_types_limitation_type_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c142</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter>INSERT INTO limitation_definitions (limitation_definition_id,name_code, name, description,volume_limitation_types_limitation_type_id )
VALUES
   (1,'cert_type_0', 'Certification Type 0' 'European Drone Certification Type 0,1') ,
   (2,'cert_type_1', 'Certification Type 1' 'European Drone Certification Type 1,1') ,
   (3,'cert_type_2', 'Certification Type 2' 'European Drone Certification Type 2,1') ,
   (4,'cert_type_3', 'Certification Type 3' 'European Drone Certification Type 3,1') ,
   (5,'cert_type_4', 'Certification Type 4' 'European Drone Certification Type 4,1') ,
   (6,'opt_type_open', 'Operation_type Open' 'European operation type Open,1') ,
   (7,'opt_type_specific', 'Operation_type Specific' 'European operation type Specific,1') ,
   (8,'opt_type_certified', 'Operation_type Certified' 'European operation type Certified,1') ,
   (50,'laanc', 'LAANC Type' 'Low Altitude Authorization and Notification Capability,2') ;</AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t22">
            <Name>volume_limitation_types</Name>
            <Description>Types of limitation that affects to the program logic behavour

INSERT INTO volume_limitation_types (limitation_type_id, name_code)
VALUES
   (1,'boolean_limitation') ,
   (2,'laanc_limitation');</Description>
            <Columns>
                <Column Id="c146">
                    <Name>limitation_type_id</Name>
                    <Type>int</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c147">
                    <Name>name_code</Name>
                    <Type>varchar(50)</Type>
                    <Description>name without spaces, punctuation and symbol characters. Prererible in  snake_case notation</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c146</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter>INSERT INTO volume_limitation_types (limitation_type_id, name_code)
VALUES
   (1,'boolean_limitation') ,
   (2,'laanc_limitation');</AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t26">
            <Name>metadata</Name>
            <Description>Information that qualifies and provides traceability for the Zone operational data. Agregation 1..0 in eurocae data model

Note: used only in ground databases.
</Description>
            <Columns>
                <Column Id="c187">
                    <Name>metada_id</Name>
                    <Type>uuid</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c188">
                    <Name>creation_date_time</Name>
                    <Type>date</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c189">
                    <Name>update_date_time</Name>
                    <Type>date</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c190">
                    <Name>author</Name>
                    <Type>varchar(250)</Type>
                    <Description></Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c187</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter></AdditionalSQLAfter>
            <Properties/>
        </Table>
        <Table Id="t27">
            <Name>authority</Name>
            <Description>A public or private authority that has responsibilities in relation with the authorisation of UAS operations within a Country.

Rule: at least one of the following shall be specified - siteURL, email, phone.
</Description>
            <Columns>
                <Column Id="c192">
                    <Name>authority_oid</Name>
                    <Type>uuid</Type>
                    <Description>This data comes from midpoint. It is the same that the id generated by posgress. (oid midpoint format "04f1a394-861c-4a82-9a13-e14ad5d9d329"  )</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c202">
                    <Name>name</Name>
                    <Type>varchar(250)</Type>
                    <Description>The official name of a public or private authority. Eurocae name "name"</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c203">
                    <Name>service</Name>
                    <Type>varchar(250)</Type>
                    <Description>The name of a specific department or service within the organisation. Eurocae name service</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c204">
                    <Name>contact_name</Name>
                    <Type>varchar(250)</Type>
                    <Description>The name or role of a specific person that needs to be contacted within the organisation. Eurocae name contactName.</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c223">
                    <Name>site_url</Name>
                    <Type>varchar(250)</Type>
                    <Description>The URL of the public internet site through which the organisation may be contacted. Eurocae name siteURL</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c224">
                    <Name>email</Name>
                    <Type>varchar(250)</Type>
                    <Description>The e-mail address by which the organisation may be contacted. Eurocae name email.</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
                <Column Id="c225">
                    <Name>phone</Name>
                    <Type>varchar(250)</Type>
                    <Description>A phone number at which the organisation may be contacted. Eurocae name phone</Description>
                    <Nullable>false</Nullable>
                    <DefaultValue></DefaultValue>
                    <CheckExpression></CheckExpression>
                    <Properties/>
                </Column>
            </Columns>
            <PrimaryKey>
                <Name></Name>
                <Columns>
                    <Column>c192</Column>
                </Columns>
            </PrimaryKey>
            <AlternateKeys/>
            <Indexes/>
            <TableChecks/>
            <AdditionalSQLBefore></AdditionalSQLBefore>
            <AdditionalSQLAfter></AdditionalSQLAfter>
            <Properties/>
        </Table>
    </Tables>
    <Views/>
    <References>
        <Reference Id="r16">
            <Name>airspace_volume_code_vertical_reference</Name>
            <Description></Description>
            <PKTable>t10</PKTable>
            <FKTable>t2</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c65</PKColumn>
                    <FKColumn>c16</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r37">
            <Name>uas_zone_version_time_period</Name>
            <Description></Description>
            <PKTable>t3</PKTable>
            <FKTable>t1</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c25</PKColumn>
                    <FKColumn>c102</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r40">
            <Name>uas_zone_version_airspace_volume</Name>
            <Description></Description>
            <PKTable>t2</PKTable>
            <FKTable>t1</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c20</PKColumn>
                    <FKColumn>c105</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r41">
            <Name>uas_zone_version_code_restriction_type</Name>
            <Description></Description>
            <PKTable>t6</PKTable>
            <FKTable>t1</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c47</PKColumn>
                    <FKColumn>c106</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r42">
            <Name>uas_zone_version_condition_expression_type</Name>
            <Description></Description>
            <PKTable>t7</PKTable>
            <FKTable>t1</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c49</PKColumn>
                    <FKColumn>c107</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r43">
            <Name>uas_zone_version_code_uspace_class_type</Name>
            <Description></Description>
            <PKTable>t8</PKTable>
            <FKTable>t1</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c60</PKColumn>
                    <FKColumn>c108</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r44">
            <Name>uas_zone_version_code_zone_reason</Name>
            <Description></Description>
            <PKTable>t11</PKTable>
            <FKTable>t1</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c70</PKColumn>
                    <FKColumn>c109</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r45">
            <Name>daily_period_time_period</Name>
            <Description></Description>
            <PKTable>t3</PKTable>
            <FKTable>t4</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c25</PKColumn>
                    <FKColumn>c110</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r46">
            <Name>daily_period_code_week_day</Name>
            <Description></Description>
            <PKTable>t9</PKTable>
            <FKTable>t4</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c62</PKColumn>
                    <FKColumn>c111</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r48">
            <Name>layers_geometry_codification</Name>
            <Description></Description>
            <PKTable>t13</PKTable>
            <FKTable>t12</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c78</PKColumn>
                    <FKColumn>c114</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r51">
            <Name>warnings_and_limitations_flight_warnings</Name>
            <Description></Description>
            <PKTable>t17</PKTable>
            <FKTable>t18</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c117</PKColumn>
                    <FKColumn>c123</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r52">
            <Name>uas_zone_version_code_zone_type</Name>
            <Description></Description>
            <PKTable>t5</PKTable>
            <FKTable>t1</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c43</PKColumn>
                    <FKColumn>c124</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r56">
            <Name>volume_limitation_definitions_volume_limitation_types</Name>
            <Description></Description>
            <PKTable>t22</PKTable>
            <FKTable>t21</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c146</PKColumn>
                    <FKColumn>c148</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r58">
            <Name>volume_limitation_volume_limitation_definitions</Name>
            <Description></Description>
            <PKTable>t21</PKTable>
            <FKTable>t16</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c142</PKColumn>
                    <FKColumn>c151</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r59">
            <Name>volume_limitation_uas_zone_version</Name>
            <Description></Description>
            <PKTable>t1</PKTable>
            <FKTable>t16</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c23</PKColumn>
                    <FKColumn>c152</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r60">
            <Name>warnings_and_limitations_volume_limitation_definitions</Name>
            <Description></Description>
            <PKTable>t21</PKTable>
            <FKTable>t18</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c142</PKColumn>
                    <FKColumn>c153</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r61">
            <Name>uas_zone_version_metadata</Name>
            <Description></Description>
            <PKTable>t26</PKTable>
            <FKTable>t1</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c187</PKColumn>
                    <FKColumn>c191</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r62">
            <Name>uas_zone_version_authority</Name>
            <Description></Description>
            <PKTable>t27</PKTable>
            <FKTable>t1</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c192</PKColumn>
                    <FKColumn>c226</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
        <Reference Id="r63">
            <Name>airspace_volume_layers</Name>
            <Description></Description>
            <PKTable>t12</PKTable>
            <FKTable>t2</FKTable>
            <PKRole></PKRole>
            <FKRole></FKRole>
            <ReferenceColumns>
                <ReferenceColumn>
                    <PKColumn>c72</PKColumn>
                    <FKColumn>c227</FKColumn>
                </ReferenceColumn>
            </ReferenceColumns>
            <Cardinality>0..*</Cardinality>
            <Mandatory>true</Mandatory>
            <OnUpdateAction>None</OnUpdateAction>
            <OnDeleteAction>None</OnDeleteAction>
            <Properties/>
        </Reference>
    </References>
    <Sequences/>
    <Notes/>
    <Areas>
        <Area Id="ar1">
            <Name>Agregation</Name>
            <DisplayInfo>
                <X>983.5</X>
                <Y>226.5</Y>
                <Width>842.0</Width>
                <Height>523.0</Height>
                <LineColor>#000000</LineColor>
                <FillColor>#FFE599</FillColor>
                <DashArray>[5,5]</DashArray>
                <NameX>742.83251953125</NameX>
                <NameY>488.0</NameY>
                <NameColor>#000000</NameColor>
                <ZIndex>1</ZIndex>
            </DisplayInfo>
        </Area>
        <Area Id="ar2">
            <Name>CodeLists</Name>
            <DisplayInfo>
                <X>986.0</X>
                <Y>760.0</Y>
                <Width>362.0</Width>
                <Height>378.0</Height>
                <LineColor>#000000</LineColor>
                <FillColor>#A2C4C9</FillColor>
                <DashArray>[5,5]</DashArray>
                <NameX>269.490234375</NameX>
                <NameY>343.0</NameY>
                <NameColor>#000000</NameColor>
                <ZIndex>2</ZIndex>
            </DisplayInfo>
        </Area>
        <Area Id="ar3">
            <Name>Others</Name>
            <DisplayInfo>
                <X>1366.0</X>
                <Y>763.0</Y>
                <Width>463.0</Width>
                <Height>378.0</Height>
                <LineColor>#000000</LineColor>
                <FillColor>#EAD1DC</FillColor>
                <DashArray>[5,5]</DashArray>
                <NameX>394.65283203125</NameX>
                <NameY>343.0</NameY>
                <NameColor>#000000</NameColor>
                <ZIndex>3</ZIndex>
            </DisplayInfo>
        </Area>
        <Area Id="ar4">
            <Name>Not in Eurocae model</Name>
            <DisplayInfo>
                <X>8.5</X>
                <Y>32.5</Y>
                <Width>558.0</Width>
                <Height>1101.0</Height>
                <LineColor>#000000</LineColor>
                <FillColor>#E6B8AF</FillColor>
                <DashArray>[5,5]</DashArray>
                <NameX>383.810546875</NameX>
                <NameY>1066.0</NameY>
                <NameColor>#000000</NameColor>
                <ZIndex>4</ZIndex>
            </DisplayInfo>
        </Area>
        <Area Id="ar5">
            <Name>Eurocae main table</Name>
            <DisplayInfo>
                <X>582.5</X>
                <Y>217.5</Y>
                <Width>388.0</Width>
                <Height>918.0</Height>
                <LineColor>#000000</LineColor>
                <FillColor>#FFFF00</FillColor>
                <DashArray>[5,5]</DashArray>
                <NameX>230.451171875</NameX>
                <NameY>883.0</NameY>
                <NameColor>#000000</NameColor>
                <ZIndex>5</ZIndex>
            </DisplayInfo>
        </Area>
    </Areas>
    <Texts/>
    <TableDisplays>
        <TableDisplay Id="td1">
            <X>608.5</X>
            <Y>408.5</Y>
            <Width>346.0</Width>
            <Height>343.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t1</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td2">
            <X>1011.5</X>
            <Y>269.5</Y>
            <Width>333.0</Width>
            <Height>159.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t2</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td3">
            <X>1025.5</X>
            <Y>445.5</Y>
            <Width>244.0</Width>
            <Height>130.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t3</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td4">
            <X>1317.5</X>
            <Y>443.5</Y>
            <Width>223.0</Width>
            <Height>130.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t4</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td5">
            <X>1002.5</X>
            <Y>777.5</Y>
            <Width>274.0</Width>
            <Height>73.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t5</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td6">
            <X>1011.5</X>
            <Y>880.5</Y>
            <Width>171.0</Width>
            <Height>60.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t6</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td7">
            <X>1400.5</X>
            <Y>854.5</Y>
            <Width>200.0</Width>
            <Height>73.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t7</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td8">
            <X>1013.5</X>
            <Y>957.5</Y>
            <Width>245.0</Width>
            <Height>76.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t8</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td9">
            <X>1597.5</X>
            <Y>445.5</Y>
            <Width>169.0</Width>
            <Height>60.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t9</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td10">
            <X>1429.5</X>
            <Y>244.5</Y>
            <Width>230.0</Width>
            <Height>60.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t10</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td11">
            <X>1014.5</X>
            <Y>1050.5</Y>
            <Width>211.0</Width>
            <Height>73.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t11</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td12">
            <X>20.5</X>
            <Y>41.5</Y>
            <Width>318.0</Width>
            <Height>159.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t12</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td13">
            <X>359.5</X>
            <Y>49.5</Y>
            <Width>189.0</Width>
            <Height>60.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t13</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td16">
            <X>188.5</X>
            <Y>497.5</Y>
            <Width>322.0</Width>
            <Height>100.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t16</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td17">
            <X>279.5</X>
            <Y>292.5</Y>
            <Width>222.0</Width>
            <Height>87.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t17</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td18">
            <X>173.5</X>
            <Y>396.5</Y>
            <Width>331.0</Width>
            <Height>73.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t18</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td21">
            <X>53.5</X>
            <Y>655.5</Y>
            <Width>350.0</Width>
            <Height>108.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t21</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td22">
            <X>87.5</X>
            <Y>815.5</Y>
            <Width>234.0</Width>
            <Height>59.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t22</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td26">
            <X>1063.5</X>
            <Y>616.5</Y>
            <Width>211.0</Width>
            <Height>87.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t26</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
        <TableDisplay Id="td27">
            <X>1322.5</X>
            <Y>607.5</Y>
            <Width>209.0</Width>
            <Height>138.0</Height>
            <LineColor>#000000</LineColor>
            <FillColor>#ffffff</FillColor>
            <Table>t27</Table>
            <FixedSize>false</FixedSize>
        </TableDisplay>
    </TableDisplays>
    <ViewDisplays/>
    <ReferenceDisplays>
        <ReferenceDisplay Id="rd16">
            <Color>#000000</Color>
            <Type>Horizontal_4CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1461.5</X>
                    <Y>280.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>1365.5</X>
                    <Y>280.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>1365.5</X>
                    <Y>338.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>1273.5</X>
                    <Y>338.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td10</PkTableDisplay>
            <FkTableDisplay>td2</FkTableDisplay>
            <Reference>r16</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd37">
            <Color>#000000</Color>
            <Type>Cross_3CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1105.5</X>
                    <Y>456.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>753.5</X>
                    <Y>456.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>753.5</X>
                    <Y>636.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td3</PkTableDisplay>
            <FkTableDisplay>td1</FkTableDisplay>
            <Reference>r37</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd40">
            <Color>#000000</Color>
            <Type>Horizontal_4CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1054.5</X>
                    <Y>279.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>950.5</X>
                    <Y>279.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>950.5</X>
                    <Y>418.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>900.5</X>
                    <Y>418.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td2</PkTableDisplay>
            <FkTableDisplay>td1</FkTableDisplay>
            <Reference>r40</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd41">
            <Color>#000000</Color>
            <Type>Horizontal_4CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1032.5</X>
                    <Y>891.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>889.5</X>
                    <Y>891.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>889.5</X>
                    <Y>636.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>794.5</X>
                    <Y>636.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td6</PkTableDisplay>
            <FkTableDisplay>td1</FkTableDisplay>
            <Reference>r41</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd42">
            <Color>#000000</Color>
            <Type>Horizontal_4CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1444.5</X>
                    <Y>865.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>864.5</X>
                    <Y>865.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>864.5</X>
                    <Y>636.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>720.5</X>
                    <Y>636.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td7</PkTableDisplay>
            <FkTableDisplay>td1</FkTableDisplay>
            <Reference>r42</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd43">
            <Color>#000000</Color>
            <Type>Cross_3CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1048.5</X>
                    <Y>972.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>800.5</X>
                    <Y>972.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>800.5</X>
                    <Y>636.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td8</PkTableDisplay>
            <FkTableDisplay>td1</FkTableDisplay>
            <Reference>r43</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd44">
            <Color>#000000</Color>
            <Type>Cross_3CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1039.5</X>
                    <Y>1062.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>720.5</X>
                    <Y>1062.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>720.5</X>
                    <Y>636.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td11</PkTableDisplay>
            <FkTableDisplay>td1</FkTableDisplay>
            <Reference>r44</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd45">
            <Color>#000000</Color>
            <Type>Horizontal_2CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1212.5</X>
                    <Y>459.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>1367.5</X>
                    <Y>459.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td3</PkTableDisplay>
            <FkTableDisplay>td4</FkTableDisplay>
            <Reference>r45</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd46">
            <Color>#000000</Color>
            <Type>Horizontal_2CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1618.5</X>
                    <Y>455.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>1509.5</X>
                    <Y>455.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td9</PkTableDisplay>
            <FkTableDisplay>td4</FkTableDisplay>
            <Reference>r46</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd48">
            <Color>#000000</Color>
            <Type>Horizontal_4CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>380.5</X>
                    <Y>59.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>455.5</X>
                    <Y>59.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>455.5</X>
                    <Y>142.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>219.5</X>
                    <Y>142.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td13</PkTableDisplay>
            <FkTableDisplay>td12</FkTableDisplay>
            <Reference>r48</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd51">
            <Color>#000000</Color>
            <Type>Vertical_4CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>313.5</X>
                    <Y>302.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>313.5</X>
                    <Y>324.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>235.5</X>
                    <Y>324.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>235.5</X>
                    <Y>406.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td17</PkTableDisplay>
            <FkTableDisplay>td18</FkTableDisplay>
            <Reference>r51</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd52">
            <Color>#000000</Color>
            <Type>Horizontal_4CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1045.5</X>
                    <Y>788.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>915.5</X>
                    <Y>788.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>915.5</X>
                    <Y>636.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>829.5</X>
                    <Y>636.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td5</PkTableDisplay>
            <FkTableDisplay>td1</FkTableDisplay>
            <Reference>r52</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd56">
            <Color>#000000</Color>
            <Type>Vertical_4CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>141.5</X>
                    <Y>844.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>141.5</X>
                    <Y>850.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>133.5</X>
                    <Y>850.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>133.5</X>
                    <Y>743.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td22</PkTableDisplay>
            <FkTableDisplay>td21</FkTableDisplay>
            <Reference>r56</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd58">
            <Color>#000000</Color>
            <Type>Cross_3CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>160.5</X>
                    <Y>684.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>253.5</X>
                    <Y>684.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>253.5</X>
                    <Y>572.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td21</PkTableDisplay>
            <FkTableDisplay>td16</FkTableDisplay>
            <Reference>r58</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd59">
            <Color>#000000</Color>
            <Type>Cross_3CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>674.5</X>
                    <Y>438.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>674.5</X>
                    <Y>572.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>260.5</X>
                    <Y>572.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td1</PkTableDisplay>
            <FkTableDisplay>td16</FkTableDisplay>
            <Reference>r59</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd60">
            <Color>#000000</Color>
            <Type>Cross_3CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>100.5</X>
                    <Y>686.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>100.5</X>
                    <Y>453.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>240.5</X>
                    <Y>453.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td21</PkTableDisplay>
            <FkTableDisplay>td18</FkTableDisplay>
            <Reference>r60</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd61">
            <Color>#000000</Color>
            <Type>Cross_3CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1129.5</X>
                    <Y>676.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>768.5</X>
                    <Y>676.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>768.5</X>
                    <Y>636.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td26</PkTableDisplay>
            <FkTableDisplay>td1</FkTableDisplay>
            <Reference>r61</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd62">
            <Color>#000000</Color>
            <Type>Cross_3CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>1444.5</X>
                    <Y>713.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>1444.5</X>
                    <Y>586.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>747.5</X>
                    <Y>586.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td27</PkTableDisplay>
            <FkTableDisplay>td1</FkTableDisplay>
            <Reference>r62</Reference>
        </ReferenceDisplay>
        <ReferenceDisplay Id="rd63">
            <Color>#000000</Color>
            <Type>Vertical_4CP</Type>
            <ControlPoints>
                <ControlPoint>
                    <X>328.5</X>
                    <Y>86.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>328.5</X>
                    <Y>162.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>1119.5</X>
                    <Y>162.5</Y>
                </ControlPoint>
                <ControlPoint>
                    <X>1119.5</X>
                    <Y>401.5</Y>
                </ControlPoint>
            </ControlPoints>
            <PkTableDisplay>td12</PkTableDisplay>
            <FkTableDisplay>td2</FkTableDisplay>
            <Reference>r63</Reference>
        </ReferenceDisplay>
    </ReferenceDisplays>
    <Properties>
        <Property>
            <Name>pdf-printer-paper-size</Name>
            <Value>A3</Value>
        </Property>
        <Property>
            <Name>pdf-printer-margin-top</Name>
            <Value>10</Value>
        </Property>
        <Property>
            <Name>pdf-printer-margin-bottom</Name>
            <Value>10</Value>
        </Property>
        <Property>
            <Name>pdf-printer-margin-left</Name>
            <Value>10</Value>
        </Property>
        <Property>
            <Name>pdf-printer-margin-right</Name>
            <Value>10</Value>
        </Property>
        <Property>
            <Name>pdf-printer-page-orientation</Name>
            <Value>landscape</Value>
        </Property>
        <Property>
            <Name>pdf-printer-show-pages</Name>
            <Value>false</Value>
        </Property>
        <Property>
            <Name>pdf-printer-include-footer</Name>
            <Value>true</Value>
        </Property>
        <Property>
            <Name>reference-notation</Name>
            <Value>crows-foot</Value>
        </Property>
        <Property>
            <Name>pages-line-color</Name>
            <Value>#CC0000</Value>
        </Property>
        <Property>
            <Name>show-grid</Name>
            <Value>true</Value>
        </Property>
        <Property>
            <Name>grid-color</Name>
            <Value>#D9D9D9</Value>
        </Property>
        <Property>
            <Name>grid-style</Name>
            <Value>solid</Value>
        </Property>
        <Property>
            <Name>grid-spacing</Name>
            <Value>2</Value>
        </Property>
        <Property>
            <Name>grid-spacing-units</Name>
            <Value>cm</Value>
        </Property>
        <Property>
            <Name>grid-subdivisions</Name>
            <Value>1</Value>
        </Property>
    </Properties>
    <DefaultAdditionalProperties>
        <Types>
            <Name>table</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>column</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>alternate_key</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>index</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>table_check</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>trigger</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>reference</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>view</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>sequence</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>procedure</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>all</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>view_column</Name>
            <Properties/>
        </Types>
        <Types>
            <Name>primary_key</Name>
            <Properties/>
        </Types>
    </DefaultAdditionalProperties>
</DatabaseModel>
