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 3,051–3,075 of 5,412

payment, page 123 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3051debit_card8002018-03-31 09:29:58
3052cash85002018-03-31 13:14:02
3053credit_card15002018-03-31 22:20:07
3054debit_card15002018-04-01 07:03:57
3055debit_card4002018-04-01 07:35:19
3056digital_wallet15002018-04-01 07:41:04
3057credit_card4002018-04-01 13:51:54
3058credit_card30002018-04-01 15:18:18
3059debit_card4002018-04-01 18:31:58
3060credit_card34002018-04-02 09:00:44
3061credit_card45002018-04-02 12:16:12
3062credit_card30002018-04-02 12:33:34
3063digital_wallet17002018-04-02 14:13:56
3064credit_card4002018-04-02 15:37:41
3065debit_card15002018-04-02 17:01:21
3066credit_card4002018-04-02 18:10:54
3067credit_card4002018-04-02 22:02:29
3068credit_card4002018-04-03 03:06:00
3069debit_card30002018-04-03 14:32:35
3070credit_card30002018-04-03 20:11:52
3071credit_card34002018-04-04 08:57:00
3072credit_card8002018-04-04 09:19:39
3073credit_card15002018-04-04 23:35:04
3074credit_card17002018-04-05 11:21:56
3075credit_card8002018-04-05 11:37:26
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;