konety_db - Laravel Schema Designer

roles

roles_id increments
titulo string

users

users_id increments
email string (60)
password string (60)
remember_token string (100)
ativo boolean
timestamps timestamps
softDeletes softDeletes

permissions

permissions_id increments
slug string (100)

permission_role

permissions_id ^FK integer
roles_id ^FK integer

role_user

role_id ^FK integer
users_id ^FK integer

secoes

secoes_id increments
users_id ^FK integer
ip string (15)
inicio timestamp
termino timestamp

tecnicos

tecnicos_id increments
users_id ^FK integer
nome string (100)
ativo boolean
timestamps timestamps
softDeletes softDeletes

contatos

contatos_id increments
cep string (16)
estado string (72)
cidade string (60)
bairro string (72)
logradouro string (125)
numero string (7)
complemento string (50)
telefone string (11)
celular string (11)
email string (60)
facebook string (255)
timestamps timestamps

empresas

empresas_id increments
contatos_id ^FK integer
users_id ^FK integer
razao_social string (100)
cnpj string (14)
responsavel_nome string (100)
responsavel_cpf string (20)
ativo boolean
timestamps timestamps
softDeletes softDeletes

clientes

clientes_id increments
contatos_id ^FK integer
empresas_id ^FK integer
nome string (100)
email string (60)
cpf string (20)
rg string (20)
sexo enum
data_nascimento date
pai string (100)
mae string (100)
aceitar_email boolean
observacao string (255)
ativo boolean
timestamps timestamps
softDeletes softDeletes

professores

professores_id increments
contatos_id ^FK integer
nome string (100)
cpf string (20)
rg string (20)
ativo boolean
timestamps timestamps
softDeletes softDeletes

turmas

turmas_id increments
professores_id ^FK integer
nome string (100)
ativo boolean
timestamps timestamps
softDeletes softDeletes
empresas_id ^FK integer

horarios

horarios_id increments
dia_semana enum
hora_inicio time
hora_fim time
ativo boolean
timestamps timestamps
softDeletes softDeletes

aulas

aulas_id increments
horarios_id ^FK integer
turmas_id ^FK integer
ativo boolean
timestamps timestamps

matriculas

matriculas_id increments
clientes_id ^FK integer
turmas_id ^FK integer
termo boolean
observacao string (1000)
ativo boolean
timestamps timestamps
softDeletes softDeletes

frequencias

frequencias_id increments
aulas_id ^FK integer
matriculas_id ^FK integer
data date
presenca boolean
observacao string (50)
timestamps timestamps

promocoes

promocoes_id increments
empresas_id ^FK integer
nome string (60)
premio string (255)
valor_cupom decimal (15,2)
data_inicial datetime
data_final datetime
sorteio_data_inicial datetime
sorteio_data_final datetime
ativo boolean
timestamps timestamps
softDeletes softDeletes

cupons

cupons_id increments
clientes_id ^FK integer
promocoes_id ^FK integer
nota_fiscal string (340)
data_compra datetime
valor_compra decimal (15,2)
data_impressao datetime
quantidade_cupons smallInteger
observacao string (255)
ativo boolean
timestamps timestamps
softDeletes softDeletes

log_atividades

log_atividades_id increments
secoes_id ^FK integer
tabela string (20)
momento timestamp

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01