























                                         Designer/2000











                               Report      : ENTITY DEFINITION REPORT



                               Filename    : ckentdef.lis



                               Run by      : DAGOSTIN



                               Report Date : 13-JAN-98  09:31am



                               Total Pages : 13









                          Parameter Values



                          Application System :CLUS3

                          Version            :1

                          Entity Name        :%

                          Diagram            :



                          Entities Created



                                On/After    : 13-JAN-98

                                On/Before   :

                           and



                           Entities Changed

                                On/After    :

                                On/Before   : 13-JAN-98

 13-JAN-98                    Entity Definition                Page  2  of 13











     Entity Name : ATTREZZO_PESCA

     Short Name  : ATTR





     Sub-type of :

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     Rappresenta le diverse tipologie di attrezzi pesca----------------------



        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    ATTREZZO_PESCA                                 N   CHAR         20

    COD_ATTR                                       N   CHAR          5      *



                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



    MAY BE     attrezzi di one or more                   IMBARCAZIONI



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------





























































                        Designer/2000 Report : ckentdef

 13-JAN-98                    Entity Definition                Page  3  of 13











     Entity Name : BLUE_BOX

     Short Name  : BB





     Sub-type of :

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     Rappresenta tutte le informazioni della Blue_Box relative alla ---------

     imbarcazione x (matricola)

     ed alla navigazione y( id_navigazione).



        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    CAMBIO_STATO                                   N   CHAR          1

    COD_BB                                         N   CHAR          5      *



    DATA                                           N   DATE

    METRI_CAVO                                     N   INTEGER       4

    NRO_GIRI_ELICA                                 N   INTEGER       4

    NRO_GIRI_MOT1                                  N   INTEGER       4

    NRO_GIRI_MOT2                                  N   INTEGER       4

    ORARIO                                         N   TIME

    PROFONDITA                                     N   NUMBER        6,1

    TEMP                                           N   NUMBER        2

    XCOORD                                         N   NUMBER        6,1

    YCOORD                                         N   NUMBER        6,1

                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



    MUST BE    Trasferisce a one and only one            GIS_TRASF



    MUST BE    trasmessi a one and only one              NAVIGAZIONE          *



    MUST BE    valore di one and only one                QUERY1_CALCOLO



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------





























                        Designer/2000 Report : ckentdef

 13-JAN-98                    Entity Definition                Page  4  of 13











     Entity Name : DISTRIBUZIONE PRODOTTO

     Short Name  : DIST_PROD





     Sub-type of :

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     Rappresenta la tipologia di distribuzione del prodotto------------------

      per ciascuna impresa



        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    COD_DISTR                                      N   CHAR          5      *



    TIPO_DISTR                                     N   CHAR         12

                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



    MAY BE     distribuito da one or more                IMPRESE



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------

    Ciascun imprenditore/azienda puo' distribuire il prodotto  in 'm'

    modi diversi























































                        Designer/2000 Report : ckentdef

 13-JAN-98                    Entity Definition                Page  5  of 13











     Entity Name : GIS_TRASF

     Short Name  : GT





     Sub-type of :

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     Tale entita' contiene le informazioni relative alla posizione-----------

     geografica di un imbarcazione in un istante t, tale informazione

     verra trasferita al sottosiistema GIS e/o al sottosistema CALCOLO



        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    ID_PUNTO                                       N   CHAR          6      *



    XCOORD                                         N   NUMBER        5,2

    YCOORD                                         N   NUMBER        4,2

                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



    MUST BE    Riceve da one and only one                BLUE_BOX             *



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------























































                        Designer/2000 Report : ckentdef

 13-JAN-98                    Entity Definition                Page  6  of 13











     Entity Name : IMBARCAZIONE

     Short Name  : IMBARC





     Sub-type of :

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     Rappresenta le informazione relative a ciascun imbarcazione-------------



        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    LUNGHEZZA                                      N   INTEGER       5

    MATRICOLA                                      N   CHAR         10      *



    NOME                                           N   CHAR         30

    PORTO_OP                                       N   CHAR         30

    ANNO_COSTR                                     Y   INTEGER       4

    STAZZA_LORDA                                   Y   INTEGER       5

    TONN_UE                                        Y   INTEGER       5

                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



    MAY BE     caratteristica di one or more             NAVIGAZIONI



    MAY BE     possiede one or more                      STRUMENTAZIONI



    MUST BE    e' propieta di one and only one           IMPRESA



    MUST BE    possiede one or more                      ATRREZZI_PESCA



    MUST BE    query su one or more                      QUERY1S



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------



































                        Designer/2000 Report : ckentdef

 13-JAN-98                    Entity Definition                Page  7  of 13











     Entity Name : IMPRESA

     Short Name  : IMPR





     Sub-type of :

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     Rappresenta l'Anagrafica Imprese nella sua accezione piu generale.------

      L' anagrafica si riferisce anche alle Unita di Campionamento.



        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    COD_IMPR                                       N   CHAR          3      *



    COD_UNIMAR                                     N   CHAR          5

    CAP                                            Y   CHAR          5

    CCIAA                                          Y   CHAR         10

    COD_FISCALE                                    Y   CHAR         16

    COMUNE                                         Y   CHAR         30

    DENOMINAZIONE                                  Y   CHAR         30

    FLAG_ASS                                       Y   CHAR          1

    INDIRIZZO                                      Y   CHAR         30

    NRO_REGISTRO                                   Y   CHAR         10

    PROVINCIA                                      Y   CHAR          2

    TIPO_IMPR                                      Y   CHAR          1

                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



    MAY BE     costituita da one or more                 RISORSE



    MAY BE     possiede one or more                      IMBARCAZIONI



    MUST BE    distribuisce % one or more                DISTRIBUZIONI



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------

    L 'impresa e in relazione con  le seguenti entita:

    - ASSOCIAZIONE: descrive il codice UNIMAR dell'azienda in oggetto

    (1:1);

    -























                        Designer/2000 Report : ckentdef

 13-JAN-98                    Entity Definition                Page  8  of 13











     Entity Name : NAVIGAZIONE

     Short Name  : NAVIG





     Sub-type of :

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     Rappresenta le informazioni relative alla navigazione-------------------



        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    DATA_FINE                                      N   DATE

    DATA_INIZIO                                    N   DATE

    ID_NAVIG                                       N   CHAR          5      *



                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



    MAY BE     ricevuti da one or more                   BLUE_BOXE



    MUST BE    navigazione di one and only one           IMBARCAZIONE



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------























































                        Designer/2000 Report : ckentdef

 13-JAN-98                    Entity Definition                Page  9  of 13











     Entity Name : QUERY1_CALCOLO

     Short Name  : QUE





     Sub-type of :

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     --                                   -----------------------------------

        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    ID_QUERY                                       N   CHAR          6      *



    VAL1                                           N   CHAR

    VAL2                                           N   CHAR

    VAL3                                           N   CHAR

                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



    MUST BE    matricola di one and only one             IMBARCAZIONE         *



    MUST BE    query su one and only one                 BLUE_BOX             *



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------























































                        Designer/2000 Report : ckentdef

 13-JAN-98                    Entity Definition                Page  10 of 13











     Entity Name : RISORSA

     Short Name  : RISO





     Sub-type of :

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     Descrive la tipologia di occupati dell'Impresa.-------------------------



        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    COD_RISORSA                                    N   CHAR          5      *



    NOME                                           N   CHAR          1

    NRO_DIP                                        N   INTEGER       3

    MESI_STAG                                      Y   INTEGER       2

    NRO_STAG                                       Y   INTEGER       2

                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



    MUST BE    risorse di one and only one               IMPRESA              *



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------

    Ogni azienda puo' avere diverse tipologie di risorse umane.

     Inoltre per ciascuna tipologia si definisce il numero delle risorse

    umane impegnate, se sono di tipo stagionale, si indichera anche

     il numero di mesi di impegno.















































                        Designer/2000 Report : ckentdef

 13-JAN-98                    Entity Definition                Page  11 of 13











     Entity Name : STRASCICO

     Short Name  : STRASC





     Sub-type of : ATTREZZO_PESCA

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     Rappresenta le informazioni relative alla tipologia di pesca a ---------

     STRASCICO



        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    COD_STRAS                                      N   CHAR          5      *



    MATERIALE                                      N   CHAR          1

    MISURA_ABBORD                                  N   NUMBER        5,2

    MISURA_FILI_SUP                                N   INTEGER       3

    NRO_FILI_SUP                                   N   INTEGER       3

    NRO_PESI_INF                                   N   INTEGER       3

    PESO_ABBORD                                    N   NUMBER        5,1

    PESO_PESI_INF                                  N   NUMBER        5,1

                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------



















































                        Designer/2000 Report : ckentdef

 13-JAN-98                    Entity Definition                Page  12 of 13











     Entity Name : STRUMENTAZIONE

     Short Name  : STRUM





     Sub-type of :

     Initial Volume :                    Average Volume :

     Maximum Volume :                    Annual Growth% :





       Description - has Significance as

     Rappresenta la tipologia di strumentazione presente sull' imbarcazione--



        Attributes

    Name                     -Domain              -Opt-Format    -Length---

    COD_STRUM                                      N   CHAR          1      *



    TIPO_STRUM                                     N   CHAR         12

                              * - Attributes in primary unique identifier

        Relationships

     ---              -----------------------------------------------------

    Each Occurrence Of This Entity :



    MUST BE    strumentazione di one or more             IMBARCAZIONI



                              * - Relationships in primary unique identifier





    --- Notes and Remarks--------------------------------------------------





























































                        Designer/2000 Report : ckentdef





















































                                  Designer/2000



                            ENTITY DEFINITION REPORT



                                 End of Report

