gpt

Tables (7)

addresses

  • address_id — INT
  • member_id — INT — NOT NULL
  • postal_code — VARCHAR(10)
  • phone — VARCHAR(20)
  • address — TEXT
  • is_default — BOOLEAN
  • created_at — TIMESTAMP

cart

  • cart_id — INT
  • member_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • total_price — DECIMAL(10, 2) — NOT NULL
  • added_at — TIMESTAMP

credit_cards

  • card_id — INT
  • member_id — INT — NOT NULL
  • card_company — VARCHAR(50)
  • card_number — VARCHAR(20)
  • expiry_date — DATE
  • created_at — TIMESTAMP

members

  • member_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • full_name — VARCHAR(100)
  • address — TEXT
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP

order_details

  • order_detail_id — INT
  • order_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL

orders

  • order_id — INT
  • member_id — INT — NOT NULL
  • order_date — TIMESTAMP
  • total_amount — DECIMAL(10, 2) — NOT NULL
  • address_id — INT — NOT NULL
  • card_id — INT — NOT NULL

products

  • product_id — INT
  • name — VARCHAR(100) — NOT NULL
  • image_url — VARCHAR(255)
  • price — DECIMAL(10, 2) — NOT NULL