EdgeCloudSmartFarm0803

Tables (20)

AUTOMTN_EVENT_HISTORY

  • AUTOMTN_EVENT_HISTORY_SEQ — INTEGER — Primary key — NOT NULL
  • AUTO_CNTRL_EQPMNT_SEQ — INTEGER — Foreign key → AUTO_CNTRL_EQPMNT.AUTO_CNTRL_EQPMNT_SEQ — NOT NULL
  • AUTOMTN_SET_SEQ — INTEGER — Foreign key → AUTO_CNTRL_EQPMNT.AUTOMTN_SET_SEQ — NOT NULL
  • INTGR_NVRNM_CNTR_INFO_SEQ — INTEGER — Foreign key → AUTO_CNTRL_EQPMNT.INTGR_NVRNM_CNTR_INFO_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → AUTO_CNTRL_EQPMNT.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → AUTO_CNTRL_EQPMNT.FARMHS_INFO_SEQ — NOT NULL
  • EVENT_OCCR_TI — DATE
  • EVENT_SCCSS_YN — CHAR(1)
  • Key — Foreign key → AUTO_CNTRL_EQPMNT.Key — NOT NULL

AUTOMTN_SET

  • AUTOMTN_SET_SEQ — INTEGER — Primary key — NOT NULL
  • INTGR_NVRNM_CNTR_INFO_SEQ — INTEGER — Foreign key → INTGR_NVRNM_CNTR_INFO.INTGR_NVRNM_CNTR_INFO_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → INTGR_NVRNM_CNTR_INFO.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → INTGR_NVRNM_CNTR_INFO.FARMHS_INFO_SEQ — NOT NULL
  • AUTOMTN_KND — VARCHAR(8)
  • AUTOMTN_NM — VARCHAR(100)
  • SNSR_KND — VARCHAR(8)
  • SNSR_SET_VAL — INTEGER
  • USE_YN — CHAR(1)
  • REG_DT — VARCHAR(10)
  • REG_ID — VARCHAR(100)
  • Key — Foreign key → INTGR_NVRNM_CNTR_INFO.Key — NOT NULL

AUTO_CNTRL_EQPMNT

  • AUTO_CNTRL_EQPMNT_SEQ — INTEGER — Primary key — NOT NULL
  • AUTOMTN_SET_SEQ — INTEGER — Foreign key → AUTOMTN_SET.AUTOMTN_SET_SEQ — NOT NULL
  • INTGR_NVRNM_CNTR_INFO_SEQ — INTEGER — Foreign key → AUTOMTN_SET.INTGR_NVRNM_CNTR_INFO_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → AUTOMTN_SET.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → AUTOMTN_SET.FARMHS_INFO_SEQ — NOT NULL
  • EQPMNT_INFO_SEQ — INTEGER — Foreign key → EQPMNT_INFO.EQPMNT_INFO_SEQ
  • EQPMNT_CNTL_VAL — INTEGER
  • USE_YN — CHAR(1)
  • REG_DT — VARCHAR(10)
  • REG_ID — VARCHAR(100)
  • Key — Foreign key → AUTOMTN_SET.Key — NOT NULL

CNTRL_HISTORY_INFO

  • CNTRL_HISTORY_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • INTGR_NVRNM_CNTR_INFO_SEQ — INTEGER — Foreign key → USE_EQPMNT_INFO.INTGR_NVRNM_CNTR_INFO_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → USE_EQPMNT_INFO.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → USE_EQPMNT_INFO.FARMHS_INFO_SEQ — NOT NULL
  • USE_EQPMNT_INFO_SEQ — INTEGER — Foreign key → USE_EQPMNT_INFO.USE_EQPMNT_INFO_SEQ — NOT NULL
  • OPDR_RATE — INTEGER
  • DRVMD — VARCHAR(8)
  • SET_TMPR — INTEGER
  • CNTR_TMPR — INTEGER
  • REG_DT — VARCHAR(10)
  • Key — Foreign key → USE_EQPMNT_INFO.Key — NOT NULL

CRPPNG_SSN

  • CRPPNG_SSN_SEQ — INTEGER — Primary key — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → TBL_FARM_INFO.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → TBL_FARM_INFO.FARMHS_INFO_SEQ — NOT NULL
  • KCRP — VARCHAR(288)
  • VRT — VARCHAR(288)
  • PLNTNG_DT — VARCHAR(10)
  • PLNTNG_AMNT — INTEGER
  • PLNTNG_DNST — CHAR(18)
  • SPCMN_CNT — INTEGER
  • HRVST_STRT_DT — VARCHAR(10)
  • HRVST_END_DT — VARCHAR(10)
  • GRWSD_STRT_DT — VARCHAR(10)
  • GRWSD_END_DT — VARCHAR(10)
  • Key — Foreign key → TBL_FARM_INFO.Key — NOT NULL

