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