viits_erd_v1(+일지)

테이블 (19)

biomass (생체 분석 정보)

  • Key — 기본 키 — NOT NULL
  • project_id (Key2) — 외래 키 → viits_project.project_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_project.site_id — NOT NULL
  • length (전장)
  • height (체고)
  • weight (무게)
  • base (pose or 생장일)
  • Field (하루에 네번 또는 1번)

viits_site (사이트)

  • site_id (Key) — 기본 키 — NOT NULL
  • site_name (Field)
  • site_access_key (Field3)
  • created_at (Field2)
  • updated_at (Field4)

viits_user (유저)

  • user_id (Key) — 기본 키 — NOT NULL
  • site_id (Key2) — 외래 키 → viits_site.site_id — NOT NULL
  • email (Field5)
  • username (Field)
  • password (Field2)
  • is_superuser(False) (Field6)
  • is_active(True) (Field7)
  • is_site_authenticated(False) (Field8)
  • created_at (Field9)
  • updated_at (Field10)

actual_body (어체 실측 정보)

  • Key — 기본 키 — NOT NULL
  • journal_id (Key2) — 외래 키 → viits_journal.journal_id — NOT NULL
  • user_id (writer) — 외래 키 → viits_journal.user_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_journal.site_id — NOT NULL
  • project_id (Key3) — 외래 키 → viits_journal.project_id — NOT NULL
  • site_id (Key23) — 외래 키 → viits_journal.site_id — NOT NULL
  • length (전장(cm))
  • height (체고(cm))
  • weight (무게(g))
  • note (비고)

death (폐사 정보)

  • death_id (Key) — 기본 키 — NOT NULL
  • journal_id (Key2) — 외래 키 → viits_journal.journal_id — NOT NULL
  • user_id (writer) — 외래 키 → viits_journal.user_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_journal.site_id — NOT NULL
  • project_id (Key3) — 외래 키 → viits_journal.project_id — NOT NULL
  • site_id (Key23) — 외래 키 → viits_journal.site_id — NOT NULL
  • type (natural or disease or etc)
  • amount (폐사량)
  • note (비고)

feeding (급이 정보)

  • feeding_id (Key) — 기본 키 — NOT NULL
  • journal_id (Key2) — 외래 키 → viits_journal.journal_id — NOT NULL
  • user_id (writer) — 외래 키 → viits_journal.user_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_journal.site_id — NOT NULL
  • project_id (Key3) — 외래 키 → viits_journal.project_id — NOT NULL
  • site_id (Key23) — 외래 키 → viits_journal.site_id — NOT NULL
  • time (Field)
  • type (Pellets or Flakes)
  • amount (Field3)
  • note (비고)

injection (주사 설정)

  • Key — 기본 키 — NOT NULL
  • journal_id (Key2) — 외래 키 → viits_journal.journal_id — NOT NULL
  • user_id (writer) — 외래 키 → viits_journal.user_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_journal.site_id — NOT NULL
  • project_id (Key3) — 외래 키 → viits_journal.project_id — NOT NULL
  • site_id (Key23) — 외래 키 → viits_journal.site_id — NOT NULL
  • time (Field)
  • type (Vaccination or Hormone)
  • amount (주사량)
  • note (비고)

medication (약욕 설정)

  • Key — 기본 키 — NOT NULL
  • journal_id (Key2) — 외래 키 → viits_journal.journal_id — NOT NULL
  • user_id (writer) — 외래 키 → viits_journal.user_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_journal.site_id — NOT NULL
  • project_id (Key3) — 외래 키 → viits_journal.project_id — NOT NULL
  • site_id (Key23) — 외래 키 → viits_journal.site_id — NOT NULL
  • time (Field)
  • duration (Field2)
  • type (Antibiotics or Antifungal)
  • amount (약욕량)
  • note (비고)

oral (경구 설정)

  • Key — 기본 키 — NOT NULL
  • journal_id (Key2) — 외래 키 → viits_journal.journal_id — NOT NULL
  • user_id (writer) — 외래 키 → viits_journal.user_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_journal.site_id — NOT NULL
  • project_id (Key3) — 외래 키 → viits_journal.project_id — NOT NULL
  • site_id (Key23) — 외래 키 → viits_journal.site_id — NOT NULL
  • time (Field)
  • type (Vitamins)
  • amount (Field2)

sensor_history (Untitled10)

  • id (Key) — 기본 키 — NOT NULL
  • wt (Field)
  • do (Field2)
  • ph (Field3)
  • created_at (Field4)
  • upadtea_at (Field5)
  • project_id (Field6)

