한입만

테이블 (3)

TB_CART (CART)

  • USER_ID (회원아이디2) — VARCHAR2(30) — 외래 키 → TB_MEMBER.USER_ID
  • RCP_ITEM_NUMBER (재료품번2) — VARCHAR2(30) — 외래 키 → TB_RECIPE.RCP_ITEM_NUMBER — NOT NULL
  • C_IDX (장바구니) — VARCHAR2(30)
  • USER_ID (회원아이디) — VARCHAR2(30)
  • USER_PRICE (회원제품가격) — NUMBER
  • RCP_ITEM_NUMBER (재료품번) — VARCHAR2(30)
  • ITEM_DATE (물품등록일자) — DATE
  • ITEM_CNT (수량) — NUMBER

TB_MEMBER (USER)

  • USER_ID (회원아이디) — VARCHAR2(30) — 기본 키
  • PASSWORD (비밀번호) — VARCHAR2(30)
  • USER_NAME (회원이름) — VARCHAR2(30)
  • BIRTH (생년월일) — DATE — NOT NULL
  • Field3 (전화번호) — VARCHAR2(30)
  • GRADE (회원등급) — CHAR(4)
  • EMAIL (이메일) — VARCHAR2(30)
  • GENDER (성별) — VARCHAR2(30)
  • IS_LEAVE (회원탈퇴여부) — NUMBER

TB_RECIPE (RECIPE)

  • RCP_ITEM_NUMBER (재료품번) — VARCHAR2(30) — 기본 키 — NOT NULL
  • RCP_TITLE (제목) — VARCHAR2(30)
  • RCP_PRICE (가격) — NUMBER
  • RCP_CNT (재고갯수) — NUMBER