Analysis of college emergency management events based on intelligent industrial Internet of Things (IIoT)
y
27 feb 2025
Acerca de este artículo
Publicado en línea: 27 feb 2025
Recibido: 16 sept 2024
Aceptado: 09 ene 2025
DOI: https://doi.org/10.2478/amns-2025-0086
Palabras clave
© 2025 He Jiang et al., published by Sciendo
This work is licensed under the Creative Commons Attribution 4.0 International License.
Figure 1.
Figure 2.
Figure 3.
Figure 4.
Figure 5.
Figure 6.
Figure 7.
Figure 8.
Figure 9.
Figure 10.
User personnel table
| Field name | Key | Data type | Nullable | Description |
|---|---|---|---|---|
| Administrator_ ID | PK | nvarchar(50) | Account | |
| Administrator_ Password | nvarchar(128) | Cipher | ||
| Administrator_ Name | nvarchar(50) | Y | Real name | |
| Position | nvarchar(20) | Y | Limits of authority | |
| Last_ Login_ IP | nvarchar(255) | Y | Log in | |
| Last_ Login_ Time | datetime | Y | Login time | |
| Register_ Time | datetime | Y | Registration time | |
| Mobile_ Num | nvarchar | Y | Telephone |
Basic terminal information table
| Field name | Key | Data type | Nullable | Description |
|---|---|---|---|---|
| Terminal_ ID | PK | nvarchar(50) | Terminal number | |
| Customer_ ID | FK | nvarchar(128) | Student ID | |
| Password | nvarchar(50) | Y | Cipher | |
| Pricing_ Model | nvarchar(20) | Y | Mode | |
| Gas_ Type | nvarchar(20) | Y | Type | |
| Campus card_ ID | nvarchar(50) | Y | Campus card number | |
| Address | datetime | Y | Address | |
| Remark | nvarchar(255) | Remark | ||
| Description | nvarchar(255) | Description |