testsql_comments
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
account_debit_types
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
code
VARCHAR
80
null
account_debit_types_branches
.debit_type_code
account_debit_types_branches_ibfk_1
C
accountlines
.debit_type_code
accountlines_ibfk_debit_type
R
description
VARCHAR
200
√
null
can_be_added_manually
TINYINT
3
1
default_amount
DECIMAL
28,6
√
null
is_system
BIT
0
0
archived
BIT
0
0
boolean flag to denote if this till is archived or not
Showing 1 to 6 of 6 entries
Table contained
0
rows
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
code
Showing 1 to 1 of 1 entries
Relationships
Close relationships within degrees of separation
One
Two degrees