StoryBoat
Tables (18)
Comment (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)
- id (Key) — UNSIGNED INT — Primary key — NOT NULL
- plot_id (Key2) — UNSIGNED INT — Foreign key → studio_plot.studio_plot_id — NOT NULL
- content (Field) — VARCHAR(255)
history (Untitled3)
- id (Key3) — UNSIGNED INT — Primary key — NOT NULL
- user_id (Key) — UNSIGNED INT — Foreign key → user.id — NOT NULL
- story_id (Key2) — UNSIGNED INT — Foreign key → studio_story.studio_story_id — NOT NULL
- update_at (Field) — TIMESTAMP
profile (CopyOfUntitled3)
- id (Key) — UNSIGNED INT — Primary key — NOT NULL
- user_id (Key2) — UNSIGNED INT — Foreign key → user.id — NOT NULL
- pen_name (Field) — VARCHAR(35)
- introduction (Field2) — TEXT
- image (Field3)
profile_tag (Untitled6)
- id (Key4) — Primary key — NOT NULL
- profile_id (Key) — UNSIGNED INT — Foreign key → profile.id — NOT NULL
- tag_id (Key3) — UNSIGNED INT — Foreign key → tag.id — NOT NULL
studio (CopyOfUntitled)
- studio_id (Key) — UNSIGNED INT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- description (Field2) — TEXT
studio_character (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled222)
- studio_character_id (Key) — UNSIGNED INT — Primary key — NOT NULL
- studio_id (Key2) — UNSIGNED INT — Foreign key → studio.studio_id — NOT NULL
- name (Field2) — VARCHAR(45)
- discription (Field3) — TEXT
studio_idea (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled222)
- studio_idea_id (Key) — UNSIGNED_INT — Primary key — NOT NULL
- studio_id (Key3) — UNSIGNED_INT — Foreign key → studio.studio_id — NOT NULL
- title (Field) — VARCHAR(50)
- content (Field2) — TEXT
studio_plot (CopyOfCopyOfUntitled22)
- studio_plot_id (Key) — UNSIGNED INT — Primary key — NOT NULL
- story_id (Key2) — UNSIGNED INT — Foreign key → studio_story.studio_story_id — NOT NULL
- prevent_id (Key3) — UNSIGNED INT — Foreign key → studio_plot.studio_plot_id — NOT NULL
- description (Field4) — TEXT
- depth (Field) — UNSIGNED INT
- x, y (Field2) — String
- manuscript (Field5) — TEXT
- is_main (Field6) — TINYINT
studio_story (CopyOfUntitled2)
- studio_story_id (Key) — UNSIGNED INT — Primary key — NOT NULL
- studio_id (Key2) — UNSIGNED INT — Foreign key → studio.studio_id — NOT NULL
- name (Field) — VARCHAR(50)
studio_tag (Untitled5)
- id (Key3) — UNSIGNED INT — Primary key — NOT NULL
- studio_id (Key) — Foreign key → studio.studio_id — NOT NULL
- tag_id (Key2) — UNSIGNED INT — Foreign key → tag.id — NOT NULL
studio_user (Untitled2)
- studio_id (Key) — Foreign key → studio.studio_id — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- role (Field)
tag (Untitled4)
- id (Key) — UNSIGNED INT — Primary key — NOT NULL
- name (Field) — VARCHAR(20)
token (Untitled7)
- id (Key) — UNSIGNED INT — Primary key — NOT NULL
- user_id (Key2) — UNSIGNED INT — Foreign key → user.id — NOT NULL
- refresh (Field) — VARCHAR(50)
- expiry_date (Field2) — TIMESTAMP
user (Untitled)
- id (Key) — UNSIGNED INT — Primary key — NOT NULL
- email_id (Field) — VARCHAR(35)
- email_domain (Field2) — VARCHAR(25)
- provider_id (Field3) — VARCHAR(50)
- provider (Field4) — VARCHAR(16)
user_character (CopyOfCopyOfCopyOfCopyOfUntitled22)
- id (Key) — UNSIGNED INT — Primary key — NOT NULL
- user_id (Key2) — UNSIGNED INT — Foreign key → user.id — NOT NULL
- name (Field2) — VARCHAR(45)
- discription (Field3) — TEXT
user_idea (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)
- id (Key) — UNSIGNED_INT — Primary key — NOT NULL
- user_id (Key2) — UNSIGNED_INT — Foreign key → user.id — NOT NULL
- title (Field) — VARCHAR(50)
- content (Field2) — TEXT
user_plot (CopyOfCopyOfCopyOfUntitled222)
- id (Key) — UNSIGNED INT — Primary key — NOT NULL
- story_id (Key22) — UNSIGNED INT — Foreign key → user_story.user_id — NOT NULL
- prevent_id (Key2) — UNSIGNED INT — Foreign key → user_plot.id — NOT NULL
- content (Field4) — TEXT
- depth (Field) — UNSIGNED INT
- x (Field2) — DOUBLE
- y (Field3) — DOUBLE
- manuscript (Field5) — TEXT
- is_main (Field6) — TINYINT
user_story (CopyOfCopyOfUntitled2)
- id (Key) — UNSIGNED INT — Primary key — NOT NULL
- user_id (Key2) — UNSIGNED INT — Foreign key → user.id — NOT NULL
- name (Field) — VARCHAR(50)