Tables


SchemaSpy Analysis of tradedb

Generated on Tue Jan 11 21:21 IST 2022

XML Representation
Insertion Order Deletion Order
TABLES 16
VIEWS 0
COLUMNS 125
Constraints 10
Anomalies 6
Routines 12

Database Properties

Database Type: PostgreSQL - 11.13

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
stock_ohlc 0 1 11 43679 Table
accounts 2 0 7 5543 Table
gain_loss 0 2 6 1943 Table
account_transactions 0 1 6 232224 Table
trade_analysis 0 2 10 1571 Table
ticker_data 6 0 11 7323 Table
algo_run 5 1 10 17369 Table
trade_plan_execution_audit 0 1 5 0 Table
new_trades 0 2 13 322951 Table
trade_plan 1 1 8 8 Table
portfolio_batch_ids 0 1 3 4528 Table
trending_tickers 0 1 5 208939 Table
trades 0 2 13 2603 Table
optimizer_run 0 0 5 348 Table
keystore 0 0 3 2768 Table
portfolio 2 1 9 4076 Table