tfarm

테이블 (115)

FAQ 테이블 (dbo.GT_FAQ)

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • FAQ_GB — nvarchar(50)
  • TITLE — nvarchar(200)
  • CONTENT — nvarchar(MAX)
  • DISPLAY_ORD — int
  • DELETE_YN — char(1) — NOT NULL

TCP 서버분석 데이터 변동 기록 테이블 (dbo.MAIN_CMD_STAT)

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CMD — varchar(50)
  • SYSTEM_ID — int

dbo.CT_CUSTOMER

  • CUSTOMER_NO — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • FNO — bigint — 외래 키
  • CONTENT — nvarchar(MAX)
  • ATTACH_FILE_PATH1 — nvarchar(400)
  • ATTACH_FILE_NM1 — nvarchar(200)
  • ATTACH_FILE_PATH2 — nvarchar(400)
  • ATTACH_FILE_NM2 — nvarchar(200)
  • ATTACH_FILE_PATH3 — nvarchar(400)
  • ATTACH_FILE_NM3 — nvarchar(200)
  • DELETE_YN — char(1) — NOT NULL

dbo.CT_FARM_ALARM_COUNT

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_YMD — char(10)
  • UPDATE_MNO — bigint
  • SYSTEM_ID — int — NOT NULL
  • EC_MAX — int
  • EC_MIN — int
  • EC_LIMITHIGH — int
  • EC_LIMITLOW — int
  • EC_URGENTHIGH — int
  • EC_URGENTLOW — int
  • PH_MAX — int
  • PH_MIN — int
  • PH_LIMITHIGH — int
  • PH_LIMITLOW — int
  • PH_URGENTHIGH — int
  • PH_URGENTLOW — int
  • CO2_MAX — int
  • CO2_MIN — int
  • CO2_LIMITHIGH — int
  • CO2_LIMITLOW — int
  • CO2_URGENTHIGH — int
  • CO2_URGENTLOW — int
  • TEMP_MAX — int
  • TEMP_MIN — int
  • TEMP_LIMITHIGH — int
  • TEMP_LIMITLOW — int
  • TEMP_URGENTHIGH — int
  • TEMP_URGENTLOW — int
  • HUMIDITY_MAX — int
  • HUMIDITY_MIN — int
  • HUMIDITY_LIMITHIGH — int
  • HUMIDITY_LIMITLOW — int
  • HUMIDITY_URGENTHIGH — int
  • HUMIDITY_URGENTLOW — int
  • ALARM_CHECK_TIMESTAMP — bigint
  • WATER_TEMP_MAX — int
  • WATER_TEMP_MIN — int
  • WATER_TEMP_LIMITHIGH — int
  • WATER_TEMP_LIMITLOW — int
  • WATER_TEMP_URGENTHIGH — int
  • WATER_TEMP_URGENTLOW — int

dbo.CT_FARM_ALARM_LOG

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • CREATE_YMD — char(8)
  • SYSTEM_ID — int
  • EC_VALUE — int
  • PH_VALUE — int
  • CO2_VALUE — int
  • TEMP_VALUE — int
  • HUMIDITY_VALUE — int
  • WATER_TEMP_VALUE — int
  • ALARM_YN — varchar(1) — NOT NULL
  • EC_ALARM_YN — varchar(2)
  • PH_ALARM_YN — varchar(2)
  • CO2_ALARM_YN — varchar(2)
  • TEMP_ALARM_YN — varchar(2)
  • HUMIDITY_ALARM_YN — varchar(2)
  • WATER_TEMP_ALARM_YN — varchar(2)
  • SYSTEM_TIMESTAMP — bigint

dbo.CT_FARM_ALARM_MANAGEMENT

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • SYSTEM_ID — bigint — NOT NULL
  • ENV_TYPE — varchar(100)
  • MANAGEMENT_CONTENT — varchar(1000)
  • ALARM_STOP_HOUR — int
  • MANAGEMENT_DT — datetime
  • ROOT_ALARM_SEQ — bigint
  • CREATE_DT — datetime
  • CREATE_MNO — bigint

dbo.CT_FARM_ALARM_SETTING

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • SYSTEM_ID — bigint — NOT NULL
  • URGENT_SET_TIME — int
  • LIMIT_SET_TIME — int
  • URGENT_ALARMING_YN — char(1)
  • LIMIT_ALARMING_YN — char(1)
  • EC_ALARMING_YN — char(1)
  • PH_ALARMING_YN — char(1)
  • CO2_ALARMING_YN — char(1)
  • TEMP_ALARMING_YN — char(1)
  • HUMIDITY_ALARMING_YN — char(1)
  • WATER_TEMP_ALARMING_YN — char(1)
  • WATER_LEVEL_ALARMING_YN — char(1)
  • PURE_LEVEL_ABC_ALARMING_YN — char(1)
  • STATUS_LOG_RECEIVE_ALARMING_YN — char(1)
  • USE_YN — char(1)
  • CREATE_DT — datetime
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime
  • UPDATE_MNO — bigint

dbo.CT_FARM_ALARM_TIMESTAMP

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • SYSTEM_ID — bigint
  • EC_TIMESTAMP — bigint
  • PH_TIMESTAMP — bigint
  • CO2_TIMESTAMP — bigint
  • TEMP_TIMESTAMP — bigint
  • HUMIDITY_TIMESTAMP — bigint
  • WATER_TEMP_TIMESTAMP — bigint
  • WATER_LEVEL_TIMESTAMP — bigint
  • PURE_LEVEL_ABC_TIMESTAMP — bigint
  • STATUS_LOG_RECEIVE_TIMESTAMP — bigint
  • DEVIATION_ALARM_SEND_TIMESTAMP — bigint
  • SYSTEM_ALARM_SEND_TIMESTAMP — bigint
  • CREATE_DT — datetime
  • UPDATE_DT — datetime

dbo.CT_FARM_CONNECT_EMERGENCY_ALARM

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • CREATE_YMD — char(8)
  • SYSTEM_ID — int — NOT NULL
  • ALARM — tinyint
  • COUNT — bigint
  • APPLY_DT — datetime — NOT NULL
  • APPLY — tinyint
  • ALARM_01 — varchar(1)
  • ALARM_02 — varchar(1)
  • ALARM_04 — varchar(1)
  • ALARM_08 — varchar(1)
  • ALARM_10 — varchar(1)
  • ALARM_20 — varchar(1)
  • ALARM_40 — varchar(1)

dbo.CT_FARM_CONNECT_MAP

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_MNO — bigint
  • FNO — bigint — 외래 키
  • CONNECT_MAP — varchar(5000)
  • CREATE_DT — datetime — NOT NULL

