18 lines
690 B
Transact-SQL
18 lines
690 B
Transact-SQL
CREATE TABLE [dbo].[XW_SunshinePoint] (
|
|
[Id] INT IDENTITY(1,1) NOT NULL,
|
|
[ImageUrl] NVARCHAR(1000) NULL,
|
|
[FileName] NVARCHAR(255) NULL,
|
|
[DeviceNum] NVARCHAR(100) NULL,
|
|
[Timestamp] NVARCHAR(50) NULL,
|
|
[StudentNo] NVARCHAR(50) NULL,
|
|
[PointName] NVARCHAR(100) NULL,
|
|
[CameraIp] NVARCHAR(50) NULL,
|
|
[EffectiveDistance] NVARCHAR(50) NULL,
|
|
[SumDistance] NVARCHAR(50) NULL,
|
|
[CreateTime] NVARCHAR(50) NULL,
|
|
CONSTRAINT [PK_XW_SunshinePoint] PRIMARY KEY CLUSTERED ([Id] ASC)
|
|
);
|
|
|
|
CREATE INDEX [IX_XW_SunshinePoint_DeviceNum] ON [dbo].[XW_SunshinePoint] ([DeviceNum]);
|
|
CREATE INDEX [IX_XW_SunshinePoint_StudentNo] ON [dbo].[XW_SunshinePoint] ([StudentNo]);
|