project1

Tables (7)

category

  • id — INT
  • name — VARCHAR(100) — NOT NULL

customer

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • address1 — VARCHAR(200)
  • zipcode — INT
  • created_at — TIMESTAMP

friend

  • id — INT
  • customer_id1 — INT — NOT NULL
  • customer_id2 — INT — NOT NULL
  • status — ENUM('pending', 'accepted', 'blocked')
  • created_at — TIMESTAMP

orders

  • id — INT
  • product_id — INT — NOT NULL
  • customer_id — INT — NOT NULL
  • friend_id — INT
  • total_price — INT — NOT NULL
  • created_at — TIMESTAMP
  • status — ENUM('pending', 'paid', 'shipped', 'delivered', 'cancelled')
  • posted — INT

product

  • id — INT
  • store_id — INT — NOT NULL
  • category_id — INT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL
  • stock — INT — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • picture — VARCHAR(50)
  • recommend — INT — NOT NULL
  • discount_start — DATETIME
  • discount_end — DATETIME
  • discount_percentage — DECIMAL(5,2)

seller

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP

store

  • id — INT
  • seller_id — INT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • address1 — VARCHAR(200)
  • zipcode — VARCHAR(7)
  • created_at — TIMESTAMP