Table 3 Video surveillance equipment.

From: The design of intelligent highway transportation system in smart city based on the internet of things

Field name

Field description

Field type

Remarks

Spnum

Video surveillance device number

Char(10)

 

Spname

Video monitoring device name

Varchar(20)

You can also store the path information of the picture

Spphoto

TakING pictures

  

Ldnjd

Section visibility

Varchar(20)

 

Ldcar

Vehicle flow rate

Varchar(20)

 

Ldzk

Section traffic condition

Varchar(20)

 

Sptime

Acquisition time

  

Ldnum

Section number

Char(10)

Foreign key