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,176–4,200 of 5,412

payment, page 168 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
4176debit_card15002019-03-06 15:24:52
4177debit_card4002019-03-07 01:02:37
4178credit_card75002019-03-07 21:39:41
4179debit_card30002019-03-08 07:43:14
4180digital_wallet34002019-03-08 09:24:52
4181credit_card60002019-03-09 11:23:49
4182digital_wallet8002019-03-09 12:07:34
4183credit_card4002019-03-09 19:38:26
4184digital_wallet8002019-03-10 12:45:43
4185credit_card8002019-03-10 12:54:35
4186digital_wallet60002019-03-11 07:21:29
4187credit_card51002019-03-11 09:43:55
4188debit_card4002019-03-12 02:28:53
4189digital_wallet45002019-03-12 08:06:54
4190digital_wallet30002019-03-12 08:31:20
4191cash17002019-03-12 11:53:57
4192credit_card4002019-03-12 19:46:52
4193credit_card30002019-03-12 20:21:52
4194debit_card4002019-03-12 21:13:13
4195credit_card4002019-03-12 21:28:16
4196digital_wallet15002019-03-13 09:15:53
4197credit_card4002019-03-13 14:43:28
4198debit_card15002019-03-13 16:49:31
4199cash34002019-03-14 11:38:52
4200digital_wallet8002019-03-14 12:14:43
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;