Table mkt.corporate.corporate_pr_material
A testületek logói, videói, szlogenjei, indulói, pr-anyagai. Fölösleges itt és így. Ha egyáltalán kellenek, akkor az itteni adatokat át kéne tenni a megfelel? adatbázisába (pl. a logókat az image_about_corporate táblába).

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
corporateid int4 10  √  null
corporate.id corporates_pr_materials_corp_fkey R
text varchar 150  √  null
rootpath varchar 50  √  null
filename varchar 20  √  null
type int4 10  √  null
datefrom date 13  √  null
datefromtimeprecisionid int4 10  √  null
timeprecision.id corporate_pr_material_fromprec_fkey R
dateto date 13  √  null
datetotimeprecisionid int4 10  √  null
timeprecision.id corporate_pr_material_toprec_fkey R

Table contained 12 rows at Sun Nov 02 21:31 CET 2014

Indexes:
Column(s) Type Sort Constraint Name
datefromtimeprecisionid Performance Asc fki_corporate_pr_material_fromprec_fkey
datetotimeprecisionid Performance Asc fki_corporate_pr_material_toprec_fkey
corporateid Performance Asc fki_corporates_pr_materials_corp_fkey

Close relationships  within of separation: