SchemaSpy - Table alter.public.mis_acct

Tabella di appoggio per la tenuta dei registri IVA

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column	Type	Size	Nulls	Default
acct_iva_id	int4	10
acct_iva_year	int4	10	√	null
acct_iva_month	int4	10	√	null
sales_pages	int4	10	√	null
purcs_pages	int4	10	√	null
prec_credit_amount	numeric	13,2	√	null
credit_amount	numeric	13,2	√	null
acc_405	numeric	13,2	√	null
available_plafond	numeric	13,2	√	null
internal_used	numeric	13,2	√	null
import_used	numeric	13,2	√	null
is_sales_closed_p	bool	1	√	null
is_purcs_closed_p	bool	1	√	null

Table contained 4 rows at Fri Feb 29 12:05 CET 2008

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
acct_iva_id	Primary key	Asc	mis_acct_iva_pkey
acct_iva_year + acct_iva_month	Must be unique	Asc/Asc	mis_acct_iva_indx	These unique columns are also nullable