asd

Tables (9)

Customer (Untitled9)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — string
  • Field (email) — string
  • Field (phone_number) — string
  • Field (maccaron_customer_id) — int

KycProof (Untitled7)

  • Key (id) — int — Primary key — NOT NULL
  • Key (customer_id) — int — Foreign key → Customer.Key — NOT NULL
  • Field (status) — string
  • Field (aadhaar_front) — File
  • Field (aadhaar_back) — File
  • Field (proof_number) — int
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Manifest (Untitled6)

  • Key (id) — int — Primary key — NOT NULL
  • Key (updated_by) — int — Foreign key → User.Key — NOT NULL
  • Field (status) — string
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (compressed_file) — File
  • Field (file) — File
  • Field (name) — string

Order (Untitled2)

  • Key (order_id) — int — Primary key — NOT NULL
  • Key (product_id) — int — Foreign key → Product.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Product.Key — NOT NULL
  • Key (user_id2) — int — Foreign key → User'.Key — NOT NULL
  • Field (quantity) — int
  • Field (created_at) — date
  • Field (updated_at) — date

Order (Untitled4)

  • Key (id) — int — Primary key — NOT NULL
  • Key (customer_id) — int — Foreign key → Customer.Key — NOT NULL
  • Key (manifest_id) — int — Foreign key → Manifest.Key — NOT NULL
  • Field (maccaron_order_id) — int
  • Field (maccaron_mgs_order_id) — int
  • Field (placed_at) — time
  • Field (shipping_address) — string
  • Field (declaration) — File
  • Field (invoice_file) — File
  • Field (status) — string

Payment (Untitled5)

  • Key (id) — int — Primary key — NOT NULL
  • Key (order_id) — int — Foreign key → Order.Key — NOT NULL
  • Field (status) — string
  • Field (type) — string
  • Field (total_amount) — decimal
  • Field (captured_amount) — decimal

Product (Untitled3)

  • Key (product_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User'.Key — NOT NULL
  • Field (name) — string
  • Field (price) — int
  • Field (description) — string
  • Field (stuck) — int
  • Field (created_at) — date
  • Field (updated_at) — date

User (Untitled8)

  • Key (id) — int — Primary key — NOT NULL

User' (Untitled)

  • Key (user_id) — int — Primary key — NOT NULL
  • Field (email) — string
  • Field (password) — string
  • Field (created_at) — date
  • Field (level) — string