viits_erd_v1

Tables (5)

viits_site (사이트)

  • site_id (Key) — Primary key — NOT NULL
  • site_name (Field)
  • site_access_key (Field3)
  • created_at (Field2)
  • updated_at (Field4)

viits_user (유저)

  • user_id (Key) — Primary key — NOT NULL
  • site_id (Key2) — Foreign key → viits_site.site_id — NOT NULL
  • email (Field5)
  • username (Field)
  • password (Field2)
  • is_site_authenticated(False) (Field8)
  • is_superuser(False) (Field6)
  • is_active(True) (Field7)
  • created_at (Field9)
  • updated_at (Field10)

viits_camera (카메라)

  • camera_id (Key) — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → viits_project.project_id — NOT NULL
  • site_id (Key22) — Foreign key → 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)
  • is_deleted (Field)
  • inference_start_at (나중에 추가)
  • inference_end_at (나충에 추가)

viits_project (프로젝트)

  • project_id (Key) — Primary key — NOT NULL
  • site_id (Key2) — Foreign key → 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))
  • created_at (Field4)
  • updated_at (Field)
  • is_deleted (Field2)

viits_sensor (센서)

  • sensor_id (Key) — Primary key — NOT NULL
  • project_id (Key2) — Foreign key → viits_project.project_id — NOT NULL
  • site_id (Key22) — Foreign key → viits_project.site_id — NOT NULL
  • sensor_name (WT/DO/pH/염도/탁도/)
  • ip_addr (Field2)
  • port (Field3)
  • wt_warning_high (Field10)
  • wt_warning_low (Field9)
  • wt_caution_high (도씨, 빈값)
  • wt_caution_low (표준/주의/위험)
  • do_warning_high (Field4)
  • do_warning_low (Field5)
  • do_caution_high (Field6)
  • do_caution_low (Field7)
  • ph_warning_high (Field8)
  • ph_warning_low (Field13)
  • ph_caution_high (Field14)
  • ph_caution_low (Field15)
  • created_at (Field11)
  • updated_at (Field12)
  • is_deleted (Field)