eatnjoy

Tables (9)

Cart (tbl_cart)

  • Member Id (uId) — VARCHAR(50) — Foreign key → Member.Member Id — NOT NULL
  • Product Id (pId) — INT(4) — Foreign key → Product.Product Id — NOT NULL
  • Total Price (oTotalPrice) — INT(12)
  • Quantity (amount) — INT(5)

Member (tbl_member)

  • Member Id (uId) — VARCHAR(50) — Primary key — NOT NULL
  • Member Password (uPwd) — VARCHAR(50)
  • Name (uName) — VARCHAR(30)
  • Email (uEmail) — VARCHAR(50)
  • Phone Number (uPhon) — VARCHAR(11)
  • Zip Code (uZip) — VARCHAR(5)
  • Address (uAddr) — VARCHAR(50)
  • Rest Address (uAddrs) — VARCHAR(50)
  • Register Date (uRegDate) — DATE
  • Update Date (uUpdateDate) — DATE
  • Birthday (uBirth) — DATE
  • Gender (uGender) — CHAR(1)
  • Verification (verified) — CHAR(1)
  • Receive SMS (rSMS) — CHAR(1)
  • Receive Email (rEmail) — CHAR(1)

Notice (tbl_notice)

  • Notice Id (nId) — INT(4) — Primary key — NOT NULL
  • Title (nTitle) — VARCHAR(100)
  • Content (nContent) — VARCHAR(400)
  • Writer (nWriter) — VARCHAR(50)
  • Register Date (nRegDate) — DATE
  • Update Date (nUpdateDate) — DATE

Order (tbl_order)

  • Order Id (oId) — INT(10) — Primary key — NOT NULL
  • Member Id (uId2) — VARCHAR(50) — Foreign key → Cart.Member Id — NOT NULL
  • Product Id (pId) — INT(4) — Foreign key → Cart.Product Id — NOT NULL
  • Order Date (oDate) — DATE
  • Order State (oState) — INT(1)

Order Detail (tbl_Orderdetail)

  • Order Id (oId) — INT(10) — Foreign key → Order.Order Id — NOT NULL
  • Member Id (uId2) — VARCHAR(50) — Foreign key → Order.Member Id — NOT NULL
  • Product Id (pId) — INT(4) — Foreign key → Order.Product Id — NOT NULL
  • Name (uName) — VARCHAR(30)
  • Phone Number (uPhon) — VARVHAR(11)
  • Address (uAddr) — VARCHAR(50)
  • Rest Address (uAddrs) — VARCHAR(50)
  • Total Price (oTotalPrice) — INT(12)
  • Quantity (amount) — INT(5)

Product (tbl_product)

  • Product Id (pId) — INT(4) — Primary key — NOT NULL
  • Name (pName) — VARCHAR(50)
  • Description (pDesc) — VARCHAR(500)
  • Price (pPrice) — INT(100)
  • Register Date (pRegDate) — DATE
  • Update Date (pUpdateDate) — DATE
  • View Count (hit) — INT(10)
  • Category Code (pCateCode) — INT(3) — Foreign key → Product Category.Category Code — NOT NULL

Product Attach (tbl_pattach)

  • Uuid Name (uuid) — VARCHAR(100) — Primary key — NOT NULL
  • Product Id (pId) — INT(4) — Foreign key → Product.Product Id — NOT NULL
  • File Name (fileName) — VARCHAR(100)
  • File Type (fileType) — CHAR(1)
  • Upload Path (uploadPath) — VARCHAR(200)

Product Category (tbl_pcategory)

  • Category Code (pCateCode) — INT(3) — Primary key — NOT NULL
  • Name (pCateName) — VARCHAR(20)
  • Parent Code (parentCode) — INT(3)

Product Reply (tbl_preply)

  • Reply Id (rId) — INT(10) — Primary key — NOT NULL
  • Product Id (pId1) — INT(4) — Foreign key → Product.Product Id — NOT NULL
  • Writer (rWriter) — VARCHAR(50)
  • Title (rTitle) — VARCHAR(100)
  • Content (rContent) — VARCHAR(500)
  • Register Date (rRegDate) — DATE
  • Update Date (rUpdateDate) — DATE
  • View Count (rHit) — INT(10)