| 1.6. Tabulka "IFC_PROPERTY" | ||
|---|---|---|
 | Kapitola 1. Tabulky |  |
| 1.6. Tabulka "IFC_PROPERTY" | ||
|---|---|---|
| | Kapitola 1. Tabulky | |
|
|
| název sloupce | typ | výchozí | omezení |
|---|---|---|---|
| ID | NUMBER ( 22 ) | ||
| KDO | VARCHAR2 ( 120 ) | NOT NULL | |
| KDY | DATE ( ) | NOT NULL | |
| IFDGUID | VARCHAR2 ( 128 ) | IFC_PROPERT... | |
| VISIBLE | VARCHAR2 ( 20 ) | null | |
| NAME | VARCHAR2 ( 400 ) | IFC_PROPERT... | |
| NAME_CZ | VARCHAR2 ( 400 ) | IFC_PROPERT... | |
| DEFINITION | VARCHAR2 ( 4000 ) | ||
| DEFINITION_CZ | VARCHAR2 ( 4000 ) | ||
| ISO | VARCHAR2 ( 400 ) | ||
| IS_REF | CHAR ( 4 ) | 'N' | IFC_PROPERT... , NOT NULL |
| IS_ENUM | CHAR ( 4 ) | 'N' | IFC_PROPERT... , NOT NULL |
| IS_BOUNDED | CHAR ( 4 ) | 'N' | IFC_PROPERT... , NOT NULL |
| DATATYPE | VARCHAR2 ( 200 ) | ||
| DATAUNIT | VARCHAR2 ( 80 ) | ||
| LINK_TEXT | VARCHAR2 ( 800 ) | ||
| LINK_URL | VARCHAR2 ( 800 ) | ||
| IFCTYPE | VARCHAR2 ( 200 ) |
Ověření IFC_PROPERTY_CHK_IS_BOUNDED: is_Bounded in ('Y','N')
Ověření IFC_PROPERTY_CHK_IS_ENUM: is_Enum in ('Y','N')
Ověření IFC_PROPERTY_CHK_IS_REF: is_Ref in ('Y','N')
Ověření IFC_PROPERTY_CHK_NAME_NAME_CZ: Name is not null or Name_CZ is not null
|
Trigger IFC_PROPERTY_ID
|
| BEFORE INSERT ON IFC_PROPERTY |
| BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD |
begin :NEW.ID := coalesce(:NEW.ID,nextid); end;
|
Trigger IFC_PROPERTY_KDO
|
| BEFORE INSERT OR UPDATE ON IFC_PROPERTY |
| BEFORE EACH ROW, REFERENCING NEW AS NEW OLD AS OLD |
begin :NEW.KDO := NVL(:NEW.KDO,USER); :NEW.KDY := SYSDATE; end;
index IFC_PROPERTY_NAME_CZ_VIS (NAME_CZ, VISIBLE)
index IFC_PROPERTY_NAME_VIS (NAME, VISIBLE)
UNIQUE index IFC_PROPERTY_PK (ID)
UNIQUE index IFC_PROPERTY_U_IFDGUID (IFDGUID)
FUNCTION-BASED NORMAL UNIQUE index IFC_PROPERTY_U_VIS_NVLNAME (VISIBLE, SYS_NC00019$)
FUNCTION-BASED NORMAL UNIQUE index IFC_PROPERTY_U_VIS_NVLNAME_CZ (VISIBLE, SYS_NC00020$)
| |  | |
| 1.5. Tabulka "IFC_CLASS" |  | 1.7. Tabulka "IFC_PROPERTY_SET" |
