# session monkchat │react / analise / banco de dados

## Henrique Dias Costa

### `db designer DER`


### `script sql`

CREATE TABLE TB_SALA (
  id_sala int AUTO_INCREMENT primary KEY,
  nm_sala varchar(100),
  nm_dono varchar(100),
  ds_senha int
 );
 
 CREATE table TB_USUARIO(
 id_usuario	int AUTO_INCREMENT PRIMARY key,
 ds_email	varchar(100),	 
 ds_senha	int,
 nm_nick	varchar(100),	 
 dt_inclusao	datetime
 );
 
 
 CREATE table TB_CHAT (
 id_chat int AUTO_INCREMENT PRIMARY KEY,
 id_sala int, 
 id_usuario int, 
 nm_mensagem	varchar(100),	 
 dt_mensagem	datetime,
   foreign key (id_sala) references TB_SALA(id_sala),
   foreign key (id_usuario) references TB_USUARIO(id_usuario)
 );

### `caso de uso`


### `react`