Skip to content

Instantly share code, notes, and snippets.

@AeroNotix
Created March 27, 2012 14:50
Show Gist options
  • Select an option

  • Save AeroNotix/2216554 to your computer and use it in GitHub Desktop.

Select an option

Save AeroNotix/2216554 to your computer and use it in GitHub Desktop.
from django.db import models
class Tblauthorization(models.Model):
admin = models.ForeignKey(Tbluser)
user = models.ManyToMany(Tbluser)
class Meta:
db_table = u'tblauthorization'
class Tblcalendar(models.Model):
user = models.ForeignKey(Tbluser)
date = models.DateField(primary_key=True)
workstart = models.TextField(db_column='workStart', blank=True) # Field name made lowercase. This field type is a guess.
workend = models.TextField(db_column='workEnd', blank=True) # Field name made lowercase. This field type is a guess.
breaks = models.TextField(db_column='Breaks') # Field name made lowercase. This field type is a guess.
daytype = models.ForeignKey(Tbldaytype, db_column='DayType') # Field name made lowercase.
comments = models.CharField(max_length=600, db_column='Comments', blank=True) # Field name made lowercase.
closed_for_changes = models.IntegerField(db_column='Closed_for_Changes') # Field name made lowercase.
class Meta:
db_table = u'tblcalendar'
class Tbldaytype(models.Model):
number = models.IntegerField(null=True, db_column='Number', blank=True) # Field name made lowercase.
daytype = models.CharField(max_length=90, primary_key=True, db_column='DayType') # Field name made lowercase.
class Meta:
db_table = u'tbldaytype'
class Tbluser(models.Model):
user_id = models.CharField(max_length=105, primary_key=True)
ufirstname = models.CharField(max_length=60, db_column='uFirstName') # Field name made lowercase.
ulastname = models.CharField(max_length=60, db_column='uLastName') # Field name made lowercase.
upassword = models.CharField(max_length=60, db_column='uPassword') # Field name made lowercase.
user_type = models.CharField(max_length=15)
umarket = models.CharField(max_length=6, db_column='uMarket', blank=True) # Field name made lowercase.
uprocess = models.CharField(max_length=6, db_column='uProcess', blank=True) # Field name made lowercase.
start_date = models.DateField(db_column='Start_Date') # Field name made lowercase.
breaklength = models.TextField(db_column='breakLength', blank=True) # Field name made lowercase. This field type is a guess.
shiftlength = models.TextField(db_column='shiftLength', blank=True) # Field name made lowercase. This field type is a guess.
class Meta:
db_table = u'tbluser'
@AeroNotix

Copy link
Copy Markdown
Author

ninja gist for working with work's tables at home

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment