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