svod
Tables (9)
Order (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- payment_id (Key2) — int — Foreign key → Payment.id — NOT NULL
- account (Field) — int
- status (Field2) — char
OrderItem (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- order_id (Key2) — int — Foreign key → Order.id — NOT NULL
- payment_id (Key22) — int — Foreign key → Order.payment_id — NOT NULL
- product_promotion_id (Key3) — int — Foreign key → ProductPromotion.id — NOT NULL
- product_id (Key4) — int — Foreign key → Product.id — NOT NULL
- product (Field) — int
- Field2
PGPayment (CopyOfpg_payment_item)
- id (pg_payment_id) — int — Primary key — NOT NULL
- paymant_id (Key) — int — Foreign key → Payment.id — NOT NULL
- py_type (Field3) — char
- pg_transaction_key (Field2) — char
PGPaymentItem (pg_payment_item)
- pg_payment_id (pg_payment_id2) — int — Foreign key → PGPayment.id — NOT NULL
- id (Key) — int — Foreign key → PGPayment.paymant_id — NOT NULL
- product_key (Field) — char
- promotion_product_key (Field2) — char
- offer_id (Field3) — char
PGProduct (Untitled6)
- id (Key) — int — Primary key — NOT NULL
- product_id (Key2) — int — Foreign key → Product.id — NOT NULL
- pg_type (Field) — char
- product_key (Field2) — char
- base_price (Field3) — decimal
- Field4
PGPromotinoProduct (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- pg_product_id (Key3) — int — Foreign key → PGProduct.id — NOT NULL
- product_promotion_id (Key2) — int — Foreign key → ProductPromotion.id — NOT NULL
- id (Key22) — int — Foreign key → PGProduct.product_id — NOT NULL
- product_key (Field) — char
- offer_id (Field2) — char
Payment (Untitled)
- id (Key) — int — Primary key — NOT NULL
- payment_type (Field) — char
- status (Field2) — char
Product (Untitled7)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — char
- product_group (Field2) — int
- product_type (Field3) — char
- release_datetime (Field4) — datetime
- expire_datetime (Field5) — datetime
- Field6
ProductPromotion (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- country_code (Field) — char
- start_datetime (Field2) — datetime
- end_datetime (Field3) — datetime