索引和约束

1.XUECI_CIKU_DANCI:




2:KEYS:




3:CHECKS:



4:INDEXES:




5.主键约束：

引用

alter table XUECI_CIKU_DANCI
  add constraint PK_XUECI_CIKU_DANCI primary key (ID)
  using index
  tablespace XUECI
  pctfree 10
  initrans 2
  maxtrans 255;

6.外键约束：

引用

alter table XUECI_CIKU_DANCI
  add constraint FK_CIKU_DANCI_CIKU foreign key (CIKU_ID)
  references XUECI_CIKU (ID);

alter table XUECI_CIKU_DANCI
  add constraint FK_CIKU_DANCI_DANCI foreign key (DANCI_ID)
  references XUECI_DANCI (ID);

7：索引：

引用

create index INDEX_XUECI_CIKU_DANCI_CIKUID on XUECI_CIKU_DANCI (CIKU_ID)
  tablespace XUECI
  pctfree 10
  initrans 2
  maxtrans 255;

create index INDEX_XUECI_CIKU_DANCI_DANCIID on XUECI_CIKU_DANCI (DANCI_ID)
  tablespace XUECI
  pctfree 10
  initrans 2
  maxtrans 255;

create bitmap index INDEX_XUECI_CIKU_DANCI_STATUS on XUECI_CIKU_DANCI (STATUS)
  tablespace XUECI
  pctfree 10
  initrans 2
  maxtrans 255;