webjine

Tables (4)

Article (Untitled)

  • id (Field) — int — Primary key — NOT NULL
  • webjin (웹진 id) — int — Foreign key → Webjine.id — NOT NULL
  • title (제목) — Char — NOT NULL
  • created_at (생성일) — Date — NOT NULL
  • updated_at (수정일) — Date — NOT NULL
  • category (카테고리) — Char — NOT NULL
  • category1 (직접입력용) — Char
  • img (기사 커버 이미지) — Img — NOT NULL
  • bigcategory (대주제) — Char — NOT NULL
  • bigcategory1 (대주제 추가용) — Char
  • writerbox (저자소개) — Char — NOT NULL

Image (Untitled4)

  • id (Field) — int — Primary key — NOT NULL
  • para_pk (문단 id) — int — Foreign key → Param.id — NOT NULL
  • article_pk (기사 id) — int — Foreign key → Param.article_pk — NOT NULL
  • webjin (웹진 id) — int — Foreign key → Param.webjin — NOT NULL
  • img (이미지) — Img — NOT NULL
  • captext (이미지 설명) — Char — NOT NULL

Param (Untitled3)

  • id (Field) — int — Primary key — NOT NULL
  • article_pk (기사 id) — int — Foreign key → Article.id — NOT NULL
  • webjin (웹진 id) — int — Foreign key → Article.webjin — NOT NULL
  • sub_title (문단제목) — Char — NOT NULL
  • content (문단내용) — Text — NOT NULL
  • Img (문단사진) — Img — NOT NULL
  • captext (사진 설명) — Char — NOT NULL

Webjine (Untitled2)

  • id (Field) — int — Primary key — NOT NULL
  • title (제목) — Char — NOT NULL
  • cover_img (표지 사진) — Img — NOT NULL
  • created-at (생성일) — Date — NOT NULL