TrickcalSite

Tables (20)

BackStory (Untitled16)

  • id (Key) — Integer — Primary key — NOT NULL
  • pre_story_id (Key2) — Integer — Foreign key → Story.id — NOT NULL
  • post_story_id (Key22) — Integer — Foreign key → Story.season_id — NOT NULL

Character (Untitled10)

  • id (Key) — Inteer — Primary key — NOT NULL
  • personality_id (Key2) — Integer — Foreign key → Personality.id — NOT NULL
  • species_id (Key3) — Integer — Foreign key → Species.id — NOT NULL

CharacterNote (Untitled12)

  • id (Key) — Integer — Primary key — NOT NULL
  • character_id (Key2) — Inteer — Foreign key → Character.id — NOT NULL
  • member_id (Key3) — Integer — Foreign key → Member.id — NOT NULL
  • id (Key22) — Integer — Foreign key → Member.streamer_id — NOT NULL

Member (Untitled)

  • id (Key) — Integer — Primary key — NOT NULL
  • streamer_id (Key2) — Integer — Foreign key → Streamer.id — NOT NULL
  • username (Field) — String
  • nickname (Field2) — String
  • password (Field3) — String

Personality (Untitled11)

  • id (Key) — Integer — Primary key — NOT NULL

Post (Untitled2)

  • id (Key) — Integer — Primary key — NOT NULL
  • author_id (Key2) — Integer — Foreign key → Member.id — NOT NULL
  • post_category_id (Key3) — Integer — Foreign key → PostCategory.id — NOT NULL

PostCategory (Untitled5)

  • id (Key) — Integer — Primary key — NOT NULL

PostComment (Untitled4)

  • id (Key2) — Integer — Primary key — NOT NULL
  • post_id (Key) — Integer — Foreign key → Post.id — NOT NULL

PostCommentRecommend (Untitled6)

  • id (Key) — Integer — Primary key — NOT NULL
  • member_id (Key2) — Integer — Foreign key → Member.id — NOT NULL
  • post_comment_id (Key22) — Integer — Foreign key → PostComment.id — NOT NULL
  • Field

PostCommentReport (Untitled8)

  • id (Key) — Integer — Primary key — NOT NULL
  • post_commend_id (Key2) — Integer — Foreign key → PostComment.id — NOT NULL
  • member_id (Key3) — Integer — Foreign key → Member.id — NOT NULL
  • id (Key22) — Integer — Foreign key → Member.streamer_id — NOT NULL

PostRecommend (Untitled3)

  • id (Key) — Integer — Primary key — NOT NULL
  • member_id (Key2) — Integer — Foreign key → Member.id — NOT NULL
  • post_id (Key3) — Integer — Foreign key → Post.id — NOT NULL
  • id (Key22) — Integer — Foreign key → Member.streamer_id — NOT NULL

PostReport (Untitled7)

  • id (Key) — Integer — Primary key — NOT NULL
  • post_id (Key2) — Integer — Foreign key → Post.id — NOT NULL
  • member_id (Key3) — Integer — Foreign key → Member.id — NOT NULL

Season (Untitled17)

  • id (Key) — Integer — Primary key — NOT NULL

Species (Untitled13)

  • id (Key) — Integer — Primary key — NOT NULL

Story (Untitled15)

  • id (Key) — Integer — Primary key — NOT NULL
  • season_id (Key2) — Integer — Foreign key → Season.id — NOT NULL
  • story_category_id (Key3) — Integer — Foreign key → StoryCategory.id — NOT NULL

StoryCategory (Untitled18)

  • id (Key) — Integer — Primary key — NOT NULL

Streamer (Untitled14)

  • id (Key) — Integer — Primary key — NOT NULL

StreamerWatched (Untitled20)

  • id (Key3) — Integer — Primary key — NOT NULL
  • streamer_id (Key) — Integer — Foreign key → Streamer.id — NOT NULL
  • story_id (Key2) — Integer — Foreign key → Story.id — NOT NULL

SupportRequest (Untitled9)

  • id (Key) — Integer — Primary key — NOT NULL
  • member_id (Key2) — Integer — Foreign key → Member.id — NOT NULL

Watched (Untitled19)

  • id (Key) — Integer — Primary key — NOT NULL
  • member_id (Key2) — Integer — Foreign key → Member.id — NOT NULL
  • story_id (Key3) — Integer — Foreign key → Story.id — NOT NULL