Table mkt.radio.document
A rádióm?sorszámok alapadatai.

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
id serial 10  √  nextval('radio.document_id_seq'::regclass)
document_about_film.documentid radio_about_film_radio_fkey R
document_about_subject.documentid radio_about_subject_radio_fkey R
document_by_person_role.documentid radio_by_person_role_radio_fkey R
series.id Implied Constraint R
rootpath varchar 50  √  null
formatsounddigitalversionid int4 10  √  null
formatsounddigitalversion.id sound_digitalversion_fkey R
filename varchar 50  √  null
title_hun varchar 50  √  null
title_eng varchar 50  √  null
description_hun varchar 255  √  null
description_eng varchar 255  √  null
note_hun varchar 255  √  null
note_eng varchar 255  √  null
length varchar 50  √  null
datecreated date 13  √  null
datecreatedtimeprecisionid int4 10  √  null
timeprecision.id sound_dateprec_fkey R
soundtypeid int4 10  √  null
soundtype.id sound_soundtype_fkey R
iscompleteorpart bool 1  √  false
seriesid int4 10  √  null
series.id sound_series_fkey R

Table contained 2 rows at Sun Nov 02 21:32 CET 2014

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc document_pkey
datecreatedtimeprecisionid Performance Asc fki_sound_dateprec_fkey
formatsounddigitalversionid Performance Asc fki_sound_digitalversion_fkey
seriesid Performance Asc fki_sound_series_fkey
soundtypeid Performance Asc fki_sound_soundtype_fkey

Close relationships  within of separation: