Table for storing scanned surveys

create-survey-table.sql

CREATE TABLE surveys (
  [id] int not null identity,
  [first_name] nvarchar(255),
  [last_name] nvarchar(255),
  [division] nvarchar(255),
  [datetime] datetime,
  [ryg_status] nvarchar(255),
  [employee_id] nvarchar(255),
  [badge_number] nvarchar(255),
  [employee_type] nvarchar(255),
  [access_code] nvarchar(255),
  [scanned_datetime] datetime,
  PRIMARY KEY( [id] )
);