Advertisement
shiftdot515

Organizational Thinking vs SQLite

Jul 19th, 2021
338
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1.  
  2. Organizational Thinking vs SQLitea
  3. _____________________________________________
  4. A person has a can do relationship with a job.
  5.  
  6. A job has a description.
  7. -------------------------------------
  8. The relationships come first.
  9. -----------
  10. sqlite> create table job (
  11. ...> job_name char(30) not null,
  12. ...> job_description var_char(1024) not null
  13. ...> ) ;
  14. sqlite> create table person (
  15. ...> go_by char(60) not null,
  16. ...> person_id integer primary key
  17. ...> );
  18.  
  19. sqlite> select * from job;
  20. sqlite> select * from person ;
  21. sqlite> insert into job
  22. <erson' , 'Computer Guy, Smart With Computers, Computer Wizard, Programmer' );
  23. sqlite> insert into person values ( Dan, 0);
  24. SQL error: no such column: Dan
  25. sqlite> insert into person values ( 'Dan', 0 ) ;
  26.  
  27. sqlite> select * from job;
  28. Computer Person|Computer Guy, Smart With Computers, Computer Wizard, Programmer
  29. sqlite> select * from person ;
  30. Dan|0
  31.  
  32. ---------------
  33. Separation of Church and State
  34. Actually, relates, primarily to, the last form of Law, and Jurisprudence in the United States, Estate Law. And, so, as the Church shrinks from the lifes of the typical American, freedom, should expand to fill it's place.
  35. -------
  36. [ This shouldn't be here, but it has to stays,
  37. As Church has a Form of Organization , of it's own ]
  38.  
  39.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement