bigant

Tables (11)

Board (Untitled9)

  • PK (id) — Primary key — NOT NULL
  • FK (user_id) — Long — Foreign key → User.Key — NOT NULL
  • Field (content)
  • Field2 (picture_url)
  • Field3 (created_at)
  • Field4 (updated_at)
  • Field (like_cnt)
  • Field (is_deleted)

BoardTreePath (Untitled10)

  • Key (id) — Primary key — NOT NULL
  • FK (descendant) — Foreign key → Board.PK — NOT NULL
  • PK (ancestor) — Foreign key → Board.PK — NOT NULL

KrStockPrice (Untitled5)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (stck_bsop_date) — String
  • Field2 (stck_clpr) — String
  • Field3 (stck_oprc) — String
  • Field4 (stck_hgpr) — String
  • Field5 (stck_lwpr) — String
  • Field (acml_vol) — String
  • Field (acml_tr_pbmn) — String
  • Field (flng_cls_code) — String
  • Field (prtt_rate) — String
  • Field (mod_yn) — String
  • Field (prdy_vrss_sign) — String
  • Field (prdy_vrss) — String
  • Field (revl_issu_reas) — String
  • Key (kr_stock_id) — Long — Foreign key → kr_stock.Key — NOT NULL

Portfolio (Untitled6)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String

PortfolioSearchHistory (Untitled8)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (start_date) — Date
  • Field (end_date) — Date
  • Field (initial_amount) — String
  • Field (is_rebalanced) — Boolean
  • Key (portfolio_id) — Long — Foreign key → Portfolio.Key — NOT NULL

PortfolioStock (Untitled7)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (portion) — Double
  • Key (stock_id) — Long — Foreign key → stock.Key — NOT NULL
  • Key (portfolio_id) — Long — Foreign key → Portfolio.Key — NOT NULL

UsStockPrice (Untitled11)

  • Key (id) — Primary key — NOT NULL
  • Key (us_stock_id) — Long — Foreign key → us_stock.Key — NOT NULL
  • Field (business_date)
  • Field2 (highest_price)
  • Field3 (lowest_price)
  • Field4 (open_price)
  • Field5 (close_price)
  • Field6 (accumulated_volume)

User (Untitled4)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (nickname) — String
  • Field (name) — String
  • Field (address) — String
  • Field (phone_number) — String
  • Field (email) — String
  • Field (oauth_id) — String
  • Field (profile)

kr_stock (Untitled)

  • Key (id) — Long — Primary key — NOT NULL
  • Field3 (isin_code) — String

stock (Untitled2)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field (symbol) — String
  • Field (type) — String
  • Field (is_delisting) — Boolean
  • Field (price_updated_at) — String
  • Key (kr_stock_id) — Long — Foreign key → kr_stock.Key — NOT NULL
  • Key (us_stock_id) — Long — Foreign key → us_stock.Key — NOT NULL

us_stock (Untitled3)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (country) — String