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개 테이블