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