SchemaSpy - Table frontend.public.operation

Działanie - sekcja A.2

Generated by
SchemaSpy

Legend:

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('operation_id_seq'::regclass)

indicator_description.id_operation	fka3b201cc4434bc24
operation_area_type.id_operation	operation_area_type_operation
operation_field_configuration.id_operation	operation_field_configuration_operation
operation_funding_form.id_operation	operation_funding_form_id_operation_fkey
operation_intervention_category.id_operation	operation_intervention_category_operation
operation_legal_base.id_operation	operation_legal_base_operation
operation_type_of_applicant.id_operation	operation_type_of_applicant_operation
operation_type_of_project.id_operation	operation_type_of_project_operation
project.id_operation	project_operation
suboperation.id_operation	suboperation_operation

Identyfikator

number

varchar

8

√

null

Numer działania

name

varchar

256

√

null

Nazwa działania

active

bool

1

√

true

Aktywny - nieaktywny

id_priority_axis

int4

10

√

null

priority_axis.id

operation_priority_axis

Identyfikator osi priorytetowej

max_requested_level

numeric

19,2

√

null

Maksymalny żądany poziom dofinansowania

Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	operation_pkey
name	Must be unique	Asc	unq_operation_name	This unique column is also nullable
number	Must be unique	Asc	unq_operation_number	This unique column is also nullable