﻿-- Table: operation
CREATE TABLE [operation] (
    [operation_id] int NOT NULL,
    [user_profile_id] int NOT NULL,
    [operation_name] nvarchar(300) NOT NULL,
    [start_time] datetime NOT NULL DEFAULT (getdate()),
    CONSTRAINT [PK_operation] PRIMARY KEY ([operation_id], [user_profile_id])
);
GO

ALTER TABLE [operation] ADD FOREIGN KEY ([user_profile_id]) REFERENCES [user_profile] ([user_profile_id]);
GO

