erd

Tables (3)

Category (Untitled3)

  • id (Key) — integer — Primary key — NOT NULL
  • Field2 — varchar(100)

Message (Untitled2)

  • id (Key) — integer — Primary key — NOT NULL
  • receiver_id (Key2) — integer — Foreign key → User.id — NOT NULL
  • categroy_id (Key3) — integer — Foreign key → Category.id — NOT NULL
  • title (Field) — varchar(100)
  • artist (Field3) — varchar(100)
  • contents (Field2) — varchar(500)
  • created_at (Field5) — timestamp
  • is_opened (Field4) — bool

User (Untitled)

  • id (Key) — integer — Primary key — NOT NULL
  • nickname (Field) — varchar(100)