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)