몽키트레이더스

테이블 (19)

Accounts

  • id — UUID
  • user_id — UUID — NOT NULL
  • balance — DECIMAL(20, 2)
  • can_reset_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

Assets

  • id — SERIAL
  • asset_type — asset_type_enum — NOT NULL
  • item_code — VARCHAR(50) — NOT NULL
  • item_name — VARCHAR(255) — NOT NULL
  • market — VARCHAR(100)
  • sector — VARCHAR(100)
  • country — VARCHAR(100)
  • currency — VARCHAR(10)
  • symbol — VARCHAR(20)
  • exchange — VARCHAR(100)
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

Coins

  • coin_id — SERIAL
  • item_code — VARCHAR(50) — NOT NULL
  • item_name — VARCHAR(255) — NOT NULL
  • symbol — VARCHAR(20)
  • base_currency — VARCHAR(10)
  • exchange — VARCHAR(100)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ

Holdings

  • id — UUID
  • user_id — UUID — NOT NULL
  • item_code — VARCHAR(50) — NOT NULL
  • item_name — VARCHAR(255) — NOT NULL
  • quantity — DECIMAL(20, 6) — NOT NULL
  • avg_price — DECIMAL(20, 2) — NOT NULL
  • last_updated_at — TIMESTAMPTZ
  • fee — DECIMAL(20, 2)
  • latest_exchange_rate — DECIMAL(20, 6)
  • latest_price — DECIMAL(20, 2)

InfluencerAccounts

  • id — SERIAL
  • person_id — INTEGER — NOT NULL
  • platform_id — INTEGER — NOT NULL
  • handle — VARCHAR(100) — NOT NULL
  • url — VARCHAR(2048)
  • created_at — TIMESTAMPTZ

InfluencerKeywords

  • id — SERIAL
  • person_id — INTEGER — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMPTZ

Influencers

  • person_id — SERIAL
  • name — VARCHAR(255) — NOT NULL
  • profile_image_url — VARCHAR(2048)
  • description — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ

NewsArticles

  • article_id — SERIAL
  • title — VARCHAR(500) — NOT NULL
  • content — TEXT — NOT NULL
  • source — VARCHAR(100)
  • url — VARCHAR(2048) — NOT NULL
  • published_at — TIMESTAMPTZ
  • view_count — INTEGER
  • author_name — VARCHAR(255)
  • category — VARCHAR(100)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ

NewsKeywords

  • id — SERIAL
  • news_id — INTEGER — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMPTZ

Oauth

  • id — UUID
  • user_id — UUID — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • refresh_token — TEXT
  • expires_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ

PersonNewsMappings

  • id — SERIAL
  • person_id — INTEGER — NOT NULL
  • article_id — INTEGER — NOT NULL
  • relation_type — VARCHAR(20)
  • score — NUMERIC(3, 2)
  • created_at — TIMESTAMPTZ
  • UNIQUE(person_id, — article_id)

Platforms

  • id — SERIAL
  • code — VARCHAR(50) — NOT NULL
  • name_ko — VARCHAR(50) — NOT NULL
  • name_en — VARCHAR(50) — NOT NULL

PostImages

  • id — UUID
  • post_id — UUID — NOT NULL
  • image_url — TEXT — NOT NULL
  • original_name — VARCHAR(255)
  • file_size — BIGINT
  • mime_type — VARCHAR(100)
  • created_at — TIMESTAMPTZ

PostLikes

  • id — UUID
  • post_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • created_at — TIMESTAMPTZ

Posts

  • id — UUID
  • user_id — UUID — NOT NULL
  • target_type — post_target_type_enum — NOT NULL
  • target_id — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • like_count — INT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ

SocialPosts

  • id — BIGINT
  • person_id — INTEGER — NOT NULL
  • platform_id — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • posted_at — TIMESTAMPTZ
  • url — VARCHAR(2048)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ

Stocks

  • stock_id — SERIAL
  • item_code — VARCHAR(50) — NOT NULL
  • item_name — VARCHAR(255) — NOT NULL
  • market — VARCHAR(100)
  • currency — VARCHAR(10)
  • sector — VARCHAR(100)
  • country — VARCHAR(100)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ

Transactions

  • id — UUID
  • user_id — UUID — NOT NULL
  • trade_type — trade_type_enum — NOT NULL
  • asset_type — asset_type_enum — NOT NULL
  • item_code — VARCHAR(50) — NOT NULL
  • amount — DECIMAL(20, 6) — NOT NULL
  • price — DECIMAL(20, 2) — NOT NULL
  • fee — DECIMAL(20, 2)
  • exchange_rate — DECIMAL(20, 6)
  • created_at — TIMESTAMPTZ

Users

  • id — UUID
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deleted_at — TIMESTAMPTZ