허비
테이블 (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