dbo.CT_FARM_CONNECT_SET_LOG_HISTORY

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_MNO — bigint
  • SYSTEM_ID — int
  • APPLY — tinyint
  • APPLY_DT — datetime
  • TEMP — varchar(1000)
  • TEMP_VALUE — int
  • TEMPN_VALUE — int
  • TEMP_DIFF — numeric(5,2)
  • TEMPN_DIFF — numeric(5,2)
  • HUMIDITY — varchar(1000)
  • HUMIDITY_VALUE — int
  • HUMIDITYN_VALUE — int
  • HUMIDITY_DIFF — int
  • HUMIDITYN_DIFF — int
  • TEMP_MIN — int
  • TEMP_MAX — int
  • TEMP_LIMITLOW — int
  • TEMP_LIMITHIGH — int
  • HUMIDITY_MIN — int
  • HUMIDITY_MAX — int
  • HUMIDITY_LIMITLOW — int
  • HUMIDITY_LIMITHIGH — int
  • EC_VALUE — numeric(5,2)
  • EC_DIFF — numeric(5,2)
  • EC_INTERVAL — int
  • EC_DURATION — int
  • EC_COUNT — int
  • EC_MIN — numeric(5,2)
  • EC_MAX — numeric(5,2)
  • EC_LIMITLOW — numeric(5,2)
  • EC_LIMITHIGH — numeric(5,2)
  • PH_VALUE — numeric(5,2)
  • PH_DIFF — numeric(5,2)
  • PH_INTERVAL — int
  • PH_DURATION — int
  • PH_COUNT — int
  • PH_MIN — numeric(5,2)
  • PH_MAX — numeric(5,2)
  • PH_LIMITLOW — numeric(5,2)
  • PH_LIMITHIGH — numeric(5,2)
  • CO2_VALUE — int
  • CO2_DIFF — int
  • CO2_INTERVAL — int
  • CO2_DURATION — int
  • CO2_COUNT — int
  • CO2_MIN — int
  • CO2_MAX — int
  • CO2_LIMITLOW — int
  • CO2_LIMITHIGH — int
  • CO2_STARTTIME_HH — varchar(10)
  • CO2_STARTTIME_MM — varchar(10)
  • CO2_DURATION_HH — varchar(10)
  • CO2_DURATION_MM — varchar(10)
  • LED — varchar(100)
  • LED_STARTTIME_HH — tinyint
  • LED_STARTTIME_MM — tinyint
  • LED_DURATION_HH — tinyint
  • LED_DURATION_MM — tinyint
  • WATER_TEMP_VALUE — int
  • … +44

dbo.CT_FARM_CROP_IMG

  • FARM_CROP_IMG_NO — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • CROP_NO — bigint — 외래 키 → 공통관리 재배작물.CROP_NO
  • RACK_DETAIL_LOCATION — nvarchar(20)
  • SYSTEM_ID — int — NOT NULL
  • PHOTO_DAY — nvarchar(10)
  • SEEDING_DAY — nvarchar(10)
  • IMG_JSON — nvarchar(MAX)
  • DESCRIPTION — nvarchar(MAX)
  • CREATE_MNO — nvarchar(MAX) — NOT NULL
  • UPDATE_MNO — bigint — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL

dbo.CT_FARM_MES

  • SEQ — bigint — 기본 키 — NOT NULL
  • MES_FARM_CODE — varchar(20)
  • MES_FARM_NAME — varchar(20)
  • FNO — bigint — 외래 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • DELETE_YN — char(1) — NOT NULL

dbo.CT_FARM_NEUTRIENT_RENEWAL

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • SYSTEM_ID — bigint — NOT NULL
  • ALARM — varchar(5) — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint — NOT NULL

dbo.CT_FARM_RACK

  • FARM_RACK_NO — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • BATCH_CODE — nvarchar(20)
  • RACK_LOCATION — nvarchar(20)
  • RACK_ROW — int
  • RACK_COLUMN — int
  • POT_COUNT — int
  • GROW_TYPE — nvarchar(20)
  • SYSTEM_ID — bigint — NOT NULL
  • CREATE_MNO — bigint — NOT NULL
  • UPDATE_MNO — bigint — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL

dbo.CT_FARM_RACK_CONNECT

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • RACK_LOCATION — nvarchar(10) — NOT NULL
  • SYSTEM_ID — bigint — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_MNO — bigint
  • DELETE_YN — char(1)

dbo.CT_FARM_SEEDING

  • FARM_SEEDING_NO — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • CROP_NO — bigint — 외래 키 → 공통관리 재배작물.CROP_NO — NOT NULL
  • SEEDING_POT_COUNT — int
  • SEEDING_DAY — varchar(10)
  • TRANSPLANT_DAY — varchar(10)
  • LASTFEED_DAY — varchar(10)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • DELETE_YN — char(1) — NOT NULL
  • CREATE_MNO — bigint — NOT NULL

dbo.CT_FARM_SPECIFICITY_INFORMATION

  • FARM_SPECIFICITY_INFORMATION_NO — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • SPECIFICITY — nvarchar(10)
  • DESCRIPTION — nvarchar(4000)
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint — NOT NULL

dbo.CT_FARM_SPECIFICITY_INFORMATION_TAG

  • SEQ — bigint — 기본 키 — NOT NULL
  • FARM_SPECIFICITY_INFORMATION_NO — bigint — 외래 키 → dbo.CT_FARM_SPECIFICITY_INFORMATION.FARM_SPECIFICITY_INFORMATION_NO — NOT NULL
  • FARM_TAG_NO — bigint — 외래 키 → dbo.CT_FARM_TAG.FARM_TAG_NO — NOT NULL

dbo.CT_FARM_STATUS_MEASURE

  • STATUS_MEASURE_NO — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • SYSTEM_ID — int — NOT NULL
  • EC_VALUE — int
  • EC_MEASURE — int
  • PH_VALUE — int
  • PH_MEASURE — int
  • CO2_VALUE — int
  • CO2_MEASURE — int
  • TEMP_VALUE — int
  • TEMP_MEASURE — int
  • WATER_TEMP_VALUE — int
  • WATER_TEMP_MEASURE — int
  • HUMIDITY_VALUE — int
  • HUMIDITY_MEASURE — int
  • MEASURE_YMD — char(10)
  • AM_PM — char(2)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint — NOT NULL
  • UPDATE_MNO — bigint — NOT NULL

dbo.CT_FARM_TAG

  • FARM_TAG_NO — bigint — 기본 키 — NOT NULL
  • TAG — nvarchar(20)

dbo.CT_FARM_TASK

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키
  • SYSTEM_ID — bigint
  • TASK_CATEGORY_ID — bigint
  • TASK_DETAIL — nvarchar(MAX)
  • TASK_START_DATE — datetime
  • TASK_END_DATE — datetime
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint — NOT NULL
  • UPDATE_MNO — bigint — NOT NULL

dbo.CT_FARM_TASK_CATEGORY

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • TASK_CATEGORY — nvarchar(20)
  • PARENT — int
  • TASK_COLOR — nvarchar(20)

dbo.CT_FARM_YIELD

  • FARM_YIELD_NO — bigint — 기본 키 — NOT NULL
  • FARM_YIELD_PLAN_NO — bigint — 외래 키 → dbo.CT_FARM_YIELD_PLAN.FARM_YIELD_PLAN_NO — NOT NULL
  • YIELD_DAY — varchar(10)
  • GROW_PERIOD — int
  • YIELD_AMOUNT — numeric(18,1)
  • YIELD_POT_COUNT — int
  • YIELD_AVG_WEIGHT — numeric(18,1)
  • YIELD_GRADE — nvarchar(20)
  • ISSUE — nvarchar(4000)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • DELETE_YN — char(1) — NOT NULL
  • CREATE_MNO — bigint — NOT NULL
  • UPDATE_MNO — bigint — NOT NULL

