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,201–1,225 of 5,412

payment, page 49 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
1201credit_card4002016-05-07 16:48:17
1202credit_card780002016-05-08 13:14:57
1203cash8002016-05-08 14:43:55
1204credit_card30002016-05-08 18:44:13
1205debit_card4002016-05-08 23:04:31
1206credit_card30002016-05-09 15:53:25
1207credit_card4002016-05-10 00:15:20
1208credit_card45002016-05-10 09:57:31
1209credit_card4002016-05-10 11:04:15
1210credit_card51002016-05-10 11:34:52
1211cash17002016-05-10 11:35:41
1212credit_card480002016-05-10 17:48:13
1213credit_card60002016-05-11 08:49:51
1214cash17002016-05-11 09:59:57
1215credit_card34002016-05-11 11:04:35
1216debit_card17002016-05-12 15:04:45
1217cash34002016-05-13 10:14:09
1218digital_wallet34002016-05-13 12:23:25
1219digital_wallet15002016-05-13 13:05:03
1220debit_card15002016-05-13 14:02:15
1221digital_wallet15002016-05-14 10:17:00
1222cash17002016-05-14 11:52:42
1223debit_card17002016-05-14 12:31:33
1224credit_card8002016-05-14 13:10:02
1225credit_card8002016-05-14 14:28:17
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;