Planning multi-nuits

• 📊 Per-target progress bars par filtre vs objectif d'heures défini par campagne
• 📅 Calendar view pluri-annuelle : pour chaque cible, sa fenêtre de visibilité > 40°
• 🌙 Smart suggestions : la nuit prochaine, quelles cibles maximiser selon Lune+météo+quotas
• 🎯 NINA Target Scheduler JSON : export direct vers le mini-PC MeLE
• 📡 Telegram bot : "lance la séquence M31 ce soir, alerte-moi si problème"

CREATE TABLE targets (
  id              TEXT PRIMARY KEY,        -- M31, NGC891, IC1396, C20…
  catalog         TEXT NOT NULL,           -- M, C, NGC, IC, Sh2, Abell
  name            TEXT NOT NULL,
  type            TEXT NOT NULL,
  ra_deg          REAL NOT NULL,
  dec_deg         REAL NOT NULL,
  mag             REAL,
  size_arcmin     REAL,
  constellation   TEXT,
  priority        INTEGER DEFAULT 50,      -- 0..100 priorité campagne
  target_h_l      REAL DEFAULT 0,
  target_h_r      REAL DEFAULT 0,
  target_h_g      REAL DEFAULT 0,
  target_h_b      REAL DEFAULT 0,
  target_h_ha     REAL DEFAULT 0,
  target_h_oiii   REAL DEFAULT 0,
  target_h_sii    REAL DEFAULT 0,
  notes           TEXT
);

CREATE TABLE sessions (
  id              INTEGER PRIMARY KEY AUTOINCREMENT,
  date_start_utc  TEXT NOT NULL,
  date_end_utc    TEXT NOT NULL,
  weather_score   TEXT,                    -- EXCELLENT/GOOD/MARGINAL/BAD
  operator        TEXT,
  notes           TEXT
);

CREATE TABLE acquisitions (
  id              INTEGER PRIMARY KEY AUTOINCREMENT,
  session_id      INTEGER REFERENCES sessions(id),
  target_id       TEXT REFERENCES targets(id),
  filter          TEXT NOT NULL,           -- L, R, G, B, Ha, OIII, SII
  exposure_s      REAL NOT NULL,
  n_subs          INTEGER NOT NULL,
  keepers         INTEGER NOT NULL,
  hfr_median      REAL,
  fwhm_arcsec     REAL,
  ts_utc          TEXT NOT NULL
);

CREATE INDEX idx_acq_target ON acquisitions(target_id, filter);
CREATE INDEX idx_acq_session ON acquisitions(session_id);