Culture

CREATE TABLE [dbo].[Culture](

[cultureID] [int] IDENTITY(1,1) NOT NULL,

[CultureName] [nvarchar](50) NOT NULL,

[Process] [nvarchar](50) NULL,

[Cropspecialist] [nvarchar](50) NULL,

[Requestor] [nvarchar](50) NULL,

[CuttingsOrSeed] [nvarchar](50) NULL,

[EndLocation] [nvarchar](50) NULL,

[StartWeek] [int] NULL,

[StartWeekDeviation] [int] NULL,

[DeliveryWeek] [int] NULL,

[DeliveryWeekDeviation] [int] NULL,

[Purpose] [nvarchar](50) NULL,

[Crop] [nvarchar](50) NULL,

[EntryVariation?] [nvarchar](50) NULL,

[CultureRemarks1] [nvarchar](255) NULL,

[CultureRemarks2] [nvarchar](255) NULL,

[extra] [int] NULL,

[planningGroupID1] [int] NULL,

[extra2] [int] NULL,

[extra3] [int] NULL,

[croptype1] [nvarchar](255) NULL,

[FLS/VEG] [nvarchar](255) NULL,

[Department] [nvarchar](255) NULL,

[subProcess] [nvarchar](255) NULL,

[timeregCode] [nvarchar](255) NULL,

[createdBy] [nvarchar](255) NULL,

[dateCreated] [nvarchar](255) NULL,

CONSTRAINT [aaaaaCulture_PK] PRIMARY KEY NONCLUSTERED

Culture Step:

CREATE TABLE [dbo].[CultureStep](

[CultureStepID] [int] IDENTITY(1,1) NOT NULL,

[CultureID] [int] NULL,

[EntryVarNr] [int] NULL,

[WeekNr] [int] NULL,

[stepordernr] [int] NULL,

[days] [int] NULL,

[plants per entry] [int] NULL,

[plants per fust] [decimal](18, 1) NULL,

[extraM2] [int] NULL,

[fustPerM2(Manual)] [float] NULL,

[SoilType] [nvarchar](255) NULL,

[covering soil] [nvarchar](255) NULL,

[watering] [nvarchar](255) NULL,

[fungicide treatm after sowing] [nvarchar](255) NULL,

[name Fungicide] [nvarchar](255) NULL,

[conc Fungiside] [nvarchar](255) NULL,

[type of Hood] [nvarchar](255) NULL,

[Pincing?] [nvarchar](50) NULL,

[temperature dayNight C] [nvarchar](255) NULL,

[Neg diff] [nvarchar](255) NULL,

[Cold drop] [nvarchar](255) NULL,

[artificial light (y/n)] [nvarchar](255) NULL,

[daylength neutral (yes/no)] [nvarchar](255) NULL,

[daylength] [nvarchar](255) NULL,

[standard PGR treatment?] [nvarchar](255) NULL,

[name PGR] [nvarchar](255) NULL,

[conc PGR] [nvarchar](255) NULL,

[Spraying Schedule PGR] [nvarchar](255) NULL,

[PH] [nvarchar](255) NULL,

[EC] [nvarchar](255) NULL,

[EC in drench water] [nvarchar](255) NULL,

[fertilisation schedule vegetative] [nvarchar](255) NULL,

[fertilisation schedule generative] [nvarchar](255) NULL,

[remarks fertilisation] [nvarchar](255) NULL,

[Common diseases] [nvarchar](255) NULL,

[remarks herbicides] [nvarchar](255) NULL,

[remarks fungicides] [nvarchar](255) NULL,

[prefLocation] [nvarchar](255) NULL,

[year] [int] NULL,

[dummy] [nvarchar](50) NULL,

[plants/hour] [int] NULL,

[EntryFactor] [decimal](18, 2) NULL,

[fustID1] [int] NULL,

[Actionid1] [int] NULL,

[CultureStepNameID1] [int] NULL,

[daynr] [int] NULL,

[endweekmanual] [int] NULL,

[CultureStepRemarks] [nvarchar](255) NULL,

CONSTRAINT [aaaaaCultureStep_PK] PRIMARY KEY NONCLUSTERED

Trial:

CREATE TABLE [dbo].[Trial](

[TrialID] [int] IDENTITY(1,1) NOT NULL,

[TrialCode] [nvarchar](50) NOT NULL,

[ActualNrOfTotalEntries] [int] NULL,

[ActualNrOfEntriesVarNr1] [int] NULL,

[ActualNrOfEntriesVarNr2] [int] NULL,

[ActualNrOfEntriesVarNr3] [int] NULL,

[ActualNrOfEntriesVarNr4] [int] NULL,

[AtualStartweek] [int] NULL,

[PlannedStartWeek] [int] NULL,

[ActualStartYear] [nvarchar](50) NULL,

[CultureID] [int] NULL,

[weekOfTrialrequest] [int] NULL,

[yearOfTrialrequest] [nvarchar](50) NULL,

[remarks1] [nvarchar](200) NULL,

[remarks2] [nvarchar](200) NULL,

[RequestedNrOfTotalEntries] [int] NULL,

[RequestedStartweek] [int] NULL,

[RequestedNrOfEntriesVarNr1] [int] NULL,

[RequestedNrOfEntriesVarNr2] [int] NULL,

[RequestedNrOfEntriesVarNr3] [int] NULL,

[RequestedNrOfEntriesVarNr4] [int] NULL,

[plannedRequest] [nvarchar](255) NULL,

[trialCodeGroup] [nvarchar](255) NULL,

[OrigRequestedNrOfTotalEntries] [int] NULL,

[OrigRequestedStartweek] [int] NULL,

[OrigRequestedNrOfEntriesVarNr1] [int] NULL,

[OrigRequestedNrOfEntriesVarNr2] [int] NULL,

[OrigRequestedNrOfEntriesVarNr3] [int] NULL,

[OrigRequestedNrOfEntriesVarNr4] [int] NULL,

[PlanningAproved] [nvarchar](255) NULL,

[EntryFactorTrial] [float] NULL,

[FirstStepWithEntryFactor] [float] NULL,

[ReasonEntryFactor] [nvarchar](100) NULL,

[RequestedEntryFacorTrial] [float] NULL,

[RequestedFirstStepWithEntryFactor] [float] NULL,

[weekCorrection] [int] NULL,

[StepWCorr] [int] NULL,

[M2Correction] [int] NULL,

[StepM2Corr] [int] NULL,

[fixedDeliveryWeek] [int] NULL,

[createdBy] [nvarchar](255) NULL,

[dateCreated] [nvarchar](255) NULL,

[trialevaluation] [nvarchar](255) NULL,

CONSTRAINT [aaaaaTrial_PK] PRIMARY KEY NONCLUSTERED