Smart Community Emergency Evacuation Management System and Risk Assessment Based on Mobile Big Data

Table 2

Design of building attribute table.

Field name	Field type	Field length	Description
SmID	Long integer	4	Primary key
SmUserID	Long integer	4	Foreign key
Area	Double precision	8	Cannot be empty
Perimeter	Long integer	8	Cannot be empty
SmSqID	Text type	4	Foreign key
Area	Long integer	50	—
Number of layers	Long integer	4	—
Total population	Long integer	4	—
Permanent residents	Text type	4	—
Principal	Text type	20	—
Tel	Text type	20	—
Use	Text type	50	—
SmJzWID	Long integer	4	Cannot be empty
SmYbID	Long integer	4	Cannot be empty
SmJzDID	Long integer	4	Cannot be empty