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