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