Analysis of college emergency management events based on intelligent industrial Internet of Things (IIoT)
e
27 feb 2025
INFORMAZIONI SU QUESTO ARTICOLO
Pubblicato online: 27 feb 2025
Ricevuto: 16 set 2024
Accettato: 09 gen 2025
DOI: https://doi.org/10.2478/amns-2025-0086
Parole chiave
© 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 |