Attachment 148666 Details for Bug 291233 – DDL file to create Sybase tables

Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

DDL file to create Sybase tables

SYBASE_SurveyBTMUP.sql (text/plain), 1.48 KB, created by Leonard Theivendra

on 2009-10-02 13:35:45 EDT

(hide)

Description:

Filename:

MIME Type:

Creator: Leonard Theivendra

Created: 2009-10-02 13:35:45 EDT

Size: 1.48 KB

patch

obsolete

>
>
>-- Generated by Relational Schema Center on Tue Mar 08 14:21:38 EST 2005 for Sybase Adaptive Server Enterprise V12.5
>DROP table CHOICETYPE;
>DROP table CHOICE;
>DROP table RESULT;
>DROP table QUESTION;
>DROP table SURVEY;
>
>
>create table SURVEY
>  (NAME VARCHAR(100) not null);
>
>alter table SURVEY
>  add constraint PK_SURVEY primary key (NAME);
>  
>create table QUESTION
>  (NUM INT not null,
>   QUESTIONTEXT VARCHAR(100) null,
>   SURVEY_NAME VARCHAR(100) not null);
>
>alter table QUESTION
>  add constraint PK_QUESTION primary key (NUM, SURVEY_NAME);
>  
>
>create table CHOICE
>  (NUM INT not null,
>   CHOICETEXT VARCHAR(100) null,
>   QUESTION_NUM INT not null,
>   QUESTION_SURVEY_NAME VARCHAR(100) not null);
>
>alter table CHOICE
>  add constraint PK_CHOICE primary key (NUM, QUESTION_NUM, QUESTION_SURVEY_NAME);
>
>  create table RESULT
>  (USERNAME VARCHAR(100) not null,
>   ANSWER INT null,
>   QUESTION_NUM INT not null,
>   QUESTION_SURVEY_NAME VARCHAR(100) not null);
>
>alter table RESULT
>  add constraint PK_RESULT primary key (USERNAME, QUESTION_NUM, QUESTION_SURVEY_NAME);
>
>ALTER TABLE QUESTION 
> add constraint survey
> FOREIGN KEY (SURVEY_NAME) 
>  REFERENCES SURVEY (NAME);
>  
>ALTER TABLE RESULT
> add constraint question
> FOREIGN KEY (QUESTION_NUM, QUESTION_SURVEY_NAME ) 
>  REFERENCES QUESTION (NUM, SURVEY_NAME); 
>  
>ALTER TABLE CHOICE
> add constraint cquestion
> FOREIGN KEY (QUESTION_NUM, QUESTION_SURVEY_NAME ) 
>  REFERENCES QUESTION (NUM, SURVEY_NAME);
>
> 
>
>

Actions: View

Attachments on bug 291233: 148666