MambuPy.orm.schema_clients
Schema tables for Mambu Clients.
Todo
this are just very basic schemas for clients. A lot of fields are missing.
Classes
|
Client table. |
|
GroupRole table. |
|
IdentificationDocument table. |
- class MambuPy.orm.schema_clients.Client(**kwargs)[source]
Bases:
Base
Client table.
- __init__(**kwargs)
A simple constructor that allows initialization from kwargs.
Sets attributes on the constructed instance using the names and values in
kwargs
.Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.
- __mapper__ = <Mapper at 0x7f0448610460; Client>
- __module__ = 'MambuPy.orm.schema_clients'
- __table__ = Table('client', MetaData(bind=None), Column('encodedKey', String(), table=<client>, primary_key=True, nullable=False), Column('id', String(), table=<client>), Column('firstName', String(), table=<client>), Column('middleName', String(), table=<client>), Column('lastName', String(), table=<client>), Column('homePhone', String(), table=<client>), Column('mobilePhone1', String(), table=<client>), Column('mobilePhone2', String(), table=<client>), Column('emailAddress', String(), table=<client>), Column('gender', String(), table=<client>), Column('state', String(), table=<client>), Column('loanCycle', Integer(), table=<client>), Column('birthDate', DateTime(), table=<client>), Column('creationDate', DateTime(), table=<client>), Column('activationDate', DateTime(), table=<client>), Column('approvedDate', DateTime(), table=<client>), Column('assignedBranchKey', String(), ForeignKey('mambu_db.branch.encodedKey'), table=<client>), schema='mambu_db')
- __table_args__ = {'keep_existing': True, 'schema': 'mambu_db'}
- __tablename__ = 'client'
- _sa_class_manager = {'activationDate': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'activities': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'addresses': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'approvedDate': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'assignedBranchKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'birthDate': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'branch': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'creationDate': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'customInformation': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'emailAddress': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'encodedKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'firstName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'gender': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'groups': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'homePhone': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'id': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'identificationDocuments': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'lastName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'loanCycle': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'loans': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'middleName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'mobilePhone1': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'mobilePhone2': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'roles': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'state': <sqlalchemy.orm.attributes.InstrumentedAttribute object>}
- activationDate
- activities
- addresses
- approvedDate
- assignedBranchKey
- birthDate
- branch
- creationDate
- customInformation
- emailAddress
- encodedKey
- firstName
- gender
- groups
- homePhone
- id
- identificationDocuments
- lastName
- loanCycle
- loans
- middleName
- mobilePhone1
- mobilePhone2
- property name
- roles
- state
- class MambuPy.orm.schema_clients.GroupRole(**kwargs)[source]
Bases:
Base
GroupRole table.
Association object for many-to-many relationship
- __init__(**kwargs)
A simple constructor that allows initialization from kwargs.
Sets attributes on the constructed instance using the names and values in
kwargs
.Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.
- __mapper__ = <Mapper at 0x7f044859eb20; GroupRole>
- __module__ = 'MambuPy.orm.schema_clients'
- __table__ = Table('grouprole', MetaData(bind=None), Column('encodedKey', String(), table=<grouprole>, primary_key=True, nullable=False), Column('clientKey', String(), ForeignKey('mambu_db.client.encodedKey'), table=<grouprole>, nullable=False), Column('groupKey', String(), ForeignKey('mambu_db.group.encodedKey'), table=<grouprole>, nullable=False), Column('groupRoleNameKey', String(), ForeignKey('mambu_db.grouprolename.encodedKey'), table=<grouprole>, nullable=False), schema='mambu_db')
- __table_args__ = {'keep_existing': True, 'schema': 'mambu_db'}
- __tablename__ = 'grouprole'
- _sa_class_manager = {'client': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'clientKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'encodedKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'group': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'groupKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'groupRoleNameKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'roleName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>}
- client
- clientKey
Reference to client
- encodedKey
- group
- groupKey
Reference to group
- groupRoleNameKey
Reference to role name
- roleName
- property rolename
- class MambuPy.orm.schema_clients.IdentificationDocument(**kwargs)[source]
Bases:
Base
IdentificationDocument table. Related with client
- __init__(**kwargs)
A simple constructor that allows initialization from kwargs.
Sets attributes on the constructed instance using the names and values in
kwargs
.Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.
- __mapper__ = <Mapper at 0x7f04485af850; IdentificationDocument>
- __module__ = 'MambuPy.orm.schema_clients'
- __table__ = Table('identificationdocument', MetaData(bind=None), Column('encodedKey', String(), table=<identificationdocument>, primary_key=True, nullable=False), Column('documentId', String(), table=<identificationdocument>), Column('documentType', String(), table=<identificationdocument>), Column('indexInList', Integer(), table=<identificationdocument>), Column('issuingAuthority', String(), table=<identificationdocument>), Column('validUntil', DateTime(), table=<identificationdocument>), Column('identificationDocumentTemplateKey', String(), table=<identificationdocument>), Column('clientKey', String(), ForeignKey('mambu_db.client.encodedKey'), table=<identificationdocument>), schema='mambu_db')
- __table_args__ = {'keep_existing': True, 'schema': 'mambu_db'}
- __tablename__ = 'identificationdocument'
- _sa_class_manager = {'client': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'clientKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'documentId': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'documentType': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'encodedKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'identificationDocumentTemplateKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'indexInList': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'issuingAuthority': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'validUntil': <sqlalchemy.orm.attributes.InstrumentedAttribute object>}
- client
- clientKey
- documentId
- documentType
- encodedKey
- identificationDocumentTemplateKey
- indexInList
- issuingAuthority
- validUntil