3 files changed, 10 insertions, 4 deletions
diff --git a/animism-align/cli/app/sql/models/annotation.py b/animism-align/cli/app/sql/models/annotation.py
index 6cc476c..cc53bd6 100644
--- a/animism-align/cli/app/sql/models/annotation.py
+++ b/animism-align/cli/app/sql/models/annotation.py
@@ -27,7 +27,7 @@ class Annotation(Base):
       'paragraph_id': self.paragraph_id,
       'start_ts': self.start_ts,
       'end_ts': self.end_ts,
-      'sentence': self.description,
+      'text': self.text,
       'settings': self.settings,
     }
 
diff --git a/animism-align/cli/app/sql/models/paragraph.py b/animism-align/cli/app/sql/models/paragraph.py
index 7c7bcd7..790c9f0 100644
--- a/animism-align/cli/app/sql/models/paragraph.py
+++ b/animism-align/cli/app/sql/models/paragraph.py
@@ -14,12 +14,16 @@ class Paragraph(Base):
   __tablename__ = 'paragraph'
   id = Column(Integer, primary_key=True)
   type = Column(String(16, convert_unicode=True), nullable=False)
+  start_ts = Column(Float, nullable=False)
+  end_ts = Column(Float, nullable=True)
   settings = Column(JSON, default={}, nullable=True)
 
   def toJSON(self):
     return {
       'id': self.id,
       'type': self.type,
+      'start_ts': self.start_ts,
+      'end_ts': self.end_ts,
       'settings': self.settings,
     }
 
diff --git a/animism-align/cli/app/sql/versions/202007041633_create_database.py b/animism-align/cli/app/sql/versions/202007041642_create_database.py
index f8336e5..bec0cc3 100644
--- a/animism-align/cli/app/sql/versions/202007041633_create_database.py
+++ b/animism-align/cli/app/sql/versions/202007041642_create_database.py
@@ -1,8 +1,8 @@
 """create database
 
-Revision ID: f8936a84e584
+Revision ID: 4ede1524f909
 Revises: 
-Create Date: 2020-07-04 16:33:01.643193
+Create Date: 2020-07-04 16:42:00.443043
 
 """
 from alembic import op
@@ -11,7 +11,7 @@ import sqlalchemy_utc
 
 
 # revision identifiers, used by Alembic.
-revision = 'f8936a84e584'
+revision = '4ede1524f909'
 down_revision = None
 branch_labels = None
 depends_on = None
@@ -22,6 +22,8 @@ def upgrade():
     op.create_table('paragraph',
     sa.Column('id', sa.Integer(), nullable=False),
     sa.Column('type', sa.String(length=16, _expect_unicode=True), nullable=False),
+    sa.Column('start_ts', sa.Float(), nullable=False),
+    sa.Column('end_ts', sa.Float(), nullable=True),
     sa.Column('settings', sa.JSON(), nullable=True),
     sa.PrimaryKeyConstraint('id')
     )