Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('okr.stripe_customers_id_seq'::regclass) |
|
|
||||
| customer_id | varchar | 255 | null |
|
|
Stripe上の顧客ID |
||||
| organization_id | bigserial | 19 | √ | nextval('okr.stripe_customers_organization_id_seq'::regclass) |
|
|
||||
| quantity | int4 | 10 | null |
|
|
購入数(ユーザー数上限) |
||||
| created_at | timestamptz | 35,6 | null |
|
|
|||||
| updated_at | timestamptz | 35,6 | null |
|
|
|||||
| expired_at | timestamptz | 35,6 | √ | null |
|
|
サブスクがいつ切れたか |
|||
| resubscripted_at | timestamptz | 35,6 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| stripe_customers_pkey | Primary key | Asc | id |
| idx_stripe_customers_on_customer_id | Must be unique | Asc | customer_id |
| idx_stripe_customers_on_organization_id | Must be unique | Asc | organization_id |