Skip to content
Louvre Ops DB

Table

payment

One row per payment; the method is a single column.

Replaces in 2020: Payment Methods

Download CSV Query in playground

Rows 1,351–1,375 of 5,412

payment, page 55 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1351credit_card51002016-06-30 13:38:38
1352debit_card8002016-06-30 14:02:39
1353cash68002016-07-01 11:56:23
1354digital_wallet8002016-07-01 12:25:33
1355credit_card51002016-07-01 13:41:45
1356cash34002016-07-01 14:41:51
1357cash34002016-07-02 09:59:47
1358credit_card8002016-07-02 10:17:07
1359credit_card34002016-07-02 10:35:47
1360digital_wallet8002016-07-02 11:03:38
1361credit_card15002016-07-02 13:24:50
1362debit_card15002016-07-02 18:48:23
1363credit_card15002016-07-04 09:11:58
1364digital_wallet15002016-07-04 13:57:07
1365credit_card4002016-07-05 07:25:00
1366credit_card15002016-07-05 13:06:44
1367credit_card15002016-07-05 13:07:54
1368credit_card15002016-07-06 07:44:23
1369digital_wallet15002016-07-06 08:56:30
1370credit_card8002016-07-06 10:29:36
1371credit_card15002016-07-06 11:32:52
1372credit_card4002016-07-06 13:26:06
1373credit_card4002016-07-07 02:13:13
1374credit_card45002016-07-07 08:51:43
1375credit_card8002016-07-07 11:40:51
Table definition
CREATE TABLE payment (
  payment_id   INTEGER PRIMARY KEY,
  method       TEXT NOT NULL
               CHECK (method IN ('credit_card', 'debit_card', 'digital_wallet', 'cash')),
  amount_cents INTEGER NOT NULL CHECK (amount_cents >= 0),
  paid_at      TEXT NOT NULL CHECK (paid_at GLOB '[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]')
) STRICT;