heartbit erd
Tables (15)
asset
- asset_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- asset_cash — numeric(18,8)
- asset_canorder — numeric(18,8)
bots
- bot_id — bigint — Primary key — NOT NULL
category
- category_id — bigint — Primary key — NOT NULL
- category_name — varchar(50)
- symbol — varchar(20)
- is_active — boolean
chat
- chatroom_id — bigint — Primary key — NOT NULL
- category_id — bigint — Foreign key → category.category_id — NOT NULL
- member_id — bigint — NOT NULL
- chatroom_time — timestamp
- chatroom_content — varchar(500)
community_data
- community_id — bigint — Primary key — NOT NULL
- title — text
- description — text
- published_at — timestamp
- symbol — varchar(20)
- ups — bigint
- hash_key — text
- is_test — boolean
- sentiment_score — real
- sentiment_label — varchar(20)
- category_id — bigint — NOT NULL
interest
- interest_id — long — Primary key — NOT NULL
- member_id — long — Foreign key → member.member_id — NOT NULL
- category_id — long — Foreign key → category.category_id — NOT NULL
invest
- invest_id — bigint — Primary key — NOT NULL
- invest_count — numeric(18,8)
- invest_price — numeric(18,8)
- trade_id — bigint — NOT NULL
- category_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
market_price
- price_id — bigint — Primary key — NOT NULL
- symbol — varchar(10)
- trade_time — timestamp
- trade_price — numeric(38,8)
- trade_volume — numeric(38,8)
- is_test — boolean
- news_id — bigint — NOT NULL
- community_id — bigint — NOT NULL
member
- member_id — bigint — Primary key — NOT NULL
- member_email — varchar(30)
- member_password — varchar(100)
- member_nickname — varchar(20)
- member_role — boolean
news_data
- news_id — bigint — Primary key — NOT NULL
- title — text
- description — text
- published_at — timestamp
- symbol — varchar(20)
- hash_key — text
- sentiment_score — real
- sentiment_label — varchar(20)
- is_test — boolean
- category_id — bigint — NOT NULL
notification
- notification_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- notification_content — varchar(200)
- notification_type — varchar(50)
- notification_is_read — boolean
- created_at — timestamp
orders
- orders_id — bigint — Primary key — NOT NULL
- orders_price — numeric(18,8)
- orders_count — numeric(18,8)
- orders_time — timestamp
- orders_type — varchar(10)
- orders_status — varchar(10)
- orders_remaining_count — numeric(18,8)
- member_id — bigint — NOT NULL
- category_id — bigint — NOT NULL
- bot_id — bigint — NOT NULL
sentiment_result
- result_id — bigint — Primary key — NOT NULL
- total_score — DEFAULT
- total_label — varchar(10)
- news_result — real
- community_result — real
- full_report — text
- summary — VARCHAR(255)
- rsi — real
- created_at — TIMESTAMP
- category_id — bigint — NOT NULL
trade
- trade_id — bigint — Primary key — NOT NULL
- trade_time — timestamp
- trade_price — numeric(18,8)
- trade_count — numeric(18,8)
- trade_buy_id — bigint
- trade_sell_id — bigint
- trade_close — numeric(18,8)
- orders_id — bigint — NOT NULL
- taker_type — varchar(10)