ca
Tables (13)
alert_candidate (Untitled7)
- candidate_id (Key) — Primary key — NOT NULL
- candidate_key (Field)
- decision (Field2)
- resaon (Field3)
- created_at (Field4)
- subscription_id (Key2) — Foreign key → subscription.subscription_id — NOT NULL
alert_delivery (Untitled8)
- delivery_id (Key) — Primary key — NOT NULL
- channel (Field)
- status (Field2)
- provider_message_id (Field3)
- sent_at (Field4)
- error_message (Field5)
- created_at (Field6)
- candidate_id (Key2) — Foreign key → alert_candidate.candidate_id — NOT NULL
app_user (Untitled)
- user_id (Key) — Primary key — NOT NULL
- googld_sub (Field)
- email (Field2)
- display_name (Field3)
- profile_image_url (Field4)
- created_at (Field5)
- updated_at (Field6)
business_category (Untitled3)
- category_id (Key) — Primary key — NOT NULL
- Field
category_ingredient_map (Untitled9)
- category_id (Key) — Foreign key → business_category.category_id — NOT NULL
- ingredient_id (Key2) — Foreign key → ingredient.ingredient_id — NOT NULL
- default_priority (Field)
- is_default_subscribe (Field2)
ingredient (Untitled4)
- ingredient_id (Key) — Primary key — NOT NULL
- code (Field)
- name_ko (Field2)
- is_active (Field3)
market_price_candle (Untitled13)
- candle_interval (Key) — Primary key — NOT NULL
- bucket_time (Key2) — Primary key — NOT NULL
- ingredient_id (Key3) — Foreign key → ingredient.ingredient_id — NOT NULL
- open (Field)
- high (Field2)
- low (Field3)
- close (Field4)
- volume (Field5)
- source (Field6)
- created_at (Field7)
signal_event_type (Untitled11)
- id (Key) — Primary key — NOT NULL
- event_type (Field)
- event_id (Key2) — Foreign key → signal_report.event_id — NOT NULL
signal_evidence (Untitled12)
- id (Key) — Primary key — NOT NULL
- source (Field)
- raw_id (Field2)
- uri (Field3)
- title (Field4)
- publisher (Field5)
- published_at (Field6)
- event_id (Key2) — Foreign key → signal_report.event_id — NOT NULL
signal_report (Untitled10)
- event_id (Key) — Primary key — NOT NULL
- dedupe_keyt (Field)
- impact_dir (Field2)
- impact_score (Field3)
- confidence (Field4)
- horizon_min (Field5)
- summary (Field6)
- batch_from (Field7)
- batch_to (Field8)
- model_version (Field9)
- generated_at (Field10)
- ingredient_id (Key2) — Foreign key → ingredient.ingredient_id — NOT NULL
subscription (Untitled6)
- subscription_id (Key) — Primary key — NOT NULL
- threshold_score (Field)
- min_confidence (Field2)
- horizon_min (Field3)
- channels (Field4)
- is_enabled (Field5)
- created_by (Field6)
- created_at (Field7)
- created_by (Field8)
- user_id (Key2) — Foreign key → app_user.user_id — NOT NULL
- ingredient_id (Key3) — Foreign key → ingredient.ingredient_id — NOT NULL
user_business_category (Untitled2)
- user_id (Key2) — Foreign key → app_user.user_id — NOT NULL
- category_id (Key3) — Foreign key → business_category.category_id — NOT NULL
user_ingredient (Untitled5)
- user_id (Key) — Foreign key → app_user.user_id — NOT NULL
- ingredient_id (Key2) — Foreign key → ingredient.ingredient_id — NOT NULL
- priority (Field)
- created_at (Field2)