class Mappings(db.Model):
__table_args__ = (db.UniqueConstraint('source',
'keyword',
name='mappings_unique_constraint'), {
'schema': 'admin'
})
__tablename__ = 'mappings'
id = db.Column(db.Integer, primary_key=True)
source = db.Column(db.String)
keyword = db.Column(db.String)
positive_debit_subaccount_id = db.Column(
db.String, db.ForeignKey('bookkeeping.subaccounts.name'))
positive_debit_subaccount = db.relationship(
'Subaccounts', foreign_keys=[positive_debit_subaccount_id])
positive_credit_subaccount_id = db.Column(
db.String, db.ForeignKey('bookkeeping.subaccounts.name'))
positive_credit_subaccount = db.relationship(
'Subaccounts', foreign_keys=[positive_credit_subaccount_id])
negative_debit_subaccount_id = db.Column(
db.String, db.ForeignKey('bookkeeping.subaccounts.name'))
negative_debit_subaccount = db.relationship(
'Subaccounts', foreign_keys=[negative_debit_subaccount_id])
negative_credit_subaccount_id = db.Column(
db.String, db.ForeignKey('bookkeeping.subaccounts.name'))
negative_credit_subaccount = db.relationship(
'Subaccounts', foreign_keys=[negative_credit_subaccount_id])
def __repr__(self):
return '{0} - {1}'.format(self.source, self.keyword)
class JournalEntries(db.Model):
__tablename__ = 'journal_entries'
id = db.Column(db.Integer, primary_key=True)
transaction_id = db.Column(db.String)
transaction_source = db.Column(db.String)
mapping_id = db.Column(db.Integer, db.ForeignKey('admin.mappings.id'))
mapping = db.relationship('Mappings', backref='journal_entries')
timestamp = db.Column(db.DateTime(timezone=True), nullable=False)
debit_subaccount = db.Column(db.String,
db.ForeignKey('bookkeeping.subaccounts.name'),
nullable=False)
credit_subaccount = db.Column(
db.String,
db.ForeignKey('bookkeeping.subaccounts.name'),
nullable=False)
functional_amount = db.Column(db.Numeric, nullable=False)
functional_currency = db.Column(db.String, nullable=False)
source_amount = db.Column(db.Numeric, nullable=False)
source_currency = db.Column(db.String, nullable=False)
__table_args__ = (db.UniqueConstraint(
'transaction_id',
'transaction_source',
name='journal_entries_unique_constraint'),
db.CheckConstraint(
functional_amount >= 0,
name='check_functional_amount_positive'),
db.CheckConstraint(source_amount >= 0,
name='check_source_amount_positive'),
{
'schema': 'bookkeeping'
})
class Accruals(db.Model):
__table_args__ = (
db.UniqueConstraint('id',
'name',
'start_date',
'end_date',
name='accruals_unique_constraint'),
{
'schema': 'bookkeeping'
},
)
__tablename__ = 'accruals'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String, nullable=False)
description = db.Column(db.String)
accrual_type = db.Column(db.String, nullable=False)
start_date = db.Column(db.Date, nullable=False)
end_date = db.Column(db.Date, nullable=False)
business_days = db.Column(db.Boolean, nullable=False)
daily_amount = db.Column(db.Numeric, nullable=False)
income_statement_subaccount = db.Column(
db.String,
db.ForeignKey('bookkeeping.subaccounts.name'),
nullable=False)
balance_sheet_subaccount = db.Column(
db.String,
db.ForeignKey('bookkeeping.subaccounts.name'),
nullable=False)
class SecurityPrices(db.Model):
__table_args__ = (db.UniqueConstraint(
'ticker', 'date', name='security_prices_unique_constraint'), {
'schema': 'investments'
})
__tablename__ = 'security_prices'
id = db.Column(db.Integer, primary_key=True)
ticker = db.Column(db.String)
date = db.Column(db.Date)
adjusted_close = db.Column(db.Numeric)
close = db.Column(db.Numeric)
high = db.Column(db.Numeric)
low = db.Column(db.Numeric)
open = db.Column(db.Numeric)
volume = db.Column(db.Numeric)
class TrialBalances(db.Model):
__table_args__ = (db.UniqueConstraint(
'subaccount',
'period',
'period_interval',
name='trial_balances_unique_constraint'), {
'schema': 'bookkeeping'
})
__tablename__ = 'trial_balances'
id = db.Column(db.Integer, primary_key=True)
subaccount = db.Column(db.String,
db.ForeignKey('bookkeeping.subaccounts.name'))
period = db.Column(db.String)
period_interval = db.Column(db.String)
debit_balance = db.Column(db.Numeric, nullable=False, default=0)
credit_balance = db.Column(db.Numeric, nullable=False, default=0)
net_balance = db.Column(db.Numeric, nullable=False, default=0)
debit_changes = db.Column(db.Numeric, nullable=False, default=0)
credit_changes = db.Column(db.Numeric, nullable=False, default=0)
net_changes = db.Column(db.Numeric, nullable=False, default=0)
class PaystubItems(db.Model):
__table_args__ = (
db.UniqueConstraint('paystub_id',
'description',
name='earnings_unique_constraint'),
{
'schema': 'payroll'
},
)
__tablename__ = 'paystub_items'
id = db.Column(db.Integer, primary_key=True)
description = db.Column(db.String)
rate = db.Column(db.Numeric)
hours = db.Column(db.Numeric)
this_period = db.Column(db.Numeric)
year_to_date = db.Column(db.Numeric)
statutory = db.Column(db.Boolean)
paystub_id = db.Column(db.Integer, db.ForeignKey('payroll.paystubs.id'))
def __repr__(self):
return self.description
class AmazonItems(db.Model):
__table_args__ = (db.UniqueConstraint(
'order_id', 'title', name='amazon_items_unique_constraint'), {
'schema': 'amazon'
})
__tablename__ = 'items'
asin_isbn = db.Column(db.String)
buyer_name = db.Column(db.String)
carrier_name_and_tracking_number = db.Column(db.String)
category_id = db.Column(db.String, db.ForeignKey('amazon.categories.name'))
condition = db.Column(db.String)
currency = db.Column(db.String)
id = db.Column(db.Integer, primary_key=True)
item_subtotal = db.Column(db.Numeric)
item_subtotal_tax = db.Column(db.Numeric)
item_total = db.Column(db.Numeric)
list_price_per_unit = db.Column(db.Numeric)
order_id = db.Column(db.String, db.ForeignKey('amazon.orders.id'))
order_status = db.Column(db.String)
ordering_customer_email = db.Column(db.String)
payment_instrument_type = db.Column(db.String)
purchase_price_per_unit = db.Column(db.Numeric)
quantity = db.Column(db.Integer)
release_date = db.Column(db.Date)
seller = db.Column(db.String)
shipment_date = db.Column(db.Date)
shipping_address_city = db.Column(db.String)
shipping_address_name = db.Column(db.String)
shipping_address_state = db.Column(db.String)
shipping_address_street_1 = db.Column(db.String)
shipping_address_street_2 = db.Column(db.String)
shipping_address_zip = db.Column(db.String)
title = db.Column(db.String)
unspsc_code = db.Column(db.Integer)
website = db.Column(db.String)
def __repr__(self):
return self.title
class Paystubs(db.Model):
__table_args__ = (db.UniqueConstraint('employer_name',
'period_beginning',
'period_ending',
name='paystubs_unique_constraint'), {
'schema': 'payroll'
})
__tablename__ = 'paystubs'
id = db.Column(db.Integer, primary_key=True)
employer_name = db.Column(db.String)
period_beginning = db.Column(db.Date)
period_ending = db.Column(db.Date)
pay_date = db.Column(db.Date)
items = db.relationship('PaystubItems',
backref='paystub',
lazy="select",
cascade="save-update, merge, delete")
def __repr__(self):
return '{0}: {1} to {2}'.format(self.employer_name,
self.period_beginning,
self.period_ending)