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