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