1 files changed, 40 insertions, 0 deletions
diff --git a/parts/django/tests/modeltests/custom_columns/models.py b/parts/django/tests/modeltests/custom_columns/models.py
new file mode 100644
index 0000000..651f8a6
--- /dev/null
+++ b/parts/django/tests/modeltests/custom_columns/models.py
@@ -0,0 +1,40 @@
+"""
+17. Custom column/table names
+
+If your database column name is different than your model attribute, use the
+``db_column`` parameter. Note that you'll use the field's name, not its column
+name, in API usage.
+
+If your database table name is different than your model name, use the
+``db_table`` Meta attribute. This has no effect on the API used to
+query the database.
+
+If you need to use a table name for a many-to-many relationship that differs
+from the default generated name, use the ``db_table`` parameter on the
+``ManyToManyField``. This has no effect on the API for querying the database.
+
+"""
+
+from django.db import models
+
+class Author(models.Model):
+    first_name = models.CharField(max_length=30, db_column='firstname')
+    last_name = models.CharField(max_length=30, db_column='last')
+
+    def __unicode__(self):
+        return u'%s %s' % (self.first_name, self.last_name)
+
+    class Meta:
+        db_table = 'my_author_table'
+        ordering = ('last_name','first_name')
+
+class Article(models.Model):
+    headline = models.CharField(max_length=100)
+    authors = models.ManyToManyField(Author, db_table='my_m2m_table')
+
+    def __unicode__(self):
+        return self.headline
+
+    class Meta:
+        ordering = ('headline',)
+