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)