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