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,926–3,950 of 5,412

payment, page 158 of 217
payment_idINTEGERmethodTEXTamount_centsINTEGERpaid_atTEXT
3926credit_card15002018-11-30 14:53:26
3927digital_wallet30002018-11-30 23:55:57
3928debit_card30002018-12-01 14:27:23
3929debit_card4002018-12-01 22:10:53
3930credit_card4002018-12-02 02:05:04
3931digital_wallet8002018-12-02 09:25:36
3932cash34002018-12-02 10:47:07
3933digital_wallet34002018-12-02 10:49:15
3934credit_card8002018-12-02 11:22:30
3935debit_card8002018-12-02 11:29:17
3936credit_card17002018-12-02 16:16:54
3937credit_card4002018-12-03 04:31:18
3938credit_card4002018-12-03 11:00:36
3939debit_card15002018-12-03 22:40:07
3940credit_card4002018-12-04 19:47:45
3941credit_card15002018-12-04 19:57:50
3942digital_wallet75002018-12-04 23:32:26
3943debit_card34002018-12-05 10:26:38
3944credit_card4002018-12-06 07:36:20
3945debit_card68002018-12-06 10:41:24
3946digital_wallet60002018-12-06 14:34:01
3947credit_card34002018-12-07 08:57:25
3948cash68002018-12-07 09:17:11
3949debit_card8002018-12-07 09:33:14
3950cash8002018-12-07 09:49:04
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;