payment
Tables (5)
cart (Untitled3)
- idf_cart — int — Primary key — NOT NULL
- idf_member — int — Foreign key → member.idf_member — NOT NULL
- date_updated — timestamp
- date_created — timestamp
member (Untitled)
- idf_member — int — Primary key — NOT NULL
- email — varchar(100)
- name — varchar(20)
- password — varchar(100)
- address — varchar(200)
- date_updated — timestamp
- date_created — timestamp
payment (Untitled5)
- idf_payment — int — Primary key — NOT NULL
- idf_member — int — Foreign key → member.idf_member — NOT NULL
- status — char(1)
- total_price — int
- tracking_number — varchar(50)
- date_updated — timestamp
- date_created — timestamp
product (Untitled2)
- idf_product — int — Primary key — NOT NULL
- name — varchar(50)
- price — int
- image — varchar(200)
- description — varchar(200)
- date_updated — timestamp
- date_created — timestamp
product_cart (Untitled4)
- idf_product — int — Foreign key → product.idf_product — NOT NULL
- idf_cart — int — Foreign key → cart.idf_cart — NOT NULL
- quantity — int
- date_updated — timestamp
- date_created — timestamp