toy-project
Tables (8)
CATEGORY (상품-카테고리)
- CAREGORY_ID (Key) — INT — Primary key — NOT NULL
- NAME (카테고리명)
- PARENT (부모인덱스) — INT
MEMBER (회원)
- ID (Key) — BIGINT — Primary key — NOT NULL
- EMAIL (이메일) — VARCHAR(100)
- PASSWORD (패스워드) — VARCHAR(50)
- NAME (이름) — VARCHAR(10)
- PHONE (휴대폰번호) — VARCHAR(15)
- ROLE (역할) — VARCHAR(10)
- REG_DT (등록일) — DATETIME
- MOD_DT (수정일) — DATETIME
ORDER (주문)
- ORDER_ID (Key) — BIGINT — Primary key — NOT NULL
- MEMBER_ID (회원ID) — BIGINT — Foreign key → MEMBER.ID — NOT NULL
- RCPNT_NAME (이름) — VARCHAR(10)
- RCPNT_ADDRESS (주소) — VARCHAR(100)
- RCPNT_PHONE (휴대폰번호) — VARCHAR(15)
- COMMENTS (요청사항) — VARCHAR(100)
- TOTAL_PRICE (합계금액) — INT
- REG_DT (주문일시) — DATETIME
- MOD_DT (수정일) — DATETIME
ORDER_EVENT (주문 이벤트)
- ORDER_EVENT_ID (Key) — BIGINT — Primary key — NOT NULL
- ORDER_ID (주문아이디) — BIGINT — Foreign key → ORDER.ORDER_ID — NOT NULL
- STATUS_CD (상태코드) — CHAR(3)
- REG_DT (등록시각) — DATETIME
ORDER_EVENT_PAYMENT (주문 결제)
- ORDER_EVENT_PAYMENT_ID (Key) — BIGINT — Primary key — NOT NULL
- ORDER_EVENT_ID (주문이벤트ID) — BIGINT — Foreign key → ORDER_EVENT.ORDER_EVENT_ID — NOT NULL
- METHOD_CD (결제수단코드) — CHAR(3) — 정수 OR 바차
- PAYMENT_PRICE (결제금액) — INT
ORDER_ITEM (주문 상세)
- ORDER_ITEM_ID (Key) — Primary key — NOT NULL
- ORDER_ID (주문ID) — BIGINT — Foreign key → ORDER.ORDER_ID — NOT NULL
- PRODUCT_ID (상품ID) — BIGINT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- PRODUCT_NAME (상품명)
- PRODUCT_PRICE (상품가격)
- PAYMENT_PRICE (결제금액)
- QUANTITY (수량) — INT
- FREE_DELIVERY_YN (무료배송여부)
- DELIVERY_FEE (배송료)
PRODUCT (상품)
- PRODUCT_ID (Key) — BIGINT — Primary key — NOT NULL
- CATEGORY_ID (카테고리ID) — INT — Foreign key → CATEGORY.CAREGORY_ID — NOT NULL
- NAME (상품명) — VARCHAR(100)
- QUANTITY (수량) — INT
- PRICE (가격) — INT
- FREE_DELIVERY_YN (무료배송여부) — VARCHAR(1)
- DELIVERY_FEE (배송료) — INT
- SCORE (평점) — DECIMAL(4,2)
- VIEW_CNT (조회수)
- DEL_YN (삭제여부) — CHAR(1)
- REG_DT (등록일) — DATETIME
- MOD_DT (수정일) — DATETIME
REVIEW (상품평)
- REVIEW_ID (Key) — Primary key — NOT NULL
- MEMBER_ID (회원ID) — BIGINT — Foreign key → MEMBER.ID — NOT NULL
- PRODUCT_ID (상품ID) — BIGINT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- SCORE (점수) — TINYINT
- COMMENTS (평가코멘트) — VARCHAR(300)
- DEL_YN (삭제여부) — CHAR(1)
- REG_DT (등록일) — DATETIME
- MOD_DT (수정일) — DATETIME