个性化定制资料（1）

分类表
分类ID      子类CATALOGID   名称 state

用户内容表.contentuser
用户内容表ID    用户ID   内容ID   catalogname
1  101  1
2  101  2
3  101  5
4  101  7
5  101  10

排列表custorder
表ID   用户内容表ID  顺序号  标识sign
1 1  1 0
2 2  1 1
3 3  1 2

gywra

<table>
 <tr>
  <td>
   <% for(Row r : rows ) {%>
    <table>
     <tr><td>
      
     </td></tr>
    </table>
   <%} %>
  </td>
  <td>

  </td>
  <td>

  </td>
 </tr>
 
</table>

定制customize
custlogin表:id,username,password,problem,answer,email,phone,address,code
custsort表
id,name,catalogid,state

custorder:
id,contentuserid,orderid,sign
 

 

 

create table CUSTLOGIN
(
  ID       NUMBER not null,
  USERNAME VARCHAR2(20) not null,
  PASSWORD VARCHAR2(8) not null,
  PROBLEM  VARCHAR2(50),
  ANSWER   VARCHAR2(50),
  EMAIL    VARCHAR2(50),
  PHONE    VARCHAR2(15),
  ADDRESS  VARCHAR2(100),
  CODE     NUMBER
)

create table CUSTORDER
(
  ID            NUMBER not null,
  CONTENTUSERID NUMBER not null,
  ORDERID       NUMBER not null,
  SIGN          NUMBER not null,
  USERID        NUMBER not null
)

create table CUSTSORT
(
  ID        NUMBER not null,
  CATALOGID NUMBER not null,
  SORTID    NUMBER not null
)

create table CUSTSORTNAME
(
  ID    NUMBER not null,
  NAME  VARCHAR2(50) not null,
  STATE NUMBER not null
)

create table CONTENTUSER
(
  ID          NUMBER not null,
  USERID      NUMBER not null,
  CATALOGID   NUMBER not null,
  CATALOGNAME VARCHAR2(50)
)

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

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

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

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

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