jesan
Tables (7)
inventory
- id — INT
- name — VARCHAR(100) — NOT NULL
- stock — INT — NOT NULL
- unit — VARCHAR(20)
- low_stock_treshold — INT — NOT NULL
- category — VARCHAR(50)
inventory_log
- log_id — INT
- inventory_id — INT
- change_type — VARCHAR(10)
- old_stock — DECIMAL(10,2)
- new_stock — DECIMAL(10,2)
- changed_at — TIMESTAMP
menu
- id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2)
- image — VARCHAR(500)
- category — VARCHAR(50)
- available — TINYINT(1)
- popular — TINYINT(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
order_items
- id — INT
- order_id — INT — NOT NULL
- product_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- quantity — INT — NOT NULL
- total_price — DECIMAL(10,2)
- created_at — TIMESTAMP
orders
- id — INT
- user_id — INT
- firstName — VARCHAR(255)
- lastName — VARCHAR(255)
- phone — VARCHAR(20)
- address — VARCHAR(255)
- barangay — VARCHAR(100)
- city — VARCHAR(100)
- province — VARCHAR(100)
- postal — VARCHAR(10)
- payment_method — ENUM('cash','gcash','card','maya','paypal','cod')
- gcash_ref — VARCHAR(50)
- subtotal — DECIMAL(10,2)
- delivery_fee — DECIMAL(10,2)
- tax — DECIMAL(10,2)
- total — DECIMAL(10,2)
- order_source — ENUM('online','walkin')
- notified — TINYINT(1)
- verified_at — DATETIME
- items — LONGTEXT
- created_at — TIMESTAMP
- status — ENUM('pending','unverified','paid','preparing','ready','delivered','cancelled')
- payment_status — ENUM('pending','unverified','paid','failed','cancelled')
users
- id — INT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('customer','staff','admin') — NOT NULL
- last_login — DATETIME
- last_logout — DATETIME
- created_at — TIMESTAMP