1

테이블 (30)

PLC설정_plc_setting

  • sid — INT — 기본 키 — NOT NULL
  • smart_nursery_id — INT — 외래 키 → 양묘장_smart_nursery.sid — NOT NULL
  • setting_name — VARCHAR(100)
  • setting_value — VARCHAR(255)

묘목상태코드_sapling_status_type

  • sid — INT — 기본 키 — NOT NULL
  • sapling_status_name — VARCHAR(50)

묘목생육일지_sapling_growth_diary

  • sid — INT — 기본 키 — NOT NULL
  • sapling_id — INT — 외래 키 → 하우스묘목_smart_nursery_house_sapling.sid — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT
  • reg_date — DATETIME

묘목종류_sapling_type

  • sid — INT — 기본 키 — NOT NULL
  • sapling_type_name — VARCHAR(50)

사용자_users

  • sid — INT — 기본 키 — NOT NULL
  • id — VARCHAR(45) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • smart_nursery_id — INT — 외래 키 → 양묘장_smart_nursery.sid
  • name — VARCHAR(45) — NOT NULL
  • email — VARCHAR(100)
  • phone_number — VARCHAR(45)
  • user_level_id — INT — 외래 키 → 사용자권한_user_level.sid — NOT NULL
  • last_login — DATETIME
  • reg_date — DATETIME — NOT NULL
  • fcm_token — TEXT

사용자권한_user_level

  • sid — INT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL

설비상태코드_facility_status_type

  • sid — INT — 기본 키 — NOT NULL
  • facility_status_name — VARCHAR(50)

설비설정종류_facility_setting_type

  • sid — INT — 기본 키 — NOT NULL
  • facility_setting_type_name — VARCHAR(50)

설비자동설정_smart_nursery_house_facility_auto_setting

  • sid — INT — 기본 키 — NOT NULL
  • facility_id — INT — 외래 키 → 하우스설비_smart_nursery_house_facility.sid — NOT NULL
  • facility_setting_type_id — INT — 외래 키 → 설비설정종류_facility_setting_type.sid
  • facility_setting_name — VARCHAR(50) — NOT NULL
  • facility_setting_code — VARCHAR(50) — NOT NULL
  • facility_setting_value — VARCHAR(50)

설비종류_facility_type

  • sid — INT — 기본 키 — NOT NULL
  • facility_type_name — VARCHAR(50)

센서상태코드_sensor_status_type

  • sid — INT — 기본 키 — NOT NULL
  • sensor_status_name — VARCHAR(50) — NOT NULL

센서알람기준_smart_nursery_house_sensor_alarm_setting

  • setting_id — INT — 기본 키 — NOT NULL
  • sensor_id — INT — 외래 키 → 하우스센서_smart_nursery_house_sensor.sid — NOT NULL
  • house_id — INT — 외래 키 → 양묘장하우스_smart_nursery_house.sid — NOT NULL
  • alarm_on_off — INT — NOT NULL
  • superemum_value — DOUBLE
  • infimum_value — DOUBLE
  • updated — DATETIME — NOT NULL

센서종류_sensor_type

  • sid — INT — 기본 키 — NOT NULL
  • sensor_name — VARCHAR(50) — NOT NULL

알람종류_alarm_type

  • sid — INT — 기본 키 — NOT NULL
  • alarm_type_name — VARCHAR(50)

알람처리상태_alarm_status_type

  • sid — INT — 기본 키 — NOT NULL
  • alarm_status_name — VARCHAR(50)

양묘일지사진_nursery_diary_images

  • sid — INT — 기본 키 — NOT NULL
  • nursery_diary_id — INT — 외래 키 → 양묘작업일지_nursery_diary.sid — NOT NULL
  • image_path — TEXT

양묘작업일지_nursery_diary

  • sid — INT — 기본 키 — NOT NULL
  • smart_nursery_id — INT — 외래 키 → 양묘장_smart_nursery.sid
  • house_id — INT — 외래 키 → 양묘장하우스_smart_nursery_house.sid
  • title — VARCHAR(200)
  • content — TEXT
  • reg_date — DATETIME

양묘장_smart_nursery

  • sid — INT — 기본 키 — NOT NULL
  • smart_nursery_name — VARCHAR(45) — NOT NULL
  • contact — VARCHAR(45) — NOT NULL
  • address — VARCHAR(255)
  • representative_name — VARCHAR(45)
  • representative_breeds — VARCHAR(100)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • is_deleted — TINYINT(1)
  • status — VARCHAR(45)
  • reg_date — DATETIME — NOT NULL

양묘장하우스_smart_nursery_house

  • sid — INT — 기본 키 — NOT NULL
  • smart_nursery_id — INT — 외래 키 → 양묘장_smart_nursery.sid — NOT NULL
  • house_code — VARCHAR(50)
  • house_name — VARCHAR(50) — NOT NULL
  • house_type_id — INT — 외래 키 → 하우스종류_house_type.sid — NOT NULL
  • latitude — DOUBLE
  • longitude — DOUBLE
  • reg_date — DATETIME — NOT NULL

