# Generated by Django 3.1.2 on 2021-02-18 02:36

import django.core.validators
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('app_folder', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='kintai_touroku_info',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('syaincd', models.CharField(max_length=8, verbose_name='syaincd')),
                ('syainname', models.CharField(max_length=16, verbose_name='syainname')),
                ('ymd', models.DateField(default='2020-11-20', verbose_name='ymd')),
                ('starttime', models.TimeField(default='09:00', verbose_name='starttime')),
                ('endtime', models.TimeField(default='17:30', verbose_name='endtime')),
                ('worktime', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='worktime')),
                ('overtime', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='overtime')),
                ('mntime', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='mntime')),
                ('mnovertime', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='movertime')),
                ('morning', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='morning')),
                ('paidtime', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='paidtime')),
                ('resttime', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='resttime')),
                ('attkbn', models.IntegerField(default=0, verbose_name='mntime')),
                ('holidaykbn', models.IntegerField(default=0, verbose_name='movertime')),
                ('holidayriyu', models.CharField(default=0, max_length=32, verbose_name='holidayriyu')),
                ('todokekbn', models.IntegerField(default=0, verbose_name='todokekbn')),
                ('todoke_tikoku', models.IntegerField(default=0, verbose_name='todoke_tikoku')),
                ('todoke_soutai', models.IntegerField(default=0, verbose_name='todoke_soutai')),
                ('todoke_midnight', models.IntegerField(default=0, verbose_name='todoke_midnight')),
                ('todoke_hayade', models.IntegerField(default=0, verbose_name='todoke_hayade')),
                ('todoke_irregular', models.IntegerField(default=0, verbose_name='todoke_irregular')),
                ('todoke_holiwork', models.IntegerField(default=0, verbose_name='todoke_holiwork')),
                ('projectname1', models.CharField(default='', max_length=16, verbose_name='projectname')),
                ('kouteiname1', models.CharField(default='', max_length=16, verbose_name='kouteiname')),
                ('workname1', models.CharField(default='', max_length=32, verbose_name='workname')),
                ('start1', models.TimeField(default='', verbose_name='start1')),
                ('end1', models.TimeField(default='', verbose_name='end1')),
                ('rest1', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='rest1')),
                ('projectcd1', models.CharField(default='', max_length=8, verbose_name='projectcd1')),
                ('kouteicd1', models.CharField(default='', max_length=8, verbose_name='kouteicd1')),
                ('workcd1', models.CharField(default='', max_length=8, verbose_name='workcd1')),
                ('projectname2', models.CharField(default='', max_length=8, verbose_name='projectname2')),
                ('kouteiname2', models.CharField(default='', max_length=8, verbose_name='kouteiname2')),
                ('workname2', models.CharField(default='', max_length=8, verbose_name='workname2')),
                ('start2', models.TimeField(default='', verbose_name='start2')),
                ('end2', models.TimeField(default='', verbose_name='end2')),
                ('rest2', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='rest2')),
                ('projectcd2', models.CharField(default='', max_length=8, verbose_name='projectcd2')),
                ('kouteicd2', models.CharField(default='', max_length=8, verbose_name='kouteicd2')),
                ('workcd2', models.CharField(default='', max_length=8, verbose_name='workcd2')),
                ('projectname3', models.CharField(default='', max_length=16, verbose_name='projectname3')),
                ('kouteiname3', models.CharField(default='', max_length=16, verbose_name='kouteiname3')),
                ('workname3', models.CharField(default='', max_length=32, verbose_name='workname3')),
                ('start3', models.TimeField(default='', verbose_name='start3')),
                ('end3', models.TimeField(default='', verbose_name='end3')),
                ('rest3', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='rest3')),
                ('projectcd3', models.CharField(default='', max_length=8, verbose_name='projectcd3')),
                ('kouteicd3', models.CharField(default='', max_length=8, verbose_name='kouteicd3')),
                ('workcd3', models.CharField(default='', max_length=8, verbose_name='workcd3')),
                ('projectname4', models.CharField(default='', max_length=16, verbose_name='projectname4')),
                ('kouteiname4', models.CharField(default='', max_length=16, verbose_name='kouteiname4')),
                ('workname4', models.CharField(default='', max_length=32, verbose_name='workname4')),
                ('start4', models.TimeField(default='', verbose_name='start4')),
                ('end4', models.TimeField(default='', verbose_name='end4')),
                ('rest4', models.DecimalField(decimal_places=2, default=0, max_digits=5, verbose_name='rest4')),
                ('projectcd4', models.CharField(default='', max_length=8, verbose_name='projectcd4')),
                ('kouteicd4', models.CharField(default='', max_length=8, verbose_name='kouteicd4')),
                ('workcd4', models.CharField(default='', max_length=8, verbose_name='workcd4')),
            ],
            options={
                'db_table': 'kintai_touroku_info',
            },
        ),
        migrations.CreateModel(
            name='project_work',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('projectname', models.CharField(max_length=16, unique=True, verbose_name='projectname')),
                ('kouteicd', models.CharField(default='0001', max_length=8, verbose_name='kouteicd')),
                ('kouteiname', models.CharField(default='テスト', max_length=32, verbose_name='kouteiname')),
                ('workcd', models.CharField(default='00001', max_length=8, verbose_name='workcd')),
                ('workname', models.CharField(default='仕様書作成', max_length=32, verbose_name='workname')),
                ('projectcd', models.CharField(default='', max_length=8, verbose_name='projectcd')),
            ],
            options={
                'db_table': 'project_work',
            },
        ),
        migrations.CreateModel(
            name='syain_info',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('syaincd', models.CharField(max_length=8, verbose_name='syaincd')),
                ('syainname', models.CharField(max_length=16, verbose_name='syainname')),
                ('password', models.CharField(max_length=16, validators=[django.core.validators.MinLengthValidator(8, '8文字以上です！'), django.core.validators.RegexValidator('^[a-zA-Z0-9]*$', '英数字のみです！')], verbose_name='password')),
            ],
            options={
                'db_table': 'syain_info',
            },
        ),
        migrations.CreateModel(
            name='torihikisaki_list',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('customname', models.CharField(max_length=16, verbose_name='customname')),
            ],
            options={
                'db_table': 'torihikisaki_list',
            },
        ),
        migrations.CreateModel(
            name='trans_info',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('tourokukbn', models.CharField(default='申請済', max_length=16, verbose_name='shinseikbn')),
                ('tourokuno', models.CharField(default='0001', max_length=16, verbose_name='tourokunon')),
                ('syaincd', models.CharField(default='0001', max_length=16, verbose_name='syaincd')),
                ('syainname', models.CharField(default='', max_length=16, verbose_name='syaincd')),
                ('tourokudate', models.DateField(default='TODAY', max_length=16, verbose_name='tourokudate')),
                ('startdate', models.DateField(default='TODAY', max_length=16, verbose_name='startdate')),
                ('enddate', models.DateField(default='TODAY', max_length=16, verbose_name='enddate')),
                ('homon', models.CharField(default='a', max_length=16, verbose_name='homon')),
                ('kamoku', models.CharField(default='交通費', max_length=16, verbose_name='kamoku')),
                ('syudan', models.CharField(default='電車', max_length=16, verbose_name='syudan')),
                ('transport', models.IntegerField(default=0, verbose_name='transport')),
                ('k_seikyu', models.CharField(default='', max_length=2, verbose_name='transport')),
                ('customname', models.CharField(default='', max_length=16, verbose_name='customname')),
                ('seisan_kbn', models.CharField(default='現金', max_length=16, verbose_name='seisan_kbn')),
            ],
            options={
                'db_table': 'trans_info',
            },
        ),
        migrations.DeleteModel(
            name='SampleDB',
        ),
    ]
