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