Advertisement
MattDovi

sql - DataAccess

Dec 3rd, 2020
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.82 KB | None | 0 0
  1. CREATE TABLE Accounts(
  2.  
  3.     ID INT NOT NULL PRIMARY KEY,
  4.  
  5.     Username nvarchar(32) NOT NULL UNIQUE,
  6.     Email nvarchar(50) NOT NULL UNIQUE,
  7.     Password nvarchar(100) NOT NULL,
  8.     Phone nvarchar(50) NOT NULL,
  9.  
  10.     ProfileID INT NOT NULL,
  11.     CONSTRAINT FK_ProfileAccounts FOREIGN KEY (ProfileID) REFERENCES Profiles(ID),
  12.     -- FK_TabelaInCareTeDuciTabelaInCareEsti --
  13. )
  14.  
  15. CREATE TABLE Profiles(
  16.  
  17.     ID INT NOT NULL PRIMARY KEY,
  18.  
  19.     FirstName nvarchar(50) NOT NULL,
  20.     LastName nvarchar(50) NOT NULL,
  21.     Country nvarchar(20) NOT NULL,
  22.     County nvarchar(20),
  23.     Gender nvarchar(1),
  24. )
  25.  
  26.  
  27. INSERT INTO Accounts (ID, Username, Email, Password, Phone, ProfileID)
  28. VALUES (1, 'admin', 'knaaofqw@gmail.com', 'pass', '0768352345', 1)
  29.  
  30. INSERT INTO Profiles (ID, FirstName, LastName, Country, County, Gender)
  31. VALUES (1, 'Admin', 'Admin', 'Romania', 'Iasi', 'M')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement