감정 일기

테이블 (7)

Comment

  • Key (idx) — SERIAL — 기본 키 — NOT NULL
  • Field (content) — VARCHAR
  • Key (post_idx) — SERIAL — 외래 키 → Post.Key — NOT NULL
  • Key (user_idx) — SERIAL — 외래 키 → User.Key — NOT NULL
  • Field (created_at) — TIMESTAMP

Diary

  • Key (idx) — SERIAL — 기본 키 — NOT NULL
  • Field (title) — VARCHAR
  • Field2 (content) — TEXT
  • Key (user_idx) — SERIAL — 외래 키 → User.Key — NOT NULL
  • Key (emtion_idx) — SERIAL — 외래 키 → Emotion.Key — NOT NULL
  • Field (date) — date

Diary-tag relation

  • Key (name) — VARCHAR — 기본 키 — NOT NULL
  • Key (diary_idx) — SERIAL — 외래 키 → Diary.Key — NOT NULL

Emotion

  • Key (idx) — SERIAL — 기본 키 — NOT NULL
  • Field (name) — VARCHAR

Post

  • Key (idx) — SERIAL — 기본 키 — NOT NULL
  • Field (title) — VARCHAR
  • Field (content) — TEXT
  • Key (emtion_idx) — SERIAL — 외래 키 → Emotion.Key — NOT NULL
  • Key (user_idx) — SERIAL — 외래 키 → User.Key — NOT NULL
  • Field (created_at) — timestamp

Post_Likes

  • Key (user_idx) — SERIAL — 외래 키 → User.Key — NOT NULL
  • Key (post_idx) — SERIAL — 외래 키 → Post.Key — NOT NULL

User

  • Key (idx) — SERIAL — 기본 키 — NOT NULL
  • Field (email) — VARCHAR
  • Field (nickname) — VARCHAR
  • Field (password) — VARCHAR
  • Field (role) — enum(int) — {0: "general", 1: "manager"}