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