JpaProject
Tables (9)
CATAGORY_ITEM (Untitled7)
- category_id (카테고리) — Long — Primary key — NOT NULL
- item_id (아이템) — Long — Primary key — NOT NULL
CATEGORY (Untitled6)
- category_id (카테고리_기본키) — Long — Primary key — NOT NULL
- parent_id (Field) — Long
- name (상품명) — String
COMMENT (Untitled9)
- comment_id (댓글 번호) — Long — Primary key — NOT NULL
- writer (작성자) — String
- Field
DELIVERY (Untitled5)
- delivery_id (배송번호) — Long — Primary key — NOT NULL
- status (배송상태) — enum
- mainAddress (메인주소) — String
- detailAddress (상세주소) — String
ITEM (Untitled4)
- item_id (제품번호) — Long — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
MEMBER (Untitled)
- member_id (회원_기본키) — Long — Primary key — NOT NULL
- id (아이디) — String
- name (이름) — String
- orders (주문내역) — List
- password (비밀번호) — Password
- passwordCheck (비밀번호_확인) — Password
- address (주소) — Address
- email (이메일) — email
ORDERS (Untitled2)
- order_id (주문번호) — Long — Primary key — NOT NULL
- member_id (주문회원) — String
- delivery_id (배송번호)
- orderDate (주문날짜)
- status (Field4)
ORDER_ITEM (Untitled3)
- order_item_id (주문상품_기본키) — Long — Primary key — NOT NULL
- order_id (주문번호) — Long
- item_id (제품번호) — Long
- orderPrice (주문가격) — Int
- count (주문수량) — int
POST (Untitled8)
- post_id (게시물 번호) — Long — Primary key — NOT NULL
- title (제목) — String
- writer (작성자) — String
- writeDate (작성일자)
- modifyDate (수정일자)
- file (파일)
- comment (댓글) — List