vias production

Tables (12)

Critique (Untitled7)

  • Id (Key) — Primary key — NOT NULL
  • keyword_Id (Key2) — Foreign key → Keyword.Id — NOT NULL
  • title (Field)
  • content (Field2)
  • url (Field3)
  • hash (Field4)
  • source (Field5)
  • s3_url (Field6)

Keyword (Untitled2)

  • Id (Key) — Primary key — NOT NULL
  • title (Field3)
  • cursor (Field)

KeywordStatus (Untitled10)

  • Id (Key) — Primary key — NOT NULL
  • keyword_Id (Key2) — Foreign key → Keyword.Id — NOT NULL
  • news_cursor_id (Field)
  • critique_cursor_id (Field2)
  • opinion_batch_cursor_id (Field3)

Member (Untitled)

  • Id (Key) — Primary key — NOT NULL
  • email (Field)
  • nickname (Field2)

News (Untitled3)

  • Id (Key) — Primary key — NOT NULL
  • keyword_Id (Key2) — Foreign key → Keyword.Id — NOT NULL
  • title (Field)
  • content (Field2)
  • url (Field3)
  • hash (Field4)
  • source (Field5)
  • s3_url (Field6)

Opinion (Untitled4)

  • Id (Key) — Primary key — NOT NULL
  • keyword_Id (Key2) — Foreign key → Keyword.Id — NOT NULL
  • content (Field2)
  • author (Field)
  • hash (Field3)
  • opinion_Id (Key3) — Foreign key → Opinion.Id — NOT NULL
  • keyword_Id (Key22) — Foreign key → Opinion.keyword_Id — NOT NULL

OpinionBatch (Untitled12)

  • Id (Key) — Primary key — NOT NULL
  • keyword_Id (Key2) — Foreign key → Keyword.Id — NOT NULL
  • s3_url (Field)

Report (Untitled5)

  • Id (Key) — Primary key — NOT NULL
  • keyword_Id (Key2) — Foreign key → Keyword.Id — NOT NULL
  • view_count (Field2)
  • content (Filed3) — BLOB (JSON)
  • scrap_count (Field)

ReportRevision (Untitled9)

  • Id (Key) — Primary key — NOT NULL
  • report_Id (Key2) — Foreign key → Report.Id — NOT NULL
  • keyword_Id (Key22) — Foreign key → Report.keyword_Id — NOT NULL
  • version (Field)
  • content (Field2)

Scrap (Untitled11)

  • Id (Key) — Primary key — NOT NULL
  • report_Id (Key2) — Foreign key → Report.Id — NOT NULL
  • keyword_Id (Key22) — Foreign key → Report.keyword_Id — NOT NULL
  • user_Id (Key3) — Foreign key → Member.Id — NOT NULL
  • Field
  • Field2

UserKeyword (Untitled6)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → Member.Id — NOT NULL
  • keyword_id (Key3) — Foreign key → Keyword.Id — NOT NULL

comment (Untitled8)

  • Id (Key) — Primary key — NOT NULL
  • report_Id (Key3) — Foreign key → Report.Id — NOT NULL
  • keyword_Id (Key22) — Foreign key → Report.keyword_Id — NOT NULL
  • member_Id (Key4) — Foreign key → Member.Id — NOT NULL
  • content (Field)
  • like (Field2)
  • comment_Id (Key2) — Foreign key → comment.Id — NOT NULL
  • Id (Key32) — Foreign key → comment.report_Id — NOT NULL
  • keyword_Id (Key222) — Foreign key → comment.keyword_Id — NOT NULL
  • Id (Key42) — Foreign key → comment.member_Id — NOT NULL