class Offer(models.Model): offer_id = models.CharField(default='', max_length=35, primary_key=True) city_code = models.CharField(max_length=8, default='') item_ids = ArrayField(models.CharField(max_length=35), default=list, null=True) offer = models.DecimalField(max_digits=6, decimal_places=3, default=0) offer_detail = models.TextField(default='') offer_tag = models.CharField(max_length=255, default='') servei_id = models.CharField(max_length=14, default='')
class Flood(models.Model): register_no = models.IntegerField() annual_dfo = models.IntegerField() country = models.TextField() began = models.DateField() ended = models.DateField() days = models.IntegerField() deaths = models.IntegerField() displaced = models.IntegerField(null=True, blank=True) damage_usd = models.IntegerField(null=True, blank=True) main_cause = models.TextField() severity = models.IntegerField() sq_km = models.DecimalField(decimal_places=9, max_digits=10) flood_magnitude_index = models.DecimalField(decimal_places=9, max_digits=10) place = models.PointField() def __unicode__(self): return '%s to %s at %s' % (self.began, self.ended, self.place)
class LotQuantiles(pg.View): sql = """ select town_id, percentile_disc(0.20) within group (order by cast(value as numeric)) as small_lot, percentile_disc(0.80) within group (order by cast(value as numeric)) as medium_lot from parcel_attribute att join parcel_parcel p on p.gid = att.parcel_id where name='LOT_SIZE' group by town_id """ town_id = models.IntegerField(primary_key=True) small_lot = models.DecimalField(max_digits=10, decimal_places=5) medium_lot = models.DecimalField(max_digits=10, decimal_places=5) class Meta: managed = False
class CadPrjUser(models.Model): prj = models.ForeignKey(Owner) user = models.ForeignKey(SfGuardUser) percentage = models.DecimalField(null=True, max_digits=18, decimal_places=2, blank=True) class Meta: db_table = u'cad_prj_user'
class Farmland(Feature): type = models.CharField(max_length=50, null=True) type_scag = models.CharField(max_length=50, null=True) county = models.CharField(max_length=50, null=True) year = models.IntegerField(null=True) acres = models.DecimalField(max_digits=14, decimal_places=2, null=True) class Meta(object): abstract = True app_label = 'main'
class ServiceArea(models.Model): provider = models.ForeignKey(Provider, related_name='service_areas', on_delete=models.CASCADE) name = models.CharField(max_length=255) price = models.DecimalField(decimal_places=2, max_digits=10) area = models.PolygonField() def __str__(self): return '%s: %s' % (self.provider, self.name)
class Dish(models.Model): group = models.ForeignKey(MenuGroup, related_name='data', on_delete=models.CASCADE) name = models.CharField(max_length=50) image = models.URLField() price = models.DecimalField(max_digits=6, decimal_places=2) def __str__(self) -> str: return f'{self.group} - {self.name}'
class Location(models.Model): """Represents the location of a weather station. """ title = models.CharField(blank=True, max_length=128) description = models.TextField(blank=True) point = models.PointField() height = models.DecimalField(max_digits=7, decimal_places=3) def __str__(self): return force_text('{} {}'.format(self.title, self.point.tuple))
class Booking(models.Model): legacy_id = models.IntegerField(unique=True) legacy_name = models.CharField(max_length=255, blank=True) arrival = models.DateField() departure = models.DateField() details = JSONField(null=True) cost_total = models.DecimalField(max_digits=8, decimal_places=2, default='0.00') campground = models.ForeignKey('Campground', null=True)
class PaleoCoreStratigraphicUnitBaseClass(PaleoCoreBaseClass): age_ma = models.DecimalField(max_digits=10, decimal_places=5, null=True, blank=True) description = models.TextField(null=True, blank=True) facies_type = models.CharField(max_length=255, null=True, blank=True) class Meta: abstract = True
class HabitatConservationAreas(Feature): name = models.CharField(max_length=70, null=True) type = models.CharField(max_length=50, null=True) stage = models.CharField(max_length=15, null=True) acres = models.DecimalField(max_digits=14, decimal_places=2, null=True) notes = models.CharField(max_length=1024, null=True, blank=True) class Meta(object): abstract = True app_label = 'main'
class City(NamedModel): name_txt = models.TextField(default='') name_short = models.CharField(max_length=5) population = models.IntegerField() density = models.DecimalField(max_digits=7, decimal_places=1) dt = models.DateField() point = models.PointField() class Meta: app_label = 'layermap'
class Mob(models.Model): mobcod = models.BigIntegerField(_('mobcod'), default=0, primary_key=True) mobmoacod = models.ForeignKey(Moa, on_delete=models.PROTECT, db_column='mobmoacod') mobfec = models.DateField(_('mobfec'), default=datetime.date(1, 1, 1)) mobrat = models.DecimalField(_('mobrat'), max_digits=15, decimal_places=6, default=0)
class PeopleMeasurement(models.Model): """PeopleMeasurement This models describes data coming from various sensors, such as counting cameras, 3D cameras and wifi sensors. The information contains for example people counts, direction, speed, lat/long etc. """ id = models.UUIDField(primary_key=True) version = models.CharField(max_length=10) timestamp = models.DateTimeField(db_index=True) sensor = models.CharField(max_length=255) sensortype = models.CharField(max_length=255) latitude = models.DecimalField(max_digits=14, decimal_places=11) longitude = models.DecimalField(max_digits=14, decimal_places=11) density = models.FloatField(null=True) speed = models.FloatField(null=True) count = models.IntegerField(null=True) details = models.JSONField(null=True)
class Nepal(models.Model): gid = models.AutoField(primary_key=True) objectid = models.IntegerField(blank=True, null=True) dcode = models.IntegerField(blank=True, null=True) dist_name = models.CharField(max_length=18, blank=True, null=True) shape_leng = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True) shape_area = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True) code1 = models.SmallIntegerField(blank=True, null=True) geom = models.MultiPolygonField(blank=True, null=True) class Meta: managed = False db_table = 'nepal'
class ElkGroveLandUseParcel(Feature): pidstr = models.CharField(max_length=100, null=True, blank=True) parcelid = models.CharField(max_length=100, null=True, blank=True) pid_2005 = models.CharField(max_length=100, null=True, blank=True) apn = models.CharField(max_length=100, null=True, blank=True) name = models.CharField(max_length=100, null=True, blank=True) plan_area = models.CharField(max_length=100, null=True, blank=True) land_use = models.CharField(max_length=100, null=True, blank=True) build_density = models.DecimalField(max_digits=14, null=True, decimal_places=4) zoning_code = models.CharField(max_length=100, null=True, blank=True) dwelling_units = models.DecimalField(max_digits=14, decimal_places=4) general_plan_code = models.CharField(max_length=100, null=True, blank=True) # land_use_definition is added dynamically to subclasses api_include = ['pidstr', 'parcelid', 'pid_2005', 'apn', 'name', 'plan_area', 'land_use', 'build_density', 'zoning_code', 'dwelling_units', 'general_plan_code'] class Meta(object): abstract = True app_label = 'main'
class Concert(models.Model): id = models.AutoField(primary_key=True) artists = models.ManyToManyField(Artist) genre = models.CharField(max_length=100) min_price = models.DecimalField(decimal_places=2, max_digits=6) bit_link = models.URLField() tm_link = models.URLField() location = models.PointField() date = models.DateTimeField() pref_link = models.IntegerField()
class ServiceArea(AuditedModel, models.Model): name = models.CharField(max_length=70, blank=True, null=True) lat = models.DecimalField(max_digits=9, decimal_places=6, blank=True, null=True) long = models.DecimalField(max_digits=9, decimal_places=6, blank=True, null=True) location = models.PointField(default='POINT (0 0)', srid=4326) townie_delivery_start = models.TimeField(blank=True, null=True) townie_delivery_end = models.TimeField(blank=True, null=True) # self_delivery_start = models.TimeField(blank=True, null=True) # self_delivery_end = models.TimeField(blank=True, null=True) def __str__(self): return str(self.id)
class BuildingFloorPlanLine(gis_models.Model): """ Represents the lines that compose a floor plan, such as walls, doors, and windows. """ # line_type = gis_models.CharField(verbose_name=_(u"Cartography line type"), max_length=150, null=True, # blank=True, choices=PLAN_LINE_TYPE) short_name = gis_models.CharField(verbose_name=_("short name"), max_length=150, null=True, blank=True) long_name = gis_models.CharField(verbose_name=_("long name"), max_length=150, null=True, blank=True) # floor_number = gis_models.IntegerField(verbose_name=_(u"floor number"),null=True, blank=True) length = gis_models.DecimalField(verbose_name=_("gis calculated length"), max_digits=10, decimal_places=2, null=True, blank=True) floor_num = gis_models.FloatField(verbose_name=_("floor number"), null=True, blank=True) floor_name = gis_models.CharField(verbose_name=_("floor name"), max_length=200, null=True, blank=True) fk_line_type = gis_models.ForeignKey(LtPlanLineType, on_delete=gis_models.CASCADE, null=True, blank=True) fk_building_floor = gis_models.ForeignKey(BuildingFloor, on_delete=gis_models.CASCADE, null=True, blank=True) geom = gis_models.MultiLineStringField(srid=3857, spatial_index=True, null=True, blank=True) tags = ArrayField(ArrayField(gis_models.CharField(max_length=150), blank=True, null=True), null=True, blank=True) class meta: ordering = ['short_name'] def __str__(self): return str(self.short_name) or ''
class LocationDistance(models.Model): community = models.ForeignKey('Community', on_delete=models.DO_NOTHING, related_name='distances', help_text="Community for this distance") location = models.ForeignKey('Location', on_delete=models.DO_NOTHING, related_name='distances') distance = models.DecimalField( null=True, blank=True, max_digits=24, decimal_places=4, help_text="Birds' eye distance from community to Location (km)") driving_distance = models.DecimalField( null=True, blank=True, max_digits=24, decimal_places=4, help_text="Driving distance from community to Location (km)") travel_time = models.IntegerField( null=True, blank=True, help_text="Travel time (in minutes) corresponding to driving distance") travel_time_display = models.CharField( null=True, blank=True, max_length=255, help_text= "Travel time, in human-readable units (e.g. 15 minutes 22 seconds)", ) within_municipality = models.BooleanField(default=False) class Meta: unique_together = ('community', 'location') verbose_name = "Location Distance" verbose_name_plural = "Location Distances" ordering = ("id", ) def __str__(self): return '{} to {}: {} km'.format(self.community.place_name, self.location.name, self.distance)
class KvkPersoon(models.Model): """ Natuurlijk Persoon """ prsid = models.DecimalField( primary_key=True, max_digits=18, decimal_places=0) datumuitschrijving = models.DecimalField( max_digits=8, decimal_places=0, blank=True, null=True) datumuitspraak = models.DecimalField( max_digits=8, decimal_places=0, blank=True, null=True) duur = models.CharField(max_length=240, blank=True, null=True) faillissement = models.CharField(max_length=3, blank=True, null=True) geboortedatum = models.DecimalField( max_digits=8, decimal_places=0, blank=True, null=True) geboorteland = models.CharField(max_length=50, blank=True, null=True) geboorteplaats = models.CharField(max_length=240, blank=True, null=True) geemigreerd = models.DecimalField( max_digits=8, decimal_places=0, blank=True, null=True) geheim = models.CharField(max_length=3, blank=True, null=True) geslachtsaanduiding = models.CharField( max_length=20, blank=True, null=True) geslachtsnaam = models.CharField(max_length=240, blank=True, null=True) handlichting = models.CharField(max_length=3, blank=True, null=True) huwelijksdatum = models.DecimalField( max_digits=8, decimal_places=0, blank=True, null=True) naam = models.CharField(max_length=600, blank=True, null=True) nummer = models.CharField(max_length=15, blank=True, null=True) ookgenoemd = models.CharField(max_length=600, blank=True, null=True) persoonsrechtsvorm = models.CharField( max_length=240, blank=True, null=True) redeninsolvatie = models.CharField(max_length=50, blank=True, null=True) rsin = models.CharField(max_length=9, blank=True, null=True) soort = models.CharField(max_length=30, blank=True, null=True) status = models.CharField(max_length=20, blank=True, null=True) toegangscode = models.DecimalField( max_digits=4, decimal_places=0, blank=True, null=True) typering = models.CharField(max_length=40, blank=True, null=True) uitgebreiderechtsvorm = models.CharField( max_length=240, blank=True, null=True) verkortenaam = models.CharField(max_length=60, blank=True, null=True) volledigenaam = models.CharField(max_length=240, blank=True, null=True) voornamen = models.CharField(max_length=240, blank=True, null=True) voorvoegselgeslachtsnaam = models.CharField( max_length=15, blank=True, null=True) prshibver = models.DecimalField(max_digits=19, decimal_places=0) rechtsvorm = models.CharField(max_length=50, blank=True, null=True) doelrechtsvorm = models.CharField(max_length=50, blank=True, null=True) rol = models.CharField(max_length=14, blank=True, null=True) class Meta: managed = False db_table = 'kvkprsm00'
class Country(models.Model): class Meta: managed = False db_table = 'gadm_country_geom' verbose_name_plural = "countries" # name = models.CharField(max_length=150) # iso = models.CharField(max_length=3, primary_key=True) # the_geom = models.GeometryField(srid=4326, dim=2, null=True, blank=True) # is_visible = models.BooleanField(default=True) gid = models.IntegerField(primary_key=True) id_0 = models.IntegerField(null=True, blank=True) iso = models.CharField(max_length=3, blank=True) name_engli = models.CharField(max_length=50, blank=True) name_iso = models.CharField(max_length=54, blank=True) name_fao = models.CharField(max_length=50, blank=True) name_local = models.CharField(max_length=54, blank=True) name_obsol = models.CharField(max_length=150, blank=True) name_varia = models.CharField(max_length=160, blank=True) name_nonla = models.CharField(max_length=50, blank=True) name_frenc = models.CharField(max_length=50, blank=True) name_spani = models.CharField(max_length=50, blank=True) name_russi = models.CharField(max_length=50, blank=True) name_arabi = models.CharField(max_length=50, blank=True) name_chine = models.CharField(max_length=50, blank=True) waspartof = models.CharField(max_length=100, blank=True) contains = models.CharField(max_length=50, blank=True) sovereign = models.CharField(max_length=40, blank=True) iso2 = models.CharField(max_length=4, blank=True) www = models.CharField(max_length=2, blank=True) fips = models.CharField(max_length=6, blank=True) ison = models.DecimalField(null=True, max_digits=65535, decimal_places=65535, blank=True) validfr = models.CharField(max_length=12, blank=True) validto = models.CharField(max_length=10, blank=True) eumember = models.DecimalField(null=True, max_digits=65535, decimal_places=65535, blank=True) the_geom = models.GeometryField(srid=4326, dim=2, null=True, blank=True) def __unicode__(self): return '%s (%s)' % (self.name_engli, self.iso)
class Galet_Weights(Context): weight = models.DecimalField(decimal_places=2, max_digits=10, blank=True, null=True) class Meta: managed = True db_table = 'galet_weights' verbose_name_plural = "Galet Weights" verbose_name = "Galet Weight"
class RatingsHostel(models.Model): hostel = models.ForeignKey(Hostel, models.CASCADE, db_column='hostel') rating_category = models.ForeignKey(RatingCategories, models.CASCADE, db_column='rating_category', blank=True, null=True) rating = models.DecimalField(max_digits=3, decimal_places=1, blank=True, null=True)
class Prices(models.Model): room_type = models.ForeignKey('RoomTypes', models.CASCADE, db_column='room_type') hostel = models.ForeignKey(Hostel, models.CASCADE, db_column='hostel') room_size = models.ForeignKey('RoomSizes', models.CASCADE, db_column='room_size') from_date = models.DateTimeField() to_date = models.DateTimeField() price = models.DecimalField(max_digits=16, decimal_places=2)
class OrderDetails(models.Model): order = models.ForeignKey(Order, on_delete=models.CASCADE) job = models.ForeignKey(Jobs, on_delete=models.CASCADE) price = models.DecimalField(max_digits=10, decimal_places=2) quantity = models.PositiveIntegerField(default=1) def __str__(self): return '{}'.format(self.id) def get_cost(self): return self.price * self.quantity
class Percent(models.Model): """ Mixes in a percent field to many-to-many through classes that need to give each member of a set a percent of 100 """ percent = models.DecimalField(max_digits=21, decimal_places=20, default=0, null=False) class Meta: abstract = True
class SpecificPlanParcels(Feature): scaguid16 = models.CharField(max_length=10, null=True, blank=True) apn = models.CharField(max_length=15, null=True, blank=True) scag_sp_code16 = models.IntegerField(null=True, blank=True) scag_sp_secondary = models.IntegerField(null=True, blank=True) sp_name = models.CharField(max_length=100, null=True, blank=True) city_sp_code16 = models.CharField(max_length=60, null=True, blank=True) density = models.DecimalField(max_digits=14, decimal_places=2, null=True) low = models.DecimalField(max_digits=14, decimal_places=2, null=True) high = models.DecimalField(max_digits=14, decimal_places=2, null=True) year_adopted = models.CharField(max_length=10, null=True, blank=True) acres = models.DecimalField(max_digits=14, decimal_places=2, null=True) city = models.CharField(max_length=30, null=True, blank=True) county = models.CharField(max_length=15, null=True, blank=True) notes = models.CharField(max_length=1024, null=True, blank=True) class Meta(object): abstract = True app_label = 'main'
class Referral17(models.Model): insp_type = models.CharField(max_length=20, blank=True, null=True) score = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True) state_name = models.CharField(max_length=100, blank=True, null=True) code = models.CharField(max_length=2, blank=True, null=True) geom = models.MultiPolygonField(blank=True, null=True) fid = models.AutoField(primary_key=True) class Meta: managed = False db_table = 'referral_17'
class Providers(models.Model): name = models.CharField(max_length=255, blank=True, null=True) email = models.CharField(max_length=255, blank=True, null=True) phone_number = models.CharField(max_length=255, blank=True, null=True) language = models.CharField(max_length=255, blank=True, null=True) currency = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True) is_deleted = models.NullBooleanField(default=False) class Meta: managed = False db_table = 'providers'