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