dbo.CT_FARM_YIELD_HISTORY

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • CROP_NO — bigint — 외래 키 → 공통관리 재배작물.CROP_NO — NOT NULL
  • SEEDING_DAY — varchar(20)
  • SEEDLING_DAY — varchar(20)
  • SEEDING_RATE — numeric(18,2)
  • TRANSPLANT_DAY — varchar(20)
  • TRANSPLANT_RATE — numeric(18,2)
  • LASTFEED_DAY — varchar(20)
  • LASTFEED_RATE — numeric(18,2)
  • YIELD_DAY — varchar(20)
  • YIELD_POT_COUNT — int
  • YIELD_AVG_WEIGHT — numeric(18,2)
  • YIELD_AMOUNT — numeric(18,2)
  • YIELD_PLAN_AMOUNT — numeric(18,2)
  • SCRAP_RATE — numeric(18,2)
  • RACK_LOCATION — nvarchar(100)
  • GROW_PERIOD — nvarchar(30)
  • ISSUE — nvarchar(2000)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • DELETE_YN — char(1) — NOT NULL
  • CREATE_MNO — bigint — NOT NULL
  • UPDATE_MNO — bigint — NOT NULL

dbo.CT_FARM_YIELD_PLAN

  • FARM_YIELD_PLAN_NO — bigint — 기본 키 — NOT NULL
  • MANAGEMENT_NO — nvarchar(20)
  • FNO — bigint — 외래 키 — NOT NULL
  • CROP_NO — bigint — 외래 키 → 공통관리 재배작물.CROP_NO — NOT NULL
  • RACK_LOCATION — nvarchar(20)
  • SYSTEM_ID — int — NOT NULL
  • LASTFEED_POT_COUNT — int
  • YIELD_PLAN_AMOUNT — numeric(18,1)
  • SEEDING_DAY — varchar(10)
  • SEEDLING_DAY — varchar(10)
  • TRANSPLANT_DAY — varchar(10)
  • LASTFEED_DAY — varchar(10)
  • YIELD_PLAN_DAY — varchar(10)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • DELETE_YN — char(1) — NOT NULL
  • CREATE_MNO — bigint — NOT NULL
  • UPDATE_MNO — bigint — NOT NULL

dbo.CT_FARM_YIELD_PROCESS

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • MANAGEMENT_NO — varchar(20)
  • CROP_NO — bigint — 외래 키 → 공통관리 재배작물.CROP_NO — NOT NULL
  • SEEDING_DATE — varchar(20)
  • SEEDLING_DATE — varchar(20)
  • TRANSPLANT_DATE — varchar(20)
  • LASTFEED_DATE — varchar(20)
  • SEEDLING_RATE — numeric(18,2)
  • TRANSPLANT_RATE — numeric(18,2)
  • LASTFEED_RATE — numeric(18,2)
  • SEEDING_PANEL_COUNT — numeric(18,2)
  • TRANSPLANT_PANEL_COUNT — numeric(18,2)
  • LASTFEED_PANEL_COUNT — numeric(18,2)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • DELETE_YN — char(1) — NOT NULL
  • CREATE_MNO — bigint — NOT NULL
  • UPDATE_MNO — bigint — NOT NULL

dbo.CT_FARM_YIELD_RESULT

  • SEQ — bigint — 기본 키 — NOT NULL
  • YIELD_PROCESS_SEQ — bigint
  • MANAGEMENT_NO — varchar(20)
  • FNO — bigint — 외래 키 — NOT NULL
  • CROP_NO — bigint — 외래 키 → 공통관리 재배작물.CROP_NO — NOT NULL
  • RACK_LOCATION — nvarchar(100)
  • RACK_ROW — int
  • RACK_COL — int
  • SYSTEM_ID — bigint — NOT NULL
  • YIELD_DATE — varchar(20)
  • YIELD_POT_COUNT — int
  • YIELD_AMOUNT — numeric(18,2)
  • YIELD_PLAN_POT_COUNT — int
  • YIELD_PLAN_AMOUNT — numeric(18,2)
  • DISPOSAL_AMOUNT — numeric(18,2)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • DELETE_YN — char(1) — NOT NULL
  • CREATE_MNO — bigint — NOT NULL
  • UPDATE_MNO — bigint — NOT NULL

dbo.CT_FARM_YIELD_TEMP

  • FARM_YIELD_NO — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • CROP_NO — bigint — 외래 키 → 공통관리 재배작물.CROP_NO — NOT NULL
  • SYSTEM_ID — int — NOT NULL
  • MANAGEMENT_NO — nvarchar(20)
  • RACK_LOCATION — nvarchar(20)
  • RACK_COUNT — int
  • YIELD_DAY — varchar(10)
  • SEEDING_DAY — varchar(10)
  • SEEDLING_DAY — varchar(10)
  • TRANSPLANT_DAY — varchar(10)
  • LASTFEED_DAY — varchar(10)
  • GROW_PERIOD — int
  • YIELD_AMOUNT — numeric(18,1)
  • YIELD_POT_COUNT — int
  • YIELD_AVG_WEIGHT — numeric(18,1)
  • YIELD_GRADE — nvarchar(20)
  • ISSUE — nvarchar(4000)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint — NOT NULL
  • UPDATE_MNO — bigint — NOT NULL

dbo.DEL_CT_FARM_CONNECT_ALARM

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • CREATE_YMD — char(8)
  • SYSTEM_ID — varchar(20) — NOT NULL
  • EC_VALUE — int
  • EC_LIMITHIGH — int
  • PH_VALUE — int
  • PH_LIMITLOW — int
  • CO2_VALUE — int
  • CO2_LIMITLOW — int
  • TEMP_VALUE — int
  • TEMP_LIMITHIGH — int
  • HUMIDITY_VALUE — int
  • HUMIDITY_LIMITHIGH — int
  • ALARM_YN — char(1) — NOT NULL
  • EC_ALARM_YN — char(2)
  • PH_ALARM_YN — char(2)
  • CO2_ALARM_YN — char(2)
  • TEMP_ALARM_YN — char(2)
  • HUMIDITY_ALARM_YN — char(2)
  • WATER_TEMP_VALUE — int
  • WATER_TEMP_LIMITHIGH — int
  • WATER_TEMP_ALARM_YN — char(2)
  • EC_MIN — int
  • EC_MAX — int
  • PH_MIN — int
  • PH_MAX — int
  • CO2_MIN — int
  • CO2_MAX — int
  • HUMIDITY_MIN — int
  • HUMIDITY_MAX — int
  • TEMP_MIN — int
  • TEMP_MAX — int
  • WATER_TEMP_MIN — int
  • WATER_TEMP_MAX — int
  • EC_LIMITLOW — int
  • TEMP_LIMITLOW — int
  • HUMIDITY_LIMITLOW — int
  • WATER_TEMP_LIMITLOW — int
  • PH_LIMITHIGH — int
  • CO2_LIMITHIGH — int

dbo.DEL_CT_MACHINE

  • MACHINE_ID — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • FNO — bigint — 외래 키 — NOT NULL
  • MACHINE_NO — bigint — NOT NULL
  • MACHINE_CD — varchar(20)
  • EQUIP_TYPE_DCD — char(7)
  • EQUIP_TYPE — nvarchar(50)
  • SUB_EQUIP_TYPE — nvarchar(50)
  • MACHINE_NM — nvarchar(200)
  • MACHINE_DETAIL — nvarchar(MAX)
  • DRAWING_X — int
  • DRAWING_Y — int
  • DELETE_YN — char(1) — NOT NULL

