teest

Tables (5)

Dividend (Untitled3)

  • dividend_id (Key) — bigint — Primary key — NOT NULL
  • stock_id (Field) — varchar
  • sector_id (Field2) — bigint
  • record_date (Field3) — date
  • cash_dividend (Field4) — decimal
  • dividend_rate (Field5) — decimal
  • dividend_date (Field6) — date
  • dividend_flag (Field7) — boolean

Execution (Untitled4)

  • execution_id (Key) — bigint — Primary key — NOT NULL
  • user_id (Field) — bigint
  • stock_id (Field2) — varchar
  • sector_id (Field3) — bigint
  • date (Field4) — date
  • is_buy (Field5) — boolean
  • quantity (Field6) — int
  • price (Field7) — bigint
  • total_price (Field8) — bigint

User_stock (Untitled5)

  • user_stock_id (Key) — bigint — Primary key — NOT NULL
  • user_id (Field) — bigint
  • stock_id (Field2) — varchar
  • sector_id (Field3) — bigint
  • holding_quantity (Field4) — int
  • avg_price (Field5) — bigint
  • total_value (Field6) — bigint

notification_event (알림)

  • 알림ID (notification_id) — bigint — Primary key — NOT NULL
  • 사용자ID (user_id2) — varchar(60) — Foreign key → ranking_top10_v2.사용자ID — NOT NULL
  • 사용자ID (user_id) — varchar(60)
  • 알림유형 (type) — enum
  • 제목 (title) — varchar(200)
  • 내용 (message) — text
  • 받아오는값 (data) — json
  • 중복방지키 (dedup_key) — varchar(128)
  • 생성날짜 (created_at) — timestamp
  • 알림읽은날짜 (read_at) — timestamp

ranking_top10_v2 (랭킹)

  • 사용자ID (user_id) — varchar(60) — Primary key — NOT NULL
  • 등수 (rank_no) — int
  • 수익률 (profit_rate) — decimal(12,6)
  • top10 포함 여부 (in_top10) — int
  • 마지막 진입 시각 (last_seen_at) — datetime
  • 제외 시각 (dropped_at) — datetime
  • 갱신 시각 (updated_at) — timestamp