1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE TABLE [dbo].[TB_users] (
[PK_USER] INT IDENTITY (1, 1) NOT NULL,
[FIRST_NAME] NVARCHAR (50) NOT NULL,
[NAME] NVARCHAR (50) NOT NULL,
[ENTIRE_NAME] NVARCHAR(100) NULL,
[SERVICE] NVARCHAR (50) NULL,
[EMAIL] NVARCHAR (50) NULL,
[PHONE] NVARCHAR (50) NULL,
[FK_GRADE] INT NULL,
[PASSWORD] NVARCHAR (50) NOT NULL,
PRIMARY KEY CLUSTERED ([PK_USER] ASC),
CONSTRAINT [FK_TB_users_To_TB_grades] FOREIGN KEY ([FK_GRADE]) REFERENCES [dbo].[TB_grades] ([PK_GRADE])
)
GO
SELECT [PK_USER], CONCAT([FIRST_NAME], ' ', [NAME]) AS [ENTIRE_NAME]; |
Partager