1449 lines
68 KiB
Python
1449 lines
68 KiB
Python
# coding: utf-8
|
|
from sqlalchemy import BigInteger, Boolean, CheckConstraint, Column, Date, DateTime, Float, ForeignKey, Integer, SmallInteger, String, Text, UniqueConstraint, text
|
|
from sqlalchemy.orm import relationship
|
|
from sqlalchemy.dialects.postgresql import JSONB
|
|
from sqlalchemy.ext.declarative import declarative_base
|
|
|
|
Base = declarative_base()
|
|
metadata = Base.metadata
|
|
|
|
|
|
class AccountLawyeruser(Base):
|
|
__tablename__ = 'account_lawyeruser'
|
|
__table_args__ = (
|
|
CheckConstraint('total_uploaded_size >= 0'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('account_lawyeruser_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
email_address = Column(String(64), nullable=False, unique=True)
|
|
password = Column(String(64))
|
|
first_name = Column(String(64), nullable=False)
|
|
last_name = Column(String(64), nullable=False)
|
|
phone_number = Column(String(64))
|
|
is_main = Column(Boolean, nullable=False)
|
|
total_uploaded_size = Column(BigInteger, nullable=False)
|
|
is_verified = Column(Boolean, nullable=False)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
is_application_admin = Column(Boolean, nullable=False)
|
|
main_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
firm_avatar_url = Column(String(256))
|
|
latest_bill_id = Column(BigInteger, index=True)
|
|
avatar_id = Column(ForeignKey('file_manager_fileinfo.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
avatar = relationship('FileManagerFileinfo', primaryjoin='AccountLawyeruser.avatar_id == FileManagerFileinfo.id')
|
|
main = relationship('AccountLawyeruser', remote_side=[id])
|
|
|
|
|
|
class AccountRole(Base):
|
|
__tablename__ = 'account_role'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('account_role_id_seq'::regclass)"))
|
|
title = Column(String(128), nullable=False)
|
|
count = Column(Integer, nullable=False)
|
|
key = Column(String(128), nullable=False)
|
|
|
|
|
|
class AuthGroup(Base):
|
|
__tablename__ = 'auth_group'
|
|
|
|
id = Column(Integer, primary_key=True, server_default=text("nextval('auth_group_id_seq'::regclass)"))
|
|
name = Column(String(150), nullable=False, unique=True)
|
|
|
|
|
|
class AuthUser(Base):
|
|
__tablename__ = 'auth_user'
|
|
|
|
id = Column(Integer, primary_key=True, server_default=text("nextval('auth_user_id_seq'::regclass)"))
|
|
password = Column(String(128), nullable=False)
|
|
last_login = Column(DateTime(True))
|
|
is_superuser = Column(Boolean, nullable=False)
|
|
username = Column(String(150), nullable=False, unique=True)
|
|
first_name = Column(String(150), nullable=False)
|
|
last_name = Column(String(150), nullable=False)
|
|
email = Column(String(254), nullable=False)
|
|
is_staff = Column(Boolean, nullable=False)
|
|
is_active = Column(Boolean, nullable=False)
|
|
date_joined = Column(DateTime(True), nullable=False)
|
|
|
|
|
|
class ConstConst(Base):
|
|
__tablename__ = 'const_const'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('const_const_id_seq'::regclass)"))
|
|
key = Column(String(256), nullable=False, unique=True)
|
|
value = Column(String(256), nullable=False)
|
|
priority = Column(Integer)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
parent_id = Column(ForeignKey('const_const.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
|
|
parent = relationship('ConstConst', remote_side=[id])
|
|
|
|
|
|
class DictionaryCountry(Base):
|
|
__tablename__ = 'dictionary_country'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('dictionary_country_id_seq'::regclass)"))
|
|
name = Column(String(64), nullable=False)
|
|
code = Column(String(8), nullable=False)
|
|
|
|
|
|
class DictionaryCurrency(Base):
|
|
__tablename__ = 'dictionary_currency'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('dictionary_currency_id_seq'::regclass)"))
|
|
symbol = Column(String(8), nullable=False)
|
|
name = Column(String(64), nullable=False)
|
|
symbol_native = Column(String(16), nullable=False)
|
|
decimal_digits = Column(Integer, nullable=False)
|
|
rounding = Column(Integer, nullable=False)
|
|
code = Column(String(8), nullable=False)
|
|
name_plural = Column(String(64), nullable=False)
|
|
|
|
|
|
class DjangoCeleryResultsChordcounter(Base):
|
|
__tablename__ = 'django_celery_results_chordcounter'
|
|
__table_args__ = (
|
|
CheckConstraint('count >= 0'),
|
|
)
|
|
|
|
id = Column(Integer, primary_key=True, server_default=text("nextval('django_celery_results_chordcounter_id_seq'::regclass)"))
|
|
group_id = Column(String(255), nullable=False, unique=True)
|
|
sub_tasks = Column(Text, nullable=False)
|
|
count = Column(Integer, nullable=False)
|
|
|
|
|
|
class DjangoCeleryResultsGroupresult(Base):
|
|
__tablename__ = 'django_celery_results_groupresult'
|
|
|
|
id = Column(Integer, primary_key=True, server_default=text("nextval('django_celery_results_groupresult_id_seq'::regclass)"))
|
|
group_id = Column(String(255), nullable=False, unique=True)
|
|
date_created = Column(DateTime(True), nullable=False, index=True)
|
|
date_done = Column(DateTime(True), nullable=False, index=True)
|
|
content_type = Column(String(128), nullable=False)
|
|
content_encoding = Column(String(64), nullable=False)
|
|
result = Column(Text)
|
|
|
|
|
|
class DjangoCeleryResultsTaskresult(Base):
|
|
__tablename__ = 'django_celery_results_taskresult'
|
|
|
|
id = Column(Integer, primary_key=True, server_default=text("nextval('django_celery_results_taskresult_id_seq'::regclass)"))
|
|
task_id = Column(String(255), nullable=False, unique=True)
|
|
status = Column(String(50), nullable=False, index=True)
|
|
content_type = Column(String(128), nullable=False)
|
|
content_encoding = Column(String(64), nullable=False)
|
|
result = Column(Text)
|
|
date_done = Column(DateTime(True), nullable=False, index=True)
|
|
traceback = Column(Text)
|
|
meta = Column(Text)
|
|
task_args = Column(Text)
|
|
task_kwargs = Column(Text)
|
|
task_name = Column(String(255), index=True)
|
|
worker = Column(String(100), index=True)
|
|
date_created = Column(DateTime(True), nullable=False, index=True)
|
|
periodic_task_name = Column(String(255))
|
|
|
|
|
|
class DjangoContentType(Base):
|
|
__tablename__ = 'django_content_type'
|
|
__table_args__ = (
|
|
UniqueConstraint('app_label', 'model'),
|
|
)
|
|
|
|
id = Column(Integer, primary_key=True, server_default=text("nextval('django_content_type_id_seq'::regclass)"))
|
|
app_label = Column(String(100), nullable=False)
|
|
model = Column(String(100), nullable=False)
|
|
|
|
|
|
class DjangoMigration(Base):
|
|
__tablename__ = 'django_migrations'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('django_migrations_id_seq'::regclass)"))
|
|
app = Column(String(255), nullable=False)
|
|
name = Column(String(255), nullable=False)
|
|
applied = Column(DateTime(True), nullable=False)
|
|
|
|
|
|
class DjangoSession(Base):
|
|
__tablename__ = 'django_session'
|
|
|
|
session_key = Column(String(40), primary_key=True, index=True)
|
|
session_data = Column(Text, nullable=False)
|
|
expire_date = Column(DateTime(True), nullable=False, index=True)
|
|
|
|
|
|
class FileManagerFileinfo(Base):
|
|
__tablename__ = 'file_manager_fileinfo'
|
|
__table_args__ = (
|
|
CheckConstraint('download_count >= 0'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('file_manager_fileinfo_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
main_tag = Column(String(64))
|
|
section = Column(Integer)
|
|
is_public = Column(Boolean, nullable=False)
|
|
path = Column(String(256), nullable=False)
|
|
size_in_bytes = Column(BigInteger)
|
|
download_count = Column(BigInteger, nullable=False)
|
|
is_temp = Column(Boolean, nullable=False)
|
|
code = Column(String(128), unique=True)
|
|
maintainer_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
maintainer = relationship('AccountLawyeruser', primaryjoin='FileManagerFileinfo.maintainer_id == AccountLawyeruser.id')
|
|
|
|
|
|
class SubscriptionPlan(Base):
|
|
__tablename__ = 'subscription_plan'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('subscription_plan_id_seq'::regclass)"))
|
|
title = Column(String(128), nullable=False)
|
|
description = Column(String(512), nullable=False)
|
|
from_date = Column(DateTime(True), nullable=False)
|
|
to_date = Column(DateTime(True), nullable=False)
|
|
is_active = Column(Boolean, nullable=False)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
deleted_at = Column(DateTime(True))
|
|
months = Column(Integer, nullable=False)
|
|
attributes = Column(JSONB(astext_type=Text()))
|
|
storage_limit = Column(Float(53), nullable=False)
|
|
|
|
|
|
class AccountAdmin(Base):
|
|
__tablename__ = 'account_admin'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('account_admin_id_seq'::regclass)"))
|
|
first_name = Column(String(128), nullable=False)
|
|
last_name = Column(String(128), nullable=False)
|
|
full_name = Column(String(256))
|
|
email = Column(String(64), nullable=False, unique=True)
|
|
gender = Column(SmallInteger, nullable=False)
|
|
is_active = Column(Boolean, nullable=False)
|
|
phone = Column(String(32))
|
|
address = Column(String(512))
|
|
password = Column(String(512), nullable=False)
|
|
role_id = Column(ForeignKey('account_role.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
role = relationship('AccountRole')
|
|
|
|
|
|
class AccountFirebasetoken(Base):
|
|
__tablename__ = 'account_firebasetoken'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('account_firebasetoken_id_seq'::regclass)"))
|
|
web_client_token = Column(String(256))
|
|
android_client_token = Column(String(256))
|
|
lawyer_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, unique=True)
|
|
ios_client_token = Column(String(256))
|
|
|
|
lawyer_user = relationship('AccountLawyeruser', uselist=False)
|
|
|
|
|
|
class AccountGroup(Base):
|
|
__tablename__ = 'account_group'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('account_group_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
title = Column(String(64), nullable=False)
|
|
main_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
main = relationship('AccountLawyeruser')
|
|
|
|
|
|
class AccountToken(Base):
|
|
__tablename__ = 'account_token'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('account_token_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
token = Column(String(128), nullable=False)
|
|
expire_date = Column(Date, nullable=False)
|
|
payload = Column(String(256))
|
|
lawyer_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
lawyer_user = relationship('AccountLawyeruser')
|
|
|
|
|
|
class ActivityExpensecategory(Base):
|
|
__tablename__ = 'activity_expensecategory'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('activity_expensecategory_id_seq'::regclass)"))
|
|
name = Column(String(32), nullable=False)
|
|
rate = Column(Float(53), nullable=False)
|
|
expense_type = Column(Integer, nullable=False)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
|
|
|
|
class ActivityTimeentrycategory(Base):
|
|
__tablename__ = 'activity_timeentrycategory'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('activity_timeentrycategory_id_seq'::regclass)"))
|
|
name = Column(String(32), nullable=False)
|
|
rate = Column(Float(53), nullable=False)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
|
|
|
|
class AuthPermission(Base):
|
|
__tablename__ = 'auth_permission'
|
|
__table_args__ = (
|
|
UniqueConstraint('content_type_id', 'codename'),
|
|
)
|
|
|
|
id = Column(Integer, primary_key=True, server_default=text("nextval('auth_permission_id_seq'::regclass)"))
|
|
name = Column(String(255), nullable=False)
|
|
content_type_id = Column(ForeignKey('django_content_type.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
codename = Column(String(100), nullable=False)
|
|
|
|
content_type = relationship('DjangoContentType')
|
|
|
|
|
|
class AuthUserGroup(Base):
|
|
__tablename__ = 'auth_user_groups'
|
|
__table_args__ = (
|
|
UniqueConstraint('user_id', 'group_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('auth_user_groups_id_seq'::regclass)"))
|
|
user_id = Column(ForeignKey('auth_user.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
group_id = Column(ForeignKey('auth_group.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
group = relationship('AuthGroup')
|
|
user = relationship('AuthUser')
|
|
|
|
|
|
class BankAccountBankaccount(Base):
|
|
__tablename__ = 'bank_account_bankaccount'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('bank_account_bankaccount_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
account_type = Column(Integer, nullable=False)
|
|
account_name = Column(String(128))
|
|
account_number = Column(String(128))
|
|
sort_code = Column(String(128))
|
|
account_holder = Column(String(128))
|
|
institution = Column(String(128))
|
|
domicile_branch = Column(String(128))
|
|
swift = Column(String(128))
|
|
is_default_account = Column(Boolean, nullable=False)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
currency_id = Column(ForeignKey('dictionary_currency.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
currency = relationship('DictionaryCurrency')
|
|
|
|
|
|
class ContactContact(Base):
|
|
__tablename__ = 'contact_contact'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('contact_contact_id_seq'::regclass)"))
|
|
avatar_url = Column(String(256))
|
|
keywords = Column(String(50), nullable=False, index=True)
|
|
fund = Column(Float(53), nullable=False)
|
|
contact_type = Column(Integer, nullable=False)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
main_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
|
|
creator_user = relationship('AccountLawyeruser', primaryjoin='ContactContact.creator_user_id == AccountLawyeruser.id')
|
|
main_user = relationship('AccountLawyeruser', primaryjoin='ContactContact.main_user_id == AccountLawyeruser.id')
|
|
|
|
|
|
class DictionaryPracticearea(Base):
|
|
__tablename__ = 'dictionary_practicearea'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('dictionary_practicearea_id_seq'::regclass)"))
|
|
title = Column(String(64), nullable=False)
|
|
owner_main_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
owner_main = relationship('AccountLawyeruser')
|
|
|
|
|
|
class DjangoAdminLog(Base):
|
|
__tablename__ = 'django_admin_log'
|
|
__table_args__ = (
|
|
CheckConstraint('action_flag >= 0'),
|
|
)
|
|
|
|
id = Column(Integer, primary_key=True, server_default=text("nextval('django_admin_log_id_seq'::regclass)"))
|
|
action_time = Column(DateTime(True), nullable=False)
|
|
object_id = Column(Text)
|
|
object_repr = Column(String(200), nullable=False)
|
|
action_flag = Column(SmallInteger, nullable=False)
|
|
change_message = Column(Text, nullable=False)
|
|
content_type_id = Column(ForeignKey('django_content_type.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
user_id = Column(ForeignKey('auth_user.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
content_type = relationship('DjangoContentType')
|
|
user = relationship('AuthUser')
|
|
|
|
|
|
class FileManagerDownloadtoken(Base):
|
|
__tablename__ = 'file_manager_downloadtoken'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('file_manager_downloadtoken_id_seq'::regclass)"))
|
|
token = Column(String(128), nullable=False)
|
|
is_used = Column(Boolean, nullable=False)
|
|
file_info_id = Column(ForeignKey('file_manager_fileinfo.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
owner_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
file_info = relationship('FileManagerFileinfo')
|
|
owner = relationship('AccountLawyeruser')
|
|
|
|
|
|
class PermissionRole(Base):
|
|
__tablename__ = 'permission_role'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('permission_role_id_seq'::regclass)"))
|
|
title = Column(String(128), nullable=False)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
|
|
|
|
class SubscriptionContract(Base):
|
|
__tablename__ = 'subscription_contract'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('subscription_contract_id_seq'::regclass)"))
|
|
from_date = Column(DateTime(True), nullable=False)
|
|
to_date = Column(DateTime(True), nullable=False)
|
|
total_price = Column(Float(53), nullable=False)
|
|
discounted_price = Column(Float(53), nullable=False)
|
|
payable_amount = Column(Float(53), nullable=False)
|
|
payed_amount = Column(Float(53), nullable=False)
|
|
installments_count = Column(Integer, nullable=False)
|
|
user_limit = Column(Integer, nullable=False)
|
|
status = Column(SmallInteger, nullable=False)
|
|
type = Column(SmallInteger, nullable=False)
|
|
allowed_delay_days = Column(SmallInteger, nullable=False)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
deleted_at = Column(DateTime(True))
|
|
owner_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
plan_id = Column(ForeignKey('subscription_plan.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
storage_limit = Column(Float(53), nullable=False)
|
|
storage_usage = Column(Float(53), nullable=False)
|
|
user_usage = Column(Integer, nullable=False)
|
|
|
|
owner = relationship('AccountLawyeruser')
|
|
plan = relationship('SubscriptionPlan')
|
|
|
|
|
|
class SubscriptionPlanpricerule(Base):
|
|
__tablename__ = 'subscription_planpricerule'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('subscription_planpricerule_id_seq'::regclass)"))
|
|
rule_type = Column(SmallInteger, nullable=False)
|
|
value = Column(Integer, nullable=False)
|
|
price = Column(Float(53), nullable=False)
|
|
discounted_price = Column(Float(53), nullable=False)
|
|
plan_id = Column(ForeignKey('subscription_plan.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
priority = Column(Integer, nullable=False)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
deleted_at = Column(DateTime(True))
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
|
|
plan = relationship('SubscriptionPlan')
|
|
|
|
|
|
class SubscriptionSubscription(Base):
|
|
__tablename__ = 'subscription_subscription'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('subscription_subscription_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
charge = Column(Float(53), nullable=False)
|
|
last_auto_withdrawal_date = Column(DateTime(True))
|
|
last_deposit_date = Column(DateTime(True))
|
|
note = Column(Text)
|
|
main_lawyer_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, unique=True)
|
|
|
|
main_lawyer_user = relationship('AccountLawyeruser', uselist=False)
|
|
|
|
|
|
class SubscriptionTransaction(Base):
|
|
__tablename__ = 'subscription_transaction'
|
|
__table_args__ = (
|
|
CheckConstraint('user_count >= 0'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('subscription_transaction_id_seq'::regclass)"))
|
|
request_body = Column(JSONB(astext_type=Text()))
|
|
response_body = Column(JSONB(astext_type=Text()))
|
|
status = Column(SmallInteger, nullable=False)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
object_id = Column(BigInteger, nullable=False)
|
|
object_type = Column(SmallInteger, nullable=False)
|
|
amount = Column(Float(53), nullable=False)
|
|
object_obj = Column(JSONB(astext_type=Text()))
|
|
user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
user_count = Column(Integer)
|
|
|
|
user = relationship('AccountLawyeruser')
|
|
|
|
|
|
class TaskTasktype(Base):
|
|
__tablename__ = 'task_tasktype'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('task_tasktype_id_seq'::regclass)"))
|
|
title = Column(String(128), nullable=False)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
|
|
|
|
class VerifierPendingverify(Base):
|
|
__tablename__ = 'verifier_pendingverify'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('verifier_pendingverify_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
expire_date = Column(DateTime(True))
|
|
payload = Column(JSONB(astext_type=Text()))
|
|
verify_type = Column(Integer, nullable=False)
|
|
code = Column(String(128), nullable=False)
|
|
email_address = Column(String(64))
|
|
lawyer_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
lawyer_user = relationship('AccountLawyeruser')
|
|
|
|
|
|
class AccountGroupUser(Base):
|
|
__tablename__ = 'account_group_users'
|
|
__table_args__ = (
|
|
UniqueConstraint('group_id', 'lawyeruser_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('account_group_users_id_seq'::regclass)"))
|
|
group_id = Column(ForeignKey('account_group.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
group = relationship('AccountGroup')
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
|
|
|
|
class AccountLawyeruserRole(Base):
|
|
__tablename__ = 'account_lawyeruser_roles'
|
|
__table_args__ = (
|
|
UniqueConstraint('lawyeruser_id', 'role_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('account_lawyeruser_permissions_id_seq'::regclass)"))
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
role_id = Column(ForeignKey('permission_role.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
role = relationship('PermissionRole')
|
|
|
|
|
|
class AuthGroupPermission(Base):
|
|
__tablename__ = 'auth_group_permissions'
|
|
__table_args__ = (
|
|
UniqueConstraint('group_id', 'permission_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('auth_group_permissions_id_seq'::regclass)"))
|
|
group_id = Column(ForeignKey('auth_group.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
permission_id = Column(ForeignKey('auth_permission.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
group = relationship('AuthGroup')
|
|
permission = relationship('AuthPermission')
|
|
|
|
|
|
class AuthUserUserPermission(Base):
|
|
__tablename__ = 'auth_user_user_permissions'
|
|
__table_args__ = (
|
|
UniqueConstraint('user_id', 'permission_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('auth_user_user_permissions_id_seq'::regclass)"))
|
|
user_id = Column(ForeignKey('auth_user.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
permission_id = Column(ForeignKey('auth_permission.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
permission = relationship('AuthPermission')
|
|
user = relationship('AuthUser')
|
|
|
|
|
|
class BankAccountSubaccount(Base):
|
|
__tablename__ = 'bank_account_subaccount'
|
|
__table_args__ = (
|
|
UniqueConstraint('type', 'owner_id', 'bank_account_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('bank_account_subaccount_id_seq'::regclass)"))
|
|
type = Column(SmallInteger, nullable=False)
|
|
owner_id = Column(BigInteger, nullable=False)
|
|
balance = Column(Float(53), nullable=False)
|
|
hash = Column(String(128))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
bank_account_id = Column(ForeignKey('bank_account_bankaccount.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
bank_account = relationship('BankAccountBankaccount')
|
|
|
|
|
|
class BillingBill(Base):
|
|
__tablename__ = 'billing_bill'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('billing_bill_id_seq'::regclass)"))
|
|
created_at = Column(Date, nullable=False)
|
|
updated_at = Column(Date, nullable=False)
|
|
issue_date = Column(Date, nullable=False)
|
|
status = Column(Integer, nullable=False)
|
|
detail_level = Column(Integer, nullable=False)
|
|
due_date = Column(Date, nullable=False)
|
|
is_apply_tax = Column(Boolean, nullable=False)
|
|
is_apply_second_tax = Column(Boolean, nullable=False)
|
|
tax = Column(Float(53), nullable=False)
|
|
second_tax = Column(Float(53), nullable=False)
|
|
tax_value = Column(Float(53), nullable=False)
|
|
second_tax_value = Column(Float(53), nullable=False)
|
|
is_skip_approval_process = Column(Boolean, nullable=False)
|
|
total_amount = Column(Float(53), nullable=False)
|
|
payed_amount = Column(Float(53), nullable=False)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
discount = Column(Float(53), nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
to_contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
type = Column(SmallInteger, nullable=False)
|
|
note = Column(String(256))
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
to_contact = relationship('ContactContact')
|
|
|
|
|
|
class ContactAddres(Base):
|
|
__tablename__ = 'contact_address'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('contact_address_id_seq'::regclass)"))
|
|
street = Column(String(128))
|
|
city = Column(String(32))
|
|
state = Column(String(32))
|
|
post_code = Column(String(64))
|
|
country = Column(Integer)
|
|
address_type = Column(Integer, nullable=False)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
|
|
|
|
class ContactBillingrate(Base):
|
|
__tablename__ = 'contact_billingrate'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('contact_billingrate_id_seq'::regclass)"))
|
|
rate = Column(Float(53), nullable=False)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyer_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
lawyer_user = relationship('AccountLawyeruser')
|
|
|
|
|
|
class ContactCompany(Base):
|
|
__tablename__ = 'contact_company'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('contact_company_id_seq'::regclass)"))
|
|
name = Column(String(64))
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
|
|
|
|
class ContactEmail(Base):
|
|
__tablename__ = 'contact_email'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('contact_email_id_seq'::regclass)"))
|
|
email_address = Column(String(64), nullable=False)
|
|
email_type = Column(Integer, nullable=False)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
|
|
|
|
class ContactPerson(Base):
|
|
__tablename__ = 'contact_person'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('contact_person_id_seq'::regclass)"))
|
|
prefix = Column(String(32))
|
|
first_name = Column(String(32))
|
|
middle_name = Column(String(32))
|
|
last_name = Column(String(32))
|
|
gender = Column(Integer, nullable=False)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
birth_day = Column(Date)
|
|
|
|
contact = relationship('ContactContact')
|
|
|
|
|
|
class ContactPhone(Base):
|
|
__tablename__ = 'contact_phone'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('contact_phone_id_seq'::regclass)"))
|
|
phone_number = Column(String(64), nullable=False)
|
|
phone_type = Column(Integer, nullable=False)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
|
|
|
|
class ContactWebsite(Base):
|
|
__tablename__ = 'contact_website'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('contact_website_id_seq'::regclass)"))
|
|
website_address = Column(String(64), nullable=False)
|
|
website_type = Column(Integer, nullable=False)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
|
|
|
|
class MatterMatter(Base):
|
|
__tablename__ = 'matter_matter'
|
|
__table_args__ = (
|
|
CheckConstraint('notify_limit >= 0'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('matter_matter_id_seq'::regclass)"))
|
|
title = Column(String(256))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
is_for_every_one = Column(Boolean, nullable=False)
|
|
description = Column(Text)
|
|
practice_area = Column(Integer)
|
|
status = Column(Integer, nullable=False)
|
|
reference_code = Column(String(128))
|
|
open_date = Column(Date)
|
|
closed_date = Column(Date)
|
|
pending_date = Column(Date)
|
|
limitation_date = Column(Date)
|
|
is_limitation_date_satisfied = Column(Boolean, nullable=False)
|
|
location = Column(String(128))
|
|
is_billable = Column(Boolean, nullable=False)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
fixed_fee = Column(Float(53))
|
|
fund = Column(Float(53), nullable=False)
|
|
billing_type = Column(Integer, nullable=False)
|
|
has_budget = Column(Boolean, nullable=False)
|
|
budget = Column(Float(53))
|
|
client_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
group_id = Column(ForeignKey('account_group.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
origination_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
owner_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
responsible_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
usage_budget = Column(Float(53), nullable=False)
|
|
notify_limit = Column(Integer)
|
|
has_notify = Column(Boolean)
|
|
|
|
client = relationship('ContactContact')
|
|
group = relationship('AccountGroup')
|
|
origination = relationship('AccountLawyeruser', primaryjoin='MatterMatter.origination_id == AccountLawyeruser.id')
|
|
owner = relationship('AccountLawyeruser', primaryjoin='MatterMatter.owner_id == AccountLawyeruser.id')
|
|
responsible = relationship('AccountLawyeruser', primaryjoin='MatterMatter.responsible_id == AccountLawyeruser.id')
|
|
|
|
|
|
class PermissionRolepermission(Base):
|
|
__tablename__ = 'permission_rolepermission'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('permission_rolepermission_id_seq'::regclass)"))
|
|
permission = Column(String(512), nullable=False)
|
|
role_id = Column(ForeignKey('permission_role.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
role = relationship('PermissionRole')
|
|
|
|
|
|
class SubscriptionAutopayment(Base):
|
|
__tablename__ = 'subscription_autopayment'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('subscription_autopayment_id_seq'::regclass)"))
|
|
first_payment_date = Column(DateTime(True), nullable=False)
|
|
currency = Column(String(32), nullable=False)
|
|
amount = Column(Float(53), nullable=False)
|
|
number_of_payment = Column(Integer, nullable=False)
|
|
frequency = Column(Integer, nullable=False)
|
|
description = Column(String(100), nullable=False)
|
|
subscription_no = Column(String(34), nullable=False)
|
|
cc_ic = Column(String(64), nullable=False)
|
|
cc_email = Column(String(64), nullable=False)
|
|
cc_phone = Column(String(100), nullable=False)
|
|
p_name = Column(String(100), nullable=False)
|
|
p_email = Column(String(100), nullable=False)
|
|
p_phone = Column(String(100), nullable=False)
|
|
p_addr_1 = Column(String(100), nullable=False)
|
|
p_addr_2 = Column(String(100))
|
|
p_city = Column(String(100), nullable=False)
|
|
p_state = Column(String(100), nullable=False)
|
|
p_zip = Column(String(100), nullable=False)
|
|
p_country = Column(String(100), nullable=False)
|
|
contract_id = Column(ForeignKey('subscription_contract.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contract = relationship('SubscriptionContract')
|
|
|
|
|
|
class SubscriptionContractUser(Base):
|
|
__tablename__ = 'subscription_contract_users'
|
|
__table_args__ = (
|
|
UniqueConstraint('contract_id', 'lawyeruser_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('subscription_contract_users_id_seq'::regclass)"))
|
|
contract_id = Column(ForeignKey('subscription_contract.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contract = relationship('SubscriptionContract')
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
|
|
|
|
class SubscriptionPayment(Base):
|
|
__tablename__ = 'subscription_payment'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('subscription_payment_id_seq'::regclass)"))
|
|
amount = Column(Float(53), nullable=False)
|
|
status = Column(SmallInteger, nullable=False)
|
|
payment_dead_line = Column(DateTime(True), nullable=False)
|
|
response = Column(JSONB(astext_type=Text()))
|
|
tracking_code = Column(String(256))
|
|
payed_at = Column(DateTime(True))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
deleted_at = Column(DateTime(True))
|
|
contract_id = Column(ForeignKey('subscription_contract.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contract = relationship('SubscriptionContract')
|
|
user = relationship('AccountLawyeruser')
|
|
|
|
|
|
class TaskTasklist(Base):
|
|
__tablename__ = 'task_tasklist'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('task_tasklist_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
title = Column(String(64), nullable=False)
|
|
description = Column(Text)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
practice_area_id = Column(ForeignKey('dictionary_practicearea.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
practice_area = relationship('DictionaryPracticearea')
|
|
|
|
|
|
class ActivityExpenseentry(Base):
|
|
__tablename__ = 'activity_expenseentry'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('activity_expenseentry_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
date = Column(Date)
|
|
is_used_in_invoice = Column(Boolean, nullable=False)
|
|
expense_type = Column(Integer, nullable=False)
|
|
reference = Column(String(32))
|
|
quantity = Column(Integer, nullable=False)
|
|
amount = Column(Float(53), nullable=False)
|
|
rate = Column(Float(53), nullable=False)
|
|
description = Column(Text)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
category_id = Column(ForeignKey('activity_expensecategory.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
vendor_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
category = relationship('ActivityExpensecategory')
|
|
creator = relationship('AccountLawyeruser', primaryjoin='ActivityExpenseentry.creator_id == AccountLawyeruser.id')
|
|
matter = relationship('MatterMatter')
|
|
user = relationship('AccountLawyeruser', primaryjoin='ActivityExpenseentry.user_id == AccountLawyeruser.id')
|
|
vendor = relationship('ContactContact')
|
|
|
|
|
|
class BankAccountTransaction(Base):
|
|
__tablename__ = 'bank_account_transaction'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('bank_account_transaction_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
amount = Column(Float(53), nullable=False)
|
|
description = Column(Text)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
balance = Column(Float(53), nullable=False)
|
|
hash = Column(String(128))
|
|
sub_account_id = Column(ForeignKey('bank_account_subaccount.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
bank_account_id = Column(ForeignKey('bank_account_bankaccount.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
ref_id = Column(String(128))
|
|
bill_id = Column(ForeignKey('billing_bill.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
client_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
flag = Column(SmallInteger, nullable=False)
|
|
sub_account_balance = Column(Float(53), nullable=False)
|
|
|
|
bank_account = relationship('BankAccountBankaccount')
|
|
bill = relationship('BillingBill')
|
|
client = relationship('ContactContact')
|
|
creator = relationship('AccountLawyeruser')
|
|
sub_account = relationship('BankAccountSubaccount')
|
|
|
|
|
|
class BillingBillMatter(Base):
|
|
__tablename__ = 'billing_bill_matters'
|
|
__table_args__ = (
|
|
UniqueConstraint('bill_id', 'matter_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('billing_bill_matters_id_seq'::regclass)"))
|
|
bill_id = Column(ForeignKey('billing_bill.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
bill = relationship('BillingBill')
|
|
matter = relationship('MatterMatter')
|
|
|
|
|
|
class ClndarEvent(Base):
|
|
__tablename__ = 'clndar_event'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('clndar_event_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
title = Column(String(128), nullable=False)
|
|
start = Column(DateTime(True), nullable=False)
|
|
end = Column(DateTime(True), nullable=False)
|
|
is_all_day = Column(Boolean, nullable=False)
|
|
location = Column(String(256))
|
|
is_for_firm = Column(Boolean, nullable=False)
|
|
description = Column(Text)
|
|
labels = Column(String(512))
|
|
repeat_type = Column(Integer, nullable=False)
|
|
repeat_every = Column(Integer, nullable=False)
|
|
in_repeat_weekly_repeat_on_monday = Column(Boolean, nullable=False)
|
|
in_repeat_weekly_repeat_on_tuesday = Column(Boolean, nullable=False)
|
|
in_repeat_weekly_repeat_on_wednesday = Column(Boolean, nullable=False)
|
|
in_repeat_weekly_repeat_on_thursday = Column(Boolean, nullable=False)
|
|
in_repeat_weekly_repeat_on_friday = Column(Boolean, nullable=False)
|
|
in_repeat_weekly_repeat_on_saturday = Column(Boolean, nullable=False)
|
|
in_repeat_weekly_repeat_on_sunday = Column(Boolean, nullable=False)
|
|
in_repeat_monthly_repeat_on_day_of_month = Column(Integer)
|
|
repeat_end_date = Column(Date)
|
|
repeat_end_after_occurrence = Column(Integer)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
tags = Column(String(512))
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
matter = relationship('MatterMatter')
|
|
|
|
|
|
class CommunicationEmaillog(Base):
|
|
__tablename__ = 'communication_emaillog'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('communication_emaillog_id_seq'::regclass)"))
|
|
date = Column(DateTime(True))
|
|
subject = Column(String(128), index=True)
|
|
recorded_time = Column(Float(53))
|
|
message = Column(Text)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
from_contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
from_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
|
|
creator = relationship('AccountLawyeruser', primaryjoin='CommunicationEmaillog.creator_id == AccountLawyeruser.id')
|
|
from_contact = relationship('ContactContact')
|
|
from_user = relationship('AccountLawyeruser', primaryjoin='CommunicationEmaillog.from_user_id == AccountLawyeruser.id')
|
|
matter = relationship('MatterMatter')
|
|
|
|
|
|
class CommunicationPhonelog(Base):
|
|
__tablename__ = 'communication_phonelog'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('communication_phonelog_id_seq'::regclass)"))
|
|
date = Column(DateTime(True))
|
|
subject = Column(String(128), index=True)
|
|
message = Column(Text)
|
|
recorded_time = Column(Float(53))
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
from_contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
from_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
|
|
creator = relationship('AccountLawyeruser', primaryjoin='CommunicationPhonelog.creator_id == AccountLawyeruser.id')
|
|
from_contact = relationship('ContactContact')
|
|
from_user = relationship('AccountLawyeruser', primaryjoin='CommunicationPhonelog.from_user_id == AccountLawyeruser.id')
|
|
matter = relationship('MatterMatter')
|
|
|
|
|
|
class CommunicationSecuremessage(Base):
|
|
__tablename__ = 'communication_securemessage'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('communication_securemessage_id_seq'::regclass)"))
|
|
date = Column(DateTime(True))
|
|
subject = Column(String(128), index=True)
|
|
message = Column(Text)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
matter = relationship('MatterMatter')
|
|
|
|
|
|
class DocumentFolderorfile(Base):
|
|
__tablename__ = 'document_folderorfile'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('document_folderorfile_id_seq'::regclass)"))
|
|
name = Column(String(128), nullable=False)
|
|
tags = Column(String(1024))
|
|
is_removed = Column(Boolean, nullable=False)
|
|
file_info_id = Column(ForeignKey('file_manager_fileinfo.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
owner_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
parent_id = Column(ForeignKey('document_folderorfile.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
file_info = relationship('FileManagerFileinfo')
|
|
matter = relationship('MatterMatter')
|
|
owner = relationship('AccountLawyeruser')
|
|
parent = relationship('DocumentFolderorfile', remote_side=[id])
|
|
|
|
|
|
class FundFundtransaction(Base):
|
|
__tablename__ = 'fund_fundtransaction'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('fund_fundtransaction_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
title = Column(String(128))
|
|
description = Column(Text, nullable=False)
|
|
transaction_date = Column(DateTime(True))
|
|
amount = Column(Float(53), nullable=False)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
from_bank_account_id = Column(BigInteger, index=True)
|
|
from_contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
from_matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
to_bank_account_id = Column(BigInteger, index=True)
|
|
to_contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
to_matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
from_contact = relationship('ContactContact', primaryjoin='FundFundtransaction.from_contact_id == ContactContact.id')
|
|
from_matter = relationship('MatterMatter', primaryjoin='FundFundtransaction.from_matter_id == MatterMatter.id')
|
|
to_contact = relationship('ContactContact', primaryjoin='FundFundtransaction.to_contact_id == ContactContact.id')
|
|
to_matter = relationship('MatterMatter', primaryjoin='FundFundtransaction.to_matter_id == MatterMatter.id')
|
|
|
|
|
|
class FundTransactionhistory(Base):
|
|
__tablename__ = 'fund_transactionhistory'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('fund_transactionhistory_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
title = Column(String(128))
|
|
description = Column(Text)
|
|
amount = Column(Float(53), nullable=False)
|
|
source_fund = Column(Float(53))
|
|
destination_fund = Column(Float(53))
|
|
is_removed = Column(Boolean, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
from_bank_account_id = Column(BigInteger, index=True)
|
|
from_contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
from_matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
to_bank_account_id = Column(BigInteger, index=True)
|
|
to_contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
to_matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
from_contact = relationship('ContactContact', primaryjoin='FundTransactionhistory.from_contact_id == ContactContact.id')
|
|
from_matter = relationship('MatterMatter', primaryjoin='FundTransactionhistory.from_matter_id == MatterMatter.id')
|
|
to_contact = relationship('ContactContact', primaryjoin='FundTransactionhistory.to_contact_id == ContactContact.id')
|
|
to_matter = relationship('MatterMatter', primaryjoin='FundTransactionhistory.to_matter_id == MatterMatter.id')
|
|
|
|
|
|
class MatterContingencyrate(Base):
|
|
__tablename__ = 'matter_contingencyrate'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('matter_contingencyrate_id_seq'::regclass)"))
|
|
rate = Column(Float(53), nullable=False)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
matter = relationship('MatterMatter')
|
|
user = relationship('AccountLawyeruser')
|
|
|
|
|
|
class MatterHistory(Base):
|
|
__tablename__ = 'matter_history'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('matter_history_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
history_type = Column(Integer, nullable=False)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
owner_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
matter = relationship('MatterMatter')
|
|
owner = relationship('AccountLawyeruser')
|
|
|
|
|
|
class MatterHourlyrate(Base):
|
|
__tablename__ = 'matter_hourlyrate'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('matter_hourlyrate_id_seq'::regclass)"))
|
|
rate = Column(Float(53), nullable=False)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
matter = relationship('MatterMatter')
|
|
user = relationship('AccountLawyeruser')
|
|
|
|
|
|
class MatterMatterNotification(Base):
|
|
__tablename__ = 'matter_matter_notifications'
|
|
__table_args__ = (
|
|
UniqueConstraint('matter_id', 'lawyeruser_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('matter_matter_notifications_id_seq'::regclass)"))
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
matter = relationship('MatterMatter')
|
|
|
|
|
|
class MatterRelation(Base):
|
|
__tablename__ = 'matter_relation'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('matter_relation_id_seq'::regclass)"))
|
|
relationship = Column(String(64))
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
matter = relationship('MatterMatter')
|
|
|
|
|
|
class NoteNote(Base):
|
|
__tablename__ = 'note_note'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('note_note_id_seq'::regclass)"))
|
|
title = Column(String(128), nullable=False)
|
|
description = Column(Text)
|
|
date = Column(DateTime(True))
|
|
is_removed = Column(Boolean, nullable=False)
|
|
recorded_time = Column(Float(53), nullable=False)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
creator = relationship('AccountLawyeruser')
|
|
matter = relationship('MatterMatter')
|
|
|
|
|
|
class SubscriptionAutopaymentPayment(Base):
|
|
__tablename__ = 'subscription_autopayment_payment'
|
|
__table_args__ = (
|
|
UniqueConstraint('autopayment_id', 'payment_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('subscription_autopayment_payment_id_seq'::regclass)"))
|
|
autopayment_id = Column(ForeignKey('subscription_autopayment.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
payment_id = Column(ForeignKey('subscription_payment.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
autopayment = relationship('SubscriptionAutopayment')
|
|
payment = relationship('SubscriptionPayment')
|
|
|
|
|
|
class TaskTask(Base):
|
|
__tablename__ = 'task_task'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('task_task_id_seq'::regclass)"))
|
|
title = Column(String(128), nullable=False)
|
|
priority = Column(Integer, nullable=False)
|
|
description = Column(Text)
|
|
status = Column(Integer, nullable=False)
|
|
time_estimate = Column(Float(53))
|
|
due_date = Column(Date)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
assigned_contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
assigned_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
task_type_id = Column(ForeignKey('task_tasktype.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
|
|
assigned_contact = relationship('ContactContact')
|
|
assigned_user = relationship('AccountLawyeruser', primaryjoin='TaskTask.assigned_user_id == AccountLawyeruser.id')
|
|
creator = relationship('AccountLawyeruser', primaryjoin='TaskTask.creator_id == AccountLawyeruser.id')
|
|
matter = relationship('MatterMatter')
|
|
task_type = relationship('TaskTasktype')
|
|
|
|
|
|
class TaskTasktemplate(Base):
|
|
__tablename__ = 'task_tasktemplate'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('task_tasktemplate_id_seq'::regclass)"))
|
|
title = Column(String(128), nullable=False)
|
|
priority = Column(Integer, nullable=False)
|
|
description = Column(Text)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
assigned_user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
task_list_id = Column(ForeignKey('task_tasklist.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
task_type_id = Column(ForeignKey('task_tasktype.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
assigned_user = relationship('AccountLawyeruser', primaryjoin='TaskTasktemplate.assigned_user_id == AccountLawyeruser.id')
|
|
creator = relationship('AccountLawyeruser', primaryjoin='TaskTasktemplate.creator_id == AccountLawyeruser.id')
|
|
task_list = relationship('TaskTasklist')
|
|
task_type = relationship('TaskTasktype')
|
|
|
|
|
|
class ActivityTimeentry(Base):
|
|
__tablename__ = 'activity_timeentry'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('activity_timeentry_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
duration = Column(Float(53), nullable=False)
|
|
date = Column(Date)
|
|
rate = Column(Float(53), nullable=False)
|
|
description = Column(Text, nullable=False)
|
|
is_no_billable = Column(Boolean, nullable=False)
|
|
is_removed = Column(Boolean, nullable=False)
|
|
is_used_in_invoice = Column(Boolean, nullable=False)
|
|
category_id = Column(ForeignKey('activity_timeentrycategory.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
matter_id = Column(ForeignKey('matter_matter.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
user_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
task_id = Column(ForeignKey('task_task.id', deferrable=True, initially='DEFERRED'), index=True)
|
|
|
|
category = relationship('ActivityTimeentrycategory')
|
|
creator = relationship('AccountLawyeruser', primaryjoin='ActivityTimeentry.creator_id == AccountLawyeruser.id')
|
|
matter = relationship('MatterMatter')
|
|
task = relationship('TaskTask')
|
|
user = relationship('AccountLawyeruser', primaryjoin='ActivityTimeentry.user_id == AccountLawyeruser.id')
|
|
|
|
|
|
class BillingBillExpenseEntry(Base):
|
|
__tablename__ = 'billing_bill_expense_entries'
|
|
__table_args__ = (
|
|
UniqueConstraint('bill_id', 'expenseentry_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('billing_bill_expense_entries_id_seq'::regclass)"))
|
|
bill_id = Column(ForeignKey('billing_bill.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
expenseentry_id = Column(ForeignKey('activity_expenseentry.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
bill = relationship('BillingBill')
|
|
expenseentry = relationship('ActivityExpenseentry')
|
|
|
|
|
|
class ClndarEventForContact(Base):
|
|
__tablename__ = 'clndar_event_for_contact'
|
|
__table_args__ = (
|
|
UniqueConstraint('event_id', 'contact_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('clndar_event_for_contact_id_seq'::regclass)"))
|
|
event_id = Column(ForeignKey('clndar_event.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
event = relationship('ClndarEvent')
|
|
|
|
|
|
class ClndarEventForUser(Base):
|
|
__tablename__ = 'clndar_event_for_users'
|
|
__table_args__ = (
|
|
UniqueConstraint('event_id', 'lawyeruser_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('clndar_event_for_users_id_seq'::regclass)"))
|
|
event_id = Column(ForeignKey('clndar_event.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
event = relationship('ClndarEvent')
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
|
|
|
|
class CommunicationEmaillogNotification(Base):
|
|
__tablename__ = 'communication_emaillog_notifications'
|
|
__table_args__ = (
|
|
UniqueConstraint('emaillog_id', 'lawyeruser_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('communication_emaillog_notifications_id_seq'::regclass)"))
|
|
emaillog_id = Column(ForeignKey('communication_emaillog.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
emaillog = relationship('CommunicationEmaillog')
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
|
|
|
|
class CommunicationEmaillogToContact(Base):
|
|
__tablename__ = 'communication_emaillog_to_contacts'
|
|
__table_args__ = (
|
|
UniqueConstraint('emaillog_id', 'contact_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('communication_emaillog_to_contacts_id_seq'::regclass)"))
|
|
emaillog_id = Column(ForeignKey('communication_emaillog.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
emaillog = relationship('CommunicationEmaillog')
|
|
|
|
|
|
class CommunicationEmaillogToUser(Base):
|
|
__tablename__ = 'communication_emaillog_to_users'
|
|
__table_args__ = (
|
|
UniqueConstraint('emaillog_id', 'lawyeruser_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('communication_emaillog_to_users_id_seq'::regclass)"))
|
|
emaillog_id = Column(ForeignKey('communication_emaillog.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
emaillog = relationship('CommunicationEmaillog')
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
|
|
|
|
class CommunicationPhonelogNotification(Base):
|
|
__tablename__ = 'communication_phonelog_notifications'
|
|
__table_args__ = (
|
|
UniqueConstraint('phonelog_id', 'lawyeruser_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('communication_phonelog_notifications_id_seq'::regclass)"))
|
|
phonelog_id = Column(ForeignKey('communication_phonelog.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
phonelog = relationship('CommunicationPhonelog')
|
|
|
|
|
|
class CommunicationPhonelogToContact(Base):
|
|
__tablename__ = 'communication_phonelog_to_contacts'
|
|
__table_args__ = (
|
|
UniqueConstraint('phonelog_id', 'contact_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('communication_phonelog_to_contacts_id_seq'::regclass)"))
|
|
phonelog_id = Column(ForeignKey('communication_phonelog.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
phonelog = relationship('CommunicationPhonelog')
|
|
|
|
|
|
class CommunicationPhonelogToUser(Base):
|
|
__tablename__ = 'communication_phonelog_to_users'
|
|
__table_args__ = (
|
|
UniqueConstraint('phonelog_id', 'lawyeruser_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('communication_phonelog_to_users_id_seq'::regclass)"))
|
|
phonelog_id = Column(ForeignKey('communication_phonelog.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
phonelog = relationship('CommunicationPhonelog')
|
|
|
|
|
|
class CommunicationSecuremessageToContact(Base):
|
|
__tablename__ = 'communication_securemessage_to_contacts'
|
|
__table_args__ = (
|
|
UniqueConstraint('securemessage_id', 'contact_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('communication_securemessage_to_contacts_id_seq'::regclass)"))
|
|
securemessage_id = Column(ForeignKey('communication_securemessage.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
contact_id = Column(ForeignKey('contact_contact.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
contact = relationship('ContactContact')
|
|
securemessage = relationship('CommunicationSecuremessage')
|
|
|
|
|
|
class NoteNoteNotification(Base):
|
|
__tablename__ = 'note_note_notifications'
|
|
__table_args__ = (
|
|
UniqueConstraint('note_id', 'lawyeruser_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('note_note_notifications_id_seq'::regclass)"))
|
|
note_id = Column(ForeignKey('note_note.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
note = relationship('NoteNote')
|
|
|
|
|
|
class ReminderReminder(Base):
|
|
__tablename__ = 'reminder_reminder'
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('reminder_reminder_id_seq'::regclass)"))
|
|
created_at = Column(DateTime(True), nullable=False)
|
|
updated_at = Column(DateTime(True), nullable=False)
|
|
target_date = Column(DateTime(True), nullable=False)
|
|
notification_type = Column(Integer, nullable=False)
|
|
creator_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
task_id = Column(ForeignKey('task_task.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
celery_id = Column(String(128))
|
|
title = Column(String(256))
|
|
|
|
creator = relationship('AccountLawyeruser')
|
|
task = relationship('TaskTask')
|
|
|
|
|
|
class BillingBillTimeEntry(Base):
|
|
__tablename__ = 'billing_bill_time_entries'
|
|
__table_args__ = (
|
|
UniqueConstraint('bill_id', 'timeentry_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('billing_bill_time_entries_id_seq'::regclass)"))
|
|
bill_id = Column(ForeignKey('billing_bill.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
timeentry_id = Column(ForeignKey('activity_timeentry.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
bill = relationship('BillingBill')
|
|
timeentry = relationship('ActivityTimeentry')
|
|
|
|
|
|
class ReminderReminderTargetUser(Base):
|
|
__tablename__ = 'reminder_reminder_target_users'
|
|
__table_args__ = (
|
|
UniqueConstraint('reminder_id', 'lawyeruser_id'),
|
|
)
|
|
|
|
id = Column(BigInteger, primary_key=True, server_default=text("nextval('reminder_reminder_target_users_id_seq'::regclass)"))
|
|
reminder_id = Column(ForeignKey('reminder_reminder.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
lawyeruser_id = Column(ForeignKey('account_lawyeruser.id', deferrable=True, initially='DEFERRED'), nullable=False, index=True)
|
|
|
|
lawyeruser = relationship('AccountLawyeruser')
|
|
reminder = relationship('ReminderReminder')
|