Welcome Guest, you are in: <root> • Login

Page History: PM PRINT_MEDIA (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:20

wikibot ¶

Table

PM.PRINT_MEDIA

Columns ¶

Column	Data Type	Nullable	Default	Description
PRODUCT_ID	NUMBER(6, 0)	not null
AD_ID	NUMBER(6, 0)	not null
AD_COMPOSITE	BLOB(4000)	null
AD_SOURCETEXT	CLOB(4000)	null
AD_FINALTEXT	CLOB(4000)	null
AD_FLTEXTN	NCLOB(4000)	null
AD_TEXTDOCS_NTAB	PM.TEXTDOC_TAB	null
AD_PHOTO	BLOB(4000)	null
AD_GRAPHIC	BFILE(530)	null
AD_HEADER	PM.ADHEADER_TYP	null

Primary Key ¶

Primary Key	Columns
PRINTMEDIA_PK	PRODUCT_ID, AD_ID

Indexes ¶

Index	Type	Columns
SYS_C005057	Unique	AD_TEXTDOCS_NTAB

Foreign Keys ¶

Relation	Column	Referenced Column
OE.PRODUCT_INFORMATION	PRODUCT_ID	PRODUCT_ID

References ¶

Dependency Type	Object Type	Referenced Object
Data Type	Type	PM.ADHEADER_TYP
Data Type	Type	PM.TEXTDOC_TAB