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