review

Tables (6)

freelancer_review (CopyOfUntitled)

  • id (클라이언트리뷰id) — long — Primary key — NOT NULL
  • service_id (서비스id) — long — Foreign key → service_review.service_id — NOT NULL
  • Key — long — Foreign key → service_review.order_id — NOT NULL
  • content (Field) — text

member (Untitled2)

  • Key — Primary key — NOT NULL

order (Untitled4)

  • Key — Primary key — NOT NULL

review_image (Untitled5)

  • id (이미지id) — long — Primary key — NOT NULL
  • id (리뷰id) — long — Foreign key → service_review.id — NOT NULL
  • image_url (Field) — varchar

service (Untitled3)

  • Key — Primary key — NOT NULL

service_review (Untitled)

  • id (리뷰id) — long — Primary key — NOT NULL
  • member_id (고객id) — long — Foreign key → member.Key — NOT NULL
  • service_id (서비스id) — long — Foreign key → service.Key — NOT NULL
  • order_id (실제제품id) — long — Foreign key → order.Key — NOT NULL
  • content (리뷰내용) — text
  • rating (별점) — float
  • status (공개 여부) — enum
  • report_count (신고횟수) — int