database

Tables (9)

Cart

  • cart_id — INT — NOT NULL
  • member_id — INT — Foreign key → Member.member_id
  • product_id — INT — Foreign key → Product.product_id
  • quantity — INT — NOT NULL
  • is_wishlist — BOOLEAN
  • added_at — TIMESTAMP

Category

  • category_id — INT — NOT NULL
  • category_name — VARCHAR(255) — NOT NULL

Member

  • member_id — INT — NOT NULL
  • id — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255)
  • birth_date — DATE — NOT NULL
  • reward_points — INT
  • status — VARCHAR(50)
  • marketing_agree — BOOLEAN
  • created_at — TIMESTAMP
  • last_login_at — TIMESTAMP

Order_Item

  • order_item_id — INT — NOT NULL
  • order_id — INT — Foreign key → Order_Master.order_id
  • product_id — INT — Foreign key → Product.product_id
  • quantity — INT — NOT NULL
  • order_price — INT — NOT NULL

Order_Master

  • order_id — INT — NOT NULL
  • member_id — INT — Foreign key → Member.member_id
  • order_date — TIMESTAMP
  • total_price — INT — NOT NULL
  • payment_method — VARCHAR(50) — NOT NULL
  • payment_card_company — VARCHAR(100)
  • payment_installment_months — INT
  • payment_auth_no — VARCHAR(255)
  • status — VARCHAR(50)
  • shipping_company — VARCHAR(100)
  • tracking_number — VARCHAR(255)
  • shipping_address — TEXT — NOT NULL
  • shipping_recipient — VARCHAR(255) — NOT NULL
  • shipping_phone — VARCHAR(255) — NOT NULL

Product

  • product_id — INT — NOT NULL
  • category_id — INT — Foreign key → Category.category_id
  • supplier_id — INT — Foreign key → Supplier.supplier_id
  • name — VARCHAR(255) — NOT NULL
  • unit_price — INT — NOT NULL
  • stock — INT
  • status — VARCHAR(50)
  • specs — TEXT
  • description — TEXT
  • created_at — TIMESTAMP

Recent_View

  • view_id — INT — NOT NULL
  • member_id — INT — Foreign key → Member.member_id
  • product_id — INT — Foreign key → Product.product_id
  • view_date — TIMESTAMP

Review

  • review_id — INT — NOT NULL
  • member_id — INT — Foreign key → Member.member_id
  • product_id — INT — Foreign key → Product.product_id
  • rating — INT — NOT NULL
  • content — TEXT
  • image_url — VARCHAR(255)
  • created_at — TIMESTAMP

Supplier

  • supplier_id — INT — NOT NULL
  • supplier_name — VARCHAR(255) — NOT NULL
  • biz_no — VARCHAR(255)
  • contact — VARCHAR(255)