bizentro_UNIERP

Tables (5)

z_auth_gen

    z_auth_gen (미정)

    • (co_cd) — NOT NULL — Primary key
    • (usr_id) — NOT NULL — Primary key — NOT NULL
    • (mnu_id) — NOT NULL — Primary key — NOT NULL
    • (mnu_type) — NOT NULL — Primary key — NOT NULL
    • (action_id) — NOT NULL
    • (upper_mnu_id) — NOT NULL
    • (sys_lvl) — NOT NULL
    • (mnu_seq) — NULL
    • (gen_user_id) — NOT NULL
    • (gen_dt) — NOT NULL

    z_co_mast_mnu (Untitled)

    • (co_cd) — NOT NULL — Primary key — NOT NULL
    • (mnu_id) — NOT NULL — Primary key — NOT NULL
    • (mnu_type) — NOT NULL
    • (called_frm_id) — NOT NULL
    • (use_yn) — NOT NULL
    • (upper_mnu_id) — NULL
    • (upper_mnu_type) — NULL
    • (insrt_user_id) — NOT NULL
    • (insrt_dt) — NOT NULL
    • (updt_user_id) — NOT NULL
    • (updt_dt) — NOT NULL
    • (moduleinitial) — NULL DEFAULT ''::character varying,

    z_common_format (Untitled2)

    • (tenant_id) — NOT NULL — Primary key — NOT NULL
    • (co_cd) — NOT NULL — Primary key — NOT NULL
    • (data_type) — NOT NULL — Primary key — NOT NULL
    • (data_format) — NOT NULL
    • (insrt_user_id) — NOT NULL
    • (insrt_dt) — NOT NULL
    • (updt_user_id) — NOT NULL
    • (updt_dt) — NOT NULL
    • (ext1_cd) — NULL
    • (ext2_cd) — NULL
    • (ext3_cd) — NULL
    • (ext1_qty) — NULL
    • (ext2_qty) — NULL
    • (ext3_qty) — NULL
    • (ext1_dt) — NOT NULL
    • (ext2_dt) — NULL
    • (ext3_dt) — NULL
    • (pgm_id) — NULL
    • (sp_nm) — NULL
    • (ip_addr) — NULL
    • (client_id) — NULL

    z_count_format (Untitled3)

    • (tenant_id) — NOT NULL — Primary key — NOT NULL
    • (co_cd) — NOT NULL — Primary key — NOT NULL
    • (form_type) — NOT NULL — Primary key — NOT NULL
    • (module_cd) — NOT NULL — Primary key — NOT NULL
    • (decimals) — NOT NULL
    • (rounding_unit) — NOT NULL
    • (rounding_policy) — NOT NULL
    • (data_format) — NOT NULL
    • (insrt_user_id) — NOT NULL
    • (insrt_dt) — NOT NULL
    • (updt_user_id) — NOT NULL
    • (updt_dt) — NOT NULL
    • (ext1_cd) — NULL
    • (ext2_cd) — NULL
    • (ext3_cd) — NULL
    • (ext1_qty) — NULL
    • (ext2_qty) — NULL
    • (ext3_qty) — NULL
    • (ext1_dt) — NULL
    • (ext2_dt) — NULL
    • (ext3_dt) — NULL
    • (pgm_id) — NULL
    • (sp_nm) — NULL
    • (ip_addr) — NULL
    • (client_id) — NULL