tomato

Tables (11)

QC_CCTV

  • CCTV_IDX — NUMBER(18, 0) — Primary key — NOT NULL
  • GH_IDX — NUMBER(18, 0) — Foreign key → QC_GREENHOUSE.GH_IDX — NOT NULL
  • FARM_IDX (FARM_IDX2) — NUMBER(18, 0) — Foreign key → QC_GREENHOUSE.FARM_IDX — NOT NULL
  • CCTV_NM — VARCHAR2(50) — NOT NULL — CCTV
  • CCTV_LOC — VARCHAR2(50) — NOT NULL — CCTV
  • CCTV_X — NUMBER — NOT NULL — 설치
  • CCTV_Y — NUMBER — NOT NULL — 설치
  • CREATED_AT — TIMESTAMP — NOT NULL — 설치

QC_CLASSIFICATION

  • ANLS_IDX — NUMBER(18, 0) — Primary key — NOT NULL
  • IMG_IDX — NUMBER(18, 0) — Foreign key → QC_IMAGES.IMG_IDX — NOT NULL
  • CCTV_IDX (CCTV_IDX2) — NUMBER(18, 0) — Foreign key → QC_IMAGES.CCTV_IDX — NOT NULL
  • GH_IDX — NUMBER(18, 0) — Foreign key → QC_IMAGES.GH_IDX — NOT NULL
  • FARM_IDX (FARM_IDX2) — NUMBER(18, 0) — Foreign key → QC_IMAGES.FARM_IDX — NOT NULL
  • GH_IDX (GH_IDX2) — NUMBER(18, 0) — Foreign key — NOT NULL
  • FARM_IDX (FARM_IDX22) — NUMBER(18, 0) — Foreign key — NOT NULL
  • INSECT_IDX — NUMBER(18, 0) — Foreign key → QC_INSECT.INSECT_IDX — NOT NULL
  • ANLS_MODEL — VARCHAR2(100) — NOT NULL — 적용
  • ANLS_CONTENT — CLOB — NOT NULL — 분석
  • ANLS_RESULT — VARCHAR2(1000) — NOT NULL — 분석
  • CREATED_AT — TIMESTAMP — NOT NULL — 분석

QC_DIARY

  • DIARY_IDX — NUMBER(18, 0) — Primary key — NOT NULL
  • FARM_TYPE — VARCHAR2(20) — NOT NULL — 농사
  • DIARY_TITLE — VARCHAR2(300) — NOT NULL — 일지
  • DIARY_CONTENT — CLOB — NOT NULL — 일지
  • IMG1 — VARCHAR2(1000) — 사진1
  • IMG2 — VARCHAR2(1000) — 사진2
  • IMG3 — VARCHAR2(1000) — 사진3
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록
  • USER_PHONE — VARCHAR2(20) — Foreign key → QC_USER.USER_PHONE — NOT NULL — 회원

QC_FARM

  • FARM_IDX — NUMBER(18, 0) — Primary key — NOT NULL
  • FARM_NAME — VARCHAR2(50) — NOT NULL — 농장
  • FARM_ADDR — VARCHAR2(200) — NOT NULL — 농장
  • FARM_PHONE — VARCHAR2(20) — NOT NULL — 농장
  • FARM_CROPS — VARCHAR2(50) — NOT NULL — 재배
  • FARM_AREA — VARCHAR2(50) — NOT NULL — 재배
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록
  • FARM_IMG — VARCHAR2(1000) — 농장
  • USER_PHONE — VARCHAR2(20) — Foreign key → QC_USER.USER_PHONE — NOT NULL — 회원

QC_FEEDBACK

  • FEEDBACK_IDX — NUMBER(18, 0) — Primary key — NOT NULL
  • ANLS_IDX — NUMBER(18, 0) — Foreign key → QC_CLASSIFICATION.ANLS_IDX — NOT NULL — 분석
  • FEEDBACK_CONTENT — VARCHAR2(3000) — NOT NULL — 피드백
  • CREATED_AT — TIMESTAMP — NOT NULL — 피드백
  • FARM_IDX (FARM_IDX222) — NUMBER(18, 0) — Foreign key — NOT NULL

QC_GREENHOUSE

  • GH_IDX — NUMBER(18, 0) — Primary key — NOT NULL
  • FARM_IDX — NUMBER(18, 0) — Foreign key → QC_FARM.FARM_IDX — NOT NULL
  • GH_NAME — VARCHAR2(255) — NOT NULL — 시설동
  • GH_AREA — VARCHAR2(255) — NOT NULL — 시설
  • GH_CROPS — VARCHAR2(255) — NOT NULL — 재배
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록

QC_IMAGES

  • IMG_IDX — NUMBER(18, 0) — Primary key — NOT NULL
  • CCTV_IDX — NUMBER(18, 0) — Foreign key → QC_CCTV.CCTV_IDX — NOT NULL
  • GH_IDX — NUMBER(18, 0) — Foreign key → QC_CCTV.GH_IDX — NOT NULL
  • FARM_IDX (FARM_IDX2) — NUMBER(18, 0) — Foreign key → QC_CCTV.FARM_IDX — NOT NULL
  • IMG_NAME — VARCHAR2(1000) — NOT NULL — 이미지
  • IMG_SIZE — NUMBER — NOT NULL — 이미지
  • IMG_EXT — VARCHAR2(10) — NOT NULL — 이미지
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록
  • IMG_X — NUMBER — 위치
  • IMG_Y — NUMBER — 위치

QC_INSECT

  • INSECT_IDX — NUMBER(18, 0) — Primary key — NOT NULL
  • INSECT_NAME — VARCHAR2(100) — NOT NULL — 해충
  • INSECT_DESC — CLOB — NOT NULL — 해충
  • INSECT_IMG1 — VARCHAR2(1000) — NOT NULL — 해충
  • INSECT_IMG2 — VARCHAR2(1000) — NOT NULL — 해충
  • INSECT_IMG3 — VARCHAR2(1000) — NOT NULL — 해충

QC_NOTIFICATION

  • NOTI_IDX — NUMBER(18, 0) — Primary key — NOT NULL
  • ANLS_IDX — NUMBER(18, 0) — Foreign key → QC_CLASSIFICATION.ANLS_IDX — NOT NULL
  • NOTI_CHECK — VARCHAR2(1)

QC_REPORT

  • REPORT_IDX — NUMBER(18, 0) — Primary key — NOT NULL
  • FARM_IDX — NUMBER(18, 0) — Foreign key → QC_FARM.FARM_IDX — NOT NULL — 농장
  • PERIOD_TYPE — VARCHAR2(50) — NOT NULL — 기간
  • PERIOD_MARK — VARCHAR2(50) — NOT NULL — 기간
  • REPORT — VARCHAR2(4000) — NOT NULL — 리포트
  • CREATED_AT — TIMESTAMP — NOT NULL — 등록

QC_USER

  • USER_PHONE — VARCHAR2(20) — Primary key — NOT NULL
  • USER_PW — VARCHAR2(128) — NOT NULL — 회원
  • USER_NAME — VARCHAR2(50) — NOT NULL — 회원
  • JOINED_AT — TIMESTAMP — NOT NULL — 회원