# -----------------------------------------------------------------------------
#    This program is part of https://github.com/hauptDev/ktf-crawler
#    Copyright (C) 2017  Konstantin (hauptDev) Haupt
#
#    This program 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 3 of the License, or
#    (at your option) any later version.
#
#    This program 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 this program.  If not, see <http://www.gnu.org/licenses/>.
# -----------------------------------------------------------------------------
#
# __author__ = "Konstantin (hauptDev) Haupt"
# __maintainer__ = "Konstantin (hauptDev) Haupt"
# __email__ = "contact_at_hauptdev_dot_de"
#
# __license__ = "GNU GPLv3"
# __version__ = "1.0.0"
#
# __status__ = "Development"
# __info__ = "Read and accept the terms of use written below."
#
# -----------------------------------------------------------------------------
# Terms of use:
# - I will NOT use this program to inflict damage (personal or commercial) to
#   the website, the website administration, the website's owner or the users
#   on this website.
# - I will use this program for personal use ONLY!
# - If I want to share ANY of the collected information (raw or processed) to
#   other persons or the public I will ask the website owner for permission.
# - I will use my OWN login details to use this program.
# - I ACCEPT that the website's owner can take legal actions if I violate the
#   law. (related to laws about crawlers, spiders, internet traffic and
#   (data) privacy in my or the website owner's country).
# - I ACCEPT that nobody else will assume responsibility for consequences that
#   result from my personal usage of this program and the collected data
#   (especially not the developer aka author of this program).
# -----------------------------------------------------------------------------

# third-party modules
from sqlalchemy import Column, Integer, ForeignKey
from sqlalchemy.orm import relationship
# own modules
from connector import Base


class MemberTech(Base):
    __tablename__ = 'MEMBER_TECH'
    member_id = Column('MEMBER_ID', Integer, ForeignKey('MEMBER.MEMBER_ID'), primary_key=True)
    tech_id = Column('TECH_ID', Integer, ForeignKey('TECH.TECH_ID'), primary_key=True)
    techs = relationship('Tech')
