Banco-de-Dados.md

@@ -21,170 +21,169 @@ Exemplo
 A modelagem do banco de dados é TEXTO...
 
 ## Tabela User {
-  id INT pk
-  name TEXT
-  email VARCHAR(255)
-  password VARCHAR(255)
-  phone CHAR(11)
-  cpfcnpj VARCHAR(14)
-  photoURL TEXT
-  blocked BOOLEAN
-  registrarion_number VARCHAR(50)  
-  institution_id INT fk
-  role_id INT fk
+-   id INT pk
+-   name TEXT
+-   email VARCHAR(255)
+-   password VARCHAR(255)
+-   phone CHAR(11)
+-   cpfcnpj VARCHAR(14)
+-   photoURL TEXT
+-   blocked BOOLEAN
+-   registrarion_number VARCHAR(50)  
+-   institution_id INT fk
+-   role_id INT fk
 }
 
 ## Tabela Address {
-  id INT pk
-  user_id INT fk
-  street VARCHAR(100)
-  number VARCHAR(50)
-  complement VARCHAR(100)
-  neighborhood VARCHAR(50)
-  city VARCHAR(30)
-  state VARCHAR(30)
-  contry VARCHAR(30)
-  postalCode VARCHAR(8)
+-   id INT pk
+-   user_id INT fk
+-   street VARCHAR(100)
+-   number VARCHAR(50)
+-   complement VARCHAR(100)
+-   neighborhood VARCHAR(50)
+-   city VARCHAR(30)
+-   state VARCHAR(30)
+-   contry VARCHAR(30)
+-   postalCode VARCHAR(8)
 }
 
 ## Tabela Institution {
-  id INT pk
-  name TEXT
-  cnpj VARCHAR(14)
-  latitude DECIMAL(9,6),
-  longitude DECIMAL(9,6)
-  updatedAt DATETIME
-  updatedBy TEXT
+-   id INT pk
+-   name TEXT
+-   cnpj VARCHAR(14)
+-   latitude DECIMAL(9,6),
+-   longitude DECIMAL(9,6)
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela Role {
-  id INT pk
-  title TEXT
-  updatedAt DATETIME
-  updatedBy TEXT
+-   id INT pk
+-   title TEXT
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela Event {
-  id INT pk
-  title TEXT
-  imageURL TEXT
-  description TEXT
-  date DATETIME
-  hour DATETIME
-  isOnline BOOLEAN
-  adress TEXT
-  latitude DECIMAL(9,6),
-  longitude DECIMAL(9,6),
-  project_id INT fk
-  institution_id INT fk
-  updatedBy TEXT
-  updatedAt DATETIME
+-   id INT pk
+-   title TEXT
+-   imageURL TEXT
+-   description TEXT
+-   date DATETIME
+-   hour DATETIME
+-   isOnline BOOLEAN
+-   adress TEXT
+-   latitude DECIMAL(9,6),
+-   longitude DECIMAL(9,6),
+-   project_id INT fk
+-   institution_id INT fk
+-   updatedBy TEXT
+-   updatedAt DATETIME
 }
 
 ## Tabela Project {
-  id INT pk
-  name TEXT
-  history TEXTUser {
-  id INT pk
-  name TEXT
-  email VARCHAR(255)
-  password VARCHAR(255)
-  phone CHAR(11)
-  cpfcnpj VARCHAR(14)
-  photoURL TEXT
-  blocked BOOLEAN
-  complement VARCHAR(100)
-  neighborhood
-  imageURL TEXT
-  purpose TEXT
-  contact VARCHAR(50)
-  start_date DATE
-  end_date DATE
-  status VARCHAR(30)
-  teacher_id INT fk
-  institution_id INT fk
-  updatedAt DATETIME
-  updatedBy TEXT
+-   id INT pk
+-   name TEXT
+-   history TEXTUser {
+-   id INT pk
+-   name TEXT
+-   email VARCHAR(255)
+-   password VARCHAR(255)
+-   phone CHAR(11)
+-   cpfcnpj VARCHAR(14)
+-   photoURL TEXT
+-   blocked BOOLEAN
+-   complement VARCHAR(100)
+-   neighborhood
+-   imageURL TEXT
+-   purpose TEXT
+-   contact VARCHAR(50)
+-   start_date DATE
+-   end_date DATE
+-   status VARCHAR(30)
+-   teacher_id INT fk
+-   institution_id INT fk
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela Category {
-  id INT pk
-  name TEXT
-  type INT
-  updatedAt DATETIME
-  updatedBy TEXT
+-   id INT pk
+-   name TEXT
+-   type INT
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela Keyword {
-  id INT pk,
-  word TEXT
-  updatedAt DATETIME
-  updatedBy TEXT
+-   id INT pk,
+-   word TEXT
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela GeneralParameters {
-  id INT pk,
-  parameter Json
-  content TEXT
-  updatedAt DATETIME
-  updatedBy TEXT
+-   id INT pk,
+-   parameter Json
+-   content TEXT
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela SocialNetwork {
-  id INT pk 
-  name TEXT
-  icon TEXT
-  updatedAt DATETIME
-  updatedBy TEXT
+-   id INT pk 
+-   name TEXT
+-   icon TEXT
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela Post {
-  id INT pk
-  content TEXT
-  project_id INT fk
-  event_id INT fk 
-  user_id INT fk
-  updatedAt DATETIME
-  updatedBy TEXT
+-   id INT pk
+-   content TEXT
+-   project_id INT fk
+-   event_id INT fk 
+-   user_id INT fk
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela PostLikes {
-  id INT pk 
-  post_id INT fk
-  user_id INT fk
-  updatedAt DATETIME
-  updatedBy TEXT
+-   id INT pk 
+-   post_id INT fk
+-   user_id INT fk
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela PostComments {
-  id INT pk
-  content TEXT
-  post_id INT fk
-  user_id INT fk
-  updatedAt DATETIME
-  updatedBy TEXT
+-   id INT pk
+-   content TEXT
+-   post_id INT fk
+-   user_id INT fk
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
-//many to many
 ## Tabela ProjectCategory {
-  project_id INT fk
-  category_id INT fk
-  updatedAt DATETIME
-  updatedBy TEXT
+-   project_id INT fk
+-   category_id INT fk
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela EventCategory {
-  event_id INT fk
-  category_id INT fk
-  updatedAt DATETIME
-  updatedBy TEXT
+-   event_id INT fk
+-   category_id INT fk
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela ProjectKeyword {
-  project_id INT fk,
-  keyword_id INT fk
-  updatedAt DATETIME
-  updatedBy TEXT
+-   project_id INT fk,
+-   keyword_id INT fk
+-   updatedAt DATETIME
+-   updatedBy TEXT
 }
 
 ## Tabela UsersSocialNetwork {
@@ -194,7 +193,3 @@ A modelagem do banco de dados é TEXTO...
 -   updatedAt DATETIME
 -   updatedBy TEXT
 }
-
-## Tabela `Texto`
-Utilizada para 'Texto'. Suas colunas são:
-- `texto`, chave primária da entidade
\ No newline at end of file