dbo.DEL_FT_FARM

  • FNO — bigint — 외래 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • CNO — bigint — NOT NULL
  • FARM_NM — nvarchar(50) — NOT NULL
  • ADDR — nvarchar(200)
  • ADDR_DETAIL — nvarchar(200)
  • ZIPCODE — varchar(10)
  • LAT — varchar(100)
  • LNG — varchar(100)
  • CTPRVN_CD — varchar(2)

dbo.DEL_GA_SESSION_404_LOG

  • SESSION_SEQ — bigint — 기본 키 — NOT NULL
  • SESSION_GUID — nvarchar(500)
  • SESSION_DT — datetime
  • SESSION_YMD — char(8)
  • LOCAL_ADDR — varchar(100)
  • USER_AGENT — varchar(3000)
  • APP_NM — nvarchar(50)
  • APP_VERSION — nvarchar(50)
  • MNO — bigint — 외래 키
  • CLIENTNO — char(18)
  • SNO — bigint
  • HTTP_STATUS_CODE — int
  • HTTP_REFERER — nvarchar(3000)
  • HTTP_METHOD — varchar(10)
  • HTTP_URL — nvarchar(3000)
  • HTTP_QUERY — nvarchar(3000)

dbo.DEL_GA_SESSION_ERROR_LOG

  • SESSION_SEQ — bigint — 기본 키 — NOT NULL
  • SESSION_GUID — nvarchar(500)
  • SESSION_DT — datetime
  • SESSION_YMD — char(8)
  • LOCAL_ADDR — varchar(100)
  • USER_AGENT — varchar(3000)
  • APP_NM — nvarchar(50)
  • APP_VERSION — nvarchar(50)
  • MNO — bigint — 외래 키
  • CLIENTNO — bigint
  • SNO — bigint
  • HTTP_STATUS_CODE — int
  • HTTP_REFERER — nvarchar(3000)
  • HTTP_METHOD — varchar(10)
  • HTTP_URL — nvarchar(3000)
  • HTTP_QUERY — nvarchar(3000)
  • ERROR_CODE — int
  • ERROR_MESSAGE — nvarchar(3000)
  • ERROR_STACK_TRACE — nvarchar(3000)

dbo.DEL_GT_DOMAIN_KSC

  • KSC_YMD — char(8) — 기본 키 — NOT NULL
  • KSC_DT — datetime
  • KSC_UTS — int
  • KSC_YEAR — smallint
  • KSC_HALF — tinyint
  • KSC_QUARTER — tinyint
  • KSC_MONTH — tinyint
  • KSC_WEEK — tinyint
  • KSC_DAY — tinyint
  • KSC_WEEKOFYEAR — smallint
  • KSC_DAYOFYEAR — smallint
  • KSC_DAYOFWEEK — tinyint
  • KSC_MONTH_NM — nvarchar(100)
  • KSC_DAY_NM — nvarchar(100)

dbo.DEL_GT_DOMAIN_KST

  • KST_UTS — int — 기본 키 — NOT NULL
  • KST_DT — datetime
  • KSC_YMD — char(8) — 외래 키 → dbo.DEL_GT_DOMAIN_KSC.KSC_YMD — NOT NULL
  • KST_HOUR — tinyint
  • KST_MINUTE — tinyint
  • KST_HOUR_MINUTE — char(4)
  • KSC_DAYOFWEEK — tinyint

dbo.DEL_GT_EXCEL

  • EXCEL_REVISION — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint — NOT NULL
  • EXCEL_JOB_DCD — char(7) — NOT NULL
  • EXCEL_JOB — nvarchar(50)
  • EXCEL_JOB_YMD — char(8) — NOT NULL
  • EXCEL_FILE_NM — nvarchar(400)

dbo.DEL_LMS_MEMBER_LRN_NOTIFICATION

  • LRN_NOTIFICATION_SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • NOTIFICATION_SET_SEQ — bigint — 외래 키 → dbo.DEL_MT_MEMBER_NOTIFICATION_SET.NOTIFICATION_SET_SEQ
  • LRN_NO — bigint
  • SNO — bigint
  • MNO — bigint — 외래 키
  • NOTI_YMD — char(8)
  • NOTI_HHMM — char(4)
  • NOTI_DT — datetime
  • DELETE_YN — char(1) — NOT NULL

dbo.DEL_LMS_MENU

  • MENU_ID — int — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • MENU_DIVIDER_DCD — char(7)
  • MENU_DIVIDER — nvarchar(50)
  • MENU_NM — nvarchar(200)
  • MENU_DESC — nvarchar(MAX)
  • MENU_LEVEL — int
  • MENU_ORD — int
  • USE_YN — char(1) — NOT NULL
  • DISPLAY_YN — char(1) — NOT NULL
  • PARENT_MENU_ID — int
  • MENU_LINK — nvarchar(400)
  • MENU_ICON — varchar(100)

dbo.DEL_LMS_MENU_PERMISSION

  • MENU_ID — int — 외래 키 → dbo.DEL_LMS_MENU.MENU_ID — NOT NULL
  • PERMISSION_ID — int — 외래 키 → dbo.DEL_LMS_PERMISSION.PERMISSION_ID — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • SET_DISPLAY_YN — char(1) — NOT NULL

dbo.DEL_LMS_PERMISSION

  • PERMISSION_ID — int — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • PERMISSION_NM — nvarchar(200)
  • PERMISSION_ENM — nvarchar(200)
  • PERMISSION_VERB — varchar(200)
  • PERMISSION_DESC — nvarchar(MAX)
  • USE_YN — char(1) — NOT NULL

dbo.DEL_LMS_ROLE_PERMISSION

  • ROLE_DCD — char(7) — 기본 키 — NOT NULL
  • PERMISSION_ID — int — 외래 키 → dbo.DEL_LMS_PERMISSION.PERMISSION_ID — NOT NULL
  • CREATE_DT — datetime — NOT NULL

dbo.DEL_MT_MEMBER_NOTIFICATION_PREFERENCES

  • PREFERENCES_SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • MNO — bigint — 외래 키 — NOT NULL
  • NOTI_ID — bigint — NOT NULL
  • SNO — bigint
  • WEB_RECEIVE_YN — char(1) — NOT NULL
  • EMAIL_RECEIVE_YN — char(1) — NOT NULL
  • PUSH_RECEIVE_YN — char(1) — NOT NULL
  • KAKAO_RECEIVE_YN — char(1) — NOT NULL

dbo.DEL_MT_MEMBER_NOTIFICATION_SET

  • NOTIFICATION_SET_SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • SNO — bigint
  • MNO — bigint — 외래 키
  • NOTIFICATION_RECEIVE_YN — char(1) — NOT NULL
  • WEB_RECEIVE_YN — char(1) — NOT NULL
  • EMAIL_RECEIVE_YN — char(1) — NOT NULL
  • PUSH_RECEIVE_YN — char(1) — NOT NULL
  • KAKAO_RECEIVE_YN — char(1) — NOT NULL
  • NOTI_METHOD_DCD — char(7) — NOT NULL
  • NOTI_METHOD — nvarchar(50)

dbo.GNS_NOTIFICATION_DEVIATION

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • SYSTEM_ID — bigint — NOT NULL
  • NOTI_ID — bigint — 외래 키
  • NOTI_TOPIC — varchar(100)
  • ENV_TYPE — varchar(100)
  • ENV_VALUE — numeric(7,2)
  • ENV_THRESHOLD — numeric(7,2)
  • DEVIATION_LEVEL — varchar(10)
  • SEND_TARGET — varchar(10)
  • ACCUMULATION_COUNT — int
  • ROOT_ALARM_SEQ — bigint
  • MANAGE_YN — char(1)
  • CREATE_DT — datetime

