<?php

$primitiveTypes = array(

  'DEFCATEGORIE' => 'models.CharField(max_length=255',

  'decimalLatitudeDataType' => 'models.FloatField(', #'xs:double [-90,90]',

  'DecimalLatitude' => 'models.FloatField(', #xs:double [-90,90]',

  'decimalLongitudeDataType' => 'models.FloatField(', #xs:double [-180,180]',

  'DecimalLongitude' => 'models.FloatField(', #xs:double [-180,180]',

  'spatialFitDataType' => 'models.FloatField(', #xs:double (0 or >1 or undefined)',

  'FootprintSpatialFit' => 'models.FloatField(', #xs:double (0 or >1 or undefined)',

  'GeodeticDatum' => 'models.CharField(max_length=255',

  'VerbatimCoordinates' => 'models.CharField(max_length=255',

  'VerbatimLatitude' => 'models.CharField(max_length=255',

  'VerbatimLongitude' => 'models.CharField(max_length=255',

  'VerbatimCoordinateSystem' => 'models.CharField(max_length=255',

  'GeoreferenceProtocol' => 'models.CharField(max_length=255',

  'GeoreferenceSources' => 'models.CharField(max_length=255',

  'GeoreferenceVerificationStatus' => 'models.CharField(max_length=255',

  'GeoreferenceRemarks' => 'models.CharField(max_length=255',

  'FootprintWKT' => 'models.CharField(max_length=255',

  'CoordinateUncertaintyInMeters' => 'models.PositiveIntegerField(', #'positiveInteger',

  'PointRadiusSpatialFit' => 'models.FloatField(', #'xs:double (0 or >1 or undefined)',

  'PERCENT' => 'models.FloatField(', #'xsd:decimal [0,100]',

  'RoleType' => 'models.CharField(max_length=255',

  'TaxonomicRankEnum' => 'models.CharField(max_length=255',

  'TINYINT' => 'models.FloatField(', #'xsd:decimal [-128,128]',

  'yearDate' => 'models.DateField(', #'xs:gYear xs:date (union of)',

  'anyType' => 'models.TextField(', #'xsd:anyType',

  'InlineType' => 'models.TextField(', #'xs:anyType',

  'date' => 'models.DateField(', #'xsd:date',

  'anyURI' => 'models.CharField(max_length=255', #'xs:anyURI',

  'boolean' => 'models.NullBooleanField(',

  'token' => 'models.CharField(max_length=255',

  'language' => 'models.CharField(max_length=255',

  'decimal' => 'models.FloatField(', #'xsd:decimal',

  'gYear' => 'models.DateField(', #'xsd:gYear',

  'string' => 'models.CharField(max_length=255',

  'permission' => 'models.CharField(max_length=255',

  'positiveInteger' => 'models.PositiveIntegerField(', #'xs:positiveInteger',

  'time' => 'models.TimeField(', #'xs:time',

  'double' => 'models.FloatField(', #'xs:double',

  'integer' => 'models.IntegerField(', #'xs:integer',

  'Name' => 'models.CharField(max_length=255', #'xs:Name',

  'NMTOKEN' => 'models.CharField(max_length=255', #'xs:NMTOKEN',

  'DateTimeISO' => 'models.CharField(max_length=255',

  'dayOfYearDataType' => 'models.IntegerField(', #'xs:integer',

  'DescriptorType' => 'models.CharField(max_length=255',

  'FunctionType' => 'models.CharField(max_length=255',

  'GRingType' => 'models.TextField(', #'xs:anyType',

  'IDType' => 'models.CharField(max_length=255',

  'KeyTypeCode' => 'models.CharField(max_length=255',

  'MEDIUMINT' => 'models.FloatField(', #'xs:decimal',

  'NomenclaturalCodesEnum' => 'models.CharField(max_length=255', #'xsd:Name',

  'NomenclaturalTypeStatusOfUnitsEnum' => 'models.CharField(max_length=255', #'xsd:Name',

  'positiveDouble' => 'models.FloatField(', #'xs:double',

  'probabilityType' => 'models.FloatField(', #'xs:double',

  'ScopeType' => 'models.CharField(max_length=255',

  'SMALLINT' => 'models.FloatField(', #'xs:decimal',

  'STRATUMINDEX' => 'models.CharField(max_length=255',

  'SystemType' => 'models.CharField(max_length=255',

  'TaxonomicRankAboveSuperfamilyEnum' => 'models.CharField(max_length=255', #'xsd:Name',

  'TaxonomicRankBelowSubspeciesEnum' => 'models.CharField(max_length=255', #'xsd:Name',

  'TaxonomicRankCultivatedPlants' => 'models.CharField(max_length=255', #'xsd:Name',

  'TaxonomicRankFamilyGroupEnum' => 'models.CharField(max_length=255', #'xsd:Name',

  'TaxonomicRankFamilySubdivisionEnum' => 'models.CharField(max_length=255', #'xsd:Name',

  'TaxonomicRankGenusGroupEnum' => 'models.CharField(max_length=255', #'xsd:Name',

  'TaxonomicRankGenusSubdivisionEnum' => 'models.CharField(max_length=255', #'xsd:Name',

  'TaxonomicRankSpeciesGroupEnum' => 'models.CharField(max_length=255', #'xsd:Name',

);

