mertic

Tables (6)

alarm (Untitled2)

  • alarm_id (Key) — int — Primary key — NOT NULL
  • Field
  • Field2
  • user_id — int — Foreign key → user_trading_info.user_id — NOT NULL

coin (Untitled5)

  • stock_id — int — Primary key — NOT NULL
  • name — varchar(200)
  • Field
  • coin_list_id — int — Foreign key → coin_list.coin_list_id — NOT NULL
  • user_id — int — Foreign key → coin_list.user_id — NOT NULL

coin_list (Untitled6)

  • coin_list_id — int — Primary key — NOT NULL
  • name — varchar(200)
  • Field
  • user_id — int — Foreign key → user_trading_info.user_id — NOT NULL

metric (Untitled)

  • metric_id (메트릭 이름) — int — Primary key — NOT NULL
  • ema_20_high (이평선20 최댓값) — double
  • ema_20_low (이평선20 최솟값) — double
  • ADX_high (ADX 최댓값) — double
  • ADX_low (ADX 최솟값) — double
  • 기타 저표값 (Field)
  • alarm_id (Key) — int — Foreign key → alarm.alarm_id — NOT NULL

user (Untitled3)

  • user_id — int — Primary key — NOT NULL
  • name — varchar(100)
  • phonenum (num) — int
  • user_info.... (개인정보 기타) — varchar(200)

user_trading_info (Untitled4)

  • user_id — int — Foreign key → user.user_id — NOT NULL
  • asset — int
  • is_hearing_alarm — tinyint
  • cradit — int