# Path: database.py
# def get_session():
# def teardown_session(exception):


from database import TableBase, Column, ForeignKey, \
    Integer, INTEGER, TINYINT, VARCHAR, LONGTEXT, DATE, DATETIME, TEXT, BINARY, DOUBLE
    author = Column(VARCHAR(200))
    owning_group_id = Column(INTEGER(11))
    status = Column(VARCHAR(20))
    dominant = Column(TINYINT(1))
    informational = Column(TINYINT(1))
    discontinued = Column(INTEGER(11))
    part_status = Column(VARCHAR(40))
    sample_status = Column(VARCHAR(40))
    p_status_cache = Column(VARCHAR(1000))
    s_status_cache = Column(VARCHAR(1000))
    creation_date = Column(DATE)
    m_datetime = Column(DATETIME)
    m_user_id = Column(INTEGER(11))
    uses = Column(INTEGER(11))
    doc_size = Column(INTEGER(11))
    works = Column(VARCHAR(10))
    favorite = Column(INTEGER(4))
    specified_u_list = Column(LONGTEXT)
    deep_u_list = Column(LONGTEXT)
    deep_count = Column(INTEGER(11))
    ps_string = Column(LONGTEXT)
    scars = Column(VARCHAR(20))
    default_scars = Column(VARCHAR(20))
    owner_id = Column(INTEGER(11))
    group_u_list = Column(LONGTEXT)
    has_barcode = Column(TINYINT(1))
    notes = Column(LONGTEXT)
    sources = Column(TEXT)
    nickname = Column(VARCHAR(10))
    categories = Column(VARCHAR(500))

# Path: database.py
# def get_session():
# def teardown_session(exception):


# Path: plugins/biobrick_manager/BiobrickUser.py
from database import TableBase, Column, ForeignKey, \
    Integer, INTEGER, TINYINT, VARCHAR, LONGTEXT, DATE, DATETIME, TEXT, BINARY, DOUBLE

    author = Column(VARCHAR(200))
    owning_group_id = Column(INTEGER(11))
    status = Column(VARCHAR(20))
    dominant = Column(TINYINT(1))
    informational = Column(TINYINT(1))
    discontinued = Column(INTEGER(11))
    part_status = Column(VARCHAR(40))
    sample_status = Column(VARCHAR(40))
    p_status_cache = Column(VARCHAR(1000))
    s_status_cache = Column(VARCHAR(1000))
    creation_date = Column(DATE)
    m_datetime = Column(DATETIME)
    m_user_id = Column(INTEGER(11))
    uses = Column(INTEGER(11))
    doc_size = Column(INTEGER(11))
    works = Column(VARCHAR(10))
    favorite = Column(INTEGER(4))
    specified_u_list = Column(LONGTEXT)
    deep_u_list = Column(LONGTEXT)
    deep_count = Column(INTEGER(11))
    ps_string = Column(LONGTEXT)
    scars = Column(VARCHAR(20))
    default_scars = Column(VARCHAR(20))
    owner_id = Column(INTEGER(11))
    group_u_list = Column(LONGTEXT)
    has_barcode = Column(TINYINT(1))
    notes = Column(LONGTEXT)
    sources = Column(TEXT)
    nickname = Column(VARCHAR(10))
    categories = Column(VARCHAR(500))

    sequence = Column(LONGTEXT)