class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Company',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=100)),
('display_name', models.CharField(blank=True, max_length=100, null=True)),
('slug', models.SlugField(blank=True, default='')),
('city', models.CharField(max_length=100)),
('country', django_countries.fields.CountryField(default='', max_length=2)),
('Description', froala_editor.fields.FroalaField()),
('hiring_agency', models.BooleanField(default=False)),
('eeo_text', models.TextField(blank=True, null=True)),
('since', models.IntegerField(choices=[(1800, 1800), (1801, 1801), (1802, 1802), (1803, 1803), (1804, 1804), (1805, 1805), (1806, 1806), (1807, 1807), (1808, 1808), (1809, 1809), (1810, 1810), (1811, 1811), (1812, 1812), (1813, 1813), (1814, 1814), (1815, 1815), (1816, 1816), (1817, 1817), (1818, 1818), (1819, 1819), (1820, 1820), (1821, 1821), (1822, 1822), (1823, 1823), (1824, 1824), (1825, 1825), (1826, 1826), (1827, 1827), (1828, 1828), (1829, 1829), (1830, 1830), (1831, 1831), (1832, 1832), (1833, 1833), (1834, 1834), (1835, 1835), (1836, 1836), (1837, 1837), (1838, 1838), (1839, 1839), (1840, 1840), (1841, 1841), (1842, 1842), (1843, 1843), (1844, 1844), (1845, 1845), (1846, 1846), (1847, 1847), (1848, 1848), (1849, 1849), (1850, 1850), (1851, 1851), (1852, 1852), (1853, 1853), (1854, 1854), (1855, 1855), (1856, 1856), (1857, 1857), (1858, 1858), (1859, 1859), (1860, 1860), (1861, 1861), (1862, 1862), (1863, 1863), (1864, 1864), (1865, 1865), (1866, 1866), (1867, 1867), (1868, 1868), (1869, 1869), (1870, 1870), (1871, 1871), (1872, 1872), (1873, 1873), (1874, 1874), (1875, 1875), (1876, 1876), (1877, 1877), (1878, 1878), (1879, 1879), (1880, 1880), (1881, 1881), (1882, 1882), (1883, 1883), (1884, 1884), (1885, 1885), (1886, 1886), (1887, 1887), (1888, 1888), (1889, 1889), (1890, 1890), (1891, 1891), (1892, 1892), (1893, 1893), (1894, 1894), (1895, 1895), (1896, 1896), (1897, 1897), (1898, 1898), (1899, 1899), (1900, 1900), (1901, 1901), (1902, 1902), (1903, 1903), (1904, 1904), (1905, 1905), (1906, 1906), (1907, 1907), (1908, 1908), (1909, 1909), (1910, 1910), (1911, 1911), (1912, 1912), (1913, 1913), (1914, 1914), (1915, 1915), (1916, 1916), (1917, 1917), (1918, 1918), (1919, 1919), (1920, 1920), (1921, 1921), (1922, 1922), (1923, 1923), (1924, 1924), (1925, 1925), (1926, 1926), (1927, 1927), (1928, 1928), (1929, 1929), (1930, 1930), (1931, 1931), (1932, 1932), (1933, 1933), (1934, 1934), (1935, 1935), (1936, 1936), (1937, 1937), (1938, 1938), (1939, 1939), (1940, 1940), (1941, 1941), (1942, 1942), (1943, 1943), (1944, 1944), (1945, 1945), (1946, 1946), (1947, 1947), (1948, 1948), (1949, 1949), (1950, 1950), (1951, 1951), (1952, 1952), (1953, 1953), (1954, 1954), (1955, 1955), (1956, 1956), (1957, 1957), (1958, 1958), (1959, 1959), (1960, 1960), (1961, 1961), (1962, 1962), (1963, 1963), (1964, 1964), (1965, 1965), (1966, 1966), (1967, 1967), (1968, 1968), (1969, 1969), (1970, 1970), (1971, 1971), (1972, 1972), (1973, 1973), (1974, 1974), (1975, 1975), (1976, 1976), (1977, 1977), (1978, 1978), (1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018)], default=company.models.current_year)),
('contact_info', models.CharField(default='', max_length=100)),
('website', models.URLField(default='', max_length=100)),
('facebook', models.URLField(blank=True, max_length=100)),
('twitter', models.URLField(blank=True, max_length=100)),
('linkedin', models.URLField(blank=True, max_length=100)),
('logo', models.ImageField(blank=True, default=0, null=True, upload_to=app.validators.image_path)),
],
),
migrations.CreateModel(
name='Office',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('country', django_countries.fields.CountryField(default='', max_length=2)),
('city', models.CharField(max_length=100)),
('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='company.Company')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Attachment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('file',
models.FileField(upload_to=company.models.company_file_path)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='date created')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='date updated')),
],
),
migrations.CreateModel(
name='Branch',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(choices=[
('CO', 'Computer Engineering'),
('ME', 'Mechanical Engineering'),
('CE', 'Civil Engineering'),
('EE', 'Electrical Engineering'),
('CH', 'Chemical Engineering'),
('EC', 'Electronics and Communication Engineering'),
('PHY', 'Physics'), ('CHEM', 'Chemistry'),
('MATH', 'Mathematics'), ('ALL', 'All Branches')
],
max_length=4)),
('degree',
models.CharField(choices=[('BTECH', 'BTech'),
('MTECH', 'MTech'), ('MSC', 'MSc')],
default='BTECH',
max_length=5)),
],
),
migrations.CreateModel(
name='Company',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255, unique=True)),
('slug', models.SlugField()),
('website',
models.URLField(blank=True, max_length=255, null=True)),
('about',
models.TextField(blank=True, max_length=5000, null=True)),
('perks',
models.TextField(blank=True, max_length=5000, null=True)),
('infra_req',
models.TextField(blank=True, max_length=5000, null=True)),
('other',
models.TextField(blank=True, max_length=5000, null=True)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='date created')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='date updated')),
],
),
migrations.CreateModel(
name='CRPDate',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('datatype',
models.CharField(choices=[('MON', 'Month'),
('WOM', 'Week of Month'),
('DAT', 'Date')],
max_length=3)),
('month', models.IntegerField(blank=True, null=True)),
('date', models.DateField(blank=True, null=True)),
('week_number',
models.CharField(blank=True,
choices=[('F', 'First'), ('S', 'Second'),
('T', 'Third'), ('L', 'Last')],
max_length=1,
null=True)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='date created')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='date updated')),
],
),
migrations.CreateModel(
name='Job',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('designation', models.CharField(max_length=255, unique=True)),
('description',
models.TextField(blank=True, max_length=5000, null=True)),
('requirements',
models.TextField(blank=True, max_length=5000, null=True)),
('eligibility_criteria',
models.TextField(blank=True, max_length=5000, null=True)),
('ctc',
models.DecimalField(blank=True,
decimal_places=2,
max_digits=4)),
('ctc_details',
models.TextField(blank=True, max_length=5000, null=True)),
('bond_details',
models.CharField(blank=True,
max_length=255,
null=True,
unique=True)),
('number_of_selections',
models.IntegerField(blank=True, null=True)),
('other',
models.TextField(blank=True, max_length=5000, null=True)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='date created')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='date updated')),
],
),
migrations.CreateModel(
name='JobLocation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('location', models.CharField(max_length=255)),
('job',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='job_location',
to='company.Job')),
],
),
migrations.CreateModel(
name='JobType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('job_domain',
models.CharField(choices=[('C', 'Core'), ('N', 'Non-Core')],
max_length=1)),
('job_type', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='PlacementCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255, unique=True)),
('ctc_range', models.CharField(max_length=255, unique=True)),
],
),
migrations.CreateModel(
name='SelectionProcedure',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('procedure', models.CharField(max_length=255)),
],
),
migrations.AlterUniqueTogether(
name='jobtype',
unique_together=set([('job_domain', 'job_type')]),
),
migrations.AddField(
model_name='job',
name='category',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='job',
to='company.PlacementCategory'),
),
migrations.AddField(
model_name='job',
name='company',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='job',
to='company.Company'),
),
migrations.AddField(
model_name='job',
name='eligible_branches',
field=models.ManyToManyField(to='company.Branch'),
),
migrations.AddField(
model_name='job',
name='job_type',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='job',
to='company.JobType'),
),
migrations.AddField(
model_name='job',
name='selection_procedure',
field=models.ManyToManyField(to='company.SelectionProcedure'),
),
migrations.AddField(
model_name='crpdate',
name='job',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='crpdate',
to='company.Job'),
),
migrations.AlterUniqueTogether(
name='branch',
unique_together=set([('name', 'degree')]),
),
migrations.AddField(
model_name='attachment',
name='job',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='attachment',
to='company.Job'),
),
migrations.AlterUniqueTogether(
name='joblocation',
unique_together=set([('job', 'location')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Company',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(help_text='Company name',
max_length=100,
unique=True)),
('description',
models.CharField(help_text='Description of the company',
max_length=500)),
('website',
models.URLField(blank=True, help_text='Company website URL')),
('address',
models.CharField(blank=True,
help_text='Company address',
max_length=200)),
('phone',
models.CharField(blank=True,
help_text='Contact phone number',
max_length=50)),
('email',
models.EmailField(blank=True,
help_text='Contact email address',
max_length=254)),
('contact',
models.CharField(blank=True,
help_text='Point of contact',
max_length=100)),
('URL',
models.URLField(
blank=True,
help_text='Link to external company information')),
('image',
models.ImageField(
blank=True,
max_length=255,
null=True,
upload_to=company.models.rename_company_image)),
('notes', models.TextField(blank=True)),
('is_customer',
models.BooleanField(
default=False,
help_text='Do you sell items to this company?')),
('is_supplier',
models.BooleanField(
default=True,
help_text='Do you purchase items from this company?')),
],
),
migrations.CreateModel(
name='Contact',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('phone', models.CharField(blank=True, max_length=100)),
('email', models.EmailField(blank=True, max_length=254)),
('role', models.CharField(blank=True, max_length=100)),
],
),
migrations.CreateModel(
name='SupplierPart',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('SKU',
models.CharField(help_text='Supplier stock keeping unit',
max_length=100)),
('manufacturer',
models.CharField(blank=True,
help_text='Manufacturer',
max_length=100)),
('MPN',
models.CharField(blank=True,
help_text='Manufacturer part number',
max_length=100)),
('URL',
models.URLField(
blank=True,
help_text='URL for external supplier part link')),
('description',
models.CharField(blank=True,
help_text='Supplier part description',
max_length=250)),
('note',
models.CharField(blank=True,
help_text='Notes',
max_length=100)),
('base_cost',
models.DecimalField(
decimal_places=3,
default=0,
help_text='Minimum charge (e.g. stocking fee)',
max_digits=10,
validators=[django.core.validators.MinValueValidator(0)
])),
('packaging',
models.CharField(blank=True,
help_text='Part packaging',
max_length=50)),
('multiple',
models.PositiveIntegerField(
default=1,
help_text='Order multiple',
validators=[django.core.validators.MinValueValidator(1)
])),
('minimum',
models.PositiveIntegerField(
default=1,
help_text='Minimum order quantity (MOQ)',
validators=[django.core.validators.MinValueValidator(1)
])),
('lead_time', models.DurationField(blank=True, null=True)),
],
options={
'db_table': 'part_supplierpart',
},
),
migrations.CreateModel(
name='SupplierPriceBreak',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('quantity',
models.PositiveIntegerField(
default=1,
validators=[django.core.validators.MinValueValidator(1)
])),
('cost',
models.DecimalField(
decimal_places=5,
max_digits=10,
validators=[django.core.validators.MinValueValidator(0)
])),
('part',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='pricebreaks',
to='company.SupplierPart')),
],
options={
'db_table': 'part_supplierpricebreak',
},
),
]
class Migration(migrations.Migration):
dependencies = [
('company', '0003_companyreview_highlight'),
]
operations = [
migrations.CreateModel(
name='Company',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=15, verbose_name='Company Name')),
('tag',
models.CharField(max_length=255, verbose_name='Company Tag')),
('founded',
models.DateTimeField(verbose_name='Company Founded')),
('active',
models.BooleanField(default=True,
verbose_name='Company State')),
('website',
models.URLField(max_length=50,
verbose_name='Company Website')),
],
),
migrations.CreateModel(
name='CompanyTelephoneHelpline',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('helpline',
models.CharField(max_length=20,
verbose_name='Helpline Type')),
('telephone',
models.CharField(max_length=15, verbose_name='Telephone')),
('company',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='company.company')),
],
),
migrations.CreateModel(
name='CompanyFounder',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50, verbose_name='Name')),
('designation',
models.CharField(max_length=30, verbose_name='Designation')),
('profile_pic',
models.ImageField(
upload_to=company.models.profilepic_directory_path,
verbose_name='Profile Pic')),
('bio', models.TextField(verbose_name='About Founder')),
('company',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='company.company')),
],
),
migrations.CreateModel(
name='CompanyEmailHelpline',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('helpline',
models.CharField(max_length=20,
verbose_name='Helpline Type')),
('email',
models.EmailField(max_length=254, verbose_name='Email')),
('company',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='company.company')),
],
),
migrations.CreateModel(
name='CompanyAddress',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('street', models.TextField(verbose_name='Street Address')),
('city', models.CharField(max_length=40, verbose_name='City')),
('pin', models.CharField(max_length=6, verbose_name='PIN')),
('district',
models.CharField(max_length=30, verbose_name='District')),
('state', models.CharField(max_length=30,
verbose_name='State')),
('country',
models.CharField(max_length=30, verbose_name='Country')),
('company',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='company.company')),
],
),
]