CREATE TABLE onu_devices (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR(100) NOT NULL,
serial_number VARCHAR(100) UNIQUE,
mac_address VARCHAR(17),
ip_address VARCHAR(15),
status VARCHAR(20) DEFAULT 'online' CHECK (status IN ('online', 'offline', 'maintenance')),
latitude DECIMAL(10,8),
longitude DECIMAL(11,8),
customer_id INTEGER,
odp_id INTEGER,
ssid VARCHAR(50),
password VARCHAR(100),
model VARCHAR(100),
firmware_version VARCHAR(50),
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (customer_id) REFERENCES customers(id) ON DELETE SET NULL,
FOREIGN KEY (odp_id) REFERENCES odps(id) ON DELETE SET NULL
)