놀리뷰
테이블 (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