3 Created on Jan 27, 2012 |
3 Created on Jan 27, 2012 |
4 |
4 |
5 @author: ymh |
5 @author: ymh |
6 ''' |
6 ''' |
7 from django.db import models |
7 from django.db import models |
8 from hdabo.models import Tag |
8 from hdabo.models import Tag, Datasheet |
9 |
9 |
10 |
10 |
11 class TagYears(models.Model): |
11 class TagYears(models.Model): |
12 |
12 |
13 tag = models.ForeignKey(Tag, related_name="years", blank=False, null=False, db_index=True) |
13 tag = models.ForeignKey(Tag, related_name="years", blank=False, null=False, db_index=True) |
23 subject = models.ForeignKey(Tag, blank=False, null=False, db_index=True, related_name="taglinks_subjects") |
23 subject = models.ForeignKey(Tag, blank=False, null=False, db_index=True, related_name="taglinks_subjects") |
24 object = models.ForeignKey(Tag, blank=False, null=False, db_index=True, related_name="taglinks_objects") |
24 object = models.ForeignKey(Tag, blank=False, null=False, db_index=True, related_name="taglinks_objects") |
25 |
25 |
26 class Meta: |
26 class Meta: |
27 app_label = 'hdalab' |
27 app_label = 'hdalab' |
28 |
|
29 #class CountryCode(models.Model): |
|
30 # |
|
31 # label = models.CharField(max_length=1024, unique=True, blank=False, null=False, db_index=True) |
|
32 # isocode = models.CharField(max_length=3, unique=True, blank=False, null=False, db_index=True) |
|
33 # |
|
34 # class Meta: |
|
35 # app_label = 'hdalab' |
|
36 |
28 |
37 class Country(models.Model): |
29 class Country(models.Model): |
38 |
30 |
39 dbpedia_uri = models.URLField(verify_exists=False, max_length=255, blank=False, null=False, db_index=True, unique=True) |
31 dbpedia_uri = models.URLField(verify_exists=False, max_length=255, blank=False, null=False, db_index=True, unique=True) |
40 |
32 |
65 sessionid = models.CharField(max_length=36, unique=True, blank=False, null=False, db_index=True) |
57 sessionid = models.CharField(max_length=36, unique=True, blank=False, null=False, db_index=True) |
66 data = models.TextField(blank=True, null=True) |
58 data = models.TextField(blank=True, null=True) |
67 |
59 |
68 class Meta: |
60 class Meta: |
69 app_label = 'hdalab' |
61 app_label = 'hdalab' |
70 |
62 |
|
63 class InseeCoords(models.Model): |
|
64 |
|
65 insee = models.IntegerField(primary_key=True) |
|
66 city_name = models.CharField(max_length=255, blank=False, null=False) |
|
67 latitude = models.FloatField(blank=False, null=False) |
|
68 longitude = models.FloatField(blank=False, null=False) |
|
69 |
|
70 class Meta: |
|
71 app_label = 'hdalab' |
|
72 |
|
73 class DatasheetExtras(models.Model): |
|
74 |
|
75 datasheet = models.OneToOneField(Datasheet, related_name="extras", db_index=True) |
|
76 insee = models.ForeignKey(InseeCoords, blank=True, null=True, db_index=True) |
|
77 |
|
78 class Meta: |
|
79 app_label = 'hdalab' |