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 (비고)