Skip to content

GitLab

Banco de Dados · Changes

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