verification (Untitled6)

  • id (Field)
  • email (Field2)
  • code (Field3)
  • is_verified (Field4)
  • created_at (Field5)
  • updated_at (Field6)

viits_ai_model (Untitled7)

  • ai_model_id (Key3) — 기본 키 — NOT NULL
  • ai_type (객체 탐지 or 생체 분석 or 이상 탐지)
  • model_file_name (Busan_Salmon_AgeModel_v2.0)
  • created_at (Field)
  • updated_at (Field2)

viits_camera (카메라)

  • camera_id (Key) — 기본 키 — NOT NULL
  • project_id (Key2) — 외래 키 → viits_project.project_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_project.site_id — NOT NULL
  • cam_name (프로젝트의 building_name + tank_name)
  • cam_rtsp_url (rtsp://admin:[email protected]:3111)
  • ai_type_list (객체 탐지 or 생체 분석 or 이상 탐지 List)
  • created_at (Field6)
  • updated_at (Field7)
  • inference_start_at (나중에 추가)
  • inference_end_at (나충에 추가)

viits_journal (Untitled8)

  • journal_id (Key) — 기본 키 — NOT NULL
  • user_id (writer) — 외래 키 → viits_user.user_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_user.site_id — NOT NULL
  • project_id (Key3) — 외래 키 → viits_project.project_id — NOT NULL
  • site_id (Key2) — 외래 키 → viits_project.site_id — NOT NULL
  • date (Field)
  • created_at (YYYY-MM-DD)
  • updated_at (Field2)

viits_project (프로젝트)

  • project_id (Key) — 기본 키 — NOT NULL
  • site_id (Key2) — 외래 키 → viits_site.site_id — NOT NULL
  • building_name (양식동 식별(생산1동))
  • tank_name (수조 식별(1번 수조))
  • type (양식 or 자연 enum) — 양식 or 자연
  • species (연어 or 넙치 or 참돔 or 기타 str)
  • tank_capacity (수조용량(6.6) float)
  • feeding_date (입식일 date)
  • hatching_date (부화일 date)
  • feeding_amount (입식량(1000) int)
  • death_amount (폐사량(199) int)
  • density (사육 밀도(27.0))
  • ai_density (AI 사육 밀도(26.5))
  • density_status (사육 밀도 상태)
  • updated_at (Field)
  • created_at (Field4)

viits_sensor_v1 (센서)

  • sensor_id (Key) — 기본 키 — NOT NULL
  • project_id (Key2) — 외래 키 → viits_project.project_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_project.site_id — NOT NULL
  • sensor_name (WT/DO/pH/염도/탁도/)
  • sensor_ip_addr (Field2)
  • sensor_port (Field3)
  • type (멀티 or 단일)
  • alarm_from (Field9)
  • alarm_to (Field10)
  • unit (도씨, 빈값)
  • status (표준/주의/위험)
  • value (float)
  • created_at (Field11)
  • updated_at (Field12)

viits_sensor_v2 (Untitled9)

  • sensor_id (Key) — 기본 키 — NOT NULL
  • project_id (Field2)
  • sensor_name (Field3)
  • ip_addr (Field4)
  • port (Field5)
  • created_at (Field6)
  • updated_at (Field7)
  • type (Field)

water_quality (수질 실측 설정)

  • water_quality_id (Key) — 기본 키 — NOT NULL
  • journal_id (Key2) — 외래 키 → viits_journal.journal_id — NOT NULL
  • user_id (writer) — 외래 키 → viits_journal.user_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_journal.site_id — NOT NULL
  • project_id (Key3) — 외래 키 → viits_journal.project_id — NOT NULL
  • site_id (Key23) — 외래 키 → viits_journal.site_id — NOT NULL
  • time (Field)
  • type (WT or DO or pH or CO2 or NH3 or 유량 or 탁도)
  • note (비고)

water_supply (환수 정보 설정)

  • Key — 기본 키 — NOT NULL
  • journal_id (Key2) — 외래 키 → viits_journal.journal_id — NOT NULL
  • user_id (writer) — 외래 키 → viits_journal.user_id — NOT NULL
  • site_id (Key22) — 외래 키 → viits_journal.site_id — NOT NULL
  • project_id (Key3) — 외래 키 → viits_journal.project_id — NOT NULL
  • site_id (Key23) — 외래 키 → viits_journal.site_id — NOT NULL
  • time (시작 시간)
  • duration (Field2)
  • amount (환수량)
  • circulation (순환량)
  • note (비고)