Table mkt.film.segment
A filmszegmens 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.segment_id_seq'::regclass)
document_about_article.segmentid film_article_film_fkey R
document_about_book.segmentid film_book_film_fkey R
document_about_corporate.segmentid film_about_corporate_segm_fkey R
document_about_event.segmentid film_about_event_segm_fkey R
document_about_film.segmentid film_about_film_left_fkey R
document_about_film.segmentid radio_about_film_filmsegm_fkey R
document_about_image.segmentid film_about_image_film_fkey R
document_about_keyword.segmentid film_about_keyword_segmid_fkey R
document_about_location.segmentid film_about_location_segment_fkey R
document_about_periodics.segmentid film_about_periodics_film_fkey R
document_about_person.segmentid film_about_person_segment_fkey R
document_about_sound.segmentid film_about_sound_film_fkey R
document_about_subject.segmentid film_about_subject_segment_fkey R
document_maintopic.segmentid film_maintopic_filmsegment_fkey R
documentpart_extent.segmentid documentpart_extent_segm_fkey R
segment_by_corporate_role.segmentid segment_by_corporate_role_segm_fkey R
segment_by_person_role.segmentid segment_by_person_role_segm_fkey R
segment_description.segmentid segment_description_segs_fkey R
segment_filename.segmentid segment_filename_segm_fkey R
segment_haspart_sound.segmentid segment_haspart_sound_segm_fkey R
segment_in_corporate_role.segmentid segment_in_corporate_role_segm_fkey R
segment_in_dialoguelist.segmentid segment_in_dialoguelist_segm_fkey R
segment_in_document.segmentid segment_in_document_segm_fkey R
segment_in_person_role.segmentid segment_in_person_role_segm_fkey R
segment_in_selectedperson.segmentid segment_in_selectedperson_filmsegment_fkey R
segment_in_selectedperson_feature.segmentid segment_in_selectedperson_feature_filmsegment_fkey R
segment_note.segmentid segment_nore_filmsegment_fkey R
zfilm_document_about_keyword_person.segmentid film_about_keyword_person_film_fkey R
zfilm_document_basicratio.segmentid film_basicratio_film_fkey R
documentid int4 10  √  null
document.id segment_doc_fkey R
A film azonosítója.
segmenttypeid int4 10  √  null
segmenttypefilm.id segment_segmenttype_fkey R
A filmszegmens típusa.
title_hun varchar 100  √  null a filmcímek rendbetétele után törölni lehet ezt a mez?t
title_eng varchar 100  √  null a filmcímek rendbetétele után törölni lehet ezt a mez?t
rank int4 10  √  null A filmszegmens sorrendje a filmhez tartozó szegmensek között.
length varchar 50  √  null A filmszegmens hossza.
ispartofcd bool 1  √  false A filmszegmens szerepel-e vagy sem az adott korszak CD-jén.
framefrom int4 10  √  null A filmszegmens kezd? frame értéke a befoglaló film(részlet)en belül.
frameto int4 10  √  null A filmszegmens záró frame értéke a befoglaló film(részlet)en belül.

Table contained 42,995 rows at Sun Nov 02 21:31 CET 2014

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc segment_pkey
documentid Performance Asc fki_segment_doc_fkey
segmenttypeid Performance Asc fki_segment_segmenttype_fkey

Close relationships  within of separation: