6 files changed, 14 insertions, 14 deletions
diff --git a/animism-align/cli/app/sql/__pycache__/common.cpython-37.pyc b/animism-align/cli/app/sql/__pycache__/common.cpython-37.pyc
deleted file mode 100644
index f995f96..0000000
--- a/animism-align/cli/app/sql/__pycache__/common.cpython-37.pyc
+++ /dev/null
diff --git a/animism-align/cli/app/sql/__pycache__/env.cpython-37.pyc b/animism-align/cli/app/sql/__pycache__/env.cpython-37.pyc
deleted file mode 100644
index 96f3d85..0000000
--- a/animism-align/cli/app/sql/__pycache__/env.cpython-37.pyc
+++ /dev/null
diff --git a/animism-align/cli/app/sql/common.py b/animism-align/cli/app/sql/common.py
index d79bc06..f291daa 100644
--- a/animism-align/cli/app/sql/common.py
+++ b/animism-align/cli/app/sql/common.py
@@ -31,6 +31,6 @@ Base.metadata.bind = engine
 db = SQLAlchemy()
 
 # include the models in reverse dependency order, so relationships work
-from app.sql.models.timestamp import Timestamp
+from app.sql.models.annotation import Annotation
 from app.sql.models.paragraph import Paragraph
 from app.sql.models.upload import Upload
diff --git a/animism-align/cli/app/sql/env.py b/animism-align/cli/app/sql/env.py
index af21e0e..0defa88 100644
--- a/animism-align/cli/app/sql/env.py
+++ b/animism-align/cli/app/sql/env.py
@@ -14,7 +14,7 @@ config.set_main_option("sqlalchemy.url", connection_url)
 target_metadata = Base.metadata
 
 # include the models in reverse dependency order, so relationships work
-from app.sql.models.timestamp import Timestamp
+from app.sql.models.annotation import Annotation
 from app.sql.models.paragraph import Paragraph
 from app.sql.models.upload import Upload
 
diff --git a/animism-align/cli/app/sql/models/timestamp.py b/animism-align/cli/app/sql/models/annotation.py
index c2bf410..6cc476c 100644
--- a/animism-align/cli/app/sql/models/timestamp.py
+++ b/animism-align/cli/app/sql/models/annotation.py
@@ -9,15 +9,15 @@ from app.sql.common import db, Base, Session
 
 from app.settings import app_cfg
 
-class Timestamp(Base):
+class Annotation(Base):
   """Table for storing references to graphs"""
-  __tablename__ = 'timestamp'
+  __tablename__ = 'annotation'
   id = Column(Integer, primary_key=True)
   type = Column(String(16, convert_unicode=True), nullable=False)
   paragraph_id = Column(Integer, ForeignKey('paragraph.id'), nullable=True)
   start_ts = Column(Float, nullable=False)
   end_ts = Column(Float, nullable=True)
-  sentence = Column(Text(convert_unicode=True), nullable=True)
+  text = Column(Text(convert_unicode=True), nullable=True)
   settings = Column(JSON, default={}, nullable=True)
 
   def toJSON(self):
@@ -31,9 +31,9 @@ class Timestamp(Base):
       'settings': self.settings,
     }
 
-class TimestampForm(ModelForm):
+class AnnotationForm(ModelForm):
   class Meta:
-    model = Timestamp
+    model = Annotation
     exclude = ['settings']
   def get_session():
     return Session()
diff --git a/animism-align/cli/app/sql/versions/202006271347_add_paragraphs.py b/animism-align/cli/app/sql/versions/202007041633_create_database.py
index cc134b5..f8336e5 100644
--- a/animism-align/cli/app/sql/versions/202006271347_add_paragraphs.py
+++ b/animism-align/cli/app/sql/versions/202007041633_create_database.py
@@ -1,8 +1,8 @@
-"""add paragraphs
+"""create database
 
-Revision ID: 650f7cdb3174
+Revision ID: f8936a84e584
 Revises: 
-Create Date: 2020-06-27 13:47:33.766574
+Create Date: 2020-07-04 16:33:01.643193
 
 """
 from alembic import op
@@ -11,7 +11,7 @@ import sqlalchemy_utc
 
 
 # revision identifiers, used by Alembic.
-revision = '650f7cdb3174'
+revision = 'f8936a84e584'
 down_revision = None
 branch_labels = None
 depends_on = None
@@ -34,13 +34,13 @@ def upgrade():
     sa.Column('created_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True),
     sa.PrimaryKeyConstraint('id')
     )
-    op.create_table('timestamp',
+    op.create_table('annotation',
     sa.Column('id', sa.Integer(), nullable=False),
     sa.Column('type', sa.String(length=16, _expect_unicode=True), nullable=False),
     sa.Column('paragraph_id', sa.Integer(), nullable=True),
     sa.Column('start_ts', sa.Float(), nullable=False),
     sa.Column('end_ts', sa.Float(), nullable=True),
-    sa.Column('sentence', sa.Text(_expect_unicode=True), nullable=True),
+    sa.Column('text', sa.Text(_expect_unicode=True), nullable=True),
     sa.Column('settings', sa.JSON(), nullable=True),
     sa.ForeignKeyConstraint(['paragraph_id'], ['paragraph.id'], ),
     sa.PrimaryKeyConstraint('id')
@@ -50,7 +50,7 @@ def upgrade():
 
 def downgrade():
     # ### commands auto generated by Alembic - please adjust! ###
-    op.drop_table('timestamp')
+    op.drop_table('annotation')
     op.drop_table('upload')
     op.drop_table('paragraph')
     # ### end Alembic commands ###