dbo.GNS_NOTIFICATION_SEND_FCM

  • SEND_SEQ — bigint — 기본 키 — NOT NULL
  • THREAD_SEQ — bigint
  • CREATE_DT — datetime
  • CREATE_MNO — bigint — NOT NULL
  • UPDATE_DT — datetime
  • UPDATE_MNO — bigint — NOT NULL
  • RESERV_SEND_YN — char(1)
  • RESERV_SEND_DT — datetime — NOT NULL
  • NOTI_SEND_ST_DCD — char(7) — NOT NULL
  • NOTI_SEND_ST — nvarchar(50)
  • NOTI_SEND_FINISH_DT — datetime
  • NOTI_RECEIVE_DT — datetime
  • NOTI_ID — bigint — 외래 키
  • NOTI_TYPE_DCD — char(7)
  • NOTI_TYPE — nvarchar(50)
  • NOTI_TOPIC — nvarchar(200)
  • NOTIMSG_NO — bigint — 외래 키 — NOT NULL
  • NOTIAPP_NO — bigint — 외래 키 — NOT NULL
  • NOTIAPP_TYPE_DCD — char(7) — NOT NULL
  • NOTIAPP_TYPE — nvarchar(50)
  • MOBILE_OS_DCD — char(7)
  • MOBILE_OS — nvarchar(50)
  • NOTI_PLATFORM_DCD — char(7)
  • NOTI_PLATFORM — nvarchar(50)
  • SENDER_MNO — bigint
  • RECIPIENT_MNO — bigint — NOT NULL
  • RECIPIENT_NM — nvarchar(200)
  • RECIPIENT_NNM — nvarchar(200)
  • RECIPIENT_EMAIL — nvarchar(200)
  • RECIPIENT_DEVICE_UUID — varchar(500)
  • RECIPIENT_DEVICE_TOKEN — varchar(1000)
  • RECIPIENT_PHONE_NO — varchar(20)
  • LANGUAGE_CD — varchar(10)
  • NOTI_TITLE — nvarchar(200) — NOT NULL
  • NOTI_CONTENT — nvarchar(MAX)
  • EMAIL_MERGE_TAG — nvarchar(MAX)
  • CLICK_ACTION — nvarchar(MAX)
  • CLICK_ACTION2 — nvarchar(MAX)
  • SEND_FAILURE_CNT — int

dbo.GNS_NOTIFICATION_SEND_HISTORY_FCM

  • HISTORY_SEQ — bigint — 기본 키 — NOT NULL
  • HISTORY_DT — datetime — NOT NULL
  • SEND_SEQ — bigint — 외래 키 → dbo.GNS_NOTIFICATION_SEND_FCM.SEND_SEQ — NOT NULL
  • NOTI_SEND_ST_DCD — char(7) — NOT NULL
  • NOTI_SEND_ST — nvarchar(50)

dbo.GNS_NOTIFICATION_SEND_QUEUE_FCM

  • QUEUE_SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • SEND_SEQ — bigint — 외래 키 → dbo.GNS_NOTIFICATION_SEND_FCM.SEND_SEQ
  • RESERV_SEND_YN — char(1) — NOT NULL
  • RESERV_SEND_DT — datetime

dbo.GT_API_LOG

  • API_LOG_NO — bigint — 기본 키 — NOT NULL
  • MNO — bigint — 외래 키 — NOT NULL
  • METHOD_TYPE — nvarchar(10)
  • REQUEST_URI — nvarchar(MAX)
  • HEADER_JSON — nvarchar(MAX)
  • REQUEST_BODY — nvarchar(MAX)
  • RESPONSE_BODY — nvarchar(MAX)
  • CREATE_DT — datetime — NOT NULL

dbo.GT_CHEMICAL_FORMULA

  • CHEMICAL_FORMULA_NO — bigint — 기본 키 — NOT NULL
  • CHEMICAL_FORMULA — nvarchar(400)
  • DELETE_YN — char(1) — NOT NULL
  • AMOUNT — char(4) — NOT NULL

dbo.GT_ENVIRONMENT_THRESHOLD

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_YMD — char(10)
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime
  • UPDATE_MNO — bigint
  • FNO — bigint — 외래 키
  • SEED_EC_MAX — numeric(5,2)
  • SEED_EC_MIN — numeric(5,2)
  • SEED_EC_LIMITHIGH — numeric(5,2)
  • SEED_EC_LIMITLOW — numeric(5,2)
  • SEED_EC_URGENTHIGH — numeric(5,2)
  • SEED_EC_URGENTLOW — numeric(5,2)
  • TRANSPLANT_EC_MAX — numeric(5,2)
  • TRANSPLANT_EC_MIN — numeric(5,2)
  • TRANSPLANT_EC_LIMITHIGH — numeric(5,2)
  • TRANSPLANT_EC_LIMITLOW — numeric(5,2)
  • TRANSPLANT_EC_URGENTHIGH — numeric(5,2)
  • TRANSPLANT_EC_URGENTLOW — numeric(5,2)
  • EC_MAX — numeric(5,2)
  • EC_MIN — numeric(5,2)
  • EC_LIMITHIGH — numeric(5,2)
  • EC_LIMITLOW — numeric(5,2)
  • EC_URGENTHIGH — numeric(5,2)
  • EC_URGENTLOW — numeric(5,2)
  • PH_MAX — numeric(5,2)
  • PH_MIN — numeric(5,2)
  • PH_LIMITHIGH — numeric(5,2)
  • PH_LIMITLOW — numeric(5,2)
  • PH_URGENTHIGH — numeric(5,2)
  • PH_URGENTLOW — numeric(5,2)
  • CO2_DAY_MAX — int
  • CO2_DAY_MIN — int
  • CO2_DAY_LIMITHIGH — int
  • CO2_DAY_LIMITLOW — int
  • CO2_DAY_URGENTHIGH — int
  • CO2_DAY_URGENTLOW — int
  • CO2_NIGHT_MAX — int
  • CO2_NIGHT_MIN — int
  • CO2_NIGHT_LIMITHIGH — int
  • CO2_NIGHT_LIMITLOW — int
  • CO2_NIGHT_URGENTHIGH — int
  • CO2_NIGHT_URGENTLOW — int
  • TEMP_DAY_MAX — int
  • TEMP_DAY_MIN — int
  • TEMP_DAY_LIMITHIGH — int
  • TEMP_DAY_LIMITLOW — int
  • TEMP_DAY_URGENTHIGH — int
  • TEMP_DAY_URGENTLOW — int
  • TEMP_NIGHT_MAX — int
  • TEMP_NIGHT_MIN — int
  • TEMP_NIGHT_LIMITHIGH — int
  • TEMP_NIGHT_LIMITLOW — int
  • TEMP_NIGHT_URGENTHIGH — int
  • TEMP_NIGHT_URGENTLOW — int
  • HUMIDITY_DAY_MAX — int
  • HUMIDITY_DAY_MIN — int
  • HUMIDITY_DAY_LIMITHIGH — int
  • HUMIDITY_DAY_LIMITLOW — int
  • HUMIDITY_DAY_URGENTHIGH — int
  • … +14

