Table openpetra_trunk.public.p_international_postal_type
Post office mailing zone classification

 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
p_internat_postal_type_code_c varchar 16
p_country.p_internat_postal_type_code_c p_country_fk1 R
p_description_c varchar 64
p_deletable_l bool 1 true This defines if the international postal type code can be deleted. This can only be updated by the system manager. At the risk of serious operational integrity. Default to Yes
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_international_postal_type_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_international_postal_type_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 14 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
p_internat_postal_type_code_c Primary key Asc p_international_postal_type_pk
s_created_by_c Performance Asc inx_ational_postal_type_fkcr_key1
s_modified_by_c Performance Asc inx_ational_postal_type_fkmd_key2
p_internat_postal_type_code_c Must be unique Asc inx_international_postal_type_pk0

Close relationships  within of separation: