Table mkt.concept.role
A tevékenységek, foglalkozási szerepek felsorolása.

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('concept.role_id_seq'::regclass)
corporate_profile.roleid corporate_profile_role_fkey R
corporate_role.roleid corporates_profiles_role_fkey R
document_by_animal_role.roleid film_by_animal_role_role_fkey R
document_by_corporate_role.roleid articles_by_corporates_role_fkey R
document_by_corporate_role.roleid books_by_corporates_role_fkey R
document_by_corporate_role.roleid film_by_corporate_role_role_fkey R
document_by_corporate_role.roleid document_by_corporate_role_fkey R
document_by_corporate_role.roleid document_by_corporate_role_role_fkey R
document_by_corporate_role.roleid document_by_corporate_role_role_fkey R
document_by_person_role.roleid articles_by_persons_role_fkey R
document_by_person_role.roleid books_by_persons_role_fkey R
document_by_person_role.givenroleid film_by_person_role_givenrole_fkey R
document_by_person_role.roleid film_by_person_role_role_fkey R
document_by_person_role.roleid document_by_person_role_fkey R
document_by_person_role.roleid document_by_person_role_role_fkey R
document_by_person_role.roleid radio_by_person_role_role_fkey R
document_by_person_role.roleid document_by_person_role_role_fkey R
document_in_corporate_role.roleid film_in_corporate_role_role_fkey R
document_in_corporate_role.roleid document_in_corporate_role_role_fkey R
document_in_person_role.roleid articles_in_persons_role_fkey R
document_in_person_role.roleid film_in_person_role_role_fkey R
document_in_person_role.roleid document_in_person_role_role_fkey R
document_in_person_role_bgperson_bgrole.bg_roleid film_in_bgperson_bgrole_role_fkey R
film_document_by_person_role_with_document_title.roleid film_by_person_role_with_role_fkey R
film_document_in_person_role_with_background_person.bg_roleid zfilm_in_person_role_with_bgperson_bgrole_fkey R
film_document_in_person_role_with_background_person.roleid zfilm_in_person_role_with_bgperson_role_fkey R
film_document_in_person_role_with_bgperson.bg_roleid film_in_person_role_with_backgroundperson_bgrole_fkey R
film_document_in_person_role_with_bgperson.roleid film_in_person_role_with_backgroundperson_role_fkey R
film_document_in_person_role_without_background_person.roleid film_in_person_role_without_bgperson_role_fkey R
segment_by_corporate_role.roleid segment_by_corporate_role_role_fkey R
segment_by_person_role.roleid segment_by_person_role_role_fkey R
segment_in_corporate_role.roleid segment_in_corporate_role_role_fkey R
segment_in_person_role.roleid segment_in_person_role_role_fkey R
series_by_corporate_role.roleid series_by_corporate_role_role_fkey R
series_by_person_role.roleid series_by_person_role_role_fkey R
name_hun varchar 50  √  null
name_eng varchar 50  √  null
rank int4 10  √  null
superroleid int4 10  √  null
rolegroupid int4 10  √  null
profileornot bool 1  √  false

Table contained 298 rows at Sun Nov 02 21:30 CET 2014

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc role_pkey

Close relationships  within of separation: