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