'''
create df schema for db
'''
PORTFOLIO_TABLE = 'portfolio_profile'
PORTFOLIO_TABLE_SCHEMA = {
    'ticker': str,
    'shares': int,
    'date': 'datetime64[ns]',
    'sector': str,
    'aggregate_sector': str,
    'display_name': str,
    'name': str,
    'cash': float,
    'weight': float,
    'ave_price': float
}
STOCKS_DETAILS_TABLE = 'all_stock_info'
STOCKS_DETAILS_TABLE_SCHEMA = {
    'display_name': str,
    'name': str,
    'start_date': 'datetime64[ns]',
    'end_date': 'datetime64[ns]',
    'type': str,
    'ticker': str,
    'sector': str,
    'aggregate_sector': str
}