Studio

테이블 (9)

Untitled (sc)

  • Key (sc_id) — 기본 키 — NOT NULL
  • Field (sc_text)
  • Key (sc_category_id) — 외래 키 → Untitled.Key — NOT NULL
  • pu_id — 외래 키 → 작품.pu_id — NOT NULL

Untitled (pu_genre)

  • Key (pu_genre_id) — 기본 키 — NOT NULL
  • Field (pu_genre_level)
  • Field (pu_genre_name)
  • Key (parent_pu_genre_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (sc_category)

  • Key (sc_category_id) — 기본 키 — NOT NULL
  • Field (sc_category_level)
  • Field (sc_category_name)
  • Key (parent_sc_category_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (p)

  • Key (p_id) — 기본 키 — NOT NULL
  • Field (p_html)

Untitled (p_sc)

  • Key (p_sc_id) — 기본 키 — NOT NULL
  • Key (sc_id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (p_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (q)

  • Key (q_id) — 기본 키 — NOT NULL
  • Key (p_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (q_cdn_url)
  • Field (a_cdn_url)
  • Field (e_cdn_url)
  • Field (a_exp)
  • Field (a_type)
  • Field2 (organization)
  • Field3 (rg_name)
  • Field4 (yy)
  • Field5 (subject1)
  • Field6 (subject2)
  • Field (group_type)
  • Field (difficulty)
  • Field (curriculum)
  • Field (grade)
  • Field (rel_school)
  • Key (q_category_id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (q_category)

  • Key (q_category_id) — 기본 키 — NOT NULL
  • Field (q_category_level)
  • Field (q_category_name)
  • Key (parent_q_category_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (user)

  • Key (user_id) — 기본 키 — NOT NULL

작품 (pu)

  • pu_id — 기본 키 — NOT NULL
  • Field (pu_era)
  • Field (pu_author)
  • Field (pu_name)
  • Key (pu_genre_id) — 외래 키 → Untitled.Key — NOT NULL