WeShList

Tables (3)

Product (Products)

  • Product ID (product_id) — LONG — Primary key — NOT NULL
  • Image Name (image_name) — VARCHAR
  • Product Name (name) — VARCHAR
  • Product Price (price) — int
  • Product Brand (brand) — VARCHAR
  • Product Category (category) — VARCHAR
  • Uploader (uploader) — VARCHAR
  • Uploaded Date (uploaded_date) — DATETIME
  • Updater (updator) — VARCHAR
  • Updated Date (updated_date) — DATETIME
  • Positive Point (positive_point) — BIGINT
  • Negative Point (negative_point) — BIGINT

Product Changed Details (OneToMany from Product)

  • Product Detail Key (product_detail_key) — LONG — Primary key — NOT NULL
  • Product ID (Key) — LONG — Foreign key → Product.Product ID — NOT NULL
  • Product Changed Point (changed_point) — VARCHAR
  • Product Before Detail (before_detail) — FLOAT
  • Product After Detail (after_detail) — FLOAT
  • Product Changed Unit (unit) — VARCHAR

User

  • key_id — LONG — Primary key — NOT NULL
  • ID (id) — VARCHAR
  • Password (password) — VARCHAR
  • Name (name) — VARCHAR
  • Nickname (nickname) — VARCHAR
  • Email (email) — VARCHAR
  • Phone Number (tel) — VARCHAR
  • Active Point (point) — INT