coinbuying

Tables (9)

asset - disable (asset)

  • asset_id — Int — Primary key — NOT NULL
  • asset_type — Int
  • amount — Decimal
  • price — Decimal
  • exchange — Int
  • last_price — Decimal
  • user_id — Int
  • market — varchar

asset_history (CopyOfcalculate_asset)

  • ca_id — Int — Primary key — NOT NULL
  • coin_id (코인ID) — Int
  • market (거래소) — Int
  • dttm (기준시각) — timestamp
  • volume (보유량) — Decimal
  • price (단가) — Decimal

calculate_asset - disable (calculate_asset)

  • ca_id — Int — Primary key — NOT NULL
  • total (총자산) — Decimal
  • rate (수익률) — Decimal
  • user_id — Int
  • dttm (기준시각) — timestamp

coin-price (CopyOfcoin_price2)

  • ticker (코인ID) — char — Primary key — NOT NULL
  • market (거래소) — varchar — Primary key — NOT NULL
  • price — Decimal
  • dttm (기준시각) — timestamp

coin_price - disable (coin_price)

  • coin_id — Int — Primary key — NOT NULL
  • name — varchar
  • price — Decimal
  • volume — Decimal
  • timeframe — Int
  • save_kst — Datetime
  • market — varchar
  • date — date

coin_price_history (CopyOfcoin_price)

  • index (Key) — int — Primary key — NOT NULL
  • coin_id (코인ID) — Int — NOT NULL
  • market (거래소) — varchar — NOT NULL
  • dttm (기준시각) — timestamp — NOT NULL
  • intervals (차트간격) — Int — NOT NULL
  • start_price (시가) — Decimal
  • end_price (종가) — Decimal
  • min_price (최소값) — Decimal
  • max_price (최대값) — Decimal

file

  • file_id (아이디) — Int — Primary key — NOT NULL
  • use_type (사용타입) — varchar
  • file_name (파일이름) — varchar
  • extention (확장자) — varchar
  • path (경로) — varchar
  • size (용량) — double
  • save_name (저장명) — varchar

post

  • post_id — Int — Primary key — NOT NULL
  • board_type — varchar
  • post_type — varchar
  • titlet (title) — varchar
  • content — varchar(2000)
  • file_yn — varchar
  • create_dt (생성일) — timestamp
  • update_dt (수정일) — timestamp
  • user_id (작성자) — Int

user

  • user_id — Int — Primary key — NOT NULL
  • name — varchar
  • email — varchar
  • password — varchar
  • authority — Int