CRPPNG_SSN_GRTH_ONCE

  • CRPPNG_SSN_GRTH_ONCE_SEQ — CHAR(18) — Primary key — NOT NULL
  • CRPPNG_SSN_SEQ — INTEGER — Foreign key → CRPPNG_SSN.CRPPNG_SSN_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARMHS_INFO_SEQ — NOT NULL
  • SDBRNCH_RMV_YN — CHAR(18)
  • FLWRM_BDDG_DT — CHAR(18)
  • BLMNG_NODE — CHAR(18)
  • FRTSET_NODE — CHAR(18)
  • HRVST_NODE — CHAR(18)
  • FLWRCLSTER_BDDG_DT — CHAR(18)
  • BLMNG_CNT — CHAR(18)
  • AXLRBD_OCCR_DT — CHAR(18)
  • TTL_HRVST_AMNT — CHAR(18)
  • TTL_AVR_FRT_WGHT — CHAR(18)
  • TTL_AVR_SGR_LNGTH — CHAR(18)
  • TTL_AVR_ACDT — CHAR(18)
  • Key — Foreign key → CRPPNG_SSN.Key — NOT NULL

EQPMNT_INFO

  • EQPMNT_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • EQPMNT_NM — VARCHAR(2)
  • EQPMNT_DVSN — VARCHAR(8)
  • EQPMNT_KND — VARCHAR(8)
  • EQPMNT_MDL — VARCHAR(288)
  • MK — VARCHAR(100)

GRNHS_INFO

  • GRNHS_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → TBL_FARM_INFO.FARMHS_INFO_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → TBL_FARM_INFO.FARM_INFO_SEQ — NOT NULL
  • OUT_CVRNG_FLM_YCNT — INTEGER
  • SBSTR_KND — VARCHAR(8)
  • BED_KND — VARCHAR(8)
  • WTR_TYP — VARCHAR(8)
  • HTNG_TYP — VARCHAR(8)
  • KWRM_MTRL — VARCHAR(8)
  • GRNHS_PLMNT_DRCT — VARCHAR(8)
  • GRNHS_HGHT — INTEGER
  • GRNHS_LNGTH — INTEGER
  • GRNHS_WDTH — INTEGER
  • VNTLT_MTHD — VARCHAR(8)
  • Key — Foreign key → TBL_FARM_INFO.Key — NOT NULL

INTGR_NVRNM_CNTR_INFO

  • INTGR_NVRNM_CNTR_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → TBL_FARM_INFO.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → TBL_FARM_INFO.FARMHS_INFO_SEQ — NOT NULL
  • INTGR_NVRNM_CNTR_PRGRM_NM — VARCHAR(50)
  • INTGR_CNTRL_MK — VARCHAR(50)
  • INTGR_CNTRL_TYP — VARCHAR(20)
  • INTGR_CNTRL_MDL — VARCHAR(50)
  • INTGR_CNTRL_LCTN_CD — VARCHAR(8)
  • Key — Foreign key → TBL_FARM_INFO.Key — NOT NULL

MNG_INCM_INFO

  • MNG_INCM_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • CRPPNG_SSN_SEQ — INTEGER — Foreign key → CRPPNG_SSN.CRPPNG_SSN_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARMHS_INFO_SEQ — NOT NULL
  • SALES_INCM — CHAR(18)
  • NTRST_INCM — CHAR(18)
  • SBSD — CHAR(18)
  • SDR_INCM — CHAR(18)
  • REG_DT — CHAR(18)
  • REG_ID — CHAR(18)
  • Key — Foreign key → CRPPNG_SSN.Key — NOT NULL

MNG_XPNS_INFO

  • MNG_XPNS_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • CRPPNG_SSN_SEQ — INTEGER — Foreign key → CRPPNG_SSN.CRPPNG_SSN_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARMHS_INFO_SEQ — NOT NULL
  • SEED_COST — CHAR(18)
  • FRTLZR_COST — CHAR(18)
  • AGCHM_COST — CHAR(18)
  • FARMTL_USE_CHRG — CHAR(18)
  • MNPWR_COST — CHAR(18)
  • MTRL_COST — CHAR(18)
  • ELCTRC_CHRG — CHAR(18)
  • PDDRC_CHRG — CHAR(18)
  • HTNG_CHRG — CHAR(18)
  • PAY_NTRST — CHAR(18)
  • DPRC_COST — CHAR(18)
  • REG_DT — CHAR(18)
  • REG_ID — CHAR(18)
  • Key — Foreign key → CRPPNG_SSN.Key — NOT NULL

