CREATE TABLE cable_routes (
id INTEGER PRIMARY KEY AUTOINCREMENT,
customer_id INTEGER NOT NULL,
odp_id INTEGER NOT NULL,
cable_length DECIMAL(8,2),
cable_type VARCHAR(50) DEFAULT 'Fiber Optic',
installation_date DATE,
status VARCHAR(20) DEFAULT 'connected' CHECK (status IN ('connected', 'disconnected', 'maintenance', 'damaged')),
port_number INTEGER,
notes TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (customer_id) REFERENCES customers(id) ON DELETE CASCADE,
FOREIGN KEY (odp_id) REFERENCES odps(id) ON DELETE CASCADE
)