from config import *

class Companies(db.Model):
	__tablename__ = "companies"	
	company_id = db.Column(db.Integer, primary_key=True)
	company_name = db.Column(db.String)
	company_url = db.Column(db.String)
	company_description = db.Column(db.String)
	logo_filename = db.Column(db.String)
	backend = db.Column(db.Boolean)
	frontend = db.Column(db.Boolean)
	mobile = db.Column(db.Boolean)
	data = db.Column(db.Boolean)
	product = db.Column(db.Boolean)
	ui_ux = db.Column(db.Boolean)
	graphic = db.Column(db.Boolean)
	accounting_finance = db.Column(db.Boolean)
	community_social = db.Column(db.Boolean)
	customer_exp = db.Column(db.Boolean)
	editorial = db.Column(db.Boolean)
	hr_recruiting = db.Column(db.Boolean)
	marketing_analytics = db.Column(db.Boolean)
	sales_account = db.Column(db.Boolean)
	person_name_1 = db.Column(db.String)
	linkedin_1 = db.Column(db.String)
	profile_pic_1 = db.Column(db.String)
	linkedin_desc_1 = db.Column(db.String)
	email_1 = db.Column(db.String)
	person_name_2 = db.Column(db.String)
	linkedin_2 = db.Column(db.String)
	profile_pic_2 = db.Column(db.String)
	linkedin_desc_2 = db.Column(db.String)
	email_2 = db.Column(db.String)
	person_name_3 = db.Column(db.String)
	linkedin_3 = db.Column(db.String)
	profile_pic_3 = db.Column(db.String)
	linkedin_desc_3 = db.Column(db.String)
	email_3 = db.Column(db.String)
	person_name_4 = db.Column(db.String)
	linkedin_4 = db.Column(db.String)
	profile_pic_4 = db.Column(db.String)
	linkedin_desc_4 = db.Column(db.String)
	email_4 = db.Column(db.String)
	person_name_5 = db.Column(db.String)
	linkedin_5 = db.Column(db.String)
	profile_pic_5 = db.Column(db.String)
	linkedin_desc_5 = db.Column(db.String)
	email_5 = db.Column(db.String)

	def __init__(self, company_name, company_url, company_description, logo_filename, backend=False, frontend=False, mobile=False, data=False, product=False, ui_ux=False, graphic=False, accounting_finance=False, community_social=False, customer_exp=False, editorial=False, hr_recruiting=False, marketing_analytics=False, sales_account=False, person_name_1=None, linkedin_1=None, profile_pic_1=None, linkedin_desc_1=None, email_1=None, person_name_2=None, linkedin_2=None, profile_pic_2=None, linkedin_desc_2=None, email_2=None, person_name_3=None, linkedin_3=None, profile_pic_3=None, linkedin_desc_3=None, email_3=None, person_name_4=None, linkedin_4=None, profile_pic_4=None, linkedin_desc_4=None, email_4=None, person_name_5=None, linkedin_5=None, profile_pic_5=None, linkedin_desc_5=None, email_5=None):
		self.company_name = company_name
		self.company_url = company_url
		self.company_description = company_description
		self.logo_filename = logo_filename
		self.backend = backend
		self.frontend = frontend
		self.mobile = mobile
		self.data = data
		self.product = product
		self.ui_ux = ui_ux
		self.graphic = graphic
		self.accounting_finance = accounting_finance
		self.community_social = community_social
		self.customer_exp = customer_exp
		self.editorial = editorial
		self.hr_recruiting = hr_recruiting
		self.marketing_analytics = marketing_analytics
		self.sales_account = sales_account
		self.person_name_1 = person_name_1
		self.linkedin_1 = linkedin_1
		self.profile_pic_1 = profile_pic_1
		self.linkedin_desc_1 = linkedin_desc_1
		self.email_1 = email_1
		self.person_name_2 = person_name_2
		self.linkedin_2 = linkedin_2
		self.profile_pic_2 = profile_pic_2
		self.linkedin_desc_2 = linkedin_desc_2
		self.email_2 = email_2
		self.person_name_3 = person_name_3
		self.linkedin_3 = linkedin_3
		self.profile_pic_3 = profile_pic_3
		self.linkedin_desc_3 = linkedin_desc_3
		self.email_3 = email_3
		self.email_4 = email_4
		self.person_name_4 = person_name_4
		self.linkedin_4 = linkedin_4
		self.profile_pic_4 = profile_pic_4
		self.linkedin_desc_4 = linkedin_desc_4
		self.email_4 = email_4
		self.email_5 = email_5
		self.person_name_5 = person_name_5
		self.linkedin_5 = linkedin_5
		self.profile_pic_5 = profile_pic_5
		self.linkedin_desc_5 = linkedin_desc_5
		self.email_5 = email_5