CREATE TABLE tblLocations
(
	LocationID int identity not null,
	Location varchar(255) NOT NULL,
	Active bit NOT NULL CONSTRAINT DF_tblLocations_Active DEFAULT ((1)),
CONSTRAINT PK_tblLocations PRIMARY KEY CLUSTERED
(
	LocationID ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

go 

CREATE TABLE tblContainerMovements(
	MovementID int NOT NULL,
	MovementDate datetime NOT NULL,
	MoveFromLocationID int NOT NULL,
	MoveToLocationID int NOT NULL,
	CustomerName varchar(64) NOT NULL, --This should be a FK to the CustomerID not their name
	ContractReference varchar(64) NOT NULL, --This should reference the Contract by the PK not a text description
	TNumber varchar(32) NOT NULL, --this appears to be poor RI again but not sure what it is.
	NotesAndComments varchar(max) NULL, --don't use text datatype, it is deprecated. instead use varchar(max)
CONSTRAINT PK_tblContainerMovements PRIMARY KEY CLUSTERED
(
	MovementID ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]