dbo.GT_ENVIRONMENT_THRESHOLD_LOG

  • SEQ — bigint — 기본 키 — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • UPDAET_MNO — bigint
  • UPDATE_YMD — char(10)
  • FNO — bigint — 외래 키
  • BEFORE_ENVIRONMENT_THRESHOLD — nvarchar(MAX)
  • AFTER_ENVIRONMENT_THRESHOLD — nvarchar(MAX)

dbo.GT_NUTRIENT_SOLUTION

  • NUTRIENT_SOLUTION_NO — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • NUTRIENT_SOLUTION_TYPE_DCD — char(7)
  • NUTRIENT_SOLUTION_TYPE — nvarchar(100)
  • NUTRIENT_SOLUTION_NM — nvarchar(400)
  • NUTRIENT_SOLUTION_DESC — nvarchar(MAX)
  • DELETE_YN — char(1) — NOT NULL

dbo.GT_NUTRIENT_SOLUTION_CHEMICAL_FORMULA

  • SEQ — bigint — 기본 키 — NOT NULL
  • NUTRIENT_SOLUTION_NO — bigint — 외래 키 → dbo.GT_NUTRIENT_SOLUTION.NUTRIENT_SOLUTION_NO — NOT NULL
  • CHEMICAL_FORMULA_NO — bigint — 외래 키 → dbo.GT_CHEMICAL_FORMULA.CHEMICAL_FORMULA_NO — NOT NULL
  • DELETE_YN — char(1) — NOT NULL
  • TANK_TYPE — char(1)
  • INPUT_VOLUME — numeric(7,2)
  • AMOUNT — char(4)

dbo.GT_ROLE_FARM

  • ROLE_DCD — char(7) — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL

dbo.GT_SYSTEM_ID_BLACK_LIST

  • SEQ — bigint — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • SYSTEM_ID — int — NOT NULL

dbo.MAIN_STATUSLOG_JSON

  • SEQ — bigint — 기본 키 — NOT NULL
  • HEADER_JSON — nvarchar(MAX) — NOT NULL
  • STATUS_LOG_JSON — nvarchar(MAX) — NOT NULL
  • CREATE_DT — datetime — NOT NULL

dbo.MAIN_STATUSLOG_NEW

  • SEQ — int — 기본 키 — NOT NULL
  • IPADDRESS — varchar(20)
  • SUBMIT_DT — datetime
  • SETFROM — varchar(1)
  • SYSTEM_DT — datetime
  • SYSTEM_ID — int
  • PH_VALUE — int
  • EC_VALUE — int
  • CO2_VALUE — numeric(8,2)
  • TEMP_VALUE — int
  • WATER_TEMP_VALUE — int
  • HUMIDITY_VALUE — int
  • WATER_LEVEL — varchar(3)
  • WATER_LEVEL_SOLENOID — varchar(1)
  • WATER_LEVEL_MAIN — varchar(10)
  • PURE_LEVEL_AB — varchar(1)
  • PURE_LEVEL_C — varchar(1)
  • PURE_LEVEL_D — varchar(1)
  • FAN — varchar(1)
  • AIRFAN — varchar(1)
  • LED — varchar(1)
  • CO2_STATUS — varchar(1)
  • UVLAMP — varchar(1)
  • ETC — nvarchar(100)
  • ALARM — int
  • ALARM_01 — varchar(1)
  • ALARM_02 — varchar(1)
  • ALARM_04 — varchar(1)
  • ALARM_08 — varchar(1)
  • ALARM_10 — varchar(1)
  • ALARM_20 — varchar(1)
  • ALARM_40 — varchar(1)
  • SYSTEM_YMD — char(8)
  • SYSTEM_TIMESTAMP — bigint

dbo.MAIN_STATUSLOG_V1

  • SEQ — int — 기본 키 — NOT NULL
  • IPADDRESS — varchar(20)
  • SUBMIT_DT — datetime
  • SETFROM — varchar(1)
  • SYSTEM_DT — datetime
  • SYSTEM_ID — int
  • EXPAND — varchar(1)
  • PH_VALUE — int
  • EC_VALUE — int
  • CO2_VALUE — numeric(8,2)
  • TEMP_VALUE — int
  • HUMIDITY_VALUE — int
  • WATER_LEVEL — varchar(3)
  • WATER_LEVEL_SOLENOID — varchar(1)
  • WATER_LEVEL_MAIN — varchar(10)
  • PURE_LEVEL_AB — varchar(1)
  • PURE_LEVEL_C — varchar(1)
  • DOOR — int
  • FAN — varchar(1)
  • AIRFAN — varchar(1)
  • LED — varchar(1)
  • ALARM — int
  • ALARM_01 — varchar(1)
  • ALARM_02 — varchar(1)
  • ALARM_04 — varchar(1)
  • ALARM_08 — varchar(1)
  • ALARM_10 — varchar(1)
  • ALARM_20 — varchar(1)
  • ALARM_40 — varchar(1)
  • E_PH_VALUE — int
  • E_EC_VALUE — int
  • E_CO2_VALUE — int
  • E_TEMP_VALUE — int
  • E_HUMIDITY_VALUE — int
  • E_WATER_LEVEL — varchar(3)
  • E_WATER_LEVEL_SOLENOID — varchar(1)
  • E_WATER_LEVEL_MAIN — varchar(1)
  • E_PURE_LEVEL_AB — varchar(1)
  • E_PURE_LEVEL_C — varchar(1)
  • E_DOOR — int
  • E_FAN — varchar(1)
  • E_AIRFAN — varchar(1)
  • E_LED — varchar(1)
  • E_ALARM — int
  • E_ALARM_01 — varchar(1)
  • E_ALARM_02 — varchar(1)
  • E_ALARM_04 — varchar(1)
  • E_ALARM_08 — varchar(1)
  • E_ALARM_10 — varchar(1)
  • E_ALARM_20 — varchar(1)
  • E_ALARM_40 — varchar(1)
  • SYSTEM_YMD — char(8)
  • SYSTEM_TIMESTAMP — bigint
  • WATER_TEMP_VALUE — int

dbo.MES_CROP_PROCESS

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • CROP_NO — bigint — 외래 키 → 공통관리 재배작물.CROP_NO — NOT NULL
  • SEEDING_DAYS — int
  • SEEDLING_DAYS — int
  • TRANSPLANT_DAYS — int
  • YIELD_DAYS — int
  • SEEDING_RATE — numeric(18,2)
  • SEEDLING_RATE — numeric(18,2)
  • TRANSPLANT_RATE — numeric(18,2)
  • YIELD_RATE — numeric(18,2)
  • TOTAL_RATE — numeric(18,2)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • DELETE_YN — char(1) — NOT NULL

dbo.MES_PACKING_RESULT

  • SEQ — bigint — 기본 키 — NOT NULL
  • MANAGEMENT_NO — varchar(20)
  • FNO — bigint — 외래 키 — NOT NULL
  • CROP_NO — bigint — 외래 키 → 공통관리 재배작물.CROP_NO
  • GRADE — varchar(10)
  • PACKING_COUNT — int
  • WEIGHT — numeric(10,2)
  • IMAGE — nvarchar(MAX)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • DELETE_YN — char(1) — NOT NULL

