Advertisement
Towwers

Codigo - database

Nov 23rd, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.45 KB | None | 0 0
  1. create database empresa;
  2. create table tb_funcionario (
  3. cd_funcionario int autoincrement primary key,
  4. nm_funcionario varchar(100),
  5. pr_nome varchar(100),
  6. ul_nome varchar(100),
  7. dt_admissao date
  8. );
  9.  
  10. create table tb_funcao (
  11. cd_funcao int autoincrement primary key,
  12. nm_funcao varchar(100),
  13. sal_funcao real,
  14. est_comissao bool
  15. );
  16.  
  17. create table tb_departamento (
  18. cd_dpto int autoincrement primary key,
  19. nm_dpto varchar(100),
  20. ds_localizao longtext
  21. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement