Guest User

Untitled

a guest
Jul 21st, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. CREATE TABLE Family (
  2. Id INT NOT NULL PRIMARY KEY,
  3. MotherId INT REFERENCES Family(Id),
  4. FatherId INT REFERENCES Family(Id),
  5. Name VARCHAR(30) NOT NULL,
  6. Age INT NOT NULL
  7. );
  8.  
  9. INSERT INTO people(Id, MotherId, FatherId, Name, Age) VALUES(1, NULL, NULL, 'David', 65);
  10. INSERT INTO people(Id, MotherId, FatherId, Name, Age) VALUES(2, NULL, NULL, 'Keti', 55);
  11. INSERT INTO people(Id, MotherId, FatherId, Name, Age) VALUES(3, 2, 1, 'Crysti', 25);
  12. INSERT INTO people(Id, MotherId, FatherId, Name, Age) VALUES(4, 2, 1, 'Ellen', 18);
  13.  
  14. Name Age
  15. =============
  16. David 25
  17. Keti 25
Add Comment
Please, Sign In to add comment