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