Hazel's Mystic Shop
Tables (16)
Attachment
- F_ID — NOT — Primary key — NOT NULL
- F_NAME — NOT — NOT NULL
- F_LEVEL — NOT — NOT NULL
- F_ENROLL — DATE
- F_STATUS — NOT — NOT NULL
- CHECK(STATUS — IN
Authority
- AUTH_ID — NOT — Primary key — NOT NULL
- AUTH_TYPE — NOT — NOT NULL
- AUTH_ROLE — NOT — NOT NULL
CART
- CART_ID — NOT — Primary key — NOT NULL
- USERID — NOT — NOT NULL
- PRODUCT_ID — NOT — NOT NULL
- CART_QUANTITY — NOT — NOT NULL
- CARTSTATUS — NOT — NOT NULL
- CHECK(STATUS — IN
CATEGORY
- CATEGORYID — NOT — Primary key — NOT NULL
- CATEGORYNAME — NOT — NOT NULL
COUPON
- COUPON_ID — NOT — Primary key — NOT NULL
- USERID — NOT — NOT NULL
- COUPON_NAME — NOT — NOT NULL
- DISCOUNT_RATE — NULL
- DISCOUNT_PRICE — NULL
- COUPON_INFO — NOT — NOT NULL
- COUPON_STATUS — CHECK(STATUS IN ('Y', 'N'))
INVOICE
- INVOICE_ID — NOT — Primary key — NOT NULL
- INVOICE_CODE — NOT — NOT NULL
- INVOICE_COMPANY — NOT — NOT NULL
- INVOICE_ENROLL — SYSDATE
- INVOICE_UPDATE — SYSDATE
Member
- USERID — NOT — Primary key — NOT NULL
- AUTH_ID — NOT — Foreign key → Authority.AUTH_ID — NOT NULL
- PASSWORD — NOT — NOT NULL
- USERNAME — NOT — NOT NULL
- AGE — NOT — NOT NULL
- GENDER — NOT — NOT NULL
- CHECKED(Y, — N)
- EMAIL — NOT — NOT NULL
- PHONE — NOT — NOT NULL
- ADDRESS — NOT — NOT NULL
- ENROLL_DATE — DATE
- LAST_UPDATE — DATE
- MEMBER_STATUS — NOT — NOT NULL
- CHECK(STATUS — IN
- 2FE1 — NOT — NOT NULL
- CHECK(STATUS — IN
ORDER
- ORDER_ID — NOT — Primary key — NOT NULL
- USERID — NOT — NOT NULL
- PRODUCT_ID — NOT — NOT NULL
- TOTAL_PRICE — NOT — NOT NULL
- ORDER_COMMENT — NULL
- ORDER_ENROLL — SYSDATE
- ADDRESSEE — NOT — NOT NULL
- ADDRESS — NOT — NOT NULL
- PHONE — NOT — NOT NULL
PAYMENT
- PRODUCT_ID2 — NOT — Primary key — NOT NULL
- ORDER_ID — NOT — Foreign key → ORDER.ORDER_ID — NOT NULL
PAYMENT_PLAN
- PP_ID — NOT — Primary key — NOT NULL
- PP_PLAN — NOT — NOT NULL
PAY_BANK
- BANK_ID — NOT — Primary key — NOT NULL
- PP_ID — NOT — Foreign key → PAYMENT_PLAN.PP_ID — NOT NULL
- BANK_NAME — NOT — NOT NULL
- BANK_CODE — NOT — NOT NULL
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
PAY_CARD
- PC_ID — NOT — Primary key — NOT NULL
- PP_ID — NOT — Foreign key → PAYMENT_PLAN.PP_ID — NOT NULL
- Field — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field2 — VARCHAR(255)
PRODUCTnutritional
- nutritional — supplement)` — NOT NULL
- CATEGORYID — NOT — NOT NULL
- P_INGRE — NOT — NOT NULL
- P_PRICE — NOT — NOT NULL
- P_NAME — NOT — NOT NULL
- P_INFO — NULL
- P_STOCK — NOT — NOT NULL
- P_ENROLL — SYSDATE
- P_SELL — NOT — NOT NULL
REVIEW
- R_ID — NOT — Primary key — NOT NULL
- R_TITLE — NOT — NOT NULL
- R_CONTENT — NOT — NOT NULL
- R_RANK — NOT — NOT NULL
SHIPMEMT
- SHIP_ID — NOT — Primary key — NOT NULL
- INVOICE_ID — NOT — NOT NULL
- SHIP_NAME — NOT — NOT NULL
- SHIP_ADDRESSEE — NOT — NOT NULL
- SHIP_PHONE — NOT — NOT NULL
- SHIP_ZIPCODE — NOT — NOT NULL
- SHIP_ADDRESS — NOT — NOT NULL
- SHIP_STARTDATE — SYSDATE
- SHIP_ENDDATE — SYSDATE
- SHIP_STATUS — DEFAULT
- N — NULL