http://integratx.sourceforge.net
Administration Module - Common Tables Programs Definition
Common tables are general tables used in IntegraTx Support Module and Transaction
Module extensions. Common tables include:
Table Name |
Description |
|---|---|
| Users | Users that can manage IntegraTx and call its Web Services (client applications use users definitions to access transaction modules) |
| Users Authorizations | Users authorizations to view and/or update tables in the administrator interface. |
| Countries | Countries used by IntegraTx, ISO codes are provided |
| Currencies | Currencies used by IntegraTx, ISO codes are provided |
| Client Applications | Applications that use the Transaction Modules defined in IntegraTx |
| Companies | Companies that belong to the group (these are not external companies, i.e. clients or suppliers) Each company is related to one or more client applications. To better understand this concept, IntegraTx manages information at the "Group" level, where the Group owns the companies and consolidates information. |
| Entity Types | Entities that can have common attributes like name, address, etc. Examples are clients, suppliers, brokers and employees |
| Entities | Once Entity Types are defined, then Entities to be used by IntegraTx can be created |
- The administration module is a web-based application. The presentation layer is developed with Struts, business layer with plain Java classes that invoke Hibernate to access the database. HTML styles are included in a single CSS file.
- A user/password screen is initially shown. The user has to have admin privileges to enter. Passwords are stored in the databased encrypted with the MD5 algorithm.
- The screen layout is arranged as follows: In a left panel, tables can be selected by clicking on the name; then the items are listed. Clicking on an item, another screen appears showing the information that can be updated. From that screen, the item can be removed.
- A "create new..." link above and below the list allows to create a new item.
- Development Environment: Application server is JBoss, database is MySQL, database name integratx. Preferred IDE is Eclipse.
- Directories structure: tables (main directory for tables management), tables/present for files related to Struts, tables/bizlayer for Java business layer sources and tables/datalayer for Hibernate related files. WEB-INF/classes contains the compiled Java for the web application.
All the tables have at the end a user/datestamp record audit trail with the following fields:
| User that created this record | user_creation |
| Date/time when this record was created | datetime_creation |
| User that modified this record | user_mod |
| Date/time when this record was modified | datetime_mod |
- Download the SQL Script to create IntegraTx tables.
- Download Database Diagram in DBDesigner
4 format (or view PNG image
if you don't have the software).
Users
Table: tbl_users - users authorized to access the administrator
interface. Also, users utilized to authenticate Web Services client applications.
Name/Description |
Database field Name |
|---|---|
| User identification | userid |
| User Name (description) | description |
| Password (hashed with MD5 in database) | password |
| Indicates whether the user identifies a client application (0=No, 1=Yes). | is_client_app |
| Indicates whether the user is an administrator (has access to view/update all the tables) (0=No, 1=Yes) | is_admin |
Users Authorizations
Table: tbl_users_auth - Indicates the tables that the user is authorized
to view and/or update. If the user identifies a client application, these authorizations
are ignored.
Name/Description |
Database field Name |
|---|---|
| User identification | userid |
| Name of the table that is granted authorizations to | table_name |
| Indicates whether the user has full access to view and update the table. When validating, rest of fields are ignored if this field is (1=Yes) | has_full_access |
| Indicates whether the user can view records (0=No, 1=Yes) | allowed_to_view |
| Indicates whether the user can create records (0=No, 1=Yes) | allowed_to_create |
| Indicates whether the user can update records (0=No, 1=Yes) | allowed_to_update |
| Indicates whether the user can delete records (0=No, 1=Yes) | allowed_to_delete |
Companies
Table: tbl_companies - companies that belong to the group. Companies
have applications that use IntegraTx services, or, in other words, the client
applications that use IntegraTx services are grouped by company. Different companies
can be located in different countries, and can have transactions in different
currencies. If a company wants to implement IntegraTx withouth the need of consolidating
information from several companies, should define and use only one company code
(i.e. company = "1" ).
To understand this better, IntegraTx manages information at the "Group"
level, where the Group owns the companies and consolidates information, different
companies can have different applications that will use IntegraTx's services,
and each of these companies and/or client applications can manage their own
exchange rate. There is only one "Group" in a typical IntegraTx implementation,
and a basic implementation will have only one Company.
Name/Description |
Database field Name |
|---|---|
| Company | company |
| Company name | name |
| Company legal (complete) name | legal_name |
| Company complete address (withouth country) | address |
| Country where the company resides | country |
Currencies
Table: tbl_currencies - currencies for support and code modules
Name/Description |
Database field Name |
|---|---|
| Currency Code | currency |
| Currency Name | name |
| ISO 4217 Alphabetic Code ( this code can be the same as Currency Code) | iso_alpha |
| ISO 4217 Numeric Code (this code can be the same as Currency Code) | iso_num |
| Default Units (Units use to trade currencies, for instance Yens are traded in hundreds) | default_units |
| User that created this record | user_creation |
| Date/time when this record was created | datetime_creation |
| User that modified this record | user_mod |
| Date/time when this record was modified | datetime_mod |
Countries
Table: tbl_countries - countries for support and code modules
Name/Description |
Database field Name |
|---|---|
| Country Code | country |
| Country Name | name |
| ISO 3166 Code ( this code can be the same as Country Code) | iso_code |
| User that created this record | user_creation |
| Date/time when this record was created | datetime_creation |
| User that modified this record | user_mod |
| Date/time when this record was modified | datetime_mod |
Currencies - Countries Relationship
Table: tbl_rel_curr_country - relationships betweens currencies and
countries
Note: This table was introduced mainly for the Euro, where a single currency
is related to many countries.
Name/Description |
Database field Name |
|---|---|
| Currency Code | currency |
| Country Code | country |
| User that created this record | user_creation |
| Date/time when this record was created | datetime_creation |
| User that modified this record | user_creation |
| Date/time when this record was modified | datetime_creation |
Please send an email to integratx@gmail.com if you wish to contact us.
Also, visit the IntegraTx's SourceForge.net website at www.sourceforge.net/projects/integratx
