树结构数据表

create table coprtrade
(
  ID      NUMBER not null,
  name    varchar2(50) not null,
  PID     NUMBER,
  ORDERID NUMBER not null,
  CNUM    NUMBER not null,
  PATH    VARCHAR2(50) not null,
  DEPTH   NUMBER not null
)

create sequence SEQ_COPRTRADE_ID
minvalue 1
nomaxvalue
start with 1
increment by 1