술이술술

테이블 (4)

Admin

  • Id — Int — 외래 키 → User.Key — NOT NULL

Category

  • Key (categoryId) — Int — 기본 키 — NOT NULL
  • Field (category) — String

Post

  • Key (postId) — Int — 기본 키 — NOT NULL
  • Id (userId) — Int — 외래 키 → User.Key — NOT NULL
  • Key (categoryId) — Int — 외래 키 → Category.Key — NOT NULL
  • Field (title) — String
  • Field (description) — String
  • Field (createdAt) — Date
  • Field (updatedAt) — Date

User

  • Key (Id) — Int — 기본 키 — NOT NULL
  • Field (name) — String
  • Field3 (studentId) — Int
  • Field (password) — String
  • Field (email) — String
  • Field (createdAt) — Date
  • Field (updatedAt) — Date
  • Field (isValid) — Boolean
  • Field (isManaged) — Boolean