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
