Advertisement
Guest User

Untitled

a guest
Oct 2nd, 2018
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.68 KB | None | 0 0
  1. CREATE TABLE persons(
  2. person_id INT(11) NOT NULL,
  3. fist_name VARCHAR(50),
  4. salary DECIMAL(15,2),
  5. passport_id INT(11)
  6. );
  7.  
  8. CREATE TABLE passports(
  9. passport_id INT(11) NOT NULL,
  10. passport_number VARCHAR(50)
  11. );
  12.  
  13. INSERT INTO persons
  14. VALUES
  15. (1, 'Roberto', 43300.00, 102),
  16. (2, 'Tom', 56100.00, 103),
  17. (3, 'Yana', 60200.00, 104);
  18.  
  19. INSERT INTO passports
  20. VALUES
  21. (102, 'N34FG21B'),
  22. (103, 'K65LO4R7'),
  23. (104, 'ZE657QP2');
  24.  
  25. ALTER TABLE persons
  26. ADD CONSTRAINT pk_person_id PRIMARY KEY(person_id);
  27.  
  28. ALTER TABLE passports
  29. ADD CONSTRAINT pk_passport_id PRIMARY KEY(passport_id);
  30.  
  31. ALTER TABLE persons
  32. ADD CONSTRAINT fk_passport_id FOREIGN KEY(passport_id) REFERENCES passports(passport_id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement