外键约束

 -- Create table
create table USER_PRIVILEGE
(
  ID        VARCHAR2(36) not null,
  MODULE_ID VARCHAR2(36),
  NAME      VARCHAR2(32),
  NOTE      VARCHAR2(128)
)
tablespace VCI
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints
alter table USER_PRIVILEGE
  add constraint PK_USER_PRIVILEGE primary key (ID)
  using index
  tablespace VCI
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table USER_PRIVILEGE
  add constraint FK_PRIV_REF_MODU foreign key (MODULE_ID)
  references USER_MODULE (ID);