appartements

45 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pieces, surface, source, statut, lat, lng, date_vue, created_at, date_vue (date), created_at (date)

CREATE TABLE appartements (
      id          INTEGER PRIMARY KEY AUTOINCREMENT,
      listing_id  TEXT UNIQUE NOT NULL,
      adresse     TEXT,
      prix        INTEGER,
      pieces      TEXT,
      surface     TEXT,
      lien        TEXT,
      source      TEXT,
      statut      TEXT DEFAULT 'en_attente_envoi',
      lat         REAL,
      lng         REAL,
      notes       TEXT,
      date_vue    TEXT,
      created_at  TEXT DEFAULT CURRENT_TIMESTAMP
    );