moseory
moseory erd
Tables (12)
high_category (상위 카테고리)
- code (상위카테고리코드) — varchar2(50) — Primary key — NOT NULL
- name (상위카테고리이름) — varchar2(50) — NOT NULL
low_category (하위 카테고리)
- code (하위카테고리코드) — varchar2(50) — Primary key — NOT NULL
- high_code (상위카테고리코드) — varchar2(50) — Foreign key → high_category.code — NOT NULL
- name (하위카테고리이름) — varchar2(50) — NOT NULL
member (회원)
- id (회원ID) — varchar2(50) — Primary key — NOT NULL
- password (비밀번호) — varchar2(50) — NOT NULL
- name (이름) — varchar2(50) — NOT NULL
- password_check (비밀번호 확인 답변) — varchar2(255) — NOT NULL
- zipcode (우편번호) — varchar2(50) — NOT NULL
- address1 (주소1) — varchar2(255) — NOT NULL
- address2 (주소2) — varchar2(255) — NOT NULL
- phone (핸드폰번호) — varchar2(20) — NOT NULL
- email (이메일) — varchar2(255) — NOT NULL
- joindate (가입일) — date
- point (적립금) — number
- amount (총구매금액) — number
- enabled (계정 사용 가능 여부) — char(1) — NOT NULL
order (주문)
- no (주문번호) — number — Primary key — NOT NULL
- member_id (회원ID) — varchar2(50) — Foreign key → member.id — NOT NULL
- order_date (주문일자) — date — NOT NULL
- delivery_charge (배송비) — number — NOT NULL
- state (주문상태) — varchar2(30) — NOT NULL
order_detail (주문 상세 정보)
- order_no (주문번호) — number — Foreign key → order.no — NOT NULL
- product_detail_no (상품 상세 정보 번호) — number — Foreign key → product_detail.no — NOT NULL — auto_increment
- amount (상품 결제 금액) — number — NOT NULL
- discount (할인 금액) — number — NOT NULL
- point (적립 금액) — number
- quantity (수량) — number — NOT NULL
product (상품)
- code (상품코드) — varchar2(50) — Primary key — NOT NULL
- name (상품명) — varchar2(250) — NOT NULL
- price (상품가격) — number — NOT NULL
- cell_count (상품 판매량) — number — NOT NULL
- wish_count (관심 상품 등록 개수) — number — NOT NULL
- grade_avg (평균 평점) — number(1,1) — NOT NULL
- high_code (상위카테고리코드) — varchar2(50) — Foreign key → high_category.code — NOT NULL
- low_code (하위카테고리코드) — varchar2(50) — Foreign key → low_category.code — NOT NULL
product_detail (상품 상세 정보)
- no (상품 상세 정보 번호) — number — Primary key — NOT NULL — auto_increment
- product_code (상품코드) — varchar2(50) — Foreign key → product.code — NOT NULL
- product_color (상품 색상) — varchar2(50)
- product_size (상품 사이즈) — varchar2(50)
- stock (재고) — number — NOT NULL
qna (Q&A)
- no (Q&A 번호) — number — Primary key — NOT NULL — auto_increment
- product_code (상품코드) — varchar2(50) — Foreign key → product.code
- subject (제목) — varchar2(250) — NOT NULL
- content (내용) — varchar2(2000) — NOT NULL
- writer (작성자) — varchar2(50) — NOT NULL
- regdate (작성일) — date — NOT NULL
- ucc_url (UCC URL) — varchar2(500)
- password (비밀번호) — varchar2(50) — NOT NULL — 글과 답글 조회, 수정, 삭제 시 필요한 비밀번호
- seceret (공개/비공개) — boolean — NOT NULL
- hit (조회수) — number — NOT NULL
- reply_count (댓글수) — number — NOT NULL
- group (원글 그룹) — number — NOT NULL
- depth (글 단계) — number — NOT NULL
- step (글순서) — number — NOT NULL
- pseq (원글 번호) — number — NOT NULL
- answer (답글개수) — number — NOT NULL
qna_reply (Q&A 댓글)
- no (댓글 번호) — number — Primary key — NOT NULL — auto_increment
- qna_no (Q&A 번호) — number — Foreign key → qna.no — NOT NULL — auto_increment
- writer (댓글 작성자) — varchar2(50) — NOT NULL
- reply (댓글) — varchar2(2000) — NOT NULL
- password (비밀번호) — varchar2(50) — NOT NULL — 댓글 수정, 삭제시 필요한 비밀번호
- regdate (작성일) — date — NOT NULL
review (리뷰)
- no (리뷰 번호) — number — Primary key — NOT NULL — auto_increment
- product_code (상품코드) — varchar2(50) — Foreign key → product.code — NOT NULL
- member_height (신장) — varchar2(10)
- member_weight (몸무게) — varchar2(10)
- content (내용) — varchar2(2000) — NOT NULL
- file_path (첨부파일) — varchar2(500)
- writer (작성자) — varchar2(50) — NOT NULL
- regdate (작성일) — date — NOT NULL
- grade (평점) — number — NOT NULL
- hit (조회수) — number — NOT NULL
- reply_count (댓글 개수) — number — NOT NULL
- like_count (좋아요 개수) — number — NOT NULL
shopping_cart (장바구니)
- no (장바구니 번호) — number — Primary key — NOT NULL — auto_increment
- member_id (회원ID) — varchar2(50) — Foreign key → member.id — NOT NULL
- product_detail_no (상품 상세 정보 번호) — number — Foreign key → product_detail.no — NOT NULL — auto_increment
- quantity (수량) — number — NOT NULL
wish_list (관심상품)
- member_id (회원ID) — varchar2(50) — Foreign key → member.id — NOT NULL
- product_code (상품코드) — varchar2(50) — Foreign key → product.code — NOT NULL