shop

Tables (9)

COMMENT (Untitled9)

  • conmment_id (Key) — Long — Primary key — NOT NULL
  • content (댓글 내용) — String
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • post_id (Key2) — Long — Foreign key → POST.post_id — NOT NULL

POST (Untitled8)

  • post_id (Key) — Long — Primary key — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • Field
  • member_id — LONG — Foreign key → member.member_id — NOT NULL

cart (Untitled2)

  • cart_id — LONG — Primary key — NOT NULL
  • member_id (member_id2) — LONG — Foreign key → member.member_id — NOT NULL

cart_item (Untitled3)

  • cart_item_id — LONG — Primary key — NOT NULL
  • count (수량) — INT
  • cart_id (cart_id2) — LONG — Foreign key → cart.cart_id — NOT NULL
  • item_id (item_id2) — LONG — Foreign key → item.item_id — NOT NULL

item (Untitled4)

  • item_id — LONG — Primary key — NOT NULL
  • item_nm (아이템명) — STRING
  • price (가격) — INT
  • stock_number (재고수량) — INT
  • item_detail (상세설명) — STRING
  • item_sell_status (Field5) — ENUM
  • order_item_id — LONG — Foreign key → order_item.order_item_id — NOT NULL
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime

item_img (Untitled7)

  • item_img_id — LONG — Primary key — NOT NULL
  • img_name (이미지 이름) — STRING
  • ori_img_name (원본 이미지 파일명) — STRING
  • img_url (이미지 조회 경로) — STRING
  • rep_img_yn (대표 이미지 여부) — STRING
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • item_id — LONG — Foreign key → item.item_id — NOT NULL

member (Untitled)

  • member_id — LONG — Primary key — NOT NULL
  • name (이름) — STRING
  • email (이메일) — STRING
  • password (비밀번호) — STRING
  • address (주소) — STRING
  • role (권한) — ENUM

order_item (Untitled6)

  • order_item_id — LONG — Primary key — NOT NULL
  • order_price (주문가격) — INT
  • count (수량) — INT
  • order_id — LONG — Foreign key → orders.order_id — NOT NULL

orders (Untitled5)

  • order_id — LONG — Primary key — NOT NULL
  • order_date (주문일) — LocalDateTime
  • order_status (주문상태) — ENUM
  • member_id — LONG — Foreign key → member.member_id — NOT NULL
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime