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 4,851–4,875 of 5,412

payment, page 195 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4851digital_wallet45002019-09-04 18:55:08
4852credit_card30002019-09-04 22:48:12
4853debit_card4002019-09-05 06:00:20
4854debit_card15002019-09-05 08:42:45
4855digital_wallet8002019-09-05 12:24:47
4856digital_wallet60002019-09-05 20:08:54
4857credit_card4002019-09-05 21:00:05
4858debit_card4002019-09-06 03:44:10
4859debit_card75002019-09-06 09:00:50
4860credit_card4002019-09-06 22:28:42
4861debit_card15002019-09-06 22:51:36
4862digital_wallet705002019-09-07 10:32:28
4863digital_wallet15002019-09-07 13:10:54
4864credit_card15002019-09-07 21:10:17
4865debit_card15002019-09-08 15:18:41
4866debit_card4002019-09-09 23:26:01
4867debit_card8002019-09-10 11:10:34
4868debit_card30002019-09-10 13:30:52
4869debit_card4002019-09-10 21:27:58
4870debit_card4002019-09-11 02:44:46
4871credit_card45002019-09-11 07:10:48
4872digital_wallet51002019-09-11 10:14:14
4873digital_wallet750002019-09-11 10:27:08
4874cash8002019-09-11 12:31:30
4875debit_card4002019-09-12 01:28: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;