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)