thesaver
Tables (11)
alarms (알림)
- id — int(11) — Primary key — NOT NULL
- UserId — int(11) — Foreign key → subscribers.id — NOT NULL
- ArticleId — int(11) — Foreign key → articles.id — NOT NULL
- deleted — tinyint(1) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
articles
- id — int(11) — Primary key — NOT NULL
- headline — varchar(255) — NOT NULL
- category — int(11) — NOT NULL
- image — varchar(255)
- imageDesc — varchar(255) — NOT NULL
- imageFrom — varchar(255) — NOT NULL
- briefing — longtext — NOT NULL
- am7 — tinyint(1) — NOT NULL
- pm7 — tinyint(1) — NOT NULL
- status — int(11) — NOT NULL
- AuthorId — int(11) — Foreign key → authors.id — NOT NULL
- publishedAt — datetime
- paragraphs — longtext — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
authors
- id — int(11) — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- code — int(11) — NOT NULL
- position — int(11)
- category — int(11)
- contact — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- photo — varchar(255) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
bookmarks (북마크)
- id — int(11) — Primary key — NOT NULL
- UserId — int(11) — Foreign key → subscribers.id — NOT NULL
- ArticleId — int(11) — Foreign key → articles.id — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
invitations
- id — int(11) — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- state — int(11)
- code — int(11)
- category — int(11)
- position — int(11)
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
likes (좋아요)
- id — int(11) — Primary key — NOT NULL
- UserId — int(11) — Foreign key → subscribers.id — NOT NULL
- ArticleId (articleId) — int(11) — Foreign key → articles.id — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
sequelizemeta
- name — varchar(255) — Primary key — NOT NULL
subscribers (구독자)
- id — int(11) — Primary key — NOT NULL
- email — varchar(255)
- name — varchar(255)
- password — varchar(255)
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- deletedAt — int(11) — NOT NULL
- followingCategories — varchar(255)
- alarmStatus — int(11) — NOT NULL
todayarticles
- id — int(11) — Primary key — NOT NULL
- ArticleId — int(11) — Foreign key → articles.id — NOT NULL
- date — datetime
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
todaywords
- id — int(11) — Primary key — NOT NULL
- WordId — int(11) — Foreign key → words.id — NOT NULL
- date — datetime
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
words
- id — int(11) — Primary key — NOT NULL
- word — varchar(255) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- AuthorId — int(11) — Foreign key → authors.id — NOT NULL
- status — int(11) — NOT NULL