cosign-rdb

Tables (20)

ai_pattern_capture_reports (AI 패턴 캡쳐 차트 분석)

  • AI 패턴 캡쳐 차트 분석 고유 아이디 (ai_pattern_capture_reports_id) — int(11) unsigned — Primary key — NOT NULL
  • pattern_code — varchar
  • crypto_currency_id — int(11) unsigned
  • is_pay — boolean

ai_reports (ai 리포트 차트 해석)

  • ai_report 아이디 (ai_reports) — int(11) unsigned — Primary key — NOT NULL
  • crypto 고유 아이디 (crypto_currency_id) — int(11) unsigned
  • 분봉 종류 (interval_type) — enum(15,60,240,1440,10080)
  • ai 리포트 (ai_report) — text
  • ai 리포트 시작 시간 (gte_time) — timestamp
  • ai 리포트 종료 시간 (lte_time) — tiemstamp
  • 생성 시간 (created_at) — tiemstamp
  • 업데이트 시간 (updated_at) — tiemstamp

feed

  • feed_id — int(10) — Primary key — NOT NULL
  • feed_contents_id — varchar(36) — NOT NULL
  • feed_type — varchar(100) — NOT NULL
  • feed_display — enum('FREE_DISPLAY','PAY_DISPLAY','NON_DISPLAY') — NOT NULL
  • feed_add_time — datetime — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

feed_admin

  • feed_admin_id (feed_id) — char(36) — Foreign key → feed.feed_id — NOT NULL
  • title — varchar(255)
  • content — text
  • coin — varchar(100)
  • crypto_currency_id — int(11)
  • img_url — varchar(255)
  • link — varchar(255)
  • new_window — bit(1)
  • registration_type — enum('IMMEDIATELY','RESERVATION','WAITING_RESERVATION')
  • registration_time — timestamp
  • created_at — timestamp
  • app_link — varchar(255)

feed_coin_coupling

  • feed_coupling_id — char(36) — Foreign key → feed.feed_id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • crypto_currency_id — int(11)
  • crypto_symbol — varchar(100)
  • date_start — timestamp
  • date_end — timestamp
  • candle_unit — int(11)
  • description — text

feed_coin_coupling_correlation

  • id — int(10) — Primary key — NOT NULL
  • feed_coupling_id — char(36)
  • rank — int(11)
  • crypto_currency_id — int(11)
  • crypto_symbol — varchar(100)
  • value — double
  • diff_rate — double
  • diff — double

feed_indicator_coupling

  • feed_coupling_id — char(36) — Foreign key → feed.feed_id — NOT NULL
  • ai_report — text
  • crypto_currency_id — int(11)
  • market — varchar(100)
  • coupling_created_at — timestamp

feed_indicator_coupling_correlation

  • id — int(10) — Primary key — NOT NULL
  • feed_coupling_id — char(36)
  • feed_type — enum('gold','dollar','nasdaq')
  • diff_rate — int(11)
  • diff — double
  • correlation — double
  • candle_unit — int(11)
  • date_end — timestamp

feed_main_schedule

  • feed_main_schedule_id — char(36) — Foreign key → feed.feed_id — NOT NULL
  • exchange — varchar(255)
  • title — varchar(255)
  • photo — varchar(255)
  • text — text
  • link — varchar(255)
  • new_window — bit(1)
  • created_at — timestamp
  • updated_at — timestamp

feed_pattern_capture

  • id — char(36) — Foreign key → feed.feed_id — NOT NULL
  • crypto_currency_id — int(11)
  • coin — varchar(255)
  • pattern_code — varchar(255)
  • capture_date — timestamp
  • state — varchar(255)
  • description — text
  • coin_image — varchar(255)
  • korean_name — varchar(255)
  • start_point_time — timestamp
  • end_point_time — timestamp
  • coin_code — varchar(100)
  • start_price — decimal(18,9)
  • pattern_id — varchar(255)

feed_sign

  • feed_sign_id — char(36)
  • ai_model_uuid — char(36)
  • crypto_currency_id — int(11)
  • market — varchar(100)
  • start_price — decimal(18,9)
  • target_price — decimal(18,9)
  • cut_price — decimal(18,9)
  • target_earning_rate — decimal(18,9)
  • start_time — timestamp
  • end_time — timestamp
  • end_earning_time — timestamp
  • validate_min — int(11)
  • content_text — text
  • created_at — timestamp
  • updated_at — timestamp
  • earning_rate — decimal(18,9)
  • min_price — decimal(18,9)
  • max_price — decimal(18,9)
  • end_price — decimal(18,9)
  • sub_seq_id — int(10)
  • slide_no — int(10)
  • target_earning_rate2 — decimal(18,9)
  • target_earning_rate3 — decimal(18,9)
  • target_price2 — decimal(18,9)
  • target_price3 — decimal(18,9)
  • active_ticket_display — bit(1) — NOT NULL
  • feed_id — int(10) — Foreign key → feed.feed_id — NOT NULL

