RdsDiagram
t_user
id: BIGINT
login: VARCHAR(50)
password: VARCHAR(100)
first_name: VARCHAR(50)
email: VARCHAR(100)
last_name: VARCHAR(50)
activated: BOOLEAN
lang_key: VARCHAR(5)
activation_key: VARCHAR(20)
created_by: VARCHAR(50)
created_date: DATE
last_modified_by: VARCHAR(50)
last_modified_date: DATE
applicant_id: BIGINT
t_phone
id: BIGINT
number: VARCHAR(255)
phonetype_id: BIGINT
applicant_id: BIGINT
t_phonetype
id: VARCHAR(255)
name: VARCHAR(255)
code: VARCHAR(255)
t_authority_user
user_: VARCHAR(50)
authority_name: VARCHAR(50)
t_authority
name: VARCHAR(50)
t_alternateuser
id: BIGINT
external_identifier: VARCHAR(255)
user_id: BIGINT
authprovider_id: BIGINT
t_authprovider
id: BIGINT
code: VARCHAR(255)
name: VARCHAR(255)
t_applicant
id: BIGINT
last_name: VARCHAR(255)
birth_date: DATE
email: VARCHAR(255)
group_name: VARCHAR(255)
gender_id: BIGINT
first_name: VARCHAR(255)
address_id: BIGINT
t_gender
id: BIGINT
code: VARCHAR(255)
name: VARCHAR(255)
t_dependent
id: BIGINT
first_name: VARCHAR(255)
last_name: VARCHAR(255)
birth_date: DATE
applicant_id: BIGINT
dependenttype_id: BIGINT
gender_id: BIGINT
t_dependenttype
id: BIGINT
code: VARCHAR(255)
name: VARCHAR(255)
t_address
id: BIGINT
address_line1: VARCHAR(255)
address_line2: VARCHAR(255)
city: VARCHAR(255)
postal_code: VARCHAR(255)
province_id: BIGINT
applicant_id: BIGINT
t_province
id: BIGINT
code: VARCHAR(255)
name: VARCHAR(255)
t_applicantplandesign
id: BIGINT
effective_date: DATE
applicant_id: BIGINT
planrate_id: BIGINT
created_by: VARCHAR(255)
created_date: DATE
last_modified_by: VARCHAR(255)
last_modifed_date: DATE
active: BOOLEAN
expiry_date: DATE
rate: NUMERIC(0,0)
enrollment_date: DATE
t_planrate
id: BIGINT
age_from: INTEGER
age_to: INTEGER
rate: NUMERIC(0,0)
effective_date: DATE
planref_id: BIGINT
province_id: BIGINT
familytype_id: BIGINT
t_familytype
code: VARCHAR(255)
name: VARCHAR(255)
id: BIGINT
t_planref
id: BIGINT
benefit_number: VARCHAR(255)
friendly_name: VARCHAR(255)
supplier_id: BIGINT
planreftype: BIGINT
t_supplier
id: BIGINT
code: VARCHAR(255)
name: VARCHAR(255)
t_planreftype
id: BIGINT
code: VARCHAR(255)
name: VARCHAR(255)
t_payment
id: BIGINT
amount: NUMERIC(0,0)
created_by: VARCHAR(50)
created_date: DATE
last_modified_by: VARCHAR(50)
last_modified_date: DATE
tracking_id: VARCHAR(255)
applicantplandesign_id: BIGINT
paymentmethod_id: BIGINT
paymentstatus_id: BIGINT
effective_date: DATE
initial_enrollment: BOOLEAN
transaction_date: DATE
t_paymentstatus
id: BIGINT
code: VARCHAR(255)
name: VARCHAR(255)
t_paymentmethod
id: BIGINT
paymenttype_id: BIGINT
paymentProvider_id: BIGINT
t_paymenttype
id: BIGINT
code: VARCHAR(255)
name: VARCHAR(255)
t_paymentprovider
id: BIGINT
code: VARCHAR(255)
name: VARCHAR(255)