-- Create table create table BOI_INST_ORDER ( code string, inst_code string, fund_code string, strategy_code string, cash_account_code string, trade_type string, advisor_code string, advisor_name string, symbol string, secu_code string, secu_name string, status string, amt decimal(15,2), vol decimal(15,2), investment_date decimal(13), remark string, create_user string, update_user string, create_time string, update_time string, exec_code string ) tablespace TBS_COI pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K next 1M minextents 1 maxextents unlimited ); -- Add comments to the table comment on table BOI_INST_ORDER is '委托表'; -- Add comments to the columns comment on column BOI_INST_ORDER.code is '委托编码'; comment on column BOI_INST_ORDER.inst_code is '指令编码'; comment on column BOI_INST_ORDER.fund_code is '产品编码'; comment on column BOI_INST_ORDER.strategy_code is '策略代码'; comment on column BOI_INST_ORDER.cash_account_code is '账户代码'; comment on column BOI_INST_ORDER.trade_type is '交易方向'; comment on column BOI_INST_ORDER.advisor_code is '资产受托人代码'; comment on column BOI_INST_ORDER.advisor_name is '资产受托人名称'; comment on column BOI_INST_ORDER.symbol is 'SYMBOL'; comment on column BOI_INST_ORDER.secu_code is '投资资产编码'; comment on column BOI_INST_ORDER.secu_name is '投资资产名称'; comment on column BOI_INST_ORDER.status is '委托状态'; comment on column BOI_INST_ORDER.amt is '委托金额'; comment on column BOI_INST_ORDER.vol is '委托份额'; comment on column BOI_INST_ORDER.investment_date is '投资执行日'; comment on column BOI_INST_ORDER.remark is '备注'; comment on column BOI_INST_ORDER.create_user is '创建用户'; comment on column BOI_INST_ORDER.update_user is '修改人'; comment on column BOI_INST_ORDER.create_time is '创建时间'; comment on column BOI_INST_ORDER.update_time is '修改时间'; comment on column BOI_INST_ORDER.exec_code is '成交编码'; -- Create/Recreate primary, unique and foreign key constraints alter table BOI_INST_ORDER add primary key (CODE) using index tablespace TBS_COI pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K next 1M minextents 1 maxextents unlimited ); 版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请联系我们举报，一经查实，本站将立刻删除。
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/217981.html原文链接：https://javaforall.net
