Source code for indra_world.service.db.schema

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, String, Integer, JSON, UniqueConstraint, \
    BigInteger

Base = declarative_base()


class Projects(Base):
    __tablename__ = 'projects'
    id = Column(String, primary_key=True)
    name = Column(String)
    ontology_id = Column(Integer)
    corpus_id = Column(String)


class ProjectRecords(Base):
    __tablename__ = 'project_records'
    __table_args__ = (UniqueConstraint('project_id', 'record_key',
                                       name='uc_pr'),)
    _dummy = Column(Integer, primary_key=True)
    project_id = Column(String)
    record_key = Column(String)


class PreparedStatements(Base):
    __tablename__ = 'prepared_statements'
    _dummy = Column(Integer, primary_key=True)
    record_key = Column(String)
    indra_version = Column(String)
    stmt = Column(JSON)


class Curations(Base):
    __tablename__ = 'curations'
    _dummy = Column(Integer, primary_key=True)
    project_id = Column(String)
    stmt_hash = Column(BigInteger)
    curation = Column(JSON)


class Ontologies(Base):
    __tablename__ = 'ontologies'
    id = Column(Integer, primary_key=True)
    url = Column(String)
    ontology = Column(String)


class DartRecords(Base):
    __tablename__ = 'dart_records'
    storage_key = Column(String, primary_key=True)
    document_id = Column(String)
    reader_version = Column(String)
    reader = Column(String)
    output_version = Column(String)
    date = Column(String)
    labels = Column(String)
    tenants = Column(String)


class Corpora(Base):
    __tablename__ = 'corpora'
    id = Column(String, primary_key=True)
    meta_data = Column(JSON)


class CorpusRecords(Base):
    __tablename__ = 'corpus_records'
    __table_args__ = (UniqueConstraint('corpus_id', 'record_key',
                                       name='uc_cr'),)
    _dummy = Column(Integer, primary_key=True)
    corpus_id = Column(String)
    record_key = Column(String)