Advertisement
Smudla

TABULKY SQL

May 18th, 2015
434
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.25 KB | None | 0 0
  1. CREATE TABLE "ST43249"."UCI"
  2.    (    "ID_STUDENTA" CHAR(7 BYTE) NOT NULL ENABLE,
  3.     "ID_UCITELE" NUMBER(5,0) NOT NULL ENABLE,
  4.     "PREDMET" VARCHAR2(30 BYTE) NOT NULL ENABLE,
  5.     "ZNAMKA" NUMBER(2,1),
  6.      CONSTRAINT "UCIPK" PRIMARY KEY ("ID_STUDENTA", "ID_UCITELE", "PREDMET")
  7.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  8.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  9.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  10.   TABLESPACE "STUDENTS"  ENABLE
  11.    ) SEGMENT CREATION IMMEDIATE
  12.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  13.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  14.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  15.   TABLESPACE "STUDENTS" ;
  16.  
  17.  
  18.  
  19.   CREATE TABLE "ST43249"."UCITELE"
  20.    (    "ID_UCITELE" NUMBER(5,0) NOT NULL ENABLE,
  21.     "JMENO" VARCHAR2(40 BYTE),
  22.     "PRIJMENI" VARCHAR2(40 BYTE),
  23.      CONSTRAINT "UCITELPK" PRIMARY KEY ("ID_UCITELE")
  24.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  25.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  26.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  27.   TABLESPACE "STUDENTS"  ENABLE
  28.    ) SEGMENT CREATION IMMEDIATE
  29.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  30.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  31.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  32.   TABLESPACE "STUDENTS" ;
  33.  
  34.  
  35.   CREATE TABLE "ST43249"."STUDENTI"
  36.    (    "ID_STUDENTA" CHAR(7 BYTE) NOT NULL ENABLE,
  37.     "JMENO" VARCHAR2(40 BYTE),
  38.     "PRIJMENI" VARCHAR2(40 BYTE),
  39.     "NASTUP" DATE,
  40.      CONSTRAINT "ID_STUDENTAPK" PRIMARY KEY ("ID_STUDENTA")
  41.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  42.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  43.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  44.   TABLESPACE "STUDENTS"  ENABLE
  45.    ) SEGMENT CREATION IMMEDIATE
  46.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  47.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  48.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  49.   TABLESPACE "STUDENTS" ;
  50.  
  51.  
  52.   CREATE TABLE "ST43249"."KNIHY"
  53.    (    "ID_KNIHY" NUMBER(7,0) NOT NULL ENABLE,
  54.     "ID_STUDENTA" CHAR(7 BYTE),
  55.     "NAZEV" VARCHAR2(150 BYTE),
  56.      CONSTRAINT "KNIHAPK" PRIMARY KEY ("ID_KNIHY")
  57.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  58.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  59.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  60.   TABLESPACE "STUDENTS"  ENABLE
  61.    ) SEGMENT CREATION IMMEDIATE
  62.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  63.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  64.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  65.   TABLESPACE "STUDENTS" ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement