Pumassi

Tables (5)

Asset

  • id — String — Primary key — NOT NULL
  • url — String
  • postId — String — Foreign key → Post.id — NOT NULL
  • createdAt — Timestamp
  • deletedAt — Timestamp

Message

  • id — Stirng — Primary key — NOT NULL
  • message — String
  • roomId — String — Foreign key → Room.id — NOT NULL
  • writerId — String — Foreign key → User.id — NOT NULL
  • createdAt — Timestamp
  • deletedAt — Timestmap

Post

  • id — String — Primary key — NOT NULL
  • title — String
  • content — String
  • reward — String
  • host — String — Foreign key → User.id — NOT NULL
  • createdAt — Timestamp
  • updatedAt — Timestamp
  • deletedAt — Timestamp

Room

  • id — String — Primary key — NOT NULL
  • createdAt — Timestamp
  • deletedAt — Timestamp
  • member — String — Foreign key → User.id — NOT NULL

User

  • id — String — Primary key — NOT NULL
  • email — String
  • name — String
  • password — String
  • entranceYear — Number
  • grade — Number
  • createdAt — Timestamp
  • updatedAt — Timestamp
  • deletedAt — Timestamp