daily pastebin goal
75%
SHARE
TWEET

Untitled

a guest Jul 17th, 2018 54 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE Rota (
  2.     RotaId INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
  3.     EmployeeId INT NOT NULL FOREIGN KEY REFERENCES Employee(Employee),
  4.     -- Other columns
  5. )
  6.    
  7. CREATE TABLE EmployeeOvertime (
  8.     EmployeeOvertimeId INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
  9.     EmployeeId INT NOT NULL FOREIGN KEY REFERENCES Employee(Employee),
  10.     -- Other columns
  11. )
  12.    
  13. CREATE TABLE RotaOvertime (
  14.     RotaId INT NOT NULL FOREIGN KEY REFERENCES Rota(RotaId),
  15.     EmployeeOvertimeId INT NOT NULL FOREIGN KEY REFERENCES EmployeeOvertime(EmployeeOvertimeId),
  16.     UNIQUE (RotaId, EmployeeOvertimeId)
  17. )
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top