EdgeCloudSmartFarm
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)