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