DD
Tables (6)
CART
- CART_ID — INT — Primary key — NOT NULL
- PRODUCT_ID — INT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- CART_QUANTITY — INT — NOT NULL
- USER_ID (USER_ID2) — VARCHAR(255) — Foreign key → MEMBER.USER_ID — NOT NULL
CATEGORY
- CATEGORY_ID — INT — Primary key — NOT NULL
- CATEGORYNAME — VARCHAR(255) — NOT NULL
MEMBER
- USER_ID — VARCHAR(255) — Primary key — NOT NULL
- AUTH_TYPE — CHAR(1) — NOT NULL
- PASSWORD — VARCHAR(255) — NOT NULL
- USERNAME — VARCHAR(255) — NOT NULL
- AGE — INT — NOT NULL
- GENDER — CHAR(1) — NOT NULL
- EMAIL — VARCHAR(255) — NOT NULL
- PHONE — VARCHAR(255) — NOT NULL
- ADDRESS — VARCHAR(255) — NOT NULL
ORDER
- ORDER_ID — INT — Primary key — NOT NULL
- PRODUCT_ID — INT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- TOTAL_PRICE — INT — NOT NULL
- ORDER_COMMENT — TEXT
- ORDER_ENROLL — DATETIME
- RECIPIENT — VARCHAR(255) — NOT NULL
- O_ADDRESS (ADDRESS) — VARCHAR(255) — NOT NULL
- O_PHONE (PHONE) — VARCHAR(255) — NOT NULL
- USER_ID (USER_ID2) — VARCHAR(255) — Foreign key → MEMBER.USER_ID — NOT NULL
PRODUCT
- PRODUCT_ID — INT — Primary key — NOT NULL
- CATEGORY_ID — INT — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
- P_PRICE — INT — NOT NULL
- P_NAME — VARCHAR(255) — NOT NULL
- P_INFO — TEXT
- P_STOCK — INT — NOT NULL
- P_ENROLL — DATETIME
- P_SELL — INT — NOT NULL
REVIEW
- R_ID — INT — Primary key — NOT NULL
- PRODUCT_ID — INT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- R_TITLE — VARCHAR(255) — NOT NULL
- R_CONTENT — TEXT — NOT NULL
- R_RANK — INT — NOT NULL