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