Boards

Tables (5)

Boards

  • id — uuid — Primary key — NOT NULL
  • title — string
  • content — string
  • author_id — string
  • createdAt — Date
  • updatedAt — Date
  • deletedAt — Date
  • likeCounts — Int
  • commentCounts — Int
  • id (id2) — uuid — Foreign key → Users.id — NOT NULL

Comments

  • id — uuid — Primary key — NOT NULL
  • content — string
  • author_id — string
  • board_id — string
  • createdAt — Date
  • id (id2) — uuid — Foreign key → Boards.id — NOT NULL

Images

  • id — uuid — Primary key — NOT NULL
  • board_id — string
  • imageUrl — string
  • createdAt — Date
  • id (id2) — uuid — Foreign key → Boards.id — NOT NULL

Likes

  • id — uuid — Primary key — NOT NULL
  • user_id — string
  • board_id — string
  • createdAt — Date
  • id (id2) — uuid — Foreign key → Users.id — NOT NULL
  • id (id3) — uuid — Foreign key → Boards.id — NOT NULL

Users

  • id — uuid — Primary key — NOT NULL
  • email — string
  • password — string
  • nickname — string
  • createdAt — Date
  • isSocial — boolean
  • provider — string