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