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 — 회원