CREATE TABLE MachineTestBeforeUse
(
[RV] timestamp NOT NULL,
[Id] int IDENTITY(1,1) NOT NULL,
MachineId int NOT NULL,
ShiftCode int NOT NULL,
OperationDateTime datetime NOT NULL,
RemnantTest bit NOT NULL,
SelfTest bit NOT NULL,
[Signature] int NOT NULL,
Comments [nvarchar](255) NULL,
)
CREATE TABLE MachineSterilizationAfterUse
(
[RV] timestamp NOT NULL,
[Id] int IDENTITY(1,1) NOT NULL,
MachineId int NOT NULL,
ShiftCode int NOT NULL,
OperationDateTime datetime NOT NULL,
PatientId int NOT NULL,
Usage bit NOT NULL,
PipeSterilization bit NOT NULL,
SurfaceSterilization bit NOT NULL,
[Signature] int NOT NULL,
Comments [nvarchar](255) NULL,
)
