Homec4science
Diffusion invenio-infoscience (master) Browse

R3600/invenio/modules/authorlist/models.py
dec4bde4d7fcmaster

Last Change
Raw File

models.py
View Options

# -*- coding: utf-8 -*-
#
## This file is part of Invenio.
## Copyright (C) 2014 CERN.
##
## Invenio is free software; you can redistribute it and/or
## modify it under the terms of the GNU General Public License as
## published by the Free Software Foundation; either version 2 of the
## License, or (at your option) any later version.
##
## Invenio is distributed in the hope that it will be useful, but
## WITHOUT ANY WARRANTY; without even the implied warranty of
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
## General Public License for more details.
##
## You should have received a copy of the GNU General Public License
## along with Invenio; if not, write to the Free Software Foundation, Inc.,
## 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
"""
AuthorList database models.
"""
# General imports.
from invenio.ext.sqlalchemy import db
# Create your models here.
class AulPAPERS(db.Model):
"""Represents an AulPAPERS record."""
__tablename__ = 'aulPAPERS'
id = db.Column(db.Integer(15, unsigned=True), primary_key=True,
nullable=False, autoincrement=True)
id_user = db.Column(db.Integer(15, unsigned=True), nullable=False)
title = db.Column(db.String(255), nullable=False)
collaboration = db.Column(db.String(255), nullable=False)
experiment_number = db.Column(db.String(255), nullable=False)
last_modified = db.Column(db.Integer(10, unsigned=True),
nullable=False)
__table_args__ = (db.Index('id_user', id_user), db.Model.__table_args__)
class AulREFERENCES(db.Model):
"""Represents an AulREFERENCES record."""
__tablename__ = 'aulREFERENCES'
item = db.Column(db.Integer(15, unsigned=True), primary_key=True,
nullable=False, autoincrement=True)
reference = db.Column(db.String(120), nullable=False)
paper_id = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(AulPAPERS.id), primary_key=True,
nullable=False)
__table_args__ = (db.Index('paper_id', paper_id), db.Index('item', item),
db.Model.__table_args__)
class AulAFFILIATIONS(db.Model):
"""Represents an AulAFFILIATIONS record."""
__tablename__ = 'aulAFFILIATIONS'
item = db.Column(db.Integer(15, unsigned=True), nullable=False,
primary_key=True, autoincrement=True)
acronym = db.Column(db.String(120), nullable=False)
umbrella = db.Column(db.String(120), nullable=False)
name_and_address = db.Column(db.String(255), nullable=False)
domain = db.Column(db.String(120), nullable=False)
member = db.Column(db.TinyInteger(1), nullable=False)
spires_id = db.Column(db.String(60), nullable=False)
paper_id = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(AulPAPERS.id), primary_key=True,
nullable=False)
__table_args__ = (db.Index('acronym', acronym), db.Index('item', item),
db.Index('paper_id', paper_id), db.Model.__table_args__)
class AulAUTHORS(db.Model):
"""Represents an AulAUTHORS record."""
__tablename__ = 'aulAUTHORS'
item = db.Column(db.Integer(15, unsigned=True), primary_key=True,
nullable=False, autoincrement=True)
family_name = db.Column(db.String(255), nullable=False)
given_name = db.Column(db.String(255), nullable=False)
name_on_paper = db.Column(db.String(255), nullable=False)
status = db.Column(db.String(30), nullable=False)
paper_id = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(AulPAPERS.id), primary_key=True,
nullable=False)
__table_args__ = (db.Index('item', item), db.Index('paper_id', paper_id),
db.Model.__table_args__)
class AulAUTHORAFFILIATIONS(db.Model):
"""Represents an AulAUTHOR_AFFILIATIONS record."""
__tablename__ = 'aulAUTHOR_AFFILIATIONS'
item = db.Column(db.Integer(15, unsigned=True), primary_key=True,
nullable=False)
affiliation_acronym = db.Column(db.String(120), nullable=False)
affiliation_status = db.Column(db.String(120), nullable=False)
author_item = db.Column(db.Integer(15, unsigned=True),
primary_key=True, nullable=False)
paper_id = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(AulPAPERS.id), primary_key=True,
nullable=False)
__table_args__ = (db.Index('author_item', author_item),
db.Index('item', item),
db.Index('paper_id', paper_id), db.Model.__table_args__)
class AulAUTHORIDENTIFIERS(db.Model):
"""Represents an AulAUTHOR_IDENTIFIERS record."""
__tablename__ = 'aulAUTHOR_IDENTIFIERS'
item = db.Column(db.Integer(15, unsigned=True), primary_key=True,
nullable=False)
identifier_number = db.Column(db.String(120), nullable=False)
identifier_name = db.Column(db.String(120), nullable=False)
author_item = db.Column(db.Integer(15, unsigned=True),
primary_key=True, nullable=False)
paper_id = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(AulPAPERS.id), primary_key=True,
nullable=False)
__table_args__ = (db.Index('item', item), db.Index('paper_id', paper_id),
db.Index('author_item', author_item),
db.Model.__table_args__)
__all__ = ['AulPAPERS',
'AulREFERENCES',
'AulAFFILIATIONS',
'AulAUTHORS',
'AulAUTHORAFFILIATIONS',
'AulAUTHORIDENTIFIERS']
c4science · Help