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)