This guide helps you with device_T and device_service_t tables. device_t and device_service_t maintains the device_id, SIM, IMSI, state, statuses and linked to service_t and account_t to find which device is associated with which account and service.