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

Product


Beskrivelse ?

Produkt

Størrelse (Antal rækker) ?

19778

Indhold (Kolonner/variable) ?

Navn Indhold
Id Primary key
PestControlType Bekæmpelsesmiddelstype
LegislationBiocide Regelsæt
ProductName Produktnavn
AdditionalTradeNames Yderligere handelsnavne
ProductCode Produktkode
LegislationPesticide Regelsæt
ProductGroupBiocide Produktgrupper
User_ FK for user
RegistrationNumber Registrerings-nr
ReferenceProductId FK for referenceprodukt
SaleDeadline Frist for salg i detailled
UseAndPossessionDeadline Frist for anvendelse og besiddelse
AuthorizationTypePesticide Godkendelse
AuthorizationTypeBiocide Godkendelse
AuthorizationTypeStartDate Godkendelsesdato
AuthorizationTypeEndDate Udløbsdato
TerminationDate Ophørsdato
Published Offentliggjort
ActiveSubstanceType Aktivstoftype
FormulationSubType Produktformuleringstype
FormulationType Formulering
ProductNameInOtherMemberState Produktnavne i andre medlemslande
ProductNature Produktnatur
CaseJournalNo Sagsjournal-nr.
CreatedDate Dato for tilføjelse til database
ExternalId Unik guid
OldId Id for importeret data
TransferOriginProductId Tidligere produkt før overdragelse
TransferDestinationProductId Nuværende produkt efter overdragelse
Terms Vilkår
TermsDate Vilkåropfølgningsdato
FirstAuthorizationTypeStartDate Første godkendelsesdato
EURegistrationNumber EU-registrerings-nr.
PreviousProductNames Tidligere produktnavne
TermsReceived Vilkår modtaget
AssessedUser Bruger
PossessionDeadline Besiddelsesforbud
Cat4Deadline Frist for kategori 4 data
Cat4RMS RMS
Cat4ActiveSubstanceId Kat. 4 aktivstof
ActiveSubstanceTypeId FK for kodeliste værdi
AuthorizationTypeBiocideId FK for kodeliste værdi
AuthorizationTypePesticideId FK for kodeliste værdi
FormulationSubTypeId FK for kodeliste værdi
FormulationTypeId FK for kodeliste værdi
LegislationBiocideId FK for kodeliste værdi
LegislationPesticideId FK for kodeliste værdi
Cat4RMSId FK for kodeliste værdi
PestControlTypeId FK for kodeliste værdi
ProductGroupBiocideId FK for kodeliste værdi
ProductNatureId FK for kodeliste værdi
UserId FK for kodeliste værdi
AssessedUserId FK for kodeliste værdi