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 5,076–5,100 of 5,412

payment, page 204 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
5076debit_card8002019-11-16 09:42:59
5077digital_wallet8002019-11-16 09:54:13
5078credit_card4002019-11-16 12:47:33
5079credit_card34002019-11-16 13:37:58
5080credit_card30002019-11-16 18:54:33
5081cash34002019-11-17 09:33:56
5082digital_wallet8002019-11-17 14:25:08
5083digital_wallet8002019-11-17 14:26:30
5084credit_card30002019-11-17 19:21:49
5085debit_card15002019-11-18 13:36:40
5086credit_card8002019-11-18 13:51:24
5087credit_card4002019-11-19 02:51:23
5088credit_card30002019-11-19 08:42:38
5089digital_wallet8002019-11-19 10:17:42
5090credit_card30002019-11-19 15:51:55
5091digital_wallet30002019-11-20 09:22:43
5092credit_card68002019-11-20 11:35:17
5093digital_wallet15002019-11-20 12:27:42
5094debit_card30002019-11-20 19:17:57
5095credit_card30002019-11-20 20:42:54
5096credit_card60002019-11-20 23:45:42
5097credit_card75002019-11-21 13:06:44
5098credit_card4002019-11-21 17:11:48
5099credit_card4002019-11-21 19:34:33
5100credit_card15002019-11-21 22:05:03
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;