--------------------------------------------------------
--  File created - Monday-November-07-2022   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table ANSWERS
--------------------------------------------------------

  CREATE TABLE "IGLOO"."ANSWERS" 
   (	"QUESTION_ID" NUMBER(*,0), 
	"NETID" VARCHAR2(40 BYTE), 
	"ANSWER" VARCHAR2(255 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "IGLOO_TAB" ;
--------------------------------------------------------
--  Constraints for Table ANSWERS
--------------------------------------------------------

  ALTER TABLE "IGLOO"."ANSWERS" MODIFY ("QUESTION_ID" NOT NULL ENABLE);
  ALTER TABLE "IGLOO"."ANSWERS" MODIFY ("NETID" NOT NULL ENABLE);
  ALTER TABLE "IGLOO"."ANSWERS" MODIFY ("ANSWER" NOT NULL ENABLE);
--------------------------------------------------------
--  Ref Constraints for Table ANSWERS
--------------------------------------------------------

  ALTER TABLE "IGLOO"."ANSWERS" ADD CONSTRAINT "ANSWERS_FK1" FOREIGN KEY ("QUESTION_ID")
	  REFERENCES "IGLOO"."QUESTIONS" ("ID") ENABLE;