SNSR_HISTORY_INFO

  • SNSR_HISTORY_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • INTGR_NVRNM_CNTR_INFO_SEQ — INTEGER — Foreign key → USE_EQPMNT_INFO.INTGR_NVRNM_CNTR_INFO_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → USE_EQPMNT_INFO.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → USE_EQPMNT_INFO.FARMHS_INFO_SEQ — NOT NULL
  • USE_EQPMNT_INFO_SEQ — INTEGER — Foreign key → USE_EQPMNT_INFO.USE_EQPMNT_INFO_SEQ — NOT NULL
  • TMPR — INTEGER
  • HMDT — INTEGER
  • RAIN_AMNT — INTEGER
  • RAIN_SNSING — CHAR(1)
  • SUN_RDT_AMNT — INTEGER
  • INNR_IOR — INTEGER
  • CAG_CNCNT — INTEGER
  • INNR_IOI — INTEGER
  • SHD_LGHT_RATE — INTEGER
  • OUT_DOW — INTEGER
  • OUT_WS — INTEGER
  • Key — Foreign key → USE_EQPMNT_INFO.Key — NOT NULL

TBL_DSS_INFO

  • DSS_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • CRPPNG_SSN_SEQ — INTEGER — Foreign key → CRPPNG_SSN.CRPPNG_SSN_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARMHS_INFO_SEQ — NOT NULL
  • DSS_CD — VARCHAR(8)
  • DSS_TYP — VARCHAR(8)
  • DSS_OCCR_DT — VARCHAR(10)
  • DSS_OCCR_DGR — VARCHAR(255)
  • PSTCNT_DT — VARCHAR(10)
  • PSTCNT_MTHD — VARCHAR(255)
  • PSTCNT_RSLT — VARCHAR(255)
  • REG_DT — VARCHAR(10)
  • REG_ID — VARCHAR(100)
  • Key — Foreign key → CRPPNG_SSN.Key — NOT NULL

TBL_FARMHS_INFO

  • FARMHS_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • FARMHS_CD — VARCHAR(20)
  • FARMHS_TYP — VARCHAR(8)
  • FARMHS_NM_CD — VARCHAR(8)
  • FARMHS_UNQ_NMBR_CD — VARCHAR(8)
  • FARMHS_UNQ_NMBR — VARCHAR(10)
  • FARMHS_CNTCT — VARCHAR(10)
  • FARMHS_REGN_CD_1 — VARCHAR(8)
  • FARMHS_REGN_CD_2 — VARCHAR(8)
  • FARMHS_ZIPCD — VARCHAR(5)
  • FARMHS_ADDR — VARCHAR(255)
  • FARMHS_NM — VARCHAR(100)

TBL_FARM_INFO

  • FARM_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → TBL_FARMHS_INFO.FARMHS_INFO_SEQ — NOT NULL
  • WTHR_FRCST_BRNCH_INFO_SEQ — INTEGER — Foreign key → WTHR_FRCST_BRNCH_INFO.WTHR_FRCST_BRNCH_INFO_SEQ — NOT NULL
  • CLTVTN_PLT_REGN_CD_1 — VARCHAR(2)
  • CLTVTN_PLT_REGN_CD_2 — VARCHAR(3)
  • CLTVTN_PLT_ZIPCD — VARCHAR(5)
  • CLTVTN_PLT_ADDR — VARCHAR(255)
  • CLTVTN_PLT_LCTN_LTTD — FLOAT(9,6)
  • CLTVTN_PLT_LCTN_LNGTD — FLOAT(9,6)
  • CLTVTN_PLT_AREA — INTEGER(10)
  • CLTVTN_FCLTLS_TYP_CD — VARCHAR(8)
  • DATA_SAVE_LCTN — VARCHAR(100)
  • WTHR_DATA_USE_YN — CHAR(1)