dbo.MES_YIELD_ISSUE

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키 — NOT NULL
  • ISSUE_TYPE — varchar(20)
  • DEVIATION_YN — char(1)
  • LOCATION — varchar(20)
  • ISSUE_DATE — varchar(20)
  • ISSUE_TITLE — nvarchar(MAX)
  • ISSUE_CONTENT — nvarchar(MAX)
  • PICTURE_URL_JSON — nvarchar(MAX)
  • COMMENT_JSON — nvarchar(MAX)
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • DELETE_YN — char(1) — NOT NULL

dbo.MT_MEMBER_CONFIRMATION_TOKEN

  • SEQ — bigint — 기본 키 — NOT NULL
  • EMAIL — nvarchar(100) — NOT NULL
  • CONFIRMATION_TOKEN — nvarchar(100) — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CONFIRM_YN — char(1) — NOT NULL
  • CONFIRM_TYPE — char(1)

dbo.MT_MEMBER_ROLE

  • ROLE_DCD — char(7) — 기본 키 — NOT NULL
  • MNO — bigint — 외래 키 — NOT NULL
  • CREATE_DT — datetime

dbo.TB_AGENT_MSG_LOG

  • MSG_SEQ — bigint — 기본 키 — NOT NULL
  • SERV_NO — bigint — NOT NULL
  • TALK_MSG — varchar(4000)
  • MSG_TITLE — varchar(200)
  • MSG_CONT — varchar(4000)
  • MSG_TYPE — varchar(5) — NOT NULL
  • BACK_TYPE — varchar(5) — NOT NULL
  • RECV_NO — varchar(20) — NOT NULL
  • CALL_NO — varchar(20)
  • PROC_TYPE — varchar(5) — NOT NULL
  • REQ_SEND_DATE — datetime — NOT NULL
  • TMPL_CODE — varchar(20)
  • MSG_IMG_PATH1 — varchar(200)
  • MSG_IMG_PATH2 — varchar(200)
  • MSG_IMG_PATH3 — varchar(200)
  • IMG_PROC_FLAG — varchar(1) — NOT NULL
  • TALK_BTN_NAME — varchar(50)
  • TALK_BTN_URL — varchar(1000)
  • TALK_BTN_LINK1 — varchar(400)
  • TALK_BTN_LINK2 — varchar(400)
  • TALK_BTN_LINK3 — varchar(400)
  • TALK_BTN_LINK4 — varchar(400)
  • TALK_BTN_LINK5 — varchar(400)
  • TALK_IMG_PATH — varchar(200)
  • TALK_IMG_LINK — varchar(400)
  • AGENT_SEND_FLAG — varchar(1) — NOT NULL
  • AGENT_SEND_DATE — datetime
  • RESEND_FLAG — varchar(1)
  • MSG_IMG_SERV_PATH1 — varchar(200)
  • MSG_IMG_SERV_PATH2 — varchar(200)
  • MSG_IMG_SERV_PATH3 — varchar(200)
  • IMG_SEND_DATE — datetime
  • TALK_IMG_SERV_PATH — varchar(200)
  • TALK_IMG_URL — varchar(400)
  • IF_NAME — varchar(100)
  • SEND_AGENT — varchar(20)
  • TALK_RESULT — varchar(10)
  • MSG_RESULT — varchar(10)
  • TALK_REQ_DATE — datetime
  • MSG_REQ_DATE — datetime
  • SEND_SUCCESS_DATE — datetime
  • SEND_CHNL_CODE — varchar(5)
  • REGR_ID — varchar(100) — NOT NULL
  • REGR_DM — datetime — NOT NULL
  • MODER_ID — varchar(100)
  • MODER_DM — datetime

dbo.TB_MAIN_STATUSLOG_EXEC_LOG

  • SEQ — bigint — 기본 키 — NOT NULL
  • FNO — bigint — 외래 키
  • MNO — bigint — 외래 키
  • START_YMD — date
  • END_YMD — date
  • REQUEST_TIME — datetime
  • REQUEST_TIMESTAMP — bigint
  • PROCEDURE_TYPE — nvarchar(10)

dbo.TB_SP_LOG

  • SP_LOG_SEQ — int — 기본 키 — NOT NULL
  • OBJECT_NAME — varchar(100)
  • LOG_TYPE — varchar(20)
  • SQLCMD — varchar(MAX)
  • MODIFIER — varchar(20)
  • MODIFY_DATE — datetime

공지사항 테이블 (dbo.CT_NOTICE)

  • NOTICE_NO — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • NOTICE_TYPE_DCD — char(7) — NOT NULL
  • NOTICE_TYPE — nvarchar(50)
  • FNO — bigint — 외래 키
  • TITLE — nvarchar(200)
  • CONTENT — nvarchar(MAX)
  • REG_MNO — bigint
  • REG_NM — nvarchar(200)
  • VIEW_CNT — int
  • ATTACH_FILE_PATH1 — nvarchar(400)
  • ATTACH_FILE_NM1 — nvarchar(200)
  • ATTACH_FILE_PATH2 — nvarchar(400)
  • ATTACH_FILE_NM2 — nvarchar(200)
  • ATTACH_FILE_PATH3 — nvarchar(400)
  • ATTACH_FILE_NM3 — nvarchar(200)
  • USE_YN — char(1) — NOT NULL
  • DELETE_YN — char(1) — NOT NULL

공통 렉 유형 테이블 (dbo.GT_RACK)

  • RACK_NO — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • RACK_TYPE — nvarchar(50)
  • RACK_GB_DCD — char(7)
  • RACK_GB — nvarchar(50)
  • RACK_NM — nvarchar(50)
  • RACK_UNIT — nvarchar(50)
  • RACK_STANDARDS — numeric(5,2)
  • SEED_PANEL_COUNT — nvarchar(50)
  • TRANSPLANT_PANEL_COUNT — nvarchar(50)
  • LASTFEED_PANEL_COUNT — nvarchar(50)
  • SEED_POT_COUNT — int
  • TRANSPLANT_POT_COUNT — int
  • LASTFEED_POT_COUNT — int
  • DELETE_YN — char(1) — NOT NULL

공통 메뉴 (dbo.GT_MENU)

  • MENU_ID — int — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • UPDATE_DT — datetime — NOT NULL
  • MENU_DIVIDER_DCD — char(7)
  • MENU_DIVIDER — nvarchar(50)
  • MENU_NM — nvarchar(200)
  • MENU_DESC — nvarchar(MAX)
  • MENU_LEVEL — int
  • MENU_ORD — int
  • USE_YN — char(1) — NOT NULL
  • DISPLAY_YN — char(1) — NOT NULL
  • PARENT_MENU_ID — int
  • MENU_LINK — nvarchar(400)
  • MENU_ICON — varchar(100)

공통 메뉴 권한 (dbo.GT_ROLE_MENU)

  • ROLE_DCD — char(7) — 기본 키 — NOT NULL
  • MENU_ID — int — 외래 키 → 공통 메뉴.MENU_ID — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • RW_PERMISSION — nvarchar(2) — NOT NULL

공통 언어 테이블 (사용안함) (dbo.GT_DOMAIN_LANGUAGE)

  • LANGUAGE_CD — varchar(10) — 기본 키 — NOT NULL
  • LANGUAGE_NM — nvarchar(200) — NOT NULL
  • LANGUAGE_KNM — nvarchar(200)
  • NATIVE_NM — nvarchar(200)
  • USE_YN — char(1) — NOT NULL

