class Dept_Manager(models.Model):
emp_no = models.Integer()
dept_no = models.Char(max_length=4)
from_date = models.Date()
to_date = models.Date()
dept_manager_ibfk_1 = models.ForeignKey(Employees)
dept_manager_ibfk_2 = models.ForeignKey(Departments)
class Employees(models.Model):
emp_no = models.Integer()
birth_date = models.Date()
first_name = models.Varchar(max_length=14)
last_name = models.Varchar(max_length=16)
gender = models.Text()
hire_date = models.Date()
class Table_1(models.Model):
id = models.PrimaryKey()
char_1 = models.Char(max_length=200)
varchar_1 = models.VarChar(max_length=200)
date_1 = models.Date()
datetime_1 = models.DateTime()
fk_1 = models.ForeignKey(Table_2)
mm_1 = models.ManyToMany(Table_3)
def setUp(self):
self.test_date = models.Date()
class Titles(models.Model):
emp_no = models.Integer()
title = models.Varchar(max_length=50)
from_date = models.Date()
to_date = models.Date()
titles_ibfk_1 = models.ForeignKey(Employees)
class Salaries(models.Model):
emp_no = models.Integer()
salary = models.Integer()
from_date = models.Date()
to_date = models.Date()
salaries_ibfk_1 = models.ForeignKey(Employees)