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