dataERD

테이블 (9)

결제 (PAYMENT)

  • PRODUCT_ID2 — NOT — 기본 키 — NOT NULL
  • ORDER_ID — NOT — 외래 키 → 주문.ORDER_ID — NOT NULL

권한 (Authority)

  • AUTH_ID — NOT NULL, UNIQUE — 기본 키 — NOT NULL
  • AUTH_NAME (AUTH_TYPE) — NOT NULL — NOT NULL
  • AUTH_ROLE — NOT NULL — NOT NULL

리뷰 (REVIEW)

  • R_ID — NOT — 기본 키 — NOT NULL
  • R_TITLE — NOT — NOT NULL
  • R_CONTENT — NOT — NOT NULL
  • R_RANK — NOT — NOT NULL

상품 (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

장바구니 (CART)

  • CART_ID — NOT — 기본 키 — NOT NULL
  • USERID — NOT — NOT NULL
  • PRODUCT_ID — NOT — NOT NULL
  • CART_QUANTITY — NOT — NOT NULL
  • CARTSTATUS — NOT — NOT NULL
  • CHECK(STATUS — IN

주문 (ORDER)

  • ORDER_ID — NOT — 기본 키 — 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

첨부파일 (Attachment)

  • F_ID — NOT — 기본 키 — NOT NULL
  • F_NAME — NOT — NOT NULL
  • F_LEVEL — NOT — NOT NULL
  • F_ENROLL — DATE
  • F_STATUS — NOT — NOT NULL
  • CHECK(STATUS — IN

카테고리 (CATEGORY)

  • CATEGORYID — NOT — 기본 키 — NOT NULL
  • CATEGORYNAME — NOT — NOT NULL

회원 (Member)

  • USERID — NOT — 기본 키 — NOT NULL
  • AUTH_ID — NOT — 외래 키 → 권한.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