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