SangSpoon
Tables (5)
parsed_data
- id — INT
- sensor_data_id — INT — NOT NULL
- water_level — DECIMAL(5,2)
- chemical_level — DECIMAL(5,2)
- motor_status1 — TINYINT
- motor_status2 — TINYINT
- flow_rate — DECIMAL(10,3)
- total_amount — INT
sensor_data
- id — INT
- site_id — INT — NOT NULL
- received_at — DATETIME — NOT NULL
- raw_data — TEXT — NOT NULL
sites
- id — INT
- site_name — VARCHAR(100) — NOT NULL
- management_code — VARCHAR(50) — NOT NULL
- manager_name — VARCHAR(100) — NOT NULL
- contact_number — VARCHAR(20) — NOT NULL
- tank_type — ENUM('원형', '사각') — NOT NULL
- diameter — DECIMAL(5,2)
- width — DECIMAL(5,2)
- height — DECIMAL(5,2) — NOT NULL
- status — ENUM('활성', '비활성')
user
- id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
users
- id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL