oracle表结构设计

-- Create table
create table T_TREASURY_YIELD_CURVE
(
  CURVE_NAME    VARCHAR2(50),
  S_YEAR_LIMIT  VARCHAR2(50),
  AVERAGE_VALUE VARCHAR2(50),
  D_DATE        DATE
)
tablespace CTD
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table T_TREASURY_YIELD_CURVE
  is '国债收益率曲线';
-- Add comments to the columns 
comment on column T_TREASURY_YIELD_CURVE.CURVE_NAME
  is '曲线名称';
comment on column T_TREASURY_YIELD_CURVE.S_YEAR_LIMIT
  is '标准年限';
comment on column T_TREASURY_YIELD_CURVE.AVERAGE_VALUE
  is '平均值';
comment on column T_TREASURY_YIELD_CURVE.D_DATE
  is '日期';