$ignoreTypes = array(

  "description"         => true,

  "example"             => true,

  "moduleDescription"   => true,

  "moduleDocs"          => true,

  "moduleName"          => true,

  "recommendedUsage"    => true,

  "standAlone"          => true,

  "summary"             => true,

  "tooltip"             => true,

  "annotation"          => true,

  "appinfo"             => true,

  "documentation"       => true,

  "import"              => true,

  "include"             => true,

  "schema"              => true,

  "AdditionalAbbreviations" => true,

  "BacteriaStatus"          => true,

  "BioCodeStatus"           => true,

  "BotanyStatus"            => true,

  "li"                      => true,

  "p"                       => true,

  "para"                    => true,

  "PreferredAbbreviation"   => true,

  "section"                 => true,

  "Specification"           => true,

  "SuffixAlgae"             => true,

  "SuffixAnimalia"          => true,

  "SuffixBacteriae"         => true,

  "SuffixFungi"             => true,

  "SuffixFungi"             => true,

  "SuffixPlantae"           => true,

  "title"                   => true,

  "ul"                      => true,

  "#text"                   => true,

  "#comment"                => true,

  "ZoologyStatus"           => true

);

$knownAttributes = array(

  "minOccurs" => True,

  "maxOccurs" => True,

  "default"   => True,

  "use"       => True,

  "mixed"     => True,

  "name"      => True,

  "type"      => True,

  "namespace" => True,

  "ref"       => True,

  "nillable"  => True,

  "base"      => True,

  #not sure about what to do with these, probably nothing

  "processContents"  => True

);

$geoSpatialTypes = array(

  "GRingPointType" => array(

                            'colDef' => 'gRingPoint = models.PointField(null=True,blank=True)',

                            'importDef' => 

                            "  if self.gRingLatitude != None and self.gRingLongitude != None:\n".

                            "      self.gRingPoint = Point(float(self.gRingLatitude),float(self.gRingLongitude))"

                           ),

  "geospatialType" => array(

                            'colDef' => 'decimalPoint = models.PointField(null=True,blank=True)',

                            'importDef' => 

                            "  if self.geospatialType_DecimalLatitude != None and self.geospatialType_DecimalLongitude != None:\n".

                            "      self.decimalPoint = Point(float(self.geospatialType_DecimalLatitude),float(self.geospatialType_DecimalLongitude))"

                           )

);

$manyToManyRelationships = array(

  'AccessType' => array( 'AccessRule' => true ),

  'ParagraphType' => array( 'ListType' => true,

                            'SubSuperScriptType' => true ),

  'listitem' => array( 'ListType' => true ),

  'SubSuperScriptType' => array( 'SubSuperScriptType' => true ),

  'ScientificName' => array( 'NomenclaturalNoteType' => true ),

  'ResourceGroup' => array( 'ResponsibleParty' => true )

);

