CROP_CALENDAR


GRID_NO
(grid number)
NOTNULL NUMBER(8) -
CROP_NO
(crop number)
NOTNULL NUMBER(2) -
VARIETY_NO
(variety number)
NOTNULL NUMBER(4) -
YEAR
(year  campaign started)
NOTNULL NUMBER(4) -
START_TYPE
(the way crop starts)
NOTNULL VARCHAR2(20) -
START_MONTHDAY1
(earliest day in month crop starts)
NOTNULL NUMBER(2) -
START_MONTHDAY2
(latest day in month crop starts -optional)
  NUMBER(2) -
START_MONTH1
(earliest month crop starts)
NOTNULL NUMBER(2) -
START_MONTH2
(latest month crop starts - optional)
  NUMBER(2) -
END_TYPE
(the way a crop ends)
NOTNULL VARCHAR2(20) -
END_MONTHDAY
(day in month crop ends)
NOTNULL NUMBER(2) -
END_MONTH
(month crop ends)
NOTNULL NUMBER(2) -
MAX_DURATION
(maximum duration for crop on field)
NOTNULL NUMBER(3) d