from .. import db
from ._mixins import Base


class Company(Base):
    name = db.Column(db.String(150), nullable=True)
    description = db.Column(db.Text, nullable=True)
    universal_name = db.Column(db.String(150), nullable=True)
    company_type = db.Column(db.String(100), nullable=True)
    status = db.Column(db.String(100), nullable=True)
    employee_count_range = db.Column(db.String(100), nullable=True)
    specialities = db.Column(db.String(150), nullable=True)
    location = db.Column(db.Text, nullable=True)
    founded_year = db.Column(db.String(150), nullable=True)

    author_pk = db.Column(db.Integer, db.ForeignKey("baseuser.pk"))
    author = db.relationship("src.models.common.BaseUser", foreign_keys=[author_pk])


class Department(Base):
    name = db.Column(db.String(150), nullable=True)
    description = db.Column(db.Text, nullable=True)

    company_pk = db.Column(db.Integer, db.ForeignKey("company.pk", ondelete="CASCADE"))
    company = db.relationship(Company, backref=db.backref("departments", lazy="joined", cascade="all, delete-orphan"), foreign_keys=[company_pk])

82fe6b19133f5419fb25284093728726ad20278b
<mask token>


class Department(Base):
    name = db.Column(db.String(150), nullable=True)
    description = db.Column(db.Text, nullable=True)
    company_pk = db.Column(db.Integer, db.ForeignKey('company.pk', ondelete
        ='CASCADE'))
    company = db.relationship(Company, backref=db.backref('departments',
        lazy='joined', cascade='all, delete-orphan'), foreign_keys=[company_pk]
        )

<mask token>


class Company(Base):
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>


class Department(Base):
    name = db.Column(db.String(150), nullable=True)
    description = db.Column(db.Text, nullable=True)
    company_pk = db.Column(db.Integer, db.ForeignKey('company.pk', ondelete
        ='CASCADE'))
    company = db.relationship(Company, backref=db.backref('departments',
        lazy='joined', cascade='all, delete-orphan'), foreign_keys=[company_pk]
        )

<mask token>


class Company(Base):
    name = db.Column(db.String(150), nullable=True)
    description = db.Column(db.Text, nullable=True)
    universal_name = db.Column(db.String(150), nullable=True)
    company_type = db.Column(db.String(100), nullable=True)
    status = db.Column(db.String(100), nullable=True)
    employee_count_range = db.Column(db.String(100), nullable=True)
    specialities = db.Column(db.String(150), nullable=True)
    location = db.Column(db.Text, nullable=True)
    founded_year = db.Column(db.String(150), nullable=True)
    author_pk = db.Column(db.Integer, db.ForeignKey('baseuser.pk'))
    author = db.relationship('src.models.common.BaseUser', foreign_keys=[
        author_pk])


class Department(Base):
    name = db.Column(db.String(150), nullable=True)
    description = db.Column(db.Text, nullable=True)
    company_pk = db.Column(db.Integer, db.ForeignKey('company.pk', ondelete
        ='CASCADE'))
    company = db.relationship(Company, backref=db.backref('departments',
        lazy='joined', cascade='all, delete-orphan'), foreign_keys=[company_pk]
        )

from .. import db
from ._mixins import Base


class Company(Base):
    name = db.Column(db.String(150), nullable=True)
    description = db.Column(db.Text, nullable=True)
    universal_name = db.Column(db.String(150), nullable=True)
    company_type = db.Column(db.String(100), nullable=True)
    status = db.Column(db.String(100), nullable=True)
    employee_count_range = db.Column(db.String(100), nullable=True)
    specialities = db.Column(db.String(150), nullable=True)
    location = db.Column(db.Text, nullable=True)
    founded_year = db.Column(db.String(150), nullable=True)
    author_pk = db.Column(db.Integer, db.ForeignKey('baseuser.pk'))
    author = db.relationship('src.models.common.BaseUser', foreign_keys=[
        author_pk])


class Department(Base):
    name = db.Column(db.String(150), nullable=True)
    description = db.Column(db.Text, nullable=True)
    company_pk = db.Column(db.Integer, db.ForeignKey('company.pk', ondelete
        ='CASCADE'))
    company = db.relationship(Company, backref=db.backref('departments',
        lazy='joined', cascade='all, delete-orphan'), foreign_keys=[company_pk]
        )

from .. import db
from ._mixins import Base


class Company(Base):
    name = db.Column(db.String(150), nullable=True)
    description = db.Column(db.Text, nullable=True)
    universal_name = db.Column(db.String(150), nullable=True)
    company_type = db.Column(db.String(100), nullable=True)
    status = db.Column(db.String(100), nullable=True)
    employee_count_range = db.Column(db.String(100), nullable=True)
    specialities = db.Column(db.String(150), nullable=True)
    location = db.Column(db.Text, nullable=True)
    founded_year = db.Column(db.String(150), nullable=True)

    author_pk = db.Column(db.Integer, db.ForeignKey("baseuser.pk"))
    author = db.relationship("src.models.common.BaseUser", foreign_keys=[author_pk])


class Department(Base):
    name = db.Column(db.String(150), nullable=True)
    description = db.Column(db.Text, nullable=True)

    company_pk = db.Column(db.Integer, db.ForeignKey("company.pk", ondelete="CASCADE"))
    company = db.relationship(Company, backref=db.backref("departments", lazy="joined", cascade="all, delete-orphan"), foreign_keys=[company_pk])
