odbtools/odbctest/mql/match/ddl/02_class.mql

create class if not exists /project_1000119_harness_draft/paper_trade_record(id varchar "对象实例唯一标识，由 identity_rule 生成。", recap_no varchar "原始 recap 单据编号", qty_source_etrm varchar "ETRM 系统中的数量单位（样本已观察值：BBL、LOT、MT）", qty_lot double "以手（LOT）为单位的交易数量", qty_mt double "以公吨（MT）为单位的交易数量", internal_or_not varchar "是否内部主体交易（样本已观察值：是、否）", dummy_or_not varchar "是否为虚拟交易（样本已观察值：是、否）", parse_status varchar "治理流程解析状态（样本已观察值：success、repaired）", load_time timestamp "治理流程加载时间", trade_record_id varchar "治理后生成的唯一交易记录标识，格式 PAPER_TRADE_xxxxxxxxx", source_line_no int "原始 recap 文件中的行号，用于追溯", system varchar "交易记录来源系统（样本已观察值：Pioneer、Symphony）", trade_date date "交易执行日期", month varchar "原始 recap 中的月份标识（如 Aug 26、202604 等）", month_standard varchar "标准化月份（YYYY-MM 格式），由治理流程从原始 month 字段派生", pricing_from date "计价周期起始日期", pricing_to date "计价周期截止日期", direction varchar "买卖方向（样本已观察值：Buy、Sell）", price double "交易价格", volume_source_etrm double "ETRM 系统中的交易量数值") with core='local', autosearch=true, version=false, key=manu, alias='纸货交易记录', nickname='project_1000119_harness_draft_paper_trade_record', namespace='project_1000119_harness_draft';
create class if not exists /project_1000119_harness_draft/trade_instrument(id varchar "对象实例唯一标识，由 identity_rule 生成。", instrument_id varchar "商品合约唯一标识", type varchar "交易类型（如 Swap、Option 等）", commodity varchar "交易商品名称", price_uom varchar "价格计量单位") with core='local', autosearch=true, version=false, key=manu, alias='商品合约', nickname='project_1000119_harness_draft_trade_instrument', namespace='project_1000119_harness_draft';
create class if not exists /project_1000119_harness_draft/market_exchange(id varchar "对象实例唯一标识，由 identity_rule 生成。", exchange_code varchar "交易所代码", market_id varchar "市场交易所唯一标识", floor_or_otc varchar "场内交易或场外交易", domestic_or_foreign varchar "境内或境外市场", exchange varchar "交易所名称") with core='local', autosearch=true, version=false, key=manu, alias='市场交易所', nickname='project_1000119_harness_draft_market_exchange', namespace='project_1000119_harness_draft';
create class if not exists /project_1000119_harness_draft/booking_entity(id varchar "对象实例唯一标识，由 identity_rule 生成。", booking_entity_id varchar "交易主体唯一标识", booking varchar "Booking 主体名称") with core='local', autosearch=true, version=false, key=manu, alias='交易主体', nickname='project_1000119_harness_draft_booking_entity', namespace='project_1000119_harness_draft';
create class if not exists /project_1000119_harness_draft/counterparty(id varchar "对象实例唯一标识，由 identity_rule 生成。", counterparty_id varchar "交易对手方唯一标识", cp_source_etrm varchar "ETRM 系统中的原始对手方名称", broker_clearing varchar "清算经纪商名称", cp_mdg_bp varchar "MDG 主数据系统中的 BP 编码", cp varchar "标准化后的对手方名称", cp_mdg_source varchar "MDG 数据来源标识", cp_mdg_match_status varchar "MDG 匹配状态") with core='local', autosearch=true, version=false, key=manu, alias='交易对手方', nickname='project_1000119_harness_draft_counterparty', namespace='project_1000119_harness_draft';
create class if not exists /project_1000119_harness_draft/trader(id varchar "对象实例唯一标识，由 identity_rule 生成。", trader_id varchar "交易员唯一标识", trader_source_etrm varchar "ETRM 系统中的原始交易员名称", trader varchar "标准化后的交易员名称", trader_institution varchar "交易员所属机构", trader_bu varchar "交易员所属业务单元", trader_type varchar "交易员类型") with core='local', autosearch=true, version=false, key=manu, alias='交易员', nickname='project_1000119_harness_draft_trader', namespace='project_1000119_harness_draft';
create class if not exists /project_1000119_harness_draft/organization_strategy(id varchar "对象实例唯一标识，由 identity_rule 生成。", org_strategy_id varchar "组织组合策略唯一标识", team varchar "交易团队名称", desk varchar "交易 Desk", portfolio varchar "投资组合", business_unit_by_team varchar "按 Team 分类的业务单元", business_group_1 varchar "业务分组1", business_unit_by_portfolio varchar "按 Portfolio 分类的业务单元", business_layer_1 varchar "业务大类层级", institution varchar "所属分支机构", institution_2 varchar "分支机构2", business_layer_2 varchar "业务子类层级", strategy_type varchar "策略类型", business_layer_3 varchar "业务说明", integration_business_or_not varchar "自营或一体化业务标识") with core='local', autosearch=true, version=false, key=manu, alias='组织组合策略', nickname='project_1000119_harness_draft_organization_strategy', namespace='project_1000119_harness_draft';