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