currency

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
currency VARCHAR 10 ''
aqbooksellers.invoiceprice aqbooksellers_ibfk_2 C
aqbooksellers.listprice aqbooksellers_ibfk_1 C
aqorders.currency aqorders_currency N
aqorders.invoice_currency aqorders_invoice_currency N
suggestions.currency Implied Constraint R
symbol VARCHAR 5 √ NULL
isocode VARCHAR 5 √ NULL
timestamp TIMESTAMP 19 current_timestamp()
rate FLOAT 15,5 √ NULL
active BOOLEAN 3 √ NULL
archived BOOLEAN 3 √ 0
p_sep_by_space BOOLEAN 3 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc currency

Relationships

Close relationships within degrees of separation