공통 작물 가격변동 (dbo.GT_CROP_PRICE)

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • CROP_NM — nvarchar(200)
  • DAY_PRICE — int
  • WEEK_PRICE — int
  • YEAR_PRICE — int
  • USE_YN — char(1) — NOT NULL
  • DELETE_YN — char(1) — NOT NULL

공통 지역 날씨 테이블 API (dbo.GT_WEATHER)

  • SEQ — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_YMD — char(8) — NOT NULL
  • CREATE_TM — char(4) — NOT NULL
  • CITY_ID — bigint — NOT NULL
  • SIDO_GB_DCD — char(7) — NOT NULL
  • SIDO_GB — nvarchar(50)
  • WEATHER_ID — bigint — NOT NULL
  • WEATHER_DESC — varchar(100)
  • WEATHER_ICON — varchar(20)
  • TEMP — numeric(5,2)
  • FEEL_LIKE_TEMP — numeric(5,2)
  • MIN_TEMP — numeric(5,2)
  • MAX_TEMP — numeric(5,2)
  • PRESSURE — int
  • HUMIDITY — numeric(5,2)
  • WIND_SPEED — numeric(5,2)

공통 타임존 테이블 (사용안함) (dbo.GT_DOMAIN_TIMEZONE)

  • TIMEZONE_ID — varchar(200) — 기본 키 — NOT NULL
  • COUNTRY_CD — char(2)
  • UTC_OFFSET — int
  • UTC_DST_OFFSET — int

공통 파일 업로드 테이블 (dbo.GT_FILE)

  • FILE_NO — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • FILE_UPLOAD_KEY — nvarchar(400)
  • FILE_PATH — nvarchar(400)
  • FILE_NM — nvarchar(100)
  • FILE_SIZE — bigint

공통관리 장치관리 테이블 (dbo.GT_MACHINE)

  • MACHINE_NO — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • MACHINE_CD — varchar(20)
  • MACHINE_NM — nvarchar(200)
  • EQUIP_TYPE_DCD — char(7) — NOT NULL
  • EQUIP_TYPE — nvarchar(50)
  • SUB_EQUIP_TYPE — nvarchar(50)
  • CTRL_GB_DCD — char(7)
  • CTRL_GB — nvarchar(50)
  • FARM_ELEMENT_DCD — char(7)
  • FARM_ELEMENT — nvarchar(50)
  • SPEC_CD — nvarchar(200)
  • MACHINE_DESC — nvarchar(MAX)
  • MACHINE_PURPOSE — nvarchar(MAX)
  • STOCK_CNT — int
  • PURCHASE_COST — nvarchar(200)
  • SUPPLY_COST — nvarchar(200)
  • PURCHASE_COMPANY — nvarchar(200)
  • MAKER_NM — nvarchar(200)
  • PURCHASE_MANAGER_NM — nvarchar(200)
  • PURCHASE_MANAGER_PHONE_NO — varchar(50)
  • MAIN_MANAGER_NM — nvarchar(200)
  • SUB_MANAGER_NM — nvarchar(200)
  • DELETE_YN — char(1) — NOT NULL

공통관리 재배작물 (dbo.GT_CULTIVATE_CROP)

  • CROP_NO — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • CROP_TYPE_DCD — char(7) — NOT NULL
  • CROP_TYPE — nvarchar(50)
  • CROP_TYPE_EN — nvarchar(200)
  • BASE_NO — bigint — NOT NULL
  • CULTIVATE_ENV_DCD — char(7)
  • CULTIVATE_ENV — nvarchar(50)
  • CROP_NM — nvarchar(200)
  • CROP_NM_EN — nvarchar(200)
  • CROP_CD — varchar(20)
  • CLASSIFICATION — nvarchar(200)
  • SEED1 — nvarchar(200)
  • SEED2 — nvarchar(200)
  • GROW_PERIOD — int
  • STANDARD_WEIGHT — numeric(5,2)
  • MONTH_AVG_OUTPUT — numeric(5,2)
  • SEED_MIN_DAY — int
  • SEED_MEDIAN_DAY — int
  • SEED_MAX_DAY — int
  • TRANSPLANT_MIN_DAY — int
  • TRANSPLANT_MEDIAN_DAY — int
  • TRANSPLANT_MAX_DAY — int
  • LASTFEED_MIN_DAY — int
  • LASTFEED_MEDIAN_DAY — int
  • LASTFEED_MAX_DAY — int
  • HARVEST_RATE — numeric(5,2)
  • DELETE_YN — char(1) — NOT NULL
  • CULTIVATE_ENV_JSON — nvarchar(MAX)
  • NUTRIENT_SOLUTION_NO — bigint

공통관리 재배환경 기준 (dbo.GT_CULTIVATE_ENV_BASE)

  • BASE_NO — bigint — 기본 키 — NOT NULL
  • CREATE_DT — datetime — NOT NULL
  • CREATE_MNO — bigint
  • UPDATE_DT — datetime — NOT NULL
  • UPDATE_MNO — bigint
  • BASE_NM — nvarchar(200) — NOT NULL
  • FARM_CULTIVATE_ENV_DCD — char(7)
  • FARM_CULTIVATE_ENV — nvarchar(50)
  • BASE_DESC — nvarchar(MAX)
  • TEMPERATURE_MIN — numeric(8,2)
  • TEMPERATURE_MEDIAN — numeric(8,2)
  • TEMPERATURE_MAX — numeric(8,2)
  • HUMIDITY_MIN — numeric(8,2)
  • HUMIDITY_MEDIAN — numeric(8,2)
  • HUMIDITY_MAX — numeric(8,2)
  • LIGHT_MIN — numeric(8,2)
  • LIGHT_MEDIAN — numeric(8,2)
  • LIGHT_MAX — numeric(8,2)
  • EC_MIN — numeric(8,2)
  • EC_MEDIAN — numeric(8,2)
  • EC_MAX — numeric(8,2)
  • PH_MIN — numeric(8,2)
  • PH_MEDIAN — numeric(8,2)
  • PH_MAX — numeric(8,2)
  • CO2_MIN — numeric(8,2)
  • CO2_MEDIAN — numeric(8,2)
  • CO2_MAX — numeric(8,2)
  • AIRFLOW_MIN — numeric(8,2)
  • AIRFLOW_MEDIAN — numeric(8,2)
  • AIRFLOW_MAX — numeric(8,2)
  • WATER_TEMPERATURE_MIN — numeric(8,2)
  • WATER_TEMPERATURE_MEDIAN — numeric(8,2)
  • WATER_TEMPERATURE_MAX — numeric(8,2)
  • LIGHT_INTENSITY_MIN — numeric(8,2)
  • LIGHT_INTENSITY_MEDIAN — numeric(8,2)
  • LIGHT_INTENSITY_MAX — numeric(8,2)
  • DELETE_YN — char(1) — NOT NULL

공통코드 테이블 (dbo.GT_DOMAIN)

  • DCD — char(7) — 기본 키 — NOT NULL
  • L10N_EN_DCD_VAL — nvarchar(50)
  • L10N_KO_DCD_VAL — nvarchar(50)
  • L10N_JA_DCD_VAL — nvarchar(50)
  • PDCD — char(7)
  • MASTER_YN — char(1) — NOT NULL
  • USE_YN — char(1) — NOT NULL
  • DISPLAY_ORD — int
  • DB_COLUMN — varchar(50)
  • PARTIAL_CD — varchar(10)
  • ADD_INFO — nvarchar(500)

외 35개 테이블