Table mkt.film.document
A film 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('film.document_id_seq'::regclass)
document_about_film.filmid articles_about_films_film_fkey R
document_about_film.filmid books_about_films_film_fkey R
document_about_film.filmid film_aboutfilm_right_fkey R
document_about_film.filmid document_about_film_film_fkey R
document_about_film.filmid radio_about_film_film_fkey R
document_about_film.filmid document_about_film_film_fkey R
document_about_keyword.documentid film_about_keyword_docid_fkey R
document_about_period.documentid film_about_period_film_fkey R
document_about_subject.documentid film_about_subject_doc_fkey R
document_award_corporate.filmid film_award_corporate_film_fkey R
document_award_document.filmid film_award_film_film_fkey R
document_award_person.filmid film_award_person_film_fkey R
document_by_animal_role.documentid film_by_animal_role_film_fkey R
document_by_corporate_role.documentid film_by_corporate_role_film_fkey R
document_by_corporate_role_premiering.documentid film_by_corporate_roleprem_film_fkey R
document_by_person_role.documentid film_by_person_role_film_fkey R
document_documentcopyinfilmarchive.documentid film_filmcopy_in_filmarchive_film_fkey R
document_filmtype.documentid film_filmtype_film_fkey R
document_formatfilmformat.documentid film_filmformat_film_fkey R
document_genre.documentid film_genre_film_fkey R
document_haspart_sound.documentid film_haspart_sound_film_fkey R
document_historicalperiod.documentid film_historicalpreiod_film_fkey R
document_in_corporate_role.documentid film_in_corporate_role_film_fkey R
document_in_document.documentd film_in_film_film_fkey R
document_in_document.indocumentid film_in_corporate_role_infilm_fkey R
document_in_language.documentid film_in_language_film_fkey R
document_in_person_role.documentid film_in_person_role_film_fkey R
document_permission.documentid film_permission_film_fkey R
document_productionplace.documentid film_productionplace_film_fkey R
document_resource.documentid film_resource R
document_right_corporate.documentid film_right_corporate_film_fkey R
document_right_person.documentid film_right_person_film_fkey R
document_series.documentid film_series_film_fkey R
document_style.documentid film_style_film_fkey R
document_title.documentid film_title_film_fkey R
document_web.documentid film_web_film_fkey R
documentcopy_formatfilmfault.documentid filmcopies_formatfilmfaults_film_fkey R
documentusageincontext.documentid film_concext_doc_fkey R
event_document_production.documentid event_document_production_doc_fkey R
film_document_by_person_role_with_document_title.documentid film_by_person_role_with_film_fkey R
film_document_in_person_role_with_background_person.documentid zfilm_in_person_role_with_bgperson_film_fkey R
film_document_in_person_role_with_bgperson.documentid film_in_person_role_with_backgroundperson_film_fkey R
film_document_in_person_role_without_background_person.documentid film_in_person_role_without_bgperson_film_fkey R
segment.documentid segment_doc_fkey R
segment_note.documentid segment_nore_film_fkey R
zfilm_document_documentcopyindigitalform_filename.filmid film_copy_filename_film_fkey R
zfilm_document_filmmaterialformat.documentid film_filmmaterialformat_film_fkey R
zfilm_document_phase_length.documentid film_phase_length_film_fkey R
A filmek azonosítója.
title_redund varchar 255  √  null Redundáns filmcím, a rekordok (filmek) gyors emberi azonosítását szolgáló mez?.
formatfilmcolorid int4 10  √  null
formatfilmcolor.id film_filmcolor_fkey R
A film színessége (fekete-fehér, színes, kevert).
formatfilmsoundid int4 10  √  null
formatfilmsound.id film_filmsound_fkey R
A film hangossága (néma, hangos).
formatcolortechnicsid int4 10  √  null
formatcolortechnics.id film_colortechnics_fkey R
A filmhez használt színesfilm-technika (pl. Eastman).
formatsoundtechnicsid int4 10  √  null
formatsoundtechnics.id film_soundtechnics_fkey R
A filmben használt hangtechnika.
formatfilmscreenformatid int4 10  √  null
formatfilmscreenformat.id film_filmscreenformat_fkey R
A képerny?formátum típusa.
document_segment_typeid int4 10  √  null Nincs mindig kitöltve, hiányos, tehát redundáns, ellen?rzés után törölhet?.
document_segment_typeid_filmpart int4 10  √  null Nincs mindig kitöltve, hiányos, tehát redundáns, ellen?rzés után törölhet?.
document_segment_typeid_seriespart int4 10  √  null Nincs mindig kitöltve, hiányos, redundáns, ellen?rzés után törölhet?.
document_segment_or_series bool 1  √  false Nincs mindig kitöltve, hiányos, redundáns, ellen?rzés után törölhet?.

Table contained 19,030 rows at Sun Nov 02 21:31 CET 2014

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc document_pkey
formatcolortechnicsid Performance Asc fki_film_colortechnics_fkey
formatfilmcolorid Performance Asc fki_film_filmcolor_fkey
formatfilmscreenformatid Performance Asc fki_film_filmscreenformat_fkey
formatfilmsoundid Performance Asc fki_film_filmsound_fkey
formatsoundtechnicsid Performance Asc fki_film_soundtechnics_fkey

Close relationships  within of separation: