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