Final Project
Tables (16)
activity_log
- PK (id) — integer — Primary key — NOT NULL
- PK (id2) — integer — Foreign key → user.PK — NOT NULL
- Field (log_date) — text
- Field2 (activity) — text
- Field (result) — text
- ip_address — text
- create_on — text
- create_by — integer
- change_on — text
- change_by — integer
cpu
- cpu_id (id) — integer — Primary key — NOT NULL
- Field (manufacturing) — text
- Field (clock) — integer
- is_delete — integer
- FK (item_id) — integer — Foreign key → item.PK — NOT NULL
customer
- PK (id) — integer — Primary key — NOT NULL
- create_on — text
- create_bh (create_by) — integer
- change_on — text
- change_by — integer
- PK (user_id) — Integer — Foreign key → user.PK — NOT NULL
delivery
- Key (id) — integer — Primary key — NOT NULL
- status — text
- city — text
- street — text
- zipcode — text
- create_on — text
- create_by — integer
- change_on — text
- change_by — integer
error
- PK (id) — integer — Primary key — NOT NULL
- PK (user_id) — integer — Foreign key → user.PK — NOT NULL
- Field (error_date) — text
- Field2 (message) — text
- Field3 (exception) — text
- Field4 (ip_address) — text
- Field5 (create_on) — text
- Field6 (create_by) — integer
- change_on — text
- change_by — integer
gpu
- gpu_id (id) — integer — Primary key — NOT NULL
- Field (manufacturing) — text
- is_delete — integer
- PK (item_id) — integer — Foreign key → item.PK — NOT NULL
history
- PK (id) — integer — Primary key — NOT NULL
- PK (user_id) — integer — Foreign key → user.PK — NOT NULL
- Field (history_date) — text
- Field2 (what) — text
- Field3 (what_id) — integer
- Field4 (name) — text
- Field5 (operation) — text
- Field6 (content) — text
- Field (undodate) — text
- create_on — text
- create_by — integer
- change_on — text
- change_by — integer
item
- PK (id) — integer — Primary key — NOT NULL
- price (Field) — integer
- dtype (category_id) — integer — Foreign key → item_category.Key — NOT NULL
- create_on — text
- create_by — integer
- change_on — text
- change_by — integer
- is_delete — integer
- PK (seller_id) — integer — Foreign key → seller.PK — NOT NULL
- stock — integer
- Field2 (name) — text
item_category
- Key (id) — integer — Primary key — NOT NULL
- component_name (name) — text
- description — text
- create_on — text
- create_by — integer
- change_on — text
- change_by — integer
memory
- memory_id (id) — integer — Primary key — NOT NULL
- Field (manufacturing) — text
- Field (latency) — integer
- is_delete — integer
- PK (item_id) — integer — Foreign key → item.PK — NOT NULL
order
- PK (id) — integer — Primary key — NOT NULL
- FK (customer_id) — integer — Foreign key → customer.PK — NOT NULL
- Key (delivery_id) — integer — Foreign key → delivery.Key — NOT NULL
- Key (payment_id) — integer — Foreign key → payment.Key — NOT NULL
- create_on — text
- create_by (integer) — integer
- change_on — text
- change_by — integer
- is_delete — integer
orderItem (order_item)
- Key — integer — Primary key — NOT NULL
- order_id — integer — Foreign key → order.PK — NOT NULL
- item_id — integer — Foreign key → item.PK — NOT NULL
- count — integer
- price (Field) — integer
- create_on — text
- create_by — integer
- change_on — text
- change_by — integer
- is_delete — integer
payment
- Key (id) — integer — Primary key — NOT NULL
- payment_method (payment) — integer
- discount_amount (discount) — integer
- create_on — text
- create_by — integer
- change_on — text
- change_by — integer
power
- power_id (id) — integer — Primary key — NOT NULL
- Field (manufacturing) — text
- Field (wattage) — integer
- is_delete — integer
- PK (item_id) — integer — Foreign key → item.PK — NOT NULL
seller
- PK (id) — integer — Primary key — NOT NULL
- create_on — text
- create_by — integer
- change_on — text
- change_by — integer
- PK (user_id) — Integer — Foreign key → user.PK — NOT NULL
user
- PK (id) — Integer — Primary key — NOT NULL
- user_name (name) — text
- user_address (address) — text
- user_telnum (telnum) — string
- EnrollDate (enroll_date) — text
- create_on — text
- create_by — integer
- change_on — text
- change_by — integer