test

Tables (3)

product (Untitled3)

  • id (커머스) (Key) — Primary key — NOT NULL
  • name (Field2)
  • thumbnail (Field3)
  • created_date (작성일자)
  • last_modified_date (마지막수정일자)
  • deleted_date (삭제일자)

review (Untitled)

  • id (Key) — Primary key — NOT NULL
  • channel (채널)
  • content (내용)
  • rating (별점)
  • option (Field) — json[]
  • store_id(커머스) (스토어Id)
  • order_id(커머스) (주문Id) — Nullable
  • item_id(커머스) (주문품목id) — Nullable
  • user_id(커머스) (주문자id) — Nullable
  • author_id (작성자아이디)
  • author_email (작성자이메일)
  • created_date (작성일자)
  • last_modified_date (마지막수정일자)
  • deleted_date (삭제일자) — Nullable

review-product (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • review_id (리뷰ID)
  • product_id (상품ID)
  • created_date (작성일자)
  • last_modified_date (마지막수정일자)
  • deleted_date (삭제일자)