Shopware 6.7.7.1 app_payment_method
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| id | binary(16) | NO | Primary Key |
| app_id | binary(16) | YES | Index Foreign Key → app.id |
| payment_method_id | binary(16) | NO | Unique Foreign Key → payment_method.id |
| app_name | varchar(255) | NO | |
| identifier | varchar(255) | NO | |
| pay_url | varchar(255) | YES | |
| finalize_url | varchar(255) | YES | |
| validate_url | varchar(255) | YES | |
| capture_url | varchar(255) | YES | |
| refund_url | varchar(255) | YES | |
| original_media_id | binary(16) | YES | Index Foreign Key → media.id |
| created_at | datetime(3) | NO | |
| updated_at | datetime(3) | YES | |
| recurring_url | varchar(255) | YES |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| fk.app_payment_method.app_id | app_id | No |
| fk.app_payment_method.original_media_id | original_media_id | No |
| PRIMARY | id | Yes |
| uniq.app_payment_method.payment_method_id | payment_method_id | Yes |
Relations (from this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| app_id | app | id |
| original_media_id | media | id |
| payment_method_id | payment_method | id |