nootbew

Tables (8)

Author (author)

  • author_id (id) — CHAR(7) — Primary key — NOT NULL
  • name
  • description
  • reg_at — TIMESTAMP

AuthorToons (author_toons)

  • author_id (id2) — CHAR(7) — Foreign key → Author.author_id — NOT NULL
  • toon_id (id) — CHAR(8) — Foreign key → Toon.toon_id — NOT NULL

Episode (toon_episode)

  • toon_episode_id (id) — CHAR(4) — Primary key — NOT NULL
  • toon_id — CHAR(8) — Foreign key → Toon.toon_id — NOT NULL
  • reg_at — TIMESTAMP

Index (Untitled2)

  • toon_episode_id (id) — CHAR(4) — Foreign key → Episode.toon_episode_id — NOT NULL
  • view_count
  • star_count

Like (Untitled)

  • toon_id (id) — CHAR(8) — Foreign key → Toon.toon_id — NOT NULL
  • count

Scene (toon_episode_scene)

  • toon_episode_cut_id (id) — SMALLINT(2) — Primary key — NOT NULL
  • toon_episode_id — CHAR(4) — Foreign key → Episode.toon_episode_id — NOT NULL
  • cut_url

Toon (toon)

  • toon_id (id) — CHAR(8) — Primary key — NOT NULL
  • status — TINYINT(1)
  • restricted _type — TINYINT(1)
  • name — VARCHAR(50)
  • description — VARCHAR(500)
  • thumbnail — VARCHAR(50)
  • day_of_week — TINYINT(1)
  • reg_at — TIMESTAMP

ToonInfo (toon_info)

  • updated_at
  • popularity
  • view_count
  • star_count