You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
486 lines
16 KiB
486 lines
16 KiB
"""Sqlacodegen generated Python bindings for the Foodsoft database schema.""" |
|
|
|
from sqlalchemy import ( |
|
DECIMAL, |
|
Column, |
|
Date, |
|
DateTime, |
|
Float, |
|
Index, |
|
LargeBinary, |
|
String, |
|
Table, |
|
Text, |
|
text, |
|
) |
|
from sqlalchemy.dialects.mysql import INTEGER, TINYINT |
|
from sqlalchemy.ext.declarative import declarative_base |
|
|
|
Base = declarative_base() |
|
metadata = Base.metadata |
|
|
|
|
|
class ArticleCategory(Base): |
|
__tablename__ = "article_categories" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
name = Column(String(255), nullable=False, unique=True, server_default=text("''")) |
|
description = Column(String(255)) |
|
|
|
|
|
class ArticlePrice(Base): |
|
__tablename__ = "article_prices" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
article_id = Column(INTEGER(11), index=True) |
|
price = Column(DECIMAL(8, 2), nullable=False, server_default=text("0.00")) |
|
tax = Column(DECIMAL(8, 2), nullable=False, server_default=text("0.00")) |
|
deposit = Column(DECIMAL(8, 2), nullable=False, server_default=text("0.00")) |
|
unit_quantity = Column(INTEGER(11)) |
|
created_at = Column(DateTime) |
|
|
|
|
|
class Article(Base): |
|
__tablename__ = "articles" |
|
__table_args__ = ( |
|
Index("index_articles_on_name_and_supplier_id", "name", "supplier_id"), |
|
) |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
name = Column(String(255), nullable=False, server_default=text("''")) |
|
supplier_id = Column( |
|
INTEGER(11), nullable=False, index=True, server_default=text("0") |
|
) |
|
article_category_id = Column( |
|
INTEGER(11), nullable=False, index=True, server_default=text("0") |
|
) |
|
unit = Column(String(255), nullable=False, server_default=text("''")) |
|
note = Column(String(255)) |
|
availability = Column(TINYINT(1), nullable=False, server_default=text("1")) |
|
manufacturer = Column(String(255)) |
|
origin = Column(String(255)) |
|
shared_updated_on = Column(DateTime) |
|
price = Column(DECIMAL(8, 2)) |
|
tax = Column(Float) |
|
deposit = Column(DECIMAL(8, 2), server_default=text("0.00")) |
|
unit_quantity = Column(INTEGER(11), nullable=False, server_default=text("1")) |
|
order_number = Column(String(255)) |
|
created_at = Column(DateTime) |
|
updated_at = Column(DateTime) |
|
deleted_at = Column(DateTime) |
|
type = Column(String(255), index=True) |
|
quantity = Column(INTEGER(11), server_default=text("0")) |
|
|
|
|
|
class Assignment(Base): |
|
__tablename__ = "assignments" |
|
__table_args__ = ( |
|
Index( |
|
"index_assignments_on_user_id_and_task_id", |
|
"user_id", |
|
"task_id", |
|
unique=True, |
|
), |
|
) |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
user_id = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
task_id = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
accepted = Column(TINYINT(1), server_default=text("0")) |
|
|
|
|
|
class Delivery(Base): |
|
__tablename__ = "deliveries" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
supplier_id = Column(INTEGER(11), index=True) |
|
delivered_on = Column(Date) |
|
created_at = Column(DateTime) |
|
note = Column(Text) |
|
invoice_id = Column(INTEGER(11)) |
|
|
|
|
|
class Document(Base): |
|
__tablename__ = "documents" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
name = Column(String(255)) |
|
mime = Column(String(255)) |
|
data = Column(LargeBinary) |
|
created_by_user_id = Column(INTEGER(11)) |
|
created_at = Column(DateTime) |
|
updated_at = Column(DateTime) |
|
|
|
|
|
class FinancialLink(Base): |
|
__tablename__ = "financial_link" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
note = Column(Text) |
|
|
|
|
|
class FinancialTransaction(Base): |
|
__tablename__ = "financial_transactions" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
ordergroup_id = Column( |
|
INTEGER(11), nullable=False, index=True, server_default=text("0") |
|
) |
|
amount = Column(DECIMAL(8, 2), nullable=False, server_default=text("0.00")) |
|
note = Column(Text, nullable=False) |
|
user_id = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
created_on = Column(DateTime, nullable=False) |
|
financial_link_id = Column(INTEGER(11)) |
|
|
|
|
|
class GroupOrderArticleQuantity(Base): |
|
__tablename__ = "group_order_article_quantities" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
group_order_article_id = Column( |
|
INTEGER(11), nullable=False, index=True, server_default=text("0") |
|
) |
|
quantity = Column(INTEGER(11), server_default=text("0")) |
|
tolerance = Column(INTEGER(11), server_default=text("0")) |
|
created_on = Column(DateTime, nullable=False) |
|
|
|
|
|
class GroupOrderArticle(Base): |
|
__tablename__ = "group_order_articles" |
|
__table_args__ = ( |
|
Index("goa_index", "group_order_id", "order_article_id", unique=True), |
|
) |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
group_order_id = Column( |
|
INTEGER(11), nullable=False, index=True, server_default=text("0") |
|
) |
|
order_article_id = Column( |
|
INTEGER(11), nullable=False, index=True, server_default=text("0") |
|
) |
|
quantity = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
tolerance = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
updated_on = Column(DateTime, nullable=False) |
|
result = Column(DECIMAL(8, 3)) |
|
result_computed = Column(DECIMAL(8, 3)) |
|
|
|
|
|
class GroupOrder(Base): |
|
__tablename__ = "group_orders" |
|
__table_args__ = ( |
|
Index( |
|
"index_group_orders_on_ordergroup_id_and_order_id", |
|
"ordergroup_id", |
|
"order_id", |
|
unique=True, |
|
), |
|
) |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
ordergroup_id = Column(INTEGER(11), index=True) |
|
order_id = Column(INTEGER(11), nullable=False, index=True, server_default=text("0")) |
|
price = Column(DECIMAL(8, 2), nullable=False, server_default=text("0.00")) |
|
lock_version = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
updated_on = Column(DateTime, nullable=False) |
|
updated_by_user_id = Column(INTEGER(11)) |
|
|
|
|
|
class Group(Base): |
|
__tablename__ = "groups" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
type = Column(String(255), nullable=False, server_default=text("''")) |
|
name = Column(String(255), nullable=False, unique=True, server_default=text("''")) |
|
description = Column(String(255)) |
|
account_balance = Column( |
|
DECIMAL(12, 2), nullable=False, server_default=text("0.00") |
|
) |
|
created_on = Column(DateTime, nullable=False) |
|
role_admin = Column(TINYINT(1), nullable=False, server_default=text("0")) |
|
role_suppliers = Column(TINYINT(1), nullable=False, server_default=text("0")) |
|
role_article_meta = Column(TINYINT(1), nullable=False, server_default=text("0")) |
|
role_finance = Column(TINYINT(1), nullable=False, server_default=text("0")) |
|
role_orders = Column(TINYINT(1), nullable=False, server_default=text("0")) |
|
deleted_at = Column(DateTime) |
|
contact_person = Column(String(255)) |
|
contact_phone = Column(String(255)) |
|
contact_address = Column(String(255)) |
|
stats = Column(Text) |
|
next_weekly_tasks_number = Column(INTEGER(11), server_default=text("8")) |
|
ignore_apple_restriction = Column(TINYINT(1), server_default=text("0")) |
|
role_invoices = Column(TINYINT(1), nullable=False, server_default=text("0")) |
|
break_start = Column(Date) |
|
break_end = Column(Date) |
|
|
|
|
|
class Invite(Base): |
|
__tablename__ = "invites" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
token = Column(String(255), nullable=False, index=True, server_default=text("''")) |
|
expires_at = Column(DateTime, nullable=False) |
|
group_id = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
user_id = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
email = Column(String(255), nullable=False, server_default=text("''")) |
|
|
|
|
|
class Invoice(Base): |
|
__tablename__ = "invoices" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
supplier_id = Column(INTEGER(11), index=True) |
|
number = Column(String(255)) |
|
date = Column(Date) |
|
paid_on = Column(Date) |
|
note = Column(Text) |
|
amount = Column(DECIMAL(8, 2), nullable=False, server_default=text("0.00")) |
|
deposit = Column(DECIMAL(8, 2), nullable=False, server_default=text("0.00")) |
|
deposit_credit = Column(DECIMAL(8, 2), nullable=False, server_default=text("0.00")) |
|
created_at = Column(DateTime) |
|
updated_at = Column(DateTime) |
|
created_by_user_id = Column(INTEGER(11)) |
|
attachment_mime = Column(String(255)) |
|
attachment_data = Column(LargeBinary) |
|
financial_link_id = Column(INTEGER(11)) |
|
|
|
|
|
class MailDeliveryStatu(Base): |
|
__tablename__ = "mail_delivery_status" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
created_at = Column(DateTime) |
|
email = Column(String(255), nullable=False, index=True) |
|
message = Column(String(255), nullable=False) |
|
attachment_mime = Column(String(255)) |
|
attachment_data = Column(LargeBinary) |
|
|
|
|
|
class Membership(Base): |
|
__tablename__ = "memberships" |
|
__table_args__ = ( |
|
Index( |
|
"index_memberships_on_user_id_and_group_id", |
|
"user_id", |
|
"group_id", |
|
unique=True, |
|
), |
|
) |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
group_id = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
user_id = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
|
|
|
|
class Message(Base): |
|
__tablename__ = "messages" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
sender_id = Column(INTEGER(11)) |
|
recipients_ids = Column(Text) |
|
subject = Column(String(255), nullable=False) |
|
body = Column(Text) |
|
email_state = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
private = Column(TINYINT(1), server_default=text("0")) |
|
created_at = Column(DateTime) |
|
reply_to = Column(INTEGER(11)) |
|
group_id = Column(INTEGER(11)) |
|
salt = Column(String(255)) |
|
received_email = Column(LargeBinary) |
|
|
|
|
|
class OrderArticle(Base): |
|
__tablename__ = "order_articles" |
|
__table_args__ = ( |
|
Index( |
|
"index_order_articles_on_order_id_and_article_id", |
|
"order_id", |
|
"article_id", |
|
unique=True, |
|
), |
|
) |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
order_id = Column(INTEGER(11), nullable=False, index=True, server_default=text("0")) |
|
article_id = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
quantity = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
tolerance = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
units_to_order = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
lock_version = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
article_price_id = Column(INTEGER(11)) |
|
units_billed = Column(INTEGER(11)) |
|
units_received = Column(INTEGER(11)) |
|
|
|
|
|
class OrderComment(Base): |
|
__tablename__ = "order_comments" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
order_id = Column(INTEGER(11), index=True) |
|
user_id = Column(INTEGER(11)) |
|
text = Column(Text) |
|
created_at = Column(DateTime) |
|
|
|
|
|
class Order(Base): |
|
__tablename__ = "orders" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
supplier_id = Column(INTEGER(11)) |
|
note = Column(Text) |
|
starts = Column(DateTime) |
|
ends = Column(DateTime) |
|
state = Column(String(255), index=True, server_default=text("'open'")) |
|
lock_version = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
updated_by_user_id = Column(INTEGER(11)) |
|
foodcoop_result = Column(DECIMAL(8, 2)) |
|
created_by_user_id = Column(INTEGER(11)) |
|
boxfill = Column(DateTime) |
|
pickup = Column(Date) |
|
invoice_id = Column(INTEGER(11)) |
|
last_sent_mail = Column(DateTime) |
|
end_action = Column(INTEGER(11), nullable=False, server_default=text("0")) |
|
|
|
|
|
class PageVersion(Base): |
|
__tablename__ = "page_versions" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
page_id = Column(INTEGER(11), index=True) |
|
lock_version = Column(INTEGER(11)) |
|
body = Column(Text) |
|
updated_by = Column(INTEGER(11)) |
|
redirect = Column(INTEGER(11)) |
|
parent_id = Column(INTEGER(11)) |
|
updated_at = Column(DateTime) |
|
|
|
|
|
class Page(Base): |
|
__tablename__ = "pages" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
title = Column(String(255), index=True) |
|
body = Column(Text) |
|
permalink = Column(String(255), index=True) |
|
lock_version = Column(INTEGER(11), server_default=text("0")) |
|
updated_by = Column(INTEGER(11)) |
|
redirect = Column(INTEGER(11)) |
|
parent_id = Column(INTEGER(11)) |
|
created_at = Column(DateTime) |
|
updated_at = Column(DateTime) |
|
|
|
|
|
class PeriodicTaskGroup(Base): |
|
__tablename__ = "periodic_task_groups" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
next_task_date = Column(Date) |
|
created_at = Column(DateTime, nullable=False) |
|
updated_at = Column(DateTime, nullable=False) |
|
|
|
|
|
t_schema_migrations = Table( |
|
"schema_migrations", |
|
metadata, |
|
Column("version", String(255), nullable=False, unique=True), |
|
) |
|
|
|
|
|
class Setting(Base): |
|
__tablename__ = "settings" |
|
__table_args__ = ( |
|
Index( |
|
"index_settings_on_thing_type_and_thing_id_and_var", |
|
"thing_type", |
|
"thing_id", |
|
"var", |
|
unique=True, |
|
), |
|
) |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
var = Column(String(255), nullable=False) |
|
value = Column(Text) |
|
thing_id = Column(INTEGER(11)) |
|
thing_type = Column(String(30)) |
|
created_at = Column(DateTime, nullable=False) |
|
updated_at = Column(DateTime, nullable=False) |
|
|
|
|
|
class StockChange(Base): |
|
__tablename__ = "stock_changes" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
delivery_id = Column(INTEGER(11), index=True) |
|
order_id = Column(INTEGER(11)) |
|
stock_article_id = Column(INTEGER(11), index=True) |
|
quantity = Column(INTEGER(11), server_default=text("0")) |
|
created_at = Column(DateTime) |
|
stock_taking_id = Column(INTEGER(11), index=True) |
|
|
|
|
|
class StockTaking(Base): |
|
__tablename__ = "stock_takings" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
date = Column(Date) |
|
note = Column(Text) |
|
created_at = Column(DateTime) |
|
|
|
|
|
class Supplier(Base): |
|
__tablename__ = "suppliers" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
name = Column(String(255), nullable=False, unique=True, server_default=text("''")) |
|
address = Column(String(255), nullable=False, server_default=text("''")) |
|
phone = Column(String(255), nullable=False, server_default=text("''")) |
|
phone2 = Column(String(255)) |
|
fax = Column(String(255)) |
|
email = Column(String(255)) |
|
url = Column(String(255)) |
|
contact_person = Column(String(255)) |
|
customer_number = Column(String(255)) |
|
delivery_days = Column(String(255)) |
|
order_howto = Column(String(255)) |
|
note = Column(String(255)) |
|
shared_supplier_id = Column(INTEGER(11)) |
|
min_order_quantity = Column(String(255)) |
|
deleted_at = Column(DateTime) |
|
shared_sync_method = Column(String(255)) |
|
iban = Column(String(255)) |
|
|
|
|
|
class Task(Base): |
|
__tablename__ = "tasks" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
name = Column(String(255), nullable=False, index=True, server_default=text("''")) |
|
description = Column(String(255)) |
|
due_date = Column(Date, index=True) |
|
done = Column(TINYINT(1), server_default=text("0")) |
|
workgroup_id = Column(INTEGER(11), index=True) |
|
created_on = Column(DateTime, nullable=False) |
|
updated_on = Column(DateTime, nullable=False) |
|
required_users = Column(INTEGER(11), server_default=text("1")) |
|
duration = Column(INTEGER(11), server_default=text("1")) |
|
periodic_task_group_id = Column(INTEGER(11)) |
|
|
|
|
|
class User(Base): |
|
__tablename__ = "users" |
|
|
|
id = Column(INTEGER(11), primary_key=True) |
|
nick = Column(String(255), unique=True) |
|
password_hash = Column(String(255), nullable=False, server_default=text("''")) |
|
password_salt = Column(String(255), nullable=False, server_default=text("''")) |
|
first_name = Column(String(255), nullable=False, server_default=text("''")) |
|
last_name = Column(String(255), nullable=False, server_default=text("''")) |
|
email = Column(String(255), nullable=False, unique=True, server_default=text("''")) |
|
phone = Column(String(255)) |
|
created_on = Column(DateTime, nullable=False) |
|
reset_password_token = Column(String(255)) |
|
reset_password_expires = Column(DateTime) |
|
last_login = Column(DateTime) |
|
last_activity = Column(DateTime) |
|
deleted_at = Column(DateTime) |
|
iban = Column(String(255))
|
|
|