허비

테이블 (8)

Alert

  • alert_uuid — varchar(36) — 기본 키 — NOT NULL
  • receiver_uuid — varchar(36) — 외래 키 → User.user_uuid — NOT NULL
  • sender_uuid — varchar(36) — 외래 키 → User.user_uuid — NOT NULL
  • content — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • is_read — boolean — NOT NULL

ApplicationForm

  • form_id — bigint — 기본 키 — NOT NULL
  • user_uuid — varchar(36) — 외래 키 → User.user_uuid — NOT NULL
  • village_id — bigint — NOT NULL
  • cert_url — varchar(255) — NOT NULL
  • registration_status — enum('ACCEPT', 'REFUSE', 'PROGRESS') — NOT NULL
  • content — varchar(255)
  • refuse_content — varchar(255)
  • created_at — datetime — NOT NULL

Detection

  • detection_id — bigint — 기본 키 — NOT NULL
  • type — enum('INTRUDER', 'BOAR', 'ROE_DEER', 'MAGPIE', 'OTHER', 'HEAT_STRESS', 'FALL_DETECTED', 'NO_MOVEMENT') — NOT NULL
  • count — int — NOT NULL
  • snapshot_url — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • crow_uuid — varchar(36) — 외래 키 → Scarecrow.crow_uuid — NOT NULL

Scarecrow

  • crow_uuid — varchar(36) — 기본 키 — NOT NULL
  • user_uuid — varchar(36) — 외래 키 → User.user_uuid — NOT NULL
  • serial_number — varchar(8) — NOT NULL
  • crow_name — varchar(16) — NOT NULL
  • village_id — bigint
  • connection_status — enum('ONLINE', 'OFFLINE') — NOT NULL
  • camera_status — enum('CONNECTED', 'DISCONNECTED', 'ERROR') — NOT NULL
  • thermal_sensor_status — enum('CONNECTED', 'DISCONNECTED', 'ERROR') — NOT NULL
  • pir_sensor_status — enum('CONNECTED', 'DISCONNECTED', 'ERROR') — NOT NULL
  • speaker_status — enum('CONNECTED', 'DISCONNECTED', 'ERROR') — NOT NULL
  • light_status — enum('CONNECTED', 'DISCONNECTED', 'ERROR') — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

Sensor

  • sensor_id — bigint — 기본 키 — NOT NULL
  • crow_uuid — varchar(36) — 외래 키 → Scarecrow.crow_uuid — NOT NULL
  • latitude — decimal(10,7)
  • longitude — decimal(10,7)
  • battery — decimal(5,2)
  • temperature — decimal(5,2)
  • humidity — decimal(5,2)

User

  • user_uuid — varchar(36) — 기본 키 — NOT NULL
  • user_village_id — bigint — NOT NULL
  • username — varchar(16) — NOT NULL
  • email — varchar(255) — NOT NULL
  • role — enum('USER', LEADER', 'ADMIN')) — NOT NULL
  • kakao_user_id — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

Village

  • village_id — bigint — 기본 키 — NOT NULL
  • village_name — varchar(16) — NOT NULL
  • region_code — varchar(32)
  • created_at — datetime — NOT NULL

VillageRegistration

  • register_id — bigint — 기본 키 — NOT NULL
  • crow_uuid — varchar(36) — 외래 키 → Scarecrow.crow_uuid — NOT NULL
  • registration_status — enum('ACCEPT', 'REFUSE', 'PROGRESS') — NOT NULL
  • register_content — varchar(255)
  • refuse_content — varchar(255)
  • created_at — datetime — NOT NULL
  • village_id — bigint — NOT NULL