character

Tables (10)

Character (Untitled10)

  • id (Key) — int — Primary key — NOT NULL
  • view_count (Field) — bigint
  • chat_count (Field2) — int
  • created_at (Field3)

additional_video (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → character.id — NOT NULL
  • title (Field) — varchar
  • video (Field2) — varchar
  • thumbnail (Field3) — varchar
  • running_time (Field4) — int
  • language (Field5) — varchar

character (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • gender (Field) — enum
  • created_at (Field2) — datetime
  • priority (Field4) — int
  • available (Field6) — enum
  • view_count (Field3) — bigint
  • chat_count (Field5) — int

character_description (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → character.id — NOT NULL
  • language (Field) — varchar
  • content (Field2) — varchar

character_language (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → character.id — NOT NULL
  • voice (Field) — varchar
  • subtitle (Field2) — varchar

character_media (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → character.id — NOT NULL
  • main_image (Field) — varchar
  • face_image (Field2) — varchar
  • detail_video (Field3) — varchar
  • dummy_chat_video (Field4) — varchar
  • background_music (Field5) — varchar

character_name (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → character.id — NOT NULL
  • language (Field) — varchar
  • name (Field2) — varchar

general_media (Untitled9)

  • id (Key) — bigint — Primary key — NOT NULL
  • join (Field) — varchar
  • withdrawal (Field2) — varchar
  • app_version ?????? (Field3) — varchar

popup (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • type (Field) — enum
  • active (Field2) — boolean

popup_media (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — bigint — Foreign key → popup.id — NOT NULL
  • language (Field) — varchar
  • uri (Field2) — varchar