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