66 lines
4.2 KiB
Python
66 lines
4.2 KiB
Python
# Generated by Django 5.0.2 on 2024-02-19 15:39
|
|
|
|
import django.db.models.deletion
|
|
from django.conf import settings
|
|
from django.db import migrations, models
|
|
|
|
|
|
class Migration(migrations.Migration):
|
|
|
|
initial = True
|
|
|
|
dependencies = [
|
|
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
|
|
]
|
|
|
|
operations = [
|
|
migrations.CreateModel(
|
|
name='pay_structure',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(blank=True, max_length=300, null=True)),
|
|
('rate', models.CharField(blank=True, max_length=300, null=True)),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='department',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(blank=True, max_length=300, null=True)),
|
|
('manager', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='manager', to=settings.AUTH_USER_MODEL)),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='employee',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('preferred_name', models.CharField(blank=True, max_length=150, null=True)),
|
|
('job_title', models.CharField(blank=True, max_length=100, null=True)),
|
|
('contact_number', models.CharField(blank=True, max_length=15, null=True)),
|
|
('address_street', models.CharField(blank=True, max_length=300, null=True)),
|
|
('address_city', models.CharField(blank=True, max_length=300, null=True)),
|
|
('address_country', models.CharField(blank=True, default='United Kingdom', max_length=300, null=True)),
|
|
('address_postcode', models.CharField(blank=True, max_length=300, null=True)),
|
|
('emergency_contact_name', models.CharField(blank=True, max_length=300, null=True)),
|
|
('emergency_contact_relationship', models.CharField(blank=True, max_length=300, null=True)),
|
|
('emergency_contact_address_street', models.CharField(blank=True, max_length=300, null=True)),
|
|
('emergency_contact_address_city', models.CharField(blank=True, max_length=300, null=True)),
|
|
('emergency_contact_address_country', models.CharField(blank=True, default='United Kingdom', max_length=300, null=True)),
|
|
('emergency_contact_address_postcode', models.CharField(blank=True, max_length=300, null=True)),
|
|
('emergency_contact_phone_number', models.CharField(blank=True, max_length=15, null=True)),
|
|
('emergency_contact_alternative_number', models.CharField(blank=True, max_length=15, null=True)),
|
|
('holiday_days_allocated', models.IntegerField(default=28)),
|
|
('holiday_days_remaining', models.IntegerField(default=28)),
|
|
('salary', models.CharField(blank=True, max_length=100, null=True)),
|
|
('contract_start_date', models.DateField(auto_now_add=True)),
|
|
('contract_end_date', models.DateField(blank=True, null=True)),
|
|
('employee_company', models.CharField(blank=True, max_length=150, null=True)),
|
|
('employee_vat_number', models.CharField(blank=True, max_length=150, null=True)),
|
|
('department', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='department', to=settings.AUTH_USER_MODEL)),
|
|
('employee', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='employee', to=settings.AUTH_USER_MODEL)),
|
|
('line_manager', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='line_manager', to=settings.AUTH_USER_MODEL)),
|
|
('pay_structure', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='pay_structure', to='hrm.pay_structure')),
|
|
],
|
|
),
|
|
]
|