NewFeed

Tables (4)

Board

  • id (PK) — Primary key — NOT NULL
  • user_id (FK) — Foreign key → User.id — NOT NULL
  • title (Field)
  • contents (Field2)
  • image (Field3)
  • comments (Field4)
  • created_at (Field5)
  • modified_at (Field6)

Comment

  • id (PK) — Primary key — NOT NULL
  • board_id (FK) — Foreign key → Board.id — NOT NULL
  • user_id (FK2) — Foreign key → Board.user_id — NOT NULL
  • contents (Field)
  • created_at (Field2)
  • modified_at (Field3)

Follows

  • id (Key) — Primary key — NOT NULL
  • follower (FK) — Foreign key → User.id — NOT NULL
  • following (Field)

User

  • id (PK) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • name (Field3)
  • image (Field4)
  • created_at (Field5)
  • modified_at (Field6)
  • is_delete (Field7)