| název sloupce | typ | výchozí | omezení |
|---|
|
ID
| NUMBER ( 22 ) | | |
| KDO | VARCHAR2 ( 120 ) | | NOT NULL |
| KDY | DATE ( ) | | NOT NULL |
| KOD | VARCHAR2 ( 80 ) | | NOT NULL , XLS_STAT_U_KOD
|
| NAZEV | VARCHAR2 ( 80 ) | | NOT NULL , XLS_STAT_U_...
|
| NADPIS | VARCHAR2 ( 800 ) | | |
| POPIS | VARCHAR2 ( 4000 ) | | |
| REPORT | CLOB ( ) | | |
| FONT | VARCHAR2 ( 120 ) | | |
| PRIZNAKY | VARCHAR2 ( 40 ) | | |
| BORDERTOP | NUMBER ( 22 ) | | |
| BORDERBOTTOM | NUMBER ( 22 ) | | |
| BORDERLEFT | NUMBER ( 22 ) | | |
| BORDERRIGHT | NUMBER ( 22 ) | | |
Unikátní XLS_STAT_U_KOD (KOD)
Unikátní XLS_STAT_U_NAZEV (NAZEV)
|
Trigger XLS_STAT_ID
|
| BEFORE INSERT ON
XLS_STAT
|
| BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD |
begin
:NEW.ID := coalesce(:NEW.ID,nextid);
end;
|
Trigger XLS_STAT_KDO
|
| BEFORE INSERT OR UPDATE ON
XLS_STAT
|
| BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD |
begin
:NEW.KDO := NVL(:NEW.KDO,USER);
:NEW.KDY := SYSDATE;
end;
UNIQUE index XLS_STAT_PK (ID)
UNIQUE index XLS_STAT_U_KOD (KOD)
UNIQUE index XLS_STAT_U_NAZEV (NAZEV)
