RdsDiagram
Customer (A)
id: INTEGER
name: INTEGER
customer_type_id: INTEGER
status: INTEGER
director: VARCHAR(191)
gender: SMALLINT
date_of_birth: DATE
passport_type_id: INTEGER
passport_no: VARCHAR(191)
home_no: VARCHAR(191)
email: VARCHAR(191)
martial_id: INTEGER
education_id: INTEGER
resident_address: VARCHAR(191)
district_id: INTEGER
region_id: INTEGER
mailing_address: VARCHAR(191)
mailing_district_id: INTEGER
mailing_region_id: INTEGER
resident_type_id: INTEGER
living_from: DATE
living_duration: INTEGER
occupy_remarks : VARCHAR(191)
company_name: VARCHAR(191)
company_address: VARCHAR(191)
company_district_id: INTEGER
company_region_id: INTEGER
office_no: VARCHAR(191)
direct_line: VARCHAR(191)
fax_no: VARCHAR(191)
career: VARCHAR(191)
department: VARCHAR(191)
position: VARCHAR(191)
employment_type: INTEGER
work_from: DATE
duration: INTEGER
salary: DECIMAL(12,2)
is_income_proof: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
+ customer_type_id (1:
personal, 2: company,
customer_type
(B.擔保/聯名/咨詢人))
Customer_Types
id: INTEGER
sequece: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Customer_Type_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
customer_type_id: INTEGER
Customer_Occupies
id: INTEGER
enabled: SMALLINT
customer_id: INTEGER
occupy_id: INTEGER
Occupies
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Customer_Mobiles
id: INTEGER
enabled: SMALLINT
customer_id: INTEGER
mobile_no: VARCHAR(20)
Martials
id: INTEGER
sequece: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Martial_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
martial_id: INTEGER
Educations
id: INTEGER
sequece: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Education_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
education_id: INTEGER
Occupy_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
occupy_id: INTEGER
Loan_Informations (STEP 1)
id: INTEGER
customer_id: INTEGER
status: INTEGER
apply_no: VARCHAR(20)
loan_no: VARCHAR(20)
interest_method_id: INTEGER
loan_type_id: INTEGER
repay_cycle_id: INTEGER
rate_type_id: INTEGER
loan_amount: DECIMAL(12,2)
flat_rate: DECIMAL(12,2)
effect_rate: DECIMAL(12,2)
total_tenor: INTERGER
instalment: BIGINT
max_interest: DECIMAL(12,2)
total_interest: DECIMAL(12,2)
apply_date: DATE
loan_purpose_id: INTEGER
branch_id: INTEGER
referral_agent_id: INTEGER
relation: VARCHAR(191)
ref_no: VARCHAR(191)
bank_name: VARCHAR(191)
account_name: VARCHAR(191)
bank_code: VARCHAR(191)
branch_code: VARCHAR(191)
account_name: VARCHAR(191)
account_no: VARCHAR(191)
source_id: INTEGER
source_remarks: TEXT
is_TE_Ref: SMALLINT
remarks: TEXT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Dictricts
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
District_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
district_id: INTEGER
Regions
id: INTEGER
sequence: INTEGER
district_id: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Region_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
region_id: INTEGER
Sources
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Source_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
source_id: INTEGER
Interest_Methods
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Interest_Method_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
interest_method_id: INTEGER
Repay_Cycle_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
repay_cycle_id: INTEGER
Repay_Cycles
id: INTEGER
sequence: INTEGER
status: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Rate_Types
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Rate_Type_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
rate_type_id: INTEGER
Loan_Types
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Loan_Type_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
loan_type_id: INTEGER
Loan_Purposes
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Loan_Purpose_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
loan_purpose_id: INTEGER
Loan_Approvals (STEP 2)
id: INTEGER
loan_id: INTEGER
status: INTEGER
od_rate: DECIMAL(12,2)
od_penalty: DECIMAL(12,2)
up_front_interest_od_rate: DECIMAL(12,2)
up_front_interest_od_penalty: DECIMAL(12,2)
early_settle_lock_period_month: INTEGER
lock_period_fee: DECIMAL(12,2)
late_drawdown_fee_od_rate: DECIMAL(12,2)
late_drawdown_fee_od_penalty: DECIMAL(12,2)
first_due_date: DATE
last_due_date (date): DATE
approval_remarks: TEXT
interest_method_id: INTEGER
repay_cycle_id: INTEGER
rate_type_id: INTEGER
loan_amount: DECIMAL(12,2)
is_last_day_of_month: SMALLINT
total_tenor: INTERGER
monthly_rate: DECIMAL(12,2)
effective_rate: DECIMAL(12,2)
effective_rate_up_front_interest: DECIMAL(12,2)
loan_date: DATE
extended_interest_day: INTEGER
extended_interest: DECIMAL(12,2)
first_repay_amount: DECIMAL(12,2)
instalment_amount: DECIMAL(12,2)
total_interest: DECIMAL(12,2)
total_repay_amount: DECIMAL(12,2)
max_interest: DECIMAL(12,2)
residual: DECIMAL(12,2)
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Loan_Payout (STEP 3)
id: INTEGER
loan_id: INTEGER
status: INTEGER
payout_date: DATE
payout_method_id: INTEGER
payout_remarks: TEXT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
first_due_date
last_due_date calc from apply_date (=
loan_date)
Loan_Repayments (STEP 4)
id: INTEGER
loan_id: INTEGER
tenor: INTEGER
od_date: DATE
od_holidays: INTERGER
repaid_principal: DECIMAL(12,2)
repaid_interest: DECIMAL(12,2)
repay_amount: DECIMAL(12,2)
od_interest: DECIMAL(12,2)
handling_fee: DECIMAL(12,2)
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Loan_OCAs (STEP 5)
id: INTEGER
loan_id: INTEGER
oca_date: DATE
oca_agent_id: INTEGER
collection_amount: DECIMAL(12,2)
collection_tenor: INTEGER
remarks: TEXT
status: INTEGER
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Loan_OCA_Details
id: INTEGER
loan_oca_id: INTEGER
repayment_date: DATE
amount_recovered: DECIMAL(12,2)
oca_agent_id: INTEGER
charge: DECIMAL(12,2)
charges: DECIMAL(12,2)
solicitor_id: INTEGER
solicitor_fee: DECIMAL(12,2)
enabled: SMALLINT
balance_amount: DECIMAL(12,2)
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Loan_OCA_Writeoffs
id: INTEGER
loan_oca_id: INTEGER
repayment_date: DATE
amount_recovered: DECIMAL(12,2)
oca_agent_id: INTEGER
charge: DECIMAL(12,2)
charges: DECIMAL(12,2)
collection_ballance: DECIMAL(12,2)
enabled: SMALLINT
remarks: TEXT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Interest_Methods
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Interest_Method_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
interest_method_id: INTEGER
Repay_Cycles
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Repay_Cycle_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
repay_cycle_id: INTEGER
Rate_Types
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Rate_Type_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
rate_type_id: INTEGER
Loan_Partakers (B)
id: INTEGER
loan_id: INTEGER
customer_id: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Loan_Credit_Refs (C)
id: INTEGER
loan_id: INTEGER
bank_id: INTEGER
credit_type_id: INTEGER
enabled: SMALLINT
loan_amount: DECIMAL(12,2)
instalment_amount: DECIMAL(12,2)
o_s_tenors: INTERGER
balance_amount: DECIMAL(12,2)
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Loan_Documents (D)
id: INTEGER
enabled: SMALLINT
loan_id: INTEGER
document_type_id: INTEGER
file_name: VARCHAR(191)
size: INTEGER
remarks: TEXT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Loan_Mortgages (E)
id: INTEGER
loan_id: INTEGER
property_address: VARCHAR(191)
saleable_area: VARCHAR(191)
gross_floor_area: VARCHAR(191)
saleable_ratio: DECIMAL(12,2)
enabled: SMALLINT
completion_year: INTERGER
resident_type_id: INTEGER
property_use: INTEGER
remarks: TEXT
purchase_date: DATE
purchase_price: DECIMAL(12,2)
price_per_ft_saleable_area: DECIMAL(12,2)
price_per_ft_gross_floor_area: DECIMAL(12,2)
insurance_agent: VARCHAR(191)
insurance_charges: DECIMAL(12,2)
solicitor_id: INTEGER
solicitor_charges: DECIMAL(12,2)
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Loan_Mortgage_Valuations
id: INTEGER
loan_mortgage_id: INTEGER
value: VARCHAR(191)
valuation_company: VARCHAR(191)
valuation_date: DATE
valuation_charges: DECIMAL(12,2)
Loan_Mortgage_Banks
id: INTEGER
loan_mortgage_id: INTEGER
bank_id: INTEGER
mortgage_o_s: DECIMAL(12,2)
Bank
id: INTEGER
sequece: INTEGER
bank: VARCHAR(191)
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Solicitors
id: INTEGER
sequece: INTEGER
name: VARCHAR(191)
contact_person: VARCHAR(191)
contact_person: VARCHAR(191)
tel_no: VARCHAR(191)
address: VARCHAR(191)
enabled: SMALLINT
created: DATE
updated: DATE
created_by: INTEGER
updated_by: INTEGER
Resident_Types
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Resident_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
resident_type_id: INTEGER
Document_Types
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Document_Type_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
document_type_id: INTEGER
Payout_Methods
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Payout_Method_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
payout_method_id: INTEGER
Credit_Types
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Credit_Type_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
credit_type_id: INTEGER
OCA_Agents
id: INTEGER
sequence: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
OCA_Agent_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
oca_agent_id: INTEGER
Passport_Types
id: INTEGER
sequece: INTEGER
enabled: SMALLINT
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Passport_Type_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
passport_type_id: INTEGER
Comany
Administration
Companies
id: INTEGER
liscense_number: VARCHAR(191)
enabled: INTEGER
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Company_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
company_id: INTEGER
Branches
id: INTEGER
enabled: INTEGER
phone: VARCHAR(20)
fax: VARCHAR(20)
email: VARCHAR(191)
website: VARCHAR(191)
sequence: INTEGER
company_id: INTEGER
created: DATE
created_by: INTEGER
updated: DATE
updated_by: INTEGER
Branch_Languages
id: INTEGER
alias: VARCHAR(191)
name: VARCHAR(191)
branch_id: INTEGER
Administrators
Roles
Adminstrators_Roles
Permissions
Roles_Permissions