Highlighters
테이블 (10)
FEED-TAG 연결
- Key (tag_id) — INT — 외래 키 → TAG.Key — NOT NULL
- Key (feed_id) — INT — 외래 키 → Untitled.Key — NOT NULL
GROUP
- Key (group_id) — INT — 기본 키 — NOT NULL
- Field (name) — CHAR(20) — NOT NULL
- Field2 (group_code) — CHAR(20) — NOT NULL — UNIQUE
OG
- Key (og_id) — INT — 기본 키 — NOT NULL
- Field (title) — VARCHAR(191)
- Field (image) — TEXT
- Field (description) — VARCHAR(191)
TAG
- Key (tag_id) — INT — 기본 키 — NOT NULL
- Field (tag_name) — CHAR(20) — NOT NULL
- Key (group_id) — INT — 외래 키 → GROUP.Key — NOT NULL — onDelete('Cascade')
Untitled (USER)
- Key (email) — CHAR(50) — 기본 키 — NOT NULL
- Field2 (nickname) — CHAR(20) — NOT NULL
- Field (image) — TEXT
- Field3 (password) — VARCHAR(191) — NOT NULL
- Field4 (new_noti) — BOOLEAN — default('false')
- Key (group_id) — INT — 외래 키 → GROUP.Key — NOT NULL
Untitled (FEED)
- Key (feed_id) — INT — 기본 키 — NOT NULL
- Field (title) — CAHR(100) — NOT NULL
- Field2 (created_At) — DATETIME(3) — NOT NULL — default('now')
- Field (updated_At) — DATETIME(3) — NOT NULL — default('now')
- Field (url) — VARCHAR(191) — NOT NULL
- Field (summary) — TEXT
- Key (email) — CHAR(50) — 외래 키 → Untitled.Key — NOT NULL
- Key (group_id) — INT — 외래 키 → GROUP.Key — NOT NULL — onDelete('Cascade')
- Key (og_id) — INT — 외래 키 → OG.Key — NOT NULL
Untitled (BOOKMARK)
- Key (bookmark_id) — INT — 기본 키 — NOT NULL
- Field (created_At) — DATETIME(3) — NOT NULL — default('now')
- Key (email) — CHAR(50) — 외래 키 → Untitled.Key — NOT NULL — onDelete('Cascade')
- Key (feed_id) — INT — 외래 키 → Untitled.Key — NOT NULL — onDelete('Cascade')
Untitled (COMMENT)
- Key (comment_id) — INT — 기본 키 — NOT NULL
- Field (content) — VARCHAR(191) — NOT NULL
- Field (created_At) — DATETIME(3) — NOT NULL — default('now')
- Key (feed_id) — INT — 외래 키 → Untitled.Key — NOT NULL — onDelete('Cascade')
- Key (email) — CHAR(50) — 외래 키 → Untitled.Key — NOT NULL
Untitled (HIGHLIGHT)
- Key (highlight_id) — INT — 기본 키 — NOT NULL
- Field (selection) — JSON — NOT NULL
- Field (contents) — TEXT — NOT NULL
- Field (type) — INT — NOT NULL
- Field (color) — CHAR(10)
- Field (created_At) — DATETIME(3) — NOT NULL — default('now')
- Key (feed_id) — INT — 외래 키 → Untitled.Key — NOT NULL — onDelete('Cascade')
- Key (group_id) — INT — 외래 키 → GROUP.Key — NOT NULL
- Key (email) — CHAR(50) — 외래 키 → Untitled.Key — NOT NULL
Untitled (NOTI)
- Key (noti_id) — INT — 기본 키 — NOT NULL
- Field (content) — VARCHAR(191) — NOT NULL
- Field (isRead) — BOOLEAN — NOT NULL — default('false')
- Field (createdAt) — DATETIME(3) — NOT NULL — default('now')
- Key (feed_id) — INT — 외래 키 → Untitled.Key — NOT NULL — onDelete('Cascade')
- Key (email1) — CHAR(50) — 외래 키 → Untitled.Key — NOT NULL
- Key (email2) — CHAR(50) — 외래 키 → Untitled.Key — NOT NULL