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