36 lines
890 B
Transact-SQL
36 lines
890 B
Transact-SQL
Alter TABLE [dbo].[Base_Project]add
|
|
[DataSource] [varchar](50) NULL
|
|
|
|
Alter TABLE [dbo].[Base_Unit]add
|
|
[DataSource] [varchar](50) NULL
|
|
|
|
Alter TABLE [dbo].[Base_Depart]add
|
|
[SuperDepartId] [nvarchar](50) NULL,
|
|
[DataSource] [nvarchar](50) NULL
|
|
|
|
Alter TABLE [dbo].[Project_Installation] add
|
|
[DataSource] [nvarchar](50) NULL
|
|
|
|
Alter TABLE [dbo].[ProjectData_WorkArea] add
|
|
[DataSource] [nvarchar](50) NULL
|
|
|
|
Alter TABLE [dbo].[Environmental_EnvironmentalMonitoring]add
|
|
[deviceId] [nvarchar](50) NULL,
|
|
[UpdateDate] [datetime] NULL,
|
|
[pm25] [float] NULL,
|
|
[pm10] [float] NULL,
|
|
[noise] [float] NULL,
|
|
[tem] [float] NULL,
|
|
[hum] [float] NULL,
|
|
[wp] [float] NULL,
|
|
[ws] [float] NULL,
|
|
[wd8] [float] NULL,
|
|
[wd360] [float] NULL,
|
|
[tsp] [float] NULL,
|
|
[atm] [float] NULL,
|
|
[lux] [float] NULL,
|
|
[co] [float] NULL,
|
|
[so2] [float] NULL,
|
|
[no2] [float] NULL,
|
|
[o3] [float] NULL
|