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,451–4,475 of 5,412

payment, page 179 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4451credit_card15002019-05-25 19:01:56
4452credit_card4002019-05-25 22:52:02
4453debit_card15002019-05-26 16:24:26
4454digital_wallet15002019-05-26 21:45:10
4455digital_wallet30002019-05-27 08:14:33
4456digital_wallet8002019-05-27 10:20:47
4457digital_wallet30002019-05-27 11:07:57
4458credit_card15002019-05-27 11:20:26
4459debit_card15002019-05-27 16:52:04
4460debit_card4002019-05-28 01:39:53
4461digital_wallet30002019-05-28 08:42:44
4462debit_card51002019-05-28 10:16:35
4463cash8002019-05-28 10:48:25
4464credit_card45002019-05-28 12:56:24
4465digital_wallet51002019-05-28 13:10:34
4466digital_wallet30002019-05-28 22:33:13
4467credit_card4002019-05-29 17:07:15
4468debit_card4002019-05-29 23:17:42
4469debit_card4002019-05-30 03:45:42
4470digital_wallet15002019-05-30 08:15:57
4471credit_card15002019-05-30 12:36:04
4472credit_card15002019-05-30 17:37:39
4473digital_wallet15002019-05-31 07:19:47
4474cash17002019-05-31 10:27:51
4475credit_card30002019-05-31 14:34:58
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;