RdsDiagram
DIM_ENTERPRISE
id_enterprise: INTEGER
id_entity: INTEGER
id_entity_type: INTEGER
rfc: VARCHAR(20)
name: VARCHAR(255)
commercial_name: VARCHAR(255)
id_economic_activity: INTEGER
id_gender: INTEGER
id_segment: INTEGER
id_channel: INTEGER
email: VARCHAR(50)
created_date: DATE
num_applications: INTEGER
num_products: INTEGER
num_active_products: INTEGER
num_shareholders: INTEGER
attr_industry: VARCHAR(255)
attr_anual_income: VARCHAR(100)
attr_employees: INTEGER
attr_business_about: VARCHAR(255)
attr_sell_product: SMALLINT
attr_sell_different_product: SMALLINT
attr_sell_online: SMALLINT
attr_current_erp: VARCHAR(155)
load_date: DATE
modification_date: DATE
ENTERPRISE_PRODUCT_REFERENCE_HIST
id_enterprise: INTEGER
id_application: INTEGER
row_key: INTEGER
created_date: DATE
registration_date: DATE
desc_status: INTEGER
id_user: INTEGER
id_folio: INTEGER
id_product: INTEGER
start_date: DATE
end_date: DATE
active_record: INTEGER
load_date: DATE
modification_date: DATE
DIM_PRODUCT
id_product: INTEGER
desc_product_short: VARCHAR(50)
desc_product_long: VARCHAR(100)
load_date: DATE
modification_date: DATE
DIM_ATTRIBUTION_CHANNEL
id_application: INTEGER
id_channel: INTEGER
desc_channel: VARCHAR(50)
id_finance_channel: INTEGER
desc_finance_channel: VARCHAR(50)
id_segment: INTEGER
desc_segment: VARCHAR(50)
id_source: INTEGER
load_date: DATE
modification_date: DATE
DIM_ENTITY_TYPE
id_entity_type: INTEGER
desc_entity_type_short: VARCHAR(50)
desc_entity_type_long: VARCHAR(50)
load_date: DATE
modification_date: DATE
DIM_ECONOMIC_ACTIVITY
id_economic_activity: INTEGER
desc_economic_activity: INTEGER
load_date: DATE
modification_date: DATE
NATURAL_PERSON_PHONE_HIST
id_natural_person: INTEGER
id_phone: INTEGER
id_phone_status: INTEGER
id_phone_type: INTEGER
id_phone_source: INTEGER
start_date: DATE
end_date: DATE
load_date: DATE
modification_date: DATE
DIM_NATURAL_PERSON
id_natural_person: INTEGER
id_user: INTEGER
id_gender: INTEGER
curp: VARCHAR(50)
rfc: VARCHAR(50)
email: VARCHAR(100)
name: VARCHAR(155)
paternal_last_name: VARCHAR(155)
maternal_last_name: VARCHAR(155)
date_birth: INTEGER
load_date: DATE
modification_date: DATE
ENTERPRISE_NATURAL_PERSON_HIST
id_enterprise: INTEGER
id_natural_person: INTEGER
id_role: INTEGER
shareholder_percent: INTEGER
one_man_show: INTEGER
start_date: DATE
end_date: DATE
load_date: DATE
modification_date: DATE
DIM_GENDER
id_gender: INTEGER
desc_geder_es: VARCHAR(25)
desc_gender_en: VARCHAR(25)
gender_key: VARCHAR(5)
load_date: DATE
modification_date: DATE
DIM_NATURAL_PERSON_ROLE
id_role: INTEGER
desc_role: VARCHAR(50)
load_date: DATE
modification_date: DATE
DIM_SEGMENT
id_segment: INTEGER
start_date: DATE
completed_date: DATE
desc_current_segment: VARCHAR(25)
desc_current_subsegment: VARCHAR(25)
desc_completed_segment: VARCHAR(25)
dsec_completed_subsegment: VARCHAR(25)
load_date: DATE
modification_date: DATE
DIM_ADDRESS
id_address: INTEGER
street: VARCHAR(255)
number: VARCHAR(50)
exterior_number: VARCHAR(50)
id_zip_code: INTEGER
load_date: DATE
modification_date: DATE
ENTERPRISE_ADDRESS_HIST
id_enterprise: INTEGER
id_address: INTEGER
id_address_type: INTEGER
id_address_status: INTEGER
start_date: DATE
end_date: DATE
load_date: DATE
modification_date: DATE
NATURAL_PERSON_ADDRESS_HIST
id_natural_person: INTEGER
id_address: INTEGER
id_address_type: INTEGER
id_address_status: INTEGER
start_date: DATE
end_date: DATE
load_date: DATE
modification_date: DATE
DIM_ADDRESS_TYPE
id_address_type: INTEGER
desc_address_type_en: VARCHAR(25)
desc_address_type_es: VARCHAR(25)
load_date: DATE
modification_date: DATE
DIM_ADDRESS_STATUS
id_address_status: INTEGER
desc_address_status: VARCHAR(25)
desc_address_status_long: VARCHAR(100)
load_date: DATE
modification_date: DATE
DIM_CITY
id_city: INTEGER
id_state: INTEGER
desc_city: VARCHAR(150)
load_date: DATE
modification_date: DATE
DIM_MUNICIPALITY
id_municipality: INTEGER
id_city: INTEGER
desc_municipality: VARCHAR(50)
load_date: DATE
modification_date: DATE
DIM_ZIP_CODE
id_zip_code: INTEGER
zip_code: VARCHAR(20)
id_municipality: INTEGER
desc_zona: VARCHAR(25)
load_date: DATE
modification_date: DATE
DIM_STATE
id_state: INTEGER
desc_short_state: VARCHAR(25)
desc_long_state: VARCHAR(50)
desc_code_state: VARCHAR(25)
load_date: DATE
modification_date: DATE
DIM_PHONE
id_phone: INTEGER
phone_number: VARCHAR(50)
load_date: DATE
modification_date: DATE
DIM_PHONE_STATUS
id_phone_status: INTEGER
desc_phone_status_en: VARCHAR(25)
desc_phone_status_en: VARCHAR(25)
load_date: DATE
modification_date: DATE
DIM_PHONE_TYPE
id_phone_type: INTEGER
desc_phone_type_es: VARCHAR(25)
desc_phone_type_en: VARCHAR(25)
load_date: DATE
modification_date: DATE
DIM_PHONE_SOURCE
id_phone_source: INTEGER
desc_phone_source_es: VARCHAR(25)
desc_phone_source_en: VARCHAR(25)
load_date: DATE
modification_date: DATE
DIM_CHANNEL
id_channel: INTEGER
desc_channel: VARCHAR(50)
load_date: DATE
modification_date: DATE