$indexableCols = array(

  "attributeID" => True,

  "attr_id" => True,

  "citationID" => True,

  "contributorID" => True,

  "coverTypeAttributeID" => True,

  "individualOrganismID" => True,

  "methodID" => True,

  "partyID" => True,

  "plotObservationID" => True,

  "plotUniqueIdentifierID" => True,

  "protocolID" => True,

  "qualityAssessmentMethodID" => True,

  "referenceCitationID" => True,

  "relatedItemID" => True,

  "relatedPlotID" => True,

  "stratumID" => True,

  "stratumObservationID" => True,

  "taxonConceptID" => True,

  "taxonNameID" => True,

  "taxonNameUsageConceptID" => True,

  "vegetationComponentAttributeID" => True,

  "plotUniqueIdentifier" => True,

  "plotUniqueIdentifierID" => True

);

//Unfortunately Django doesn't support composite keys which is what would be necessary to add these

//FK constraints.  This is because multiple vegx instances will have the same ids for the same nodes

//(e.g. many VegX documents will have AttributeType nodes with the same id attribute.  This is 

//somewhat by design).  We would need to link by attr_id AND entryInfo.  Another option would be to

//store and manage all possible values (attributes, methods, citations, etc.) in BIEN.

$nativeVegXPointers = array(

/*

  "attributeID" => array(

      'def' => "models.ForeignKey('AttributeType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'AttributeType'

  ),

  "citationID" => array(

      'def' => "models.ForeignKey('CitationType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'CitationType'

  ),

// Not sure  "contributorID" => "models.ForeignKey('ResponsibleParty', to_field='',null=True, blank=True, db_index=True) #internal key",

  "coverTypeAttributeID" => array(

      'def' => "models.ForeignKey('AttributeType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'AttributeType'

  ),

  "individualOrganismID" => array(

      'def' => "models.ForeignKey('IndividualOrganismType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'IndividualOrganismType'

  ),

  "methodID" => array(

      'def' => "models.ForeignKey('MethodType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'MethodType'

  ),

  "partyID" => array(

      'def' => "models.ForeignKey('ResponsibleParty', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'ResponsibleParty'

  ),

  "plotObservationID" => array(

      'def' => "models.ForeignKey('ObservationType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'ObservationType'

  ),

  "plotUniqueIdentifierID" => array(

      'def' => "models.ForeignKey('PlotType', to_field='plotUniqueIdentifier',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'plotUniqueIdentifier',

      'fk_type' => 'PlotType'

  ),

  "protocolID" => array(

      'def' => "models.ForeignKey('ProtocolType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'ProtocolType'

  ),

  "qualityAssessmentMethodID" => array(

      'def' => "models.ForeignKey('MethodType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'MethodType'

  ),

  "referenceCitationID" => array(

      'def' => "models.ForeignKey('CitationType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'CitationType'

  ),

// too general, appears to be used to reference *any* other item in the xml document "relatedItemID" => "models.ForeignKey('', to_field='',null=True, blank=True, db_index=True) #internal key",

// not very useful, this pointer doesn't seem to add any info not already in schema  "relatedPlotID" => "models.ForeignKey('', to_field='',null=True, blank=True, db_index=True) #internal key",

  "stratumID" => array(

      'def' => "models.ForeignKey('StratumType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'StratumType'

  ),

  "stratumObservationID" => array(

      'def' => "models.ForeignKey('StratumObservationType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'StratumObservationType'

  ),

  "taxonConceptID" => array(

      'def' => "models.ForeignKey('TaxonConceptType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'TaxonConceptType'

  ),

  "taxonNameID" => array(

      'def' => "models.ForeignKey('ScientificName', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'ScientificName'

  ),

  "taxonNameUsageConceptID" => array(

      'def' => "models.ForeignKey('TaxonNameUsageType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'TaxonNameUsageType'

  ),

  "vegetationComponentAttributeID" => array(

      'def' => "models.ForeignKey('AttributeType', to_field='attr_id',null=True, blank=True, db_index=True) #internal key",

      'to_field' => 'attr_id',

      'fk_type' => 'AttributeType'

  )

*/

);

$tableRenames = array(

  "taxonNamesLC" => "taxonNames",

  "taxonConceptsLC" => "taxonConcepts",

  "temporalCoverageLC" => "temporalCoverage",

  "taxonomicCoverageLC" => "taxonomicCoverage",

  "taxonRelationshipAssertionMapList" => "taxonRelationshipAssertions",

  "taxonRelationshipAssertionMap" => "taxonRelationshipAssertion"

);

?>