prospects

✎ View and edit SQL

This data as json

0 records

CREATE TABLE prospects (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            rue_id INTEGER NOT NULL,
            nom TEXT NOT NULL,
            type_commerce TEXT,
            statut TEXT DEFAULT 'à contacter',
            date_passage TEXT,
            nb_passages INTEGER DEFAULT 0,
            notes TEXT,
            lat REAL,
            lng REAL,
            FOREIGN KEY (rue_id) REFERENCES rues(id)
        );