1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| CREATE TABLE [dbo].[gradde](
[id_grade] [int] NOT NULL,
[intitule_grade] [nvarchar](max) NOT NULL,
[nombre _post] [int] NOT NULL,
[poste_ocuper] [int] NULL,
[defference] [int] NULL,
CONSTRAINT [PK_gradde] PRIMARY KEY CLUSTERED
CREATE TABLE [dbo].[EMPLOYEE](
[NUM_EMP] [int] NOT NULL,
[NOM_EMP] [nvarchar](50) NOT NULL,
[id_grade] [int] NOT NULL,
CONSTRAINT [PK_EMPLOYEE] PRIMARY KEY CLUSTERED
ALTER TABLE [dbo].[EMPLOYEE] WITH CHECK ADD CONSTRAINT [FK_EMPLOYEE_gradde] FOREIGN KEY([id_grade])
REFERENCES [dbo].[gradde] ([id_grade])
GO
ALTER TABLE [dbo].[EMPLOYEE] CHECK CONSTRAINT [FK_EMPLOYEE_gradde]
GO |
Partager