Global Unified Key Component ID-ER图

portfolio_template_fy

ID int(11)TEMPLATE_NAME varchar(60)CREATOR varchar(50)MODIFIER varchar(50)CREATE_TIME timestampUPDATE_TIME timestamp

portfolio_sbb_global

ID int(11)SBBNAME varchar(60)CREATOR varchar(50)MODIFIER varchar(50)CREATE_TIME timestampUPDATE_TIME timestampSHORT_NAME varchar(20)

N:1

portfolio_global_item

ID int(11)SBBNAME varchar(60)NUMBER varchar(60)STATE varchar(20)DESCRIPTION varchar(500)GENERATION varchar(200)DELETE_FLAG tinyint(4)CREATOR varchar(50)MODIFIER varchar(50)CREATE_TIME timestampUPDATE_TIME timestampCREATE_GEN VARCHAR(20)SERIAL_NUM VARCHAR(20）

portfolio_template_attribute

attribute_definition

ID int(11)ATTRIBUTE_NAME varchar(50)DISPLAY_NAME varchar(50)ATTRIBUTE_TYPE varchar(60)新增：FYSpec原值:  MKT/Tech/CommonDATA_TYPE varchar(60)

portfolio_fy_item

ID int(11)SBBNAME varchar(60)global_ITEM_ID int(11)ITEM_ID int(11)BASELINE_ID int(11)BASELINE_NAME varchar(50)NUMBER varchar(60)STATE varchar(20)DESCRIPTION varchar(500)GENERATION varchar(200)DELETE_FLAG tinyint(4)CREATOR varchar(50)MODIFIER varchar(50)CREATE_TIME timestampUPDATE_TIME timestamp

1:N

portfolio_template

ID int(11)BASELINE_ID (11)TEMPLATE_NAME varchar(60)TEMPLATE_TYPE varchar(60)RULE_NAME varchar(200)ACTIVED tinyint(4)CREATOR varchar(50)MODIFIER varchar(50)CREATE_TIME timestampUPDATE_TIME timestamp

原有表

attribute_standard_value

ID int(11)ATTRIBUTE_ID(无效字段)ATTRIBUTE_NAME varchar(60)VALUE varchar(60)OBJECT_TYPE varchar(60)STATE VARCHAR(10)新增字段：Visible/InvisibleCREATOR varchar(50)MODIFIER varchar(50)CREATE_TIME timestampUPDATE_TIME timestamp

变更表

attribute_value

ID int(11)ATTRIBUTE_ID int(11)OBJECT_ID int(11VALUE varchar(200)span style=\"font-size: inherit;\

1:1

新增表

portfolio_template_global

portfolio_item

ID int(11)ITEM_NAME varchar(200)DELETE_FLAG tinyint(4)NUMBER varchar（50）STATE varchar(20)CREATOR varchar(50)MODIFIER varchar(50)CREATE_TIME timestampUPDATE_TIME timestamp