heartbit erd

Tables (15)

Authorization

    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)