Table testsql_comments.aqbudgets_planning 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
plan_id int 10  √ 
budget_id int 10
aqbudgets.budget_id aqbudgets_planning_ifbk_1 C
budget_period_id int 10
aqbudgetperiods.budget_period_id Implied Constraint R
estimated_amount decimal 28,6  √  null
authcat varchar 30
authvalue varchar 30
display bit 0  √  1

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
plan_id Primary key Asc PRIMARY
budget_id Performance Asc aqbudgets_planning_ifbk_1
budget_period_id Performance Asc budget_period_id

Close relationships  within of separation: