한입만
테이블 (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