Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    Repo - Report - Super Repo - Services - Programs 1 Repo - Codes - Super 1 1 1 1 1 1

    Uploaded by

    Sandra Patricia
    The document describes the structure of multiple database tables. It includes tables for services and programs, compensation offices, codes and categories, and a report table that includes fields to store details about individuals, documents, products, and monetary values.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Repo - Report - Super Repo - Services - Programs 1 Repo - Codes - Super 1 1 1 1 1 1

    Uploaded by

    Sandra Patricia
    13 views1 page
    The document describes the structure of multiple database tables. It includes tables for services and programs, compensation offices, codes and categories, and a report table that includes fields to store details about individuals, documents, products, and monetary values.

    Original Description:

    reporte super

    Original Title

    REPOR SUPER M.R

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes the structure of multiple database tables. It includes tables for services and programs, compensation offices, codes and categories, and a report table that includes fields to store details about individuals, documents, products, and monetary values.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    13 views1 page

    Repo - Report - Super Repo - Services - Programs 1 Repo - Codes - Super 1 1 1 1 1 1

    Uploaded by

    Sandra Patricia
    The document describes the structure of multiple database tables. It includes tables for services and programs, compensation offices, codes and categories, and a report table that includes fields to store details about individuals, documents, products, and monetary values.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    repo_services_programs repo_report_super repo_codes_super

    11 11
    id TINYINT id BIGINT
    id INT
    code_service VARCHAR(45) invoice_id INT
    ∞
    ∞ code VARCHAR(100)
    service VARCHAR(45) compensation_office_id SMALLINT
    name VARCHAR(100)
    code_program VARCHAR(45) program_id INT
    code_child VARCHAR(100)
    program VARCHAR(45) third_party_id INT
    ∞
    ∞ description_child VARCHAR(100)
    created_at DATETIME service_program_id TINYINT
    status VARCHAR(45)
    updated_at DATETIME document_type VARCHAR(10)
    created_at DATETIME
    deleted_at DATETIME document VARCHAR(30)
    updated_at DATETIME
    first_name_titular VARCHAR(45)
    deleted_at DATETIME
    second_name_titular VARCHAR(45)
    first_lastname_titular VARCHAR(45)
    second_lastname_titular VARCHAR(45)

    gender_titular CHAR(1)
    admi_compensation_offices ∞
    11 code_super_gender_titular_id INT
    id INT
    category_titular CHAR(1)
    code_office VARCHAR(100) ∞
    ∞
    code_super_category_titular_id INT
    compensation_office VARCHAR(100)
    birthdate_titular DATE
    description VARCHAR(100)
    age CHAR(3)
    status VARCHAR(10) ∞
    ∞
    code_super_range_age_titular_id INT
    created_at DATETIME
    document_type_affiliate VARCHAR(30)
    updated_at DATETIME
    document_affiliate VARCHAR(10)
    deleted_at DATETIME
    first_name_affilaite VARCHAR(45)

    second_name_affiliate VARCHAR(45)
    first_lastname_affiliate VARCHAR(45)
    second_lastname_affiliate VARCHAR(45)
    gender_affiliate CHAR(1)
    ∞
    ∞
    code_super_gender_affiliate_id INT
    category_affiliate CHAR(1)
    ∞
    ∞
    code_super_category_affiliate_id INT
    birth_date_affiliate DATE
    age_afiliate CHAR(3)
    ∞
    ∞
    code_super_range_age_affiliate_id INT
    product_plu VARCHAR(70)
    product VARCHAR(45)
    quantity SMALLINT

    base_value INT
    value INT
    taxes INT
    total_subsidy INT
    total INT

    quantity_uses SMALLINT
    created_at DATETIME
    update_at DATETIME

    You might also like