TBL_GRTH_INFO

  • GRTH_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • CRPPNG_SSN_SEQ — INTEGER — Foreign key → CRPPNG_SSN.CRPPNG_SSN_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARMHS_INFO_SEQ — NOT NULL
  • PLT_LNGTH — CHAR(18)
  • LEAF_CNT — CHAR(18)
  • LEAF_LNGTH — CHAR(18)
  • LEAF_WDTH — CHAR(18)
  • LEAF_AREA — CHAR(18)
  • GRWNGPT_FLWRCLSTR_DSTN — CHAR(18)
  • GRWNGPT_SHP — CHAR(18)
  • FLWRCLSTR_SHP — CHAR(18)
  • FLWRCLSTR_COLOR — CHAR(18)
  • BLMNG_GRP_CNT — CHAR(18)
  • RFTSET_GRP_CNT — CHAR(18)
  • HRVST_GRP_CNT — CHAR(18)
  • FRTSET_TREE_CNT — CHAR(18)
  • MAX_LEAF_LNGTH — CHAR(18)
  • THCA_DMTR — CHAR(18)
  • FLWRCLSTR_CNT — CHAR(18)
  • STEM_THICK — CHAR(18)
  • FLWRCLSTR_HGHT — CHAR(18)
  • BLMNG_FLWRCLSTR_CNT — CHAR(18)
  • FLW_CNT — CHAR(18)
  • FLL_BLMNG_FLW_CNT — CHAR(18)
  • SPAD — CHAR(18)
  • GRWMNG_LNGTH — CHAR(18)
  • FRT_CNT — CHAR(18)
  • FLWRCLSTR_FLW_CNT — CHAR(18)
  • BLMNG_CNT — CHAR(18)
  • NOT_BLMNG_CNT — CHAR(18)
  • DAY_MRVST_AMNT — CHAR(18)
  • DAY_AVRG_FRT_WGHT — CHAR(18)
  • SGR_CNTNT — CHAR(18)
  • ACDT — CHAR(18)
  • FRT_LNGTH — CHAR(18)
  • FRT_WDTH — CHAR(18)
  • FRT_HGHT — CHAR(18)
  • HRVST_NODE — CHAR(18)
  • REG_DT — CHAR(18)
  • REG_ID — CHAR(18)
  • LEAF_TMPR — CHAR(18)
  • Key — Foreign key → CRPPNG_SSN.Key — NOT NULL

USE_EQPMNT_INFO

  • USE_EQPMNT_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • INTGR_NVRNM_CNTR_INFO_SEQ — INTEGER — Foreign key → INTGR_NVRNM_CNTR_INFO.INTGR_NVRNM_CNTR_INFO_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → INTGR_NVRNM_CNTR_INFO.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → INTGR_NVRNM_CNTR_INFO.FARMHS_INFO_SEQ — NOT NULL
  • EQPMNT_INFO_SEQ — INTEGER — Foreign key → EQPMNT_INFO.EQPMNT_INFO_SEQ — NOT NULL
  • NTRDCTN_DT — VARCHAR(10)
  • USE_YN — CHAR(1)
  • PLMNT_LCTN — VARCHAR(8)
  • PLMNT_GRNHS_SEQ — INTEGER
  • Key — Foreign key → INTGR_NVRNM_CNTR_INFO.Key — NOT NULL

WORK_INFO

  • WORK_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • CRPPNG_SSN_SEQ — INTEGER — Foreign key → CRPPNG_SSN.CRPPNG_SSN_SEQ — NOT NULL
  • FARM_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARM_INFO_SEQ — NOT NULL
  • FARMHS_INFO_SEQ — INTEGER — Foreign key → CRPPNG_SSN.FARMHS_INFO_SEQ — NOT NULL
  • WORK_CD — VARCHAR(8)
  • WORK_STRT_DT — VARCHAR(10)
  • WORK_END_DT — VARCHAR(10)
  • WORK_AMNT — INTEGER
  • MNPWR_NVSTMNT_AMNT — INTEGER
  • REG_DT — VARCHAR(10)
  • REG_ID — VARCHAR(100)
  • Key — Foreign key → CRPPNG_SSN.Key — NOT NULL

WTHR_DATA

  • WTHR_DATA_SEQ — INTEGER — Primary key — NOT NULL
  • NNNCMNT_DT — VARCHAR(10)
  • TMPR — INTEGER
  • HMDT — INTEGER
  • WS — INTEGER
  • DOW — INTEGER
  • 1HOUR_RAIN_AMNT — INTEGER
  • EW_WND_NGRDNT — INTEGER
  • SN_WND_NGRDNT — INTEGER
  • REG_DT — VARCHAR(10)
  • WTHR_FRCST_BRNCH_INFO_SEQ — INTEGER — Foreign key → WTHR_FRCST_BRNCH_INFO.WTHR_FRCST_BRNCH_INFO_SEQ — NOT NULL

WTHR_FRCST_BRNCH_INFO

  • WTHR_FRCST_BRNCH_INFO_SEQ — INTEGER — Primary key — NOT NULL
  • FRCST_XCRDNT — VARCHAR(2)
  • FRCST_YCRDNT — VARCHAR(2)
  • LTTD — FLOAT(9,6)
  • LNGTD — FLOAT(9,6)
  • REGN_CD_1 — VARCHAR(8)
  • REGN_CD_2 — VARCHAR(8)
  • REGN_CD_3 — VARCHAR(8)