search

chiraganand / law-typesetting

Software for typesetting laws.
2 stars 0 forks source link

Database model design #3

Open chiraganand opened 5 years ago

chiraganand commented 5 years ago

Based on the feature set, list the database tables and attributes.

srivatsshankar commented 5 years ago

I think for the first version we can have a relatively simple DB schema. Of course Django will automatically create a primary key. Apart from that we can probably have some metadata of the statute in question, including, name, year, number, and so on. The final column will be the XML.

We could possibly implement it something along the lines of:

class Statute (models.Model):
    name = models.CharField(max_length=128)
    year = models.DateField()
    enacted = models.BooleanField()
    xml = models.TextField()