# Generated by Django 5.0.6 on 2026-03-03 13:13 import django.contrib.auth.models import django.contrib.auth.validators import django.utils.timezone from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='Account', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('type', models.CharField(max_length=1, null=True)), ('payment', models.DecimalField(decimal_places=2, max_digits=13, null=True)), ('credit', models.IntegerField(null=True)), ('lastpayment', models.DecimalField(decimal_places=2, max_digits=13, null=True)), ('lastpaymentdatetime', models.DateTimeField(null=True)), ('lastcredit', models.IntegerField(null=True)), ('lastcreditdatetime', models.DateTimeField(null=True)), ('balance', models.IntegerField(null=True)), ('lowcreditsnotification', models.CharField(blank=True, max_length=1, null=True)), ], options={ 'db_table': 'account', }, ), migrations.CreateModel( name='Branding', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('logourl', models.FileField(null=True, upload_to='logos/')), ('content', models.TextField(null=True)), ('sociallinks', models.TextField(null=True)), ('status', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'branding', }, ), migrations.CreateModel( name='Brules', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('workflowid', models.IntegerField(blank=True, null=True)), ('companyid', models.IntegerField(blank=True, null=True)), ('jobdescid', models.IntegerField(blank=True, null=True)), ('paperid', models.IntegerField(blank=True, null=True)), ('passscore', models.IntegerField(blank=True, null=True)), ('passevent', models.IntegerField(blank=True, null=True)), ('failevent', models.IntegerField(blank=True, null=True)), ('hold', models.CharField(blank=True, max_length=1, null=True)), ('holdpercentage', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'brules', }, ), migrations.CreateModel( name='CallSchedule', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('candidateid', models.IntegerField(null=True)), ('hrid', models.IntegerField(null=True)), ('paper_id', models.IntegerField(null=True)), ('interviewerid', models.IntegerField(null=True)), ('datentime', models.DateTimeField(null=True)), ('status', models.CharField(max_length=1, null=True)), ('callstarteddtt', models.DateTimeField(null=True)), ('callendeddtt', models.DateTimeField(null=True)), ('instructions', models.CharField(max_length=1000, null=True)), ('intnotes', models.CharField(max_length=1000, null=True)), ('meetinglink', models.CharField(max_length=100, null=True)), ('callendflag', models.CharField(max_length=1, null=True)), ('companyid', models.IntegerField(null=True)), ('audioscore', models.IntegerField(null=True)), ('audiolevel', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'callschedule', }, ), migrations.CreateModel( name='Candidate', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('candidateid', models.CharField(max_length=100, null=True)), ('firstname', models.CharField(max_length=100, null=True)), ('lastname', models.CharField(max_length=100, null=True)), ('registrationdate', models.DateTimeField(null=True)), ('companyid', models.IntegerField(null=True)), ('email', models.CharField(max_length=100, null=True)), ('mobile', models.CharField(max_length=40, null=True)), ('add1', models.CharField(max_length=100, null=True)), ('add2', models.CharField(max_length=100, null=True)), ('city', models.CharField(max_length=100, null=True)), ('state', models.CharField(max_length=100, null=True)), ('country', models.CharField(max_length=40, null=True)), ('dob', models.DateField(null=True)), ('jobid', models.IntegerField(null=True)), ('status', models.CharField(max_length=1, null=True)), ('deleteflag', models.CharField(max_length=1, null=True)), ('source', models.CharField(max_length=5, null=True)), ('profileid', models.IntegerField(null=True)), ], options={ 'db_table': 'candidate', }, ), migrations.CreateModel( name='CdnData', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('libraryid', models.CharField(max_length=50, null=True)), ('libraryname', models.CharField(max_length=100, null=True)), ('pullzoneid', models.CharField(max_length=100, null=True)), ('hostname', models.CharField(max_length=100, null=True)), ('authkey', models.CharField(max_length=100, null=True)), ], options={ 'db_table': 'cdndata', }, ), migrations.CreateModel( name='Client', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(blank=True, max_length=100, null=True)), ('companyid', models.IntegerField(blank=True, null=True)), ('createdat', models.DateTimeField(blank=True, null=True)), ('status', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'client', }, ), migrations.CreateModel( name='Company', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=100)), ('address1', models.CharField(blank=True, max_length=100, null=True)), ('address2', models.CharField(blank=True, max_length=100, null=True)), ('city', models.CharField(blank=True, max_length=100, null=True)), ('state', models.CharField(blank=True, max_length=100, null=True)), ('country', models.CharField(blank=True, max_length=100, null=True)), ('companydomain', models.CharField(blank=True, max_length=100, null=True)), ('status', models.CharField(blank=True, max_length=1, null=True)), ('website', models.CharField(blank=True, max_length=100, null=True)), ('phone1', models.CharField(blank=True, max_length=100, null=True)), ('phone2', models.CharField(blank=True, max_length=100, null=True)), ('email', models.CharField(blank=True, max_length=100, null=True)), ('emaildomain', models.CharField(max_length=100, null=True)), ('companytype', models.CharField(blank=True, max_length=100, null=True)), ('freetrail', models.CharField(max_length=1, null=True)), ('registrationdate', models.DateTimeField(null=True)), ('contactperson', models.CharField(blank=True, max_length=100, null=True)), ('resumetemplateid', models.IntegerField(null=True)), ], options={ 'db_table': 'company', }, ), migrations.CreateModel( name='CompanyCredits', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('transtype', models.CharField(max_length=1, null=True)), ('credits', models.IntegerField(null=True)), ], options={ 'db_table': 'companycredits', }, ), migrations.CreateModel( name='CompanyData', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyname', models.CharField(blank=True, max_length=120, null=True)), ('companyemail', models.CharField(blank=True, max_length=120, null=True)), ('location', models.CharField(blank=True, max_length=120, null=True)), ('contactperson', models.CharField(blank=True, max_length=50, null=True)), ('companytype', models.CharField(blank=True, max_length=100, null=True)), ('registerationtime', models.DateTimeField(blank=True, null=True)), ('demorequest', models.CharField(blank=True, max_length=1, null=True)), ], options={ 'db_table': 'companydata', }, ), migrations.CreateModel( name='Credits', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('transdatetime', models.DateTimeField(null=True)), ('transtype', models.CharField(max_length=1, null=True)), ('papertype', models.CharField(max_length=1, null=True)), ('points', models.IntegerField(null=True)), ('user', models.IntegerField(null=True)), ('transid', models.IntegerField(null=True)), ('balance', models.IntegerField(null=True)), ], options={ 'db_table': 'credits', }, ), migrations.CreateModel( name='Email_template', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('company_id', models.IntegerField(blank=True, null=True)), ('template_name', models.CharField(max_length=120, null=True)), ('paper_type', models.CharField(max_length=100, null=True)), ('event', models.CharField(max_length=120, null=True)), ('sender_email', models.CharField(max_length=100, null=True)), ('sender_label', models.CharField(max_length=100, null=True)), ('email_subject', models.CharField(blank=True, max_length=300, null=True)), ('email_body', models.CharField(blank=True, max_length=10000, null=True)), ('template_heading', models.CharField(max_length=300, null=True)), ('email_attachment', models.CharField(max_length=250, null=True)), ('email_attachment_path', models.FileField(null=True, upload_to='email_attachments/')), ('email_attachment_name', models.CharField(max_length=120, null=True)), ], options={ 'db_table': 'email_template', }, ), migrations.CreateModel( name='ExtendedHours', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('empid', models.IntegerField(null=True)), ('workcalid', models.IntegerField(null=True)), ('fromdate', models.DateField(null=True)), ('todate', models.DateField(null=True)), ('starttime', models.TimeField(max_length=20, null=True)), ('workhours', models.CharField(max_length=4, null=True)), ('status', models.CharField(max_length=1, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'extendedhours', }, ), migrations.CreateModel( name='HolidayCal', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('holidaydt', models.DateField(null=True)), ('type', models.CharField(max_length=1, null=True)), ('description', models.CharField(max_length=100, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'holidaycal', }, ), migrations.CreateModel( name='InterviewMedia', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('recorded', models.CharField(max_length=200, null=True)), ('candidateid', models.CharField(max_length=40, null=True)), ('scheduleid', models.IntegerField(null=True)), ], options={ 'db_table': 'interviewmedia', }, ), migrations.CreateModel( name='IvFeedback', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('candidateid', models.IntegerField(null=True)), ('gonogo', models.CharField(max_length=1, null=True)), ('interviewerid', models.IntegerField(null=True)), ('notes', models.CharField(max_length=100, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'ivfeedback', }, ), migrations.CreateModel( name='JdAnalysis', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('sourcecode', models.CharField(max_length=5, null=True)), ('papertype', models.CharField(max_length=1, null=True)), ('registration', models.IntegerField(null=True)), ('submission', models.IntegerField(null=True)), ('efficiency', models.IntegerField(null=True)), ('durationmin', models.IntegerField(null=True)), ('durationmax', models.IntegerField(null=True)), ('durationavg', models.IntegerField(null=True)), ('jobid', models.IntegerField(null=True)), ('leadtimemin', models.IntegerField(null=True)), ('leadtimemax', models.IntegerField(null=True)), ('leadtimeavg', models.IntegerField(null=True)), ], options={ 'db_table': 'jdanalysis', }, ), migrations.CreateModel( name='JDJobBoards', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(blank=True, null=True)), ('jobdescid', models.IntegerField(blank=True, null=True)), ('jobboardid', models.IntegerField(blank=True, null=True)), ('publishedon', models.DateTimeField(blank=True, null=True)), ('publishedby', models.IntegerField(blank=True, null=True)), ('status', models.CharField(blank=True, max_length=1, null=True)), ], options={ 'db_table': 'jdjobboard', }, ), migrations.CreateModel( name='jdlibrary', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('title', models.CharField(max_length=350, null=True)), ('description', models.CharField(max_length=3024, null=True)), ('role', models.CharField(max_length=50)), ('min_exp', models.IntegerField()), ('max_exp', models.IntegerField()), ('primary_skills', models.CharField(max_length=2048, null=True)), ('secondary_skills', models.CharField(max_length=2048, null=True)), ('work_location', models.CharField(max_length=512, null=True)), ], options={ 'db_table': 'jdlibrary', }, ), migrations.CreateModel( name='JobBoard', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(blank=True, max_length=100, null=True)), ('logo_path', models.CharField(blank=True, max_length=100, null=True)), ('status', models.CharField(blank=True, max_length=1, null=True)), ], options={ 'db_table': 'jobboard', }, ), migrations.CreateModel( name='JobBoardCredential', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(blank=True, null=True)), ('jobboardid', models.IntegerField(blank=True, null=True)), ('apikey', models.CharField(blank=True, max_length=512, null=True)), ('endpoint', models.CharField(blank=True, max_length=512, null=True)), ('username', models.CharField(blank=True, max_length=100, null=True)), ('password', models.CharField(blank=True, max_length=100, null=True)), ('status', models.CharField(blank=True, max_length=1, null=True)), ], options={ 'db_table': 'jobboardcredential', }, ), migrations.CreateModel( name='JobDesc', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('jobcode', models.CharField(max_length=20, null=True)), ('jdlibraryid', models.IntegerField(null=True)), ('title', models.CharField(max_length=350, null=True)), ('role', models.CharField(max_length=100, null=True)), ('description', models.CharField(max_length=3024, null=True)), ('expmin', models.IntegerField(null=True)), ('expmax', models.IntegerField(null=True)), ('department', models.CharField(max_length=100, null=True)), ('location', models.CharField(max_length=512, null=True)), ('budget', models.DecimalField(decimal_places=2, max_digits=13, null=True)), ('skillset', models.CharField(max_length=512, null=True)), ('secondaryskills', models.CharField(max_length=2048, null=True)), ('skillnotes', models.CharField(max_length=512, null=True)), ('interviewers', models.CharField(max_length=100, null=True)), ('expjoindate', models.DateField(max_length=11, null=True)), ('positions', models.IntegerField(null=True)), ('createdby', models.IntegerField(null=True)), ('createdon', models.DateTimeField(null=True)), ('companyid', models.IntegerField(null=True)), ('status', models.CharField(max_length=1, null=True)), ('dashboardflag', models.CharField(max_length=1, null=True)), ('approval_status', models.CharField(max_length=1, null=True)), ('comments', models.CharField(max_length=100, null=True)), ('recruiterids', models.CharField(max_length=100, null=True)), ('hiringmanagerid', models.IntegerField(null=True)), ('webpublish', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'jobdesc', }, ), migrations.CreateModel( name='Lookupmaster', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('lookupid', models.IntegerField(null=True)), ('lookupmasterid', models.IntegerField(null=True)), ('lookupname', models.CharField(max_length=150, null=True)), ('lookupparam1', models.TextField(null=True)), ('lookupparam2', models.CharField(max_length=150, null=True)), ('status', models.CharField(max_length=1, null=True)), ('comments', models.CharField(max_length=300, null=True)), ], options={ 'db_table': 'lookupmaster', }, ), migrations.CreateModel( name='Payments', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('dateofpay', models.DateTimeField(null=True)), ('modeofpay', models.CharField(max_length=1, null=True)), ('amount', models.DecimalField(decimal_places=2, max_digits=13, null=True)), ('credits', models.IntegerField(null=True)), ], options={ 'db_table': 'payments', }, ), migrations.CreateModel( name='Profile', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('sourceid', models.IntegerField(blank=True, null=True)), ('resumeid', models.IntegerField(blank=True, null=True)), ('companyid', models.IntegerField(null=True)), ('dateofcreation', models.DateTimeField(blank=True, null=True)), ('title', models.CharField(blank=True, max_length=100, null=True)), ('firstname', models.CharField(blank=True, max_length=100, null=True)), ('middlename', models.CharField(blank=True, max_length=40, null=True)), ('lastname', models.CharField(blank=True, max_length=100, null=True)), ('email', models.CharField(blank=True, max_length=100, null=True)), ('mobile', models.CharField(blank=True, max_length=50, null=True)), ('linkedin', models.CharField(blank=True, max_length=100, null=True)), ('facebook', models.CharField(blank=True, max_length=100, null=True)), ('passportnum', models.CharField(blank=True, max_length=40, null=True)), ('dateofbirth', models.DateTimeField(blank=True, null=True)), ('fathername', models.CharField(blank=True, max_length=100, null=True)), ('nativeof', models.CharField(blank=True, max_length=100, null=True)), ('strength', models.IntegerField(null=True)), ('educationscore', models.IntegerField(null=True)), ('experiencescore', models.IntegerField(null=True)), ('projectsscore', models.IntegerField(null=True)), ('skillsscore', models.IntegerField(null=True)), ('certificatesscore', models.IntegerField(null=True)), ('awardsscore', models.IntegerField(null=True)), ('status', models.CharField(blank=True, max_length=1, null=True)), ('profilecode', models.CharField(blank=True, max_length=20, null=True)), ], options={ 'db_table': 'profile', }, ), migrations.CreateModel( name='ProfileActivity', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('profileid', models.IntegerField(blank=True, null=True)), ('datentime', models.DateTimeField(blank=True, null=True)), ('sequence', models.IntegerField(blank=True, null=True)), ('activitycode', models.CharField(blank=True, max_length=3, null=True)), ('acvityuserid', models.IntegerField(blank=True, null=True)), ('activityname', models.CharField(blank=True, max_length=100, null=True)), ('activityremarks', models.CharField(blank=True, max_length=200, null=True)), ('activitystatus', models.CharField(blank=True, max_length=100, null=True)), ('companyid', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'profileactivity', }, ), migrations.CreateModel( name='ProfileAddress', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('profileid', models.IntegerField(blank=True, null=True)), ('addline1', models.CharField(blank=True, max_length=100, null=True)), ('addline2', models.CharField(blank=True, max_length=100, null=True)), ('city', models.CharField(blank=True, max_length=100, null=True)), ('state', models.CharField(blank=True, max_length=40, null=True)), ('country', models.CharField(blank=True, max_length=40, null=True)), ('zipcode', models.CharField(blank=True, max_length=20, null=True)), ], options={ 'db_table': 'profileaddress', }, ), migrations.CreateModel( name='ProfileAnalysis', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('day', models.IntegerField(blank=True, null=True)), ('month', models.IntegerField(blank=True, null=True)), ('year', models.IntegerField(blank=True, null=True)), ('userid', models.IntegerField(null=True)), ('activitycode', models.CharField(blank=True, max_length=3, null=True)), ('profilescount', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'profileanalysis', }, ), migrations.CreateModel( name='ProfileAwards', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('profileid', models.IntegerField(blank=True, null=True)), ('sequence', models.IntegerField(blank=True, null=True)), ('awardname', models.CharField(blank=True, max_length=100, null=True)), ('year', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'profileawards', }, ), migrations.CreateModel( name='ProfileCertificates', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('profileid', models.IntegerField(blank=True, null=True)), ('certname', models.CharField(blank=True, max_length=100, null=True)), ('sequence', models.IntegerField(blank=True, null=True)), ('year', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'profilecertificates', }, ), migrations.CreateModel( name='ProfileEducation', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('profileid', models.IntegerField(blank=True, null=True)), ('sequence', models.IntegerField(blank=True, null=True)), ('course', models.CharField(blank=True, max_length=100, null=True)), ('institute', models.CharField(blank=True, max_length=100, null=True)), ('yearfrom', models.IntegerField(blank=True, null=True)), ('yearto', models.IntegerField(blank=True, null=True)), ('grade', models.CharField(blank=True, max_length=100, null=True)), ], options={ 'db_table': 'profileeducation', }, ), migrations.CreateModel( name='ProfileExperience', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('profileid', models.IntegerField(blank=True, null=True)), ('sequence', models.IntegerField(blank=True, null=True)), ('jobtitle', models.CharField(blank=True, max_length=100, null=True)), ('company', models.CharField(blank=True, max_length=100, null=True)), ('yearfrom', models.IntegerField(blank=True, null=True)), ('yearto', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'profileexperience', }, ), migrations.CreateModel( name='ProfileProjects', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('profileid', models.IntegerField(blank=True, null=True)), ('sequence', models.IntegerField(blank=True, null=True)), ('projectname', models.CharField(blank=True, max_length=100, null=True)), ('clientname', models.CharField(blank=True, max_length=100, null=True)), ('roleplayed', models.CharField(blank=True, max_length=100, null=True)), ('skillsused', models.CharField(blank=True, max_length=100, null=True)), ('yearsfrom', models.IntegerField(blank=True, null=True)), ('yearsto', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'profileprojects', }, ), migrations.CreateModel( name='ProfileSkills', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('profileid', models.IntegerField(blank=True, null=True)), ('primaryskills', models.CharField(blank=True, max_length=256, null=True)), ('secondaryskills', models.CharField(blank=True, max_length=256, null=True)), ], options={ 'db_table': 'profileskills', }, ), migrations.CreateModel( name='QResponse', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('qid', models.IntegerField(null=True)), ('candidateid', models.IntegerField(null=True)), ('callscheduleid', models.IntegerField(null=True)), ('response', models.CharField(max_length=256, null=True)), ('notes', models.CharField(max_length=256, null=True)), ('qrate', models.CharField(max_length=10, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'qresponse', }, ), migrations.CreateModel( name='ReferenceId', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('type', models.CharField(max_length=1, null=True)), ('prefix1', models.CharField(max_length=3, null=True)), ('prefix2', models.CharField(max_length=3, null=True)), ('prefix3', models.CharField(max_length=3, null=True)), ('lastid', models.IntegerField(null=True)), ], options={ 'db_table': 'referenceid', }, ), migrations.CreateModel( name='Registration', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('candidateid', models.IntegerField(null=True)), ('jobid', models.IntegerField(null=True)), ('paperid', models.IntegerField(null=True)), ('papertype', models.CharField(blank=True, max_length=1, null=True)), ('companyid', models.IntegerField(null=True)), ('registrationdate', models.DateTimeField(null=True)), ('completiondate', models.DateTimeField(null=True)), ('status', models.CharField(blank=True, max_length=1, null=True)), ], options={ 'db_table': 'registration', }, ), migrations.CreateModel( name='Resume', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('sourceid', models.IntegerField(null=True)), ('filename', models.CharField(max_length=100, null=True)), ('mailid', models.CharField(max_length=200, null=True)), ('datentime', models.DateTimeField(auto_now_add=True)), ('companyid', models.IntegerField(null=True)), ('status', models.CharField(max_length=1, null=True)), ('docparserid', models.IntegerField(null=True)), ('jobid', models.IntegerField(null=True)), ], options={ 'db_table': 'resume', }, ), migrations.CreateModel( name='ResumeFile', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('resumeid', models.IntegerField(null=True)), ('filename', models.CharField(max_length=100, null=True)), ('filecontent', models.BinaryField(null=True)), ], options={ 'db_table': 'resumefile', }, ), migrations.CreateModel( name='ResumeTemplate', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(blank=True, max_length=40, null=True)), ('thumbnail', models.CharField(blank=True, max_length=100, null=True)), ('filename', models.CharField(blank=True, max_length=100, null=True)), ('default_template', models.CharField(blank=True, max_length=1, null=True)), ('status', models.CharField(blank=True, max_length=1, null=True)), ], options={ 'db_table': 'resumetemplate', }, ), migrations.CreateModel( name='Role', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('Name', models.CharField(max_length=120, null=True)), ('status', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'role', }, ), migrations.CreateModel( name='RolesPermissions', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('function', models.CharField(max_length=120, null=True)), ('sub_function', models.CharField(max_length=120, null=True)), ('function_category', models.CharField(max_length=120, null=True)), ('function_link', models.CharField(max_length=120, null=True)), ('enable', models.CharField(max_length=260, null=True)), ('function_icon', models.CharField(max_length=120, null=True)), ('orderby', models.IntegerField(null=True)), ], options={ 'db_table': 'rolespermissions', }, ), migrations.CreateModel( name='Source', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('code', models.CharField(max_length=5, null=True)), ('label', models.CharField(max_length=50, null=True)), ('userid', models.IntegerField(null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'source', }, ), migrations.CreateModel( name='Tag', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('tag', models.CharField(max_length=40)), ('resumeid', models.IntegerField(blank=True, null=True)), ('profileid', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'tags', }, ), migrations.CreateModel( name='Uploads', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('companyid', models.IntegerField(null=True)), ('type', models.CharField(max_length=1, null=True)), ('filepath', models.CharField(max_length=200, null=True)), ('filename', models.CharField(max_length=100, null=True)), ('status', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'uploads', }, ), migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=100, null=True)), ('mobile', models.CharField(max_length=20, null=True)), ('location', models.CharField(blank=True, max_length=120, null=True)), ('datentime', models.DateTimeField(null=True)), ('email', models.CharField(blank=True, max_length=120, null=True)), ('password', models.CharField(max_length=40, null=True)), ('role', models.CharField(max_length=120, null=True)), ('companyid', models.IntegerField(null=True)), ('status', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'user', }, ), migrations.CreateModel( name='Vacation', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('empid', models.IntegerField(null=True)), ('fromdate', models.DateField(null=True)), ('todate', models.DateField(null=True)), ('hours', models.IntegerField(null=True)), ('purpose', models.CharField(max_length=30, null=True)), ('type', models.CharField(max_length=1, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'vacation', }, ), migrations.CreateModel( name='WorkCal', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('userid', models.IntegerField(null=True)), ('startday', models.CharField(max_length=10, null=True)), ('starttime', models.TimeField(max_length=20, null=True)), ('hours', models.CharField(max_length=4, null=True)), ('weekoff1', models.CharField(max_length=10, null=True)), ('weekoff2', models.CharField(max_length=10, null=True)), ('companyid', models.IntegerField(null=True)), ], options={ 'db_table': 'workcal', }, ), migrations.CreateModel( name='Workflow', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('jobid', models.IntegerField(null=True)), ('companyid', models.IntegerField(null=True)), ('paperid', models.IntegerField(null=True)), ('papertype', models.CharField(max_length=1, null=True)), ('order', models.IntegerField(null=True)), ('papertitle', models.CharField(blank=True, max_length=120, null=True)), ('paperlibraryid', models.IntegerField(null=True)), ('teststatus', models.CharField(max_length=1, null=True)), ], options={ 'db_table': 'workflow', }, ), migrations.CreateModel( name='Workspace', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('clientid', models.IntegerField(blank=True, null=True)), ('project', models.CharField(blank=True, max_length=100, null=True)), ('startdate', models.DateTimeField(blank=True, null=True)), ('notes', models.CharField(blank=True, max_length=100, null=True)), ('createdby', models.IntegerField(blank=True, null=True)), ('createdat', models.DateTimeField(blank=True, null=True)), ('status', models.CharField(max_length=1, null=True)), ('jd_ids', models.JSONField(null=True)), ], options={ 'db_table': 'workspace', }, ), migrations.CreateModel( name='User_data', fields=[ ('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')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('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')), ('id', models.AutoField(primary_key=True, serialize=False)), ('usr_email', models.CharField(max_length=120)), ('usr_password', models.CharField(max_length=60)), ('user', models.CharField(max_length=1, null=True)), ('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': 'user_data', }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), ]