월별설비데이터_facility_data_log_monthly

  • sid — INT — 기본 키 — NOT NULL
  • facility_id — INT — 외래 키 → 하우스설비_smart_nursery_house_facility.sid — NOT NULL
  • data_value — DOUBLE
  • reg_date — DATETIME — NOT NULL

월별설비알람_alarm_facility_log_monthly

  • sid — INT — 기본 키 — NOT NULL
  • facility_id — INT — 외래 키 → 하우스설비_smart_nursery_house_facility.sid — NOT NULL
  • alarm_type_id — INT — 외래 키 → 알람종류_alarm_type.sid — NOT NULL
  • alarm_status_type_id — INT — 외래 키 → 알람처리상태_alarm_status_type.sid — NOT NULL
  • content — VARCHAR(255)
  • action_result — VARCHAR(255)
  • recover_date — DATETIME
  • input_date — DATETIME
  • result_date — DATETIME

월별센서데이터_sensor_data_log_monthly

  • sid — INT — 기본 키 — NOT NULL
  • sensor_id — INT — 외래 키 → 하우스센서_smart_nursery_house_sensor.sid — NOT NULL
  • data_value — DOUBLE
  • reg_date — DATETIME — NOT NULL

월별센서알람_alarm_sensor_log_monthly

  • sid — INT — 기본 키 — NOT NULL
  • sensor_id — INT — 외래 키 → 하우스센서_smart_nursery_house_sensor.sid — NOT NULL
  • alarm_type_id — INT — 외래 키 → 알람종류_alarm_type.sid — NOT NULL
  • alarm_status_type_id — INT — 외래 키 → 알람처리상태_alarm_status_type.sid — NOT NULL
  • content — VARCHAR(255)
  • action_result — VARCHAR(255)
  • recover_date — DATETIME
  • input_date — DATETIME
  • result_date — DATETIME

하우스묘목_smart_nursery_house_sapling

  • sid — INT — 기본 키 — NOT NULL
  • house_id — INT — 외래 키 → 양묘장하우스_smart_nursery_house.sid — NOT NULL
  • sapling_type_id — INT — 외래 키 → 묘목종류_sapling_type.sid — NOT NULL
  • sapling_status_id — INT — 외래 키 → 묘목상태코드_sapling_status_type.sid — NOT NULL
  • sapling_name — VARCHAR(50) — NOT NULL
  • updated — DATETIME — NOT NULL

하우스배치이미지_smart_nursery_house_image

  • sid — INT — 기본 키 — NOT NULL
  • house_id — INT — 외래 키 → 양묘장하우스_smart_nursery_house.sid — NOT NULL
  • house_image — LONGTEXT — NOT NULL
  • house_x — DOUBLE — NOT NULL
  • house_y — DOUBLE — NOT NULL
  • house_width — DOUBLE — NOT NULL
  • house_height — DOUBLE — NOT NULL
  • house_scale_x — DOUBLE — NOT NULL
  • house_scale_y — DOUBLE — NOT NULL
  • updated — DATETIME — NOT NULL

하우스설비_smart_nursery_house_facility

  • sid — INT — 기본 키 — NOT NULL
  • house_id — INT — 외래 키 → 양묘장하우스_smart_nursery_house.sid — NOT NULL
  • facility_code — VARCHAR(50)
  • facility_type_id — INT — 외래 키 → 설비종류_facility_type.sid — NOT NULL
  • facility_status_id — INT — 외래 키 → 설비상태코드_facility_status_type.sid — NOT NULL
  • facility_name — VARCHAR(50)
  • facility_x — DOUBLE
  • facility_y — DOUBLE
  • updated — DATETIME — NOT NULL

하우스센서_smart_nursery_house_sensor

  • sid — INT — 기본 키 — NOT NULL
  • house_id — INT — 외래 키 → 양묘장하우스_smart_nursery_house.sid — NOT NULL
  • sensor_code — VARCHAR(50)
  • sensor_type_id — INT — 외래 키 → 센서종류_sensor_type.sid — NOT NULL
  • sensor_status_id — INT — 외래 키 → 센서상태코드_sensor_status_type.sid — NOT NULL
  • sensor_name — VARCHAR(50)
  • sensor_x — DOUBLE
  • sensor_y — DOUBLE
  • updated — DATETIME — NOT NULL

하우스종류_house_type

  • sid — INT — 기본 키 — NOT NULL
  • house_type_name — VARCHAR(50)

현재설비데이터_facility_data_current

  • sid — INT — 기본 키 — NOT NULL
  • facility_id — INT — 외래 키 → 하우스설비_smart_nursery_house_facility.sid — NOT NULL
  • data_value — DOUBLE
  • reg_date — DATETIME — NOT NULL

현재센서데이터_sensor_data_current

  • sid — INT — 기본 키 — NOT NULL
  • sensor_id — INT — 외래 키 → 하우스센서_smart_nursery_house_sensor.sid — NOT NULL
  • data_value — DOUBLE
  • reg_date — DATETIME — NOT NULL