Bekæmpelsesmiddeldatabasen

Tabeloversigt ?
Application
EnvironmentalLoadCalculation
Product
ProductFamily
Address
Notification
EnvironmentalLoadInput
PhaseTask
CompanyBillingAddressTemplate
StandardDosage
MinorUse
ProductClassification
User_
Invoice
PhaseTaskTemplate
PhaseTemplateDue
EppoName
Event
ParadigmTemplate
ProductFamilyCollection
Substance
ActiveSubstanceAdditionalInformation
Comment
Phase
ActiveSubstanceExpiration
LoadTax
AdditionalFeeData
CLPDanger
UseEppoRelation
SubstanceRange
ApplicationPrimaryResourceRelation
BasicFeeData
Company
CompanyTypeRelation
ContactPerson
EppoCode
FeeStatement2
File
Hearing
InvoiceLine
NewsLetter
ProductLabel
SavedSearch
Clockstop
CompanyBillingAddressRelation
CompanyBillingAnnualTax
CompanyContactPersonRelation
Use
Metabolite
Mixture
ParadigmTemplateApplicationType
PhaseTemplate
PossibleUse
ResourceType
SalesReport
UserTask
AnnualTax
ApplicationProductGroupPesticide
ApplicationProductType
ApplicationStatus
ApplicationUserTypeBiocide
BasicFee2
ProductFamilyCollectionStatus
ProductFamilyStatus
ProductStatus
SalesReportAccess
Setting
SubstanceMixtureRelation
SystemAccessLog
TaskRemainingTime
ActiveSubstanceBiocideProductGroup
ActiveSubstanceProductGroup
ActiveSubstanceProductType
ApplicationSubstanceRange
ConcernedMemberState
FeeStatementAdditionalFeeDataRelation
GHSHazardPictogramRelation
InvoiceStatus
MemberStateParallelTrade
MemberStateSameBiocidalProduct
MetaboliteCalculation
NewsletterAuthenticationType
NewsletterProductGroupBiocide
NewsletterProductGroupPesticide
NewsletterProductType
ParadigmTemplateApplicationPurpose
PhaseStatus
PhaseTaskStatus
ProductConcernedMemberState
ProductQuantity
RiskPhraseRelation
SpecialUse
UserSettings
ActiveSubstanceActionMechanism
ActiveSubstanceType
AdditionalFee2
ApplicationPriority
ApplicationPurpose
ApplicationStatusType
ApplicationTypeBiocide
ApplicationTypePesticide
AuthenticationType
AuthorizationTypeBiocide
AuthorizationTypePesticide
BarcodeValue
BeeSymbol
CategoryCode
CommentStatus
UserOperation
CompanyType
ContactPersonRole
Country
DKRoleBiocide
DKRolePesticide
EppoRelation
EppoUseEppoRelation
EppoUseRelation
EventOrigin
EventTrigger
FileType
FormulationSubType
FormulationType
FrontPageChoiceType
GeographicalAreaPesticide
GHSHazardPictogram
HazardClass
HazardStatement
HealthEnvironmentalAssesment
IndicationDangerEnvironment
IndicationDangerFlammable
IndicationDangerToxicity
InvoiceStatusType
InvoiceType
LegislationBiocide
LegislationPesticide
LoadTaxUnit
UserAccessType
MemberState
MinorUseStatus
NationalAssessment
NotificationArea
NotificationChannel
NotificationStatus
NotificationTypeEnum
PestControlType
PhaseStatusType
PhaseStep
PhaseTaskStatusType
PhaseTaskUser
PossibleUseBiocide
PossibleUsePesticide
PriorityCategory
ProductApprovalType
ProductFamilyCollectionStatusType
ProductFamilyStatusType
ProductGroupBiocide
ProductGroupPesticide
ProductNature
ProductRisk
ProductStatusType
ProductType
RecipientTypeEnum
ResourceTypeBiocide
ResourceTypePesticide
RiskPhrase
SalesReportAccessProductRelation
UserTaskGroupType
UserType
UserTypeBiocide
SettingType
SignalWord
SpecialUseType
SubstanceType
TaskPriorityType
Unit
EppoUse
ApplicationFormulationSubType
ProductFamilyCollectionFormulationSubType
ProductFamilyCollectionProductType
ProductFamilyCollectionUserType
ProductFamilyFormulationSubType
ProductFamilyProductType
ProductFamilyUserType
AnnualTaxProduct
ApplicationFile
ApplicationFollowers
NotificationFile
ParadigmTemplateBasicFeeCodes
ProductFamilyCollectionSubstanceRange
ProductFamilyMember
ProductFollowers
Tabel

