EHSDataCompliance Framework

USE MASTER;
CREATE DATABASE Test3
USE Test3;
CREATE TABLE Engin([ID]   int IDENTITY(1,1) NOT NULL PRIMARY KEY,[Description]   VARCHAR(100)  NOT NULL ,[DateCreated]   datetime  NOT NULL ,[CreatedBy]   VARCHAR(500)  NOT NULL ,[DateModified]   datetime  NULL ,[ModifiedBy]   VARCHAR(500)  NULL )
CREATE TABLE Person([ID]   int IDENTITY(1,1) NOT NULL PRIMARY KEY,[Title]   int  NULL ,[FullName]   VARCHAR(100)  NULL ,[Initials]   VARCHAR(100)  NULL ,[FirstName]   VARCHAR(100)  NULL ,[LastName]   VARCHAR(100)  NULL ,[Age]   int  NOT NULL ,[AddressNo]   VARCHAR( 100)  NOT NULL ,[AddressStreet]   VARCHAR( 100)  NOT NULL ,[AddressCity]   VARCHAR( 100)  NOT NULL ,[AddressCountry]   VARCHAR( 100)  NOT NULL ,[Status]   int  NULL ,[DateCreated]   datetime  NOT NULL ,[CreatedBy]   VARCHAR(500)  NOT NULL ,[DateModified]   datetime  NULL ,[ModifiedBy]   VARCHAR(500)  NULL )
CREATE TABLE Car([ID]   int IDENTITY(1,1) NOT NULL PRIMARY KEY,[OwnerId ]   int  NOT NULL REFERENCES  person(Id),[Description]   VARCHAR(100)  NULL ,[Type]   int  NULL ,[EnginId ]   int  NOT NULL REFERENCES  engin(Id),[Color]   VARCHAR( 100)  NOT NULL ,[Usage]   int  NOT NULL ,[DateCreated]   datetime  NOT NULL ,[CreatedBy]   VARCHAR(500)  NOT NULL ,[DateModified]   datetime  NULL ,[ModifiedBy]   VARCHAR(500)  NULL )