ㄴㅇㅁㅇㄴ

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 — Foreign key → Member.USERID — 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 — Foreign key → Member.USERID — 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 — Foreign key → Member.USERID — 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 — Foreign key → INVOICE.INVOICE_ID — 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

Untitled

  • EMAIL — NOT — Primary key — NOT NULL
  • USERID — NOT — NOT NULL
  • USERNANE — NOT — NOT NULL
  • AGE — NOT — NOT NULL
  • GENDER — NOT — NOT NULL
  • HEIGHT — NOT — NOT NULL
  • WEIGHT — NOT — NOT NULL
  • ANSWERTYPE — NOT — NOT NULL
  • RESULT1 — NULL
  • RESULT2 — NULL
  • RESULT3 — NULL
  • RESULT4 — NULL