Created
March 27, 2012 14:50
-
-
Save AeroNotix/2216554 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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' | |
Author
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
ninja gist for working with work's tables at home