Application


Beskrivelse ?

Ansøgning

Størrelse (Antal rækker) ?

5188

Indhold (Kolonner/variable) ?

Navn Indhold
Id Primary key
PestControlType Bekæmpelsesmiddelstype
LegislationBiocide Regelsæt for biocid
ApplicationPurpose Ansøgningsformål
ApplicationTypeBiocide Ansøgningstype for biocid
ProductNature Produktnatur
DKRoleBiocide DK-rolle for biocid
FormulationSubType Produktformuleringstype
FormulationType Formulering
ProductName Produktnavn
AdditionalTradeNames Yderligere handelsnavne
ProductCode Produktkode
ActiveSubstanceType Aktivstoftype
LegislationPesticide Regelsæt for pesticid
ApplicationTypePesticide Ansægningstype for pesticid
GeographicalAreaPesticide Geografisk område
DKRolePesticide DK-rolle for pesticid
RapporteurMemberState Medlemsland
LegislationForOriginalAuthorisationInOtherMemberState Regelsæt for oprindelig godkendelse i andet medlemsland
MemberStateOriginalAuthorisation Medlemsland for oprindelig godkendelse
ProductGroupBiocide Produktgruppe for biocid
ZoneForOriginalAuthorisation Zone for oprindelig godkendelse
User_ Bruger for pesticid
ReferenceProduct Referenceprodukt for tidligere vurdering
ProductNameInOtherMemberState Produktnavne i andre medlemslande
FeeFileNo Gebyrjournal-nr.
BasicFeeCode Gebyrkode
ExistingProductId FK for reference produkt
ReferenceProductId Referenceprodukt for tidligere vurdering
ApplicationDate Ansøgningsdato
CreatedDate Dato for tilføjelse til database
ExternalId Unik guid
ProductId FK for produkt
DueCalculationDate Forfaldsberegningsdato
ProductFamilyName Produktfamilie navn
ProductFamilyId FK for produktfamilie
ProductRisk Produktrisiko
NationalAssessment Behov for national vurdering
HealthEnvironmentalAssesment Sundheds- eller miljøvurdering
ProductApprovalType Produkt godkendes som
ExistingProductFamilyId FK for produktfamilie
ReferenceFamilyId Referenceproduktfamilie for tidligere vurdering
ProductFamilyCollectionId FK for produktfamiliesamling
ApplicationPriority Prioritet
PriorityCategory Prioriteringskategori
ActiveSubstanceTypeId FK for kodeliste værdi
ApplicationPriorityId FK for kodeliste værdi
ApplicationPurposeId FK for kodeliste værdi
ApplicationTypeBiocideId FK for kodeliste værdi
ApplicationTypePesticideId FK for kodeliste værdi
DKRoleBiocideId FK for kodeliste værdi
DKRolePesticideId FK for kodeliste værdi
FormulationSubTypeId FK for kodeliste værdi
FormulationTypeId FK for kodeliste værdi
GeographicalAreaPesticideId FK for kodeliste værdi
ZoneForOriginalAuthorisationId FK for kodeliste værdi
HealthEnvironmentalAssesmentId FK for kodeliste værdi
LegislationBiocideId FK for kodeliste værdi
LegislationPesticideId FK for kodeliste værdi
LegislationForOriginalAuthorisationInOtherMemberStateId FK for kodeliste værdi
RapporteurMemberStateId FK for kodeliste værdi
MemberStateOriginalAuthorisationId FK for kodeliste værdi
NationalAssessmentId FK for kodeliste værdi
PestControlTypeId FK for kodeliste værdi
PriorityCategoryId FK for kodeliste værdi
ProductApprovalTypeId FK for kodeliste værdi
ProductGroupBiocideId FK for kodeliste værdi
ProductNatureId FK for kodeliste værdi
ProductRiskId FK for kodeliste værdi
UserId FK for kodeliste værdi