class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Pessoa',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nome', models.CharField(max_length=255)),
('cpf',
cpf_field.models.CPFField(max_length=14, verbose_name='CPF')),
('data_de_nascimento', models.DateField()),
('phone',
phone_field.models.PhoneField(
blank=True,
help_text='Contact phone number',
max_length=31)),
('sexo',
models.CharField(choices=[('Masculino', 'Masculino'),
('Feminino', 'Feminino')],
max_length=9)),
('data', models.DateTimeField(auto_now=True)),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('web', '0007_remove_tb_estoque_tx_lucro'),
]
operations = [
migrations.CreateModel(
name='Tb_cliente',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nome', models.CharField(max_length=100,
verbose_name='Nome')),
('cpf',
cpf_field.models.CPFField(max_length=14, verbose_name='cpf')),
('cep', models.IntegerField(max_length=8, verbose_name='CEP')),
('endereco',
models.CharField(max_length=200, verbose_name='Endereço')),
('bairro',
models.CharField(max_length=50, verbose_name='Bairro')),
('uf', models.CharField(max_length=2, verbose_name='Uf')),
('dt_nascimento',
models.DateField(verbose_name='Data de nascimento')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Farmer',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('cpf', cpf_field.models.CPFField(max_length=14, verbose_name='cpf')),
('email', models.EmailField(max_length=254)),
('name', models.CharField(max_length=255)),
],
options={
'db_table': 'farmer',
},
),
migrations.CreateModel(
name='Tillage',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('location', django.contrib.gis.db.models.fields.PointField(srid=4326)),
('type', models.CharField(max_length=255)),
('harvest_date', models.DateField()),
],
options={
'db_table': 'tillage',
},
),
migrations.CreateModel(
name='LossCommunication',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('loss_cause', models.CharField(choices=[('EXCESSIVE_RAIN', 'Chuva excessiva'), ('FROST', 'Geada'), ('FROZEN_RAIN', 'Granizo'), ('DRY', 'Seca'), ('GALE', 'Vendaval'), ('THUNDER', 'Raio')], max_length=255)),
('farmer', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='loss_communication.farmer')),
('tillage', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='loss_communication.tillage')),
],
options={
'db_table': 'loss_communication',
},
),
]
class Migration(migrations.Migration):
dependencies = [
('web', '0011_tb_fornecedor'),
]
operations = [
migrations.CreateModel(
name='Tb_vendas',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nome',
models.CharField(max_length=100,
verbose_name='Nome do cliente')),
('cpf',
cpf_field.models.CPFField(max_length=14, verbose_name='cpf')),
('valor',
models.DecimalField(decimal_places=2,
max_digits=15,
null=True,
verbose_name='Valor do pedido')),
('cep', models.IntegerField(verbose_name='CEP')),
('endereco',
models.CharField(max_length=200,
verbose_name='Endereço do cliente')),
('dt', models.DateField(verbose_name='Data do pedido')),
('codigo',
models.IntegerField(verbose_name='Codigo do produto')),
('status',
models.CharField(
max_length=45,
verbose_name=
'Status: Separando / Processando / Entregue / Cancelado')
),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('web', '0009_auto_20201208_1223'),
]
operations = [
migrations.CreateModel(
name='Tb_usuario',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nome', models.CharField(max_length=100, verbose_name='Nome')),
('cpf', cpf_field.models.CPFField(max_length=14, verbose_name='cpf')),
('cep', models.IntegerField(verbose_name='CEP')),
('endereco', models.CharField(max_length=200, verbose_name='Endereço')),
('email', models.EmailField(max_length=254)),
('telefone', phone_field.models.PhoneField(blank=True, help_text='Contact phone number', max_length=31)),
('dt_nascimento', models.DateField(verbose_name='Data de nascimento')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='Usuario',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=150,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('email',
models.EmailField(max_length=254,
unique=True,
verbose_name='E-mail')),
('data_nascimento', models.DateField(blank=True, null=True)),
('celular',
models.CharField(blank=True, max_length=50, null=True)),
('cpf',
cpf_field.models.CPFField(max_length=14, verbose_name='cpf')),
('is_staff',
models.BooleanField(default=True,
verbose_name='Membro da equipe')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'db_table': 'usuario',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Dados_usuario',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cpf',
cpf_field.models.CPFField(blank=True,
max_length=14,
null=True,
verbose_name='cpf')),
('nome', models.CharField(blank=True,
max_length=255,
null=True)),
('sobrenome',
models.CharField(blank=True, max_length=255, null=True)),
('data_nascimento',
models.DateField(blank=True,
null=True,
verbose_name='Data de Nascimento')),
('telefone',
models.CharField(blank=True, max_length=12, null=True)),
('cep',
models.CharField(blank=True,
max_length=8,
null=True,
unique=True)),
('cidade',
models.CharField(blank=True, max_length=255, null=True)),
('estado', models.CharField(blank=True,
max_length=2,
null=True)),
('rua', models.CharField(blank=True, max_length=255,
null=True)),
('bairro',
models.CharField(blank=True, max_length=255, null=True)),
('complemento',
models.CharField(blank=True, max_length=255, null=True)),
('foto',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='Imagem')),
('user',
models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Aula',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('modified_at', models.DateTimeField(auto_now=True)),
('status',
models.IntegerField(choices=[(1, 'Ativo'), (0, 'Inativo')],
default=1)),
('nome', models.CharField(max_length=100,
verbose_name='Nome')),
('description',
models.TextField(blank=True, verbose_name='Descrição')),
('ordem',
models.IntegerField(blank=True,
default=0,
verbose_name='Número (Ordem)')),
('data_liberacao',
models.DateField(blank=True,
null=True,
verbose_name='Data de Liberação')),
('slug',
models.SlugField(max_length=255,
unique=True,
verbose_name='Slug')),
('created_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='aula_created',
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name_plural': 'Aulas',
'db_table': 'aula',
},
),
migrations.CreateModel(
name='Curso',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('modified_at', models.DateTimeField(auto_now=True)),
('status',
models.IntegerField(choices=[(1, 'Ativo'), (0, 'Inativo')],
default=1)),
('nome',
models.CharField(max_length=255,
verbose_name='Nome do Curso')),
('description',
models.TextField(blank=True,
verbose_name='Descrição Simples')),
('about',
models.TextField(blank=True, verbose_name='Sobre o Curso')),
('data_inicio',
models.DateField(blank=True,
null=True,
verbose_name='Data de Início')),
('image',
models.ImageField(blank=True,
null=True,
upload_to='courses/images',
verbose_name='Imagem do Curso')),
('slug',
models.SlugField(max_length=255,
unique=True,
verbose_name='Slug')),
('created_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='curso_created',
to=settings.AUTH_USER_MODEL)),
('modified_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='curso_modified',
to=settings.AUTH_USER_MODEL)),
('professor',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
verbose_name='Usuário')),
],
options={
'verbose_name_plural': 'Cursos',
'db_table': 'curso',
},
),
migrations.CreateModel(
name='Setor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('modified_at', models.DateTimeField(auto_now=True)),
('status',
models.IntegerField(choices=[(1, 'Ativo'), (0, 'Inativo')],
default=1)),
('secretaria',
models.CharField(max_length=255, verbose_name='Secretaria')),
('diretoria',
models.CharField(max_length=255, verbose_name='Diretoria')),
('divisao',
models.CharField(max_length=255, verbose_name='Divisão')),
('setor', models.CharField(max_length=255,
verbose_name='Setor')),
('slug',
models.SlugField(max_length=255,
unique=True,
verbose_name='Slug')),
('created_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='setor_created',
to=settings.AUTH_USER_MODEL)),
('modified_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='setor_modified',
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name_plural': 'Setores',
'db_table': 'setor',
},
),
migrations.CreateModel(
name='Pessoa',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('modified_at', models.DateTimeField(auto_now=True)),
('status',
models.IntegerField(choices=[(1, 'Ativo'), (0, 'Inativo')],
default=1)),
('acesso',
models.IntegerField(blank=True,
choices=[(1, 'Professor'), (0, 'Aluno')],
null=True,
verbose_name='Tipo de Acesso')),
('nome', models.CharField(max_length=255,
verbose_name='Nome')),
('data_nascimento',
models.DateTimeField(verbose_name='Data de Nascimento')),
('cpf',
cpf_field.models.CPFField(max_length=14, verbose_name='CPF')),
('email',
models.EmailField(max_length=254, verbose_name='Email')),
('whats',
models.CharField(max_length=15, verbose_name='WhatsApp')),
('slug',
models.SlugField(max_length=255,
unique=True,
verbose_name='Slug')),
('created_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='pessoa_created',
to=settings.AUTH_USER_MODEL)),
('modified_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='pessoa_modified',
to=settings.AUTH_USER_MODEL)),
('setor',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='ead.setor',
verbose_name='Setor')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
verbose_name='Usuário')),
],
options={
'verbose_name_plural': 'Pessoas',
'db_table': 'pessoa',
},
),
migrations.CreateModel(
name='Material',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('modified_at', models.DateTimeField(auto_now=True)),
('status',
models.IntegerField(choices=[(1, 'Ativo'), (0, 'Inativo')],
default=1)),
('nome', models.CharField(max_length=100,
verbose_name='Nome')),
('embedded',
models.TextField(blank=True, verbose_name='Vídeo embedded')),
('file',
models.FileField(blank=True,
null=True,
upload_to='aulas/materiais')),
('slug',
models.SlugField(max_length=255,
unique=True,
verbose_name='Slug')),
('aula',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='materiais',
to='ead.aula',
verbose_name='Aula')),
('created_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='material_created',
to=settings.AUTH_USER_MODEL)),
('modified_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='material_modified',
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name_plural': 'Materiais',
'db_table': 'material',
},
),
migrations.CreateModel(
name='Inscricao',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('modified_at', models.DateTimeField(auto_now=True)),
('status',
models.IntegerField(choices=[(1, 'Ativo'), (0, 'Inativo')],
default=1)),
('situacao',
models.IntegerField(blank=True,
choices=[(0, 'Pendente'), (1, 'Aprovado'),
(2, 'Cancelado')],
default=1,
verbose_name='Situação')),
('slug',
models.SlugField(max_length=255,
unique=True,
verbose_name='Slug')),
('course',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='inscritos',
to='ead.curso',
verbose_name='Curso')),
('created_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='inscricao_created',
to=settings.AUTH_USER_MODEL)),
('modified_by',
models.ForeignKey(editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='inscricao_modified',
to=settings.AUTH_USER_MODEL)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='inscritos',
to=settings.AUTH_USER_MODEL,
verbose_name='Usuário')),
],
options={
'verbose_name_plural': 'Inscrições',
'db_table': 'inscricao',
},
),
migrations.AddField(
model_name='aula',
name='curso',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='aulas',
to='ead.curso',
verbose_name='Curso'),
),
migrations.AddField(
model_name='aula',
name='modified_by',
field=models.ForeignKey(
editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='aula_modified',
to=settings.AUTH_USER_MODEL),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Profile_user',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('autor', models.CharField(max_length=50)),
('CRM', models.IntegerField()),
('Estado_CRM',
models.CharField(choices=[('A', 'Acre (AC)'),
('B', 'Alagoas (AL)'),
('C', 'Amapá (AP)'),
('D', 'Amazonas (AM)'),
('E', 'Bahia (BA'),
('F', 'Ceará (CE)'),
('G', 'Distrito Federal (DF)'),
('H', 'Espírito Santo (ES)'),
('I', 'Goiás (GO)'),
('J', 'Maranhão (MA)'),
('K', 'Mato Grosso (MT)'),
('L', 'Mato Grosso do Sul (MS)'),
('M', 'Minas Gerais (MG)'),
('N', 'Pará (PA)'),
('O', 'Paraíba (PB)'),
('P', 'Paraná (PR)'),
('Q', 'Pernambuco (PE)'),
('R', 'Piauí (PI)'),
('S', 'Rio de Janeiro (RJ)'),
('T', 'Rio Grande do Norte (RN)'),
('U', 'Rio Grande do Sul (RS)'),
('V', 'Rondônia (RO)'),
('X', 'Roraima (RR)'),
('Y', 'Santa Catarina (SC)'),
('Z', 'São Paulo (SP)'),
('W', 'Sergipe (SE)'),
('Ç', 'Tocantin (TO)')],
max_length=1)),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Post',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('Exame',
models.CharField(choices=[('Covid-19', 'Covid-19'),
('Leishmaniose', 'Leishmaniose')],
max_length=20)),
('Nome_do_paciente', models.CharField(max_length=50)),
('Cpf_paciente',
cpf_field.models.CPFField(max_length=14, verbose_name='cpf')),
('Sexo', models.CharField(max_length=10)),
('Data_de_nascimento', models.DateField()),
('created_date',
models.DateTimeField(default=django.utils.timezone.now)),
('published_date', models.DateTimeField(blank=True,
null=True)),
('four_digit_code', models.IntegerField(null=True)),
('author', models.TextField()),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]