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)