customer
326 rows where store_id = 1
This data as json, xlsx, CSV (advanced)
Suggested facets: active, create_date, last_update, create_date (date), last_update (date)
| customer_id ▼ | store_id | first_name | last_name | address_id | active | create_date | last_update | |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 1 | MARY | SMITH | MARY.SMITH@sakilacustomer.org | 5 5 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 2 | 1 1 | PATRICIA | JOHNSON | PATRICIA.JOHNSON@sakilacustomer.org | 6 6 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 3 | 1 1 | LINDA | WILLIAMS | LINDA.WILLIAMS@sakilacustomer.org | 7 7 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 5 | 1 1 | ELIZABETH | BROWN | ELIZABETH.BROWN@sakilacustomer.org | 9 9 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 7 | 1 1 | MARIA | MILLER | MARIA.MILLER@sakilacustomer.org | 11 11 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 10 | 1 1 | DOROTHY | TAYLOR | DOROTHY.TAYLOR@sakilacustomer.org | 14 14 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 12 | 1 1 | NANCY | THOMAS | NANCY.THOMAS@sakilacustomer.org | 16 16 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 15 | 1 1 | HELEN | HARRIS | HELEN.HARRIS@sakilacustomer.org | 19 19 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 17 | 1 1 | DONNA | THOMPSON | DONNA.THOMPSON@sakilacustomer.org | 21 21 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 19 | 1 1 | RUTH | MARTINEZ | RUTH.MARTINEZ@sakilacustomer.org | 23 23 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 21 | 1 1 | MICHELLE | CLARK | MICHELLE.CLARK@sakilacustomer.org | 25 25 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 22 | 1 1 | LAURA | RODRIGUEZ | LAURA.RODRIGUEZ@sakilacustomer.org | 26 26 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 25 | 1 1 | DEBORAH | WALKER | DEBORAH.WALKER@sakilacustomer.org | 29 29 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 28 | 1 1 | CYNTHIA | YOUNG | CYNTHIA.YOUNG@sakilacustomer.org | 32 32 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 30 | 1 1 | MELISSA | KING | MELISSA.KING@sakilacustomer.org | 34 34 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 32 | 1 1 | AMY | LOPEZ | AMY.LOPEZ@sakilacustomer.org | 36 36 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 37 | 1 1 | PAMELA | BAKER | PAMELA.BAKER@sakilacustomer.org | 41 41 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 38 | 1 1 | MARTHA | GONZALEZ | MARTHA.GONZALEZ@sakilacustomer.org | 42 42 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 39 | 1 1 | DEBRA | NELSON | DEBRA.NELSON@sakilacustomer.org | 43 43 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 41 | 1 1 | STEPHANIE | MITCHELL | STEPHANIE.MITCHELL@sakilacustomer.org | 45 45 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 44 | 1 1 | MARIE | TURNER | MARIE.TURNER@sakilacustomer.org | 48 48 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 45 | 1 1 | JANET | PHILLIPS | JANET.PHILLIPS@sakilacustomer.org | 49 49 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 47 | 1 1 | FRANCES | PARKER | FRANCES.PARKER@sakilacustomer.org | 51 51 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 48 | 1 1 | ANN | EVANS | ANN.EVANS@sakilacustomer.org | 52 52 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 50 | 1 1 | DIANE | COLLINS | DIANE.COLLINS@sakilacustomer.org | 54 54 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 51 | 1 1 | ALICE | STEWART | ALICE.STEWART@sakilacustomer.org | 55 55 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 52 | 1 1 | JULIE | SANCHEZ | JULIE.SANCHEZ@sakilacustomer.org | 56 56 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 53 | 1 1 | HEATHER | MORRIS | HEATHER.MORRIS@sakilacustomer.org | 57 57 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 54 | 1 1 | TERESA | ROGERS | TERESA.ROGERS@sakilacustomer.org | 58 58 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 56 | 1 1 | GLORIA | COOK | GLORIA.COOK@sakilacustomer.org | 60 60 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:11 |
| 58 | 1 1 | JEAN | BELL | JEAN.BELL@sakilacustomer.org | 62 62 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 59 | 1 1 | CHERYL | MURPHY | CHERYL.MURPHY@sakilacustomer.org | 63 63 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 60 | 1 1 | MILDRED | BAILEY | MILDRED.BAILEY@sakilacustomer.org | 64 64 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 62 | 1 1 | JOAN | COOPER | JOAN.COOPER@sakilacustomer.org | 66 66 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 63 | 1 1 | ASHLEY | RICHARDSON | ASHLEY.RICHARDSON@sakilacustomer.org | 67 67 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 67 | 1 1 | KELLY | TORRES | KELLY.TORRES@sakilacustomer.org | 71 71 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 68 | 1 1 | NICOLE | PETERSON | NICOLE.PETERSON@sakilacustomer.org | 72 72 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 71 | 1 1 | KATHY | JAMES | KATHY.JAMES@sakilacustomer.org | 75 75 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 74 | 1 1 | DENISE | KELLY | DENISE.KELLY@sakilacustomer.org | 78 78 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 78 | 1 1 | LORI | WOOD | LORI.WOOD@sakilacustomer.org | 82 82 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 79 | 1 1 | RACHEL | BARNES | RACHEL.BARNES@sakilacustomer.org | 83 83 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 80 | 1 1 | MARILYN | ROSS | MARILYN.ROSS@sakilacustomer.org | 84 84 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 81 | 1 1 | ANDREA | HENDERSON | ANDREA.HENDERSON@sakilacustomer.org | 85 85 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 82 | 1 1 | KATHRYN | COLEMAN | KATHRYN.COLEMAN@sakilacustomer.org | 86 86 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 83 | 1 1 | LOUISE | JENKINS | LOUISE.JENKINS@sakilacustomer.org | 87 87 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 87 | 1 1 | WANDA | PATTERSON | WANDA.PATTERSON@sakilacustomer.org | 91 91 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 89 | 1 1 | JULIA | FLORES | JULIA.FLORES@sakilacustomer.org | 93 93 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 93 | 1 1 | PHYLLIS | FOSTER | PHYLLIS.FOSTER@sakilacustomer.org | 97 97 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 94 | 1 1 | NORMA | GONZALES | NORMA.GONZALES@sakilacustomer.org | 98 98 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
| 96 | 1 1 | DIANA | ALEXANDER | DIANA.ALEXANDER@sakilacustomer.org | 100 100 | 1 | 2006-02-14 22:04:36.000 | 2020-12-23 07:15:12 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE customer ( customer_id INT NOT NULL, store_id INT NOT NULL, first_name VARCHAR(45) NOT NULL, last_name VARCHAR(45) NOT NULL, email VARCHAR(50) DEFAULT NULL, address_id INT NOT NULL, active CHAR(1) DEFAULT 'Y' NOT NULL, create_date TIMESTAMP NOT NULL, last_update TIMESTAMP NOT NULL, PRIMARY KEY (customer_id), CONSTRAINT fk_customer_store FOREIGN KEY (store_id) REFERENCES store (store_id) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT fk_customer_address FOREIGN KEY (address_id) REFERENCES address (address_id) ON DELETE NO ACTION ON UPDATE CASCADE ); CREATE INDEX idx_customer_fk_store_id ON customer(store_id) ; CREATE INDEX idx_customer_fk_address_id ON customer(address_id) ; CREATE INDEX idx_customer_last_name ON customer(last_name) ;