hellodb.io
MODELS · 18
/
27 refs · 150 fields
user
9
PK
id
uuid
email
varchar
full_name
varchar
country_code
varchar
kyc_status
enum
risk_profile
enum
FK
referred_by_id
uuid?
created_at
timestamp
deleted_at
timestamp?
account
9
PK
id
uuid
FK
user_id
uuid
account_number
varchar
account_type
enum
base_currency
varchar
cash_balance
decimal
buying_power
decimal
status
enum
opened_at
timestamp
margin_account
9
PK
id
uuid
FK
account_id
uuid
initial_margin
decimal
maintenance_margin
decimal
margin_used
decimal
margin_available
decimal
leverage_ratio
decimal
status
enum
updated_at
timestamp
margin_call
9
PK
id
uuid
FK
margin_account_id
uuid
FK
account_id
uuid
required_amount
decimal
deficit_amount
decimal
status
enum
due_at
timestamp
resolved_at
timestamp?
created_at
timestamp
exchange
8
PK
id
uuid
code
varchar
name
varchar
country_code
varchar
timezone
varchar
trading_hours
jsonb
currency_code
varchar
is_active
boolean
instrument
9
PK
id
uuid
FK
exchange_id
uuid
symbol
varchar
name
varchar
instrument_type
enum
currency_code
varchar
lot_size
int
tick_size
decimal
status
enum
market_data_tick
7
PK
id
bigint
FK
instrument_id
uuid
last_price
decimal
bid_price
decimal
ask_price
decimal
volume
bigint
recorded_at
timestamp
corporate_action
9
PK
id
uuid
FK
instrument_id
uuid
action_type
enum
ratio
decimal?
cash_amount
decimal?
ex_date
date
record_date
date
pay_date
date?
status
enum
portfolio
6
PK
id
uuid
FK
account_id
uuid
name
varchar
strategy
enum
is_default
boolean
created_at
timestamp
holding
8
PK
id
uuid
FK
portfolio_id
uuid
FK
instrument_id
uuid
quantity
decimal
average_cost
decimal
realized_pnl
decimal
unrealized_pnl
decimal
updated_at
timestamp
position
9
PK
id
uuid
FK
account_id
uuid
FK
instrument_id
uuid
side
enum
quantity
decimal
average_entry_price
decimal
is_open
boolean
opened_at
timestamp
closed_at
timestamp?
watchlist
6
PK
id
uuid
FK
user_id
uuid
name
varchar
is_public
boolean
display_order
int
created_at
timestamp
watchlist_item
6
PK
id
uuid
FK
watchlist_id
uuid
FK
instrument_id
uuid
display_order
int
alert_price
decimal?
added_at
timestamp
order
11
PK
id
uuid
FK
account_id
uuid
FK
instrument_id
uuid
FK
parent_order_id
uuid?
side
enum
order_type
enum
time_in_force
enum
quantity
decimal
limit_price
decimal?
status
enum
placed_at
timestamp
trade
8
PK
id
uuid
FK
instrument_id
uuid
FK
exchange_id
uuid
execution_price
decimal
quantity
decimal
exchange_trade_ref
varchar
status
enum
executed_at
timestamp
order_fill
9
PK
id
uuid
FK
order_id
uuid
FK
trade_id
uuid
quantity
decimal
fill_price
decimal
commission
decimal
exchange_fee
decimal
liquidity_flag
enum
filled_at
timestamp
settlement
9
PK
id
uuid
FK
account_id
uuid
FK
order_fill_id
uuid
settlement_date
date
gross_amount
decimal
fee_amount
decimal
net_amount
decimal
status
enum
settled_at
timestamp?
transaction
9
PK
id
bigint
FK
account_id
uuid
FK
settlement_id
uuid?
transaction_type
enum
amount
decimal
balance_after
decimal
currency_code
varchar
description
varchar
occurred_at
timestamp
96%
Opening Stock Trading