feed_soaring_plunging

  • id — char(36) — Foreign key → feed.feed_id — NOT NULL
  • crypto_currency_id — int(11)
  • coin — varchar(255)
  • korean_name — varchar(255)
  • coin_image — varchar(255)
  • title — varchar(255)
  • text — varchar(255)
  • created_at — timestamp
  • tag — varchar(255)
  • coin_code — varchar(100)
  • photo — varchar(255)

feed_today_ai_reports

  • feed_today_ai_reports_id — char(36) — Foreign key → feed.feed_id — NOT NULL
  • title — varchar(255)
  • reports_keyword — text
  • created_at — timestamp
  • updated_at — timestamp

graph_points (차트 패턴 그래프 포인트)

  • graph_point_id — int(11) unsigned — Primary key — NOT NULL
  • time — int(11) unsigned
  • price — big decimal
  • graph_points_group_id (graph_point_group_id) — int(11) unsigned — Foreign key → graph_points_group.graph_points_group_id — NOT NULL

graph_points_group (points 그룹 테이블)

  • graph_points_group_id (graph_point_group_id) — int(11) unsigned — Primary key — NOT NULL
  • pattern_capture_graph_id — int(11) unsigned — Foreign key → pattern_capture_graph.pattern_capture_graph_id — NOT NULL
  • graph_group_type — enum('auxiliaryLine','points')

interval_statistics (분봉별 데이터)

  • 분봉 고융 아이디 (interval_id) — int(11) unsigned — Primary key — NOT NULL
  • pattern_capture_id — int(11) unsigned — Foreign key → patten_statistics.pattern_capture_id — NOT NULL
  • interval_count — int(11) unsigned
  • interval_up_rate — double
  • interval_down_rate — double
  • interval_type — enum('total','15','60','240','1440','10080')

patten_statistics (패턴 통계)

  • pattern_capture_id — int(11) unsigned — Primary key — NOT NULL
  • ai_pattern_capture_reports_id — int(11) unsigned — Foreign key → ai_pattern_capture_reports.AI 패턴 캡쳐 차트 분석 고유 아이디 — NOT NULL
  • description — text
  • standard_date — timestamp
  • pattern_capture_type — enum('symbol','total')

pattern_capture_graph (차트 패턴 그래프)

  • pattern_capture_graph_id — int(11) unsigned — Primary key — NOT NULL
  • pattern_code — varchar(255)
  • crypto_currency_id — int(11) unsigned
  • state — varchar(255)
  • interval — varchar(255)
  • start_point_time — int(11) unsigned
  • end_point_time — int(11) unsigned
  • seq_id — int(11) unsigned
  • auxiliary_shape — varchar(255)
  • report_title — varchar(255)
  • report_text — varchar(255)

today_ai_reports (오늘의 AI 리포트)

  • 오늘의 AI 리포트 고유 아이디 (today_ai_reports_id) — int(10) unsigned — Primary key — NOT NULL
  • 커플링 제목 (report_title) — varchar(255)
  • 나스닥 (nasdaq) — double
  • 달러 (dollar) — double
  • 금 (gold) — double
  • 리포트 생성 시간 (report_add_date) — varchar

today_ai_reports_contents (AI 리포트 타입)

  • AI 리포트 텍스트 타입 고유 아이디 (today_ai_reports_contents_id) — int(10) unsigned — Primary key — NOT NULL
  • 리포트 카테고리 (category) — enum(coupling_report,nomal_report)
  • 리포트 문단 번호 (paragraph) — int
  • AI 리포트 타입 (reports_type) — enum(title,content,list)
  • AI 리포트 텍스트 타입 (texts_type) — enum(nomal,strong)
  • AI 리포트 텍스트 (texts) — text
  • 오늘의 AI 리포트 고유 아이디 (today_ai_reports_id) — int(10) unsigned — Foreign key → today_ai_reports.오늘의 AI 리포트 고유 아이디 — NOT NULL