Database IOT

1. Alert.TripDetail

1.1. Id

1.2. CompanyName

1.3. MainContactName

1.4. HouseNumber

1.5. AdressLine1

1.6. AdressLine2

1.7. AdditionalInformation

1.8. City

1.9. PostalCode

1.10. Country

1.11. PhoneNumber

1.12. EmailContact

1.13. MaskId

1.14. TripDetailType

1.14.1. Installation of the device

1.14.2. At destination

2. Alert.PointOfInterest

2.1. Id

2.2. Airport

2.3. Street

2.4. City

2.5. Country

2.6. MaskId

3. Alert.Tilt

3.1. Id

3.2. AlertTypeId

3.3. MinValue

3.4. MaxValue

3.5. MeasureId

3.6. MaskId

3.7. SQLCreationDate

3.8. SQLCreationAuthor

3.9. SQLLastModificationDate

3.10. SQLLastModificationAuthor

4. Alert.Contact

4.1. Id

4.2. Title

4.3. ContactName

4.4. PhoneNumber

4.5. Email

4.6. Section

4.6.1. BTL

4.6.2. 3RD

4.7. ContactTypeId

4.7.1. Alert.ContactType

4.7.1.1. Id

4.7.1.2. Label

4.7.1.2.1. Departure Point

4.7.1.2.2. Destination Point

4.7.1.2.3. Sales

4.8. ContactRoleId

4.8.1. Lấy dữ liệu từ bảng Iot.Role

4.9. SQLCreationDate

4.10. SQLCreationAuthor

4.11. SQLLastModificationDate

4.12. SQLLastModificationAuthor

5. Alert.Battery

5.1. Id

5.2. AlertTypeId

5.3. MinValue

5.4. MeasureId

5.5. MaskId

5.6. SQLCreationDate

5.7. SQLCreationAuthor

5.8. SQLLastModificationDate

5.9. SQLLastModificationAuthor

6. Alert.Notification

6.1. Id

6.2. MaskId

6.3. EmailAddress

6.4. NoAlert

6.5. AllLert

6.6. Geofence

6.7. Temperature

6.8. Huminity

6.9. Shock

6.10. Opendoor

6.11. Battery

6.12. Tilt

6.13. SQLCreationDate

6.14. SQLCreationAuthor

6.15. SQLLastModificationDate

6.16. SQLLastModificationAuthor

7. Alert.MaskContact

7.1. Id

7.2. MaskId

7.3. ContactId