XRMeta Review
Tables (4)
contents (리뷰대상컨텐츠)
- id (컨텐츠ID) — int — Primary key — NOT NULL
review (리뷰)
- id (리뷰ID) — int — Primary key — NOT NULL — 리뷰ID
- contents_id (컨텐츠ID) — int — Foreign key → contents.id — NOT NULL — 컨텐츠ID
- contents_type (컨텐츠 종류) — char
- user_id (사용자ID) — varchar
- title (리뷰제목) — varchar
- content (리뷰 내용) — varchar
- score (평점) — int
- tags (태그) — varchar
- delyn (삭제여부) — char
- crdt (생성일시) — timestamp
- updt (수정일시) — timestamp
review_file (리뷰 업로드파일)
- id (파일ID) — int — Primary key — NOT NULL
- review_id (리뷰ID) — int — Foreign key → review.id — NOT NULL
- file_name (파일명) — varchar
- file_path (파일경로) — varchar
- file_size (파일사이즈) — int
- file_extension (파일확장자) — varchar
- delyn (삭제여부) — char
- crdt (생성일) — timestamp
- updt (수정일시) — timestamp
review_like (리뷰 좋아요)
- review_id (리뷰ID) — int — Foreign key → review.id — NOT NULL — 리뷰ID
- user_id (사용자ID) — varchar