Device Profile
The DeviceProfile table is used to store device profiles in the system. It includes columns for the device ID, device name, phone number, OS device, app version number, ICCID, IMSI, IMEI, SIM card info, and the user who created or last modified the record, along with the corresponding date and time.
Table Structure
[ID](bigint,auto-incrementing,primary key): Represents the unique identifier for each device profile record.[Device_ID](bigint,foreign key,not null): Represents the device associated with the profile.[Device_Name](nvarchar(100),nullable): Represents the name of the device.[Phone_Number](varchar(50),nullable): Represents the phone number.[OS_Device](nvarchar(50),nullable): Represents the OS device.[App_Version_Number](varchar(20),nullable): Represents the app version number.[ICCID](varchar(50),nullable): Represents the ICCID.[IMSI](varchar(50),nullable): Represents the IMSI.[IMEI](varchar(50),nullable): Represents the IMEI.[SimCard_Info](varchar(50),nullable): Represents the SIM card info.[Modified_By](bigint,nullable): Represents the user who last modified the record.[Modified_Date](datetime,not null): Represents the date and time when the record was last modified.[Created_By](bigint,nullable): Represents the user who created the record.[Created_Date](datetime,not null): Represents the date and time when the record was created.
Constraints
[PK_DeviceProfile]: Primary key constraint on the[ID]column.[DF_DeviceProfile_ModifiedDate]: Default constraint to set[Modified_Date]to the current UTC date and time.[DF_DeviceProfile_CreatedDate]: Default constraint to set[Created_Date]to the current UTC date and time.[FK_DeviceProfile]: Foreign key constraint on the[Device_ID]column, referencing the[JFW].[Device] table.
Example Data
1
iPhone 12
1234567890
iOS
14.5
12345
6789
1234
5678
2
Samsung S21
0987654321
Android
11.0
54321
9876
4321
8765
Last updated
Was this helpful?