LeejoeDdo
Tables (3)
Post (Untitled2)
- Id (Key) — int — Primary key — NOT NULL
- Id (Key2) — Foreign key → User.Id — NOT NULL
- title (Field) — varchar(25)
- text (Field2) — LongText — 타입 추후 고려
- created_at (Field3) — timestamp — NOT NULL — 추후 옵션 고려
- updated_at (Field4) — timestamp
Post_Like (Untitled3)
- Key — Primary key — NOT NULL
User (Untitled)
- Id (Key) — Primary key — NOT NULL
- Email (Field) — varchar(30) — NOT NULL
- password (Field2) — varchar(30) — NOT NULL
- nickname (Field3) — varchar(30) — NOT NULL
- Role (Field4) — enum — NOT NULL — 관리자, 유저 구분
- Field5