oracle table上增加 外键，主键，唯一键的 sql

create table NIFM_TARGET_FIELD
(
  FIELD_SEQ         NUMBER not null,
  CATEGORY_ID       NUMBER,
  FIELD_MANDATORY   VARCHAR2(5),
  FIELD_EDITABLE    VARCHAR2(5),
  TARGET_TABLE      VARCHAR2(10),
  DERIVE_ORDER      NUMBER not null,
  DERIVE_RULE       VARCHAR2(4000),
  FIELD_NAME        VARCHAR2(50),
  USE_EXISTEDDATA   VARCHAR2(5),
  EXCEL_DERIVE_RULE VARCHAR2(4000)
)
tablespace TS_DATA_2
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 2M
    next 2M
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
-- Create/Recreate primary, unique and foreign key constraints
alter table NIFM_TARGET_FIELD
  add constraint NIFM_TARGET_FIELD_PK primary key (FIELD_SEQ)
  using index
  tablespace TS_INDEXES_2
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 2M
    next 2M
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
alter table NIFM_TARGET_FIELD
  add constraint NIFM_TARGET_FIELD_UK unique (CATEGORY_ID, FIELD_NAME, TARGET_TABLE)
  using index
  tablespace TS_DATA_1
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 2M
    next 2M
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
alter table NIFM_TARGET_FIELD
  add constraint NIFM_TARGET_FIELD_CAT_FK foreign key (CATEGORY_ID)
  references NIFM_MSG_CATEGORY (CATEGORY_ID) on delete cascade;