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)