놀리뷰

테이블 (3)

nol_review_comments (Untitled2)

  • id (Key) — int — 기본 키 — NOT NULL
  • content_id (Key2) — int — 외래 키 → nol_review_contents.id — NOT NULL
  • type (Field6) — char
  • created_by_mid (Field) — varchar
  • delete_reason (Field8)
  • contents (Field2) — text
  • attachments (Field7) — varchar
  • created_at (Field5) — datetime
  • updated_at (Field3) — datetime
  • deleted_at (Field4) — datetime

nol_review_contents

  • id — int — 기본 키 — NOT NULL
  • used — char
  • title — varchar
  • brief — text
  • notification_date_at (Field)
  • apply_start_at — datetime
  • apply_end_at — datetime
  • participants_select_start_at — datetime
  • participants_select_end_at — datetime
  • announce_date_at — datetime
  • comment_wrote_start_at — datetime
  • comment_wrote_end_at — datetime
  • contents_type — text
  • thumbnails — text
  • contents — text
  • notice — text
  • created_by_mid — varchar
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

nol_review_notification (Untitled3)

  • id (Key) — int — 기본 키 — NOT NULL
  • content_id (Key2) — int — 외래 키 → nol_review_contents.id — NOT NULL
  • mid (Field) — varchar
  • status (Field3) — char
  • status_message (Field4) — text
  • created_at (Field2) — datetime