acq.fiscal_year

↑ acq schema

Cascading Deletes: Deleting rows from this table will cascade to: acq.fiscal_calendar.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: fiscal_year_calendar_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.fiscal_year_id_seq'::regclass)

calendar FK

integer

No

→ acq.fiscal_calendar(id)

year

integer

No

year_begin

timestamp with time zone

No

year_end

timestamp with time zone

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

calendar

acq.fiscal_calendar(id)

CASCADE

NO ACTION

DEFERRED

fiscal_year_calendar_fkey

Unique Constraints

  • acq_fy_logical_key: (calendar, year)

  • acq_fy_physical_key: (calendar, year_begin)

Indexes

Index Method Definition

fiscal_year_pkey PK

btree

CREATE UNIQUE INDEX fiscal_year_pkey ON acq.fiscal_year USING btree (id)

acq_fy_logical_key UNIQUE

btree

CREATE UNIQUE INDEX acq_fy_logical_key ON acq.fiscal_year USING btree (calendar, year)

acq_fy_physical_key UNIQUE

btree

CREATE UNIQUE INDEX acq_fy_physical_key ON acq.fiscal_year USING btree (calendar, year_begin)
Previous
Next