WebSQL Reports
Table details
TABLE_NAME like WPG% and TABLE_TYPE like TABLE 28.08.2002 11:36
|
OWNER
|
|
|
WPG
|
|
TABLE_NAME
|
|
|
WPG_ITEM
|
|
TABLE_TYPE
|
|
|
TABLE
|
|
COMMENTS
|
|
|
Definition der Textbausteine (HTML-Sequenzen). Parameter können über $1..$5 angegeben werden.
|
|
|
|
|
|
|
ITM_COMMENT
|
VARCHAR2(1000)
|
|
Beschreibung und Kommentar.
|
|
ITM_DATE
|
DATE
|
NOT NULL
|
Datum der letzten Mutation.
|
|
ITM_ID
|
NUMBER(22)
|
NOT NULL
|
Eindeutige Item-Id.
|
|
ITM_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Bezeichnung des Items.
|
|
ITM_PROMPT1
|
VARCHAR2(30)
|
|
|
|
ITM_PROMPT2
|
VARCHAR2(30)
|
|
|
|
ITM_PROMPT3
|
VARCHAR2(30)
|
|
|
|
ITM_PROMPT4
|
VARCHAR2(30)
|
|
|
|
ITM_PROMPT5
|
VARCHAR2(30)
|
|
|
|
ITM_PROMPT6
|
VARCHAR2(30)
|
|
|
|
ITM_PROMPT7
|
VARCHAR2(30)
|
|
|
|
ITM_PROMPT8
|
VARCHAR2(30)
|
|
|
|
ITM_TEXT
|
VARCHAR2(2000)
|
NOT NULL
|
HTML-Text des Items.
|
|
ITM_USER
|
VARCHAR2(30)
|
NOT NULL
|
User der letzten Mutation.
|
|
|
|
|
|
|
WPG
|
WLT
|
ALTER
|
NO
|
|
WPG
|
WLT
|
DELETE
|
NO
|
|
WPG
|
WLT
|
INDEX
|
NO
|
|
WPG
|
WLT
|
INSERT
|
NO
|
|
WPG
|
WLT
|
SELECT
|
NO
|
|
WPG
|
WLT
|
UPDATE
|
NO
|
|
WPG
|
WLT
|
REFERENCES
|
NO
|
|
|
WPG
|
|
|
WPG_MANDANT
|
|
|
TABLE
|
|
|
Projekt oder Mandant Definitionen.
|
|
|
|
|
|
|
MAN_ID
|
NUMBER(22)
|
NOT NULL
|
Eindeutige Mandant-Id.
|
|
MAN_NAME
|
VARCHAR2(80)
|
NOT NULL
|
Bezeichnung des Mandanten.
|
|
MAN_ROOT
|
VARCHAR2(132)
|
|
Root-Directory fr die File-Generierung.
|
|
|
|
|
|
|
WPG
|
WLT
|
ALTER
|
NO
|
|
WPG
|
WLT
|
DELETE
|
NO
|
|
WPG
|
WLT
|
INDEX
|
NO
|
|
WPG
|
WLT
|
INSERT
|
NO
|
|
WPG
|
WLT
|
SELECT
|
NO
|
|
WPG
|
WLT
|
UPDATE
|
NO
|
|
WPG
|
WLT
|
REFERENCES
|
NO
|
|
|
WPG
|
|
|
WPG_PAGE
|
|
|
TABLE
|
|
|
Daten zu einer einzelnen Webpage.
|
|
|
|
|
|
|
PAG_DATE
|
DATE
|
NOT NULL
|
Date der letzten Mutation.
|
|
PAG_ID
|
NUMBER(22)
|
NOT NULL
|
Eindeute Page-Id.
|
|
PAG_MAN_ID
|
NUMBER(22)
|
|
Join auf WPG_MANDANT.
|
|
PAG_NAME
|
VARCHAR2(60)
|
NOT NULL
|
Filename der Seite (ohne Pfad).
|
|
PAG_USER
|
VARCHAR2(30)
|
NOT NULL
|
User der letzten Mutation.
|
|
|
|
|
|
|
WPG
|
WLT
|
ALTER
|
NO
|
|
WPG
|
WLT
|
DELETE
|
NO
|
|
WPG
|
WLT
|
INDEX
|
NO
|
|
WPG
|
WLT
|
INSERT
|
NO
|
|
WPG
|
WLT
|
SELECT
|
NO
|
|
WPG
|
WLT
|
UPDATE
|
NO
|
|
WPG
|
WLT
|
REFERENCES
|
NO
|
|
|
WPG
|
|
|
WPG_PAGITM
|
|
|
TABLE
|
|
|
Einer Seite zugeordnete Items sowie ihre variablen Parameter.
|
|
|
|
|
|
|
PGI_ITM_ID
|
NUMBER(22)
|
NOT NULL
|
Join auf WPG_ITEM.
|
|
PGI_ORDER
|
NUMBER(22)
|
NOT NULL
|
Reihenfolge der Items.
|
|
PGI_P1
|
VARCHAR2(4000)
|
|
|
|
PGI_P2
|
VARCHAR2(2000)
|
|
|
|
PGI_P3
|
VARCHAR2(2000)
|
|
|
|
PGI_P4
|
VARCHAR2(2000)
|
|
|
|
PGI_P5
|
VARCHAR2(2000)
|
|
|
|
PGI_P6
|
VARCHAR2(2000)
|
|
|
|
PGI_P7
|
VARCHAR2(2000)
|
|
|
|
PGI_P8
|
VARCHAR2(2000)
|
|
|
|
PGI_PAG_ID
|
NUMBER(22)
|
NOT NULL
|
Join auf WPG_PAGE.
|
|
|
|
|
|
|
WPG
|
WLT
|
ALTER
|
NO
|
|
WPG
|
WLT
|
DELETE
|
NO
|
|
WPG
|
WLT
|
INDEX
|
NO
|
|
WPG
|
WLT
|
INSERT
|
NO
|
|
WPG
|
WLT
|
SELECT
|
NO
|
|
WPG
|
WLT
|
UPDATE
|
NO
|
|
WPG
|
WLT
|
REFERENCES
|
NO
|
4 master row(s) retrieved.
Copyright ©
- all rights reserved.