|
This has information about the bank and its branch's codes. There is also an attribute about the account number. You can also customise and include additional details pertaining to the company bank. |
|
Name |
Code |
Class Name |
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Shows the code for the bank. This acts as the primary key for the BankSubmitCompanyBank table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Shows the branch code of the bank. This acts as the primary key for the BankSubmitCompanyBank table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Stores the account number of the bank. This acts as the primary key for the BankSubmitCompanyBank table. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Often comes in a form of a checkbox. The customer can create a questionnaire and have the option to either check or uncheck the box. Ticking the box will show “1” in the database while not checking the box will show “0”. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Often comes in a form of a checkbox. The customer can create a questionnaire and have the option to either check or uncheck the box. Ticking the box will show “1” in the database while not checking the box will show “0”. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Often comes in a form of a checkbox. The customer can create a questionnaire and have the option to either check or uncheck the box. Ticking the box will show “1” in the database while not checking the box will show “0”. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
It only allows whole numbers to be entered. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
It only allows whole numbers to be entered. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
It only allows whole numbers to be entered. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Usually represents numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45 |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Usually represents numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45 |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Usually represents numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45 |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
It can ask for the date-of-birth or hire date of the user and this function will show a calendar for an easier selection. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
It can ask for the date-of-birth or hire date of the user and this function will show a calendar for an easier selection. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
It can ask for the date-of-birth or hire date of the user and this function will show a calendar for an easier selection. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
|
|